VC_PLAN_FUNDING (SQL Table)	Index Back
Variable Comp Plan Funding "This record stores all funding at the plan level for Variable Compensation plans that get funded. This funding can be in dollars, units, or stock shares."

VC_PLAN_FUNDING

(SQL Table)

Variable Comp Plan Funding

"This record stores all funding at the plan level for Variable Compensation plans that get funded. This funding can be in dollars, units, or stock shares."

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 VC_PLAN_ID Character(10) VARCHAR2(10) NOT NULL VC Plan ID
Prompt Table: VC_PLAN_TBL

2 VC_FUND_DATE Date(10) DATE NOT NULL Funding Date
Default Value: %date

3 SEQ_NO Number(2,0) SMALLINT NOT NULL Sequence Number

4 VC_FUND_AMOUNT Signed Number(20,6) DECIMAL(18,6) NOT NULL This field is used by Variable Compensation to represent the dollar amount funded to a variable comp plan.

5 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Default Value: VC_PLAN_TBL.CURRENCY_CD
Prompt Table: CURRENCY_CD_TBL

6 VC_FUND_UNITS Signed Number(16,6) DECIMAL(14,6) NOT NULL This field is used by Variable Compensation to represent the number of units funded to a Variable Comp plan.

7 LAST_UPDT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Updated User Name

8 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	VC_PLAN_ID	Character(10)	VARCHAR2(10) NOT NULL	VC Plan ID Prompt Table: VC_PLAN_TBL
2	VC_FUND_DATE	Date(10)	DATE NOT NULL	Funding Date Default Value: %date
3	SEQ_NO	Number(2,0)	SMALLINT NOT NULL	Sequence Number
4	VC_FUND_AMOUNT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	This field is used by Variable Compensation to represent the dollar amount funded to a variable comp plan.
5	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: VC_PLAN_TBL.CURRENCY_CD Prompt Table: CURRENCY_CD_TBL
6	VC_FUND_UNITS	Signed Number(16,6)	DECIMAL(14,6) NOT NULL	This field is used by Variable Compensation to represent the number of units funded to a Variable Comp plan.
7	LAST_UPDT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Updated User Name
8	LAST_UPDATE_DTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.