RF_SO_ENT_WAR (SQL View)	Index Back
Agreement Line Entitlements Used to display the entitlements associated with a warranty.

RF_SO_ENT_WAR

(SQL View)

Agreement Line Entitlements

Used to display the entitlements associated with a warranty.

SELECT A.SETID , A.ENTITLE_NAME , A.WARRANTY_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_WARRANT_ENTL A , PS_RF_ENTITLEMENTS B WHERE B.SETID = ( SELECT C.SETID FROM PS_SET_CNTRL_REC C WHERE C.SETCNTRLVALUE = A.SETID AND C.RECNAME = 'RF_ENTITLEMENTS') 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.
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
Prompt Table: RF_ENTITLEMENTS

3 WARRANTY_NAME Character(40) VARCHAR2(40) NOT NULL This field is used to store the name of the warranty.

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
Prompt Table: RF_SERVICE_LVL
Set Control Field: SERVICE_LVL_CD

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

#	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 Prompt Table: RF_ENTITLEMENTS
3	WARRANTY_NAME	Character(40)	VARCHAR2(40) NOT NULL	This field is used to store the name of the warranty.
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 Prompt Table: RF_SERVICE_LVL Set Control Field: SERVICE_LVL_CD
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