ST_PRC_RVSL_VW2(SQL View) |
Index Back |
|---|---|
Grant View for ReversalsThis view is used in the HR Integration Process to reverse a previous Stock Action. |
| SELECT G.EMPLID ,G.EMPL_RCD , G.STOCK_ID , G.STOCK_ACTION , G.STOCK_ACTION_DT , G.GRANT_NBR , G.GRANT_DT , G.ST_OPTION_TYPE FROM PS_ST_ACTN_PRC_TBL P , PS_ST_GRANT G WHERE P.EMPLID = G.EMPLID AND P.EMPL_RCD = G.EMPL_RCD AND P.STOCK_ID = G.STOCK_ID AND P.STOCK_ACTION = G.STOCK_ACTION AND P.STOCK_ACTION_DT = G.STOCK_ACTION_DT AND (P.GRANT_NBR = G.GRANT_NBR OR P.GRANT_NBR = ' ') AND (P.ST_OPTION_TYPE = G.ST_OPTION_TYPE OR P.ST_OPTION_TYPE = ' ') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | STOCK_ID | Character(10) | VARCHAR2(10) NOT NULL |
Company's Stock Identification Symbol
Prompt Table: ST_ACTN_PRC_VW1 |
| 4 | STOCK_ACTION | Character(3) | VARCHAR2(3) NOT NULL | Stock Action |
| 5 | STOCK_ACTION_DT | Date(10) | DATE | Date the stock action is effective. |
| 6 | GRANT_NBR | Character(10) | VARCHAR2(10) NOT NULL | System assigned grant number used to uniquely identify the grant record. |
| 7 | GRANT_DT | Date(10) | DATE | Grant Date |
| 8 | ST_OPTION_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Option Type
ISAR=ISO-Stock Appreciation Right ISO=Incentive Stock Option NQ=Non-Qualified NSAR=NQ-Stock Appreciation Right RSA=Restricted Stock Award |