VC_PLAN_IDPRD_END_DTVC_PAYOUT_PRD_IDGB_GROUP_IDVC_IND_ATN_VW(SQL View) |
Index Back |
|---|---|
Indiv. Goal Attainment Srch VwThis view is used as the search record for the Individual Goal Attainments panel group. |
| SELECT DISTINCT A.VC_PLAN_ID , B.PRD_END_DT , A.VC_PAYOUT_PRD_ID , A.GB_GROUP_ID FROM PS_VC_IND_GOAL A , PS_VC_PAYPRD_TBL B WHERE A.GB_GROUP_ID = 'NOGROUP' AND 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 |
| 2 | PRD_END_DT |
Date(10) | DATE | Pay Period End Date |
| 3 | VC_PAYOUT_PRD_ID |
Character(10) | VARCHAR2(10) NOT NULL | Payout Period ID |
| 4 | GB_GROUP_ID |
Character(15) | VARCHAR2(15) NOT NULL | Group Build ID. |