SFA_SS_AWDSRCH

(SQL View)
 Index Back

Select Awards for Self Service

View used to select Student Award Data available for Self Service.

SELECT B.EMPLID , B.INSTITUTION , B.AID_YEAR FROM PS_STDNT_AID_ATRBT B , PS_SS_FA_INSTALL C WHERE B.INSTITUTION = C.INSTITUTION AND B.AID_YEAR = C.AID_YEAR AND C.SS_FA_ALLOW_ACCESS = 'Y' AND ( (B.FA_SS_INQ_SECURITY = 'Y' AND EXISTS ( SELECT A.EMPLID FROM PS_STDNT_AWARDS A , PS_ITEM_TYPE_FA D WHERE A.EMPLID = B.EMPLID AND A.INSTITUTION = B.INSTITUTION AND A.AID_YEAR = B.AID_YEAR AND A.SETID = D.SETID AND A.AID_YEAR = D.AID_YEAR AND A.ITEM_TYPE = D.ITEM_TYPE AND D.EFFDT = ( SELECT MAX(EFFDT) FROM PS_ITEM_TYPE_FA D1 WHERE D1.SETID = D.SETID AND D1.AID_YEAR = D.AID_YEAR AND D1.ITEM_TYPE = D.ITEM_TYPE AND D1.EFF_STATUS = 'A' AND D1.EFFDT <= %CurrentDateIn ) AND D.PRINT_LTR_OPTION = 'P') ) OR( B.SFA_EASS_ACCESS = 'Y' AND C.SFA_SS_EA_ACCESS='Y') OR C.SS_FA_SHOW_SUMMARY <> 'N' )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PEOPLE_SRCH

2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Default Value: OPR_DEF_TBL_CS.INSTITUTION

Prompt Table: INSTITUTION_TBL

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

Default Value: OPR_DEF_TBL_CS.AID_YEAR

Prompt Table: AID_YEAR_TBL