SETIDDefault Value: OPR_DEF_TBL_CS.SETID
Prompt Table: SP_SETID_NONVW
WAIVER_CODESSF_STDNTWVR_VW(SQL View) |
Index Back |
|---|---|
Student Waiver Codes ViewView used for prompting to select waiver codes setup as Student Override. |
| 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 C.EFF_STATUS = 'A') AND B.SSF_STDNT_WVR_FLG = 'Y' |
| # | 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 |