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