SFA_RUN_EALOAD (SQL Table)	Index Back
SFA Run External Award Load SFA_RUN_EALOAD holds run control parameters to run the external award loading process.

SFA_RUN_EALOAD

(SQL Table)

SFA Run External Award Load

SFA_RUN_EALOAD holds run control parameters to run the external award loading process.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

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 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
Default Value: U

6 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

7 TRANSACTION_DATE Date(10) DATE TRANSACTION_DATE

8 SFA_EA_TRANS_NBR Number(15,0) DECIMAL(15) NOT NULL Transaction number used for staging external awards to the database.

9 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

10 SFA_EA_TYPE Character(3) VARCHAR2(3) NOT NULL External Award type (customer defined).
Prompt Table: SFA_EA_TYPE

11 SFA_EA_SOURCE Character(3) VARCHAR2(3) NOT NULL External Award source (customer defined).
Prompt Table: SFA_EA_SOURCE

12 SFA_EA_PROGRAM_CD Character(3) VARCHAR2(3) NOT NULL External Award program code (customer defined).
Prompt Table: SFA_EA_PROGRAM

13 SFA_EA_NO_UPDATE Character(12) VARCHAR2(12) NOT NULL External award load exclusionary equation for no update of student aid attribute.
Prompt Table: SFA_EAEQTNS_VW

14 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

15 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

16 SFA_EA_LCR_OPTION Character(1) VARCHAR2(1) NOT NULL Skip loading a loan ceritification request if the Aid Processing Status is not 'Complete' (student has not been packaged).

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
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	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 Default Value: U
6	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
7	TRANSACTION_DATE	Date(10)	DATE	TRANSACTION_DATE
8	SFA_EA_TRANS_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Transaction number used for staging external awards to the database.
9	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
10	SFA_EA_TYPE	Character(3)	VARCHAR2(3) NOT NULL	External Award type (customer defined). Prompt Table: SFA_EA_TYPE
11	SFA_EA_SOURCE	Character(3)	VARCHAR2(3) NOT NULL	External Award source (customer defined). Prompt Table: SFA_EA_SOURCE
12	SFA_EA_PROGRAM_CD	Character(3)	VARCHAR2(3) NOT NULL	External Award program code (customer defined). Prompt Table: SFA_EA_PROGRAM
13	SFA_EA_NO_UPDATE	Character(12)	VARCHAR2(12) NOT NULL	External award load exclusionary equation for no update of student aid attribute. Prompt Table: SFA_EAEQTNS_VW
14	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
15	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
16	SFA_EA_LCR_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Skip loading a loan ceritification request if the Aid Processing Status is not 'Complete' (student has not been packaged).