HSEHOLD_VERF (SQL Table)	Index Back
Household Verification Table This record houses verification data about each family member in the financial aid applicant's household. For example, a financial aid office would enter data from a household verification document pertaining to each household member, their dependency status, age, and college they may be attending. This data is then compared to the federal or institutional financial aid application form for consistancy and accuracy.

HSEHOLD_VERF

(SQL Table)

Household Verification Table

This record houses verification data about each family member in the financial aid applicant's household. For example, a financial aid office would enter data from a household verification document pertaining to each household member, their dependency status, age, and college they may be attending. This data is then compared to the federal or institutional financial aid application form for consistancy and accuracy.

Parent record: VERIFICATION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PEOPLE_SRCH

2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
Prompt Table: INSTITUTION_TBL

3 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
Prompt Table: STUDENT_AID

4 SEQUENCE_NBR Number(2,0) SMALLINT NOT NULL Sequence Number

5 MEMBER_NUMBER Number(2,0) SMALLINT NOT NULL HH Member Number

6 MEMBER_NAME Character(50) VARCHAR2(50) NOT NULL Member Name

7 AGE Number(3,0) SMALLINT NOT NULL Age

8 PEOPLE_RELATION Character(2) VARCHAR2(2) NOT NULL Relationship

9 TITLE_IV_SCH_CD Character(6) VARCHAR2(6) NOT NULL FAFSA Title IV School Code
Prompt Table: TITLE_IV_SRCH

10 EXEMPTION_TYPE Character(2) VARCHAR2(2) NOT NULL Tax Exemption Type
NA=Not Applicable or Claimed
NC=Non Resident Child
OT=Other
PR=Parent
RC=Resident Child
SF=Self
SP=Spouse

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PEOPLE_SRCH
2	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Prompt Table: INSTITUTION_TBL
3	AID_YEAR	Character(4)	VARCHAR2(4) NOT NULL	Aid Year Prompt Table: STUDENT_AID
4	SEQUENCE_NBR	Number(2,0)	SMALLINT NOT NULL	Sequence Number
5	MEMBER_NUMBER	Number(2,0)	SMALLINT NOT NULL	HH Member Number
6	MEMBER_NAME	Character(50)	VARCHAR2(50) NOT NULL	Member Name
7	AGE	Number(3,0)	SMALLINT NOT NULL	Age
8	PEOPLE_RELATION	Character(2)	VARCHAR2(2) NOT NULL	Relationship
9	TITLE_IV_SCH_CD	Character(6)	VARCHAR2(6) NOT NULL	FAFSA Title IV School Code Prompt Table: TITLE_IV_SRCH
10	EXEMPTION_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Tax Exemption Type NA=Not Applicable or Claimed NC=Non Resident Child OT=Other PR=Parent RC=Resident Child SF=Self SP=Spouse