RF_SVC_LVL_H_VL (SQL View)	Index Back
service level holiday view Related language view of the view storing service level holiday description information. It used for service level search based on holiday and timezone.

RF_SVC_LVL_H_VL

(SQL View)

service level holiday view

Related language view of the view storing service level holiday description information. It used for service level search based on holiday and timezone.

SELECT s.SETID , s.SERVICE_LVL_CD , h.LANGUAGE_CD , h.DESCR FROM PS_RF_SERVICE_LVL s , PS_HOLIDAY_LANG h WHERE s.HOLIDAY_SCHEDULE = h.HOLIDAY_SCHEDULE

Related Language Record for RF_SVC_LVL_H_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 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

3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

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