Table Detail Report

DOC_TRANSCRIPTION_QUEUE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Documentation Transcription Queue
Definition: List dictated documentations that are ready for transcription
Table Type: ACTIVITY





Column Detail - DOC_TRANSCRIPTION_QUEUE


Column Name Type Null? Definition
AUTHOR_ID DOUBLE N Identifies the provider who is the author of the documentation.
DOCUMENTATION_TYPE_CD DOUBLE N The documentation type represented by event cd.
DOC_TRANSCRIPTION_QUEUE_ID DOUBLE N Identifies the queue uniquely. Primary Key
ENCNTR_ID DOUBLE N Identifies the patient encounter this documentation belongs to. Can be 0.
EVENT_ID DOUBLE N Identifies a Unique Event set from the CLINICAL EVENT table which is associated to the documentation type code
FACILITY_CD DOUBLE N Indicates the Facility of the patient.
PERSON_ID DOUBLE N Identifies the patient this documentation belongs to
PRIORITY_IND DOUBLE N Indicates if the documentation is marked as priority item.
PURGE_IND DOUBLE N Indicates that this documentation has been transcribed and is ready to be purged.
TOTAL_DICTATION_LENGTH DOUBLE N Indicated a total length of the dictation for the entire document in minutes.
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 - DOC_TRANSCRIPTION_QUEUE


Child Column in DOC_TRANSCRIPTION_QUEUE(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID
AUTHOR_ID PRSNL PERSON_ID


DYNAMIC_LABEL_TEMPLATE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Dynamic Label Template
Definition: Store information about a Dynamic Label as well as the ID of the documentation set that defines the dynamic label elements. Additional attributes WILL be added to the table in the future to extend the functionality and refine the template identification.
Table Type: REFERENCE





Column Detail - DYNAMIC_LABEL_TEMPLATE


Column Name Type Null? Definition
DOC_SET_REF_ID DOUBLE N ID of the documentations set that defines the contents of the dynamic label.
ENCOUNTER_SPECIFIC_IND DOUBLE N This field indicates if a label created from this template is intended to be active only during a single encounter or if it spans multiple encounters
LABEL_TEMPLATE_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 - DYNAMIC_LABEL_TEMPLATE


Child Column in DYNAMIC_LABEL_TEMPLATE(FK) Parent Table Name Parent Column Name
Parents: DOC_SET_REF_ID DOC_SET_REF DOC_SET_REF_ID




Parent Column in DYNAMIC_LABEL_TEMPLATE (PK) Child Table Name Child Column Name
Children: LABEL_TEMPLATE_ID CE_DYNAMIC_LABEL LABEL_TEMPLATE_ID
CNT_DS_LABEL_KEY LABEL_TEMPLATE_REF_ID
DISCRETE_TASK_ASSAY LABEL_TEMPLATE_ID