VC_PLAN_IDVC_PAYOUT_PRD_IDEFFDTA=Ad Hoc Award
E=Empl VC Record
G=Empl VC Record with Groups
T=Define Tree/Group
VC_PLN_MEM_SRCH(SQL View) |
Index Back |
|---|---|
Plan member search recordVariable Comp: search record for plan member without groups panel |
| SELECT E.VC_PLAN_ID , C.VC_PAYOUT_PRD_ID , B.EFFDT , E.DESCR50 , B.TREE_NAME , C.PRD_BGN_DT , C.PRD_END_DT , E.VC_PLAN_MEM_CRIT , B.VC_PRORATION_IND FROM PS_VC_PLAN_EFFDT B , PS_VC_PAYPRD_TBL C , PS_VC_PLAN_TBL E WHERE B.VC_PLAN_ID = C.VC_PLAN_ID AND C.VC_PLAN_ID = E.VC_PLAN_ID AND B.EFFDT=( SELECT MAX(EFFDT) FROM PS_VC_PLAN_EFFDT VC_PLAN_EFFDT WHERE VC_PLAN_EFFDT.VC_PLAN_ID=B.VC_PLAN_ID AND VC_PLAN_EFFDT.EFFDT<=C.PRD_END_DT) AND B.EFF_STATUS = 'A' AND VC_PLAN_MEM_CRIT IN ('A', 'E') |
| # | 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 | EFFDT |
Date(10) | DATE | Effective Date |
| 4 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 5 | TREE_NAME | Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| 6 | PRD_BGN_DT | Date(10) | DATE | Period Begin Date |
| 7 | PRD_END_DT | Date(10) | DATE | Pay Period End Date |
| 8 | VC_PLAN_MEM_CRIT | Character(2) | VARCHAR2(2) NOT NULL |
Plan Member Criteria
A=Ad Hoc Award E=Empl VC Record G=Empl VC Record with Groups T=Define Tree/Group |
| 9 | VC_PRORATION_IND | Character(2) | VARCHAR2(2) NOT NULL | Calculate Proration |