ST_REPURCH_VW2(SQL View) |
Index Back |
---|---|
Grant Repurchase Process |
SELECT A.EMPLID , A.STOCK_ID , A.GRANT_NBR , B.REPURCHASE_NBR , B.REPURCHASE_DT , B.SHARES_REPURCHASED , B.REPURCHASE_STATUS FROM PS_ST_GRANT A , PS_ST_GRNT_REPURCH B WHERE A.EMPLID = B.EMPLID AND A.STOCK_ID = B.STOCK_ID AND A.GRANT_NBR = B.GRANT_NBR AND A.GRANT_STATUS = 'A' AND A.EXER_BFR_VEST = 'Y' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: ST_GRANT_VW1 |
2 | STOCK_ID | Character(10) | VARCHAR2(10) NOT NULL |
Stock ID
Default Value: ST_GRANT.STOCK_ID Prompt Table: ST_GRANT_VW2 |
3 | GRANT_NBR | Character(10) | VARCHAR2(10) NOT NULL |
System assigned grant number used to uniquely identify the grant record.
Prompt Table: ST_GRANT_VW3 |
4 | REPURCHASE_NBR | Number(8,0) | INTEGER NOT NULL | Unique system assigned number used to identify the repurchase. |
5 | REPURCHASE_DT | Date(10) | DATE | Date share were repurchased. |
6 | SHARES_REPURCHASED | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Number of shares repurchased. |
7 | REPURCHASE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status of the repurchase - active or void.
A=Active V=Void |