| # |
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 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_CS.SETID
Prompt Table:
SP_SETID_NONVW
|
| 4 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table:
INSTITUTION_TBL
|
| 5 |
AID_YEAR_FROM |
Character(4) |
VARCHAR2(4) NOT NULL |
Copy From Aid Year
Default Value: OPR_DEF_TBL_CS.AID_YEAR
Prompt Table:
AID_YEAR_TBL
|
| 6 |
AID_YEAR_TO |
Character(4) |
VARCHAR2(4) NOT NULL |
Copy To Aid Year
|
| 7 |
OVRD_AID_YEAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Aid Year
Y/N Table Edit
Default Value: Y
|
| 8 |
EFFDT_TODAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Eff Date of Today
Y/N Table Edit
Default Value: N
|
| 9 |
EFFDT_1900 |
Character(1) |
VARCHAR2(1) NOT NULL |
Eff Date of 01/01/1900
Y/N Table Edit
Default Value: N
|
| 10 |
EFFDT_FRM_TBL |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Eff Date from Source Table
Y/N Table Edit
Default Value: N
|
| 11 |
ROLLOVER_INACTIVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Rollover Inactive Rows
Y/N Table Edit
Default Value: N
|
| 12 |
GEN_AID_YEAR_SETUP |
Character(1) |
VARCHAR2(1) NOT NULL |
Aid Year Tables
Y/N Table Edit
Default Value: N
|
| 13 |
AGGR_AID_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Aggregate Aid Limit Tables
Y/N Table Edit
Default Value: N
|
| 14 |
FA_TERM_SETUP |
Character(1) |
VARCHAR2(1) NOT NULL |
FA Term Tables
Y/N Table Edit
Default Value: N
|
| 15 |
BDGT_TBL_SETUP |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Tables
Y/N Table Edit
Default Value: N
|
| 16 |
DISB_TBL_SETUP |
Character(1) |
VARCHAR2(1) NOT NULL |
Disbursement Rules Tables
Y/N Table Edit
Default Value: N
|
| 17 |
ITEM_TYPE_SETUP |
Character(1) |
VARCHAR2(1) NOT NULL |
FA Item Type Tables
Y/N Table Edit
Default Value: N
|
| 18 |
ISIR_REC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
ISIR Record Code
C=Correction Application
D=Duplicate Request
H=Correction
Q=EDE Quick Correction
R=Renewal FAFSA Web or Paper
S=Web Signatures
V=EDE Verification Corrections
Y/N Table Edit
Default Value: N
|
| 19 |
PKG_SETUP |
Character(1) |
VARCHAR2(1) NOT NULL |
Packaging Tables
Y/N Table Edit
Default Value: N
|
| 20 |
RTRN_TIV_SETUP |
Character(1) |
VARCHAR2(1) NOT NULL |
Return of TIV Tables
Y/N Table Edit
Default Value: N
|
| 21 |
LOAN_SETUP |
Character(1) |
VARCHAR2(1) NOT NULL |
Loan Tables
Y/N Table Edit
Default Value: N
|
| 22 |
PELL_SETUP |
Character(1) |
VARCHAR2(1) NOT NULL |
PELL/ACG/SMART Tables
Y/N Table Edit
Default Value: N
|
| 23 |
PROFILE_SETUP |
Character(1) |
VARCHAR2(1) NOT NULL |
Profile Tables
Y/N Table Edit
Default Value: N
|
| 24 |
SFA_SS_SETUP |
Character(1) |
VARCHAR2(1) NOT NULL |
Shopping Sheet Tables / CFP
Y/N Table Edit
Default Value: N
|
| 25 |
SFA_AYR_EFFDT |
Date(10) |
DATE |
Effective Date
|