FT_RUN_IDCOMPANYVC_PLAN_IDVC_PAYOUT_PRD_IDCURRENCY_CDFT_VCAWD_SUM_VW(SQL View) |
Index Back |
|---|---|
Variable Comp AwardsThis record stores all Variable Compensation awards for an employee. This is the record that serves as input to NA Payroll and Stock Administration for integration purposes, as well as the source record when VC awards are published for any 3rd-party subscriber. |
| SELECT DISTINCT FT_RUN_ID , COMPANY , VC_PLAN_ID , VC_PAYOUT_PRD_ID , CURRENCY_CD FROM %Table(FT_VC_AWARD_STG) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FT_RUN_ID |
Number(18,0) | DECIMAL(18) NOT NULL | LEGAL_ENTITY_ID |
| 2 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 3 | VC_PLAN_ID |
Character(10) | VARCHAR2(10) NOT NULL | VC Plan ID |
| 4 | VC_PAYOUT_PRD_ID |
Character(10) | VARCHAR2(10) NOT NULL | Payout Period ID |
| 5 | CURRENCY_CD |
Character(3) | VARCHAR2(3) NOT NULL | Currency Code |