VC_PLAN_IDVC_ST_PLAN_VW(SQL View) |
Index Back |
|---|---|
Variable Comp Stock PlansVC_ST_PLAN_VW is a view of VC_PLAN_TBL that returns only those compensation plans that are of stock type. |
| SELECT A.VC_PLAN_ID , A.DESCRSHORT FROM PS_VC_PLAN_TBL A WHERE A.VC_PLAN_TYPE IN ('I','K','Q','R','S') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | VC_PLAN_ID |
Character(10) | VARCHAR2(10) NOT NULL | VC Plan ID |
| 2 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |