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 |