SSF_NOSTDWVR_VW

(SQL View)
 Index Back

Non-Student Waiver Codes View

View used for prompting to select waiver codes which are not setup as Student Overrides. This is used in Tuition Groups to not allow Waivers defined as Student Override from being attached to a group. Also filters out Net Waivers.

SELECT A.SETID , A.WAIVER_CODE , A.DESCR , B.WAIVE_PCT , B.AMT_PER_UNIT , B.FLAT_AMT , B.MAX_AMOUNT FROM PS_WAIVER_CODE_TBL A , PS_WAIVER_TBL B WHERE B.SETID = A.SETID AND B.WAIVER_CODE = A.WAIVER_CODE AND B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_WAIVER_TBL C WHERE C.SETID = B.SETID AND C.WAIVER_CODE = B.WAIVER_CODE AND C.EFFDT <= %CurrentDateIn) AND B.EFF_STATUS = 'A' AND B.SSF_STDNT_WVR_FLG <> 'Y' AND B.SSF_WAIVER_TYPE = 'G'

  • Related Language Record: SSFNOSTDWVRVWLN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_CS.SETID

    Prompt Table: SP_SETID_NONVW

    2 WAIVER_CODE Character(6) VARCHAR2(6) NOT NULL Waiver Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 WAIVE_PCT Number(6,2) DECIMAL(5,2) NOT NULL Waive Percentage
    5 AMT_PER_UNIT Number(17,2) DECIMAL(16,2) NOT NULL Amount Per Unit
    6 FLAT_AMT Number(17,2) DECIMAL(16,2) NOT NULL Flat Amount
    7 MAX_AMOUNT Number(17,2) DECIMAL(16,2) NOT NULL Maximum Amount