| # |
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:
AID_YEAR_TBL
|
| 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 |
EFFDT |
Date(10) |
DATE |
Effective Date
|
| 6 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 7 |
CNAS_RULE_SET |
Character(4) |
VARCHAR2(4) NOT NULL |
CNAS Rule Set
1=Temp Value 1
2=Temp Value 2
C=CSL Rule Set
Prompt Table:
CNAS_SETUP_TBL
|
| 8 |
STDNT_CATEGORY |
Character(1) |
VARCHAR2(1) NOT NULL |
Student Category
D=Single Dependent
I=Single Independent
M=Married
S=Sole Support
|
| 9 |
FULL_PART_TIME |
Character(1) |
VARCHAR2(1) NOT NULL |
Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time
|
| 10 |
TOTAL_BDGT |
Number(5,0) |
INTEGER NOT NULL |
Total Inital Budget
|
| 11 |
BDGT_CAP |
Number(5,0) |
INTEGER NOT NULL |
Budget Reduction/Cap
|
| 12 |
PS_MIN_INC |
Number(8,0) |
INTEGER NOT NULL |
Min Prestudy Contribution
|
| 13 |
PS_INC_DISC |
Number(8,0) |
INTEGER NOT NULL |
Actual Prestudy Contribution
|
| 14 |
PS_INC_USED |
Number(8,0) |
INTEGER NOT NULL |
Prestudy Contribution Used
|
| 15 |
SP_INC_TOT |
Number(8,0) |
INTEGER NOT NULL |
Study Period Inc Contribution
|
| 16 |
SP_ASSETS |
Number(8,0) |
INTEGER NOT NULL |
Asset Contribution
|
| 17 |
STD_CONT |
Number(8,0) |
INTEGER NOT NULL |
Final Student Contribution
|
| 18 |
FATHER_INC |
Number(8,0) |
INTEGER NOT NULL |
Father's Income Used
|
| 19 |
MOTHER_INC |
Number(10,0) |
DECIMAL(10) NOT NULL |
Mother's Income Used
|
| 20 |
PRT_ADI |
Number(8,0) |
INTEGER NOT NULL |
Parent's ADI
|
| 21 |
TOT_PRT_CONT |
Number(8,0) |
INTEGER NOT NULL |
Total Parental Cont
|
| 22 |
FIN_PRT_CONT |
Number(8,0) |
INTEGER NOT NULL |
PC for Student
|
| 23 |
FAM_CONT |
Number(8,0) |
INTEGER NOT NULL |
Family Contribution
|
| 24 |
FIN_NEED |
Number(5,0) |
INTEGER NOT NULL |
Financial Need
|
| 25 |
CSL_AMT |
Number(5,0) |
INTEGER NOT NULL |
CSL Amount
|
| 26 |
CSG_AMT |
Number(5,0) |
INTEGER NOT NULL |
CSG Amount
|
| 27 |
PROV_AMT |
Number(5,0) |
INTEGER NOT NULL |
Provincial Loan Amount
|
| 28 |
SOG_AMT |
Number(5,0) |
INTEGER NOT NULL |
SOG Amount
|
| 29 |
OVERAWARD_USED |
Number(5,0) |
INTEGER NOT NULL |
Overaward Used
|
| 30 |
OVERAWARD_BAL |
Number(5,0) |
INTEGER NOT NULL |
Overaward Balance
|
| 31 |
ABORT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
CNAS Abort Flag
Y/N Table Edit
|
| 32 |
USE_COA |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Cost of Attendance
F=Fed Year COA
I=Inst Year COA
|
| 33 |
FM_IM_USE |
Character(1) |
VARCHAR2(1) NOT NULL |
FM/IM Use
B=Both FM and IM EFC
F=FM EFC
I=IM EFC
|
| 34 |
AWD_PER_USE |
Character(1) |
VARCHAR2(1) NOT NULL |
Award Period Use
A=Academic
B=Both
N=Non-Standard
|
| 35 |
FAMILY_SIZE |
Number(2,0) |
SMALLINT NOT NULL |
Created for use with Canadian Part-Time Student Loan Family Size placeholder
|