Table Detail Report

CAC_RULE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Computer Assisted Coding Rule
Definition: Stores the computer assisted coding rules.
Table Type: REFERENCE





Column Detail - CAC_RULE


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_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.
CAC_RULE_ID DOUBLE N Unique generated number that identifies a single row on the CAC_RULE table.
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.
LONG_TEXT_ID DOUBLE N Unique identifier for the row on the LONG_TEXT_REFERENCE table where the rule is stored.
RULE_NAME VARCHAR(200) N Unique name of the rule.
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_DEFINED_IND DOUBLE N Indicates whether this rule was user defined or system defined.



Relationship Detail - CAC_RULE


Child Column in CAC_RULE(FK) Parent Table Name Parent Column Name
Parents: LONG_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID




Parent Column in CAC_RULE (PK) Child Table Name Child Column Name
Children: CAC_RULE_ID CAC_NOMENCLATURE CAC_RULE_ID
CAC_RULE_RELTN CAC_RULE_ID


CAC_RULE_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Computer Assisted Coding Rule Relationship
Definition: Stores the relationship of computer assisted coding rule sets to rules.
Table Type: REFERENCE





Column Detail - CAC_RULE_RELTN


Column Name Type Null? Definition
CAC_RULE_ID DOUBLE N This is the value of ht unique primary identifier of the CAC_RULE table. This is the rule that the rule set is related to.
CAC_RULE_RELTN_ID DOUBLE N Unique generated number that identifies a single row on the CAC_RULE_RELTN table.
CAC_RULE_SET_ID DOUBLE N This is the value of ht unique primary identifier of the CAC_RULE_SET table. This is the rule set that the rule is related to.
PRIORITY_SEQ DOUBLE N A number that represents the order the CAC Rule will be run within the CAC Rule Set.
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 - CAC_RULE_RELTN


Child Column in CAC_RULE_RELTN(FK) Parent Table Name Parent Column Name
Parents: CAC_RULE_ID CAC_RULE CAC_RULE_ID
CAC_RULE_SET_ID CAC_RULE_SET CAC_RULE_SET_ID


CAC_RULE_SET



Column Section Relationship Section Top of Page


Table-level Detail

Description: Computer Assisted Coding Rule Set
Definition: Stores the sets of computer assisted coding rules.
Table Type: REFERENCE





Column Detail - CAC_RULE_SET


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_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.
CAC_RULE_SET_ID DOUBLE N Unique generated number that identifies a single row on the CAC_RULE_SET table.
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.
RULE_SET_ALIAS VARCHAR(200) N Unique alias of the rule set. This is used to identify which rule set should be run.
RULE_SET_NAME VARCHAR(200) N Unique name of the rule set.
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_DEFINED_IND DOUBLE N Indicates whether this rule set was user defined or system defined.



Relationship Detail - CAC_RULE_SET




Parent Column in CAC_RULE_SET (PK) Child Table Name Child Column Name
Children: CAC_RULE_SET_ID CAC_RULE_RELTN CAC_RULE_SET_ID


CHART_PROCESS



Column Section Relationship Section Top of Page


Table-level Detail

Description: ProFile chart processing table
Definition: stores chart level information such as allocation date and chart status
Table Type: ACTIVITY





Column Detail - CHART_PROCESS


Column Name Type Null? Definition
ABSTRACT_COMPLETE_IND DOUBLE Y This indicator is used to identify which charts have been abstracted
ACTIVE_IND DOUBLE Y 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.
ACTIVE_STATUS_CD DOUBLE Y Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE Y The person who caused the active_status_cd to be set or change.
ALLOCATION_DT_FLAG DOUBLE Y This flexes how allocation date is calculated
ALLOCATION_DT_MODIFIER DOUBLE Y The number of days to add to an event's date in calculating the allocation date.
ALLOCATION_DT_TM DATETIME Y The date and time that the chart is allocated (or made available) to a physician for completion.
BEG_EFFECTIVE_DT_TM DATETIME Y 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.
CHART_PROCESS_ID DOUBLE N The unique identifier of the chart process table
CHART_STATUS_CD DOUBLE Y Code for the status of the chart
CHART_STATUS_DT_TM DATETIME Y The date and time the chart status was assigned
ENCNTR_ID DOUBLE Y This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
END_EFFECTIVE_DT_TM DATETIME Y 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.
PERSON_ID DOUBLE Y This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
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 - CHART_PROCESS


Child Column in CHART_PROCESS(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID


CLINICAL_SERVICE_RELTN



Column Section Top of Page


Table-level Detail

Description: CLINICAL SERVICE RELTN
Definition: The relationships between the person and the clinical service.
Table Type: REFERENCE





Column Detail - CLINICAL_SERVICE_RELTN


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
BEG_EFFECTIVE_DT_TM DATETIME Y 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.
CLINICAL_SERVICE_CD DOUBLE N Associates the clinical diagnosis to a particular setting of care within an encounter.
CLINICAL_SERVICE_RELTN_ID DOUBLE N Unique identifier for the Clinical Service Relation table.
END_EFFECTIVE_DT_TM DATETIME Y 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.
PARENT_ENTITY_ID DOUBLE N The value of the primary identifier of the table to which the 'clinical_service_reltn' row is related
PARENT_ENTITY_NAME VARCHAR(30) N Name of the parent entity table
PRIORITY DOUBLE Y Optional field. It can be used if the person/org relation has more than 1 clinical service associated with it.
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.