SSF_SWVR_DEF_VW

(SQL View)
 Index Back

Student Waiver Codes Vw

View used by Student Waivers page to show waiver codes setup as Student that are effective as at the Term specified.

SELECT C.BUSINESS_UNIT , C.STRM , A.WAIVER_CODE , B.DESCR , A.WAIVE_PCT , A.WAIVER_OFFSET , A.ITEM_TYPE_GROUP , A.AMT_PER_UNIT , A.FLAT_AMT , A.MAX_AMOUNT , A.CURRENCY_CD , A.SSF_CRITR_EQUTN_SW FROM PS_WAIVER_TBL A , PS_WAIVER_CODE_TBL B , PS_SSF_TERM_VW C WHERE A.SETID = B.SETID AND A.WAIVER_CODE = B.WAIVER_CODE AND A.SETID = ( SELECT D.SETID FROM PS_SET_CNTRL_REC D WHERE D.RECNAME='WAIVER_CODE_TBL' AND D.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'

  • Related Language Record: SSFSWVRDEFVWLNG

    • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 WAIVE_PCT Number(6,2) DECIMAL(5,2) NOT NULL Waive Percentage
    6 WAIVER_OFFSET Number(17,2) DECIMAL(16,2) NOT NULL Waiver Offset
    7 ITEM_TYPE_GROUP Character(10) VARCHAR2(10) NOT NULL Item Type Group
    8 AMT_PER_UNIT Number(17,2) DECIMAL(16,2) NOT NULL Amount Per Unit
    9 FLAT_AMT Number(17,2) DECIMAL(16,2) NOT NULL Flat Amount
    10 MAX_AMOUNT Number(17,2) DECIMAL(16,2) NOT NULL Maximum Amount
    11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    12 SSF_CRITR_EQUTN_SW Character(1) VARCHAR2(1) NOT NULL Criteria Equation switch
    C=Use Criteria
    E=Use Equation
    N=No Criteria