VC_EEWSCHED_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 build a link between employees and their work schedules. This link is stored in this table.

VC_EEWSCHED_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 build a link between employees and their work schedules. This link is stored in this table.

# 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 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.

5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

6 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

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

8 VC_ELIG_PRO_DAYS Number(8,3) DECIMAL(7,3) NOT NULL Days Eliglble In Period

9 VC_TOTAL_DAYS Number(7,3) DECIMAL(6,3) NOT NULL Total Days is required for performing the Eligibitity Process in VC

#	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	GB_GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Group Build ID.
5	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
6	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
7	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.
8	VC_ELIG_PRO_DAYS	Number(8,3)	DECIMAL(7,3) NOT NULL	Days Eliglble In Period
9	VC_TOTAL_DAYS	Number(7,3)	DECIMAL(6,3) NOT NULL	Total Days is required for performing the Eligibitity Process in VC