ACCT_ADDL_FPL_INFO

Description: |
Stores additional income types and values that correspond with entries from the ACCOUNT_FPL_INFO table.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ACCT_ID | NUMERIC | No |
The unique identifier for the account record.
2 | LINE | INTEGER | No |
The line number for the information associated with this record. It is used to differentiate records in this table, but is not meaningful.
3 | ADDL_INCOME_TYPE_C_NAME | VARCHAR | No |
Additional income type for the federal poverty level (FPL) table. This is a translated version of FPL Additional Income Type Combined (I EAR 144) storing the information as a discrete line instead of a delimited string.
May contain organization-specific values: Yes
4 | ADDL_INCOME_VALUE | NUMERIC | No |
Additional income amount for the federal poverty level (FPL) table. This is a translated version of FPL Additional Income Value Calculated (I EAR 145) storing the information as a discrete line instead of a delimited string.
5 | FPL_INFO_LINE | INTEGER | No |
Points to the line number ACCOUNT_FPL_INFO that this line is related to.