Table Detail Report
PFT_COMBINE_RULE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PFT Combine Rule |
Definition: | This table is used to store rule information that triggered the combine operation. |
Table Type: | ACTIVITY |
Column Detail - PFT_COMBINE_RULE
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. |
PFT_COMBINE_LOG_ID | DOUBLE | Y | Uniquely identifies the related row on the PFT_COMBINE_LOG table. |
PFT_COMBINE_RULE_ID | DOUBLE | N | A system generated identifier used to uniquely identify a row on the PFT_COMBINE_RULE table. |
RULE_DESC | VARCHAR(350) | Y | Rule description of the external system that triggered the combine operation |
RULE_IDENT | VARCHAR(200) | Y | Rule Identifier of the external system that triggered the combine operation. Rule Identifier and Rule Version properties uniquely identifies the financial combine rule of the external system. |
RULE_VERSION_TXT | VARCHAR(200) | Y | Rule version of the external system that triggered the combine operation. Rule Identifier and Rule Version properties uniquely identifies the financial combine rule of the external system. |
UPDT_APPLCTX | DOUBLE | Y | 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 | Y | 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 | Y | 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 | Y | 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 | Y | 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 - PFT_COMBINE_RULE
Child Column in PFT_COMBINE_RULE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PFT_COMBINE_LOG_ID | PFT_COMBINE_LOG | PFT_COMBINE_LOG_ID |
PFT_COMPARE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PFT COMPARE |
Definition: | This table is used to evaluate multiple criteria. |
Table Type: | ACTIVITY |
Column Detail - PFT_COMPARE
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. |
BILLING_ENTITY_ID | DOUBLE | N | Foreign Key from the billing_entity table |
COMPARE_TYPE_CD | DOUBLE | N | Codified type of comparison. Code Set. |
PFT_COMPARE_ID | DOUBLE | N | Primary key : built from pft_ref_seq. |
PRIMARY_ENTITY_NAME | VARCHAR(40) | N | Name of the type of Primary Criterion. |
PRIMARY_ENTITY_NBR | DOUBLE | N | Primary Criteria Code Value. |
RESULT_NBR | DOUBLE | Y | Numeric result value. |
RESULT_STR | VARCHAR(255) | Y | Alpha-numeric result value. |
SECONDARY_ENTITY_NAME | VARCHAR(40) | Y | Secondary criteria code value. |
SECONDARY_ENTITY_NBR | DOUBLE | N | Name of the type of secondary criterion. |
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 - PFT_COMPARE
Child Column in PFT_COMPARE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | BILLING_ENTITY_ID | BILLING_ENTITY | BILLING_ENTITY_ID |
PFT_CONFIG
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | ProFit Configuration |
Definition: | This table will store configuration information |
Table Type: | REFERENCE |
Column Detail - PFT_CONFIG
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. |
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. |
INFO_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. |
INFO_DOMAIN_TXT | VARCHAR(100) | Y | A textual name of the domain. |
INFO_DT_TM | DATETIME | Y | Stores the date and time when the value is a date |
INFO_NAME | VARCHAR(255) | Y | Stores the name when the value portion is a name. |
INFO_NBR | DOUBLE | Y | Stores the number when the value is a number. |
INFO_TXT | VARCHAR(4000) | Y | Stores the text when the value is a text. |
PFT_CONFIG_ID | DOUBLE | N | Unique generated number that identifies a single row on the PFT_CONFIG 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 - PFT_CONFIG
Child Column in PFT_CONFIG(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | INFO_DOMAIN_ID | LOGICAL_DOMAIN | LOGICAL_DOMAIN_ID |
PFT_DAILY_BALANCE_BAL
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Daily Balance |
Definition: | This table tracks the daily changes to individual insurance balances to perform accounting checks against existing account data. |
Table Type: | ACTIVITY |
Column Detail - PFT_DAILY_BALANCE_BAL
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. |
ADJUSTMENT_AMT | DOUBLE | N | Total adjustments made on this bill rec for this day. |
BEG_BALANCE_AMT | DOUBLE | N | This is the balance amount that this bo_hp was responsible for when this row became effective. |
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 | Uniquely identifies the related billing entity. |
BO_HP_RELTN_ID | DOUBLE | Y | Uniquely identifies the related BO_HP_RELTN record. |
BO_HP_STATUS_CD | DOUBLE | N | The status stored on the parent BO_HP_RELTN table can change as a balance progresses. This contains the historical status of the balance. |
CHARGE_AMT | DOUBLE | N | The amount of the charges posted on this date. |
END_BALANCE_AMT | DOUBLE | N | This is the balance amount that this bo_hp is either currently responsible for, or was responsible for when a new row was written out. |
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. |
ORIG_PFT_DAILY_BALANCE_BAL_ID | DOUBLE | N | Used to track versions of the daily balance 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. |
PAYMENT_AMT | DOUBLE | N | Contains the amount of the related payment. |
PFT_DAILY_BALANCE_BAL_ID | DOUBLE | N | Uniquely identifies individual insurance balances to perform accounting checks against existing account data and to track daily changes.. |
ROLL_IN_AMT | DOUBLE | N | This is the amount that represents a higher sequence health plan transferring monetary responsibility to this health plan. |
ROLL_OUT_AMT | DOUBLE | N | This is the amount that represents a this health plan transferring monetary responsibility to a lower sequence health plan. |
TOTAL_ADJUSTMENT_AMT | DOUBLE | N | Contains the total amount of the adjustment |
TOTAL_CHARGE_AMT | DOUBLE | N | Contains the total amount of the charge. |
TOTAL_PAYMENT_AMT | DOUBLE | N | Contains the total amount of the payment. |
TRANSFER_IN_AMT | DOUBLE | N | This is a generic monetary amount that was transferred in to this health plan. It could be an amalgem of charges, payments, and adjustment amounts. |
TRANSFER_OUT_AMT | DOUBLE | N | This is a generic monetary amount that was transferred away from this health plan. It could be an amalgem of charges, payments, and adjustment amounts. |
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 - PFT_DAILY_BALANCE_BAL
Child Column in PFT_DAILY_BALANCE_BAL(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | BILLING_ENTITY_ID | BILLING_ENTITY | BILLING_ENTITY_ID |
BO_HP_RELTN_ID | BO_HP_RELTN | BO_HP_RELTN_ID |
PFT_DAILY_BILL_BAL
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PFT DAILY BILL BAL |
Definition: | Stores a bill's balance on a daily basis. |
Table Type: | ACTIVITY |
Column Detail - PFT_DAILY_BILL_BAL
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVITY_DT_TM | DATETIME | N | Date and time the bill activity occurred. |
ADJUSTMENT_AMOUNT | DOUBLE | N | Total adjustments made on this bill rec for this day. |
ADJ_DR_CR_FLAG | DOUBLE | N | The debit/credit flag for the adjustment amount.0 |
BEG_BALANCE | DOUBLE | N | Beginning balance for the bill record for this day. |
BEG_DR_CR_FLAG | DOUBLE | N | Debit/credit flag for the beginning balance. |
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. |
BILLED_AMOUNT | DOUBLE | N | Original billed amount of the bill record. |
BILLED_DR_CR_FLAG | DOUBLE | N | Debit/credit flag for the billed amount. |
BILLING_ENTITY_ID | DOUBLE | N | Foreign key reference to the billing_entity table |
BILL_VRSN_NBR | DOUBLE | N | Foreign key to bill record |
CALCULATED_END_BAL | DOUBLE | N | Calculated balance of the bill record for this day. |
CALC_DR_CR_FLAG | DOUBLE | N | Debit/credit flag for the calculated balance. |
CHARGE_AMT | DOUBLE | N | The amount of the charges posted on this date. |
CORSP_ACTIVITY_ID | DOUBLE | N | Along with bill_vrsn_nbr, uniquely identifies a bill record |
END_BALANCE | DOUBLE | N | Ending balance of the bill record for this day. |
END_DR_CR_FLAG | DOUBLE | N | Debit/credit flag for the ending balance. |
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. |
ORIG_BILL_DT_TM | DATETIME | N | The date and time the bill was originally billed. |
PAYMENT_AMOUNT | DOUBLE | N | Total payments made on this bill record for this day. |
PAY_DR_CR_FLAG | DOUBLE | N | Debit/credit flag for the payments. |
PFT_DAILY_BILL_BAL_ID | DOUBLE | N | Unique identifier for the pft_daily_bill_bal table. |
TRANSFER_AMT | DOUBLE | N | Amount of transfer (balance transfer), if applicable. |
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 - PFT_DAILY_BILL_BAL
Child Column in PFT_DAILY_BILL_BAL(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | BILLING_ENTITY_ID | BILLING_ENTITY | BILLING_ENTITY_ID |
BILL_VRSN_NBR | BILL_REC | BILL_VRSN_NBR | |
CORSP_ACTIVITY_ID | BILL_REC | CORSP_ACTIVITY_ID |