SDK_STOCK

index back

SDK Company Stock Table

SDK Company Stock Table

PeopleSoft Field NameField TypeColumn TypeDescription
SDK_STOCK_TICKERCharacter(12)VARCHAR2(12) NOT NULLSDK Stock Ticker Symbol
SDK_STOCK_EXCHANGECharacter(38)VARCHAR2(38) NOT NULLSDK Stock Exchange Code
SDK_DESCRCharacter(30)VARCHAR2(30) NOT NULLSDK Description
SDK_LAST_TRADENumber(8,4)DECIMAL(7,4) NOT NULLSDK Last Trader Price
SDK_LAST_TRADE_SIZNumber(9,0)DECIMAL(9) NOT NULLSDK Last Trade Size
SDK_LAST_TRADE_DTDate(10)DATESDK Last Trade Date

Default: %date

SDK_LAST_TRADE_TMETime(15)TIMESTAMPSDK Last Trade Time
SDK_TOTAL_SHARESNumber(13,0)DECIMAL(13) NOT NULLSDK Total Shares Traded Today
SDK_STOCK_NET_CHGSigned Number(9,4)DECIMAL(7,4) NOT NULLSDK Net Change for Day
SDK_OPENING_TRADENumber(8,4)DECIMAL(7,4) NOT NULLSDK Opening Trade Today
SDK_CLOSING_TRADENumber(8,4)DECIMAL(7,4) NOT NULLSDK Closing Trade
SDK_BID_PRICENumber(8,4)DECIMAL(7,4) NOT NULLSDK Bid Price
SDK_ASK_PRICENumber(8,4)DECIMAL(7,4) NOT NULLSDK Ask Price
SDK_BID_X_ASK_SIZECharacter(9)VARCHAR2(9) NOT NULLSDK Bid Price
SDK_HIGH_TRADENumber(8,4)DECIMAL(7,4) NOT NULLSDK High Trade
SDK_LOW_TRADENumber(8,4)DECIMAL(7,4) NOT NULLSDK Daily Low Trade
SDK_YEAR_HIGHNumber(8,4)DECIMAL(7,4) NOT NULLSDK 52 Week High
SDK_YEAR_LOWNumber(8,4)DECIMAL(7,4) NOT NULLSDK 52 Week Low
SDK_STK_DIVID_FREQCharacter(28)VARCHAR2(28) NOT NULLSDK Dividend Frequency - Dividend Frequency for Stock Pagelet
SDK_DIVIDEND_AMTNumber(8,4)DECIMAL(7,4) NOT NULLSDK Dividend Amount
SDK_DIVIDEND_DTDate(10)DATESDK Dividend Date
SDK_EX_DIVIDEND_DTDate(10)DATESDK Exchange Dividend Date
SDK_EARNINGS_SHARENumber(18,4)DECIMAL(17,4) NOT NULLSDK Edit
SDK_SHARE_OUTSTANDNumber(13,0)DECIMAL(13) NOT NULLSDK Shares Outstanding
SDK_PE_RATIONumber(10,4)DECIMAL(9,4) NOT NULLSDK Price Earnings Ratio
SDK_MKT_CAPITALNumber(18,4)DECIMAL(17,4) NOT NULLSDK Market Capitalization
SDK_VOLATILITYNumber(10,4)DECIMAL(9,4) NOT NULLSDK Stock Volatility
SDK_YIELDNumber(10,4)DECIMAL(9,4) NOT NULLSDK Stock Yield
SDK_LASTUPDDTTMDateTime(26)TIMESTAMPSDK Last Update Date Time

Default: %datetime

SDK_STOCKCOMP_NAMECharacter(38)VARCHAR2(38) NOT NULLSDK Stock Company Name
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19