Table Detail Report

PFT_CHARGE_BO_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: ProFit Charge Benefit Order Relation
Definition: Identifies a charge(pft_charge_id) as being a member of the charge group identified by benefit_order_id, including any billing information that is specific to this relationship (such as the health plan coverage of the charge for the coordination of benefits represented by the charge group).
Table Type: ACTIVITY





Column Detail - PFT_CHARGE_BO_RELTN


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.
ADJUDICATED_STATUS_CD DOUBLE N Status of adjudication for the charge
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.
BENEFIT_ORDER_ID DOUBLE N FK to the benefit_order table
BILL_TEMPL_ID DOUBLE N FK to the bill_templ table
BT_COND_RESULT_ID DOUBLE N FK to the bt_cond_result table as of iteration 2.2 no longer used
COVERED_BITMAP DOUBLE N This column utilizes bit manipulation to determine whether a charge is covered by the associated health plan.
COVERED_IND DOUBLE Y Covered Indicator
DENIED_IND DOUBLE Y ** obsolete ** This column is no longer used. Denied Indicator
DENIED_REASON_CD DOUBLE N ** obsolete ** This column is no longer used. Denied Reason Code
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.
PFT_CHARGE_BO_RELTN_ID DOUBLE N Primary Key
PFT_CHARGE_ID DOUBLE N FK to the pft_charge table
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_CHARGE_BO_RELTN


Child Column in PFT_CHARGE_BO_RELTN(FK) Parent Table Name Parent Column Name
Parents: BENEFIT_ORDER_ID BENEFIT_ORDER BENEFIT_ORDER_ID
BILL_TEMPL_ID BILL_TEMPL BILL_TEMPL_ID
PFT_CHARGE_ID PFT_CHARGE PFT_CHARGE_ID


PFT_CHRG_GRP_RPRCS



Column Section Relationship Section Top of Page


Table-level Detail

Description: PFT Charge Group Reprocess
Definition: Stores balance information along with encounter details to reprocess through WTP server.
Table Type: ACTIVITY





Column Detail - PFT_CHRG_GRP_RPRCS


Column Name Type Null? Definition
BALANCE_STATUS_TXT VARCHAR(40) Y State of the balance at a particular instance of time
BATCH_REPROCESSING_STATUS_FLAG DOUBLE N Batch reprocessing status as pending,In Progress, Error and Completed.
BENEFIT_ORDER_ID DOUBLE N System defined unique identifier of a benefit order.
BILLING_ENTITY_ID DOUBLE N Uniquely identifies the related Billing Entity.
BILLING_ENTITY_NAME VARCHAR(50) Y Allows for the billing entity to have a different name than the organization that it is related to.
BT_CONDITION_ID DOUBLE N Uniquely identifies each bill template condition.
CHARGE_GROUP_AMT DOUBLE Y The current amount due for this that particular balance.
CHARGE_GROUP_NAME VARCHAR(200) Y Contains the name of a particular bill template condition.
CREATED_ID DOUBLE N Uniquely identifies the related personnel who created the record.
ENCOUNTER_ALIAS_NAME VARCHAR(215) Y Stores the financial encounter's alias which will be used to identify the financial encounter.
ENCOUNTER_BALANCE_AMT DOUBLE Y Balance related to a profit encounter.
ENCOUNTER_STATUS_TXT VARCHAR(40) Y Encounter status identifies the state of a particular encounter type from the time it is initiated until it is complete. (i.e., temporary, preliminary, active, discharged (complete), cancelled).
ENCOUNTER_TYPE_TXT VARCHAR(40) Y Categorizes the encounter into a logical group or type. examples may include inpatient, outpatient, etc.
FAILURE_REASON_FLAG DOUBLE Y If the reprocess fail, this column displays reason why it failed.
HEALTH_PLAN_NAME VARCHAR(100) Y Name of the related health plan.
LOGICAL_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.
PFT_CHRG_GRP_RPRCS_ID DOUBLE N System Generated Number to Uniquely Identify a Row on the PFT_CHRG_GRP_RPRCS table.
PFT_ENCNTR_ID DOUBLE N Uniquely identifies the related profit encounter record
REPORT_FILE_NAME VARCHAR(100) Y Contains file name where for reporting need after reprocess.
REPROCESSING_STATUS_FLAG DOUBLE Y Reprocessing status for each balance like Failure or Success.
SLICE_GRP_VALUE DOUBLE N Load balancing slice number for reprocess using WTP
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.
USER_BATCH_GRP_VALUE DOUBLE N User based batch number for reprocess



Relationship Detail - PFT_CHRG_GRP_RPRCS


Child Column in PFT_CHRG_GRP_RPRCS(FK) Parent Table Name Parent Column Name
Parents: BENEFIT_ORDER_ID BENEFIT_ORDER BENEFIT_ORDER_ID
BT_CONDITION_ID BT_CONDITION BT_CONDITION_ID
LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
PFT_ENCNTR_ID PFT_ENCNTR PFT_ENCNTR_ID
CREATED_ID PRSNL PERSON_ID


PFT_CHRG_GRP_RPRCS_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Profit Charge Group Reprocess History
Definition: Stores historical balances information along with encounter details that were reprocessed through WTP server.
Table Type: ACTIVITY





Column Detail - PFT_CHRG_GRP_RPRCS_HIST


