ST_PRC_RVSL_VW1(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_STOCK_ACTN_TBL S1 , PS_STOCK_ACTN_TBL S2 , PS_ST_GRANT_VEST V , PS_ST_GRANT G WHERE V.EMPLID = P.EMPLID AND P.EMPLID = G.EMPLID AND P.EMPL_RCD = G.EMPL_RCD AND V.STOCK_ID = P.STOCK_ID AND P.STOCK_ID = G.STOCK_ID AND V.GRANT_NBR = G.GRANT_NBR AND V.VEST_EFFDT = ( SELECT MAX(VEST_EFFDT) FROM PS_ST_GRANT_VEST WHERE EMPLID = V.EMPLID AND STOCK_ID = V.STOCK_ID AND GRANT_NBR = V.GRANT_NBR AND VEST_EFFDT <= P.STOCK_ACTION_DT) AND V.SEQ_NUM = ( SELECT MAX(SEQ_NUM) FROM PS_ST_GRANT_VEST WHERE EMPLID = V.EMPLID AND STOCK_ID = V.STOCK_ID AND GRANT_NBR = V.GRANT_NBR AND VEST_EFFDT = V.VEST_EFFDT) AND S1.STOCK_ACTION_TYPE = S2.STOCK_ACTION_TYPE AND S1.STOCK_ACTION = P.STOCK_ACTION AND S2.STOCK_ACTION = V.VEST_REASON |
| # | 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 Rcd Nbr |
| 3 | STOCK_ID | Character(10) | VARCHAR2(10) NOT NULL |
Stock ID
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 |