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 |