| # |
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
|
| 5 |
PRT_RESIDENCE |
Character(6) |
VARCHAR2(6) NOT NULL |
Parent Residence
Prompt Table:
PROVINCE_VW
|
| 6 |
PRT_RSDNT_LENGTH |
Character(1) |
VARCHAR2(1) NOT NULL |
Parent Residence Length
1=Less than 12 Months
2=At least 12 Months
|
| 7 |
MAR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Marital Status
C=Common-Law
D=Divorced
E=Separated
H=Head of Household
L=DissDeclLost Civil Partner
M=Married
P=Civil Partnership
S=Single
T=Surviving Civil Partner
U=Unknown
V=Dissolved Civil Partnership
W=Widowed
|
| 8 |
NUM_DEPENDENTS |
Number(2,0) |
SMALLINT NOT NULL |
Number of Dependents
|
| 9 |
NUM_COLLEGE |
Number(2,0) |
SMALLINT NOT NULL |
Number in College
|
| 10 |
FATHER_ID |
Character(9) |
VARCHAR2(9) NOT NULL |
Father's Social Insurance #
|
| 11 |
FATHER_NO_ID |
Character(1) |
VARCHAR2(1) NOT NULL |
Father has No ID
Y/N Table Edit
|
| 12 |
MOTHER_ID |
Character(9) |
VARCHAR2(9) NOT NULL |
Mother's Social Insurance #
|
| 13 |
MOTHER_NO_ID |
Character(1) |
VARCHAR2(1) NOT NULL |
Mother has No ID
Y/N Table Edit
|
| 14 |
FATHER_EARNINGS |
Number(8,0) |
INTEGER NOT NULL |
Father Actual Income
|
| 15 |
MOTHER_EARNINGS |
Number(8,0) |
INTEGER NOT NULL |
Mother Actual Income
|
| 16 |
EXPECT_FATHER_EARN |
Number(8,0) |
INTEGER NOT NULL |
Father Estimated Income
|
| 17 |
EXPECT_MOTHER_EARN |
Number(8,0) |
INTEGER NOT NULL |
Mother Estimated Income
|
| 18 |
PRT_INCOME_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
Parent Income Source
1=Ontario Disability Program
2=Family Benefits
3=General Welfare
4=Other
|
| 19 |
FATHER_PENSION |
Number(6,0) |
INTEGER NOT NULL |
Father's Pension
|
| 20 |
FATHER_EMPL_INS |
Number(6,0) |
INTEGER NOT NULL |
Father's Empl Ins
|
| 21 |
FATHER_TAX_PAID |
Number(6,0) |
INTEGER NOT NULL |
Father's Tax Paid
|
| 22 |
MOTHER_PENSION |
Number(6,0) |
INTEGER NOT NULL |
Mother's Pension
|
| 23 |
MOTHER_EMPL_INS |
Number(6,0) |
INTEGER NOT NULL |
Mother's Empl Ins
|
| 24 |
MOTHER_TAX_PAID |
Number(6,0) |
INTEGER NOT NULL |
Mother's Tax Paid
|