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. |