SSFSWVRDEFVWLNG

(SQL View)
 Index Back

Rel Lang Stdnt Waiver View

SSFSWVRDEFVWLNG is the language record view related to SSF_SWVR_DEF_VW.

SELECT C.BUSINESS_UNIT , C.STRM , A.WAIVER_CODE , D.LANGUAGE_CD , D.DESCR FROM PS_WAIVER_TBL A , PS_WAIVER_CODE_TBL B , PS_SSF_TERM_VW C , PS_WAIVERCODETBLLN D WHERE A.SETID = B.SETID AND A.WAIVER_CODE = B.WAIVER_CODE AND A.SETID = ( SELECT E.SETID FROM PS_SET_CNTRL_REC E WHERE E.RECNAME='WAIVER_CODE_TBL' AND E.SETCNTRLVALUE=C.BUSINESS_UNIT) AND A.EFFDT = ( SELECT MAX(W.EFFDT) FROM PS_WAIVER_TBL W WHERE W.SETID = A.SETID AND W.WAIVER_CODE = A.WAIVER_CODE AND W.EFFDT <= C.TERM_BEGIN_DT) AND A.EFF_STATUS = 'A' AND A.SSF_STDNT_WVR_FLG = 'Y' AND B.SETID = D.SETID AND B.WAIVER_CODE = D.WAIVER_CODE

  • Related Language Record for SSF_SWVR_DEF_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 STRM Character(4) VARCHAR2(4) NOT NULL Term
    3 WAIVER_CODE Character(6) VARCHAR2(6) NOT NULL Waiver Code
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description