FIN_ASST_TRKR_RST_LOC_HX

Description: |
This table contains a history of the edits made to the list of location restrictions placed on a financial assistance tracker record to limit the scope of tracker's approval.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
FIN_ASST_TRACKER_ID | 1 |
GROUP_LINE | 2 |
VALUE_LINE | 3 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | FIN_ASST_TRACKER_ID | NUMERIC | No |
The unique identifier (.1 item) for the financial assistance program tracker record.
2 | GROUP_LINE | INTEGER | No |
The line number of the location's approval is restricted to at the time of this update in the financial assistance tracker record. Together with FIN_ASST_TRACKER_ID column in this table, this forms the foreign key to the FIN_ASST_TRKR_UPDATE_HX table.
3 | VALUE_LINE | INTEGER | No |
The line number of one of the multiple locations approval is restricted to with the financial assistance tracker record and the update from the FIN_ASST_TRKR_UPDATE_HX table.
4 | UPDATE_RSTR_LOC_ID_LOC_NAME | VARCHAR | No |
The name of the revenue location.