VC_PLAN_IDPrompt Table: VC_PLAN_TBL
VC_PAYOUT_PRD_IDVC_PAYPRD_TBL(SQL Table) |
Index Back |
|---|---|
Variable Comp Payout Periods"This table stores the payout period start and end dates. It also stores the org performance factors, when applicable, for each payout period." |
| # | 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_PAYOUT_PRD_ID |
Character(10) | VARCHAR2(10) NOT NULL | Payout Period ID |
| 3 | PRD_BGN_DT | Date(10) | DATE NOT NULL | Period Begin Date |
| 4 | PRD_END_DT | Date(10) | DATE NOT NULL | Pay Period End Date |
| 5 | VC_ORG_PERF_FACTOR | Number(20,4) | DECIMAL(19,4) NOT NULL | Organizational Performance Factor field used in variable compensation. |