SAD_WVRBASCDVWL

(SQL View)
 Index Back

Lang Ref for SAD_WVRBASCDVW

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

SELECT A.INSTITUTION ,A.ADM_APPL_CTR ,B.SAD_WAIVER_BASIS ,C.LANGUAGE_CD ,C.DESCR FROM PS_ADM_APPLCTR_TBL A , PS_SAD_APP_FEE_WVR B , PS_SAD_FEE_WVR_LNG 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_LNG C1 WHERE C1.INSTITUTION = C.INSTITUTION AND C1.SAD_WAIVER_BASIS = C.SAD_WAIVER_BASIS AND C1.EFFDT <= %CurrentDateIn)

  • Related Language Record for SAD_WVRBASCDVW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description