SDK_STOCK_TICKERPrompt Table: SDK_STOCK
SDK_STOCK_EXCHANGEPrompt Table: SDK_STOCKXCHG
Default Value: %date
Default Value: %datetime
SDK_STOCK_SR(SQL View) |
Index Back |
|---|---|
SDK Stock Quote SearchSDK Stock Quote Search |
| SELECT SDK_STOCK_TICKER , SDK_STOCK_EXCHANGE , SDK_DESCR , SDK_LAST_TRADE , SDK_LAST_TRADE_SIZ , SDK_LAST_TRADE_DT , SDK_LAST_TRADE_TME , SDK_TOTAL_SHARES , SDK_STOCK_NET_CHG , SDK_OPENING_TRADE , SDK_CLOSING_TRADE , SDK_BID_PRICE , SDK_ASK_PRICE , SDK_BID_X_ASK_SIZE , SDK_HIGH_TRADE , SDK_LOW_TRADE , SDK_LASTUPDDTTM FROM PS_SDK_STOCK |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SDK_STOCK_TICKER |
Character(12) | VARCHAR2(12) NOT NULL |
SDK Stock Ticker Symbol
Prompt Table: SDK_STOCK |
| 2 | SDK_STOCK_EXCHANGE |
Character(38) | VARCHAR2(38) NOT NULL |
SDK Stock Exchange Code
Prompt Table: SDK_STOCKXCHG |
| 3 | SDK_DESCR | Character(30) | VARCHAR2(30) NOT NULL | SDK Description |
| 4 | SDK_LAST_TRADE | Number(8,4) | DECIMAL(7,4) NOT NULL | SDK Last Trader Price |
| 5 | SDK_LAST_TRADE_SIZ | Number(9,0) | DECIMAL(9) NOT NULL | SDK Last Trade Size |
| 6 | SDK_LAST_TRADE_DT | Date(10) | DATE |
SDK Last Trade Date
Default Value: %date |
| 7 | SDK_LAST_TRADE_TME | Time(15) | TIMESTAMP | SDK Last Trade Time |
| 8 | SDK_TOTAL_SHARES | Number(13,0) | DECIMAL(13) NOT NULL | SDK Total Shares Traded Today |
| 9 | SDK_STOCK_NET_CHG | Signed Number(9,4) | DECIMAL(7,4) NOT NULL | SDK Net Change for Day |
| 10 | SDK_OPENING_TRADE | Number(8,4) | DECIMAL(7,4) NOT NULL | SDK Opening Trade Today |
| 11 | SDK_CLOSING_TRADE | Number(8,4) | DECIMAL(7,4) NOT NULL | SDK Closing Trade |
| 12 | SDK_BID_PRICE | Number(8,4) | DECIMAL(7,4) NOT NULL | SDK Bid Price |
| 13 | SDK_ASK_PRICE | Number(8,4) | DECIMAL(7,4) NOT NULL | SDK Ask Price |
| 14 | SDK_BID_X_ASK_SIZE | Character(9) | VARCHAR2(9) NOT NULL | SDK Bid Price |
| 15 | SDK_HIGH_TRADE | Number(8,4) | DECIMAL(7,4) NOT NULL | SDK High Trade |
| 16 | SDK_LOW_TRADE | Number(8,4) | DECIMAL(7,4) NOT NULL | SDK Daily Low Trade |
| 17 | SDK_LASTUPDDTTM | DateTime(26) | TIMESTAMP |
SDK Last Update Date Time
Default Value: %datetime |