STOCK_EXCH_LANG (SQL Table)	Index Back
Stock Exchange The Stock Exchange table contains details about an exchange a stock is traded on. This record stores the stock exchange contact information and stock ticker symbol for a stock on a given day. This record is a child record of the STOCK_TBL.

STOCK_EXCH_LANG

(SQL Table)

Stock Exchange

The Stock Exchange table contains details about an exchange a stock is traded on. This record stores the stock exchange contact information and stock ticker symbol for a stock on a given day. This record is a child record of the STOCK_TBL.

Related Language Record for STOCK_EXCHANGE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 STOCK_ID Character(10) VARCHAR2(10) NOT NULL Company's Stock Identification Symbol
Prompt Table: STOCK_TBL

2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

4 COMMENTS Long Character CLOB Comment

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	STOCK_ID	Character(10)	VARCHAR2(10) NOT NULL	Company's Stock Identification Symbol Prompt Table: STOCK_TBL
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	COMMENTS	Long Character	CLOB	Comment