EMPLIDSTOCK_IDST_PE_OPTN_VW(SQL View) |
Index Back |
|---|---|
Stock GrantsOptionee Grants |
| SELECT DISTINCT A.EMPLID , A.STOCK_ID , C.DESCR FROM PS_ST_GRANT A , PS_STOCK_TBL B , PS_COMPANY_TBL C WHERE A.STOCK_ID = B.STOCK_ID AND B.COMPANY = C.COMPANY AND %EffdtCheck(COMPANY_TBL, C, %CurrentDateIn) AND A.GRANT_STATUS = 'A' AND A.ST_CANCEL_REASON <> 'RESC' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | STOCK_ID |
Character(10) | VARCHAR2(10) NOT NULL | Stock ID |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |