Table Detail Report
CT_RULE
Column Section | Top of Page |
Table-level Detail
Description: | This table holds all the rules that have been defined. |
Definition: | Charge Transformation Rule Table |
Table Type: | REFERENCE |
Column Detail - CT_RULE
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTION_CD | DOUBLE | N | Indicates whether a rule is of the type REPLACELIST, REPLACEPRICE, REPLACEADJUST or COUNT. |
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 | 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 | Y | 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. |
COUNT_GROUP_CD | DOUBLE | N | not used. |
CT_RULE_ID | DOUBLE | N | This the unique primary identifier of the ct_rule table. It is an internal system assigned number. |
DESCRIPTION | VARCHAR(100) | Y | This is the name of the rule. |
DURATION_CD | DOUBLE | N | Indicates whether accession or dateofservice is to be used. |
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. |
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. |
VOCAB_TYPE_CD | DOUBLE | N | Value from code_set 400 that indicates the source vocabulary type. |
CT_RULESET_RULE_RELTN
Column Section | Top of Page |
Table-level Detail
Description: | This table holds the relationship between rulesets and rules. |
Definition: | Charge Transformation ruleset rule reltn |
Table Type: | REFERENCE |
Column Detail - CT_RULESET_RULE_RELTN
Column Name | Type | Null? | Definition |
---|---|---|---|
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 | 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 | Y | 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. |
CT_RULESET_CD | DOUBLE | N | Value from 18829 that indicates a set of rules that are grouped together. |
CT_RULESET_RULE_ID | DOUBLE | N | This is the unique primary identifier for the ct_ruleset_rule_reltn table. It is an internal system assigned number. |
CT_RULE_ID | DOUBLE | N | This is the unique primary identifier for the ct_rule 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. |
PRIORITY | DOUBLE | Y | This is the priority for 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. |
CT_RULESET_TIER
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | This table holds the relationship between tiers and rulesets. |
Definition: | Charge Transformation Ruleset Tier table |
Table Type: | REFERENCE |
Column Detail - CT_RULESET_TIER
Column Name | Type | Null? | Definition |
---|---|---|---|
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 | 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 | Y | 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. |
CT_RULESET_CD | DOUBLE | N | This is a user defined code value from code set 18829 that is the name of the rule set. |
CT_RULESET_TIER_ID | DOUBLE | N | This is the unique primary identifier of the ct_ruleset_tier table. It is an internal system assigned number. |
ENCNTR_TYPE_CD | DOUBLE | N | Value from code_set 71 that indicated whether the encounter is inpatient, outpatient etc. |
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. |
EXCLUDE_ENCNTR_TYPE_CD | DOUBLE | N | Exclusion encounter type for tier rule |
FIN_CLASS_CD | DOUBLE | N | Patient's finacial class from code set 354. |
HEALTH_PLAN_ID | DOUBLE | N | This is the unique identifier from the health_plan table. |
INS_ORG_ID | DOUBLE | N | This column will store the insurance organization id for the given tier. |
ORGANIZATION_ID | DOUBLE | N | Indicates the client organization associated with this charge. |
PRIORITY | DOUBLE | Y | This is the priority for 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. |
Relationship Detail - CT_RULESET_TIER
Child Column in CT_RULESET_TIER(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | HEALTH_PLAN_ID | HEALTH_PLAN | HEALTH_PLAN_ID |
INS_ORG_ID | ORGANIZATION | ORGANIZATION_ID | |
ORGANIZATION_ID | ORGANIZATION | ORGANIZATION_ID |
CT_RULE_DETAIL
Column Section | Top of Page |
Table-level Detail
Description: | This table holds all the rule details for a particular rule. |
Definition: | Charge Transformation Rule Detail table |
Table Type: | REFERENCE |
Column Detail - CT_RULE_DETAIL
Column Name | Type | Null? | Definition |
---|---|---|---|
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 | 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 | Y | 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. |
COUNT_BEG | DOUBLE | Y | The beginning count number. |
COUNT_END | DOUBLE | Y | The ending count number. |
CT_RULE_DETAIL_ID | DOUBLE | N | This is the unique primary identifier for the ct_rule_detail table. It is an internal assigned system number. |
CT_RULE_ID | DOUBLE | N | This the unique primary identifier for the ct_rule table. |
DETAIL_TYPE_CD | DOUBLE | N | Value from 15729 that indicates whether or not a charge is a PRECURSOR or RESULT. |
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. |
OPERATOR_CD | DOUBLE | N | Value from 18849 that indicates either multiply, subtract, equal, add, and or or. |
PRECEDENCE | DOUBLE | Y | Indicates the priority of the rule detail. |
RESULT_FACTOR | DOUBLE | Y | Holds the value for the REPLACEPRICE or the REPLACEADJUST. |
RULE_ENTITY_ID | DOUBLE | N | Depending on the rule_entity_name, this field either holds the nomen_id from the nomenclature table for a particular orderable, or the bill_item_id from the bill_item table.. |
RULE_ENTITY_NAME | VARCHAR(32) | Y | Either NOMENCLATURE or BILLITEM. |
SEQUENCE | DOUBLE | Y | The order by which the NOMENCLATURE or BILLITEM types were entered. |
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. |
FAV_FOLDER_CAT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Favorites Folders |
Definition: | This table stores the parent level user defined folders. |
Table Type: | REFERENCE |
Column Detail - FAV_FOLDER_CAT
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. |
CHILD_CAT_IND | DOUBLE | N | Child category indicator |
DESCRIPTION | VARCHAR(200) | N | Description |
FAV_FOLDER_CAT_ID | DOUBLE | N | Favorites Folder Category ID |
LOGICAL_DOMAIN_ID | DOUBLE | N | The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table. |
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. |
Relationship Detail - FAV_FOLDER_CAT
Child Column in FAV_FOLDER_CAT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LOGICAL_DOMAIN_ID | LOGICAL_DOMAIN | LOGICAL_DOMAIN_ID |