ACCOUNT_FPL_INFO
Description:
This table contains Federal Poverty Level information from EAR masterfile.

Primary Key
Column Name Ordinal Position
ACCOUNT_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 ACCOUNT_ID NUMERIC No
The unique ID for the account record. This ID number could be encrypted if you have elected to implement enterprise reporting’s encryption security function.
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 FPL_EFF_DATE DATETIME No
The date from which this line of Federal Poverty Level information is effective.
4 FPL_INCOME NUMERIC No
Total income for use in calculating Federal Poverty Level information.
5 FPL_FAMILY_SIZE INTEGER No
Family size for use in calculating Federal Poverty Level information.
6 FPL_PERCENTAGE NUMERIC No
Calculated percentage of the Federal Poverty Level for this guarantor.
7 FPL_STAFF_TYPE_C_NAME VARCHAR No
The type of staff category ID for the person who collected this Federal Poverty Level information.
May contain organization-specific values: Yes
8 FPL_INCOME_PRF_C_NAME VARCHAR No
The category ID for the method used by the guarantor to prove their income level.
May contain organization-specific values: Yes
9 FPL_STATUS_CODE_C_NAME VARCHAR No
The category ID for the financial assistance status of a guarantor account. This only applies to guarantors that have their Federal Poverty Level form filled out.
May contain organization-specific values: Yes
10 FPL_REASON_CODE_C_NAME VARCHAR No
The category ID for the financial assistance reason code associated with this row.
May contain organization-specific values: Yes
11 FPL_EXP_DATE DATETIME No
The date until which this line of Federal Poverty Level information is effective.
12 FPL_ENTRY_USER_ID VARCHAR No
The unique ID of the user that collected this line of Federal Poverty Level information.
13 FPL_ENTRY_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
14 FPL_USER_DEPT_ID NUMERIC No
The unique ID of the department in which this line of Federal Poverty Level information was collected.
15 FPL_INST_OF_ENTRY DATETIME (Local) No
The date and time at which this line of Federal Poverty Level information was collected.
16 INCOME_INTDIV NUMERIC No
Gross monthly income from interest and dividends.
17 INCOME_PENSION NUMERIC No
Gross monthly income from pension.
18 INCOME_ALIMONY NUMERIC No
Gross monthly income from alimony/child support.
19 INCOME_SSI NUMERIC No
Gross monthly supplemental security income.
20 INCOME_GOVT NUMERIC No
Gross monthly income from government assistance.
21 INCOME_NON_WAGE NUMERIC No
Other gross monthly non-wage income.
22 INCOME_HRLY_WAGE NUMERIC No
Hourly wage for gross monthly income calculation.
23 HOURS_WORKED_WEEK INTEGER No
Number of hours worked per week.
24 OTHER_WAGES NUMERIC No
Other wages for use in calculating gross monthly income for use in calculating Federal Poverty Level information.
25 SALARY NUMERIC No
Salary earned for use in calculating gross monthly income for use in calculating Federal Poverty Level information.