VC_WD_SCHED_TAO (SQL Table)	Index Back
Temp table for VC Elig process This is a temporary table used by the eligibility processing program when proration method is workdays. For the purpose of the eligibility process, we need to keep identify the work schedules employee belongs to. Once the working days pattern are known, we need to associate the periods to the work schedules so that we can find the working days and the factor for each day. The data built here is used by the next process, which is linking employees to their Work schedules and building the working days and factor for each employee.

VC_WD_SCHED_TAO

(SQL Table)

Temp table for VC Elig process

This is a temporary table used by the eligibility processing program when proration method is workdays. For the purpose of the eligibility process, we need to keep identify the work schedules employee belongs to. Once the working days pattern are known, we need to associate the periods to the work schedules so that we can find the working days and the factor for each day. The data built here is used by the next process, which is linking employees to their Work schedules and building the working days and factor for each employee.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 VC_PLAN_ID Character(10) VARCHAR2(10) NOT NULL VC Plan ID

3 VC_PAYOUT_PRD_ID Character(10) VARCHAR2(10) NOT NULL Payout Period ID

4 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.

5 PRD_END_DT Date(10) DATE Pay Period End Date

6 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

7 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	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	VC_PLAN_ID	Character(10)	VARCHAR2(10) NOT NULL	VC Plan ID
3	VC_PAYOUT_PRD_ID	Character(10)	VARCHAR2(10) NOT NULL	Payout Period ID
4	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.
5	PRD_END_DT	Date(10)	DATE	Pay Period End Date
6	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
7	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.