Table Detail Report

CSOPS_SUMM



Column Section Top of Page


Table-level Detail

Description: CS Operations Summary
Definition: This table holds an audit of all the runs of the Charge Services interface scripts.
Table Type: ACTIVITY





Column Detail - CSOPS_SUMM


Column Name Type Null? Definition
AMOUNT DOUBLE Y Sum of the prices of all the charges for the job_name_cd and interface_file_id on that row.
BATCH_NUM DOUBLE Y The batch number of the charges for that job_name_cd and interface_file_id. The batch_num comes from the batch_num field on the interface_charge table.
CHARGE_TYPE_CD DOUBLE N This value will be the code value from code set 13028 with a cdf_meaning of DEBIT or CREDIT.
CSOPS_SUMM_ID DOUBLE N This is the value of the unique primary identifier of the csops_summ table. It is an internal system assigned number.
END_DT_TM DATETIME Y This field holds the date and time that the job_name_cd completed.
INTERFACE_FILE_ID DOUBLE N This field holds the interface_file_id from the interface_file table for the charges that were processed by the job_name_cd.
JOB_NAME_CD DOUBLE N This field holds the code value from code set 25632 that tells what script was running for this particular row.
JOB_STATUS VARCHAR(1) Y This field either holds the value of F for failure, S for success or Z for nothing processed, depending on the status that the job_name_cd returns.
QUANTITY DOUBLE Y This field holds the sum of all the quantities of the charges for the job_name_cd and interface_file_id.
RAW_COUNT DOUBLE Y This field holds the number of charge rows that were processed by the job_name_cd.
SEQUENCE DOUBLE Y If the job_name_cd is AFC_RUN_CUSTOM and the interface_file_id has the hl7_ind checked, then the charges were processed in batches of 1000. This field holds the sequentialnumber of that batch. So if it is the first batch of 1000 charges, this field would contain a value of 1.
START_DT_TM DATETIME Y This field holds the date and time that the job_name_cd started.


CS_CPP_ERROR_LOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Charge Services - Charge Preprocessor Error Log
Definition: Contains error records produced from the charge services preprocessor.
Table Type: ACTIVITY





Column Detail - CS_CPP_ERROR_LOG


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.
CS_CPP_ERROR_LOG_ID DOUBLE N Uniquely identifies an error log entry.
CS_CPP_RULESET_ID DOUBLE N Uniquely identifies the ruleset related to this error log entry.
CS_CPP_RULE_ID DOUBLE N Uniquely Identifies the rule related to there is error log entry.
ENCNTR_ID DOUBLE N Uniquely identifies the encounter related to this error log entry.
ERROR_DT_TM DATETIME N The date and time of the error.
ERROR_TEXT VARCHAR(200) N Contains the description of the error that occurred for a particular rule.
PERSON_ID DOUBLE N Uniquely identifies the person related to this error log entry.
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 - CS_CPP_ERROR_LOG


Child Column in CS_CPP_ERROR_LOG(FK) Parent Table Name Parent Column Name
Parents: CS_CPP_RULE_ID CS_CPP_RULE CS_CPP_RULE_ID
CS_CPP_RULESET_ID CS_CPP_RULESET CS_CPP_RULESET_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID


CS_CPP_RULE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Charge Services - Charge Preprocessor Rule
Definition: Contains the rule information for the new Charge Preprocessor framework.
Table Type: REFERENCE





Column Detail - CS_CPP_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.
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.
CHARGE_STATUS_IND DOUBLE N Indicates the rule will ignore the charge status of other charges on each encounter or not. 0 -No, 1-Yes.
CS_CPP_RULESET_ID DOUBLE N Uniquely identifies the ruleset related to this rule.
CS_CPP_RULE_ID DOUBLE N Uniquely identifies rule information for the Charge Preprocessor framework.
LONG_TEXT_ID DOUBLE N Uniquely identifies text related to this rule.
PRIORITY_NBR DOUBLE N The execution priority of a rule inside its associated ruleset.
PROCESS_IND DOUBLE N Indicates whether to process this rule or not. 0 - No, 1 - Yes
RULE_BEG_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.
RULE_END_DT_TM DATETIME N The date and time after which the row is no longer valid as active current data. This may be valued with the date and time the row became inactive.
RULE_NAME VARCHAR(100) N The name of the rule. This is unique per ruleset.
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 - CS_CPP_RULE


Child Column in CS_CPP_RULE(FK) Parent Table Name Parent Column Name
Parents: CS_CPP_RULESET_ID CS_CPP_RULESET CS_CPP_RULESET_ID
LONG_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID




