Table Detail Report

BT_SELECTION_CRIT



Column Section Relationship Section Top of Page


Table-level Detail

Description: BILL TEMPLATE SELECTION CRITERIA
Definition: This table stores bill template selection criteria information
Table Type: REFERENCE





Column Detail - BT_SELECTION_CRIT


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 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.
BT_SELECTION_CRIT_ID DOUBLE N Unique identifier of table
BT_SELECTION_ID DOUBLE N Foreign key to bt_selection table
CRITERIA_CD DOUBLE N Criteria of Billing Entity, Fin Class, Insurance Org.,Health Plan, or Encntr Type. From the bill template selection criteria code set.
CRITERIA_TYPE_CD DOUBLE N Criteria type of Codeset, Custom, Date, Enum, ID, String.
CRITERIA_VALUE VARCHAR(50) Y The value of the criteria represented by the criteria_cd
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.
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 - BT_SELECTION_CRIT


Child Column in BT_SELECTION_CRIT(FK) Parent Table Name Parent Column Name
Parents: BT_SELECTION_ID BT_SELECTION BT_SELECTION_ID


CBOS_PERSON_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Consolidated Benefit Order Schedule Person Relationship
Definition: Relates a Consolidated Benefit Order Schedule record to one or more Person.
Table Type: ACTIVITY





Column Detail - CBOS_PERSON_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 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.
CBOS_PERSON_RELTN_ID DOUBLE N Unique generated number that identifies a single row on the CBOS_PERSON_RELTN table.
CONS_BO_SCHED_ID DOUBLE N This is the consolidated benefit order schedule for this person relation.
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.
FIRST_PROCESS_DT_TM DATETIME N The date/time that the first ETL process started that created this record.
LAST_PROCESS_DT_TM DATETIME N The date/time that the last ETL process started that updated this record.
ORGANIZATION_ID DOUBLE N This is the value of the unique primary identifier of the orgaization table. It is an internal system assigned number.
PERSON_ID DOUBLE N Uniquely identifies the related person.
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 - CBOS_PERSON_RELTN


Child Column in CBOS_PERSON_RELTN(FK) Parent Table Name Parent Column Name
Parents: CONS_BO_SCHED_ID CONS_BO_SCHED CONS_BO_SCHED_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PERSON_ID PERSON PERSON_ID


CBOS_PE_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Consolidated Benefit Order Schedule ProFit Encounter Relationship
Definition: Relates a consolidated benefit order schedule record to a ProFit Encounter and its respective Statement Cycle and Dunning Level information.
Table Type: ACTIVITY





Column Detail - CBOS_PE_RELTN


Column Name Type Null? Definition
ACCT_ID DOUBLE N Contains the guarantor account id responsible for the consolidated benefit order schedule - financial encounter relationship.
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.
BALANCE_AMT DOUBLE N The balance amount related to a ProFit Encounter.
CBOS_PE_RELTN_ID DOUBLE N A Unique generated number that identifies a single row on the CBOS_PE_RELTN table.
CONSOLIDATION_IND DOUBLE N Indicator that this guarantor's financial responsibility for encounter is excluded from a consolidation statement.
CONS_BO_SCHED_ID DOUBLE N Uniquely identifies the related consolidated benefit order schedule.
DR_CR_FLAG DOUBLE N Flag identifying the whether the balance is debit or credit.0 - Not Defined; 1 - Credit; 2 - Debit
DUNNING_HOLD_IND DOUBLE N Indicates if this financial encounter remains at the same dunning level regardless of other criteria.
DUNNING_IND DOUBLE N Indicator that this financial encounter is excluded from dunning messages.
DUNNING_LEVEL_CD DOUBLE N Code value indicating collections state that a financial encounter is in.
DUNNING_LEVEL_CHANGE_DT_TM DATETIME Y Date the dunning level was changed by the bill record generation process.
DUNNING_LEVEL_CNT DOUBLE Y Indicates how many times a bill has been sent at the current dunning level code.
DUNNING_NO_PAY_CNT DOUBLE Y The number of times that no payment has been received at this dunning level.
DUNNING_PAY_CNT DOUBLE Y The number of times that an acceptable payment has been received at this dunning level.
DUNNING_UNACC_PAY_CNT DOUBLE Y The number of times that an unacceptable payment has been received at this dunning level.
INS_PEND_BAL_FWD_AMT DOUBLE N The amount of insurance pending that is being pulled forward at the pft_encntr level to the next month's statement.
LAST_STMT_DT_TM DATETIME Y Date of the last Statement made against this encounter.
ORIG_BILL_DT_TM DATETIME Y The date that the original bill was generated.
PAT_BAL_FWD_AMT DOUBLE N The amount the patient owes at the pft_encntr level that is being pulled forward to the next month's statement.
PAYMENT_PLAN_FLAG DOUBLE N Defines the Payment Plan. 1 - Informal Payment Plan; 2 - Formal Payment Plan
PAYMENT_PLAN_STATUS_CD DOUBLE N This field defines the status of the payment plan.
PFT_ENCNTR_ID DOUBLE N Uniquely identifies the related ProFit Encounter
STATEMENT_CYCLE_ID DOUBLE N Uniquely identifies the related Statement Cycle.
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 - CBOS_PE_RELTN


