SDK_STOCK_SR

index back

SDK Stock Quote Search

SDK 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 NameField TypeColumn TypeDescription
SDK_STOCK_TICKERCharacter(12)VARCHAR2(12) NOT NULLSDK Stock Ticker Symbol

Prompt Table: SDK_STOCK

SDK_STOCK_EXCHANGECharacter(38)VARCHAR2(38) NOT NULLSDK Stock Exchange Code

Prompt Table: SDK_STOCKXCHG

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_LASTUPDDTTMDateTime(26)TIMESTAMPSDK Last Update Date Time

Default: %datetime

index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19