VISITCODE_CODETREE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Coding Tree
Definition: The root of a flattened tree structure defining rhe acceptable inputs to a set of coding rules and UI for maintaining those inputs
Table Type: REFERENCE





Column Detail - VISITCODE_CODETREE


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.
BEG_CONTENT_DT_TM DATETIME N timestamp indicating when the coding tree starts being active.
CONTENT_VERSION_NBR DOUBLE N used to provide a unique merge id that does not involve the effective dates.
DISPLAY_NAME VARCHAR(100) N Displayed name for the coding tree
END_CONTENT_DT_TM DATETIME N timestamp indicating when the coding tree stops being active. NULL indicates the tree is still active.
TREE_NAME VARCHAR(60) N name used to identify the coding tree.
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 Primary Key



Relationship Detail - VISITCODE_CODETREE




Parent Column in VISITCODE_CODETREE (PK) Child Table Name Child Column Name
Children: VISITCODE_CODETREE_ID VISITCODE_RULESET VISITCODE_CODETREE_ID
VISITCODE_TREENODE VISITCODE_CODETREE_ID
VISITCODING_EXTRACT VISITCODE_CODETREE_ID


VISITCODE_INI



Column Section Relationship Section Top of Page


Table-level Detail

Description: Visitcde INI
Definition: Stores XML preferences for use within professional coding application
Table Type: REFERENCE





Column Detail - VISITCODE_INI


Column Name Type Null? Definition
APPLICATION_NAME VARCHAR(50) N Name of application being used
CONTEXT_NAME VARCHAR(50) N Name of context being saved
LONG_TEXT_ID DOUBLE N Data of Context being saved. Foreign Key value from LONG_TEXT_REFERENCE table.
PRSNL_ID DOUBLE N Personnel 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.
VISITCODE_INI_ID DOUBLE N Primary Key



Relationship Detail - VISITCODE_INI


Child Column in VISITCODE_INI(FK) Parent Table Name Parent Column Name
Parents: LONG_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID
PRSNL_ID PRSNL PERSON_ID


VISITCODE_RULESET



Column Section Relationship Section Top of Page


Table-level Detail

Description: Coding Rule Set
Definition: A versioned pointer to a long_blob_reference record containing the data for a rule set and a coding_tree identifying acceptable inpurts to the rule set.
Table Type: REFERENCE





Column Detail - VISITCODE_RULESET


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.
BEG_CONTENT_DT_TM DATETIME N timestamp specifying when the rule set starts being active.
CONTENT_VERSION_NBR DOUBLE N used to define a unique merge key without referencing the effective dates
DISPLAY_NAME VARCHAR(100) N Displayed name for the ruleset
END_CONTENT_DT_TM DATETIME N timestamp specifying when the rule set ceases being active. NULL indicates the rule set is still active.
LONG_BLOB_ID DOUBLE N id of the long_blob_reference record containing the data for this rule set.
RULESET_NAME VARCHAR(60) N fixed name for the rule set to be used as a meaning not to be modified.
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 id of the associated track_coding_tree
VISITCODE_RULESET_ID DOUBLE N Primary Key



Relationship Detail - VISITCODE_RULESET


Child Column in VISITCODE_RULESET(FK) Parent Table Name Parent Column Name
Parents: LONG_BLOB_ID LONG_BLOB_REFERENCE LONG_BLOB_ID
VISITCODE_CODETREE_ID VISITCODE_CODETREE VISITCODE_CODETREE_ID




Parent Column in VISITCODE_RULESET (PK) Child Table Name Child Column Name
Children: VISITCODE_RULESET_ID VISITCODING_AUDIT VISITCODE_RULESET_ID


VISITCODE_TREENODE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Coding Tree Node
Definition: Define the nodes of a coding tree.
Table Type: REFERENCE





Column Detail - VISITCODE_TREENODE


