SFA_EA_SSINQ_VW (SQL View)	Index Back
External Awards Status View Search view of external award staging table for the primary purposes of managing data by processing status.

SFA_EA_SSINQ_VW

(SQL View)

External Awards Status View

Search view of external award staging table for the primary purposes of managing data by processing status.

SELECT DISTINCT A.INSTITUTION , A.AID_YEAR , A.SFA_EA_PROC_STAT , A.EMPLID , C.NAME , B.TRANSACTION_DATE FROM PS_SFA_EASTAGE_DTL A , PS_SFA_EASTAGE_HDR B , PS_SCC_PRI_NAME_VW C WHERE B.SFA_EA_TRANS_SRCE = '05' AND A.SFA_EA_TRANS_NBR = B.SFA_EA_TRANS_NBR AND A.EMPLID = C.EMPLID AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_SCC_PRI_NAME_VW C1 WHERE C1.EMPLID = C.EMPLID AND C1.EFFDT <= %CurrentDateIn)

# 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_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: R

4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

5 NAME Character(50) VARCHAR2(50) NOT NULL Name

6 TRANSACTION_DATE Date(10) DATE TRANSACTION_DATE

#	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_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: R
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
5	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
6	TRANSACTION_DATE	Date(10)	DATE	TRANSACTION_DATE