VC_PLAN_DATA(SQL Table) |
Index Back |
|---|---|
Variable Comp Plan Data.This record stores data for Variable Compensation Plans. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  VC_PLAN_ID |
Character(10) | VARCHAR2(10) NOT NULL | VC Plan ID |
| 2 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 3 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 4 | PLAN_START_DT | Date(10) | DATE NOT NULL | Plan Start Date |
| 5 | PLAN_END_DT | Date(10) | DATE NOT NULL | Plan End Date |
| 6 | VC_PLAN_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
VC Plan Type
D=Discretionary Bonus G=Goal Sharing I=Stock - ISO K=Stock - NSAR N=Non-Monetary O=Other P=Profit Sharing Q=Stock - NQ R=Stock - RSA S=Stock- ISAR |
| 7 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 8 | GOAL_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Plan Goal Type
G=Weighted Goals M=Goals Matrix |
| 9 | PLAN_MEM_CRIT | Character(2) | VARCHAR2(2) NOT NULL |
Plan Member Criteria
A=Ad-Hoc Award E=Empl Var Comp Record G=Empl Var Comp Rec with Grps T=Define Tree/Groups |
| 10 | CARRYOVER_IND | Character(2) | VARCHAR2(2) NOT NULL |
Carryover Awards
Y/N Table Edit |
| 11 | FUND_IND | Character(2) | VARCHAR2(2) NOT NULL |
Funded Plan
Y/N Table Edit |
| 12 | FUND_AVAILABLE | Number(19,6) | DECIMAL(18,6) NOT NULL | Funds Available |