RF_SVC_LVL_H_VW (SQL View)	Index Back
service level holiday view the view stores service level holiday description information. It used for service level search based on holiday and timezone.

RF_SVC_LVL_H_VW

(SQL View)

service level holiday view

the view stores service level holiday description information. It used for service level search based on holiday and timezone.

SELECT s.SETID , s.SERVICE_LVL_CD , s.TIMEZONE , s.HOLIDAY_SCHEDULE , h.DESCR FROM PS_RF_SERVICE_LVL s , PS_HOLIDAY_TBL h WHERE s.HOLIDAY_SCHEDULE = h.HOLIDAY_SCHEDULE (+)

Related Language Record: RF_SVC_LVL_H_VL

# 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 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone

4 HOLIDAY_SCHEDULE Character(6) VARCHAR2(6) NOT NULL This is the holiday schedule field.
Prompt Table: HOLIDAY_TBL

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	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	TIMEZONE	Character(9)	VARCHAR2(9) NOT NULL	Time Zone
4	HOLIDAY_SCHEDULE	Character(6)	VARCHAR2(6) NOT NULL	This is the holiday schedule field. Prompt Table: HOLIDAY_TBL
5	HOLIDAY_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Holiday Schedule Description field.