CHG_TX_EXPECTED_WRT_OFF

Description: |
The write-off amounts for pending financial assistance trackers linked to the charge.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | TX_ID | NUMERIC | No |
The unique identifier (.1 item) for the transaction record.
2 | LINE | INTEGER | No |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | FIN_ASST_TRACKER_ID | NUMERIC | No |
Financial assistance tracker used to calculate expected write-off amounts.
4 | LAST_UPDATE_UTC_DTTM | DATETIME (UTC) | No |
Instant the write-off amounts were updated for this financial assistance tracker.
5 | EXPECTED_SELF_PAY_WRITE_OFF | NUMERIC | No |
Self-pay write-off amount the financial assistance tracker would be responsible for writing off if it were to be approved.
6 | EXPECTED_FIN_ASST_WRITE_OFF | NUMERIC | No |
Financial assistance-specific write-off amount the tracker would be responsible for writing off if it were to be approved.
7 | FPL_PERCENTAGE | NUMERIC | No |
The federal poverty level (FPL) percentage at the time of the write-off calculation.
8 | WRITE_OFF_SCENARIO | VARCHAR | No |
The discounting scenario from the financial assistance program that was used for the write-off calculation.
9 | WRITE_OFF_RULE_ID | VARCHAR | No |
The matching rule for the discounting scenario from the financial assistance program that was used for the write-off calculation.
10 | WRITE_OFF_RULE_ID_RULE_NAME | VARCHAR | No |
The name of the rule.
11 | WRITE_OFF_LPP_ID | NUMERIC | No |
The discounting extension from the financial assistance program that was used for the write-off calculation.
12 | WRITE_OFF_LPP_ID_LPP_NAME | VARCHAR | No |
The name of the extension.