STOCK_FISCAL_YR (SQL Table)	Index Back
Stock Fiscal Year table Contains the fiscal year, fiscal year from, and fiscal year to dates

STOCK_FISCAL_YR

(SQL Table)

Stock Fiscal Year table

Contains the fiscal year, fiscal year from, and fiscal year to dates

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 STOCK_ID Character(10) VARCHAR2(10) NOT NULL Stock ID
Prompt Table: STOCK_TBL

2 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year

3 FISCAL_BEGIN_DT Date(10) DATE NOT NULL Fiscal Begin Date

4 FISCAL_END_DT Date(10) DATE NOT NULL Fiscal End Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	STOCK_ID	Character(10)	VARCHAR2(10) NOT NULL	Stock ID Prompt Table: STOCK_TBL
2	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
3	FISCAL_BEGIN_DT	Date(10)	DATE NOT NULL	Fiscal Begin Date
4	FISCAL_END_DT	Date(10)	DATE NOT NULL	Fiscal End Date