Field Name

Data Type

Description

Stock_Key

Integer

Primary Key

Split_Key

Integer

Foreign Key references Split_Dimension Table

Stock_Name

Varchar

Publicly Traded Stock Name

Stock_ Symbol

Varchar

Symbol of Traded security

Stock_Type

Varchar

Equity/Bond

Industry_Type

Varchar

Chemical/Computers/Steel

SP_Rating

varchar

S&P Rating, 'AAA',AA,A B+, B etc.

Company_Name

Varchar

Complete Name of Compnay

Registered_Address

Varchar

Complete Address where the company is registered

Registered_City

Varchar

City where company is registered

Registered_State

Varchar

State where Company is registered

Postal_Code

Varchar

Postal code

Registered_County

Varchar

Country where company is registered

FaceValue

Integer

Issue Price of Stock in Country where company is located e.g. $1, $5