Table Detail Report
CLRFCTN_SUPT_DOC
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | CLRFCTN_SUPT_DOC |
Definition: | Existing documents which contain data supporting the clarification |
Table Type: | ACTIVITY |
Column Detail - CLRFCTN_SUPT_DOC
Column Name | Type | Null? | Definition |
---|---|---|---|
CLRFCTN_SUPT_DOC_ID | DOUBLE | N | Unique generated number that identifies a single row on the CLARIFICATION_SUPT_DOC table. |
DQR_DOCUMENT_IDENTIFIER_ID | DOUBLE | N | Document Identifier sent to the Document Quality Review Inference engine for the document which contains the supporting data |
EFFECTIVE_DT_TM | DATETIME | Y | Effective date and time for this document |
ENTITY_ID | DOUBLE | N | Id of the row on the linked clarification table |
ENTITY_NAME | VARCHAR(30) | N | Name of the clarification table being linked |
EVENT_ID | DOUBLE | N | Document on which Document Quality Review has been run - value from CLINICAL_EVENT.EVENT_ID |
TEMP_REF_IDENT | VARCHAR(100) | N | Temporary reference identifier for document on which DQR was run. To be used for new documents before they have been saved and have an event_id |
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 - CLRFCTN_SUPT_DOC
Child Column in CLRFCTN_SUPT_DOC(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | DQR_DOCUMENT_IDENTIFIER_ID | DQR_DOCUMENT_IDENTIFIER | DQR_DOCUMENT_IDENTIFIER_ID |
CLRFCTN_SUPT_LAB_VS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | CLRFCTN_SUPT_LAB_VS |
Definition: | Lab vital signs that support the clarification |
Table Type: | ACTIVITY |
Column Detail - CLRFCTN_SUPT_LAB_VS
Column Name | Type | Null? | Definition |
---|---|---|---|
ABNORMALITY_STATUS | VARCHAR(10) | Y | The Abnormality Status will be one of the following: Normal, Abnormal, Very Low, Low, High, Very High. |
CLARIFICATION_ID | DOUBLE | N | Identifier for row on the Clarification Table |
CLRFCTN_SUPT_LAB_VS_ID | DOUBLE | N | Unique generated number that identifies a single row on the CLARIFICATION_SUPT_LAB_VS table. |
LAB_VS_DISPLAY | VARCHAR(36) | Y | Supporting lab vital sign display |
LAB_VS_VAL | VARCHAR(36) | Y | Supporting lab vital sign value |
UPDATED_IND | DOUBLE | N | UPDATED? 1 = YES 0 = NO |
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 - CLRFCTN_SUPT_LAB_VS
Child Column in CLRFCTN_SUPT_LAB_VS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CLARIFICATION_ID | CLARIFICATION | CLARIFICATION_ID |
CLRFCTN_SUPT_TREATMENT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | CLRFCTN_SUPT_TREATMENT |
Definition: | Treatments that support the clarification |
Table Type: | ACTIVITY |
Column Detail - CLRFCTN_SUPT_TREATMENT
Column Name | Type | Null? | Definition |
---|---|---|---|
CLARIFICATION_ID | DOUBLE | N | Identifier for row on the Clarification Table |
CLRFCTN_SUPT_TREATMENT_ID | DOUBLE | N | Unique generated number that identifies a single row on the CLARIFICATION_SUPT_TREATMENT table. |
TREATMENT_CLASS | VARCHAR(128) | Y | Supporting treatment class |
TREATMENT_DISPLAY | VARCHAR(128) | Y | Supporting treatment display |
UPDATED_IND | DOUBLE | N | UPDATED? 1 = yes 0 = no |
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 - CLRFCTN_SUPT_TREATMENT
Child Column in CLRFCTN_SUPT_TREATMENT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CLARIFICATION_ID | CLARIFICATION | CLARIFICATION_ID |
DOCUMENT_QUALITY_REVIEW
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Document Quality Review |
Definition: | Status of requests to the Document Quality Review inference engine |
Table Type: | ACTIVITY |
Column Detail - DOCUMENT_QUALITY_REVIEW
Column Name | Type | Null? | Definition |
---|---|---|---|
DOCUMENT_QUALITY_REVIEW_ID | DOUBLE | N | Unique generated number that identifies a single row on the DOCUMENT_QUALITY_REVIEW table. |
DQR_BEG_EFFECTIVE_DT_TM | DATETIME | Y | Beginning of the range for which the DQR run is effective |
DQR_DOCUMENT_ACTION_ID | DOUBLE | N | The transaction audit record for the document quality review run. |
DQR_DOCUMENT_IDENTIFIER_ID | DOUBLE | N | Document identifier sent to the Document Quality Review inference engine |
DQR_END_EFFECTIVE_DT_TM | DATETIME | Y | End of the range for which the DQR run is effective |
DQR_STATUS_CD | DOUBLE | N | Resulting status of the call to DQR |
DQR_STATUS_TEXT | VARCHAR(255) | Y | Any status text returned by DQR |
ENCNTR_ID | DOUBLE | N | Encounter on which DQR was run |
EVENT_ID | DOUBLE | N | Document on which Document Quality Review has been run - value from CLINICAL_EVENT.EVENT_ID |
ORGANIZATION_ID | DOUBLE | N | Organization of DQR Run |
PERSON_ID | DOUBLE | N | Person on which DQR was run |
PHYSICIAN_IND | DOUBLE | N | Indicates whether DQR was run by non-physician or physician |
POR_FLAG | DOUBLE | N | Indicates whether the personnel authoring the document on which DQR is being run is not physician(0), physician, unknown of record(1), physician, not of record(2), physician of record(3) |
PRSNL_ID | DOUBLE | N | Personnel who ran DQR |
TEMP_REF_IDENT | VARCHAR(100) | N | Temporary reference identifier for document on which DQR was run. To be used for new documents before they have been saved and have an event_id |
TRANSACTION_IDENT | VARCHAR(36) | Y | Transaction identifier for message sent to DQR inference engine |
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 - DOCUMENT_QUALITY_REVIEW
Child Column in DOCUMENT_QUALITY_REVIEW(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | DQR_DOCUMENT_ACTION_ID | DQR_DOCUMENT_ACTION | DQR_DOCUMENT_ACTION_ID |
DQR_DOCUMENT_IDENTIFIER_ID | DQR_DOCUMENT_IDENTIFIER | DQR_DOCUMENT_IDENTIFIER_ID | |
ENCNTR_ID | ENCOUNTER | ENCNTR_ID | |
ORGANIZATION_ID | ORGANIZATION | ORGANIZATION_ID | |
PERSON_ID | PERSON | PERSON_ID | |
PRSNL_ID | PRSNL | PERSON_ID |
Parent Column in DOCUMENT_QUALITY_REVIEW (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | DOCUMENT_QUALITY_REVIEW_ID | CLARIFICATION | DOCUMENT_QUALITY_REVIEW_ID |
DQR_DOCUMENT_ACTION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Document Quality Review - Action |
Definition: | Status of requests to the Document Quality Review inference engine. |
Table Type: | ACTIVITY |
Column Detail - DQR_DOCUMENT_ACTION
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTION_DT_TM | DATETIME | N | date/time the document was submitted or deleted |
DOC_ACTION_FLAG | DOUBLE | N | action being taken on the document 1-Submit, 2-Delete |
DQR_DOCUMENT_ACTION_ID | DOUBLE | N | PRIMARY KEY. A unique generated number that signifies a single row on the table. |
DQR_DOCUMENT_IDENTIFIER_ID | DOUBLE | N | Document identifier sent to the Document Quality Review inference engine |
DQR_STATUS_CD | DOUBLE | N | Resulting status of the call to DQR |
DQR_STATUS_TEXT | VARCHAR(255) | Y | Any status text returned by DQR |
ENCOUNTER_ID | DOUBLE | N | Encounter on which DQR was run |
ESO_QUEUE_ID | DOUBLE | N | The CQM ESO queue_id if triggered via ESO, cqm_fsieso_que table. |
EVENT_ID | DOUBLE | N | Document on which Document Quality Review has been run - value from CLINICAL_EVENT.EVENT_ID |
HIST_ENCNTR_ID | DOUBLE | N | The historical encounter associated with the action. |
HIST_PERSON_ID | DOUBLE | N | The historical person associated with the action. |
ORGANIZATION_ID | DOUBLE | N | Organization of the DQR Run |
PERSON_ID | DOUBLE | N | Person on which DQR was run |
SI_MESSAGE_LOG_ID | DOUBLE | Y | The message audit record for the requested action |
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 - DQR_DOCUMENT_ACTION
Child Column in DQR_DOCUMENT_ACTION(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ESO_QUEUE_ID | CQM_FSIESO_QUE | QUEUE_ID |
DQR_DOCUMENT_IDENTIFIER_ID | DQR_DOCUMENT_IDENTIFIER | DQR_DOCUMENT_IDENTIFIER_ID | |
ENCOUNTER_ID | ENCOUNTER | ENCNTR_ID | |
ORGANIZATION_ID | ORGANIZATION | ORGANIZATION_ID | |
PERSON_ID | PERSON | PERSON_ID | |
SI_MESSAGE_LOG_ID | SI_MESSAGE_LOG | SI_MESSAGE_LOG_ID |
Parent Column in DQR_DOCUMENT_ACTION (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | DQR_DOCUMENT_ACTION_ID | DOCUMENT_QUALITY_REVIEW | DQR_DOCUMENT_ACTION_ID |