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