Table Detail Report

PFT_AR_CONV_INFO



Column Section Relationship Section Top of Page


Table-level Detail

Description: PFT AR CONV INFO
Definition: This table holds default data necessary for the AR Data Conversion.
Table Type: REFERENCE





Column Detail - PFT_AR_CONV_INFO


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 Related Billing Entity for this record.
CONVERSION_DATE DATETIME Y Date value for conversion purposes.
CONVERSION_NBR DOUBLE Y Numeric Value necessary for conversion purposes.
CONVERSION_NUMBER DOUBLE Y Numeric Value necessary for conversion purposes.
CONVERSION_STRING VARCHAR(250) Y Alpha Value necessary for conversion purposes.
CONVERSION_TYPE VARCHAR(20) Y The type of data being stored for this entry for the conversion.
PFT_AR_CONV_INFO_ID DOUBLE N Unique Identifier
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_AR_CONV_INFO


Child Column in PFT_AR_CONV_INFO(FK) Parent Table Name Parent Column Name
Parents: BILLING_ENTITY_ID BILLING_ENTITY BILLING_ENTITY_ID


PFT_AR_CONV_TRANS



Column Section Relationship Section Top of Page


Table-level Detail

Description: PFT AR CONV TRANS
Definition: Converted Transaction data from a legacy system.
Table Type: ACTIVITY





Column Detail - PFT_AR_CONV_TRANS


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.
AMOUNT DOUBLE Y OBSOLETE - No longer used
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
HEALTH_PLAN_ID DOUBLE N Related Health Plan information.
PFT_AR_CONV_TRANS_ID DOUBLE N Unique Identifier.
POSTED_DATE DATETIME Y Date that the transaction was originally posted in the legacy system.
SERVICE_DATE DATETIME Y Date of Service from the legacy system.
TRANSACTION_ALIAS_CD DOUBLE N Transaction Alias Code
TRANSACTION_IDENT VARCHAR(100) Y Unique identifier from the legacy system for this transaction.
TRANSACTION_TYPE_CD DOUBLE N Transaction Type Code
TRANS_AMT DOUBLE Y Transaction Amount
TRANS_REASON_CD DOUBLE N Code value identifying the transaction reason.
TRANS_SUB_TYPE_CD DOUBLE N Transaction Sub Type Code
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_AR_CONV_TRANS


