VC_PLAN_IDVC_PAYOUT_PRD_IDVC_PLAN_TREE_VW(SQL View) |
Index Back |
|---|---|
VC - Tree name for VC PlanVariable Compensation: This view returns availables tree names for each VC plan. |
| SELECT VC.VC_PLAN_ID , TR.TREE_NAME , PP.VC_PAYOUT_PRD_ID , PP.PRD_END_DT , TR.EFFDT FROM PS_VC_PLAN_EFFDT VC , PS_VC_PAYPRD_TBL PP , PSTREEDEFN TR WHERE VC.VC_PLAN_ID = PP.VC_PLAN_ID AND VC.EFFDT = ( SELECT MAX(VC2.EFFDT) FROM PS_VC_PLAN_EFFDT VC2 WHERE VC2.VC_PLAN_ID = VC.VC_PLAN_ID AND VC2.EFFDT <= PP.PRD_END_DT AND VC2.EFF_STATUS = 'A') AND TR.TREE_NAME = VC.TREE_NAME AND TR.EFFDT = ( SELECT MAX(EFFDT) FROM PSTREEDEFN TR2 WHERE TR2.TREE_NAME = VC.TREE_NAME AND TR2.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 | TREE_NAME | Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| 3 | VC_PAYOUT_PRD_ID |
Character(10) | VARCHAR2(10) NOT NULL | Payout Period ID |
| 4 | PRD_END_DT | Date(10) | DATE | Pay Period End Date |
| 5 | VC_TREE_DT | Date(10) | DATE | VC_TREE_DT |