SFA_EASTAGE_VW

(SQL View)
 Index Back

EA Staging - Header record

Header table for Financial Aid External Award Staging process.

SELECT DISTINCT A.SFA_EA_TRANS_NBR , A.TRANSACTION_DATE , A.SFA_EA_TRANS_SRCE , A.SCCFP_MAP_ID , A.FILENAME , B.SFA_EA_PROC_STAT FROM PS_SFA_EASTAGE_HDR A , PS_SFA_EASTAGE_DTL B WHERE A.SFA_EA_TRANS_NBR > 0 AND A.SFA_EA_TRANS_NBR = B.SFA_EA_TRANS_NBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SFA_EA_TRANS_NBR Number(15,0) DECIMAL(15) NOT NULL Transaction number used for staging external awards to the database.
2 TRANSACTION_DATE Date(10) DATE TRANSACTION_DATE

Default Value: %Date

3 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
4 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

5 FILENAME Character(80) VARCHAR2(80) NOT NULL File Name
6 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