RC_VC_ELIG_PRO (SQL Table)	Index Back
VC Elig/Pro Run Control This is the run control record to store input parameters to run the Variable Compensation Eligibility/Proration process.

RC_VC_ELIG_PRO

(SQL Table)

VC Elig/Pro Run Control

This is the run control record to store input parameters to run the Variable Compensation Eligibility/Proration process.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

3 VC_PLAN_ID Character(10) VARCHAR2(10) NOT NULL VC Plan ID
Prompt Table: VC_ELIG_PLAN_VW

4 VC_PAYOUT_PRD_ID Character(10) VARCHAR2(10) NOT NULL Payout Period ID
Prompt Table: VC_ELIG_PRD_VW

5 PRD_BGN_DT Date(10) DATE Period Begin Date
Prompt Table: VC_RUN_ELIG_VW

6 PRD_END_DT Date(10) DATE Pay Period End Date
Prompt Table: VC_PRORATE_DT

7 THRUDATE Date(10) DATE End Date

8 FROMDATE Date(10) DATE From Date

9 VC_PLAN_MEM_CRIT Character(2) VARCHAR2(2) NOT NULL Plan Member Criteria
A=Ad Hoc Award
E=Empl VC Record
G=Empl VC Record with Groups
T=Define Tree/Group

10 AS_OF_DATE Date(10) DATE As of Date

11 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name

12 VC_TREE_DT Date(10) DATE VC_TREE_DT

13 VC_PRORATION_IND Character(2) VARCHAR2(2) NOT NULL Calculate Proration

14 VC_ORG_PLAN_WEIGHT Number(6,2) DECIMAL(5,2) NOT NULL Org Goal Weight

15 VC_GRP_PLAN_WEIGHT Number(6,2) DECIMAL(5,2) NOT NULL Group Goal Weight

16 VC_IND_PLAN_WEIGHT Number(6,2) DECIMAL(5,2) NOT NULL Ind Goal Weight

17 VC_GOAL_TYPE Character(2) VARCHAR2(2) NOT NULL Plan Goal Type
G=Weighted Goals
M=Goals Matrix

18 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

19 VC_PRT_RULE_ID Character(8) VARCHAR2(8) NOT NULL Users have the ability to define proration percentages for different employee statuses in the system. A Rule ID holds the definition to be created centrally and be shared between different VC Plans instead of having to redefine the same propration percentage on each plan.

20 VC_PRORATION_FREQ Character(1) VARCHAR2(1) NOT NULL Proration Frequency
D=Calendar Days
K=By Workdays
M=Monthly
W=Weekly

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	VC_PLAN_ID	Character(10)	VARCHAR2(10) NOT NULL	VC Plan ID Prompt Table: VC_ELIG_PLAN_VW
4	VC_PAYOUT_PRD_ID	Character(10)	VARCHAR2(10) NOT NULL	Payout Period ID Prompt Table: VC_ELIG_PRD_VW
5	PRD_BGN_DT	Date(10)	DATE	Period Begin Date Prompt Table: VC_RUN_ELIG_VW
6	PRD_END_DT	Date(10)	DATE	Pay Period End Date Prompt Table: VC_PRORATE_DT
7	THRUDATE	Date(10)	DATE	End Date
8	FROMDATE	Date(10)	DATE	From Date
9	VC_PLAN_MEM_CRIT	Character(2)	VARCHAR2(2) NOT NULL	Plan Member Criteria A=Ad Hoc Award E=Empl VC Record G=Empl VC Record with Groups T=Define Tree/Group
10	AS_OF_DATE	Date(10)	DATE	As of Date
11	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name
12	VC_TREE_DT	Date(10)	DATE	VC_TREE_DT
13	VC_PRORATION_IND	Character(2)	VARCHAR2(2) NOT NULL	Calculate Proration
14	VC_ORG_PLAN_WEIGHT	Number(6,2)	DECIMAL(5,2) NOT NULL	Org Goal Weight
15	VC_GRP_PLAN_WEIGHT	Number(6,2)	DECIMAL(5,2) NOT NULL	Group Goal Weight
16	VC_IND_PLAN_WEIGHT	Number(6,2)	DECIMAL(5,2) NOT NULL	Ind Goal Weight
17	VC_GOAL_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Plan Goal Type G=Weighted Goals M=Goals Matrix
18	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
19	VC_PRT_RULE_ID	Character(8)	VARCHAR2(8) NOT NULL	Users have the ability to define proration percentages for different employee statuses in the system. A Rule ID holds the definition to be created centrally and be shared between different VC Plans instead of having to redefine the same propration percentage on each plan.
20	VC_PRORATION_FREQ	Character(1)	VARCHAR2(1) NOT NULL	Proration Frequency D=Calendar Days K=By Workdays M=Monthly W=Weekly
21	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.