Parent Column in CS_CPP_RULE (PK) Child Table Name Child Column Name
Children: CS_CPP_RULE_ID CS_CPP_ERROR_LOG CS_CPP_RULE_ID


CS_CPP_RULESET



Column Section Relationship Section Top of Page


Table-level Detail

Description: Charge Services - Charge Preprocessor Ruleset
Definition: Contains the ruleset information linking the rule to the tier in the new Charge Preprocessor framework. Also stores change history of the table.
Table Type: REFERENCE





Column Detail - CS_CPP_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.
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.
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.
CS_CPP_RULESET_ID DOUBLE N Uniquely identifies a Charge Services - Charge preprocessor ruleset.
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.
PREV_CS_CPP_RULESET_ID DOUBLE N This field is used to track versions of the charge services - charge preprocessor ruleset information. This field will always point back to the initial value created. This may be used to find the correct version when combined with begin and end effective dates and times.
PROCESS_IND DOUBLE N Indicates whether to process this ruleset or not. 0 - No, 1 - Yes.
RULESET_NAME VARCHAR(100) N Contains the unique name of a ruleset.
RULESET_NAME_KEY VARCHAR(100) N This contains the same value as the ruleset name except it is in all caps and has no spaces or special characters.
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 - CS_CPP_RULESET


Child Column in CS_CPP_RULESET(FK) Parent Table Name Parent Column Name
Parents: PREV_CS_CPP_RULESET_ID CS_CPP_RULESET CS_CPP_RULESET_ID




Parent Column in CS_CPP_RULESET (PK) Child Table Name Child Column Name
Children: CS_CPP_RULESET_ID CS_CPP_ERROR_LOG CS_CPP_RULESET_ID
CS_CPP_RULE CS_CPP_RULESET_ID
CS_CPP_RULESET PREV_CS_CPP_RULESET_ID


CS_CPP_TIER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Charge Services - Charge Preprocessor Tier
Definition: Tier information for the pre-qualification of charges for the new charge preprocessor framework prior to running rules.
Table Type: REFERENCE





Column Detail - CS_CPP_TIER


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_DT_TM DATETIME N The date and time that the active_status_cd was set.
CHARGE_STATUS_IND DOUBLE N Indicates the rule will ignore the charge status of other charges on each encounter or not. 0 -No, 1-Yes
CS_CPP_RULESET_ID DOUBLE N Uniquely identifies the ruleset related to this tier.
CS_CPP_TIER_ID DOUBLE N Uniquely identifies a charge preprocessor tier.
ENCNTR_TYPE_CD DOUBLE N Encounter type of the patient. This column is OBSOLETE.
ENCNTR_TYPE_CLASS_EXCLD_IND DOUBLE N Specifies whether to use the encntr_type_class_detail as a tier qualifier.
ENCNTR_TYPE_EXCLD_IND DOUBLE N Specifies whether to use the encntr_type_cd as a tier quailifier or to qualify all encounter types except the one specified. (0 = Don't Exclude, 1 = Do Exclude)
FIN_CLASS_CD DOUBLE N Contains the Financial Class of the patient. This column is OBSOLETE.
FIN_CLASS_EXCLD_IND DOUBLE N Specifies whether to use the fin_class_cd as a tier quailifier or to qualify all financial classes except the one specified. (0 = Don't Exclude, 1 = Do Exclude)
HEALTH_PLAN_EXCLD_IND DOUBLE N Specifies whether to use the health_plan_id as a tier quailifier or to qualify all health plans except the one specified. (0 = Don't Exclude, 1 = Do Exclude)
HEALTH_PLAN_ID DOUBLE N Uniquely identifies the Health Plan related to this Tier. This column is OBSOLETE.
INS_ORG_EXCLD_IND DOUBLE N Specifies whether to use the ins_org_id as a tier quailifier or to qualify all insurance organizations except the one specified. (0 = Don't Exclude, 1 = Do Exclude)
INS_ORG_ID DOUBLE N Uniquely identifies the Insurance Organization related to this tier. This column is OBSOLETE.
ORGANIZATION_EXCLD_IND DOUBLE N Specifies whether to use the Organization_ID as a tier quailifier or to qualify all organizations except the one specified. (0 = Don't Exclude, 1 = Do Exclude)
ORGANIZATION_ID DOUBLE N Uniquely Identifies the organization related to this tier. This column is OBSOLETE.
PRIORITY_NBR DOUBLE N The execution priority.
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 - CS_CPP_TIER




Parent Column in CS_CPP_TIER (PK) Child Table Name Child Column Name
Children: CS_CPP_TIER_ID CS_CPP_TIER_DETAIL CS_CPP_TIER_ID