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