Column Name Type Null? Definition
AUTOMATED_IND DOUBLE N AUTOMATED
DISPLAY_NAME VARCHAR(100) N The displayed name of the node
NODE_NAME VARCHAR(255) N delimited key for the node. this is a fixed name to be used as an id not to be modified.
SEQUENCE_NBR DOUBLE N position of the node among its siblings
TYPE_FLAG DOUBLE N Indicates the ui style for displaying child nodes: 0=checkbox, 1=dropdown, 2=option. This is only meaningful for parents of leaf nodes.
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 Parent Coding Tree
VISITCODE_TREENODE_ID DOUBLE N Primary Key



Relationship Detail - VISITCODE_TREENODE


Child Column in VISITCODE_TREENODE(FK) Parent Table Name Parent Column Name
Parents: VISITCODE_CODETREE_ID VISITCODE_CODETREE VISITCODE_CODETREE_ID


VISITCODING_AUDIT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Coding Audit
Definition: The root for a charging audit trail serving as a pointer to the list of coding extracts used to suggest a charge and the coding extract used to generate the final charge.
Table Type: ACTIVITY





Column Detail - VISITCODING_AUDIT


Column Name Type Null? Definition
APPLIED_CHARGE_ID DOUBLE N The nomenclature_id of the charge code that was applied by the coder.
APPLIED_MODIFIER_ID DOUBLE N ** OBSOLETE ** THIS COLUMN IS NOT USED AND WILL BECOME OBSOLETE WITH CHANGE MADE BY CR 1-3060766751 - FEB. 2009 ** Nomenclature id of the modifier applied to the charge
AUDIT_STATUS_CD DOUBLE N Visitcoding status [in progress, not started, signed]
AUTOMATED_DELTA_IND DOUBLE N Automated Delta Indicator
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CHARGE_DT_TM DATETIME N Date when the charge was generated.
CODER_PRSNL_ID DOUBLE N Prsnl.person_id of the coder
CRITICAL_CARE_IND DOUBLE N Indicates if this coding audit had critical care yes selected.
ENCNTR_ID DOUBLE N Encounter.encntr_id
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
NO_CHARGE_IND DOUBLE N indicates the charge was dropped as a no charge charge
PREV_VISITCODING_AUDIT_ID DOUBLE N Previous (original) valid tracking audit row. Used for type-2 Versioning of the tracking audit row
PRIMARY_NOMENCLATURE_ID DOUBLE N FOREIGN KEY VALUE FROM NOMENCLATURE
PROVIDER_PRSNL_ID DOUBLE N Prsnl.person_id of the care provider for whom the charge was created
SUGGESTED_CHARGE_ID DOUBLE N The nomenclature_id of the charge code that was suggested to the coder.
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_RULESET_ID DOUBLE N Coding ruleset used to suggest the charge
VISITCODING_AUDIT_ID DOUBLE N Primary Key



Relationship Detail - VISITCODING_AUDIT


Child Column in VISITCODING_AUDIT(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
APPLIED_CHARGE_ID NOMENCLATURE NOMENCLATURE_ID
APPLIED_MODIFIER_ID NOMENCLATURE NOMENCLATURE_ID
PRIMARY_NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID
SUGGESTED_CHARGE_ID NOMENCLATURE NOMENCLATURE_ID
CODER_PRSNL_ID PRSNL PERSON_ID
PROVIDER_PRSNL_ID PRSNL PERSON_ID
VISITCODE_RULESET_ID VISITCODE_RULESET VISITCODE_RULESET_ID
PREV_VISITCODING_AUDIT_ID VISITCODING_AUDIT VISITCODING_AUDIT_ID




Parent Column in VISITCODING_AUDIT (PK) Child Table Name Child Column Name
Children: VISITCODING_AUDIT_ID VISITCODING_AUDIT PREV_VISITCODING_AUDIT_ID
VISITCODING_BILLITEM VISITCODING_AUDIT_ID
VISITCODING_DX VISITCODING_AUDIT_ID
VISITCODING_EXTRACT VISITCODING_AUDIT_ID
VISITCODING_MODIFIER VISITCODING_AUDIT_ID
VISITCODING_PROVIDER VISITCODING_AUDIT_ID