STOCK_IDSTOCK_PLANGRANT_NBRST_GRANT_NBR_VW(SQL View) |
Index Back |
|---|---|
Grant Number Vw by ID/PlanGrant number view by stock id/stock plan. |
| SELECT A.STOCK_ID , A.STOCK_PLAN , A.GRANT_NBR , A.EMPLID , B.NAME FROM PS_ST_GRANT A , PS_PERSON_NAME B WHERE %Join(COMMON_KEYS, ST_GRANT A, PERSON_NAME B) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | STOCK_ID |
Character(10) | VARCHAR2(10) NOT NULL | Company's Stock Identification Symbol |
| 2 | STOCK_PLAN |
Character(10) | VARCHAR2(10) NOT NULL | Stock Plan |
| 3 | GRANT_NBR |
Character(10) | VARCHAR2(10) NOT NULL | System assigned grant number used to uniquely identify the grant record. |
| 4 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 5 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |