| pfr_id | int(11) | NO | | PRI | auto_increment | |
| pfr_cus_id | int(11) | NO | | MUL | | Customer ID# if intended for customer view |
| pfr_cli_id | int(11) | NO | | MUL | | Client ID# if intended for client view |
| pfr_pat_id | int(11) | NO | | MUL | | Patient ID# |
| pfr_annual_income | int(11) | YES | | | | annual income of patient in dollar amount |
| pfr_annual_income_unknown | int(1) | YES | 0 | | | Annual Income is Unknown |
| pfr_household_members | tinyint(4) | NO | 0 | | | count of members (including self) in patient's household |
| pfr_min_due_amount | decimal(12,2) | NO | | | | Client defined minimum amount a patient must pay |
| pfr_annual_income_verify_date | date | YES | | | | annual income of verification date |
| pfr_pat_bal | decimal(12,2) | NO | 0.00 | | | Current amount owed by patient (All claim ready charges remaining total whose next payer is patient). |
| pfr_unapplied_payments | decimal(12,2) | NO | 0.00 | | | Total unapplied payments |
| pfr_fam_bal | decimal(12,2) | NO | 0.00 | | | All guarantor related billable charges remaining total whose next payer is patient |
| pfr_fam_unapplied_payments | decimal(12,2) | NO | 0.00 | | | Total guarantor related unapplied payments |
| pfr_ins_primary_bal | decimal(12,2) | NO | 0.00 | | | Current amount owed by primary insurance (All claim ready charges remaining total whose next payer is primary insurance). |
| pfr_ins_secondary_bal | decimal(12,2) | NO | 0.00 | | | Current amount owed by secondary insurance (All claim ready charges remaining total whose next payer is secondary insurance). |
| pfr_ins_tertiary_bal | decimal(12,2) | NO | 0.00 | | | Current amount owed by tertiary insurance (All claim ready charges remaining total whose next payer is tertiary insurance). |
| pfr_resp_pat_bal | decimal(12,2) | NO | | | | Total Amount owed by patient on billable encounters guaranteed by this patient. |
| pfr_resp_unapplied_payments | decimal(12,2) | NO | | | | Unapplied total payments from patients that this patient is linked to by Encounter Guarantor. |
| pfr_resp_ins_primary_bal | decimal(12,2) | NO | | | | Total Amount owed by primary insurance on billable encounters whose primary insurance is linked to this patient. |
| pfr_resp_ins_secondary_bal | decimal(12,2) | NO | | | | Total Amount owed by primary insurance on billable encounters whose secondary insurance is linked to this patient. |
| pfr_resp_ins_tertiary_bal | decimal(12,2) | NO | | | | Total Amount owed by primary insurance on billable encounters whose tertiary insurance is linked to this patient. |
| pfr_resp_charges | decimal(12,2) | YES | 0.00 | | | Total patient responsible charges |
| pfr_resp_adjustments | decimal(12,2) | YES | 0.00 | | | Total patient responsible adjustments |
| pfr_resp_payments | decimal(12,2) | YES | 0.00 | | | Total patient responsible payments |
| pfr_last_batch_patient_statement_gen_dt | datetime | YES | | MUL | | Last datetime a batch patient statement was generated |
| pfr_modified | timestamp | YES | CURRENT_TIMESTAMP | | on update CURRENT_TIMESTAMP | |
| pfr_created | timestamp | YES | CURRENT_TIMESTAMP | | | |