Child Column in PFT_AR_CONV_TRANS(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
HEALTH_PLAN_ID HEALTH_PLAN HEALTH_PLAN_ID


PFT_BAD_DEBT_BAL



Column Section Relationship Section Top of Page


Table-level Detail

Description: ProFit Bad Debt Balance
Definition: Contains a daily balance of all bad debt transaction information.
Table Type: ACTIVITY





Column Detail - PFT_BAD_DEBT_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.
ACTIVITY_DT_TM DATETIME Y Represents the last date and time a transaction was posted to the encounter.
ADJUSTMENT_AMT DOUBLE N The total adjustment amount for the given activity date.
ADJ_DR_CR_FLAG DOUBLE N The total adjustment amount debit credit flag for the given activity date. 0 - Not Specified, 1 - Debit, 2 - Credit
BEG_BALANCE_AMT DOUBLE N The opening balance for the given activity date copied from the previous activities days end_balance_dt_tm.
BEG_DR_CR_FLAG DOUBLE N The beginning balance debit/credit flag. 0 - Not Specified; 1 - Debit; 2 - Credit
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_PE_RELTN_ID DOUBLE N Uniquely identifies the related row on the CBOS_PE_RELTN table.
END_BALANCE_AMT DOUBLE N Contains the ending balance amount for the given activity date.
END_DR_CR_FLAG DOUBLE N Ending balance debit/credit flag. Total ending balance flag. 0 - Not Specified; 1 - Debit; 2 - Credit
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.
PAYMENT_AMT DOUBLE N Contains the total payment amount for the given activity date.
PAY_DR_CR_FLAG DOUBLE N Contains the total payment amount debit credit flag for the given activity date. 0 - Not Specified; 1 - Debit; 2 - Credit
PFT_BAD_DEBT_BAL_ID DOUBLE N Unique generated number that identifies a single row on the PFT_BAD_DEBT_BAL table.
PFT_ENCNTR_ID DOUBLE N Uniquely identifies the related ProFit Encounter.
TOTAL_ADJUSTMENT_AMT DOUBLE N A running total of adjustmens for the associated profit encounter up to and including this activity date and time.
TOTAL_PAYMENT_AMT DOUBLE N A running total of payments for the associated profit encounter up to and including this activity date and time.
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_BAD_DEBT_BAL


Child Column in PFT_BAD_DEBT_BAL(FK) Parent Table Name Parent Column Name
Parents: CBOS_PE_RELTN_ID CBOS_PE_RELTN CBOS_PE_RELTN_ID
PFT_ENCNTR_ID PFT_ENCNTR PFT_ENCNTR_ID


PFT_BALANCE



Column Section Relationship Section Top of Page


Table-level Detail

Description: ProFit Balance
Definition: Financial information tracking money owed, by whom, state/status.
Table Type: ACTIVITY





Column Detail - PFT_BALANCE


Column Name Type Null? Definition
ACCT_ID DOUBLE N Account of the associated balance
ADJUSTMENT_AMT DOUBLE N Adjustments for the effective day
ADMIT_PRSNL_ID DOUBLE N Admitting personnel associated with the patient encounter
BALANCE_STATE_CD DOUBLE N Current state of the associated balance
BALANCE_TYPE_CD DOUBLE N Identifies the level for which the balance is maintained, e.g., Bill, Line Item.
BEG_BALANCE_AMT DOUBLE N Balance at beginning of day
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.
BEG_SERVICE_DT_TM DATETIME Y Datetime service began
BILLING_ENTITY_ID DOUBLE N Billing Entity which claims processing is being defined.
BILL_DT_TM DATETIME Y First submission/transmission datetime for associated bill
BILL_TYPE_CD DOUBLE N Type of bill for associated balance
BILL_VRSN_NBR DOUBLE N Version number of the associated bill record
BO_HP_RELTN_ID DOUBLE N Identifies the associated BO_HP_RELTN to the BO_HP balance this day
CHARGE_AMT DOUBLE N Charges for the effective day
CLIENT_ORG_ID DOUBLE N Organization of responsible client
CORSP_ACTIVITY_ID DOUBLE N Identifies the associated bill record
ENCNTR_TYPE_CLASS_CD DOUBLE N Further categorization of patients into general groups (i.e., inpatient, outpatient, emergency, recurring outpatient).
END_BALANCE_AMT DOUBLE N Current 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.
END_SERVICE_DT_TM DATETIME Y Datetime service ended
GUARANTOR_PERSON_ID DOUBLE N Guarantor/person responsible for the balance
INTERIM_BILL_DT_TM DATETIME Y Transmission date and time of the interim bill.
LAST_PAYMENT_DT_TM DATETIME Y Datetime of last payment against this balance
PATIENT_RESP_AMT DOUBLE N Patient responsibility for the day
PAYER_TYPE_CD DOUBLE N Type of payer associated to the bill, e.g., Selfpay, Insurance, Client, Unidentified
PAYMENT_AMT DOUBLE N Payments for the effective day
PERFORM_PRSNL_ID DOUBLE N Performing personnel associated to the patient encounter
PERSON_ID DOUBLE N Patient associated to the encounter
PFT_BALANCE_ID DOUBLE N Uniquely identifies the financial information, tracking money owed, by whom, and state/status
PFT_CHARGE_ID DOUBLE N Physician office charge associated to the balance
PFT_ENCNTR_ID DOUBLE N Financial encounter associated to the balance
PREV_BALANCE_ID DOUBLE N Previous balance that associated to the financial information, tracking money owed, by whom, and state/status
TOTAL_ADJUSTMENT_AMT DOUBLE N Total adjustments for the balance
TOTAL_CHARGE_AMT DOUBLE N Total charges for the balance
TOTAL_PATIENT_RESP_AMT DOUBLE N Total patient responsibility for the balance
TOTAL_PAYMENT_AMT DOUBLE N Total payments for the balance
TOTAL_TRANSFER_AMT DOUBLE N Total transfers for the balance
TRANSFER_AMT DOUBLE N Transfers (eob remainders, non-covered) for the effective day
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.
ZERO_BALANCE_DT_TM DATETIME Y Datetime the balance reached 0.0



Relationship Detail - PFT_BALANCE


Child Column in PFT_BALANCE(FK) Parent Table Name Parent Column Name
Parents: ACCT_ID ACCOUNT ACCT_ID
BILLING_ENTITY_ID BILLING_ENTITY BILLING_ENTITY_ID
BILL_VRSN_NBR BILL_REC BILL_VRSN_NBR
CORSP_ACTIVITY_ID BILL_REC CORSP_ACTIVITY_ID
BO_HP_RELTN_ID BO_HP_RELTN BO_HP_RELTN_ID
CLIENT_ORG_ID ORGANIZATION ORGANIZATION_ID
GUARANTOR_PERSON_ID PERSON PERSON_ID
PERSON_ID PERSON PERSON_ID
PREV_BALANCE_ID PFT_BALANCE PFT_BALANCE_ID
PFT_CHARGE_ID PFT_CHARGE PFT_CHARGE_ID
PFT_ENCNTR_ID PFT_ENCNTR PFT_ENCNTR_ID
ADMIT_PRSNL_ID PRSNL PERSON_ID
PERFORM_PRSNL_ID PRSNL PERSON_ID




Parent Column in PFT_BALANCE (PK) Child Table Name Child Column Name
Children: PFT_BALANCE_ID PE_STATUS_REASON PFT_BALANCE_ID
PFT_BALANCE PREV_BALANCE_ID
PFT_BILL_ACTIVITY PFT_BALANCE_ID
PFT_QUEUE_ITEM PFT_BALANCE_ID
TRANS_LOG CREDIT_BALANCE_ID
TRANS_LOG DEBIT_BALANCE_ID


PFT_DAILY_BO_HP_CHRG_BAL



Column Section Relationship Section Top of Page


Table-level Detail

Description: ProFit Daily Benefit Order Health Plan Charge Balance
Definition: Maintains a daily balance for a charge associated to a Benefit Order Health Plan
Table Type: ACTIVITY





Column Detail - PFT_DAILY_BO_HP_CHRG_BAL


Column Name Type Null? Definition
ACTIVITY_DT_TM DATETIME N Date of the activity applied to the BO_HP_RELTN.
ADJUSTMENT_AMT DOUBLE N The amount of the adjustments posted on this date.
BEG_BALANCE_AMT DOUBLE N Beginning balance amount as related to the BOHP charge
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.
BO_HP_RELTN_ID DOUBLE N Identifies the associated BO_HP_RELTN to the BO_HP balance this day
CHARGE_AMT DOUBLE N The amount of the charges posted on this date.
DENIAL_AMT DOUBLE N Amount of the denial, if applicable.
END_BALANCE_AMT DOUBLE N End balance amount
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.
NON_COVERED_AMT DOUBLE N Amount not covered
PAT_RESP_AMT DOUBLE N Amount responsible to patient
PAYMENT_AMT DOUBLE N Payment Amount
PFT_CHARGE_ID DOUBLE N Identifies the associated charge
PFT_DAILY_BO_HP_CHRG_BAL_ID DOUBLE N Identifies a daily benefit order health plan charge
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_BO_HP_CHRG_BAL


Child Column in PFT_DAILY_BO_HP_CHRG_BAL(FK) Parent Table Name Parent Column Name
Parents: BO_HP_RELTN_ID BO_HP_RELTN BO_HP_RELTN_ID
PFT_CHARGE_ID PFT_CHARGE PFT_CHARGE_ID