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 |