Table Detail Report
TRACKING_CHECKIN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Tracking Checkin Table |
Definition: | Tracking table used to log when a tracking item is checked into a tracking group. Any tracking group specific fields are also strored in this table. |
Table Type: | ACTIVITY |
Column Detail - TRACKING_CHECKIN
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | 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. |
ACUITY_LEVEL_ID | DOUBLE | N | Patient Acuity Level used to identify how serious the injuries and how soon treatment must be provided. |
CHECKIN_DT_TM | DATETIME | Y | Date and time the tracking item was checked into the tracking group. |
CHECKIN_ID | DOUBLE | N | ID of the person who checked the tracking item into the tracking group. |
CHECKOUT_DISPOSITION_CD | DOUBLE | N | Disposition at checkout time |
CHECKOUT_DT_TM | DATETIME | Y | Date and time the tracking item was checked out of the tracking group. |
CHECKOUT_ID | DOUBLE | N | ID of the person who checked the tracking item out of the tracking group. |
DEPART_ACUITY_LEVEL_ID | DOUBLE | N | Final acuity level assigned at time of departure. |
DOCUMENT_STATUS_CD | DOUBLE | N | Tracking Document StatusColumn |
FAMILY_PRESENT_CD | DOUBLE | N | Family Present Code used to identify if the family of the patient is here or on their way to see the patient. |
PARENT_ENTITY_ID | DOUBLE | N | Table identifier for the Parent Entity Name table.Column |
PARENT_ENTITY_NAME | VARCHAR(20) | Y | Table name identifier for the Parent Entity Id.Column |
PAT_ED_ACKNOWLEDGED_IND | DOUBLE | Y | Indicator that the patient acknowledged understanding the instructions during th |
PAT_ED_ACKNOWLEDGED_USER_ID | DOUBLE | N | This is the user_id of the PRSNL who last logged the Patient Acknowledged Indicator User IND. |
PRIMARY_DOC_ID | DOUBLE | N | ID of the Primary Physician who is to see the Patient. |
PRIMARY_NURSE_ID | DOUBLE | N | ID of the Primary Nurse who is to see the Patient. |
RANK_SEQUENCE | DOUBLE | Y | Rank sequence used to identify which patient is to be seen next. |
REACTIVATE_USER_ID | DOUBLE | N | The person id of the user that reactivated a patientColumn |
REACTIVATION_DT_TM | DATETIME | Y | Date and time when a patient was reactivatedColumn |
REGISTRATION_STATUS_ID | DOUBLE | N | Registration status code used to identify the status of the patient registration. |
SECONDARY_DOC_ID | DOUBLE | N | ID of the Secondary Physician who is to see the Patient. |
SECONDARY_NURSE_ID | DOUBLE | N | ID of the Secondary Nurse who is to see the Patient. |
SPECIALTY_ID | DOUBLE | N | Specialty code used to identify and categorize patient problems. |
TEAM_ID | DOUBLE | N | Team code of which team is assigned to attend to the patient. |
TRACKING_CHECKIN_ID | DOUBLE | N | Tracking Checkin Identifier |
TRACKING_EVENT_TYPE_CD | DOUBLE | N | Tracking Event Type Code |
TRACKING_GROUP_CD | DOUBLE | N | Tracking Group Code used to identify which tracking group this patient is currently checked into. |
TRACKING_ID | DOUBLE | N | Tracking ItemColumn |
TRAUMA_IND | DOUBLE | Y | Defines the patient is trauma or notColumn |
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_CHECKIN
Child Column in TRACKING_CHECKIN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | FAMILY_PRESENT_CD | CODE_VALUE | CODE_VALUE |
TRACKING_EVENT_TYPE_CD | CODE_VALUE | CODE_VALUE | |
TRACKING_GROUP_CD | CODE_VALUE | CODE_VALUE | |
CHECKIN_ID | PRSNL | PERSON_ID | |
CHECKOUT_ID | PRSNL | PERSON_ID | |
PAT_ED_ACKNOWLEDGED_USER_ID | PRSNL | PERSON_ID | |
PRIMARY_DOC_ID | PRSNL | PERSON_ID | |
PRIMARY_NURSE_ID | PRSNL | PERSON_ID | |
SECONDARY_DOC_ID | PRSNL | PERSON_ID | |
SECONDARY_NURSE_ID | PRSNL | PERSON_ID | |
TRACKING_ID | TRACKING_ITEM | TRACKING_ID | |
ACUITY_LEVEL_ID | TRACK_REFERENCE | TRACKING_REF_ID | |
DEPART_ACUITY_LEVEL_ID | TRACK_REFERENCE | TRACKING_REF_ID | |
REGISTRATION_STATUS_ID | TRACK_REFERENCE | TRACKING_REF_ID | |
SPECIALTY_ID | TRACK_REFERENCE | TRACKING_REF_ID | |
TEAM_ID | TRACK_REFERENCE | TRACKING_REF_ID |
TRACKING_COMMENT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Tracking Comments in FirstNet |
Definition: | Activity Comments Records for Patients |
Table Type: | ACTIVITY |
Column Detail - TRACKING_COMMENT
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. |
ACTIVE_STATUS_CD | DOUBLE | N | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
ACTIVE_STATUS_DT_TM | DATETIME | Y | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
COMMENT_IDENTIFIER | VARCHAR(100) | Y | Identifier that distinguishes a comment from the comment_name |
COMMENT_NAME | VARCHAR(100) | N | Field Defines what name the comment is known by |
COMMENT_TYPE_CD | DOUBLE | N | Type of tracking comment |
ENCNTR_ID | DOUBLE | N | Encounter ID of a Patient |
TRACKING_COMMENT_ID | DOUBLE | N | Unique Primary Key for the table |
TRACKING_ID | DOUBLE | N | Foreign Key to tracking_item 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_COMMENT
Child Column in TRACKING_COMMENT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
TRACKING_ID | TRACKING_ITEM | TRACKING_ID |
TRACKING_COMPLAINT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Activity table listing the complaints (Lynx Problems) selected for a patient. |
Definition: | Tracking Complaint |
Table Type: | ACTIVITY |
Column Detail - TRACKING_COMPLAINT
Column Name | Type | Null? | Definition |
---|---|---|---|
BEG_EFFECTIVE_DT_TM | DATETIME | Y | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
END_EFFECTIVE_DT_TM | DATETIME | Y | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
PRIORITY_SEQUENCE | DOUBLE | N | The sequence order in which the problem is presented in user interfaces. Indicates relative importance of the problem. |
TRACKING_COMPLAINT_ID | DOUBLE | N | Primary Key for the table. Sequenced from i_tracking. |
TRACKING_GROUP_CD | DOUBLE | N | Tracking Group the Patient is checked into. |
TRACKING_ID | DOUBLE | N | Tracking ID (tracking_item key) of the patient. |
TRACK_COMPLAINT_ID | DOUBLE | N | Foreign Key pointing to the reference Track Complaint this record refers to. |
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_COMPLAINT
Child Column in TRACKING_COMPLAINT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | TRACKING_ID | TRACKING_ITEM | TRACKING_ID |
TRACK_COMPLAINT_ID | TRACK_COMPLAINT | TRACK_COMPLAINT_ID |
TRACKING_ENCNTR_EXTENSION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Tracking Encounter Extension |
Definition: | Store tracking specific data elements related to an encounter. Used in cases where no tracking id is available (CWD for example). |
Table Type: | ACTIVITY |
Column Detail - TRACKING_ENCNTR_EXTENSION
Column Name | Type | Null? | Definition |
---|---|---|---|
DC_SIGNED_IND | DOUBLE | N | Indicates that the discharge process has been signed |
DC_SIGNED_USER_ID | DOUBLE | N | Provider who last signed the discharge process. |
ENCNTR_ID | DOUBLE | N | Encntr_id of the associated encounter record. |
ESIGNATURE_FLAG | DOUBLE | N | status of the eSignature for an encounter. 0 = not complete, 1 = all fields complete, 2 = at least 1 signature was declined. |
PAT_ED_ACKNOWLEDGED_IND | DOUBLE | N | Indicates the patient understands the instructions they were given. |
PAT_ED_ACKNOWLEDGED_USER_ID | DOUBLE | N | The id of the provider who last set the patient acknowledgement indicator true |
PAT_RECEIVED_EC_IND | DOUBLE | N | Patient received an electronic copy of the discharge patient summary |
PAT_RECEIVED_EC_USER_ID | DOUBLE | N | User id of prsnl performing action |
PAT_REQUESTED_EC_IND | DOUBLE | N | Patient requested an electronic copy of the discharge patient summary |
PAT_REQUESTED_EC_USER_ID | DOUBLE | N | User id of prsnl performing action |
TRACKING_ENCNTR_EXTENSION_ID | DOUBLE | N | Primary key |
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_ENCNTR_EXTENSION
Child Column in TRACKING_ENCNTR_EXTENSION(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
DC_SIGNED_USER_ID | PRSNL | PERSON_ID | |
PAT_ED_ACKNOWLEDGED_USER_ID | PRSNL | PERSON_ID |
TRACKING_ENCNTR_PRSNL_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Tracking Encounter Personnel Relation Table |
Definition: | Tracking table used to cross-reference which personnel provider records are related to each encounter tracked. |
Table Type: | ACTIVITY |
Column Detail - TRACKING_ENCNTR_PRSNL_RELTN
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | 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. |
ENCNTR_PRSNL_RELTN_ID | DOUBLE | N | Provider relationship identifier used to define the relationship of the provider to the encounter. |
ENCNTR_TRACKING_ID | DOUBLE | N | Tracking ID from the Tracking Item table used to identify the cross-reference identifier for the encounter being tracked. |
PRSNL_TRACKING_ID | DOUBLE | N | Tracking ID from the Tracking Item table used to identify the cross-reference identifier for the provider (person) being tracked. |
TRACKING_ENCNTR_PRSNL_RELTN_ID | DOUBLE | N | Unique tracking identifier used to define the cross-reference between the provider records and the associated encounters. |
TRACKING_ID | DOUBLE | N | Cross-reference tracking item identifier of the patient that is to be associated with a provider. |
TRACKING_LOCATOR_ID | DOUBLE | N | Cross-reference tracking locator identifier of the provider location that is associated with a patient. |
TRACKING_PRSNL_ID | DOUBLE | N | Cross-reference tracking personnel identifier of the provider that is to be associated with a patient. |
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_ENCNTR_PRSNL_RELTN
Child Column in TRACKING_ENCNTR_PRSNL_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_PRSNL_RELTN_ID | ENCNTR_PRSNL_RELTN | ENCNTR_PRSNL_RELTN_ID |
ENCNTR_TRACKING_ID | TRACKING_ITEM | TRACKING_ID | |
PRSNL_TRACKING_ID | TRACKING_ITEM | TRACKING_ID | |
TRACKING_LOCATOR_ID | TRACKING_LOCATOR | TRACKING_LOCATOR_ID |