VC_MTX_PRD_VW(SQL View) |
Index Back |
---|---|
Pay Prds with Goal Mtx definedAll combinations Plan/Period for which a Goal Matrix has been defined. This view is uesd as a level 1 base record for the panels VC_MTX_GOAL_ATN and VC_MTX_GOAL_WG_ATN. |
SELECT DISTINCT A.VC_PLAN_ID , A.VC_PAYOUT_PRD_ID , A.PRD_BGN_DT , A.PRD_END_DT FROM PS_VC_PAYPRD_TBL A , PS_VC_MTX_GOAL_DEF B WHERE A.VC_PLAN_ID = B.VC_PLAN_ID AND A.VC_PAYOUT_PRD_ID = B.VC_PAYOUT_PRD_ID |
# | 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 |