Table Detail Report
NURSING_ENCNTR_SCRATCHPAD
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | NURSING_ENCNTR_SCRATCHPAD |
Definition: | Maintains scratchpad data for a given time period of a solution |
Table Type: | ACTIVITY |
Column Detail - NURSING_ENCNTR_SCRATCHPAD
Column Name | Type | Null? | Definition |
---|---|---|---|
ENCNTR_ID | DOUBLE | N | The encounter id that relates to the scratchpad information being stored |
LAST_UPDT_DT_TM | DATETIME | N | The date and time the scratchpad information was last updated |
LONG_BLOB_ID | DOUBLE | N | Identifier that relates NURSING_ENCNTR_SCRATCHPAD rows to LONG_BLOB table (this field will become logically obsolete after addition of field SCRATCHPAD_BLOB to the table) |
NURSING_ENCNTR_SCRATCHPAD_ID | DOUBLE | N | PRIMARY KEY |
PRSNL_ID | DOUBLE | N | The id of the person responsible for documenting the scratchpad information |
SCRATCHPAD_TYPE_CD | DOUBLE | N | ** OBSOLETE ** - this column becomes OBSOLETE after new column SCRATCHPAD_TYPE_NAME, is added to the table.Categorizes the scratchpad into a logical group or type. Example is MEDADMINCHRT |
SCRATCHPAD_TYPE_NAME | VARCHAR(50) | Y | Indicates the type of scratchpad entry in the NURSING_ENCTR_SCRATCHPAD table |
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 - NURSING_ENCNTR_SCRATCHPAD
Child Column in NURSING_ENCNTR_SCRATCHPAD(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
LONG_BLOB_ID | LONG_BLOB | LONG_BLOB_ID | |
PRSNL_ID | PRSNL | PERSON_ID |
Parent Column in NURSING_ENCNTR_SCRATCHPAD (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | NURSING_ENCNTR_SCRATCHPAD_ID | NC_CHARTED_VIEW | SCRATCHPAD_DRAFT_ID |
NURSING_TRANSACTION_INFO
Column Section | Top of Page |
Table-level Detail
Description: | Nursing Transaction Information |
Definition: | Keeps track of the transaction IDs tht have been or are in the process of being completed. |
Table Type: | ACTIVITY |
Column Detail - NURSING_TRANSACTION_INFO
Column Name | Type | Null? | Definition |
---|---|---|---|
GROUP_NURSING_TRANSACTION_ID | DOUBLE | N | Parent Transaction ID that groups together all attempts to process a given set of data. Each submittal of the same data will window up with the same parent ID. |
NURSING_TRANSACTION_INFO_ID | DOUBLE | N | Transaction ID used to track a particular transaction already being worked on or completed. This is a unique field. |
PRIMARY_TRANSACTION_IND | DOUBLE | N | Specifies if this row is the one where the transaction was processed. The other rows with the same parent_id with an indicator of 0 provide an audit. |
TRANSACTION_DT_TM | DATETIME | N | Date and time when the transaction ID started being processed. |
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. |
NURSING_USAGE_DATA
Column Section | Top of Page |
Table-level Detail
Description: | NURSING USAGE DATA |
Definition: | Maintains usage data for a given time period of a solution |
Table Type: | ACTIVITY |
Column Detail - NURSING_USAGE_DATA
Column Name | Type | Null? | Definition |
---|---|---|---|
AUDIT_SOLUTION_CD | DOUBLE | N | Specifies which solution the audit information applies to |
NURSING_USAGE_DATA_ID | DOUBLE | N | PRIMARY KEY |
PERIOD_END_DT_TM | DATETIME | N | The end date/time of the period for which the number of users are being tracked. |
PERIOD_START_DT_TM | DATETIME | N | The start date/time of the period for which the number of users are being tracked. |
SERVER_NAME | VARCHAR(100) | Y | The name of the server that the user last accessed. May be NULL for some solutions. |
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. |
USER_COUNT | DOUBLE | N | The number of users used the given solution during the particular time frame |
NURSING_USER_ACCESS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | NURSING USER ACCESS |
Definition: | Keeps track of the last time a user performed a transaction within a given application |
Table Type: | ACTIVITY |
Column Detail - NURSING_USER_ACCESS
Column Name | Type | Null? | Definition |
---|---|---|---|
AUDIT_SOLUTION_CD | DOUBLE | N | Specifies which solution the audit information applies to |
LAST_ACCESS_DT_TM | DATETIME | N | The date/time that the user last accessed the specific solution |
NURSING_USER_ACCESS_ID | DOUBLE | N | PRIMARY KEY |
SERVER_NAME | VARCHAR(100) | Y | The name of the server that the user last accessed. May be NULL for some solutions. |
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. |
USER_ID | DOUBLE | N | The ID of the user related to the record of when they last used the solution. |
Relationship Detail - NURSING_USER_ACCESS
Child Column in NURSING_USER_ACCESS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | USER_ID | PRSNL | PERSON_ID |
OCS_ATTR_XCPTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Order Catalog Synonym Attribute Exception |
Definition: | Used to flex synonym attributes by other entities. For instance, flexing the witness by location indicator by location. |
Table Type: | REFERENCE |
Column Detail - OCS_ATTR_XCPTN
Column Name | Type | Null? | Definition |
---|---|---|---|
FACILITY_CD | DOUBLE | N | This is the facility code that the object is flexed by. |
FLEX_NBR_VALUE | DOUBLE | Y | This is the flexed value if the value is numeric. |
FLEX_OBJ_CD | DOUBLE | N | This is the code of the object by which the item will flex. |
FLEX_OBJ_TYPE_CD | DOUBLE | N | This indicates the data type for the value - whether numeric or string. |
FLEX_STR_VALUE_TXT | VARCHAR(100) | Y | This is the string value if the value is alphanumeric. |
LOGICAL_DOMAIN_ID | DOUBLE | Y | The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table. |
OCS_ATTR_XCPTN_GROUP_ID | DOUBLE | N | This is used to group rows into a combination. |
OCS_ATTR_XCPTN_ID | DOUBLE | N | This is the generated key for this flex-by object. |
OCS_COL_NAME_CD | DOUBLE | N | This is the column name in the ORDER CATALOG SYNONYM table that is being flexed. |
SYNONYM_ID | DOUBLE | N | This is the key to the ORDER CATALOG SYNONYM table for the synonym that is being flexed. |
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 - OCS_ATTR_XCPTN
Child Column in OCS_ATTR_XCPTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LOGICAL_DOMAIN_ID | LOGICAL_DOMAIN | LOGICAL_DOMAIN_ID |
SYNONYM_ID | ORDER_CATALOG_SYNONYM | SYNONYM_ID |