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 |