ARPB_TX_FIN_ASST

Description: |
Financial Assistance Related Items for Transactions. This table has information that is populated by financial assistance workflows.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
TX_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | TX_ID | NUMERIC | No |
The unique identifier for the transaction record.
2 | PROGRAM_ID | NUMERIC | No |
The financial assistance program applied on this charge line.
3 | PROGRAM_ID_PROGRAM_NAME | VARCHAR | No |
The name of the financial assistance program record.
4 | DISCOUNT_PCT | NUMERIC | No |
The discount percentage applied to this charge line from financial assistance.
5 | FLAT_FEE_AMT | NUMERIC | No |
The applied flat fee for this charge line from financial assistance.
6 | MIN_FEE_AMT | NUMERIC | No |
The applied minimum fee on this charge line from financial assistance.
7 | FEE_SCHEDULE_ID | NUMERIC | No |
The fee schedule on this charge line used to determine the financial assistance discount amount.
8 | FEE_SCHEDULE_ID_FEE_SCHEDULE_NAME | VARCHAR | No |
The name of each fee schedule.
9 | DISCOUNT_AMT | NUMERIC | No |
The discount amount from financial assistance calculations.
10 | FPL_PCT | NUMERIC | No |
The Federal Poverty Level (FPL) percentage used in financial assistance calculations.
11 | FIN_ASST_TRACKER_ID | NUMERIC | No |
The unique identifier of the financial assistance tracker that discounted this transaction.