RF_ENTPLAN_VW

(SQL View)
 Index Back

Entitlements from plan

Lists Entitlement characteristics for entries in entitlement plan

SELECT A.SETID , A.ENTITLE_PLAN_NAME , A.ENTITLE_NAME , B.DESCR , B.ENTITLE_TYPE , B.ENTITLE_MINUTES , B.SERVICE_LVL_CD , B.COVERAGE_TYPE , B.AGRT_COV_PCT , B.AGRT_COV_LEN , B.AGRT_COV_UOM , B.ENTITLE_PCT FROM PS_RF_ENTL_PL_DTL A , PS_RF_ENTITLEMENTS B WHERE A.SETID = B.SETID AND A.ENTITLE_NAME = B.ENTITLE_NAME

# 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.
2 ENTITLE_PLAN_NAME Character(10) VARCHAR2(10) NOT NULL This field represents the Entitlement Plan Name
3 ENTITLE_NAME Character(10) VARCHAR2(10) NOT NULL This field represents the name of the entitlement
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
5 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
6 ENTITLE_MINUTES Number(6,0) INTEGER NOT NULL This field represents the number of minutes for the response or restore time of an entitlement
7 SERVICE_LVL_CD Character(4) VARCHAR2(4) NOT NULL This field stores the Service Level Code.
7X24=7X24
ENH=Enhanced
PREF=Preferred
PREM=Premium
STD=Standard
8 COVERAGE_TYPE Character(4) VARCHAR2(4) NOT NULL This field represents the coverage type of an entitlement
EXP=Expenses
MAT=Material
TIME=Time
9 AGRT_COV_PCT Number(3,0) SMALLINT NOT NULL This field represents the agreement coverage percentage
10 AGRT_COV_LEN Number(6,0) INTEGER NOT NULL This field represents the agreement coverage length
11 AGRT_COV_UOM Character(4) VARCHAR2(4) NOT NULL This field represents agreement coverage unit of measurement
DAY=Day
MON=Month
WK=Week
YR=Year
12 ENTITLE_PCT Signed Number(4,0) DECIMAL(3) NOT NULL This field represents the entitlement uplift or discount percent