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 |