| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_CS.OPRID
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table:
INSTITUTION_TBL
|
| 4 |
AID_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Aid Year
Default Value: OPR_DEF_TBL_CS.AID_YEAR
Prompt Table:
AID_YEAR_TBL
|
| 5 |
FIN_AID_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Fin Aid Type
A=Athletic
B=Bursary
F=Fellowship
G=Grant
L=Loan
S=Scholarship
V=Waiver
W=Work/Study
|
| 6 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_CS.SETID
Prompt Table:
SP_SETID_NONVW
|
| 7 |
LN_ACTION_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Loan Action Type
|
| 8 |
LN_ACTION_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Loan Action Cd
Prompt Table:
%EDITTABLE
|
| 9 |
LN_ACTION_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Loan Action Status
A=Accptd-Not Applied
B=Accepted
F=Failed Rule
I=Invalid
L=Lower Endorser Amount accepted
O=Authorized for Transfer
P=Pending
R=Rejected
T=Transmitted
U=Received
W=Accepted with Corrected Award
|
| 10 |
REPORTING_DATE |
Date(10) |
DATE |
Pell Reporting Date
|
| 11 |
TIV_SCHOOL_CODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Pell ID Reporting
Prompt Table:
TIV_SCHOOL_TBL
|
| 12 |
IWD_AWARD_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Award Year
|
| 13 |
CPS_SCHOOL_CODE |
Character(6) |
VARCHAR2(6) NOT NULL |
CPS School Code. Also known as Title IV School Code
Prompt Table:
TIV_SCHOOL_TBL
|
| 14 |
LOAN_PROGRAM |
Character(1) |
VARCHAR2(1) NOT NULL |
Loan Program
A=Alternative
D=Direct Lending
F=FFELP
H=Health Professions
P=Perkins
S=State
U=University
|