VC_EPROPRD1_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. This step is necessary to build rows in the temporary table and identify the rows as ineligible rows. Ineligible periods are determined by searching for employee records in the VC_EEPROPRD_TAO table where an employee does not have a row for a given date of the payout period. All missing (date) rows need to be inserted back into the VC_EEPROPRD_TAO table but should be marked as Auto Ineligible. Due to the constraints in some databases, where a SELECT AND INSERT cannot be done on the same table, we will insert the missing rows into a separate table and then insert them back into the main VC_EEPROPRD_TAO table.

VC_EPROPRD1_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. This step is necessary to build rows in the temporary table and identify the rows as ineligible rows. Ineligible periods are determined by searching for employee records in the VC_EEPROPRD_TAO table where an employee does not have a row for a given date of the payout period. All missing (date) rows need to be inserted back into the VC_EEPROPRD_TAO table but should be marked as Auto Ineligible. Due to the constraints in some databases, where a SELECT AND INSERT cannot be done on the same table, we will insert the missing rows into a separate table and then insert them back into the main VC_EEPROPRD_TAO 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 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.