| # |
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
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table:
INSTITUTION_TBL
|
| 3 |
AID_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Aid Year
Default Value: OPR_DEF_TBL_CS.AID_YEAR
Prompt Table:
AID_YEAR_TBL
|
| 4 |
OSAP_LAST_TRANS_DT |
Date(10) |
DATE |
Last Transaction Date
|
| 5 |
APP_ACCT_NUM |
Character(9) |
VARCHAR2(9) NOT NULL |
App Acct Number
|
| 6 |
SIN |
Character(9) |
VARCHAR2(9) NOT NULL |
Social Insurance #
|
| 7 |
CSL_AMT |
Number(5,0) |
INTEGER NOT NULL |
CSL Amount
|
| 8 |
PROV_AMT |
Number(5,0) |
INTEGER NOT NULL |
Provincial Loan Amount
|
| 9 |
CSG_AMT |
Number(5,0) |
INTEGER NOT NULL |
CSG Amount
|
| 10 |
DATE_SSB |
Date(10) |
DATE |
Date Received at SSB
|
| 11 |
TOT_ENT_AWARD |
Number(5,0) |
INTEGER NOT NULL |
Total Entitled Award
|
| 12 |
TOT_CSL_ISS |
Number(5,0) |
INTEGER NOT NULL |
Total CSL Issued
|
| 13 |
TOT_OSL_ISS |
Number(5,0) |
INTEGER NOT NULL |
Total OSL Issued
|
| 14 |
NE_CODE |
Character(2) |
VARCHAR2(2) NOT NULL |
NE Code
A1=Sept. - Dec. with 1 term
B1=Sept. - Dec. with 2 terms
C1=Sept. - Dec. with 3 terms
D1=Jan. - Apr. with 1 term
E1=Jan. - Apr. with 2 terms
F1=May - Jun. with 1 term
G1=July - Aug. with 2 terms
H1=July - Aug. with 3 terms
J1=July - Aug. with 1 term
|
| 15 |
MULTIPLE_APPS |
Character(1) |
VARCHAR2(1) NOT NULL |
Multiple Apps
|
| 16 |
FA_STATUS_CODE_1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Status Code 1
|
| 17 |
FA_STATUS_CODE_2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Status Code 2
|
| 18 |
FA_STATUS_CODE_3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Status Code 3
|
| 19 |
FA_STATUS_CODE_4 |
Character(1) |
VARCHAR2(1) NOT NULL |
Status Code 4
|
| 20 |
FA_STATUS_CODE_5 |
Character(1) |
VARCHAR2(1) NOT NULL |
Status Code 5
|
| 21 |
FA_STATUS_CODE_6 |
Character(1) |
VARCHAR2(1) NOT NULL |
Status Code 6
|
| 22 |
FA_STATUS_CODE_7 |
Character(1) |
VARCHAR2(1) NOT NULL |
Status Code 7
|
| 23 |
FA_STATUS_CODE_8 |
Character(1) |
VARCHAR2(1) NOT NULL |
Status Code 8
|
| 24 |
FA_STATUS_CODE_9 |
Character(1) |
VARCHAR2(1) NOT NULL |
Status Code 9
|
| 25 |
FA_STATUS_CODE_10 |
Character(1) |
VARCHAR2(1) NOT NULL |
Status Code 10
|
| 26 |
FA_STATUS_CODE_11 |
Character(1) |
VARCHAR2(1) NOT NULL |
Status Code 11
|
| 27 |
FA_STATUS_CODE_12 |
Character(1) |
VARCHAR2(1) NOT NULL |
Status Code 12
|
| 28 |
FA_STATUS_CODE_13 |
Character(1) |
VARCHAR2(1) NOT NULL |
Status Code 13
|
| 29 |
FA_STATUS_CODE_14 |
Character(1) |
VARCHAR2(1) NOT NULL |
Status Code 14
|
| 30 |
FA_STATUS_CODE_15 |
Character(1) |
VARCHAR2(1) NOT NULL |
Status Code 15
|
| 31 |
PREPRINT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Preprint Indicator
|
| 32 |
HIGHEST_PCT_CRSLD |
Character(3) |
VARCHAR2(3) NOT NULL |
Highest Pct Courseload
|
| 33 |
TOT_NEED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Total Need Flag
|
| 34 |
FA_TOTAL_NEED |
Number(5,0) |
INTEGER NOT NULL |
Total Need
|
| 35 |
CURRENT_COST_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Current Cost Code
|
| 36 |
YEAR_ENTERING |
Character(1) |
VARCHAR2(1) NOT NULL |
Year Entering
|
| 37 |
GRANT_ISSUED |
Number(5,0) |
INTEGER NOT NULL |
Grant Issued
|
| 38 |
TITLE_IV_SCH_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
FAFSA Title IV School Code
|
| 39 |
ACAD_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Academic Year
|
| 40 |
SFA_UNMET_NEED |
Number(6,0) |
INTEGER NOT NULL |
CNAS Unmet Need field.
|
| 41 |
SFA_DISAB_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
CNAS - Disability Flag.
1=Yes
2=No
|
| 42 |
SFA_OAG_ENT |
Number(5,0) |
INTEGER NOT NULL |
CNAS - OAG Entitled.
|
| 43 |
SFA_OAG_ISSUE |
Number(5,0) |
INTEGER NOT NULL |
CNAS - OAG Issued.
|
| 44 |
SFA_MOAG_ENT |
Number(5,0) |
INTEGER NOT NULL |
CNAS - MOAG Entitled.
|
| 45 |
SFA_MOAG_ISSUE |
Number(5,0) |
INTEGER NOT NULL |
CNAS - MOAG Issued.
|
| 46 |
SFA_CAG_LID_ENT |
Number(5,0) |
INTEGER NOT NULL |
CNAS - CAG LID Entitled.
|
| 47 |
SFA_CAG_LID_ISS |
Number(5,0) |
INTEGER NOT NULL |
CNAS - CAG LID Issued.
|
| 48 |
SFA_CAG_PD_ENT |
Number(5,0) |
INTEGER NOT NULL |
CNAS - CAG PD Entitled.
|
| 49 |
SFA_CAG_PD_ISS |
Number(5,0) |
INTEGER NOT NULL |
CNAS - CAG PD Issued.
|
| 50 |
SFA_MILLEN_ENT |
Number(5,0) |
INTEGER NOT NULL |
CNAS - Millennium Entitled.
|
| 51 |
SFA_MILLEN_ISS |
Number(5,0) |
INTEGER NOT NULL |
CNAS - Millennium Issued.
|
| 52 |
SFA_CUR_ST_INFO |
Character(1) |
VARCHAR2(1) NOT NULL |
CNAS - Current Status Information.
|
| 53 |
SFA_OWN_VECH |
Character(1) |
VARCHAR2(1) NOT NULL |
CNAS - Own Vehicles?
|
| 54 |
SFA_RRSP_NET |
Number(6,0) |
INTEGER NOT NULL |
CNAS - RRSP Net Value.
|
| 55 |
SFA_TOT_OTHER |
Number(6,0) |
INTEGER NOT NULL |
CNAS - Total Other Assets.
|
| 56 |
SFA_PRESTD_INC |
Number(5,0) |
INTEGER NOT NULL |
CNAS - Student Prestudy Income.
|
| 57 |
SFA_STD_PER_EMP |
Number(5,0) |
INTEGER NOT NULL |
CNAS - Study Period Employment.
|
| 58 |
SFA_GOVT_INC |
Number(5,0) |
INTEGER NOT NULL |
CNAS - Government Income During Study.
|
| 59 |
SFA_TYP_GOV_INC |
Character(1) |
VARCHAR2(1) NOT NULL |
CNAS - Type of Gov. Income.
|
| 60 |
SFA_LIV_PARNTS |
Character(1) |
VARCHAR2(1) NOT NULL |
CNAS - Living With Parents During Period?
1=At Home
2=Living Away
|
| 61 |
SFA_CUR_RES_INFO |
Character(1) |
VARCHAR2(1) NOT NULL |
CNAS - Current Residency Information
1=Student is ON Resident
2=Spouse is ON Resident
3=Parent is ON Resident
4=Not ON Resident
5=Resident of Canada
|
| 62 |
SFA_C_OF_E |
Character(6) |
VARCHAR2(6) NOT NULL |
CNAS - C of E Event Status.
|
| 63 |
SFA_CODE_35 |
Character(1) |
VARCHAR2(1) NOT NULL |
CNAS - Code 35
Y=Yes
|
| 64 |
SFA_CODE_65 |
Character(1) |
VARCHAR2(1) NOT NULL |
CNAS - Code 65
Y=Yes
|
| 65 |
SFA_CODE_67 |
Character(1) |
VARCHAR2(1) NOT NULL |
CNAS - Code 67
Y=Yes
|