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 |