VC_PLAN_IDVC_PAYOUT_PRD_IDVC_PLN_EFFDT_VW(SQL View) |
Index Back |
|---|---|
VC - Effdt Row for Prorate PrdVariable Compensation: This view returns max effdt data for a plan based on payout period |
| SELECT VC.VC_PLAN_ID , PP.VC_PAYOUT_PRD_ID , PP.PRD_END_DT ,VC_ORG_PLAN_WEIGHT ,VC_GRP_PLAN_WEIGHT ,VC_IND_PLAN_WEIGHT ,VC_PRORATION_IND FROM PS_VC_PLAN_EFFDT VC , PS_VC_PAYPRD_TBL PP WHERE VC.VC_PLAN_ID = PP.VC_PLAN_ID AND VC.EFFDT = ( SELECT MAX(EFFDT) FROM PS_VC_PLAN_EFFDT VC2 WHERE VC2.VC_PLAN_ID = VC.VC_PLAN_ID AND VC2.EFFDT <= PP.PRD_END_DT ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | VC_PLAN_ID |
Character(10) | VARCHAR2(10) NOT NULL | VC Plan ID |
| 2 | VC_PAYOUT_PRD_ID |
Character(10) | VARCHAR2(10) NOT NULL | Payout Period ID |
| 3 | PRD_END_DT | Date(10) | DATE | Pay Period End Date |
| 4 | VC_ORG_PLAN_WEIGHT | Number(6,2) | DECIMAL(5,2) NOT NULL | Org Goal Weight |
| 5 | VC_GRP_PLAN_WEIGHT | Number(6,2) | DECIMAL(5,2) NOT NULL | Group Goal Weight |
| 6 | VC_IND_PLAN_WEIGHT | Number(6,2) | DECIMAL(5,2) NOT NULL | Ind Goal Weight |
| 7 | VC_PRORATION_IND | Character(2) | VARCHAR2(2) NOT NULL | Calculate Proration |