| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table:
INSTITUTION_TBL
|
| 2 |
AID_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Aid Year
Default Value: OPR_DEF_TBL_CS.AID_YEAR
Prompt Table:
FED_AID_YR_TBL
|
| 3 |
SFA_LOAN_CODE |
Character(4) |
VARCHAR2(4) NOT NULL |
Loan Code
|
| 4 |
SFA_LN_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Source
F=Federal
I=Institutional
P=Private
S=State
|
| 5 |
SFA_LOAN_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Loan Type
GPLS=Graduate PLUS Loan
HEAL=Health Education Assistance Ln
HPSL=Health Profession Student Loan
LDS=Loan for Disadvantage Student
NURS=Nursing Loan
PCL=Primary Care Loan
PERK=Federal Perkins Loan Program
PLUS=Federal PLUS
STAF=Federal Stafford
|
| 6 |
SFA_DESCR15 |
Character(15) |
VARCHAR2(15) NOT NULL |
Description
|
| 7 |
SFA_ENTRANCE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Entrance Requirement
A=Required Annually
M=Required Once
Default Value: M
|
| 8 |
SFA_ENTRANCE_C_MSG |
Character(254) |
VARCHAR2(254) NOT NULL |
Complete Entrance Instructions
|
| 9 |
SFA_ENTRANCE_V_MSG |
Character(254) |
VARCHAR2(254) NOT NULL |
Entrance Req Instuctions
|
| 10 |
SFA_ENTRANCE_URL |
Character(254) |
VARCHAR2(254) NOT NULL |
Entrance Counseling URL
|
| 11 |
SFA_EXIT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Exit Type
A=Required Annually
M=Required Once
Default Value: M
|
| 12 |
SFA_EXIT_C_MSG |
Character(254) |
VARCHAR2(254) NOT NULL |
Complete Exit Instructions
|
| 13 |
SFA_EXIT_V_MSG |
Character(254) |
VARCHAR2(254) NOT NULL |
View Exit Req Instructions
|
| 14 |
SFA_EXIT_URL |
Character(254) |
VARCHAR2(254) NOT NULL |
Exit Counseling URL
|
| 15 |
SFA_EXIT_DATE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Default Exit Date
Y/N Table Edit
Default Value: Y
|
| 16 |
SFA_EXIT_DATE_CALC |
Character(2) |
VARCHAR2(2) NOT NULL |
Exit Date Calculation Choice
Default Value: 30
|
| 17 |
SFA_EXIT_DATE |
Date(10) |
DATE |
Exit Date
Default Value: %date
|