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