SFA_EASTG_SRCH

(SQL View)
 Index Back

EA Data File Staging Search VW

Search View for Financial Aid External Award Data File Staging process.

SELECT DISTINCT B.INSTITUTION , B.AID_YEAR , A.SFA_EA_TRANS_NBR , A.TRANSACTION_DATE , A.PROCESS_INSTANCE , A.SCCFP_MAP_ID , D.SCCFP_MAP_NAME , A.FILENAME , B.SFA_EA_TYPE , B.SFA_EA_SOURCE FROM PS_SFA_EASTAGE_HDR A , PS_SFA_EASTAGE_DTL B , PS_SCCFP_MAP_DFN D WHERE A.SFA_EA_TRANS_NBR = B.SFA_EA_TRANS_NBR AND A.SCCFP_MAP_ID = D.SCCFP_MAP_ID AND A.SFA_EA_TRANS_SRCE = '02'

# 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

2 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

Default Value: OPR_DEF_TBL_CS.AID_YEAR

3 SFA_EA_TRANS_NBR Number(15,0) DECIMAL(15) NOT NULL Transaction number used for staging external awards to the database.
4 TRANSACTION_DATE Date(10) DATE TRANSACTION_DATE

Default Value: %Date

5 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
6 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

7 SCCFP_MAP_NAME Character(30) VARCHAR2(30) NOT NULL File Mapping name - the user key to a File Mapping

Prompt Table: SFA_EA_MAP_SRCH

8 FILENAME Character(80) VARCHAR2(80) NOT NULL File Name
9 SFA_EA_TYPE Character(3) VARCHAR2(3) NOT NULL External Award type (customer defined).
10 SFA_EA_SOURCE Character(3) VARCHAR2(3) NOT NULL External Award source (customer defined).