FINANCIAL The table contains information about a company's quarterly financial reports. VGenLoader will load this table with financial information for each company for the Quarters starting 1 January 2000 and ending with the quarter that starts 1 October 2004. Prefix: FI_ Column Name Data Type Constraints Relations Description PK+ FI_CO_ID IDENT_T Not Null Company identifier. FK (CO_) FI_YEAR NUM(4) Not Null PK+ Year of the quarter end. Quarter number that the financial Not Null FI_QTR NUM(1) PK+ information is for: valid values 1, 2, 3, in 1,2,3,4 4. FI_QTR_START_DATE DATE Not Null date of quarter. FI_REVENUE FIN_AGG_T Not Null Reported revenue for the quarter. FI_NET_EARN FIN_AGG_T Not Null Net earnings reported for the quarter. Basic earnings per share reported for FI_BASIC_EPS VALUE_T Not Null the quarter. Diluted earnings per share reported FI_DILUT_EPS VALUE_T Not Null for the quarter. Profit divided by revenues for the FI_MARGIN VALUE_T Not Null quarter. Value of inventory on hand at the end FI_INVENTORY FIN_AGG_T Not Null of the quarter. Value of total assets at the end of the FI_ASSETS FIN_AGG_T Not Null quarter. Value of total liabilities at the end of FI_LIABILITY FIN_AGG_T Not Null the quarter. Average number of common shares FI_OUT_BASIC S_COUNT_T Not Null outstanding (basic). Average number of common shares FI_OUT_DILUT S_COUNT_T Not Null outstanding (diluted). INDUSTRY The table contains information about industries. Used to categorize which industries a company is in. Table Prefix: IN_ Column Name Data Type Constraints Relations Description IN_ID CHAR(2) Not Null PK Industry identifier. Industry name. Examples: "Air Travel", IN_NAME CHAR(50) Not Null "Air Cargo", "Software", "Consumer Banking", "Merchant Banking", etc. Sector identifier of the sector the IN_SC_ID CHAR(2) Not Null FK (SC_) industry is in.
FINANCIAL The table contains information about a company's quarterly financial reports. VGenLoader will load this table with financial information for each company for the Quarters starting 1 January 2000 and ending with the quarter that starts 1 October 2004. Prefix: FI_ Column Name Data Type Constraints Relations Description FI_CO_ID IDENT_T Not Null PK+ FK (CO_) Company identifier. FI_YEAR NUM(4) Not Null PK+ Year of the quarter end. FI_QTR NUM(1) Not Null in 1,2,3,4 PK+ Quarter number that the financial information is for: valid values 1, 2, 3, 4. FI_QTR_START_DATE DATE Not Null date of quarter. FI_REVENUE FIN_AGG_T Not Null Reported revenue for the quarter. FI_NET_EARN FIN_AGG_T Not Null Net earnings reported for the quarter. FI_BASIC_EPS VALUE_T Not Null Basic earnings per share reported for the quarter. FI_DILUT_EPS VALUE_T Not Null Diluted earnings per share reported for the quarter. FI_MARGIN VALUE_T Not Null Profit divided by revenues for the quarter. FI_INVENTORY FIN_AGG_T Not Null Value of inventory on hand at the end of the quarter. FI_ASSETS FIN_AGG_T Not Null Value of total assets at the end of the quarter. FI_LIABILITY FIN_AGG_T Not Null Value of total liabilities at the end of the quarter. FI_OUT_BASIC S_COUNT_T Not Null Average number of common shares outstanding (basic). FI_OUT_DILUT S_COUNT_T Not Null Average number of common shares outstanding (diluted). INDUSTRY The table contains information about industries. Used to categorize which industries a company is in. Table Prefix: IN_ Column Name Data Type Constraints Relations Description IN_ID CHAR(2) Not Null PK Industry identifier. IN_NAME CHAR(50) Not Null Industry name. Examples: "Air Travel", "Air Cargo", "Software", "Consumer Banking", "Merchant Banking", etc. IN_SC_ID CHAR(2) Not Null FK (SC_) Sector identifier of the sector the industry is in.
tpcx-v_v2.1.0.docx