VC_WKDY_SCHD_DY (SQL Table)	Index Back
Work Schedule Defn table A Work Schedule definition table controls the factor to be applied for each day of the week. This table used by Variable Compensation is applicable only if the proration frequency selected is Workdays.

VC_WKDY_SCHD_DY

(SQL Table)

Work Schedule Defn table

A Work Schedule definition table controls the factor to be applied for each day of the week. This table used by Variable Compensation is applicable only if the proration frequency selected is Workdays.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 VC_WRK_DY_RULE_ID Character(8) VARCHAR2(8) NOT NULL A Working Days Rule ID defines the day pattern for a week. The definition of a day is governed by the value in the VC_DAY_FACTOR field. A '0' (zero) value in the factor would mean a Non-Working day, and a '1' would be identified as a full working day.

2 EFFDT Date(10) DATE Effective Date
Default Value: %date

3 DAY_OF_WK Character(1) VARCHAR2(1) NOT NULL Day of the Week
1=Sunday
2=Monday
3=Tuesday
4=Wednesday
5=Thursday
6=Friday
7=Saturday

4 VC_DAY_FACTOR Number(6,2) DECIMAL(5,2) NOT NULL Day Factor is used to calculate the factor for proration when the proration method is workdays. This field is used in conjuction with a Day of the week to identify if the day is a working day, a non-working day or any other fraction of a day.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	VC_WRK_DY_RULE_ID	Character(8)	VARCHAR2(8) NOT NULL	A Working Days Rule ID defines the day pattern for a week. The definition of a day is governed by the value in the VC_DAY_FACTOR field. A '0' (zero) value in the factor would mean a Non-Working day, and a '1' would be identified as a full working day.
2	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	DAY_OF_WK	Character(1)	VARCHAR2(1) NOT NULL	Day of the Week 1=Sunday 2=Monday 3=Tuesday 4=Wednesday 5=Thursday 6=Friday 7=Saturday
4	VC_DAY_FACTOR	Number(6,2)	DECIMAL(5,2) NOT NULL	Day Factor is used to calculate the factor for proration when the proration method is workdays. This field is used in conjuction with a Day of the week to identify if the day is a working day, a non-working day or any other fraction of a day.