EMPLIDSTOCK_IDST_SPLIT_VW(SQL View) |
Index Back |
|---|
| SELECT A.EMPLID , B.STOCK_ID , B.RECORD_DT , B.ST_SPLIT_SHARE_NEW , ' : ' , B.ST_SPLIT_SHARE_OLD FROM PS_ST_GRANT_VW2 A , PS_ST_SPLIT_TBL B WHERE A.STOCK_ID = B.STOCK_ID |
| # | 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 | Company's Stock Identification Symbol |
| 3 | RECORD_DT | Date(10) | DATE NOT NULL | Record Date |
| 4 | ST_SPLIT_SHARE_NEW | Number(3,0) | SMALLINT NOT NULL | Stock Split New Shares |
| 5 | ST_FOR_LIT | Character(5) | VARCHAR2(5) NOT NULL | For Literal |
| 6 | ST_SPLIT_SHARE_OLD | Number(3,0) | SMALLINT NOT NULL | Stock Split Old Shares |