STOCK_IDSTOCK_PLANEMPLIDPrompt Table: ST_GRANT_VW1
ST_GRNT_MOD_VW(SQL View) |
Index Back |
|---|---|
Stock ID/Plan/EmplID ViewThis view list the employees by stock id, stock plan order. |
| SELECT DISTINCT A.STOCK_ID , A.STOCK_PLAN , A.EMPLID ,B.NAME FROM PS_ST_GRANT A , PS_PERSON_NAME B WHERE A.EMPLID = B.EMPLID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | STOCK_ID |
Character(10) | VARCHAR2(10) NOT NULL | Stock ID |
| 2 | STOCK_PLAN |
Character(10) | VARCHAR2(10) NOT NULL | Stock Plan |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: ST_GRANT_VW1 |
| 4 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |