FIN_ASST_CASE_APPLY_PROG
Description:
This table contains the programs a household member is applying for in a financial assistance case record. Each row represents one program a household member has applied to in a financial assistance case.

Primary Key
Column Name Ordinal Position
FIN_ASST_CASE_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 FIN_ASST_CASE_ID NUMERIC No
The unique identifier (.1 item) for the financial assistance case record. This column is frequently used to link to the FIN_ASST_CASE table.
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 APPLYING_PROGRAM_C_NAME VARCHAR No
The applying program category ID for the household member on this financial assistance case.
May contain organization-specific values: Yes
Category Entries:
Medicaid
SNAP
WIC
CHIP
Disability Benefits