SFA_EASTAGESRCH

(SQL View)
 Index Back

EA Staging Detail View 1

Staging Detail view for data entry by EA Type, Source, and Program code.

SELECT B.INSTITUTION , B.AID_YEAR , B.SFA_EA_TYPE , B.SFA_EA_SOURCE , A.SFA_EA_TRANS_NBR , B.SFA_EA_SEQNO , A.TRANSACTION_DATE , A.PROCESS_INSTANCE , A.SFA_EA_TRANS_SRCE , A.SCCFP_MAP_ID , B.SFA_EA_PROGRAM_CD , B.SFA_EA_PROC_STAT , B.SFA_EA_PROC_DTTM , B.EMPLID , B.NATIONAL_ID , B.BIRTHDATE , B.LAST_NAME , B.FIRST_NAME , B.MIDDLE_NAME , B.ACAD_CAREER , B.SFA_EA_LOAN_CERT , B.SFA_EA_REPORT_CD , B.ITEM_TYPE , B.REL_ITEM_TYPE , B.DISBURSEMENT_PLAN , B.SPLIT_CODE , B.NET_AWARD_AMT , B.DISBURSED_AMOUNT , B.SFA_EA_PAY_STATUS , B.SFA_EA_ADJ_REASON , B.SFA_EA_INELIGIBLE , B.SFA_EA_SUSPEND_RSN , B.SFA_EA_LOAD_ERROR , B.SFA_EA_AWRD_ACTION FROM PS_SFA_EASTAGE_HDR A , PS_SFA_EASTAGE_DTL B WHERE A.SFA_EA_TRANS_NBR = B.SFA_EA_TRANS_NBR

# 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 SFA_EA_TYPE Character(3) VARCHAR2(3) NOT NULL External Award type (customer defined).

Prompt Table: SFA_EA_TYPE

4 SFA_EA_SOURCE Character(3) VARCHAR2(3) NOT NULL External Award source (customer defined).

Prompt Table: SFA_EA_SOURCE

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

Prompt Table: SFA_EASTAGE_HDR

6 SFA_EA_SEQNO Number(5,0) INTEGER NOT NULL Unique sequence for EA transactions.
7 TRANSACTION_DATE Date(10) DATE TRANSACTION_DATE
8 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
9 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
10 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

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_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
13 SFA_EA_PROC_DTTM DateTime(26) TIMESTAMP External award load process date/time stamp.
14 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
15 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
16 BIRTHDATE Date(10) DATE Date of Birth
17 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
18 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
19 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME
20 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
BAC=Bachelor (NLD)
BBL=Vocational Coaching (NLD)
BOL=Vocational Training (NLD)
BUSN=Graduate Business
CNED=Continuing Education
CRED=Semester Credit
EDU=Education (NLD)
EXED=Extended Education
GRAD=Graduate
LAW=Law
MEDS=Medical School
NONA=Non Award
PGRD=Postgraduate
RSCH=Research
TECH=Technical
UENG=Undergraduate Engineering
UGRD=Undergraduate
VAVO=Advanced General Educ. (NLD)
VETM=Veterinary Medicine
21 SFA_EA_LOAN_CERT Character(1) VARCHAR2(1) NOT NULL External Award Loan Certification flag (Y/N).
22 SFA_EA_REPORT_CD Character(1) VARCHAR2(1) NOT NULL External Award reporting code.
A=Add to existing
N=New
R=Replace existing
23 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type
24 REL_ITEM_TYPE Character(8) VARCHAR2(8) NOT NULL Related Item Group
25 DISBURSEMENT_PLAN Character(2) VARCHAR2(2) NOT NULL Disbursement Plan
26 SPLIT_CODE Character(2) VARCHAR2(2) NOT NULL Split Code
27 NET_AWARD_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL Net Award Amount
28 DISBURSED_AMOUNT Number(12,2) DECIMAL(11,2) NOT NULL Disbursed Amount
29 SFA_EA_PAY_STATUS Character(1) VARCHAR2(1) NOT NULL External award paid out (Y/N).
30 SFA_EA_ADJ_REASON Character(3) VARCHAR2(3) NOT NULL External award adjustment reason.
31 SFA_EA_INELIGIBLE Character(3) VARCHAR2(3) NOT NULL External award ineligibility code.
32 SFA_EA_SUSPEND_RSN Character(1) VARCHAR2(1) NOT NULL External Award Load suspend reason.
M=Multiple matches for student
N=Student not found
33 SFA_EA_LOAD_ERROR Number(5,0) INTEGER NOT NULL External award load error code.
34 SFA_EA_AWRD_ACTION Character(1) VARCHAR2(1) NOT NULL Externa Award load action.
B=Offer/Accept
O=Offer