SETIDDefault Value: OPR_DEF_TBL_CS.SETID
Prompt Table: SP_SETID_NONVW
WAIVER_CODEC=Use Criteria
E=Use Equation
N=No Criteria
G=Gross Waiver
N=Net Waiver
WAIVER_CODE_VW(SQL View) |
Index Back |
|---|---|
Waiver Code View |
| SELECT A.SETID , A.WAIVER_CODE , A.DESCR , B.WAIVE_PCT , B.WAIVER_OFFSET , B.ITEM_TYPE_GROUP , B.AMT_PER_UNIT , B.FLAT_AMT , B.MAX_AMOUNT , B.CURRENCY_CD , B.SSF_CRITR_EQUTN_SW , B.SSF_WAIVER_TYPE , X.XLATSHORTNAME FROM PS_WAIVER_CODE_TBL A , PS_WAIVER_TBL B , XLATTABLE_VW X 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 X.FIELDNAME = 'SSF_WAIVER_TYPE' AND X.FIELDVALUE = B.SSF_WAIVER_TYPE AND X.EFFDT = ( SELECT MAX(X1.EFFDT) FROM XLATTABLE_VW X1 WHERE X1.FIELDNAME = X.FIELDNAME AND X1.FIELDVALUE = X.FIELDVALUE AND X1.EFFDT <= %CurrentDateIn) AND X.EFF_STATUS = 'A' |
| # | 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 | WAIVER_OFFSET | Number(17,2) | DECIMAL(16,2) NOT NULL | Waiver Offset |
| 6 | ITEM_TYPE_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Item Type Group |
| 7 | AMT_PER_UNIT | Number(17,2) | DECIMAL(16,2) NOT NULL | Amount Per Unit |
| 8 | FLAT_AMT | Number(17,2) | DECIMAL(16,2) NOT NULL | Flat Amount |
| 9 | MAX_AMOUNT | Number(17,2) | DECIMAL(16,2) NOT NULL | Maximum Amount |
| 10 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 11 | SSF_CRITR_EQUTN_SW | Character(1) | VARCHAR2(1) NOT NULL |
Criteria Equation switch
C=Use Criteria E=Use Equation N=No Criteria |
| 12 | SSF_WAIVER_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Waiver Type Indicator to identify whether the waiver is appllied to the Gross amount of charges, or the current Net amount, based on prior waiver reductions.
G=Gross Waiver N=Net Waiver |
| 13 | XLATSHORTNAME | Character(10) | VARCHAR2(10) NOT NULL | Translate Value Short Name |