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