RF_ENTL_LVW (SQL View)	Index Back
Entitlements View Language Related View. Entitlement view contains all entitlements including timezone and holiday schedule information. As the view has translated value of entitlement descr (from entitlement table) and holiday schedule desc (from service level table). The view is translated entitlement reference to translated service level union translated enttilement reference to un-translated service level union non-translated entitlement reference to translated service level.

RF_ENTL_LVW

(SQL View)

Entitlements View

Language Related View. Entitlement view contains all entitlements including timezone and holiday schedule information. As the view has translated value of entitlement descr (from entitlement table) and holiday schedule desc (from service level table). The view is translated entitlement reference to translated service level union translated enttilement reference to un-translated service level union non-translated entitlement reference to translated service level.

SELECT e.SETID , e.ENTITLE_NAME , el.LANGUAGE_CD , el.DESCR , sl.HOLIDAY_DESCR FROM PS_RF_ENTITLEMENTS e , PS_RF_ENTITLE_LANG el , PS_RF_SVC_LVL_H_VL sl WHERE e.SETID = sl.SETID AND e.ENTITLE_NAME = el.ENTITLE_NAME AND e.SERVICE_LVL_CD = sl.SERVICE_LVL_CD AND e.SETID = el.SETID AND el.LANGUAGE_CD = sl.LANGUAGE_CD UNION SELECT e2.SETID , e2.ENTITLE_NAME , el2.LANGUAGE_CD , el2.DESCR , ' ' FROM PS_RF_ENTITLEMENTS e2 , PS_RF_ENTITLE_LANG el2 WHERE e2.SETID = el2.SETID AND e2.ENTITLE_NAME = el2.ENTITLE_NAME AND NOT EXISTS ( SELECT 'x' FROM PS_RF_SVC_LVL_H_VL sl2 WHERE e2.SETID = sl2.SETID AND e2.SERVICE_LVL_CD = sl2.SERVICE_LVL_CD AND sl2.LANGUAGE_CD = el2.LANGUAGE_CD)

Related Language Record for RF_ENTL_VW

# 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

5 HOLIDAY_DESCR Character(30) VARCHAR2(30) NOT NULL Holiday Schedule Description field.

#	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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	HOLIDAY_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Holiday Schedule Description field.