STOCK_TBL (SQL Table)	Index Back
Stock Table The Stock Table is a static record that uniquely defines a stock using a stock id. The Stock Table is a parent table for a number of other stock tables, including STOCK_DTL, STOCK_PLAN_TBL, etc.

STOCK_TBL

(SQL Table)

Stock Table

The Stock Table is a static record that uniquely defines a stock using a stock id. The Stock Table is a parent table for a number of other stock tables, including STOCK_DTL, STOCK_PLAN_TBL, etc.

Related Language Record: STOCK_TBL_LANG

Parent Record Of STOCK_AGENT STOCK_BRANCH STOCK_DTL ST_DAILY_PRICES ST_ESTIMATE_TBL ST_VALUE_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 STOCK_ID Character(10) VARCHAR2(10) NOT NULL Stock ID

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description

3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
Default Value: STOCK_TBL.DESCR

4 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Prompt Table: COMPANY_TBL

5 ST_PAR_VALUE Number(16,6) DECIMAL(15,6) NOT NULL Par Value

6 CUSIP_NBR Character(9) VARCHAR2(9) NOT NULL CUSIP Number

7 GRANT_NBR_LAST Number(10,0) DECIMAL(10) NOT NULL Last Grant Number

8 EXERCISE_NBR_LAST Number(8,0) INTEGER NOT NULL Last Exercise Number

9 DISPOSN_NBR_LAST Number(8,0) INTEGER NOT NULL Last Option Disposition Number

10 ESPP_DISP_NBR_LAST Number(8,0) INTEGER NOT NULL Last Purchase Disposition Nbr

11 RELEASE_NBR_LAST Number(8,0) INTEGER NOT NULL Last Release Number

12 REPURCHASE_NBR_LST Number(8,0) INTEGER NOT NULL Last Repurchase Number

13 CHECK_NBR_LAST Number(15,0) DECIMAL(15) NOT NULL Last Check Number

14 DAILY_PRICES_DAYS Number(3,0) SMALLINT NOT NULL Capture the number of days as a default to view the Daily Prices Table.
Default Value: 31

15 ST_ACCOUNT_STD Character(1) VARCHAR2(1) NOT NULL Accounting Standard - used in Stock Administation to determine the accounting standard for a Stock ID.
A=APB 25
F=FAS 123
Default Value: F

16 ST_FAS_ADOPT_DT Date(10) DATE FAS 123 adoption date - date a Stock ID has adopted FAS 123 as it's accounting standard.

17 ST_FAS_DISCLOSE_DT Date(10) DATE NOT NULL FAS 123 disclosure date - date a Stock ID first recognized FAS 123 in it's financial disclose.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	STOCK_ID	Character(10)	VARCHAR2(10) NOT NULL	Stock ID
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description Default Value: STOCK_TBL.DESCR
4	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
5	ST_PAR_VALUE	Number(16,6)	DECIMAL(15,6) NOT NULL	Par Value
6	CUSIP_NBR	Character(9)	VARCHAR2(9) NOT NULL	CUSIP Number
7	GRANT_NBR_LAST	Number(10,0)	DECIMAL(10) NOT NULL	Last Grant Number
8	EXERCISE_NBR_LAST	Number(8,0)	INTEGER NOT NULL	Last Exercise Number
9	DISPOSN_NBR_LAST	Number(8,0)	INTEGER NOT NULL	Last Option Disposition Number
10	ESPP_DISP_NBR_LAST	Number(8,0)	INTEGER NOT NULL	Last Purchase Disposition Nbr
11	RELEASE_NBR_LAST	Number(8,0)	INTEGER NOT NULL	Last Release Number
12	REPURCHASE_NBR_LST	Number(8,0)	INTEGER NOT NULL	Last Repurchase Number
13	CHECK_NBR_LAST	Number(15,0)	DECIMAL(15) NOT NULL	Last Check Number
14	DAILY_PRICES_DAYS	Number(3,0)	SMALLINT NOT NULL	Capture the number of days as a default to view the Daily Prices Table. Default Value: 31
15	ST_ACCOUNT_STD	Character(1)	VARCHAR2(1) NOT NULL	Accounting Standard - used in Stock Administation to determine the accounting standard for a Stock ID. A=APB 25 F=FAS 123 Default Value: F
16	ST_FAS_ADOPT_DT	Date(10)	DATE	FAS 123 adoption date - date a Stock ID has adopted FAS 123 as it's accounting standard.
17	ST_FAS_DISCLOSE_DT	Date(10)	DATE NOT NULL	FAS 123 disclosure date - date a Stock ID first recognized FAS 123 in it's financial disclose.