Table Detail Report

PAT_ED_SHORTCUT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Patient Education Shortcut
Definition: The table will store the shortcut names of each relation id (instruction)
Table Type: REFERENCE





Column Detail - PAT_ED_SHORTCUT


Column Name Type Null? Definition
PAT_ED_RELTN_ID DOUBLE N Relation Id that relates to the pat_ed_reltn table on which instruction this row is.
PAT_ED_SHORTCUT_ID DOUBLE N Primary key
SHORTCUT_NAME VARCHAR(1000) Y This is storing a shortcut name of an instruction that is given by the content domain.
SHORTCUT_NAME_KEY VARCHAR(1000) N Displays the shortcut name with only alpha characters and all uppercase
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 - PAT_ED_SHORTCUT


Child Column in PAT_ED_SHORTCUT(FK) Parent Table Name Parent Column Name
Parents: PAT_ED_RELTN_ID PAT_ED_RELTN PAT_ED_RELTN_ID


PRESENTING_PROBLEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: presenting_problem
Definition: Reference Data to store the Presenting Problem Content from Lynx
Table Type: REFERENCE





Column Detail - PRESENTING_PROBLEM


Column Name Type Null? Definition
AGE_MASK_VAL DOUBLE N Masked age - age is split into 10 age ranges
GENDER_MASK_VAL DOUBLE N Masked gender values
KEY_VAL DOUBLE N Unique presenting problem key value
PRESENTING_PROBLEM_ID DOUBLE N Unique generated number that identifies a single row on the presenting_problem table.
PROBLEM_HINTS VARCHAR(1000) N Gives additional information concerning the presenting problem
PROBLEM_NAME VARCHAR(255) N Name of the presenting problem
PROBLEM_NAME_KEY VARCHAR(255) N Name key of the presenting problem
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.
VALUE_TYPE_FLAG DOUBLE N Determines type of presenting problem [facility or clinic]



Relationship Detail - PRESENTING_PROBLEM




Parent Column in PRESENTING_PROBLEM (PK) Child Table Name Child Column Name
Children: PRESENTING_PROBLEM_ID PRESENTING_PROBLEM_RELTN PRESENTING_PROBLEM_ID


PRESENTING_PROBLEM_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: presenting_problem_relationship
Definition: Reference Data that associates a unique cerner value to a presenting problem key value
Table Type: REFERENCE





Column Detail - PRESENTING_PROBLEM_RELTN


Column Name Type Null? Definition
KEY_STRING VARCHAR(255) Y Associated unique Cerner value that relates to the presenting problem identifier
PRESENTING_PROBLEM_ID DOUBLE N Unique generated number that identifies a single row on the presenting_problem table
PRESENTING_PROBLEM_RELTN_ID DOUBLE N Unique generated number that identifies a single row on the presenting_problem_reltn 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 - PRESENTING_PROBLEM_RELTN


Child Column in PRESENTING_PROBLEM_RELTN(FK) Parent Table Name Parent Column Name
Parents: PRESENTING_PROBLEM_ID PRESENTING_PROBLEM PRESENTING_PROBLEM_ID


TRACKING_AUDIT



Column Section Relationship Section Top of Page


Table-level Detail

Description: TRACKING AUDIT
Definition: Store an audit record of events that occur in tracking.
Table Type: ACTIVITY





Column Detail - TRACKING_AUDIT


Column Name Type Null? Definition
AUDIT_TYPE_CD DOUBLE N Audit Type - from code set 4002045.
ENCNTR_ID DOUBLE N Encntr_id from the encounter table.
TRACKING_AUDIT_ID DOUBLE N Primary Key for the tracking_audit table.
TRACKING_GROUP_CD DOUBLE N Code-Value from code-set 16370.
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 - TRACKING_AUDIT


Child Column in TRACKING_AUDIT(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID




Parent Column in TRACKING_AUDIT (PK) Child Table Name Child Column Name
Children: TRACKING_AUDIT_ID TRACKING_AUDIT_ELEMENT TRACKING_AUDIT_ID


TRACKING_AUDIT_ELEMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: TRACKING AUDIT ELEMENT
Definition: Store elements of information about a tracking audit event.
Table Type: ACTIVITY





Column Detail - TRACKING_AUDIT_ELEMENT


Column Name Type Null? Definition
AUDIT_DT_TM DATETIME Y Date/Time value to be audited.
AUDIT_ELEMENT_NAME VARCHAR(255) N The name of the element being audited.
AUDIT_ELEMENT_STRING VARCHAR(255) N The string value of the Element being audited.
AUDIT_ELEMENT_TXT VARCHAR(255) Y Sometimes the value is a double, sometimes it's a string. This column stores the string value.
AUDIT_FLAG DOUBLE Y Audit Flag - 0 = Incomplete, 1 = Complete.NULL implies no value assigned.
AUDIT_STRING VARCHAR(255) Y String value to be audited.
AUDIT_VALUE DOUBLE Y Numeric value to be audited.
TRACKING_AUDIT_ELEMENT_ID DOUBLE N Primary Key for the tracking_audit_element table.
TRACKING_AUDIT_ID DOUBLE N Foreign Key to the tracking_audit 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 - TRACKING_AUDIT_ELEMENT


Child Column in TRACKING_AUDIT_ELEMENT(FK) Parent Table Name Parent Column Name
Parents: TRACKING_AUDIT_ID TRACKING_AUDIT TRACKING_AUDIT_ID