Child Column in CBOS_PE_RELTN(FK) Parent Table Name Parent Column Name
Parents: ACCT_ID ACCOUNT ACCT_ID
CONS_BO_SCHED_ID CONS_BO_SCHED CONS_BO_SCHED_ID
PFT_ENCNTR_ID PFT_ENCNTR PFT_ENCNTR_ID
STATEMENT_CYCLE_ID STATEMENT_CYCLE STATEMENT_CYCLE_ID




Parent Column in CBOS_PE_RELTN (PK) Child Table Name Child Column Name
Children: CBOS_PE_RELTN_ID CBOS_ACTIVITY_RELTN CBOS_PE_RELTN_ID
EXT_PAY_PLAN_PE_RELTN CBOS_PE_RELTN_ID
PFT_BAD_DEBT_BAL CBOS_PE_RELTN_ID
PFT_PAY_PLAN_PE_RELTN CBOS_PE_RELTN_ID


CHRG_GRP_EXCEPTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table holds health plan relationship exceptions
Definition: This table holds health plan relationships that are exceptions to the normal Charge Grouping logic.
Table Type: REFERENCE





Column Detail - CHRG_GRP_EXCEPTION


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 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.
BILLING_ENTITY_ID DOUBLE N Foreign key to the billing entity table to identify the billing entity for this relationship
CHRG_GRP_EXCEPTION_ID DOUBLE N The unique identifier to this 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.
PRIMARY_HP_ID DOUBLE N Foreign key to the health_plan table to identify the primary health plan for this relationship
PRIMARY_INS_ORG_ID DOUBLE N Foreign key to the organization table to identify the primary insurance org for this relationship
SECONDARY_HP_ID DOUBLE N Foreign key to the health plan table to identify the secondary health plan for this relationship
SECONDARY_INS_ORG_ID DOUBLE N Foreign key to the organization table to identify the secondary insurance organization for this relationship
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 - CHRG_GRP_EXCEPTION


Child Column in CHRG_GRP_EXCEPTION(FK) Parent Table Name Parent Column Name
Parents: BILLING_ENTITY_ID BILLING_ENTITY BILLING_ENTITY_ID
PRIMARY_HP_ID HEALTH_PLAN HEALTH_PLAN_ID
SECONDARY_HP_ID HEALTH_PLAN HEALTH_PLAN_ID
PRIMARY_INS_ORG_ID ORGANIZATION ORGANIZATION_ID
SECONDARY_INS_ORG_ID ORGANIZATION ORGANIZATION_ID


CLAIM_FLD_POSITION



Column Section Relationship Section Top of Page


Table-level Detail

Description: CLAIM FLD POSITION
Definition: Stores the claim position of field attribute on a claim.
Table Type: REFERENCE





Column Detail - CLAIM_FLD_POSITION


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.
CLAIM_FLD_POSITION_ID DOUBLE N Primary Key
DEVICE_CD DOUBLE N Foreign key to the device 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.
FIELD_CATALOG_ID DOUBLE N Foreign key reference to the field_catalog table.
FIELD_HEIGHT DOUBLE Y Height of the field.
FIELD_LEFT DOUBLE Y X cordinate of the field position.
FIELD_TOP DOUBLE Y Y cordinate of the field position.
FIELD_WIDTH DOUBLE Y Width of the field.
FORMAT_BILL_TYPE_CD DOUBLE N Stores a code value for the secondary formatting_bill_type of the claim object. In other words, a 1500 can be formatted as a MA319, even though it is a 1500.
LINE_ITEM_OFFSET DOUBLE Y Line Item Offset
PAPER_TYPE_FLAG DOUBLE Y Indicates the type of paper to be used for printing.
PRINT_TRAY DOUBLE Y Physical paper tray to print to
PRINT_TRAY_CD DOUBLE N The code value corresponding to the print tray
QUEUE_NAME VARCHAR(40) Y Output destination to send job to
QUEUE_NAME_KEY VARCHAR(40) Y Indexed field for queue name
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 - CLAIM_FLD_POSITION


Child Column in CLAIM_FLD_POSITION(FK) Parent Table Name Parent Column Name
Parents: FIELD_CATALOG_ID FIELD_CATALOG FIELD_CATALOG_ID