| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table:
INSTITUTION_TBL
|
| 2 |
PRCSNAME |
Character(12) |
VARCHAR2(12) NOT NULL |
Process Name
Prompt Table:
FIN_AID_JOBS_VW
|
| 3 |
SCC_UPDATE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Update switch
N=No
Y=Yes
Default Value: N
|
| 4 |
CPS_SCHOOL_CODE |
Character(6) |
VARCHAR2(6) NOT NULL |
CPS School Code. Also known as Title IV School Code
Prompt Table:
INST_CPS_SRCH
|
| 5 |
RECORD_COUNT |
Number(7,0) |
INTEGER NOT NULL |
Count of Records
Default Value: 9999999
|
| 6 |
FILE_PATH |
Character(127) |
VARCHAR2(127) NOT NULL |
Input/Output file path
|
| 7 |
BATCH_SERIAL_NUM |
Number(5,0) |
INTEGER NOT NULL |
Last Sequence Nbr
|
| 8 |
RUN_DT |
Date(10) |
DATE |
Run Date
|
| 9 |
RAD_PRINT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Option
A=Print After 12/1
B=Print Before 12/1
|
| 10 |
RAD_RECV_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Receive RAD's Via
1=3 1/2 High Density Diskette
2=3 1/2 Double Density Diskette
N=Title IV WAN
|
| 11 |
RAD_SORT_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Sort By
1=By SSN
2=Alpha Full Name
3=Zip Code
|
| 12 |
RAD_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
RAD Type
Prompt Table:
RAD_TYPE_VW
|
| 13 |
TG5_NUM |
Character(5) |
VARCHAR2(5) NOT NULL |
TG Number
|
| 14 |
REPORTING_DATE |
Date(10) |
DATE |
Pell Reporting Date
Default Value: %date
|
| 15 |
AID_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Aid Year
Default Value: OPR_DEF_TBL_CS.AID_YEAR
Prompt Table:
AID_YEAR_TBL
|
| 16 |
PELL_SEND_ADDR |
Character(1) |
VARCHAR2(1) NOT NULL |
Added for FAEPPD98.SQR
Y/N Table Edit
Default Value: N
|
| 17 |
ESOA_OVERRIDE_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
If = Y indicates an ESOA record is intended to override one already loaded having same key values.
Y/N Table Edit
Default Value: N
|
| 18 |
ACCOUNTING_CYCLE |
Character(3) |
VARCHAR2(3) NOT NULL |
ESOA Accounting Cycle Number
|
| 19 |
CORRECTION_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Corrections
Y/N Table Edit
|
| 20 |
ADD_INST_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Add Institution
Y/N Table Edit
|
| 21 |
DUP_ISIR_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Duplicate ISIR Request
Y/N Table Edit
|
| 22 |
PROC_SARA |
Character(1) |
VARCHAR2(1) NOT NULL |
Load ISIRs (#A,#E)
Y/N Table Edit
Default Value: Y
|
| 23 |
PROC_SARR |
Character(1) |
VARCHAR2(1) NOT NULL |
Load ISIR Corrections (#C)
Y/N Table Edit
Default Value: Y
|
| 24 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 25 |
EXT_OVERRIDE_FLAG |
Character(50) |
VARCHAR2(50) NOT NULL |
External Override Flags
|
| 26 |
INST_ADD_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Add Action
A=Add (Do NOT Replace)
R=Add to Database (Replace)
Default Value: R
|