SFA_FAMLYLST_VW

(SQL View)
Index Back

IM/NCP Family request

Wrapper for IM/NCP Family request

SELECT EMPLID ,INSTITUTION , AID_YEAR , APP_SOURCE_CODE FROM PS_INST_CONTROL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
3 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
4 APP_SOURCE_CODE Character(1) VARCHAR2(1) NOT NULL Application Source Code
0=Need Access
0=Need Access
1=Electronic Initial Application
2=Electronic Renewal Aplication
3=Electronic Correction
4=FAFSA Express
5=ACT
6=I-NET
7=NCS
8=Profile
9=Institutional Application
O=FT Canada Student Loan
P=PT Canada Student Loan