Table Detail Report
VISITCODING_BILLITEM
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Coding Audit Bill Items |
Definition: | The subtable for audit trail serving as a pointer to the list of bill items that were selected during professional coding. |
Table Type: | ACTIVITY |
Column Detail - VISITCODING_BILLITEM
Column Name | Type | Null? | Definition |
---|---|---|---|
BILL_ITEM_ID | DOUBLE | N | foreign key from BILL_ITEM |
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. |
VISITCODING_AUDIT_ID | DOUBLE | N | FOREIGN KEY TO TRACKING AUDIT |
VISITCODING_BILLITEM_ID | DOUBLE | N | PRIMARY KEY |
VISITCODING_DX_ID | DOUBLE | N | FOREIGN KEY VALUE FROM VISITCODING_DX |
VISITCODING_MODIFIER_ID | DOUBLE | N | FOREIGN KEY VALUE FROM VISITCODING_MODIFIER |
VISITCODING_PROVIDER_ID | DOUBLE | N | FOREIGN KEY VALUE FROM VISITCODING_PROVIDER |
Relationship Detail - VISITCODING_BILLITEM
Child Column in VISITCODING_BILLITEM(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | BILL_ITEM_ID | BILL_ITEM | BILL_ITEM_ID |
VISITCODING_AUDIT_ID | VISITCODING_AUDIT | VISITCODING_AUDIT_ID | |
VISITCODING_DX_ID | VISITCODING_DX | VISITCODING_DX_ID | |
VISITCODING_MODIFIER_ID | VISITCODING_MODIFIER | VISITCODING_MODIFIER_ID | |
VISITCODING_PROVIDER_ID | VISITCODING_PROVIDER | VISITCODING_PROVIDER_ID |
VISITCODING_DX
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Coding Audit Bill Items Diagnosis |
Definition: | The subtable for audit trail serving as a pointer to the list of diagnosises that were selected during professional coding. |
Table Type: | ACTIVITY |
Column Detail - VISITCODING_DX
Column Name | Type | Null? | Definition |
---|---|---|---|
DIAGNOSIS_ID | DOUBLE | N | Diagnosis |
NOMENCLATURE_ID | DOUBLE | N | THE FOREIGN KEY VALUE FROM NOMENCLATURE TABLE |
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. |
VISITCODING_AUDIT_ID | DOUBLE | N | Foreign Key to tracking_audit |
VISITCODING_DX_ID | DOUBLE | N | PRIMARY KEY |
Relationship Detail - VISITCODING_DX
Child Column in VISITCODING_DX(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | DIAGNOSIS_ID | DIAGNOSIS | DIAGNOSIS_ID |
NOMENCLATURE_ID | NOMENCLATURE | NOMENCLATURE_ID | |
VISITCODING_AUDIT_ID | VISITCODING_AUDIT | VISITCODING_AUDIT_ID |
Parent Column in VISITCODING_DX (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | VISITCODING_DX_ID | VISITCODING_BILLITEM | VISITCODING_DX_ID |
VISITCODING_EXTRACT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Coding Extract |
Definition: | Root element of a tree of coding data extracted from clinical documentation |
Table Type: | ACTIVITY |
Column Detail - VISITCODING_EXTRACT
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
AUTHENTICATED_IND | DOUBLE | N | indicates whether the extract is for a saved document or a signed document |
BEG_CONTENT_DT_TM | DATETIME | N | timestamp indicating when the extract starts being active |
END_CONTENT_DT_TM | DATETIME | N | timestamp specifying when the extract ceases being active. NULL indicates the extract is still active. |
EVENT_ID | DOUBLE | N | Clinical_event.event id of the source document. if non-zero then tracking_coding_audit_id must be zero. |
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. |
VISITCODE_CODETREE_ID | DOUBLE | N | the track_coding_tree.name for the associated track_coding_tree. |
VISITCODING_AUDIT_ID | DOUBLE | N | tracking_coding_audit.tracking_coding_audit_id of the source audit. if non-zero then event_id must be zero. |
VISITCODING_EXTRACT_ID | DOUBLE | N | Primary Key |
Relationship Detail - VISITCODING_EXTRACT
Child Column in VISITCODING_EXTRACT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | VISITCODE_CODETREE_ID | VISITCODE_CODETREE | VISITCODE_CODETREE_ID |
VISITCODING_AUDIT_ID | VISITCODING_AUDIT | VISITCODING_AUDIT_ID |
Parent Column in VISITCODING_EXTRACT (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | VISITCODING_EXTRACT_ID | VISITCODING_EXT_ITEM | VISITCODING_EXTRACT_ID |
VISITCODING_EXT_ITEM
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Coding Extract Item |
Definition: | child items for a coding_extract |
Table Type: | ACTIVITY |
Column Detail - VISITCODING_EXT_ITEM
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
NODE_NAME | VARCHAR(255) | N | a delimited string specifying a node in a tree. this is a fixed name to be used as an id not to be modified. |
NODE_VALUE_TXT | VARCHAR(255) | N | the text value of the node |
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. |
VISITCODING_EXTRACT_ID | DOUBLE | N | id of the parent tracking_coding_extract record |
VISITCODING_EXT_ITEM_ID | DOUBLE | N | Primary Key |
Relationship Detail - VISITCODING_EXT_ITEM
Child Column in VISITCODING_EXT_ITEM(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | VISITCODING_EXTRACT_ID | VISITCODING_EXTRACT | VISITCODING_EXTRACT_ID |
VISITCODING_MODIFIER
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Visit Coding Modifier |
Definition: | Stores lists of modifiers associated to an E&M code in the visitcoding_audit table |
Table Type: | ACTIVITY |
Column Detail - VISITCODING_MODIFIER
Column Name | Type | Null? | Definition |
---|---|---|---|
MODIFIER_CD | DOUBLE | N | Modifier Code |
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. |
VISITCODING_AUDIT_ID | DOUBLE | N | Key to the visitcoding_audit record containing the modified E&M code. |
VISITCODING_MODIFIER_ID | DOUBLE | N | Primary id |
Relationship Detail - VISITCODING_MODIFIER
Child Column in VISITCODING_MODIFIER(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | VISITCODING_AUDIT_ID | VISITCODING_AUDIT | VISITCODING_AUDIT_ID |
Parent Column in VISITCODING_MODIFIER (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | VISITCODING_MODIFIER_ID | VISITCODING_BILLITEM | VISITCODING_MODIFIER_ID |