SCRATCHPAD_ITEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scratchpad Item
Definition: Contains scratchpad items associated to a patient/user/concept centric scratchpad session.
Table Type: ACTIVITY





Column Detail - SCRATCHPAD_ITEM


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ITEM_CONCEPT_NAME VARCHAR(100) Y The concept used to identify the scratchpad item. For example, if the item is an order, the item_concept could be something like ""ORDER"" with a corresponding item_concept_id with the order_id.
ITEM_CONCEPT_VALUE DOUBLE Y The numeric concept identifier used to identify the scratchpad item. For example, if the item is an order, the item_concept could be something like ""ORDER"" with a corresponding item_concept_id with the order_id.
LAST_ITEM_SEQ DOUBLE N The last scratchpad item sequence. Used to identify the latest sequence used to add either label or component information.
SCRATCHPAD_ITEM_ID DOUBLE N Unique generated number that identifies a single row on the scratchpad_item table.
SCRATCHPAD_SESSION_ID DOUBLE N The scratchpad session identifier to which this item is associated.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.
VERSION_NBR DOUBLE N The scratchpad item version. This is used to ensure modifications made to a scratchpad item are performed against the latest version of the scratchpad item.



Relationship Detail - SCRATCHPAD_ITEM


Child Column in SCRATCHPAD_ITEM(FK) Parent Table Name Parent Column Name
Parents: SCRATCHPAD_SESSION_ID SCRATCHPAD_SESSION SCRATCHPAD_SESSION_ID




Parent Column in SCRATCHPAD_ITEM (PK) Child Table Name Child Column Name
Children: SCRATCHPAD_ITEM_ID SCRATCHPAD_ITEM_COMPONENT SCRATCHPAD_ITEM_ID
SCRATCHPAD_ITEM_LABEL SCRATCHPAD_ITEM_ID


SCRATCHPAD_ITEM_COMPONENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scratchpad Item Component
Definition: Contains the component data elements associated to a scratchpad item.
Table Type: ACTIVITY





Column Detail - SCRATCHPAD_ITEM_COMPONENT


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
DATA_BLOB LONGBLOB Y The raw data stored to the scratchpad item component.
DATA_BLOB_SIZE DOUBLE Y Used to store the size of the blob column.
DATA_CONCEPT_NAME VARCHAR(100) N The concept used to identify the data that is stored within the data_blob.
DELETE_IND DOUBLE N Indicates if the scratchpad item component has been deleted.
ITEM_SEQ DOUBLE N The scratchpad item sequence. Identifies the order in which components were added to this table.
SCRATCHPAD_ITEM_COMPONENT_ID DOUBLE N Unique generated number that identifies a single row on the scratchpad_item_component table.
SCRATCHPAD_ITEM_ID DOUBLE N The scratchpad item identifier to which this component is associated.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - SCRATCHPAD_ITEM_COMPONENT


Child Column in SCRATCHPAD_ITEM_COMPONENT(FK) Parent Table Name Parent Column Name
Parents: SCRATCHPAD_ITEM_ID SCRATCHPAD_ITEM SCRATCHPAD_ITEM_ID


SCRATCHPAD_ITEM_LABEL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scratchpad Item Label
Definition: Contains the labels associated to a scratchpad item.
Table Type: ACTIVITY





Column Detail - SCRATCHPAD_ITEM_LABEL


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
DELETE_IND DOUBLE N Indicates if the scratchpad item label row has been deleted.
ITEM_SEQ DOUBLE N The scratchpad item sequence. Identifies the order in which labels were added to this table.
LABEL_NAME VARCHAR(100) N The string label associated to a scratchpad item. The label can be used to provide information about a scratchpad item.
SCRATCHPAD_ITEM_ID DOUBLE N The scratchpad item identifier to which this label is associated.
SCRATCHPAD_ITEM_LABEL_ID DOUBLE N Unique generated number that identifies a single row on the scratchpad_item_label table.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - SCRATCHPAD_ITEM_LABEL


Child Column in SCRATCHPAD_ITEM_LABEL(FK) Parent Table Name Parent Column Name
Parents: SCRATCHPAD_ITEM_ID SCRATCHPAD_ITEM SCRATCHPAD_ITEM_ID


SCRATCHPAD_SESSION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Scratchpad Session
Definition: Contains information for a scratchpad session. Scratchpad session is used as a temporary data storage for information that is being prepared to commit to Millennium.
Table Type: ACTIVITY





Column Detail - SCRATCHPAD_SESSION


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
EXPIRE_DT_TM DATETIME N The date/time as which point this scratchpad session expires.
PERSON_ID DOUBLE N The id of the patient to which this scratchpad session is associated.
PRSNL_ID DOUBLE N The id of the personnel to which this scratchpad session is associated.
SCRATCHPAD_CONCEPT_NAME VARCHAR(100) N The concept used to identify the scratchpad session.
SCRATCHPAD_SESSION_ID DOUBLE N Unique generated number that identifies a single row on the scratchpad_session table.
TIMEOUT_IN_MINS DOUBLE N The number of minutes the session can be without modification before the session expires.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - SCRATCHPAD_SESSION


Child Column in SCRATCHPAD_SESSION(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PERSON PERSON_ID
PRSNL_ID PRSNL PERSON_ID




Parent Column in SCRATCHPAD_SESSION (PK) Child Table Name Child Column Name
Children: SCRATCHPAD_SESSION_ID SCRATCHPAD_ITEM SCRATCHPAD_SESSION_ID