ST_VC_EXP_AET (SQL Table)	Index Back
Stock/VC Expiration State Rec State record for the Stock/Variable Comp Expiration process.

ST_VC_EXP_AET

(SQL Table)

Stock/VC Expiration State Rec

State record for the Stock/Variable Comp Expiration process.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

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

3 VC_PLAN_ID Character(10) VARCHAR2(10) NOT NULL VC Plan ID

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	VC_PLAN_ID	Character(10)	VARCHAR2(10) NOT NULL	VC Plan ID
4	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.