EMPLIDEMPL_RCDEFFDTDefault Value: %date
VC_PLAN_IDPrompt Table: VC_EEVC_PLAN_VW
Prompt Table: VC_PAYFORM_TBL
Prompt Table: CURRENCY_CD_TBL
VC_EE_VCOMP_DTL(SQL Table) |
Index Back |
|---|---|
EE Variable Comp Detail RecordThis record stores the detail information regarding an employee's Variable Compensation record when a plan is administered by EE VC (as determined in the VC Plan table). This record stores, for each effective date, the information regarding any and all plan(s) the employee is enrolled, including the Target formula and eligibility 'as of' date. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | VC_PLAN_ID |
Character(10) | VARCHAR2(10) NOT NULL |
VC Plan ID
Prompt Table: VC_EEVC_PLAN_VW |
| 5 | ELIG_DATE | Date(10) | DATE | Eligiblity Date |
| 6 | VC_TARGET_PAYOUT | Character(10) | VARCHAR2(10) NOT NULL |
Target Payout
Prompt Table: VC_PAYFORM_TBL |
| 7 | VC_GUARANTEE_AMT | Number(19,6) | DECIMAL(18,6) NOT NULL | Guarantee Amount |
| 8 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 9 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |