SDK_STOCK_TICKERSDK_STOCK_EXCHANGEDefault Value: %date
Default Value: %datetime
SDK_STOCK(SQL Table) |
Index Back |
|---|---|
SDK Company Stock TableSDK Company Stock Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SDK_STOCK_TICKER |
Character(12) | VARCHAR2(12) NOT NULL | SDK Stock Ticker Symbol |
| 2 | SDK_STOCK_EXCHANGE |
Character(38) | VARCHAR2(38) NOT NULL | SDK Stock Exchange Code |
| 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_YEAR_HIGH | Number(8,4) | DECIMAL(7,4) NOT NULL | SDK 52 Week High |
| 18 | SDK_YEAR_LOW | Number(8,4) | DECIMAL(7,4) NOT NULL | SDK 52 Week Low |
| 19 | SDK_STK_DIVID_FREQ | Character(28) | VARCHAR2(28) NOT NULL | SDK Dividend Frequency - Dividend Frequency for Stock Pagelet |
| 20 | SDK_DIVIDEND_AMT | Number(8,4) | DECIMAL(7,4) NOT NULL | SDK Dividend Amount |
| 21 | SDK_DIVIDEND_DT | Date(10) | DATE | SDK Dividend Date |
| 22 | SDK_EX_DIVIDEND_DT | Date(10) | DATE | SDK Exchange Dividend Date |
| 23 | SDK_EARNINGS_SHARE | Number(18,4) | DECIMAL(17,4) NOT NULL | SDK Edit |
| 24 | SDK_SHARE_OUTSTAND | Number(13,0) | DECIMAL(13) NOT NULL | SDK Shares Outstanding |
| 25 | SDK_PE_RATIO | Number(10,4) | DECIMAL(9,4) NOT NULL | SDK Price Earnings Ratio |
| 26 | SDK_MKT_CAPITAL | Number(18,4) | DECIMAL(17,4) NOT NULL | SDK Market Capitalization |
| 27 | SDK_VOLATILITY | Number(10,4) | DECIMAL(9,4) NOT NULL | SDK Stock Volatility |
| 28 | SDK_YIELD | Number(10,4) | DECIMAL(9,4) NOT NULL | SDK Stock Yield |
| 29 | SDK_LASTUPDDTTM | DateTime(26) | TIMESTAMP |
SDK Last Update Date Time
Default Value: %datetime |
| 30 | SDK_STOCKCOMP_NAME | Character(38) | VARCHAR2(38) NOT NULL | SDK Stock Company Name |