FILE NAME,FILE FIELD NAME,DATATYPE,START,LENGTH,DECIMAL,CERCLIS TABLE NAME,CERCLIS ELEMENT NAME action,site_id,character,1,7,,action,site_id action,rat_code,character,8,2,,action,rat_code action,act_code,character,10,3,,action,act_code_id action,act_st_dt,character(date:yyyymmdd),13,8,,action,act_actl_strt_date action,act_cm_dt,character(date:yyyymmdd),21,8,,action,act_actl_cmpltn_date action,ou_id,character,29,2,,action,ou_id action,qual_code,character,31,2,,action,raq_action_qual_code action,ralt_code,character,33,2,,action,ralt_code action,rps_code,character,35,2,,action,rps_code action,crit_code,character,37,1,,action,ract_critical_flag_code action,raa_code,character,38,2,,action,raa_code ,,,,,,, brac,sbt_seq_id,number,1,20,,site_brac_types,sbt_seq_id brac,site_id,character,21,7,,site_brac_types,site_id brac,rbrac_code,character,28,1,,site_brac_types,rbrac_code ,,,,,,, cm_site,site_id,character,1,7,,cmt_site,site_id cm_site,rcst_code,character,8,2,,cmt_site,rcst_code cm_site,csite_seq,number,10,20,,cmt_site,csite_seq_nmbr cm_site,text1,character,30,250,,cmt_site,csite_text cm_site,text2,character,280,250,,cmt_site,csite_text cm_site,text3,character,530,250,,cmt_site,csite_text cm_site,text4,character,780,250,,cmt_site,csite_text cm_site,text5,character,1030,250,,cmt_site,csite_text cm_site,text6,character,1280,250,,cmt_site,csite_text cm_site,text7,character,1530,250,,cmt_site,csite_text cm_site,text8,character,1780,250,,cmt_site,csite_text ,,,,,,, cons_cnt,rhs_seq_id,number,1,20,,constituent_contaminant,rhs_seq_id cons_cnt,site_id,character,21,7,,constituent_contaminant,site_id cons_cnt,wsmc_nmbr,number,28,20,,constituent_contaminant,wsmc_nmbr cons_cnt,coc_flag,character,48,1,,constituent_contaminant,cc_cont_of_cncrn_flag cons_cnt,mx_conc_vl,number,49,20,7,constituent_contaminant,cc_max_conc_value_nmbr cons_cnt,mn_conc_vl,number,69,20,7,constituent_contaminant,cc_min_conc_value_nmbr cons_cnt,conc_un_cd,character,89,2,,constituent_contaminant,rconc_units_code ,,,,,,, contact,site_id,character,1,7,,site_contact,site_id contact,cont_sq_id,number,8,20,,site_contact,site_cont_seq_id contact,person_id,number,28,20,,site_contact,person_id contact,rrole_code,character,48,5,,site_contact,rrole_code ,,,,,,, csit_al,site_id,character,1,7,,cmt_site_alias,site_id csit_al,alias_id,number,8,20,,cmt_site_alias,site_alias_id csit_al,csa_seq_no,number,28,20,,cmt_site_alias,csa_seq_nmbr csit_al,text1,character,48,250,,cmt_site_alias,csa_text csit_al,text2,character,298,250,,cmt_site_alias,csa_text csit_al,text3,character,548,250,,cmt_site_alias,csa_text csit_al,text4,character,798,250,,cmt_site_alias,csa_text csit_al,text5,character,1048,250,,cmt_site_alias,csa_text csit_al,text6,character,1298,250,,cmt_site_alias,csa_text csit_al,text7,character,1548,250,,cmt_site_alias,csa_text csit_al,text8,character,1798,250,,cmt_site_alias,csa_text ,,,,,,, ei_clnup,site_id,character,1,7,,ei_cleanup,site_id ei_clnup,ec_seq_id,number,8,20,,ei_cleanup,ec_seq_id ei_clnup,rat_code,character,28,2,,ei_cleanup,rat_code ei_clnup,act_code,character,30,3,,ei_cleanup,act_code_id ei_clnup,wsmc_nmbr,number,33,20,,ei_cleanup,wsmc_nmbr ei_clnup,ec_std_amt,number,53,20,,ei_cleanup,ec_standard_amount ei_clnup,std_un_cd,character,73,4,,ei_cleanup,rsvuc_standard_unit_code ei_clnup,ec_nfd_flg,character,77,1,,ei_cleanup,ec_no_further_data_flag ,,,,,,, fed_reg,site_id,character,1,7,,federal_register,site_id fed_reg,rfra_code,character,8,1,,federal_register,rfra_code fed_reg,fr_date,character(date:yyyymmdd),9,8,,federal_register,fr_date fed_reg,fr_vol,character,17,3,,federal_register,fr_vol fed_reg,fr_pg_num,character,20,5,,federal_register,fr_page_nmbr fed_reg,fr_act_nm,character,25,50,,federal_register,fr_action_name fed_reg,fr_hrs_scr,number,75,20,2,federal_register,fr_hrs_score_nmbr fed_reg,fr_npl_uno,character,95,2,,federal_register,fr_npl_update_nmbr ,,,,,,, fin_tra,rftt_code,character,1,1,,financial_transaction,rftt_code fin_tra,site_id,character,2,7,,financial_transaction,site_id fin_tra,rat_code,character,9,2,,financial_transaction,rat_code fin_tra,act_code,character,11,3,,financial_transaction,act_code_id fin_tra,ft_id,character,14,4,,financial_transaction,ft_id fin_tra,ft_ifms_fl,character,18,1,,financial_transaction,ft_ifms_flag fin_tra,ft_date,character(date:yyyymmdd),19,8,,financial_transaction,ft_date fin_tra,ft_amt,number,27,20,,financial_transaction,ft_amt fin_tra,ft_fy,character,47,4,,financial_transaction,ft_fy fin_tra,ft_bug_fy,character,51,4,,financial_transaction,ft_budget_fy fin_tra,rfbs_code,character,55,1,,financial_transaction,rfbs_code ,,,,,,, op_unit,site_id,character,1,7,,operable_unit,site_id op_unit,ou_id,character,8,2,,operable_unit,ou_id op_unit,ou_name,character,10,30,,operable_unit,ou_name ,,,,,,, person,person_id,number,1,20,,person,person_id person,first_name,character,21,26,,person,person_first_name person,last_name,character,47,26,,person,person_last_name person,phone_nmbr,character,73,10,,person,person_phone_nmbr1 person,net_adrs1,character,83,128,,person,person_internet_adrs person,net_adrs2,character,211,128,,person,person_internet_adrs ,,,,,,, point,site_id,character,1,7,,point,site_id point,pnt_seq_id,number,8,20,,point,pnt_seq_id point,pnt_dc_lat,character,28,10,,point,pnt_dec_lat point,pnt_dc_lng,character,38,11,,point,pnt_dec_long ,,,,,,, ract_ano,raa_code,character,1,2,,ref_action_anomaly,raa_code ract_ano,raa_desc,character,3,40,,ref_action_anomaly,raa_desc ,,,,,,, ract_cri,crit_code,character,1,1,,ref_action_critical_flag,ract_critical_flag_code ract_cri,crit_desc,character,2,20,,ref_action_critical_flag,ract_critical_flag_desc ,,,,,,, ract_lea,ralt_code,character,1,2,,ref_action_lead_type,ralt_code ract_lea,ralt_desc,character,3,50,,ref_action_lead_type,ralt_desc ,,,,,,, ract_qua,qual_code,character,1,2,,ref_action_qualifier,raq_action_qual_code ract_qua,qual_desc,character,3,75,,ref_action_qualifier,raq_action_qual_desc ,,,,,,, ract_typ,rat_code,character,1,2,,ref_action_type,rat_code ract_typ,rat_name,character,3,100,,ref_action_type,rat_name ract_typ,his_flag,character,103,1,,ref_action_type,rat_historical_only_flag ract_typ,nsi_indctr,character,104,1,,ref_action_type,rat_nsi_indicator ract_typ,rat_level,character,105,1,,ref_action_type,rat_level ract_typ,rie_code,character,106,1,,ref_action_type,rie_code ract_typ,def1,character,107,250,,ref_action_type,rat_def ract_typ,def2,character,357,250,,ref_action_type,rat_def ract_typ,def3,character,607,250,,ref_action_type,rat_def ract_typ,def4,character,857,250,,ref_action_type,rat_def ract_typ,def5,character,1107,250,,ref_action_type,rat_def ract_typ,def6,character,1357,250,,ref_action_type,rat_def ract_typ,def7,character,1607,250,,ref_action_type,rat_def ract_typ,def8,character,1857,250,,ref_action_type,rat_def ract_typ,def_ou,character,2107,2,,ref_action_type,rat_def_ou ract_typ,rfbs_code,character,2109,1,,ref_action_type,rfbs_code ,,,,,,, ract_typ,spa_code,character,2110,2,,ref_action_type,spa_code rbrac,rbrac_code,character,1,1,,ref_brac,rbrac_code rbrac,rbrac_desc,character,2,8,,ref_brac,rbrac_desc ,,,,,,, rcmt_sit,rcst_code,character,1,2,,ref_cmt_site,rcst_code rcmt_sit,rcst_desc,character,3,50,,ref_cmt_site,rcs_desc ,,,,,,, rconc_un,conc_un_cd,character,1,2,,ref_concentration_units,rconc_units_code rconc_un,conc_un_ds,character,3,50,,ref_concentration_units,rconc_units_desc ,,,,,,, rcont_gp,rcg_code,character,1,2,,ref_contaminant_group,rcg_code rcont_gp,rcg_name,character,3,80,,ref_contaminant_group,rcg_name ,,,,,,, rdimunit,dim_un_cd,character,1,4,,ref_dimension_unit,rdmnsn_unit_code rdimunit,dim_un_ds,character,5,50,,ref_dimension_unit,rdmnsn_unit_desc ,,,,,,, rfbs,rfbs_code,character,1,1,,ref_financial_budget_source,rfbs_code rfbs,rfbs_desc,character,2,80,,ref_financial_budget_source,rfbs_desc ,,,,,,, rfed_fac,fclty_code,character,1,1,,ref_federal_facility,rfed_fclty_code rfed_fac,fclty_desc,character,2,22,,ref_federal_facility,rfed_fclty_desc rfed_rgs,rfra_code,character,1,1,,ref_fdrl_rgstr_actn,rfra_code rfed_rgs,rfra_desc,character,2,50,,ref_fdrl_rgstr_actn,rfra_desc ,,,,,,, rfin_typ,rftt_code,character,1,1,,ref_financial_transaction_type,rftt_code rfin_typ,long_name,character,2,50,,ref_financial_transaction_type,rftt_long_name rfin_typ,ftt_pl_act,character,52,1,,ref_financial_transaction_type,rftt_plan_act rfin_typ,rftt_desc,character,53,250,,ref_financial_transaction_type,rftt_desc ,,,,,,, rhaz_sub,rhs_seq_id,number,1,20,,ref_hazardous_substance,rhs_seq_id rhaz_sub,rhs_nmbr,character,21,15,,ref_hazardous_substance,rhs_nmbr rhaz_sub,rhs_name1,character,36,250,,ref_hazardous_substance,rhs_name rhaz_sub,rhs_name2,character,286,250,,ref_hazardous_substance,rhs_name rhaz_sub,rhs_name3,character,536,250,,ref_hazardous_substance,rhs_name rhaz_sub,rhs_name4,character,786,250,,ref_hazardous_substance,rhs_name rhaz_sub,rhs_name5,character,1036,250,,ref_hazardous_substance,rhs_name rhaz_sub,rhs_name6,character,1286,250,,ref_hazardous_substance,rhs_name rhaz_sub,rhs_name7,character,1536,250,,ref_hazardous_substance,rhs_name rhaz_sub,rhs_name8,character,1786,250,,ref_hazardous_substance,rhs_name rhaz_sub,rcg_code,character,2036,2,,ref_hazardous_substance,rcg_code rhaz_sub,rhs_ag_cd,character,2038,50,,ref_hazardous_substance,rhs_naming_agency_code ,,,,,,, rifms,rie_code,character,1,1,,ref_ifms_entry,rie_code rifms,rie_desc,character,2,50,,ref_ifms_entry,rie_desc ,,,,,,, rmd_resp,site_id,character,1,7,,remedial_response,site_id rmd_resp,resp_id,number,8,20,,remedial_response,rmdlr_resp_id rmd_resp,rrtg_code,character,28,2,,remedial_response,rrtg_code rmd_resp,r_rtt_code,character,30,4,,remedial_response,r_rtt_code rmd_resp,rmed_code,character,34,2,,remedial_response,rmedia_code rmd_resp,act_code,character,36,3,,remedial_response,act_code_id rmd_resp,rat_code,character,39,2,,remedial_response,rat_code ,,,,,,, rmedia,rmed_code,character,1,2,,ref_media,rmedia_code rmedia,rmed_desc,character,3,80,,ref_media,rmedia_desc ,,,,,,, rmv_resp,site_id,character,1,7,,removal_response,site_id rmv_resp,resp_id,number,8,20,,removal_response,rmdlr_resp_id rmv_resp,rrtg_code,character,28,2,,removal_response,rrtg_code rmv_resp,r_rtt_code,character,30,4,,removal_response,r_rtt_code rmv_resp,rmed_code,character,34,2,,removal_response,rmedia_code rmv_resp,act_code,character,36,3,,removal_response,act_code_id rmv_resp,rat_code,character,39,2,,removal_response,rat_code ,,,,,,, rnon_npl,non_npl_cd,character,1,2,,ref_non_npl_status,rnon_npl_status_code rnon_npl,non_npl_ds,character,3,80,,ref_non_npl_status,rnon_npl_status_desc ,,,,,,, rnpl_sta,npl_cd,character,1,1,,ref_npl_status,rnpl_status_code rnpl_sta,npl_ds,character,2,50,,ref_npl_status,rnpl_status_desc rpla_sta,rps_code,character,1,2,,ref_planning_status,rps_code rpla_sta,rps_desc,character,3,80,,ref_planning_status,rps_desc ,,,,,,, rprog_pri,rppt_code,character,1,2,,ref_program_priority_type,rppt_code rprog_pri,rppt_desc,character,3,50,,ref_program_priority_type,rppt_desc ,,,,,,, rregion,region_cd,character,1,2,,ref_region,rregion_code rregion,region_ds,character,3,80,,ref_region,rregion_desc ,,,,,,, rrespfed,resp_fa_cd,character,1,4,,ref_resp_fed_agncy,rresp_fed_agncy_code rrespfed,resp_fa_ds,character,5,75,,ref_resp_fed_agncy,rresp_fed_agncy_desc ,,,,,,, rrole,rrole_code,character,1,5,,ref_role,rrole_code rrole,rrole_desc,character,6,80,,ref_role,rrole_desc ,,,,,,, rrsp_tec,rrtg_code,character,1,2,,ref_response_technology_type,rrtg_code rrsp_tec,rmed_code,character,3,2,,ref_response_technology_type,rmedia_code rrsp_tec,r_rtt_code,character,5,4,,ref_response_technology_type,r_rtt_code rrsp_tec,r_rtt_name,character,9,80,,ref_response_technology_type,r_rtt_name rrsp_tec,r_rtt_torc,character,89,1,,ref_response_technology_type,r_rtt_torc rrsp_tec,r_rtt_def1,character,90,250,,ref_response_technology_type,r_rtt_definition rrsp_tec,r_rtt_def2,character,340,250,,ref_response_technology_type,r_rtt_definition ,,,,,,, rrtgrp,rrtg_code,character,1,2,,ref_response_type_group,rrtg_code rrtgrp,rrtg_desc,character,3,80,,ref_response_type_group,rrtg_desc ,,,,,,, rsatype,rsat_code,character,1,2,,ref_site_alias_type,rsat_code rsatype,rsat_desc,character,3,40,,ref_site_alias_type,rsat_desc ,,,,,,, rsit_cat,scat_cd,character,1,2,,ref_site_category,resc_category_code rsit_cat,scat_ds,character,3,80,,ref_site_category,resc_category_desc rsit_set,sit_set_cd,character,1,2,,ref_site_setting,rsite_setting_code rsit_set,sit_set_ds,character,3,50,,ref_site_setting,rsite_setting_desc ,,,,,,, rsit_typ,rst_code,character,1,2,,ref_site_type,rsit_code rsit_typ,rst_desc,character,3,50,,ref_site_type,rsit_desc ,,,,,,, rsitsubc,subc_cd,character,1,2,,ref_site_sub_category,rssc_sub_category_desc rsitsubc,subc_ds,character,3,100,,ref_site_sub_category,rssc_sub_category_code ,,,,,,, rsparea,spa_code,character,1,2,,ref_superfund_program_area,spa_code rsparea,spa_name,character,3,50,,ref_superfund_program_area,spa_name ,,,,,,, rstate,state_code,character,1,2,,ref_state,rstate_code rstate,state_nm,character,3,40,,ref_state,rstate_name rstate,nav_nat_fl,character,43,1,,ref_state,rs_navajo_nation_flag ,,,,,,, rstincat,rsitinc_cd,character,1,1,,ref_site_incident_category,rsitinc_code rstincat,rsitinc_ds,character,2,50,,ref_site_incident_category,rsitinc_desc ,,,,,,, rvolunit,vol_un_cd,character,1,4,,ref_volume_unit ,rvolume_unit_code rvolunit,vol_un_ds,character,5,50,,ref_volume_unit ,rvolume_unit_desc ,,,,,,, sit_prog,site_id,character,1,7,,site_program_priority_init,site_id sit_prog,rppt_code,character,8,2,,site_program_priority_init,rppt_code sit_subc,site_id,character,1,7,,site_type_sub_category ,rssc_sub_category_code sit_subc,scat_cd,character,8,2,,site_type_sub_category,site_id sit_subc,subc_cd,character,10,2,,site_type_sub_category ,resc_category_code sit_subc,oth_sb_txt,character,12,40,,site_type_sub_category ,stsc_other_sub_text sit_subc,stsc_p_fl,character,52,1,,site_type_sub_category ,stsc_primary_flag ,,,,,,, sit_typc,site_id,character,1,7,,site_type_category ,resc_category_code sit_typc,scat_cd,character,8,2,,site_type_category,site_id sit_typc,prim_flg,character,10,1,,site_type_category ,stc_primary_flag ,,,,,,, site,site_id,character,1,7,,site,site_id site,epa_id,character,8,12,,site,site_epa_id site,short_nm,character,20,25,,site,site_short_name site,site_name,character,45,80,,site,site_name site,strt_adrs1,character,125,40,,site,site_strt_adrs1 site,strt_adrs2,character,165,40,,site,site_strt_adrs2 site,city,character,205,25,,site,site_city_name site,zip,character,230,10,,site,site_zip_code site,cnty_name,character,240,40,,site,site_cnty_name site,cng_dstrct,character,280,59,,site,site_cngrsnl_dstrct_code site,dmnsn_nm,number,339,20,2,site,site_dmnsn_nmbr site,orphn_fl,character,359,1,,site,site_orphn_flag site,rcra_id,character,360,12,,site,site_rcra_id site,ssid_code,character,372,4,,site,site_ifms_ssid_code site,usgs_q_ds,character,376,40,,site,site_usgs_qdrngl_desc site,hydro_unit,character,416,8,,site,site_usgs_hydro_unit_nmbr site,int_prg_in,character,424,1,,site,site_init_by_prog_ind site,nfrap_flag,character,425,3,,site,site_nfrap_flag site,smsa_nmbr,character,428,4,,site,site_smsa_nmbr site,parent_id,character,432,7,,site,site_parent_id site,rst_code,character,439,2,,site,rst_code site,region_cd,character,441,2,,site,rregion_code site,state_code,character,443,2,,site,rstate_code site,rsitinc_cd,character,445,1,,site,rsitinc_code site,sit_set_cd,character,446,2,,site,rsite_setting_code site,npl_cd,character,448,1,,site,rnpl_status_code site,dim_un_cd,character,449,4,,site,rdmnsn_unit_code site,rbrac_code,character,453,1,,site,rbrac_code site,fclty_code,character,454,1,,site,rfed_fclty_code site,resp_fa_cd,character,455,4,,site,rresp_fed_agncy_code site,non_npl_cd,character,459,2,,site,rnon_npl_status_code site,nnpl_st_dt,character(date:yyyymmdd),461,8,,site,non_npl_status_date site,fips_code,character,469,5,,site,site_fips_code site,cc_con_dt,character(date:yyyymmdd),474,8,,site,site_cc_concurrence_date site,cc_con_fy,character,482,4,,site,site_cc_concurrence_fy site,sa_epa_id,character,486,12,,site,site_alias_epa_id site,fuds_flag,character,498,1,,site,site_fuds_flag ,,,,,,, site_ali,site_id,character,1,7,,site_alias,site_id site_ali,alias_id,number,8,20,,site_alias,site_alias_id site_ali,sa_name,character,28,80,,site_alias,sa_name site_ali,alias_city,character,108,40,,site_alias,site_alias_city_name site_ali,alias_strt,character,148,40,,site_alias,site_alias_strt_adrs site_ali,alias_zip,character,188,10,,site_alias,site_alias_zip_code site_ali,state_code,character,198,2,,site_alias,rstate_code site_ali,sa_npl_flg,character,200,1,,site_alias,site_alias_npl_listing_flag site_ali,sa_cnty,character,201,40,,site_alias,site_alias_cnty_name site_ali,sa_fips,character,241,5,,site_alias,site_alias_fips_code site_ali,sa_cngdscd,character,246,59,,site_alias,site_alias_cngrsnl_dstrct_code site_ali,rsat_code,character,305,2,,site_alias,rsat_code ,,,,,,, wa_src,site_id,character,1,7,,waste_src_media_contaminated,site_id wa_src,wsmc_nmbr,number,8,20,,waste_src_media_contaminated,wsmc_nmbr wa_src,act_code,character,28,3,,waste_src_media_contaminated,act_code_id wa_src,rat_code,character,31,2,,waste_src_media_contaminated,rat_code wa_src,wsmc_name,character,33,100,,waste_src_media_contaminated,wsmc_name wa_src,vol_high,number,133,20,2,waste_src_media_contaminated,wsmc_vol_high wa_src,vol_low,number,153,20,2,waste_src_media_contaminated,wsmc_vol_low wa_src,vol_un_cd,character,173,4,,waste_src_media_contaminated,rvolume_unit_code wa_src,rmed_code,character,177,2,,waste_src_media_contaminated,rmedia_code