SETIDDefault Value: OPR_DEF_TBL_RB.SETID
Prompt Table: SP_SETID_NONVW
ENTITLE_NAMECOV=Guaranteed Coverage
PPM=Service Level
RESP=Guaranteed Response
REST=Guaranteed Restore
Prompt Table: HOLIDAY_TBL
RF_ENTL_VW(SQL View) |
Index Back |
|---|---|
Entitlements ViewEntitlement view contains all entitlements including timezone and holiday schedule information. |
| SELECT e.SETID , e.ENTITLE_NAME , e.ENTITLE_TYPE , e.DESCR , s.TIMEZONE , s.HOLIDAY_SCHEDULE , s.HOLIDAY_DESCR , e.ENTITLE_PCT FROM PS_RF_ENTITLEMENTS e , PS_RF_SVC_LVL_H_VW s WHERE e.SETID = s.SETID (+) AND e.SERVICE_LVL_CD = s.SERVICE_LVL_CD (+) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
Default Value: OPR_DEF_TBL_RB.SETID Prompt Table: SP_SETID_NONVW |
| 2 | ENTITLE_NAME |
Character(10) | VARCHAR2(10) NOT NULL | This field represents the name of the entitlement |
| 3 | ENTITLE_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
This field represents the type of entitlement
COV=Guaranteed Coverage PPM=Service Level RESP=Guaranteed Response REST=Guaranteed Restore |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | TIMEZONE | Character(9) | VARCHAR2(9) NOT NULL | Time Zone |
| 6 | HOLIDAY_SCHEDULE | Character(6) | VARCHAR2(6) NOT NULL |
This is the holiday schedule field.
Prompt Table: HOLIDAY_TBL |
| 7 | HOLIDAY_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Holiday Schedule Description field. |
| 8 | ENTITLE_PCT | Signed Number(4,0) | DECIMAL(3) NOT NULL | This field represents the entitlement uplift or discount percent |