CREATE TABLE calcrt_data2 ( PARSEKEY_UNIQUE varchar(20) binary not null, 144A_FLAG char(1) binary default NULL, ACCT_PAY_TO_TOT_LIAB_AND_EQY double default NULL, ACCT_RCV_DAYS double default NULL, ACCT_RCV_TO_TOT_ASSET double default NULL, ACCT_RCV_TURN double default NULL, ACCUM_DEPR_PLANT_TO_TOT_ASSET double default NULL, ACCUM_DEPR_TO_GROSS_FA double default NULL, ACCUM_DEPR_TO_TOT_ASSET double default NULL, ACT_LOAN_LOSS_TO_PROV_LOAN_LOSS double default NULL, ADR_ADR_PER_SH double default NULL, ADR_CUSTODIAN varchar(30) binary default NULL, ADR_SH_PER_ADR double default NULL, ADR_UNDL_CMPID varchar(128) binary default NULL, ADR_UNDL_CRNCY varchar(12) binary default NULL, ADR_UNDL_SECID varchar(128) binary default NULL, ADR_UNDL_TICKER varchar(22) binary default NULL, AFUDC_DEBT_GROWTH double default NULL, AFUDC_DEBT_TO_TOT_REV double default NULL, AFUDC_EQY_GROWTH double default NULL, AFUDC_EQY_TO_TOT_REV double default NULL, AFUDC_TO_NET_INC double default NULL, ALLOW_LOAN_LOSS_TO_TOT_ASSET double default NULL, ALT_NON_144A_CUSIP varchar(30) binary default NULL, AMORT_OF_GOODWILL double default NULL, AMT_ISSUED double default NULL, AMT_OUTSTANDING double default NULL, ANNOUNCEMENT_DT date default NULL, ANNOUNCE_DT date default NULL, APIC_PER_COM_TO_TOT_LIAB_EQY double default NULL, ASSETS_CUR_LIAB double default NULL, ASSET_GROWTH double default NULL, ASSET_PER_EMPL double default NULL, ASSET_TO_EQY double default NULL, ASSET_TURNOVER double default NULL, AVG_COM_EQY_TO_AVG_ASSET double default NULL, AVG_EARN_ASSET_TO_AVG_INT_LIAB double default NULL, AVG_REV_PER_KWH double default NULL, AVG_REV_PER_THERM double default NULL, BASIC_SPREAD double default NULL, BEARER char(1) binary default NULL, BEG_UNIT_VAL double default NULL, BESION_FONDS_DE_ROULEMENT double default NULL, BNCHMRK_TSY_ISSUE varchar(128) binary default NULL, BOOK_ENTRY char(1) binary default NULL, BOOK_VAL_PER_SH double default NULL, BRADY char(1) binary default NULL, BRADY_BUS_DAY_CONV varchar(128) binary default NULL, BRADY_PV_INT_GUARANTEE double default NULL, BRADY_PV_PRINC_GUARANTEE double default NULL, BS_ACCRUAL double default NULL, BS_ACCT_NOTE_RCV double default NULL, BS_ACCT_PAYABLE double default NULL, BS_ACCUM_DEF_INC_TAXES double default NULL, BS_ACCUM_DEF_ITC double default NULL, BS_ACCUM_DEPR double default NULL, BS_ACCUM_DEPR_FOR_OTHER_PRPTY double default NULL, BS_ACCUM_DEPR_FOR_PLANT_ASSET double default NULL, BS_ACCUM_INFLATION_ADJ double default NULL, BS_ADD_PAID_IN_CAP double default NULL, BS_AMT_OF_TSY_STOCK double default NULL, BS_APPROPRIATED_RETAINED_EARNING double default NULL, BS_ASSETS_UNDER_MGMT double default NULL, BS_BANK_ST_BORROW double default NULL, BS_BLDG_AND_IMPRV double default NULL, BS_CAPITAL_RESERVE double default NULL, BS_CAPITAL_STOCK double default NULL, BS_CASH_NEAR_CASH_ITEM double default NULL, BS_COMMON_STOCK double default NULL, BS_COMM_LOAN double default NULL, BS_COM_PLANT_IN_SERV double default NULL, BS_CONS_LOAN double default NULL, BS_CORE_CAP_RATIO double default NULL, BS_CORE_DPST double default NULL, BS_CUR_ASSET_REPORT double default NULL, BS_CUR_LIAB double default NULL, BS_CUST_ACCPT_LIAB_CUSTDY_SEC double default NULL, BS_DEBT_IN_FOREIGN_CURR double default NULL, BS_DECOMM_FUND double default NULL, BS_DEF_TAX_LIAB double default NULL, BS_DEMAND_DPST double default NULL, BS_DISAGIO double default NULL, BS_DISCLOSED_INTANGIBLES double default NULL, BS_DVD_RIGHT_PARITY double default NULL, BS_ELECT_PLANT_IN_SERV double default NULL, BS_EQUIP double default NULL, BS_EQY_SEC double default NULL, BS_FIX_INCOME_SEC double default NULL, BS_FIX_RT_DEBT double default NULL, BS_FOREIGN_LOAN double default NULL, BS_FOSSIL_FUEL double default NULL, BS_FUND_FOR_FUT_APPROP double default NULL, BS_GAS_PLANT_IN_SERV double default NULL, BS_GOODWILL_WRITE_OFF double default NULL, BS_GROSS_FIX_ASSET double default NULL, BS_GROSS_OTHER_PRPTY double default NULL, BS_GROSS_UTIL_PLANT_IN_SERV double default NULL, BS_INS_VAL_OF_DEPR_FIX_ASSET double default NULL, BS_INTERBANK_ASSET double default NULL, BS_INVENTORIES double default NULL, BS_INVEST_IN_ASSOC_CO double default NULL, BS_LAND_AND_IMPRV double default NULL, BS_LARGE_DPST double default NULL, BS_LEASE_FNC_LOAN double default NULL, BS_LESS_ALLOW double default NULL, BS_LEV_RATIO_TO_TANG_CAP double default NULL, BS_LIFE_PLCY_BNFT double default NULL, BS_LOAN_MTG double default NULL, BS_LT_BORROW double default NULL, BS_LT_INVEST double default NULL, BS_LT_INVEST_OTHER double default NULL, BS_MATL_SUPL_AND_GAS_IN_STORAGE double default NULL, BS_MINORITY_INT double default NULL, BS_MISC_PRPTY double default NULL, BS_MKT_SEC_OTHER_ST_INVEST double default NULL, BS_NET_FIX_ASSET double default NULL, BS_NET_NUCLR_FUEL double default NULL, BS_NET_OTHER_PRPTY double default NULL, BS_NET_PLANT_IN_SERV double default NULL, BS_NON_DEPR_DECOMM_FUND double default NULL, BS_NON_EQY_RSRV double default NULL, BS_NON_PERFORM_ASSET double default NULL, BS_NUM_OF_SHAREHOLDERS double default NULL, BS_NUM_OF_TSY_SH double default NULL, BS_OFF_BAL_COMMIT_AND_CONT double default NULL, BS_OTHER_ASSET_DEF_CHNG_OTHER double default NULL, BS_OTHER_CONST_IN_PROG double default NULL, BS_OTHER_CUR_ASSET double default NULL, BS_OTHER_CUR_ASSET_LESS_PREPAY double default NULL, BS_OTHER_CUR_LIAB double default NULL, BS_OTHER_DPST double default NULL, BS_OTHER_INV double default NULL, BS_OTHER_LIAB double default NULL, BS_OTHER_LOAN double default NULL, BS_OTHER_OPER_RSRV double default NULL, BS_OTHER_ST_LIAB double default NULL, BS_PAR_VAL double default NULL, BS_PENSION_RSRV double default NULL, BS_PERCENT_FLOATING_SHARES double default NULL, BS_PERCENT_OF_FOREIGN_OWNERSHIP double default NULL, BS_PFD_EQY double default NULL, BS_PLANT_CONST_IN_PROG double default NULL, BS_PLCY_HOLD_EQY double default NULL, BS_PREM_RSRV double default NULL, BS_PREPAY double default NULL, BS_PROJ_UNDER_DVLP_CONST double default NULL, BS_RESTRICT_BOND_PROCEED double default NULL, BS_RETAIN_EARN double default NULL, BS_RE_INVEST double default NULL, BS_RE_LOAN double default NULL, BS_RSRV_FOR_OUT_CLAIM_LOSS double default NULL, BS_RSRV_LOAN_LOSS double default NULL, BS_SEC_PURCH_RESELL_AGRMNT double default NULL, BS_SEC_SOLD_REPO_AGRMNT double default NULL, BS_SEGREGATED_FUND double default NULL, BS_SH_CAP_AND_APIC double default NULL, BS_SH_OUT double default NULL, BS_ST_BORROW double default NULL, BS_ST_DEBT double default NULL, BS_ST_PORTION_OF_LT_DEBT double default NULL, BS_SVNG_DPST double default NULL, BS_TECH_PROV_FOR_LINK_LIAB double default NULL, BS_TIME_DPST double default NULL, BS_TOT_ASSET double default NULL, BS_TOT_CAP double default NULL, BS_TOT_CAPITALIZATION double default NULL, BS_TOT_CAP_AND_LIAB double default NULL, BS_TOT_CAP_FUND double default NULL, BS_TOT_CAP_TO_RISK_BASE_CAP double default NULL, BS_TOT_DPST_SEC_DPST double default NULL, BS_TOT_EQY double default NULL, BS_TOT_INSUR_RSRV double default NULL, BS_TOT_INVEST_ASSET double default NULL, BS_TOT_LIAB2 double default NULL, BS_TOT_LIAB_EQY double default NULL, BS_TOT_LIAB_REITS double default NULL, BS_TOT_LOAN double default NULL, BS_TOT_MTG_BACK_INVEST_CMO double default NULL, BS_TOT_NON_CUR_ASSET double default NULL, BS_TOT_OTHER_PRPTY_AND_EQUIP double default NULL, BS_TOT_UTIL_PLANT double default NULL, BS_TRANS_ASSET double default NULL, BS_VAR_RT_DEBT double default NULL, BS_VOTE_RIGHT_PARITY double default NULL, BS_WATER_PLANT_IN_SERV double default NULL, BULLET char(1) binary default NULL, BVPS_GROWTH double default NULL, CALC_TYP int(11) default NULL, CALC_TYP_DES varchar(128) binary default NULL, CALLABLE char(1) binary default NULL, CALLED char(1) binary default NULL, CALLED_DT date default NULL, CALLED_PX double default NULL, CALL_DAYS_NOTICE int(11) default NULL, CALL_DISCRETE char(1) binary default NULL, CALL_FEATURE varchar(128) binary default NULL, CALL_IN_LOTS int(11) default NULL, CALL_NOTIFICATION_MAX_DAYS int(11) default NULL, CALL_NOTIFICATION_MIN_DAYS int(11) default NULL, CALL_PARTIAL varchar(128) binary default NULL, CAP_EXPEND_PER_RE double default NULL, CAP_EXPEND_TO_FFO double default NULL, CAP_EXPEND_TO_GROSS_FA double default NULL, CAP_EXPEND_TO_SALES double default NULL, CAP_EXPEND_TO_TOT_ASSET double default NULL, CAP_LOAN_LOSS_TO_NON_PERF_ASSET double default NULL, CASH_AND_EQUIV double default NULL, CASH_AND_EQUIV_PER_TOT_LIAB double default NULL, CASH_AND_EQUIV_TO_CUR_ASSET double default NULL, CASH_CONST_INTERNAL_FNC double default NULL, CASH_DVD_COVERAGE double default NULL, CASH_EARN_PER_SHARE double default NULL, CASH_EPS double default NULL, CASH_FLOW_PER_SH double default NULL, CASH_FLOW_TO_NET_INC double default NULL, CASH_FLOW_TO_TOT_LIAB double default NULL, CASH_GEN_TO_CASH_REQ double default NULL, CASH_RATIO double default NULL, CASH_TO_TOT_ASSET double default NULL, CDR_COUNTRY_CODE varchar(4) binary default NULL, CDR_EXCH_CODE varchar(4) binary default NULL, CDR_SETTLE_CODE varchar(128) binary default NULL, CFO_BEF_NON_CASH_WC double default NULL, CFO_TO_FIX_CHRG double default NULL, CFO_TO_SALES double default NULL, CFO_TO_TOT_DEBT double default NULL, CF_ACCT_PAY_ACCRUAL double default NULL, CF_ACCT_RCV_UNBILLED_REV double default NULL, CF_ACC_TAX double default NULL, CF_ACT_CASH_PAID_FOR_INT_DEBT double default NULL, CF_ADD_TO_UTIL_PLANT_EXCEPT_AFC double default NULL, CF_AFC_DEBT_AND_EQY double default NULL, CF_AMORT_NUCLR_FUEL double default NULL, CF_CAP_EXPEND_INC_FIX_ASSET double default NULL, CF_CAP_EXPEND_PRPTY_ADD double default NULL, CF_CASH_FROM_FNC_ACT double default NULL, CF_CASH_FROM_INV_ACT double default NULL, CF_CASH_FROM_OPER double default NULL, CF_CASH_FROM_SALES_SERV double default NULL, CF_CASH_PAID_FOR_TAX double default NULL, CF_CASH_PAY_FOR_OPER_EXP double default NULL, CF_CASH_PURCH double default NULL, CF_CHNG_FOSSIL_FUEL double default NULL, CF_CHNG_IN_DECOMM_FUND double default NULL, CF_CHNG_NON_CASH_WORK_CAP double default NULL, CF_CHNG_RESTRICT_BOND_PROCEED double default NULL, CF_DECR_CAP_STOCK double default NULL, CF_DECR_CAP_STOCK_SU double default NULL, CF_DECR_DPST double default NULL, CF_DECR_FIX_ASSET double default NULL, CF_DECR_INCR_LOAN double default NULL, CF_DECR_INS_RSRV double default NULL, CF_DECR_INVEST double default NULL, CF_DECR_INVEST_SU double default NULL, CF_DECR_LOAN2 double default NULL, CF_DECR_LT_BORROW double default NULL, CF_DEF_INC_TAX double default NULL, CF_DEF_OF_FUND double default NULL, CF_DEPR_AMORT double default NULL, CF_DEPR_EXP double default NULL, CF_DISP_FIX_ASSET double default NULL, CF_DVD_PAID double default NULL, CF_DVD_PAID_SU double default NULL, CF_FFO double default NULL, CF_FFO_PER_SH double default NULL, CF_FFO_PER_SH_FULLY_DILUTED double default NULL, CF_FORM_OF_STATEMENT double default NULL, CF_FREE_CASH_FLOW double default NULL, CF_INCR_CAP_STOCK double default NULL, CF_INCR_CAP_STOCK_SU double default NULL, CF_INCR_DECR_DPST double default NULL, CF_INCR_DECR_INSUR_RSRV double default NULL, CF_INCR_DPST2 double default NULL, CF_INCR_FUND double default NULL, CF_INCR_INSUR_RSRV double default NULL, CF_INCR_INVEST double default NULL, CF_INCR_LOAN double default NULL, CF_INCR_LT_BORROW double default NULL, CF_INCR_LT_BORROW_SU double default NULL, CF_INCR_LT_INVEST double default NULL, CF_INCR_ST_BORROW double default NULL, CF_ISSUE_COM_STOCK double default NULL, CF_ISSUE_PFD_STOCK double default NULL, CF_ITC double default NULL, CF_MATL_SUPL_GAS_STORAGE double default NULL, CF_NET_BANK_INC double default NULL, CF_NET_CHNG_CASH double default NULL, CF_NET_INC double default NULL, CF_NET_INT_INC double default NULL, CF_OTHERS_NET double default NULL, CF_OTHER_FNC_ACT double default NULL, CF_OTHER_INV_ACT double default NULL, CF_OTHER_NON_CASH_ADJUST double default NULL, CF_OTHER_NON_CASH_ADJ_LESS double default NULL, CF_OTHER_SRC double default NULL, CF_OTHER_USES double default NULL, CF_PREPAY_OTHER double default NULL, CF_PROV_DOUBT_ACCT double default NULL, CF_PRPTY_IMPRV double default NULL, CF_REIMB_LT_BORROW double default NULL, CF_TOT_SRC double default NULL, CF_TOT_USES double default NULL, CHNG_WORK_CAP double default NULL, CLAIM_LOSS_RES_TO_SHRHLDR_EQY double default NULL, CMPD_FREQ_CNV_YLD double default NULL, CNTRY_ISSUE_ISO varchar(4) binary default NULL, CNTRY_OF_DOMICILE varchar(4) binary default NULL, CNTRY_OF_INCORPORATION varchar(4) binary default NULL, COGS_TO_NET_SALES double default NULL, COGS_YR_CHNG double default NULL, COLLAT_TYP varchar(128) binary default NULL, COMB_RATIO_NL double default NULL, COMM_AND_FEE_TO_TOT_REV double default NULL, COMM_FEES_EARN_YR_CHNG double default NULL, COMM_FEE_EARN_TO_TOT_REV double default NULL, COMM_LOAN_TO_TOT_ASSET double default NULL, COMPANY_AUDITOR varchar(128) binary default NULL, COMPANY_FAX_NUMBER varchar(128) binary default NULL, COMPANY_TEL_NUMBER varchar(128) binary default NULL, COMPANY_WEB_ADDRESS text, COMPOSITE_EFF_DT date default NULL, COM_EQY_TO_TOT_ASSET double default NULL, COM_EQY_TO_TOT_CAP double default NULL, COM_PLANT_IN_SERV_TO_TOT_ASSET double default NULL, COM_STOCK_TO_TOT_LIAB_AND_EQY double default NULL, CONST_SPEND_GROWTH_RT double default NULL, CONS_LOAN_TO_TOT_ASSET double default NULL, CONT_INC double default NULL, CONT_INC_GROWTH double default NULL, CONT_INC_PER_SH double default NULL, CONVERTIBLE char(1) binary default NULL, CORE_DPST_GROWTH double default NULL, COUNTRY varchar(8) binary default NULL, COUNTRY_FULL_NAME varchar(32) binary default NULL, COUNTRY_GUARANTOR varchar(16) binary default NULL, COUNTRY_ISO varchar(4) binary default NULL, CO_MGR varchar(128) binary default NULL, CPN double default NULL, CPN_ASOF_DT date default NULL, CPN_CAP double default NULL, CPN_CRNCY varchar(12) binary default NULL, CPN_FLOOR double default NULL, CPN_FREQ int(11) default NULL, CPN_FREQ_YLD_CNV double default NULL, CPN_TYP varchar(128) binary default NULL, CPN_TYP_SPECIFIC varchar(128) binary default NULL, CRNCY varchar(12) binary default NULL, CURR_ENTP_VAL double default NULL, CURR_INT_INDICATOR char(1) binary default NULL, CUR_ASSET_TO_TOT_ASSET double default NULL, CUR_CPN double default NULL, CUR_EMPLOYEES int(11) default NULL, CUR_LIAB_TO_TOT_LIAB_AND_EQY double default NULL, CUR_MKT_CAP varchar(128) binary default NULL, CUR_NUM_EMPLOYEES_AS_PER_DT date default NULL, CUR_RATIO double default NULL, CUST_ACCPT_LIAB_TO_TOT_ASSET double default NULL, CUST_ASSTS double default NULL, CV_CASH_REQUIRED int(11) default NULL, CV_CNVS_FEXCH_RT double default NULL, CV_CNVS_PX double default NULL, CV_CNVS_RATIO double default NULL, CV_COMMON_EXCH varchar(128) binary default NULL, CV_COMMON_ISIN varchar(128) binary default NULL, CV_COMMON_TICKER varchar(22) binary default NULL, CV_COMMON_TICKER_EXCH varchar(22) binary default NULL, CV_CONV_BY_ISSUER_OR_HOLDER varchar(128) binary default NULL, CV_MANDATORY_CNVS varchar(128) binary default NULL, CV_PROV_PX double default NULL, CV_SH_PAR double default NULL, CV_START_DT date default NULL, CV_STOCK_DVD double default NULL, CV_UNTIL date default NULL, CWIP_PCT_OF_TOT_PLANT double default NULL, DAY_CNT int(11) default NULL, DAY_CNT_DES varchar(128) binary default NULL, DEBT_TO_MKT_CAP double default NULL, DEBT_TO_RE_ASSET double default NULL, DECOMM_TO_TOT_ASSET double default NULL, DEC_INC_RE_INT double default NULL, DEC_INC_RE_INT_OTHER double default NULL, DEFAULTED char(1) binary default NULL, DELIVERY_TYP varchar(128) binary default NULL, DEMAND_DPST_TO_TOT_DPST double default NULL, DEMAND_DPST_TO_TOT_LIAB_AND_EQY double default NULL, DEPR_AND_AMORT_TO_FFO double default NULL, DEPR_EXP_TO_NET_FIX_ASSET double default NULL, DEPR_EXP_TO_NET_SALES double default NULL, DEPR_EXP_YR_CHNG double default NULL, DEPR_FIXED_ASSETS double default NULL, DES_NOTES text, DEVELOPMENT_PROP double default NULL, DIVIDEND_RIGHTS varchar(128) binary default NULL, DTC_ELIGIBLE char(1) binary default NULL, DTC_REGISTERED char(1) binary default NULL, DUAL_CRNCY char(1) binary default NULL, DUAL_CRNCY_CNVS_FACTOR double default NULL, DVD_CRNCY varchar(12) binary default NULL, DVD_DECLARED_DT date default NULL, DVD_EX_DT date default NULL, DVD_PAYOUT_EX_AFUDC double default NULL, DVD_PAYOUT_RATIO double default NULL, DVD_PAY_DT date default NULL, DVD_RECORD_DT date default NULL, EARN_ASSET double default NULL, EARN_ASSET_GROWTH double default NULL, EARN_ASSET_TO_INT_BEAR_LIAB double default NULL, EARN_FOR_COMMON double default NULL, EARN_FOR_COM_GROWTH double default NULL, EARN_FOR_COM_TO_TOT_REV double default NULL, EARN_YLD double default NULL, EBIT double default NULL, EBITDA double default NULL, EBITDA_GROWTH double default NULL, EBITDA_LES_CAP_EXPEND_TO_INT_EXP double default NULL, EBITDA_PER_SH double default NULL, EBITDA_RETURN double default NULL, EBITDA_RE_ASSET double default NULL, EBITDA_TO_AVG_RE_ASSET double default NULL, EBITDA_TO_TOT_INT_EXP double default NULL, EBIT_MARGIN double default NULL, EBIT_TO_INT_EXP double default NULL, EBIT_TO_NET_SALES double default NULL, EBIT_TO_TOT_INT_EXP double default NULL, EBIT_YR_CHNG double default NULL, EFF_INT_RATE double default NULL, EFF_OF_EARN_ASSET double default NULL, EFF_RATIO double default NULL, EFF_TAX_RATE double default NULL, ELECT_PLANT_IN_SERV_TO_TOT_ASSET double default NULL, EMPL_GROWTH double default NULL, ENTERPRISE_VALUE double default NULL, EPS_ANNUALIZED double default NULL, EPS_GROWTH double default NULL, EQUALIZATION_PROVISION double default NULL, EQY_AND_RE_INVEST_TO_TOT_INVEST double default NULL, EQY_DPS double default NULL, EQY_DPS_GROSS_1YR_GROWTH double default NULL, EQY_DPS_GROSS_3YR_GROWTH double default NULL, EQY_DPS_GROSS_FISCAL_YR double default NULL, EQY_DPS_NET_1YR_GROWTH double default NULL, EQY_DPS_NET_3YR_GROWTH double default NULL, EQY_DPS_NET_5YR_GROWTH double default NULL, EQY_DPS_NET_FISCAL_YR double default NULL, EQY_DVD_CASH_ANN_DT_NEXT date default NULL, EQY_DVD_CASH_CRNCY_NEXT varchar(12) binary default NULL, EQY_DVD_CASH_EX_DT_NEXT date default NULL, EQY_DVD_CASH_GROSS_NEXT double default NULL, EQY_DVD_CASH_NET_NEXT double default NULL, EQY_DVD_CASH_PAY_DT_NEXT date default NULL, EQY_DVD_CASH_RECORD_DT_NEXT date default NULL, EQY_DVD_CASH_TYP_NEXT varchar(128) binary default NULL, EQY_DVD_EX_FLAG char(1) binary default NULL, EQY_DVD_FREQ varchar(128) binary default NULL, EQY_DVD_PCT_FRANKED double default NULL, EQY_DVD_RIGHT_ADJ_FCT_CURR varchar(128) binary default NULL, EQY_DVD_RIGHT_ADJ_FCT_NEXT varchar(128) binary default NULL, EQY_DVD_RIGHT_ANN_DT_CURR date default NULL, EQY_DVD_RIGHT_ANN_DT_NEXT date default NULL, EQY_DVD_RIGHT_EX_DT_CURR date default NULL, EQY_DVD_RIGHT_EX_DT_NEXT date default NULL, EQY_DVD_RIGHT_EX_FLAG char(1) binary default NULL, EQY_DVD_RIGHT_PAY_DT_CURR date default NULL, EQY_DVD_RIGHT_PAY_DT_NEXT date default NULL, EQY_DVD_RIGHT_RECORD_DT_CURR date default NULL, EQY_DVD_RIGHT_RECORD_DT_NEXT date default NULL, EQY_DVD_RIGHT_SPLIT_RATIO_CURR varchar(128) binary default NULL, EQY_DVD_RIGHT_SPLIT_RATIO_NEXT varchar(128) binary default NULL, EQY_DVD_RIGHT_SUB_PRICE_CURR double default NULL, EQY_DVD_RIGHT_SUB_PRICE_NEXT double default NULL, EQY_DVD_RIGHT_TYP_CURR varchar(128) binary default NULL, EQY_DVD_RIGHT_TYP_NEXT varchar(128) binary default NULL, EQY_DVD_SH_12M double default NULL, EQY_DVD_SH_12M_NET double default NULL, EQY_DVD_SH_IND_GROSS double default NULL, EQY_DVD_SH_IND_NET double default NULL, EQY_DVD_SH_LAST double default NULL, EQY_DVD_SPL_ADJ_FCT_CURR varchar(128) binary default NULL, EQY_DVD_SPL_ADJ_FCT_NEXT varchar(128) binary default NULL, EQY_DVD_SPL_ANN_DT_CURR date default NULL, EQY_DVD_SPL_ANN_DT_NEXT date default NULL, EQY_DVD_SPL_EX_DT_NEXT date default NULL, EQY_DVD_SPL_EX_FLAG char(1) binary default NULL, EQY_DVD_SPL_PAY_DT_CURR date default NULL, EQY_DVD_SPL_PAY_DT_NEXT date default NULL, EQY_DVD_SPL_RECORD_DT_CURR date default NULL, EQY_DVD_SPL_RECORD_DT_NEXT date default NULL, EQY_DVD_SPL_SPLIT_RATIO_NEXT varchar(128) binary default NULL, EQY_DVD_SPL_TYP_CURR varchar(128) binary default NULL, EQY_DVD_SPL_TYP_NEXT varchar(128) binary default NULL, EQY_DVD_STK_ADJ_FCT_CURR varchar(128) binary default NULL, EQY_DVD_STK_ADJ_FCT_NEXT varchar(128) binary default NULL, EQY_DVD_STK_ANN_DT_CURR date default NULL, EQY_DVD_STK_ANN_DT_NEXT date default NULL, EQY_DVD_STK_EX_DT_CURR date default NULL, EQY_DVD_STK_EX_DT_NEXT date default NULL, EQY_DVD_STK_EX_FLAG char(1) binary default NULL, EQY_DVD_STK_PAY_DT_CURR date default NULL, EQY_DVD_STK_PAY_DT_NEXT date default NULL, EQY_DVD_STK_PCT_CURR varchar(128) binary default NULL, EQY_DVD_STK_PCT_NXT varchar(128) binary default NULL, EQY_DVD_STK_RECORD_DT_CURR date default NULL, EQY_DVD_STK_RECORD_DT_NEXT date default NULL, EQY_DVD_STK_TYP_CURR varchar(128) binary default NULL, EQY_DVD_STK_TYP_NEXT varchar(128) binary default NULL, EQY_DVD_TYP_LAST varchar(128) binary default NULL, EQY_FISCAL_YR_END varchar(128) binary default NULL, EQY_FOR_SH_OUT int(11) default NULL, EQY_FREE_FLOAT_PCT double default NULL, EQY_FUND_CRNCY varchar(12) binary default NULL, EQY_FUND_IND varchar(128) binary default NULL, EQY_IND_DPS_ANNUAL_GROSS double default NULL, EQY_IND_DPS_ANNUAL_NET double default NULL, EQY_INIT_PO_DT date default NULL, EQY_INIT_PO_LEAD_MGR varchar(128) binary default NULL, EQY_INIT_PO_SH_OFFER double default NULL, EQY_INIT_PO_SH_PX double default NULL, EQY_INIT_PO_TYP varchar(128) binary default NULL, EQY_INT_GROWTH double default NULL, EQY_INT_TO_TOT_REV double default NULL, EQY_IPO_LOCKUP_DT date default NULL, EQY_LAST_DPS_GROSS varchar(128) binary default NULL, EQY_LAST_PO_LOCKUP_DT date default NULL, EQY_NMS double default NULL, EQY_OPT_AVAIL char(1) binary default NULL, EQY_PO_DT date default NULL, EQY_PO_LEAD_MGR varchar(128) binary default NULL, EQY_PO_SH_OFFER double default NULL, EQY_PO_SH_PX double default NULL, EQY_PO_TYP varchar(128) binary default NULL, EQY_PRIM_EXCH varchar(128) binary default NULL, EQY_PRIM_EXCH_SHRT varchar(128) binary default NULL, EQY_PRIM_SECURITY_COMP_EXCH varchar(128) binary default NULL, EQY_PRIM_SECURITY_PRIM_EXCH varchar(128) binary default NULL, EQY_PRIM_SECURITY_TICKER varchar(22) binary default NULL, EQY_RECENT_QT_END_DT varchar(128) binary default NULL, EQY_RECENT_QT_END_QT varchar(128) binary default NULL, EQY_RECENT_SEMI_END varchar(128) binary default NULL, EQY_SEC_TO_TOT_ASSET double default NULL, EQY_SEC_TO_TOT_INVEST double default NULL, EQY_SH_OUT double default NULL, EQY_SH_OUT_DT date default NULL, EQY_SH_OUT_REAL double default NULL, EQY_SIC_CODE varchar(128) binary default NULL, EQY_SIC_NAME varchar(128) binary default NULL, EQY_SPLIT_ADJUSTMENT_FACTOR double default NULL, EQY_SPLIT_ADJ_INIT_PO_PX double default NULL, EQY_SPLIT_ADJ_LAST_OFFER_PX double default NULL, EQY_SPLIT_DT date default NULL, EQY_SPLIT_RATIO varchar(128) binary default NULL, EQY_WRT_AVAIL char(1) binary default NULL, EST_CPN_FLAG char(1) binary default NULL, EV_TO_BOOK_VALUE double default NULL, EV_TO_MKT_CAP double default NULL, EV_TO_T12M_CASH_FLOW double default NULL, EV_TO_T12M_EBIT double default NULL, EV_TO_T12M_EBITDA double default NULL, EV_TO_T12M_FREE_CASH_FLOW double default NULL, EV_TO_T12M_NET_INCOME double default NULL, EV_TO_T12M_SALES double default NULL, EXCESS_CASH_FLOW double default NULL, EXCHANGEABLE char(1) binary default NULL, EXCH_CODE varchar(18) binary default NULL, EXPECTED_REPORT_DT date default NULL, EXPECTED_REPORT_TIME varchar(128) binary default NULL, EXPECTED_REPORT_TYP varchar(128) binary default NULL, EXP_RATIO_NL double default NULL, EXTENDIBLE char(1) binary default NULL, EXTERN_EQY_FNC double default NULL, EX_DIV_CALENDAR varchar(128) binary default NULL, EX_DIV_DAYS int(11) default NULL, FCF_PER_DIL_SHR double default NULL, FEE_MGR double default NULL, FEE_REALLOWANCE double default NULL, FEE_SELLING_CONCESSN double default NULL, FEE_TOTAL_GROSS double default NULL, FEE_UNDERWRITER double default NULL, FFIEC_TEST varchar(128) binary default NULL, FFO_GROWTH_RT double default NULL, FFO_PAYOUT_RATIO double default NULL, FFO_PER_SH_GROWTH double default NULL, FFO_PER_TOT_DEBT double default NULL, FFO_PER_TOT_LIAB double default NULL, FFO_RETURN double default NULL, FFO_RE_ASSET double default NULL, FFO_TO_INT_EXP double default NULL, FFO_TO_NET_INC double default NULL, FFO_TO_TOT_REV double default NULL, FINAL_MATURITY date default NULL, FINANCIAL_ADVISOR varchar(128) binary default NULL, FINANCIAL_ADVISOR_CITY varchar(128) binary default NULL, FINANCIAL_ADVISOR_STATE varchar(128) binary default NULL, FIRST_CPN_DT date default NULL, FIRST_SETTLE_DT date default NULL, FITCH_EFF_DT date default NULL, FIXED char(1) binary default NULL, FIX_INC_SEC_TO_TOT_ASSET double default NULL, FIX_INC_SEC_TO_TOT_INVEST double default NULL, FLOATER char(1) binary default NULL, FLT_CPN_CONVENTION varchar(128) binary default NULL, FLT_IDX_FACTOR double default NULL, FLT_MAX_CPN double default NULL, FLT_MAX_RT_CHG double default NULL, FLT_MIN_CPN double default NULL, FLT_SPREAD double default NULL, FNCL_LVRG double default NULL, FONDS_DE_ROULEMENT double default NULL, FOREIGN_DEBT_TO_TOT_DEBT double default NULL, FOREIGN_DPST_TO_TOT_DPST double default NULL, FOREIGN_LOAN_TO_TOT_LOAN double default NULL, FOTRA char(1) binary default NULL, FREE_CASH_FLOW_PER_SH double default NULL, FREE_CASH_FLOW_PER_SH_GROWTH double default NULL, FRENCH_FLT_CRYST_RT double default NULL, FUEL_PER_KWH double default NULL, FULL_FUND_AVAIL char(1) binary default NULL, FUND_12B_FEE double default NULL, FUND_ASSET_CLASS_FOCUS varchar(128) binary default NULL, FUND_DEFERRED_LOAD double default NULL, FUND_DOMICILE_TYP varchar(128) binary default NULL, FUND_EXPENSE_RATIO double default NULL, FUND_FRONT_END_LOAD double default NULL, FUND_GEO_FOCUS varchar(128) binary default NULL, FUND_INCEPT_DT date default NULL, FUND_INCOME_RATIO double default NULL, FUND_INVEST_ADVISOR varchar(128) binary default NULL, FUND_IRA_INVEST double default NULL, FUND_MATURITY_BAND_FOCUS varchar(128) binary default NULL, FUND_MGMT_STYLE varchar(128) binary default NULL, FUND_MGR varchar(128) binary default NULL, FUND_MGR_FEE double default NULL, FUND_MGR_START_DT varchar(128) binary default NULL, FUND_MIN_INVEST double default NULL, FUND_MKT_CAP_FOCUS varchar(128) binary default NULL, FUND_OBJECTIVE_LONG varchar(128) binary default NULL, FUND_PHONE varchar(128) binary default NULL, FUND_RTG_CLASS_FOCUS varchar(128) binary default NULL, FUND_SECTOR_FOCUS varchar(128) binary default NULL, FUND_TOTAL_ASSETS varchar(128) binary default NULL, FUND_TOTAL_ASSETS_CRNCY varchar(12) binary default NULL, FUND_TOTAL_ASSETS_DT date default NULL, FUND_TURNOVER double default NULL, FUND_TYP varchar(128) binary default NULL, GAS_PLANT_IN_SERV_TO_TOT_ASSET double default NULL, GA_EXP_TO_FFO double default NULL, GA_EXP_TO_NET_OPER_EXP double default NULL, GEO_GROW_AVG_EARN_TO_AVG_LIAB double default NULL, GEO_GROW_BOOK_VAL double default NULL, GEO_GROW_CASH_FLOW_PER_SH double default NULL, GEO_GROW_CASH_FNC_ACT double default NULL, GEO_GROW_CASH_OPER_ACT double default NULL, GEO_GROW_COGS_TO_NET_SALES double default NULL, GEO_GROW_COMB_RATIO double default NULL, GEO_GROW_COM_EQY_TO_ASSET double default NULL, GEO_GROW_COM_EQY_TO_ASSET_INS double default NULL, GEO_GROW_CORE_CAP_RATIO double default NULL, GEO_GROW_CUR_ASSET double default NULL, GEO_GROW_CUR_RATIO double default NULL, GEO_GROW_DEBT_TO_COM_EQY double default NULL, GEO_GROW_DVD_PER_SH double default NULL, GEO_GROW_EARN_ASSET double default NULL, GEO_GROW_EBITDA_CAP_EXP_TO_INT double default NULL, GEO_GROW_EBITDA_TO_INT_EXP double default NULL, GEO_GROW_EBIT_TO_TOT_INT_EXP double default NULL, GEO_GROW_EFF_RATIO double default NULL, GEO_GROW_EPS_AFTER_XO_ITEM double default NULL, GEO_GROW_EPS_BEF_XO_ITEM double default NULL, GEO_GROW_EXP_RATIO double default NULL, GEO_GROW_EXTERN_EQY_FNC double default NULL, GEO_GROW_FNCL_LVRG double default NULL, GEO_GROW_FREE_CASH_FLOW double default NULL, GEO_GROW_GROSS_FA_TO_TOT_ASSET double default NULL, GEO_GROW_GROSS_MARGIN double default NULL, GEO_GROW_INC_BEF_XO_ITEM double default NULL, GEO_GROW_INS_RES_GROWTH double default NULL, GEO_GROW_INS_RES_TO_TOT_CAP double default NULL, GEO_GROW_INT_INV_TO_INV_ASSET double default NULL, GEO_GROW_INV_TURN double default NULL, GEO_GROW_LOAN_LOSS_RES_LOAN double default NULL, GEO_GROW_LOAN_LOSS_RES_TO_NPA double default NULL, GEO_GROW_LOSS_RATIO double default NULL, GEO_GROW_LT_DEBT_TO_COM_EQY double default NULL, GEO_GROW_NET_INC double default NULL, GEO_GROW_NET_INT_INC double default NULL, GEO_GROW_NET_INT_MARGIN double default NULL, GEO_GROW_NET_PREM_EARN_TO_EQY double default NULL, GEO_GROW_NET_PREM_GROWTH double default NULL, GEO_GROW_NET_REV_MARGIN double default NULL, GEO_GROW_NET_SALES double default NULL, GEO_GROW_NP_ASSET_TO_TOT_ASSET double default NULL, GEO_GROW_OPER_INC double default NULL, GEO_GROW_OPER_INC_TO_NET_EARN double default NULL, GEO_GROW_OPER_INC_TO_TOT_CAP double default NULL, GEO_GROW_OPER_MRGN double default NULL, GEO_GROW_PRETAX_INC double default NULL, GEO_GROW_PRETAX_MARGIN double default NULL, GEO_GROW_PROF_MARGIN double default NULL, GEO_GROW_ROA double default NULL, GEO_GROW_ROC double default NULL, GEO_GROW_ROE double default NULL, GEO_GROW_SALES_PER_SH double default NULL, GEO_GROW_TOT_ASSET double default NULL, GEO_GROW_TOT_CAP_RATIO double default NULL, GEO_GROW_TOT_COM_EQY double default NULL, GEO_GROW_TOT_DEBT_TO_EBITDA double default NULL, GEO_GROW_TOT_DEBT_TO_TOT_CAP double default NULL, GEO_GROW_TOT_DPST double default NULL, GEO_GROW_TOT_LIAB double default NULL, GEO_GROW_TOT_LOAN double default NULL, GEO_GROW_TOT_MKT_VAL double default NULL, GEO_GROW_TOT_MKT_VAL_EBITDA double default NULL, GEO_GROW_TOT_SHRHLDR_EQY double default NULL, GIC_CITY varchar(128) binary default NULL, GIC_STATE varchar(128) binary default NULL, GILTS_EX_DVD_DT date default NULL, GL_ON_INFL_ADJ_TO_NET_INC double default NULL, GL_ON_SALE_OF_RE_ASSET_GROWTH double default NULL, GL_ON_SALE_OF_RE_ASSET_TO_REV double default NULL, GROSS_FIX_ASSET_TO_TOT_ASSET double default NULL, GROSS_FIX_ASSET_TURN double default NULL, GROSS_MARGIN double default NULL, GROSS_UTIL_PLANT_TO_TOT_ASSET double default NULL, GROWTH_IN_CAP double default NULL, GROWTH_IN_TOT_DPST double default NULL, GROWTH_IN_TOT_LOAN double default NULL, GUARANTEED_INVEST_CONTRACT varchar(128) binary default NULL, GUARANTOR varchar(128) binary default NULL, GUARANTY_AGREEMENT varchar(128) binary default NULL, GUARANTY_AGREEMENT_CITY varchar(128) binary default NULL, GUARANTY_AGREEMENT_STATE varchar(128) binary default NULL, HAS_CONVERTIBLES char(1) binary default NULL, IDX_RATIO double default NULL, ID_APIR varchar(128) binary default NULL, ID_AUSTRIAN varchar(128) binary default NULL, ID_BB varchar(128) binary default NULL, ID_BB_8_CHR varchar(128) binary default NULL, ID_BB_COMPANY int(11) default NULL, ID_BB_PARENT_CO int(11) default NULL, ID_BB_PRIM_SECURITY_FLAG char(1) binary default NULL, ID_BB_SECURITY int(11) default NULL, ID_BB_UNIQUE varchar(128) binary default NULL, ID_BELGIAN_LOAN varchar(128) binary default NULL, ID_BELGIUM varchar(128) binary default NULL, ID_CATS varchar(128) binary default NULL, ID_CEDEL varchar(128) binary default NULL, ID_COMMON varchar(128) binary default NULL, ID_CUSIP varchar(30) binary default NULL, ID_CUSIP_8_CHR varchar(8) binary default NULL, ID_CUSIP_REAL varchar(18) binary default NULL, ID_CZECH varchar(128) binary default NULL, ID_DANISH varchar(128) binary default NULL, ID_DUTCH varchar(128) binary default NULL, ID_EPIC_CODE varchar(128) binary default NULL, ID_EUROCLEAR varchar(128) binary default NULL, ID_FRENCH varchar(128) binary default NULL, ID_HONG_KONG varchar(128) binary default NULL, ID_IRISH_SEDOL varchar(128) binary default NULL, ID_ISIN varchar(128) binary default NULL, ID_ISMA varchar(128) binary default NULL, ID_ISRAELI varchar(128) binary default NULL, ID_ITALY varchar(128) binary default NULL, ID_JAPAN varchar(128) binary default NULL, ID_JAPAN_COMPANY varchar(128) binary default NULL, ID_LOCAL varchar(128) binary default NULL, ID_LUXEMBOURG varchar(128) binary default NULL, ID_MDM_MISC_DOMES varchar(128) binary default NULL, ID_NORWAY varchar(128) binary default NULL, ID_PRPL varchar(128) binary default NULL, ID_SEDOL1 varchar(128) binary default NULL, ID_SEDOL2 varchar(128) binary default NULL, ID_SINGAPORE varchar(128) binary default NULL, ID_SPAIN varchar(128) binary default NULL, ID_SWEDISH varchar(128) binary default NULL, ID_VALOREN varchar(128) binary default NULL, ID_WERTPAPIER varchar(128) binary default NULL, INCR_IN_EQY double default NULL, INCR_IN_EQY_PCT_OF_TOT double default NULL, INCR_IN_LIAB double default NULL, INCR_IN_LIAB_PCT_OF_TOT double default NULL, INC_BEF_XO_ITEMS_TO_NET_SALES double default NULL, INC_BEF_XO_ITEM_YR_CHNG double default NULL, INC_DEC_LT_INVEST double default NULL, INC_TAX_EXP_TO_NET_SALES double default NULL, INC_TAX_EXP_YR_CHNG double default NULL, INDUSTRY_GROUP varchar(128) binary default NULL, INDUSTRY_GROUP_INDEX varchar(128) binary default NULL, INDUSTRY_SECTOR varchar(128) binary default NULL, INDUSTRY_SUBGROUP varchar(128) binary default NULL, INDUSTRY_SUBGROUP_NUM int(11) default NULL, INDX_ADV_NUM double default NULL, INDX_ADV_VOL double default NULL, INDX_DECL_NUM double default NULL, INDX_DECL_VOL double default NULL, INDX_DIVISOR double default NULL, INDX_GWEIGHT text, INDX_MWEIGHT text, INDX_POS_ERN double default NULL, INDX_POS_EST_ERN double default NULL, INDX_TRADING_DAY varchar(128) binary default NULL, INDX_UNCH_NUM double default NULL, INDX_UNCH_VOL double default NULL, INS_CLAIM_CHRG_TO_TOT_REV double default NULL, INS_CLAIM_PER_CHRG_GROWTH double default NULL, INS_RES_GROWTH double default NULL, INTANGIBLE_AND_OTHER double default NULL, INTERBANKING_ASSETS double default NULL, INTERBANK_ASSET_TO_TOT_ASSET double default NULL, INTEREST_INCOME double default NULL, INTEREST_INCOME_NET_OTHER_LG double default NULL, INTERNAL_CASH_GEN double default NULL, INT_ACC double default NULL, INT_ACC_DT date default NULL, INT_BEAR_LIAB double default NULL, INT_BURDEN double default NULL, INT_EXP_BANK_GROWTH double default NULL, INT_EXP_COVERAGE double default NULL, INT_EXP_GROWTH double default NULL, INT_EXP_INC_GROWTH double default NULL, INT_EXP_REITS_GROWTH double default NULL, INT_EXP_REITS_TO_TOT_REV2 double default NULL, INT_EXP_TO_INT_BEAR_LIAB double default NULL, INT_EXP_TO_NET_SALES double default NULL, INT_EXP_TO_TOT_DEBT double default NULL, INT_EXP_TO_TOT_DPST double default NULL, INT_EXP_TO_TOT_REV double default NULL, INT_EXP_TO_TOT_REV_UTL double default NULL, INT_EXP_YR_CHNG double default NULL, INT_INC_TO_AVG_TOT_LOAN double default NULL, INT_INC_TO_TOT_LOAN double default NULL, INT_INC_TO_TOT_REV double default NULL, INT_INVEST_INC_TO_INVEST_ASSET double default NULL, INVENT_DAYS double default NULL, INVENT_TO_TOT_ASSET double default NULL, INVENT_TURN double default NULL, INVESTMENTS double default NULL, INVEST_INC_BEF_FEES_PER_UNIT double default NULL, INVEST_INC_GROWTH double default NULL, INVEST_INC_TO_TOT_REV double default NULL, INVEST_INC_TO_TOT_REV_INS double default NULL, INVEST_IN_ASSOC_TO_TOT_ASSET double default NULL, INVEST_LESS_DEF_DEBT double default NULL, INVST_INCOME double default NULL, INVTRY_FINISHED_GOODS double default NULL, INVTRY_IN_PROGRESS double default NULL, INVTRY_RAW_MATERIALS double default NULL, INV_INCOME_BEF_FEES double default NULL, INV_TO_CASH_DAYS double default NULL, ISSUER varchar(128) binary default NULL, ISSUER_BULK text, ISSUER_CMPID varchar(128) binary default NULL, ISSUER_INDUSTRY varchar(128) binary default NULL, ISSUER_SECID varchar(128) binary default NULL, ISSUE_BNCHMRK varchar(128) binary default NULL, ISSUE_DT date default NULL, ISSUE_PX double default NULL, ISSUE_SPREAD_BNCHMRK int(11) default NULL, ISSUE_YLD double default NULL, IS_ABNORMAL_ITEM double default NULL, IS_ADJUST_LIFE double default NULL, IS_ADJUST_NL double default NULL, IS_AFUDC_DEBT double default NULL, IS_AFUDC_EQY double default NULL, IS_ALLOW_ROE_RETAIL double default NULL, IS_ALLOW_ROE_WHOLESALE double default NULL, IS_AVG_NUM_SH_FOR_EPS double default NULL, IS_CAPSEC_OR_TRUST_PFD char(1) binary default NULL, IS_CAP_INT_EXP double default NULL, IS_CASH_AVAIL_FOR_DIST double default NULL, IS_COGS_TO_FE_AND_PP_AND_G double default NULL, IS_COMM_AND_FEE_EARN_INC_REO double default NULL, IS_COMM_FEE_PAID_TO_MGMT_EXP double default NULL, IS_COMPREHENSIVE_INCOME double default NULL, IS_COMPREHENSIVE_INCOME_PER_SHR double default NULL, IS_COST_OF_MATL double default NULL, IS_DEPR_EXP double default NULL, IS_DIL_EPS_BEF_XO double default NULL, IS_DIL_EPS_CONT_OPS double default NULL, IS_DISTRIBUTED_FUNDS double default NULL, IS_DIV_PER_SHR double default NULL, IS_DOLLAR_PFD char(1) binary default NULL, IS_EARN_BEF_XO_ITEMS_PER_SH double default NULL, IS_ELECT_REV_COMM_RETAIL double default NULL, IS_ELECT_REV_INDUS_RETAIL double default NULL, IS_ELECT_REV_OTHER_RETAIL double default NULL, IS_ELECT_REV_RES_RETAIL double default NULL, IS_ELECT_REV_UNDER_FERC_REG double default NULL, IS_ELECT_SALE_COMM_RETAIL double default NULL, IS_ELECT_SALE_INDUS_RETAIL double default NULL, IS_ELECT_SALE_OTHER_RETAIL double default NULL, IS_ELECT_SALE_RES_RETAIL double default NULL, IS_EPS double default NULL, IS_EPS_BEF_ABNORMAL_ITEM double default NULL, IS_EPS_BEF_GL_OF_PRPTY_MTG double default NULL, IS_EQY_EARN_FROM_INVEST_ASSOC double default NULL, IS_EXPORT_SALES double default NULL, IS_FFO_PERH_SH_FULL_DILUTED double default NULL, IS_FOREIGN_EXCH_LOSS double default NULL, IS_FUEL_COST double default NULL, IS_FULLY_DILUTED_EPS double default NULL, IS_GAS_REV_COMM double default NULL, IS_GAS_REV_INDUS double default NULL, IS_GAS_REV_INTERRUPT double default NULL, IS_GAS_REV_RES double default NULL, IS_GAS_REV_TRANS_OTHER double default NULL, IS_GAS_SALES_COMM double default NULL, IS_GAS_SALES_INDUS double default NULL, IS_GAS_SALES_INTERRUPT double default NULL, IS_GAS_SALES_RES double default NULL, IS_GAS_SALES_TRANS_OTHER double default NULL, IS_GL_ON_SALE_OF_PRPTY_MTG double default NULL, IS_GNRL_AND_ADMIN_EXP double default NULL, IS_GROSS_PREM_EARN_LIFE double default NULL, IS_GROSS_PREM_EARN_NL double default NULL, IS_INC_BEF_XO_ITEM double default NULL, IS_INC_TAX_EXP double default NULL, IS_INC_UNCONS_EQTY_INT double default NULL, IS_INDEX_LINKED char(1) binary default NULL, IS_INS_CLAIM_AND_LOSS_L double default NULL, IS_INS_CLAIM_AND_LOSS_NL double default NULL, IS_INT_EXP_BANK_OPER double default NULL, IS_INT_EXP_BOND double default NULL, IS_INT_INC_BANK_OPER double default NULL, IS_INVEST_INCOME double default NULL, IS_INVEST_INC_BANK_OPER double default NULL, IS_JASDAQ_MKT_MAKER char(1) binary default NULL, IS_LT_INS_CHRG_L double default NULL, IS_MAINT_EXP double default NULL, IS_MAINT_EXP_REITS double default NULL, IS_MINORITY_INT double default NULL, IS_NET_AFTER_DISTRIBUTIONS double default NULL, IS_NET_INC_AVAIL_COM_SHRHLDRS double default NULL, IS_NET_NON_OPER_LOSS double default NULL, IS_NET_OPER_EXP double default NULL, IS_OPER_INC double default NULL, IS_OPER_PROF_FROM_DISC_OPER double default NULL, IS_OTHER_INT_EXP double default NULL, IS_OTHER_OPER_EXP double default NULL, IS_OTHER_OPER_INC double default NULL, IS_OTHER_OPER_INC_LOSSES double default NULL, IS_OTHER_REV double default NULL, IS_PERPETUAL char(1) binary default NULL, IS_PLCY_HOLD_SURPLUS double default NULL, IS_PROV_FOR_LOAN_LOSS double default NULL, IS_PURCH_GAS_COST double default NULL, IS_PURCH_POWER_COST double default NULL, IS_RD_EXPEND double default NULL, IS_REG_S char(1) binary default NULL, IS_RENT_INC double default NULL, IS_REVERSE_CONVERTIBLE char(1) binary default NULL, IS_REV_FROM_ELECT double default NULL, IS_REV_FROM_GAS double default NULL, IS_REV_FROM_WATER double default NULL, IS_RE_TAX_EXP double default NULL, IS_RSRV_CHRG double default NULL, IS_SALES_TURN_REV_FROM_DISC_OPER double default NULL, IS_SETS char(1) binary default NULL, IS_SGA_OTHER_OP_DEPR_OP_MAINT double default NULL, IS_SH_FOR_FULLY_DILUTED_EPS double default NULL, IS_SOFT_CALL char(1) binary default NULL, IS_SPECIAL_EPS double default NULL, IS_SQUARE_GLA double default NULL, IS_STK_MARGINABLE char(1) binary default NULL, IS_SUBORDINATED char(1) binary default NULL, IS_TAX_EFF_ON_ABNORMAL_ITEM double default NULL, IS_TAX_EFF_ON_XO_ITEM double default NULL, IS_TAX_EQV_ADJ double default NULL, IS_TAX_OTHER_THAN_INC_TAX double default NULL, IS_TOT_CASH_COM_DVD double default NULL, IS_TOT_CASH_PFD_DVD double default NULL, IS_TOT_ELECT_REV_RETAIL double default NULL, IS_TOT_ELECT_SALE_RETAIL double default NULL, IS_TOT_ELECT_SALE_WHOLESALE double default NULL, IS_TOT_NET_LIFE_PLCY_IN_FORCE double default NULL, IS_TOT_NET_PREM_EARN double default NULL, IS_TOT_OPER_EXP double default NULL, IS_TRADING_ACCT_PROF double default NULL, IS_TRADING_PROF_DISC_OPS double default NULL, IS_TRANSLATION double default NULL, IS_TRANS_FOR_FUT_APPROP double default NULL, IS_UNDW_AND_PLCY_ACQ_COST_L double default NULL, IS_UNDW_AND_PLCY_ACQ_COST_NL double default NULL, IS_UNITS double default NULL, IS_UNIT_TRADED char(1) binary default NULL, IS_UNRLZD_GAIN double default NULL, IS_UNTAXED_RSRV double default NULL, IS_VAL_ADDED double default NULL, IS_XO_LOSS_BEF_TAX_EFF double default NULL, LARGE_DPST_TO_EARN_ASSET double default NULL, LAST_REFIX_DT date default NULL, LATEST_ANN_CIE_FILING varchar(128) default NULL, LATEST_ANN_DT_ANNUAL date default NULL, LATEST_ANN_DT_QTRLY date default NULL, LATEST_ANN_DT_SEMI date default NULL, LATEST_FULL_PERIOD_END_DT date default NULL, LEAD_MGR varchar(128) binary default NULL, LEGAL_OPINION varchar(128) binary default NULL, LEGAL_OPINION_CITY varchar(128) binary default NULL, LEGAL_OPINION_STATE varchar(128) binary default NULL, LIAB_GROWTH double default NULL, LIFE_PLCY_BNFT_TO_SHRHLDR_EQY double default NULL, LIQUIDITY_AGREEMENT varchar(128) binary default NULL, LIQUIDITY_AGREEMENT_CITY varchar(128) binary default NULL, LIQUIDITY_AGREEMENT_STATE varchar(128) binary default NULL, LISTED_EXCH text, LOAN_AND_MTG_TO_TOT_INVEST double default NULL, LOAN_LOSS_COVERAGE double default NULL, LOAN_LOSS_RES_TO_NON_PERF_ASSET double default NULL, LONG_COMP_NAME text, LOSS_RATIO_NL double default NULL, LSE_SECTOR varchar(128) binary default NULL, LSE_SEGMENT varchar(128) binary default NULL, LT_BORROW_TO_TOT_LIAB_AND_EQY double default NULL, LT_DEBT_TO_COM_EQY double default NULL, LT_DEBT_TO_TOT_ASSET double default NULL, LT_DEBT_TO_TOT_CAP double default NULL, LT_INVEST_TO_TOT_ASSET double default NULL, MAKE_WHOLE_CALL char(1) binary default NULL, MARKET_ISSUE varchar(128) binary default NULL, MARKET_SECTOR int(11) default NULL, MARKET_SECTOR_DES varchar(128) binary default NULL, MARKET_STATUS varchar(128) binary default NULL, MATURITY date default NULL, MAX_REDEMP_FEE double default NULL, MINORITY_INT_TO_NET_SALES double default NULL, MINORITY_INT_YR_CHNG double default NULL, MIN_DENOMINATION int(11) default NULL, MIN_INCREMENT double default NULL, MIN_INT_TO_TOT_LIAB_AND_EQY double default NULL, MIN_PIECE double default NULL, MKT_CAP_LISTED double default NULL, MKT_SEC_TO_ASSET double default NULL, MKT_VAL_OF_EQY double default NULL, MOODY_EFF_DT date default NULL, MOST_RECENT_HIST_CHARGE_OFF_1M double default NULL, MOST_RECENT_HIST_CHARGE_OFF_3M double default NULL, MOST_RECENT_HIST_CHARGE_OFF_DT date default NULL, MOST_RECENT_HIST_DLQ_DT date default NULL, MOST_RECENT_REPORTED_FACTOR double default NULL, MTG_ACC_RT_END_DT date default NULL, MTG_ALL_FLUX double default NULL, MTG_ALL_FLUX_DT date default NULL, MTG_AMORT_TYP varchar(128) binary default NULL, MTG_AMORT_WAM int(11) default NULL, MTG_AMT_OUT_FACE double default NULL, MTG_ANNUAL_FLUX double default NULL, MTG_ANNUAL_FLUX_DT date default NULL, MTG_AOLS varchar(128) binary default NULL, MTG_ARM_ACC_RT_STRUCT varchar(128) binary default NULL, MTG_ARM_SUBTYP varchar(128) binary default NULL, MTG_ARM_TRANSFER_TYP varchar(128) binary default NULL, MTG_BAL varchar(128) binary default NULL, MTG_BALLOON_WAM double default NULL, MTG_BASE_RT double default NULL, MTG_BOND_VAL varchar(128) binary default NULL, MTG_CALL_NOT_CODED varchar(128) binary default NULL, MTG_CALL_PCT int(11) default NULL, MTG_CALL_RULES_LATER varchar(128) binary default NULL, MTG_CARD_MPR double default NULL, MTG_CLASS_CALL_DT date default NULL, MTG_CLASS_CALL_PCT double default NULL, MTG_CMO_CLASS varchar(128) binary default NULL, MTG_CMO_FLUX double default NULL, MTG_CMO_FLUX_DT date default NULL, MTG_CMO_GROUP varchar(128) binary default NULL, MTG_CMO_SERIES varchar(128) binary default NULL, MTG_CNVS_PER_BEG date default NULL, MTG_CNVS_PER_END date default NULL, MTG_COLLAT_AGE_HIGH int(11) default NULL, MTG_COLLAT_AGE_LOW int(11) default NULL, MTG_COLLAT_DT date default NULL, MTG_COLLAT_SEASONING varchar(128) binary default NULL, MTG_COLLAT_TYP varchar(128) binary default NULL, MTG_COMPLIANCE_CODE varchar(128) binary default NULL, MTG_CONTRIB_CF varchar(128) binary default NULL, MTG_CONV varchar(128) binary default NULL, MTG_CRED_PROV varchar(128) binary default NULL, MTG_CTRL_MOS varchar(128) binary default NULL, MTG_CUR_INT_PAY double default NULL, MTG_CUR_PAY_DT date default NULL, MTG_CUR_PAY_RT double default NULL, MTG_CUR_PRINC_PAY double default NULL, MTG_DEAL_CALL_DT date default NULL, MTG_DEAL_CALL_PCT double default NULL, MTG_DEAL_CUR_COLLAT_AMT int(11) default NULL, MTG_DEAL_CUR_NET double default NULL, MTG_DEAL_ORIG_FACE int(11) default NULL, MTG_DEAL_ORIG_NET double default NULL, MTG_DEAL_PX_SPD varchar(128) binary default NULL, MTG_DEAL_TYP varchar(128) binary default NULL, MTG_DEBT_PER_RE_INVEST double default NULL, MTG_DEBT_TO_TOT_DEBT double default NULL, MTG_DEF_INT_ALLOWED char(1) binary default NULL, MTG_DISC_FREQ_COLLAT int(11) default NULL, MTG_DLQ_C1_DEF varchar(128) binary default NULL, MTG_DLQ_C2_DEF varchar(128) binary default NULL, MTG_DLQ_C3_DEF varchar(128) binary default NULL, MTG_DLQ_O60_DOL double default NULL, MTG_DLQ_U60_DOL double default NULL, MTG_DTC_TYP varchar(128) binary default NULL, MTG_END_ACC_DT_SET_DT date default NULL, MTG_EST_ACC_RT double default NULL, MTG_EXS_SPREAD double default NULL, MTG_FACE_AMT varchar(128) binary default NULL, MTG_FACTOR double default NULL, MTG_FACTOR_DT varchar(128) binary default NULL, MTG_FACTOR_INT_PAY double default NULL, MTG_FACTOR_NUM_DT date default NULL, MTG_FACTOR_PAY_DT date default NULL, MTG_FACTOR_PAY_RT double default NULL, MTG_FACTOR_PRINC_PAY double default NULL, MTG_FACTOR_SET_DT double default NULL, MTG_FACTOR_SET_DT_END_ACC_DT date default NULL, MTG_FACTOR_SET_DT_PAY_DT date default NULL, MTG_FACTOR_SET_DT_START_ACC_DT date default NULL, MTG_FACT_SET_DT_STRT_NEXT_ACC_DT date default NULL, MTG_FIRST_PAY_DT date default NULL, MTG_FIRST_PAY_RST_DT date default NULL, MTG_FIRST_RST_DT date default NULL, MTG_GEN_CPR_ISS double default NULL, MTG_GEN_FACTOR int(11) default NULL, MTG_GEN_PSA_ISS double default NULL, MTG_GEN_TICKER varchar(22) binary default NULL, MTG_GEO varchar(128) binary default NULL, MTG_GROUP_DES varchar(128) binary default NULL, MTG_HIST_1ST_PRINC_PAY_DT date default NULL, MTG_INT_DEFERRED double default NULL, MTG_INT_DIST double default NULL, MTG_INT_EXPECT double default NULL, MTG_INT_SHORTFALL double default NULL, MTG_IS_MEGA char(1) binary default NULL, MTG_LIFE_CAP double default NULL, MTG_LIFE_FLOOR double default NULL, MTG_LOAN_AGE int(11) default NULL, MTG_LOAN_MRGN double default NULL, MTG_LOCK_WAM int(11) default NULL, MTG_LOOKBACK varchar(128) binary default NULL, MTG_MIN_INCREMENT int(11) default NULL, MTG_MIN_INDX_MOV double default NULL, MTG_MRG_DIFF int(11) default NULL, MTG_NEGAM_FACT double default NULL, MTG_NEGAM_FACT_DT date default NULL, MTG_NOTL_PRINC_FLAG varchar(128) binary default NULL, MTG_NUM_BONDS_DEAL varchar(128) binary default NULL, MTG_NUM_CPT_DEAL varchar(128) binary default NULL, MTG_NUM_ORIG_LOAN int(11) default NULL, MTG_NUM_POOLS varchar(128) binary default NULL, MTG_NXT_ACC_PER_BEG date default NULL, MTG_NXT_ADJ_DT date default NULL, MTG_NXT_PAY_DT_SET_DT date default NULL, MTG_OID_CLASS_TYP varchar(128) binary default NULL, MTG_OID_DE_MINIMIS char(1) binary default NULL, MTG_OID_DISC_STAT varchar(128) binary default NULL, MTG_OID_RETAIL_FLAG varchar(128) binary default NULL, MTG_OID_TAX_ID varchar(128) binary default NULL, MTG_ORIG_ACC_RT double default NULL, MTG_ORIG_AMT varchar(128) binary default NULL, MTG_ORIG_CPN_HIGH double default NULL, MTG_ORIG_CPN_LOW double default NULL, MTG_ORIG_LCAP_HIGH double default NULL, MTG_ORIG_LCAP_LOW double default NULL, MTG_ORIG_LFLOOR_AVG double default NULL, MTG_ORIG_LFLOOR_HIGH double default NULL, MTG_ORIG_LFLOOR_LOW double default NULL, MTG_ORIG_LIFE_CAP double default NULL, MTG_ORIG_MRGN_HIGH double default NULL, MTG_ORIG_MRGN_LOW double default NULL, MTG_ORIG_PAC_COLLARS varchar(128) binary default NULL, MTG_ORIG_RMTY_HIGH double default NULL, MTG_ORIG_RMTY_LOW double default NULL, MTG_ORIG_SERV_LINE1 varchar(128) binary default NULL, MTG_ORIG_SERV_LINE2 varchar(128) binary default NULL, MTG_ORIG_SERV_LINE3 varchar(128) binary default NULL, MTG_ORIG_SERV_LINE4 varchar(128) binary default NULL, MTG_ORIG_WAC double default NULL, MTG_ORIG_WAL double default NULL, MTG_ORIG_WAM double default NULL, MTG_PAC_COLLARS varchar(128) binary default NULL, MTG_PAC_DT date default NULL, MTG_PAY_CAP double default NULL, MTG_PAY_CHG_FREQ varchar(128) binary default NULL, MTG_PAY_DELAY varchar(128) binary default NULL, MTG_PAY_METHOD varchar(128) binary default NULL, MTG_PAY_RT double default NULL, MTG_PER_RT_CAP double default NULL, MTG_PL_ABS_12M double default NULL, MTG_PL_ABS_1M double default NULL, MTG_PL_ABS_3M double default NULL, MTG_PL_ABS_6M double default NULL, MTG_PL_ABS_ISS double default NULL, MTG_PL_CPR_12M double default NULL, MTG_PL_CPR_1M double default NULL, MTG_PL_CPR_3M double default NULL, MTG_PL_CPR_6M double default NULL, MTG_PL_CPR_ISS double default NULL, MTG_PL_PSA_12M int(11) default NULL, MTG_PL_PSA_1M int(11) default NULL, MTG_PL_PSA_3M int(11) default NULL, MTG_PL_PSA_6M int(11) default NULL, MTG_PL_PSA_ISS double default NULL, MTG_POOL_ALPHA varchar(128) binary default NULL, MTG_POOL_FACTOR double default NULL, MTG_POOL_NUMBER varchar(128) binary default NULL, MTG_POOL_TYP varchar(128) binary default NULL, MTG_PORT_YLD double default NULL, MTG_PREPAY_MODEL varchar(128) binary default NULL, MTG_PREPAY_SPEED double default NULL, MTG_PREPAY_TYP varchar(128) binary default NULL, MTG_PREV_BAL varchar(128) binary default NULL, MTG_PREV_CPN double default NULL, MTG_PREV_FACTOR double default NULL, MTG_PREV_FACTOR_DT varchar(128) binary default NULL, MTG_PREV_FACTOR_NUM_DT varchar(128) default NULL, MTG_PRINC_DIST double default NULL, MTG_PRINC_LOSSES double default NULL, MTG_PROPERTY_TYP varchar(128) binary default NULL, MTG_PRPL_DES varchar(128) binary default NULL, MTG_PX_SPD varchar(128) binary default NULL, MTG_PX_SPD_DT date default NULL, MTG_QRT_AGE_25 int(11) default NULL, MTG_QRT_AGE_75 int(11) default NULL, MTG_QRT_AGE_MAX int(11) default NULL, MTG_QRT_AGE_MED int(11) default NULL, MTG_QRT_AGE_MIN int(11) default NULL, MTG_QRT_AOLS_25 int(11) default NULL, MTG_QRT_AOLS_75 int(11) default NULL, MTG_QRT_AOLS_MAX int(11) default NULL, MTG_QRT_AOLS_MED int(11) default NULL, MTG_QRT_AOLS_MIN int(11) default NULL, MTG_QRT_ASOF_DT date default NULL, MTG_QRT_CPN_25 double default NULL, MTG_QRT_CPN_75 double default NULL, MTG_QRT_CPN_MAX double default NULL, MTG_QRT_CPN_MED double default NULL, MTG_QRT_CPN_MIN double default NULL, MTG_QRT_MTY_25 int(11) default NULL, MTG_QRT_MTY_75 int(11) default NULL, MTG_QRT_MTY_MAX int(11) default NULL, MTG_QRT_MTY_MED int(11) default NULL, MTG_QRT_MTY_MIN int(11) default NULL, MTG_QRT_TERM_25 int(11) default NULL, MTG_QRT_TERM_75 int(11) default NULL, MTG_QRT_TERM_MAX int(11) default NULL, MTG_QRT_TERM_MED int(11) default NULL, MTG_QRT_TERM_MIN int(11) default NULL, MTG_RCV double default NULL, MTG_RECORD_DT date default NULL, MTG_RESET_SLOPE double default NULL, MTG_REV_TERM_DT date default NULL, MTG_RT_CHG_FREQ varchar(128) binary default NULL, MTG_SERV varchar(128) binary default NULL, MTG_SMMEA_STAT varchar(128) binary default NULL, MTG_START_ACC_DT_SET_DT date default NULL, MTG_STATED_DT varchar(128) binary default NULL, MTG_STATED_NUM_DT varchar(128) binary default NULL, MTG_STATED_WALA int(11) default NULL, MTG_STATED_WARM int(11) default NULL, MTG_TAX_1984 char(1) binary default NULL, MTG_TAX_1985 char(1) binary default NULL, MTG_TRANCHE_TYP varchar(128) binary default NULL, MTG_TRANCHE_TYP_LONG varchar(128) binary default NULL, MTG_TRUSTEE varchar(128) binary default NULL, MTG_TYP varchar(128) binary default NULL, MTG_UNDW_DISC double default NULL, MTG_WACPN double default NULL, MTG_WAC_CALC double default NULL, MTG_WAL double default NULL, MTG_WALA_CALC double default NULL, MTG_WAL_CALL double default NULL, MTG_WAM double default NULL, MTG_WAM_NXT_RST varchar(128) binary default NULL, MTG_WAM_SD int(11) default NULL, MTG_WAM_SD_YRM varchar(128) binary default NULL, MTG_WAM_YRM varchar(128) binary default NULL, MTG_WAOLT int(11) default NULL, MTG_WA_COMP_MA int(11) default NULL, MTG_WA_NEG_AM_LIMIT int(11) default NULL, MTG_WHLN_30DLQ double default NULL, MTG_WHLN_60DLQ double default NULL, MTG_WHLN_90DLQ double default NULL, MTG_WHLN_BAL36 double default NULL, MTG_WHLN_BALGT6 double default NULL, MTG_WHLN_CRED_SUP double default NULL, MTG_WHLN_FCLS double default NULL, MTG_WHLN_GEO1 varchar(128) binary default NULL, MTG_WHLN_GEO2 varchar(128) binary default NULL, MTG_WHLN_GEO3 varchar(128) binary default NULL, MTG_WHLN_GEO4 varchar(128) binary default NULL, MTG_WHLN_LIM_DOC double default NULL, MTG_WHLN_LTV double default NULL, MTG_WHLN_NUMBER_LOAN int(11) default NULL, MTG_WHLN_REO double default NULL, MTG_WHLN_WALA double default NULL, MTG_WHLN_WALTV double default NULL, MTY_TYP varchar(128) binary default NULL, MULTIPLE_SHARE char(1) binary default NULL, MULTI_CPN_SCHEDULE_TYP int(11) default NULL, MUNI_LOC1_CITY varchar(128) binary default NULL, MUNI_LOC1_STATE varchar(128) binary default NULL, MUNI_LOC2_CITY varchar(128) binary default NULL, MUNI_LOC2_STATE varchar(128) binary default NULL, MUNI_LOC3_CITY varchar(128) binary default NULL, MUNI_LOC3_STATE varchar(128) binary default NULL, MUNI_LOC4_CITY varchar(128) binary default NULL, MUNI_LOC4_STATE varchar(128) binary default NULL, MUNI_LOC5_CITY varchar(128) binary default NULL, MUNI_LOC5_STATE varchar(128) binary default NULL, MUNI_PAYING_AGENT varchar(128) binary default NULL, MUNI_PAYING_AGENT_CITY varchar(128) binary default NULL, MUNI_PAYING_AGENT_STATE varchar(128) binary default NULL, MUNI_PURCH_AGREEMENT_CITY varchar(128) binary default NULL, MUNI_PURCH_AGREEMENT_STATE varchar(128) binary default NULL, MUNI_REGISTRAR varchar(128) binary default NULL, MUNI_REVISED_ISSUE_PX double default NULL, MUNI_TRUSTEE varchar(128) binary default NULL, NAME varchar(128) binary default NULL, NET_ASSETS double default NULL, NET_CAP_EXP double default NULL, NET_CAP_STOCK double default NULL, NET_CHNG_IN_LT_DEBT double default NULL, NET_CHNG_LT_DEBT double default NULL, NET_CHNG_SRC_OF_CAP_OTHER_LIAB double default NULL, NET_CHNG_ST_DEBT double default NULL, NET_CHNG_TOT_DPST double default NULL, NET_CHRG_OFF_TO_AVG_TOT_LOAN double default NULL, NET_DEBT double default NULL, NET_DEBT_TO_SHRHLDR_EQTY double default NULL, NET_FIX_ASSET_TO_TOT_ASSET double default NULL, NET_FIX_ASSET_TURN double default NULL, NET_INCOME double default NULL, NET_INCOME_BEF_FEES double default NULL, NET_INCOME_BEF_MI double default NULL, NET_INC_GROWTH double default NULL, NET_INC_LESS_D_A double default NULL, NET_INC_PER_EMPL double default NULL, NET_INC_TO_AVG_EARN_ASSET double default NULL, NET_INC_TO_AVG_RE_ASSET double default NULL, NET_INC_TO_INT_EXP double default NULL, NET_INT_AFTER_PROV_GROWTH double default NULL, NET_INT_INC_AFT_PROV double default NULL, NET_INT_INC_AFT_PROV_TO_TOT_REV double default NULL, NET_INT_INC_GROWTH double default NULL, NET_INT_INC_TO_EARN_ASSET double default NULL, NET_INT_INC_TO_TOT_REV double default NULL, NET_INT_MARGIN double default NULL, NET_INVEST_INC_TO_OPER_INC double default NULL, NET_LOAN_TO_TOT_ASSET double default NULL, NET_NON_OPER_LOSS double default NULL, NET_NON_OPER_LOSS_YR_CHNG double default NULL, NET_NUCLR_FUEL_TO_TOT_ASSET double default NULL, NET_OPER_INCOME double default NULL, NET_OPER_INCOME_PER_DIL_SHR double default NULL, NET_OPER_INCOME_PER_SHR double default NULL, NET_OTHER_PRPTY_TO_TOT_ASSET double default NULL, NET_PLANT_IN_SERV_TO_TOT_ASSET double default NULL, NET_PLANT_TO_TOT_REV double default NULL, NET_PREM_EARNED_NL double default NULL, NET_PREM_EARN_TO_SHRHLDR_EQY double default NULL, NET_PREM_EARN_TO_TOT_REV double default NULL, NET_REV double default NULL, NET_REV_AFT_PROV double default NULL, NET_REV_BASIC_SHR double default NULL, NET_REV_DIL_SHR double default NULL, NET_REV_GROWTH double default NULL, NET_REV_MARGIN double default NULL, NET_REV_TO_NON_INT_EXP double default NULL, NET_SALES_TO_NET_SALES double default NULL, NET_UTIL_PLANT_PER_SH double default NULL, NET_WORTH_GROWTH double default NULL, NOI_GROWTH double default NULL, NON_CUR_LIAB double default NULL, NON_INT_EXP double default NULL, NON_INT_EXP_GROWTH double default NULL, NON_INT_EXP_TO_TOT_REV double default NULL, NON_INT_INC_GROWTH double default NULL, NON_INT_INC_TO_TOT_REV double default NULL, NON_INVEST_INC_TO_TOT_REV double default NULL, NON_PERFORM_ASSET_TO_TOT_LOAN double default NULL, NON_PERF_ASSET_TO_TOT_ASSET double default NULL, NON_UTIL_CAP_EXP double default NULL, NOTES_RECEIVABLE double default NULL, NUM_DAYS_IN_PER double default NULL, NXT_CALL_DT date default NULL, NXT_CALL_PX double default NULL, NXT_CAP_AMT double default NULL, NXT_CAP_DT date default NULL, NXT_CPN_DT date default NULL, NXT_PAR_CALL_DT date default NULL, NXT_PAR_CALL_PX double default NULL, NXT_PAR_PUT_DT date default NULL, NXT_PREMIUM_CALL_DT date default NULL, NXT_PREMIUM_CALL_PX double default NULL, NXT_PUT_DT date default NULL, NXT_PUT_PX double default NULL, NXT_REFIX_DT date default NULL, NXT_REFUND_DT date default NULL, NXT_SINK_AMT double default NULL, NXT_SINK_DT date default NULL, NXT_SINK_PX double default NULL, NYSE_POST_AND_PANEL varchar(128) binary default NULL, OID_BOND char(1) binary default NULL, OPER_INCOME_LESS_RLZD_GAIN_LOSS double default NULL, OPER_INC_BEF_EXP_PER_REV double default NULL, OPER_INC_BEF_INT_PER_RE_INVEST double default NULL, OPER_INC_GROWTH double default NULL, OPER_INC_PER_AVG_EARN_ASSET double default NULL, OPER_INC_PER_SH double default NULL, OPER_INC_TO_CUR_LIAB double default NULL, OPER_INC_TO_INT_EXP double default NULL, OPER_INC_TO_LT_DEBT double default NULL, OPER_INC_TO_NET_PREM_EARN double default NULL, OPER_INC_TO_NET_SALES double default NULL, OPER_INC_TO_REV double default NULL, OPER_INC_TO_TOT_CAP double default NULL, OPER_INC_TO_TOT_DEBT double default NULL, OPER_MARGIN double default NULL, OPT_ADJ_CONTRACT char(1) binary default NULL, OPT_CONT_SIZE int(11) default NULL, OPT_CRNCY_FOREIGN varchar(12) binary default NULL, OPT_EXER_TYP varchar(128) binary default NULL, OPT_EXPIRE_DT date default NULL, OPT_PUT_CALL varchar(128) binary default NULL, OPT_STRIKE_PX double default NULL, OPT_UNDL_CMPID varchar(128) binary default NULL, OPT_UNDL_CRNCY varchar(12) binary default NULL, OPT_UNDL_CUSIP varchar(18) binary default NULL, OPT_UNDL_ISIN varchar(128) binary default NULL, OPT_UNDL_SECID varchar(128) binary default NULL, OPT_UNDL_TICKER varchar(22) binary default NULL, OTHER_ASSETS double default NULL, OTHER_ASSET_TO_TOT_ASSET double default NULL, OTHER_CUR_ASSET_TO_TOT_ASSET double default NULL, OTHER_DEP_TOT_LIAB_AND_EQY double default NULL, OTHER_EXP_GROWTH double default NULL, OTHER_EXP_TO_TOT_REV double default NULL, OTHER_INCOME_STI double default NULL, OTHER_INC_LOSS_TO_TOT_REV double default NULL, OTHER_INC_TO_TOT_REV2 double default NULL, OTHER_INS_RES_TO_SHRHLDR_EQY double default NULL, OTHER_INVEST_TO_TOT_INVEST double default NULL, OTHER_LIAB double default NULL, OTHER_LIAB_TOT_MKT_VAL double default NULL, OTHER_LOAN_TO_TOT_ASSET double default NULL, OTHER_LT_INVEST_TO_TOT_ASSET double default NULL, OTHER_LT_LIAB double default NULL, OTHER_NON_CASH_ADJ double default NULL, OTHER_OPER_INC_GROWTH double default NULL, OTHER_OPER_INC_TO_TOT_REV double default NULL, OTHER_OPER_INC_YR_CHNG double default NULL, OTHER_USES double default NULL, OTH_LT_LIAB_TO_TOT_LIAB_AND_EQY double default NULL, OTH_ST_LIAB_TO_TOT_LIAB_AND_EQY double default NULL, OVERHEAD_EFF_RATIO double default NULL, PARENT_COMP_COUNTRY_ISO varchar(8) binary default NULL, PARENT_COMP_NAME varchar(128) binary default NULL, PARENT_COMP_TICKER varchar(22) binary default NULL, PARENT_INDUSTRY_GROUP varchar(128) binary default NULL, PARENT_INDUSTRY_SECTOR varchar(128) binary default NULL, PARENT_INDUSTRY_SUBGROUP varchar(128) binary default NULL, PAR_AMT double default NULL, PAR_VAL_CRNCY varchar(12) binary default NULL, PCS_QUOTE_TYP int(11) default NULL, PCT_OF_REV_ELECT double default NULL, PCT_PAR_QUOTED char(1) binary default NULL, PCT_SINKER char(1) binary default NULL, PENULTIMATE_CPN_DT date default NULL, PERIOD_END_DT date default NULL, PE_DVFA_STANDARD double default NULL, PE_RATIO double default NULL, PFD_DVD_PAY_DT date default NULL, PFD_EQY_TO_TOT_LIAB_AND_EQY double default NULL, PFD_EXCH_SYM varchar(128) binary default NULL, PFD_EX_DVD_DT date default NULL, PFD_RST_DVD double default NULL, PFD_STOCK_TO_TOT_CAP double default NULL, PFD_TRADEMARK_NAME varchar(128) binary default NULL, PLANT_CONST_PROG_TO_TOT_ASSET double default NULL, POISON_PILL_RIGHTS char(1) binary default NULL, POLICYHOLDERS_BENEFIT double default NULL, PORT_STATS_BOND_PCT double default NULL, PORT_STATS_CASH_PCT double default NULL, PORT_STATS_OTHER_PCT double default NULL, PORT_STATS_STOCK_PCT double default NULL, POST_EURO_AMT_ISSUED double default NULL, POST_EURO_AMT_OUTSTANDING double default NULL, POST_EURO_AMT_OUTSTANDING_LAST double default NULL, POST_EURO_CALC_TYP int(11) default NULL, POST_EURO_CALC_TYP_DES varchar(128) binary default NULL, POST_EURO_CALENDAR_CODE varchar(128) binary default NULL, POST_EURO_CRNCY varchar(12) binary default NULL, POST_EURO_DAY_CNT int(11) default NULL, POST_EURO_DAY_CNT_DES varchar(128) binary default NULL, POST_EURO_ID_COMMON varchar(128) binary default NULL, POST_EURO_ID_DUTCH varchar(128) binary default NULL, POST_EURO_ID_FRENCH varchar(128) binary default NULL, POST_EURO_ID_ISIN varchar(128) binary default NULL, POST_EURO_ISSUE_TYP varchar(128) binary default NULL, POST_EURO_MIN_INCREMENT double default NULL, POST_EURO_MIN_PIECE double default NULL, POST_EURO_OPT_STRIKE_PX double default NULL, POST_EURO_PAR_AMT double default NULL, POST_EURO_RESET_IDX varchar(128) binary default NULL, POST_EURO_WRT_DIVISOR double default NULL, POST_EURO_WRT_EXR_PX double default NULL, POST_EURO_WRT_PARITY_BST double default NULL, POST_EURO_WRT_SH_PER double default NULL, POST_EURO_WRT_UNDL_CRNCY varchar(12) binary default NULL, POST_EURO_WRT_UNDL_ISIN varchar(128) binary default NULL, POST_EURO_WRT_UNDL_PX double default NULL, PREF_DVDS_OTH_DIST double default NULL, PREM_RES_TO_SHRHLDR_EQY double default NULL, PREPAY_RT_1M double default NULL, PREPAY_TYP_1M varchar(128) binary default NULL, PRETAX_INC double default NULL, PRETAX_INC_DIL_SHR double default NULL, PRETAX_INC_PER_SH double default NULL, PRETAX_INC_TO_NET_SALES double default NULL, PRETAX_INC_YR_CHNG double default NULL, PRETAX_MARGIN double default NULL, PREV_CPN_DT date default NULL, PRE_EURO_AMT_ISSUED double default NULL, PRE_EURO_AMT_OUTSTANDING double default NULL, PRE_EURO_AMT_OUTSTANDING_LAST double default NULL, PRE_EURO_CALC_TYP int(11) default NULL, PRE_EURO_CALC_TYP_DES varchar(128) binary default NULL, PRE_EURO_CALENDAR_CODE varchar(128) binary default NULL, PRE_EURO_CRNCY varchar(12) binary default NULL, PRE_EURO_DAY_CNT int(11) default NULL, PRE_EURO_DAY_CNT_DES varchar(128) binary default NULL, PRE_EURO_ID_COMMON varchar(128) binary default NULL, PRE_EURO_ID_FRENCH varchar(128) binary default NULL, PRE_EURO_ID_ISIN varchar(128) binary default NULL, PRE_EURO_ISSUE_TYP varchar(128) binary default NULL, PRE_EURO_MIN_INCREMENT double default NULL, PRE_EURO_MIN_PIECE double default NULL, PRE_EURO_OPT_STRIKE_PX double default NULL, PRE_EURO_PAR_AMT double default NULL, PRE_EURO_RESET_IDX varchar(128) binary default NULL, PRE_EURO_WRT_DIVISOR double default NULL, PRE_EURO_WRT_EXR_PX double default NULL, PRE_EURO_WRT_PARITY_BST double default NULL, PRE_EURO_WRT_SH_PER double default NULL, PRE_EURO_WRT_UNDL_CRNCY varchar(12) binary default NULL, PRE_EURO_WRT_UNDL_ISIN varchar(128) binary default NULL, PRE_EURO_WRT_UNDRL_PX double default NULL, PRE_POST_EURO_WRT_EXCH_RT double default NULL, PRE_POST_EURO_WRT_UNDL_EXCH_RT double default NULL, PROF_MARGIN double default NULL, PROSPECTUS char(1) binary default NULL, PROV_FOR_LOAN_LOSS_GROWTH double default NULL, PROV_FOR_LOAN_LOSS_TO_TOT_ASSET double default NULL, PROV_FOR_LOAN_LOSS_TO_TOT_LOAN double default NULL, PROV_FOR_LOAN_LOSS_TO_TOT_REV double default NULL, PRO_RATA_CALL char(1) binary default NULL, PRO_RATA_SINK char(1) binary default NULL, PRPL char(1) binary default NULL, PRPTY_OPER_EXP double default NULL, PRVT_PLACE char(1) binary default NULL, PUTABLE char(1) binary default NULL, PUT_DAYS_NOTICE int(11) default NULL, PUT_DISCRETE char(1) binary default NULL, PUT_EXPIRED char(1) binary default NULL, PUT_FEATURE varchar(128) binary default NULL, PUT_NOTIFICATION_MAX_DAYS int(11) default NULL, PUT_NOTIFICATION_MIN_DAYS int(11) default NULL, PX_TO_BOOK_RATIO double default NULL, PX_TO_CASH_FLOW double default NULL, PX_TO_EBITDA double default NULL, PX_TO_SALES_RATIO double default NULL, PX_TRADE_LOT_SIZE int(11) default NULL, QUICK_RATIO double default NULL, QUOTE_TYP int(11) default NULL, RD_EXPEND_TO_NET_SALES double default NULL, RD_EXPEND_YR_CHNG double default NULL, RD_TO_SALES double default NULL, REAL_ESTATE_ADD_IMPROV double default NULL, REAL_FIRST_CPN_DT date default NULL, RECONVENTION_DT date default NULL, REDEMP_CRNCY varchar(12) binary default NULL, REDEMP_VAL double default NULL, REDENOM_DT date default NULL, REDENOM_METHOD varchar(128) binary default NULL, REDENOM_PX double default NULL, REDENOM_ROUND_METHOD varchar(128) binary default NULL, REFIX_FREQ double default NULL, REFIX_FREQ_M double default NULL, REGISTERED char(1) binary default NULL, REINVEST_EARN double default NULL, REINVEST_EARN_TO_NET_SALES double default NULL, REINVEST_EARN_YR_CHNG double default NULL, REINVEST_RT double default NULL, RELATED_EQUITIES text, REL_INDEX varchar(128) binary default NULL, REL_PE_RATIO double default NULL, REMOVAL_REASON text, RENT_INC_GROWTH double default NULL, RENT_INC_TO_TOT_REV double default NULL, REPAY_RATIO double default NULL, RESET_IDX varchar(128) binary default NULL, RESTRICTED_ASSETS double default NULL, RES_MWH_GROWTH_RT double default NULL, RETAIN_EARN_TO_TOT_LIAB_AND_EQY double default NULL, RETENTION_RATIO double default NULL, RETURN_COM_EQY double default NULL, RETURN_ON_ASSET double default NULL, RETURN_ON_CAP double default NULL, RETURN_ON_WORK_CAP double default NULL, REVENUE_PER_SH double default NULL, REV_LESS_ENERGY_GROWTH_RT double default NULL, REV_TO_EQY_SEC double default NULL, REV_TO_FIX_INC_SEC double default NULL, RE_ASSET_GROWTH double default NULL, RE_ASSET_TO_TOT_LIAB double default NULL, RE_INCOME_AND_OTHER_INC_GROWTH double default NULL, RE_INC_AND_OTHER_INC_TO_TOT_REV double default NULL, RE_INVEST_PER_TOT_CAP double default NULL, RE_INVEST_TO_TOT_ASSET double default NULL, RE_INVEST_TO_TOT_INVEST double default NULL, RE_OPER_EXP_GROWTH double default NULL, RE_OPER_EXP_TO_TOT_REV double default NULL, RE_TAX_GROWTH double default NULL, RE_TAX_TO_TOT_REV double default NULL, ROA_BASED_ON_BOTTOM_EPS double default NULL, ROA_TO_ROE double default NULL, RR_DIL_EPS_CONT_OPS double default NULL, RR_DIL_EPS_CONT_OPS_GROWTH double default NULL, RSRV_FOR_LOAN_LOSS_TO_TOT_LOAN double default NULL, RTG_BB_COMP varchar(128) binary default NULL, RTG_CANADIAN varchar(128) binary default NULL, RTG_DOMINION varchar(128) binary default NULL, RTG_FITCH varchar(128) binary default NULL, RTG_FITCH_NO_WATCH varchar(128) binary default NULL, RTG_FITCH_TYP varchar(128) binary default NULL, RTG_FITCH_WATCH varchar(128) binary default NULL, RTG_FITCH_WATCH_DT date default NULL, RTG_JCR varchar(128) binary default NULL, RTG_MIKUNI varchar(128) binary default NULL, RTG_MOODY varchar(128) binary default NULL, RTG_MOODY_NO_WATCH varchar(128) binary default NULL, RTG_MOODY_TYP varchar(128) binary default NULL, RTG_MOODY_WATCH varchar(128) binary default NULL, RTG_MOODY_WATCH_DT date default NULL, RTG_RI varchar(128) binary default NULL, RTG_SP varchar(128) binary default NULL, RTG_SP_NO_WATCH varchar(128) binary default NULL, RTG_SP_TYP varchar(128) binary default NULL, RTG_SP_WATCH varchar(128) binary default NULL, RTG_SP_WATCH_DT date default NULL, SALES_GROWTH double default NULL, SALES_PER_EMPL double default NULL, SALES_REV_TURN double default NULL, SALES_TO_ACCT_RCV double default NULL, SALES_TO_ACCUM_DEPR double default NULL, SALES_TO_ACCUM_DEPR_PLANT_ASSET double default NULL, SALES_TO_CASH double default NULL, SALES_TO_COM_PLANT_IN_SERV double default NULL, SALES_TO_CUR_ASSET double default NULL, SALES_TO_DECOMM_FUND double default NULL, SALES_TO_ELECT_PLANT_IN_SERV double default NULL, SALES_TO_GAS_PLANT_IN_SERV double default NULL, SALES_TO_GROSS_FIX_ASSET double default NULL, SALES_TO_GROSS_UTIL_PLANT_SERV double default NULL, SALES_TO_INVENT double default NULL, SALES_TO_INVEST_IN_ASSOC double default NULL, SALES_TO_LT_INVEST double default NULL, SALES_TO_MKT_SEC double default NULL, SALES_TO_NET_FIX_ASSET double default NULL, SALES_TO_NET_NUCLR_FUEL double default NULL, SALES_TO_NET_OTHER_PRPTY double default NULL, SALES_TO_NET_PLANT_IN_SERV double default NULL, SALES_TO_OTHER_ASSET double default NULL, SALES_TO_OTHER_CUR_ASSET double default NULL, SALES_TO_PLANT_CONST_IN_PROG double default NULL, SALES_TO_TOT_ASSET double default NULL, SALES_TO_TOT_UTIL_PLANT double default NULL, SALES_TO_WATER_PLANT_IN_SERV double default NULL, SEASONED char(1) binary default NULL, SEASONING_STATUS varchar(128) binary default NULL, SECOND_CALL_DT date default NULL, SECOND_CALL_PX double default NULL, SECOND_CPN_DT date default NULL, SECURITY_DES varchar(128) binary default NULL, SECURITY_TYP varchar(128) binary default NULL, SECURITY_TYP2 varchar(128) binary default NULL, SEC_RESTRICT int(11) default NULL, SELL_AND_ADMIN_EXP_TO_NET_SALES double default NULL, SELL_AND_ADMIN_EXP_YR_CHNG double default NULL, SERIES varchar(128) binary default NULL, SETTLE_DT date default NULL, SHORT_AND_LONG_TERM_DEBT double default NULL, SHORT_NAME varchar(128) binary default NULL, SHRHLDR_EQY_TO_TOT_LIAB_AND_EQY double default NULL, SH_CAP_APIC_TO_TOT_LIAB_EQY double default NULL, SINKABLE char(1) binary default NULL, SINKABLE_PAR_MARKET varchar(128) binary default NULL, SINK_EXPIRED char(1) binary default NULL, SINK_FREQ int(11) default NULL, SINK_TYP varchar(128) binary default NULL, SINK_VOLUNTARY double default NULL, SOFT_CALL_BASIS int(11) default NULL, SOFT_CALL_DAYS int(11) default NULL, SOFT_CALL_END char(1) binary default NULL, SOFT_CALL_OUT_OF int(11) default NULL, SOFT_CALL_OUT_OF_DAY_TYP varchar(128) binary default NULL, SOFT_CALL_PARITY char(1) binary default NULL, SOFT_CALL_QUOTE_TYP varchar(128) binary default NULL, SOFT_CALL_TRIGGER double default NULL, SOFT_CALL_TYP varchar(128) binary default NULL, SPREAD_TO_TSY_ISSUE double default NULL, SP_EFF_DT date default NULL, STATE_CODE varchar(128) binary default NULL, STEPUP_CPN double default NULL, STEPUP_DT date default NULL, STRUCTURED_NOTE char(1) binary default NULL, ST_BORROW_TO_TOT_LIAB_AND_EQY double default NULL, ST_INVEST_TO_TOT_INVEST double default NULL, ST_LIAB_TO_TOT_LIAB_AND_EQY double default NULL, SURETY_BOND_CITY varchar(128) binary default NULL, SURETY_BOND_PROVIDER varchar(128) binary default NULL, SURETY_BOND_STATE varchar(128) binary default NULL, SUSTAIN_GROWTH_RT double default NULL, SVNG_DPST_TO_TOT_LIAB_AND_EQY double default NULL, T12M_DIL_EPS_BEF_XO double default NULL, T12M_DIL_EPS_CONT_OPS double default NULL, T12_EPS_CONT_OPS double default NULL, TANGIBLE_BOOK_VALUE double default NULL, TANGIBLE_FIXED_ASSETS double default NULL, TANG_BOOK_VAL_PER_SH double default NULL, TAX_BURDEN double default NULL, TAX_CHANGES_CALL char(1) binary default NULL, TENDER_AGENT varchar(128) binary default NULL, TICKER varchar(22) binary default NULL, TIME_DPST_TO_TOT_LIAB_AND_EQY double default NULL, TOP_SHAREHOLDER_NAME varchar(128) binary default NULL, TOP_SHAREHOLDER_NUM_SH double default NULL, TOP_SHAREHOLDER_PERCENT_SH double default NULL, TOTAL_DEBT_TO_EV double default NULL, TOTAL_ELEC_REV double default NULL, TOTAL_FINANCED double default NULL, TOTAL_KWH double default NULL, TOT_ANALYST_REC double default NULL, TOT_ASSET_TO_TOT_ASSET double default NULL, TOT_BUY_REC double default NULL, TOT_CAP_EXPEND_GROWTH double default NULL, TOT_CAP_EXPEND_GROWTH_REITS double default NULL, TOT_CAP_TO_LIAB_AND_EQY double default NULL, TOT_CASH_PFD_DVD_TO_NET_SALES double default NULL, TOT_CASH_PFD_DVD_YR_CHNG double default NULL, TOT_COMMON_EQY double default NULL, TOT_COM_DVD_TO_NET_SALES double default NULL, TOT_COM_DVD_YR_CHNG double default NULL, TOT_COM_EQY_TO_TOT_LIAB_AND_EQY double default NULL, TOT_DEBT_TO_COM_EQY double default NULL, TOT_DEBT_TO_EBITDA double default NULL, TOT_DEBT_TO_INTERNAL_FUND double default NULL, TOT_DEBT_TO_TOT_ASSET double default NULL, TOT_DEBT_TO_TOT_CAP double default NULL, TOT_DPST_TO_TOT_CAP double default NULL, TOT_DPST_TO_TOT_LIAB_AND_EQY double default NULL, TOT_EXP_TO_AVG_ASSET double default NULL, TOT_EXP_TO_AVG_EARN_ASSET double default NULL, TOT_GAS_REV double default NULL, TOT_HOLD_REC double default NULL, TOT_INS_RES_TO_SHRHLDR_EQY double default NULL, TOT_INS_RES_TO_TOT_ASSET double default NULL, TOT_INS_RES_TO_TOT_CAP double default NULL, TOT_INT_EXP double default NULL, TOT_INVEST_TO_TOT_ASSET double default NULL, TOT_INVEST_TO_TOT_LIAB double default NULL, TOT_LIAB_AND_EQY double default NULL, TOT_LIAB_EQY_TO_TOT_LIAB_AND_EQY double default NULL, TOT_LIAB_PER_COM_EQY double default NULL, TOT_LIAB_PER_SH double default NULL, TOT_LIAB_TO_TOT_LIAB_AND_EQY double default NULL, TOT_LOAN_TO_TOT_ASSET double default NULL, TOT_LOAN_TO_TOT_CAP double default NULL, TOT_LOAN_TO_TOT_DPST double default NULL, TOT_MKT_VAL double default NULL, TOT_MKT_VAL_TO_EBITDA double default NULL, TOT_MTG_TO_NOTE double default NULL, TOT_MWH_YR_CHNG double default NULL, TOT_OPER_EXP_GROWTH_RT double default NULL, TOT_PREF_DVD_GROWTH double default NULL, TOT_RETAIL_MWH_GROWTH_RT double default NULL, TOT_REV_TO_ALLOW_FOR_LOAN_LOSS double default NULL, TOT_REV_TO_COMM_LOAN double default NULL, TOT_REV_TO_CONS_LOAN double default NULL, TOT_REV_TO_CUST_ACCPT_LIAB double default NULL, TOT_REV_TO_INTERBANK_ASSET double default NULL, TOT_REV_TO_MTG_TO_NOTE_INVEST double default NULL, TOT_REV_TO_NET_LOAN double default NULL, TOT_REV_TO_OTHER_LOAN double default NULL, TOT_REV_TO_OTHER_LT_INVEST double default NULL, TOT_REV_TO_RE_INVEST double default NULL, TOT_REV_TO_TOT_LOAN double default NULL, TOT_SELL_REC double default NULL, TOT_SHRHLDR_EQY double default NULL, TOT_THERM_DELIVERY double default NULL, TOT_THERM_YR_CHNG double default NULL, TOT_UTIL_PLANT_TOT_TOT_ASSET double default NULL, TRADE_ACCT_PL_TO_TOT_REV double default NULL, TRADE_ACCT_PL_YR_CHNG double default NULL, TRADE_CRNCY varchar(12) binary default NULL, TRADE_PROF_TO_TOT_REV double default NULL, TRADE_STATUS char(1) binary default NULL, TRAIL_12M_AMORT_AND_DEPR double default NULL, TRAIL_12M_CAP_EXPEND double default NULL, TRAIL_12M_CASH_FLOW_NET_INC double default NULL, TRAIL_12M_CASH_FLOW_PER_SH double default NULL, TRAIL_12M_CASH_FROM_OPER double default NULL, TRAIL_12M_CHNG_IN_WORK_CAP double default NULL, TRAIL_12M_COGS double default NULL, TRAIL_12M_COMM_AND_FEE_EARN double default NULL, TRAIL_12M_COMM_AND_FEE_PAID double default NULL, TRAIL_12M_COM_DVD double default NULL, TRAIL_12M_DVD_PER_SH double default NULL, TRAIL_12M_EBITDA double default NULL, TRAIL_12M_EPS double default NULL, TRAIL_12M_EPS_AFTER_XO double default NULL, TRAIL_12M_EPS_BEF_XO_ITEM double default NULL, TRAIL_12M_FOREIGN_EXCH double default NULL, TRAIL_12M_FREE_CASH_FLOW double default NULL, TRAIL_12M_FREE_CASH_FLOW_PER_SH double default NULL, TRAIL_12M_FULLY_DILUTED_EPS double default NULL, TRAIL_12M_GROSS_MARGIN double default NULL, TRAIL_12M_INC_BEF_XO_ITEM double default NULL, TRAIL_12M_INC_TAX_EXP double default NULL, TRAIL_12M_INT_EXP double default NULL, TRAIL_12M_INT_EXP_BNK double default NULL, TRAIL_12M_INT_INC double default NULL, TRAIL_12M_INVEST_INC double default NULL, TRAIL_12M_MINORITY_INT double default NULL, TRAIL_12M_NET_INC double default NULL, TRAIL_12M_NET_SALES double default NULL, TRAIL_12M_OPER_INC double default NULL, TRAIL_12M_OPER_MARGIN double default NULL, TRAIL_12M_OTHER_NON_CASH_ADJ double default NULL, TRAIL_12M_OTHER_NON_OPER_LOSS double default NULL, TRAIL_12M_OTHER_OPER_INC double default NULL, TRAIL_12M_PFD_DVD double default NULL, TRAIL_12M_PROF_MARGIN double default NULL, TRAIL_12M_PROV_FOR_LOAN_LOSS double default NULL, TRAIL_12M_RES_CHRG double default NULL, TRAIL_12M_SALES_PER_SH double default NULL, TRAIL_12M_SGA double default NULL, TRAIL_12M_SPECIAL_EPS double default NULL, TRAIL_12M_TAX_EFF_ON_XO_ITEM double default NULL, TRAIL_12M_TRADE_ACCT_PROF double default NULL, TRAIL_12M_XO_LOSS_BEF_TAX double default NULL, TRANSFER_AGENT text, UNDERWRITER_CITY varchar(128) binary default NULL, UNDERWRITER_STATE varchar(128) binary default NULL, UNDW_COSTS double default NULL, UNDW_COST_GROWTH double default NULL, UNDW_COST_TO_TOT_REV double default NULL, UNIT_EXPIRE_DT date default NULL, UNRLZD_GAIN_AND_LOSS double default NULL, VAR_ADJ_DAY varchar(128) binary default NULL, VAR_RATE_DEBT_PER_TOT_DEBT double default NULL, VERBAL_AWARD_DT date default NULL, VOTING_RIGHTS double default NULL, VOTING_RIGHTS_DES varchar(128) binary default NULL, WATER_PLANT_IN_SERV_TO_TOT_ASSET double default NULL, WHEN_ISSUED char(1) binary default NULL, WHICH_JAPANESE_SECTION varchar(128) binary default NULL, WITHHOLDING_TAX double default NULL, WITHHOLDING_TAX_EXEMPT varchar(128) binary default NULL, WORKING_CAPITAL double default NULL, WORK_CAP_GROWTH double default NULL, WRT_COVERED varchar(128) binary default NULL, WRT_CRNCY varchar(12) binary default NULL, WRT_EQY_PRIM_EXCH varchar(128) binary default NULL, WRT_EXER_DT date default NULL, WRT_EXER_PX double default NULL, WRT_EXER_TYP varchar(128) binary default NULL, WRT_EXPIRE_DT date default NULL, WRT_ISSUE_AMT int(11) default NULL, WRT_ISSUE_DT date default NULL, WRT_ISSUE_PRC double default NULL, WRT_MIN_EXER int(11) default NULL, WRT_NAME varchar(128) binary default NULL, WRT_PUT_OR_CALL varchar(128) binary default NULL, WRT_SETTLE_TYP varchar(128) binary default NULL, WRT_SH_PER double default NULL, WRT_TICKER varchar(22) binary default NULL, WRT_UNDL_CRNCY varchar(12) binary default NULL, WRT_UNDL_CUSIP varchar(18) binary default NULL, WRT_UNDL_ISIN varchar(128) binary default NULL, WRT_UNDL_TYP varchar(128) binary default NULL, XO_GL_NET_OF_TAX double default NULL, XO_GL_NET_OF_TAX_GROWTH double default NULL, XO_GL_NET_OF_TAX_TO_NET_SALES double default NULL, XO_GL_NET_OF_TAX_TO_TOT_REV double default NULL, XO_LOSS_NET_OF_TAX_GROWTH double default NULL, XO_LOSS_PRETAX_YR_CHNG double default NULL, YLD_FLAG varchar(128) binary default NULL, ZERO_CPN char(1) binary default NULL, PRIMARY KEY(PARSEKEY_UNIQUE) ) TYPE=MyISAM;