| # |
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:
AID_YEAR_TBL
|
| 3 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 4 |
SFA_EA_PROC_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
External award processing status.
A=Adjusted
D=Duplicate
E=Error
I=In Process Abend
K=Skip
P=Processed
R=Reported
S=Suspend
U=Unprocessed
|
| 5 |
SFA_EA_TRANS_SRCE |
Character(2) |
VARCHAR2(2) NOT NULL |
External Award data source (file, self service, manual entry, loans, SF)
01=Manual Entry
02=External File
03=Loan Certification File
04=Student Financials
05=Self Service
|
| 6 |
TRANSACTION_DATE |
Date(10) |
DATE |
TRANSACTION_DATE
|
| 7 |
SFA_EA_TRANS_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Transaction number used for staging external awards to the database.
|
| 8 |
SCCFP_MAP_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Mapping ID - the unique key that identifies the file mapping
Prompt Table:
SFA_EA_SCCFPMAP
|
| 9 |
SFA_EA_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
External Award type (customer defined).
Prompt Table:
SFA_EA_TYPE
|
| 10 |
SFA_EA_SOURCE |
Character(3) |
VARCHAR2(3) NOT NULL |
External Award source (customer defined).
Prompt Table:
SFA_EA_SOURCE
|
| 11 |
SFA_EA_PROGRAM_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
External Award program code (customer defined).
Prompt Table:
SFA_EA_PROGRAM
|
| 12 |
SFA_EA_NO_UPDATE |
Character(12) |
VARCHAR2(12) NOT NULL |
External award load exclusionary equation for no update of student aid attribute.
Prompt Table:
EQTN_NAME_VW
|
| 13 |
SFA_EA_MC_LOAD_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
External award load - multiple career rule.
A=Adjusted
E=Error
S=Suspend
Default Value: E
|
| 14 |
SFA_EA_INVALID_TRM |
Character(1) |
VARCHAR2(1) NOT NULL |
External award load - invalid term rule.
A=Adjust
E=Error
S=Suspend
Default Value: E
|
| 15 |
STUDENTS_SEL |
Signed Number(9,0) |
DECIMAL(8) NOT NULL |
Students Selected
|
| 16 |
STUDENTS_PROC |
Signed Number(9,0) |
DECIMAL(8) NOT NULL |
Students Processed
|
| 17 |
STUDENTS_SKIPPED |
Signed Number(9,0) |
DECIMAL(8) NOT NULL |
Students Skipped
|
| 18 |
SFA_EA_ERROR_COUNT |
Number(8,0) |
INTEGER NOT NULL |
In Error Status
|
| 19 |
SFA_PROC_RUN_MODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to indicate process execution mode (Batch vs. Remote Call). Created for the FA External Award Load process.
B=Batch Process
R=On-line Process
Default Value: B
|