SAD_WVRBASCDVW

(SQL View)
 Index Back

AAWS App Fee Waiver Codes

This view is for the AAWS Application Fee Waiver LOV waiver basis codes.

SELECT A.INSTITUTION ,A.ADM_APPL_CTR ,B.SAD_WAIVER_BASIS ,C.DESCR FROM PS_ADM_APPLCTR_TBL A , PS_SAD_APP_FEE_WVR B , PS_SAD_FEE_WVR_BAS C WHERE A.INSTITUTION = B.INSTITUTION AND A.ADM_APPL_CTR = B.ADM_APPL_CTR AND B.SAD_WAIVER_BASIS = C.SAD_WAIVER_BASIS AND A.SAD_APP_FEE_REQ ='Y' AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_ADM_APPLCTR_TBL A1 WHERE A1.INSTITUTION = A.INSTITUTION AND A1.ADM_APPL_CTR = A.ADM_APPL_CTR AND A1.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A' AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_SAD_APP_FEE_WVR B1 WHERE B1.INSTITUTION = B.INSTITUTION AND B1.ADM_APPL_CTR = B.ADM_APPL_CTR AND B1.SAD_WAIVER_BASIS = B.SAD_WAIVER_BASIS AND B1.EFFDT <= %CurrentDateIn) AND B.EFF_STATUS = 'A' AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_SAD_FEE_WVR_BAS C1 WHERE C1.INSTITUTION = C.INSTITUTION AND C1.SAD_WAIVER_BASIS = C.SAD_WAIVER_BASIS AND C1.EFFDT <= %CurrentDateIn) AND C.EFF_STATUS = 'A'

  • Related Language Record: SAD_WVRBASCDVWL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    2 ADM_APPL_CTR Character(4) VARCHAR2(4) NOT NULL Application Center
    3 SAD_WAIVER_BASIS Character(6) VARCHAR2(6) NOT NULL Fee Waiver Basis Code.
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description