RF_SCHED_TBL_VW (SQL View)	Index Back
View of Schedule Table View for Schedule Table being used in Contracts Integration

RF_SCHED_TBL_VW

(SQL View)

View of Schedule Table

View for Schedule Table being used in Contracts Integration

SELECT setid ,schedule ,descr ,day_of_wk ,day_of_month FROM PS_SCHEDULE_TBL WHERE FREQUENCY IN ('W','M','A') AND schedule <> 'EOM'

Related Language Record: RF_SCHDTBLVW_LG

# 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 SCHEDULE Character(10) VARCHAR2(10) NOT NULL Schedule for integration with Contracts.

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

4 DAY_OF_WK Character(2) VARCHAR2(2) NOT NULL Determines the day of the week for which route schedule dates will be generated when the weekly route scheduling option is chosen on the Route Calendar Maintenance Panel.
1=Monday
2=Tuesday
3=Wednesday
4=Thursday
5=Friday
6=Saturday
7=Sunday

5 DAY_OF_MONTH Number(2,0) SMALLINT NOT NULL Day of the Month

#	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	SCHEDULE	Character(10)	VARCHAR2(10) NOT NULL	Schedule for integration with Contracts.
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	DAY_OF_WK	Character(2)	VARCHAR2(2) NOT NULL	Determines the day of the week for which route schedule dates will be generated when the weekly route scheduling option is chosen on the Route Calendar Maintenance Panel. 1=Monday 2=Tuesday 3=Wednesday 4=Thursday 5=Friday 6=Saturday 7=Sunday
5	DAY_OF_MONTH	Number(2,0)	SMALLINT NOT NULL	Day of the Month