Column Name Type Null? Definition
BALANCE_STATUS_TXT VARCHAR(40) Y State of the balance at a particular instance of time
BATCH_REPROCESSING_STATUS_FLAG DOUBLE N Batch reprocessing status as pending,In Progress, Error and Completed.
BENEFIT_ORDER_ID DOUBLE N System defined unique identifier of a benefit order.
BILLING_ENTITY_ID DOUBLE N Uniquely identifies the related Billing Entity.
BILLING_ENTITY_NAME VARCHAR(50) Y Allows for the billing entity to have a different name than the organization that it is related to.
BT_CONDITION_ID DOUBLE N Uniquely identifies each bill template condition.
CHARGE_GROUP_AMT DOUBLE Y The current amount due for this that particular balance.
CHARGE_GROUP_NAME VARCHAR(200) Y Contains the name of a particular bill template condition.
CREATED_ID DOUBLE N Uniquely identifies the related personnel who created the record.
ENCOUNTER_ALIAS_NAME VARCHAR(215) Y Stores the financial encounter's alias which will be used to identify the financial encounter.
ENCOUNTER_BALANCE_AMT DOUBLE Y Balance related to a profit encounter.
ENCOUNTER_STATUS_TXT VARCHAR(40) Y Encounter status identifies the state of a particular encounter type from the time it is initiated until it is complete. (i.e., temporary, preliminary, active, discharged (complete), cancelled).
ENCOUNTER_TYPE_TXT VARCHAR(40) Y Categorizes the encounter into a logical group or type. examples may include inpatient, outpatient, etc.
FAILURE_REASON_FLAG DOUBLE Y If the reprocess fail, this column displays reason why it failed.
HEALTH_PLAN_NAME VARCHAR(100) Y Name of the related health plan.
LOGICAL_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.
PFT_CHRG_GRP_RPRCS_HIST_ID DOUBLE N System Generated Number Used to Uniquely Identify a Row on PFT_CHRG_GRP_RPRCS_HIST.
PFT_ENCNTR_ID DOUBLE N Uniquely identifies the related profit encounter record
REPORT_FILE_NAME VARCHAR(100) Y Contains file name where for reporting need after reprocess.
REPROCESSING_STATUS_FLAG DOUBLE Y Reprocessing status for each balance like Failure or Success.
SLICE_GRP_VALUE DOUBLE N Load balancing slice number for reprocess using WTP
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.
USER_BATCH_GRP_VALUE DOUBLE N User based batch number for reprocess



Relationship Detail - PFT_CHRG_GRP_RPRCS_HIST


Child Column in PFT_CHRG_GRP_RPRCS_HIST(FK) Parent Table Name Parent Column Name
Parents: BENEFIT_ORDER_ID BENEFIT_ORDER BENEFIT_ORDER_ID
BT_CONDITION_ID BT_CONDITION BT_CONDITION_ID
LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
PFT_ENCNTR_ID PFT_ENCNTR PFT_ENCNTR_ID
CREATED_ID PRSNL PERSON_ID


PFT_CLAIM_RULE



Column Section Relationship Section Top of Page


Table-level Detail

Description: ProFit Claim Rule
Definition: Contains Claim generation rules.
Table Type: REFERENCE





Column Detail - PFT_CLAIM_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.
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.
MEDIA_SUB_TYPE_CD DOUBLE N Identifies the media type to which the rule applies.
PFT_CLAIM_RULE_ID DOUBLE N Uniquely identifies a claim generation rule.
PREV_PFT_CLAIM_RULE_ID DOUBLE N Used to track versions of the claim rule 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.
RULE_DESC VARCHAR(200) Y Textual description of the claim generation rule.
RULE_NAME VARCHAR(100) Y The name of the rule.
RULE_TEMPLATE_ID DOUBLE N Uniquely identifies template information for this claim generation rule.
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_CLAIM_RULE


Child Column in PFT_CLAIM_RULE(FK) Parent Table Name Parent Column Name
Parents: RULE_TEMPLATE_ID LONG_BLOB_REFERENCE LONG_BLOB_ID


PFT_CLAIM_STATUS_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: ProFit Claim Status History
Definition: Contains the history of changes to claim status and sub status (status reason)
Table Type: ACTIVITY





Column Detail - PFT_CLAIM_STATUS_HIST


Column Name Type Null? Definition
ACTIVITY_DT_TM DATETIME N The current date/time of the system that inserted the row.
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_EVENT_STATUS_FLAG DOUBLE N Identifies whether the event status is:0 - N/A1 - In Process2 - Failed3 - Success
CLAIM_STATUS_CD DOUBLE N Primary status of the claim (bill_status_cd on the bill_rec.
CLAIM_SUB_STATUS_CD DOUBLE N The secondary status of the claim (bill_status_reason_cd on the bill_rec.
CORSP_ACTIVITY_ID DOUBLE N Identifies the related claim identifier from the bill_rec 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.
EXTERNAL_IDENT VARCHAR(250) Y The external identifier is the unique identifier for an edi transaction for various payment types.
LONG_TEXT_ID DOUBLE N Uniquely identifies a message specific to an event.
PFT_CLAIM_STATUS_HIST_ID DOUBLE N Uniquely identifiesa change to the claim status and sub status for a bill rec.
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_CLAIM_STATUS_HIST


Child Column in PFT_CLAIM_STATUS_HIST(FK) Parent Table Name Parent Column Name
Parents: LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID