SETIDWIZARD_TYPELDY=Laundry
MSC=Misc Charges
PHN=Telephone
PRK=Parking
RC=Room Charge
RS=Room Service
RS1=Room Service 1
RS2=Room Service 2
RS3=Room Service 3
RT=Room Tax
EX_WIZ_RS_VW(SQL View) |
Index Back |
|---|---|
Wizard Room Service View |
| SELECT DISTINCT A.SETID , A.WIZARD_TYPE , A.EXPENSE_TYPE , B.DESCRSHORT FROM PS_EX_WIZARD_TBL A , PS_EX_TYPES_TBL B WHERE A.EXPENSE_TYPE = B.EXPENSE_TYPE AND A.WIZARD_TYPE IN ('RS', 'RS1', 'RS2', 'RS3') AND A.SETID = B.SETID AND B.EFF_STATUS = 'A' AND B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_EX_TYPES_TBL C WHERE C.SETID = B.SETID AND C.EXPENSE_TYPE = B.EXPENSE_TYPE AND C.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | WIZARD_TYPE |
Character(3) | VARCHAR2(3) NOT NULL |
Wizard Type Definition
LDY=Laundry MSC=Misc Charges PHN=Telephone PRK=Parking RC=Room Charge RS=Room Service RS1=Room Service 1 RS2=Room Service 2 RS3=Room Service 3 RT=Room Tax |
| 3 | EXPENSE_TYPE | Character(7) | VARCHAR2(7) NOT NULL | Expense Type |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |