VC_EEPROPRD_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 track of the eligible and ineligible days for each employee in the processing period. The AE process will use this table and populate it with employees that the process identifies during each period. Once all the employees have been identified, it will scan through this table and populate it with dates for all the employees who have partial eligibility. The new rows being inserted will be marked as Auto-Ineligible.

VC_EEPROPRD_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 track of the eligible and ineligible days for each employee in the processing period. The AE process will use this table and populate it with employees that the process identifies during each period. Once all the employees have been identified, it will scan through this table and populate it with dates for all the employees who have partial eligibility. The new rows being inserted will be marked as Auto-Ineligible.

# 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 Rcd Nbr

7 PRD_END_DT Date(10) DATE Pay Period End Date

8 VC_ELIG_STATUS Character(2) VARCHAR2(2) NOT NULL Eligibility Status
AE=Auto Eligible
AI=Auto Ineligible
EP=Eligible with Proration
ME=Manual Eligible
MI=Manual Ineligble

9 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	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 Rcd Nbr
7	PRD_END_DT	Date(10)	DATE	Pay Period End Date
8	VC_ELIG_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Eligibility Status AE=Auto Eligible AI=Auto Ineligible EP=Eligible with Proration ME=Manual Eligible MI=Manual Ineligble
9	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.