CLARIFICATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: CLARIFICATION
Definition: Clarifications returned by the DQR inference engine
Table Type: ACTIVITY





Column Detail - CLARIFICATION


Column Name Type Null? Definition
CLARIFICATION_FAMILY VARCHAR(64) N Family of the clarification
CLARIFICATION_ID DOUBLE N Unique generated number that identifies a single row on the CLARIFICATION table.
CLARIFICATION_KIND VARCHAR(64) N Kind name of the Clarification
CLARIFICATION_SEQUENCE DOUBLE N Order that provides clinical relevance to the physician
CONFIDENCE_FLAG DOUBLE N Confidence of the clarification condition
DISPLAY_TEXT_ID DOUBLE N Link to the clarification text on the long text table. The clarification text is the high-level verbage that will be presented to the user
DOCUMENTATION_STATUS_FLAG DOUBLE N Documentation status of the clarification
DOCUMENT_QUALITY_REVIEW_ID DOUBLE N Identifier for row on the Document Quality Review 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
MORE_INFO_TEXT_ID DOUBLE N Text That describe the clarification
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.
USER_STATUS_FLAG DOUBLE N Indicates user clarification resolution/extraction status.1 Agree2 Not Shown3 Shown4 Other5 Ask me later6 Does not apply



Relationship Detail - CLARIFICATION


Child Column in CLARIFICATION(FK) Parent Table Name Parent Column Name
Parents: DOCUMENT_QUALITY_REVIEW_ID DOCUMENT_QUALITY_REVIEW DOCUMENT_QUALITY_REVIEW_ID
DQR_DOCUMENT_IDENTIFIER_ID DQR_DOCUMENT_IDENTIFIER DQR_DOCUMENT_IDENTIFIER_ID
DISPLAY_TEXT_ID LONG_TEXT LONG_TEXT_ID
MORE_INFO_TEXT_ID LONG_TEXT LONG_TEXT_ID




Parent Column in CLARIFICATION (PK) Child Table Name Child Column Name
Children: CLARIFICATION_ID CLRFCTN_ACTION CLARIFICATION_ID
CLRFCTN_RESPONSE CLARIFICATION_ID
CLRFCTN_SUPT_CODE CLARIFICATION_ID
CLRFCTN_SUPT_LAB_VS CLARIFICATION_ID
CLRFCTN_SUPT_TREATMENT CLARIFICATION_ID


CLRFCTN_ACTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Clarification Response
Definition: Clarification responses suggested by the DQR inference engine
Table Type: ACTIVITY





Column Detail - CLRFCTN_ACTION


Column Name Type Null? Definition
ACCEPTED_TEXT_ID DOUBLE N The (potentially modified) documentation text that the physician accepts
ACTION_CD DOUBLE N The action taken by the physician on the clarification
ACTION_DT_TM DATETIME Y The date and time at which the personnel took action on the clarification
ACTION_PRSNL_ID DOUBLE N The personnel who took action on the clarification
CLARIFICATION_ID DOUBLE N Unique identifier on CLARIFICATION table
CLRFCTN_ACTION_ID DOUBLE N PRIMARY KEY
CLRFCTN_RESPONSE_ID DOUBLE N Unique identifier on CLARIFICATION RESPONSE table
DIAGNOSIS_ID DOUBLE N The diagnosis entered when physician accept the clarification
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_ACTION


Child Column in CLRFCTN_ACTION(FK) Parent Table Name Parent Column Name
Parents: CLARIFICATION_ID CLARIFICATION CLARIFICATION_ID
CLRFCTN_RESPONSE_ID CLRFCTN_RESPONSE CLRFCTN_RESPONSE_ID
DIAGNOSIS_ID DIAGNOSIS DIAGNOSIS_ID
ACCEPTED_TEXT_ID LONG_TEXT LONG_TEXT_ID
ACTION_PRSNL_ID PRSNL PERSON_ID


CLRFCTN_CODED_VALUES



Column Section Top of Page


Table-level Detail

Description: Clarification Coded Values
Definition: Coded vocabulary identifiers returned in Clarification Responses
Table Type: ACTIVITY





Column Detail - CLRFCTN_CODED_VALUES


Column Name Type Null? Definition
CLRFCTN_CODED_VALUES_ID DOUBLE N Unique generated number that identifies a single row on the Table
DISPLAY_TEXT VARCHAR(255) N Vocabulary Display
ENTITY_ID DOUBLE N ID of the row on the linked clarification table identified in ENTITY_NAME
ENTITY_NAME VARCHAR(30) N Name of the Clarification table being linked
EXST_POTEN_CONDITION_FLAG DOUBLE N Indicates whether exiting condition OR New Diagnosis 0 - Not Applicable; 1 - Existing Condition; 2 - New Diagnosis
SOURCE_VOCABULARY_CD DOUBLE N Source Vocabulary code from Code Set 400
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.
VOCABULARY_CODE VARCHAR(20) N Vocabulary Code


CLRFCTN_RESPONSE



Column Section Relationship Section Top of Page


Table-level Detail

Description: CLRFCTN_RESPONSE
Definition: Clarification responses suggested by the DQR inference engine
Table Type: ACTIVITY





Column Detail - CLRFCTN_RESPONSE


Column Name Type Null? Definition
CLARIFICATION_ID DOUBLE N Unique identifier on CLARIFICATION table
CLRFCTN_RESPONSE_ID DOUBLE N Unique generated number that identifies a single row on the CLARIFICATION_RESPONSE table.
PROPOSED_TEXT_ID DOUBLE N Proposed documentation text to go in the document if the clarification response is accepted
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_RESPONSE


Child Column in CLRFCTN_RESPONSE(FK) Parent Table Name Parent Column Name
Parents: CLARIFICATION_ID CLARIFICATION CLARIFICATION_ID
PROPOSED_TEXT_ID LONG_TEXT LONG_TEXT_ID




Parent Column in CLRFCTN_RESPONSE (PK) Child Table Name Child Column Name
Children: CLRFCTN_RESPONSE_ID CLRFCTN_ACTION CLRFCTN_RESPONSE_ID


CLRFCTN_SUPT_CODE



Column Section Relationship Section Top of Page


Table-level Detail

Description: CLRFCTN_SUPT_CODE
Definition: Coded nomenclature values that support the clarification
Table Type: ACTIVITY





Column Detail - CLRFCTN_SUPT_CODE


Column Name Type Null? Definition
CLARIFICATION_ID DOUBLE N Identifier for row on the Clarification Table
CLRFCTN_SUPT_CODE_ID DOUBLE N Unique generated number that identifies a single row on the CLARIFICATION_SUPT_CODE table.
NEGATIVE_IND DOUBLE N Indicates whether the absence of the given code is significant
SUPT_CODE_NAME VARCHAR(128) Y Name of the Supporting Code
UPDATED_IND DOUBLE N UPDATED? YES or NO ( 1 OR 0 )
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_CODE


Child Column in CLRFCTN_SUPT_CODE(FK) Parent Table Name Parent Column Name
Parents: CLARIFICATION_ID CLARIFICATION CLARIFICATION_ID