| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
STUDENT_AID
|
| 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 |
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
Prompt Table:
INST_CONTROL
|
| 5 |
MEMBER_SEQ |
Number(2,0) |
SMALLINT NOT NULL |
Family Member Sequence
|
| 6 |
RELATIONSHIP_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Relationship
1=Student's Parent
2=Student's Stepparent
3=Student's Brother/Sister/Step
4=Student's Spouse
5=Student's Son/Daughter
6=Student's Grandparent
7=Student's Stepbrother/sister
8=Other
?=Invalid Entry
|
| 7 |
ATTEND_COLLEGE |
Character(1) |
VARCHAR2(1) NOT NULL |
College Status
0=Not Applicable
1=Full-Time
2=Half-Time
3=Not Attending
|
| 8 |
COLLEGE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
College Type
1=2-Year Public
2=2-Year Private
3=4-Year Public
4=4-Year Private
5=Graduate/Professional
6=Proprietary
7=Other
|
| 9 |
MEMBER_AGE |
Number(2,0) |
SMALLINT NOT NULL |
Family Member's Age
|
| 10 |
SFA_PF_NAME |
Character(20) |
VARCHAR2(20) NOT NULL |
Name
|
| 11 |
SFA_PF_FNAME |
Character(35) |
VARCHAR2(35) NOT NULL |
First Name
|
| 12 |
SFA_PF_LNAME |
Character(35) |
VARCHAR2(35) NOT NULL |
Last Name
|
| 13 |
SFA_PF_SCHOOL_NM |
Character(50) |
VARCHAR2(50) NOT NULL |
Name of School
|