CERCLIS and Archived Sites Record Layout

Please note that cm_site, csit_al, point, and rcmt_sit data files are not included for archived sites.

File Name
action brac cm_site const_cnt contact csit_al ei_clnup fed_reg fin_tra op_unit person	point ract_ano ract_cri ract_lea ract_qua ract_typ rbrac rcmt_sit rconc_un rcont_gp rdimunit	rfbs rfed_fac rfed_rgs rfin_typ rhaz_sub rifms rmd_resp rmedia rmv_resp rnon_npl rnpl_sta	rpla_sta rprog_pri rregion rrespfed rrole rrsp_tec rrtgrp rsatype rsit_cat rsit_set rsit_typ	rsitsubc rsparea rstate rstincat rvolunit sit_prog sit_subc sit_typc site site_ali wa_src

File Name: action
Table Name: action
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
SITE_ID: SITE_ID	character	1		7
RAT_CODE: RAT_CODE	character	8		2
ACT_CODE_ID: ACT_CODE	character	10		3
ACT_ACTL_STRT_DATE: ACT_ST_DT	character(date:yyyymmdd)	13		8
ACT_ACTL_CMPLTN_DATE: ACT_CM_DT	character(date:yyyymmdd)	21		8
OU_ID: OU_ID	character	29		2
RAQ_ACTION_QUAL_CODE: QUAL_CODE	character	31		2
RALT_CODE: RALT_CODE	character	33		2
RPS_CODE: RPS_CODE	character	35		2
RACT_CRITICAL_FLAG_CODE: CRIT_CODE	character	37		1
RAA_CODE: RAA_CODE	character	38		2
Total Length:				39

Top of Page

File Name: brac
Table Name: site_brac_types
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
SBT_SEQ_ID: SBT_SEQ_ID	number	1		20
SITE_ID: SITE_ID	character	21		7
RBRAC_CODE: RBRAC_CODE	character	28		1
Total Length:				28

Top of Page

File Name: cm_site
Table Name: cmt_site
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
SITE_ID: SITE_ID	character	1		7
RCST_CODE: RCST_CODE	character	8		2
CSITE_SEQ_NMBR: CSITE_SEQ	number	10		20
CSITE_TEXT: TEXT1 TEXT2 TEXT3 TEXT4 TEXT5 TEXT6 TEXT7 TEXT8	character character character character character character character character	30 280 530 780 1,030 1,280 1,530 1,780		250 250 250 250 250 250 250 250
Total Length:				2,029

Top of Page

File Name: const_cnt
Table Name: constituent_contaminant
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
RHS_SEQ_ID: RHS_SEQ_ID	number	1		20
SITE_ID: SITE_ID	character	21		7
WSMC_NMBR: WSMC_NMBR	number	28		20
CC_CONT_OF_CNCRN_FLAG: COC_FLAG	character	48		1
CC_MAX_CONC_VALUE_NMBR: MX_CONC_VL	number	49	7	20
CC_MIN_CONC_VALUE_NMBR: MN_CONC_VL	number	69	7	20
RCONC_UNITS_CODE: CONC_UN_CD	character	89		2
Total length:				90

Top of Page

File Name: contact
Table Name: site_contact
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
SITE_ID: SITE_ID	character	1		7
SITE_CONT_SEQ_ID: CONT_SQ_ID	number	8		20
PERSON_ID: PERSON_ID	number	28		20
RROLE_CODE: RROLE_CODE	character	48		5
Total length:				52

Top of Page

File Name: csit_al
Table Name: cmt_site_alias
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
SITE_ID: SITE_ID	character	1		7
SITE_ALIAS_ID: ALIAS_ID	number	8		20
CSA_SEQ_NMBR: CSA_SEQ_NO	number	28		20
CSA_TEXT: TEXT1 TEXT2 TEXT3 TEXT4 TEXT5 TEXT6 TEXT7 TEXT8	character character character character character character character character	48 298 548 798 1,048 1,298 1,548 1,798		250 250 250 250 250 250 250 250
Total Length:				2,047

Top of Page

File Name: ei_clnup
Table Name: ei_cleanup
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
SITE_ID: SITE_ID	character	1		7
EC_SEQ_ID: EC_SEQ_ID	number	8		20
RAT_CODE: RAT_CODE	character	28		2
ACT_CODE_ID: ACT_CODE	character	30		3
WSMC_NMBR: WSMC_NMBR	number	33		20
EC_STANDARD_AMOUNT: EC_STD_AMT	number	53		20
RSVUC_STANDARD_UNIT_CODE: STD_UN_CD	character	73		4
EC_NO_FURTHER_DATA_FLAG: EC_NFD_FLG	character	77		1
Total Length:				77

Top of Page

File Name: fed_reg
Table Name: federal_register
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
SITE_ID: SITE_ID	character	1		7
RFRA_CODE: RFRA_CODE	character	8		1
FR_DATE: FR_DATE	character(date:yyyymmdd)	9		8
FR_VOL: FR_VOL	character	17		3
FR_PAGE_NMBR: FR_PG_NUM	character	20		5
FR_ACTION_NAME: FR_ACT_NM	character	25		50
FR_HRS_SCORE_NMBR: FR_HRS_SCR	number	75	2	20
FR_NPL_UPDATE_NMBR: FR_NPL_UNO	character	95		2
Total Length:				96

Top of Page

File Name: fin_tra
Table Name: financial_transaction
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
RFTT_CODE: RFTT_CODE	character	1		1
SITE_ID: SITE_ID	character	2		7
RAT_CODE: RAT_CODE	character	9		2
ACT_CODE_ID: ACT_CODE	character	11		3
FT_ID: FT_ID	character	14		4
FT_IFMS_FLAG: FT_IFMS_FL	character	18		1
FT_DATE: FT_DATE	character(date:yyyymmdd)	19		8
FT_AMT: FT_AMT	number	27		20
FT_FY: FT_FY	character	47		4
FT_BUDGET_FY: FT_BUG_FY	character	51		4
RFBS_CODE: RFBS_CODE	character	55		1
Total Length:				55

Top of Page

File Name: op_unit
Table Name: operable_unit
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
SITE_ID: SITE_ID	character	1		7
OU_ID: OU_ID	character	8		2
OU_NAME: OU_NAME	character	10		30
Total length:				39

Top of Page

File Name: person
Table Name: person
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
PERSON_ID: PERSON_ID	number	1		20
PERSON_FIRST_NAME: FIRST_NAME	character	21		26
PERSON_LAST_NAME: LAST_NAME	character	47		26
PERSON_PHONE_NMBR1: PHONE_NMBR	character	73		10
PERSON_INTERNET_ADRS: NET_ADRS1 NET_ADRS2	character character	83 211		128 128
Total length:				338

Top of Page

File Name: point
Table Name: point
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
SITE_ID: SITE_ID	character	1		7
PNT_SEQ_ID: PNT_SEQ_ID	number	8		20
PNT_DEC_LAT: PNT_DC_LAT	character	28		10
PNT_DEC_LONG: PNT_DC_LNG	character	38		11
Total length:				48

Top of Page

File Name: ract_ano
Table Name: ref_action_anomaly
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
RAA_CODE: RAA_CODE	character	1		2
RAA_DESC: RAA_DESC	character	3		40
Total Length:				42

Top of Page

File Name: ract_cri
Table Name: ref_action_critical_flag
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
RACT_CRITICAL_FLAG_CODE: CRIT_CODE	character	1		1
RACT_CRITICAL_FLAG_DESC: CRIT_DESC	character	2		20
Total Length:				21

Top of Page

File Name: ract_lea
Table Name: ref_action_lead_type
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
RALT_CODE: RALT_CODE	character	1		2
RALT_DESC: RALT_DESC	character	3		50
Total Length:				52

Top of Page

File Name: ract_qua
Table Name: ref_action_qualifier
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
RAQ_ACTION_QUAL_CODE: QUAL_CODE	character	1		2
RAQ_ACTION_QUAL_DESC: QUAL_DESC	character	3		75
Total Length:				77

Top of Page

File Name: ract_typ
Table Name: ref_action_type
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
RAT_CODE: RAT_CODE	character	1		2
RAT_NAME: RAT_NAME	character	3		100
RAT_HISTORICAL_ONLY_FLAG: HIS_FLAG	character	103		1
RAT_NSI_INDICATOR: NSI_INDCTR	character	104		1
RAT_LEVEL: RAT_LEVEL	character	105		1
RIE_CODE: RIE_CODE	character	106		1
RAT_DEF: DEF1 DEF2 DEF3 DEF4 DEF5 DEF6 DEF7 DEF8	character character character character character character character character	107 357 607 857 1,107 1,357 1,607 1,857		250 250 250 250 250 250 250 250
RAT_DEF_OU: DEF_OU	character	2,107		2
RFBS_CODE: RFBS_CODE	character	2,109		1
SPA_CODE: SPA_CODE	character	2,110		2
Total:				2,111

Top of Page

File Name: rbrac
Table Name: ref_brac
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
RBRAC_CODE: RBRAC_CODE	character	1		1
RBRAC_DESC: RBRAC_DESC	character	2		8
Total Length:				9

Top of Page

File Name: rcmt_sit
Table Name: ref_cmt_site
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
RCST_CODE: RCST_DESC	character	1		2
RCS_DESC: RCS_DESC	character	3		50
Total Length:				52

Top of Page

File Name: rconc_un
Table Name: ref_concentration_units
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
RCONC_UNITS_CODE: CONC_UN_CD	character	1		2
RCONC_UNITS_DESC: CONC_UN_DS	character	3		50
Total Length:				52

Top of Page

File Name: rcont_gp
Table Name: ref_contaminant_group
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
RCG_CODE: RCG_CODE	character	1		2
RCG_NAME: RCG_NAME	character	3		80
Total Length:				82

Top of Page

File Name: rdimunit
Table Name: ref_dimension_unit
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
RDMNSN_UNIT_CODE: DIM_UN_CD	character	1		4
RDMNSN_UNIT_DESC: DIM_UN_DS	character	5		50
Total Length:				54

Top of Page

File Name: rfbs
Table Name: ref_financial_budget_source
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
RFBS_CODE: RFBS_CODE	character	1		1
RFBS_DESC: RFBS_DESC	character	2		80
Total Length:				81

Top of Page

File Name: rfed_fac
Table Name: ref_federal_facility
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
RFED_FCLTY_CODE: FCLTY_CODE	character	1		1
RFED_FCLTY_DESC: FCLTY_DESC	character	2		22
Total Length:				23

Top of Page

File Name: rfed_rgs
Table Name: ref_fdrl_rgstr_actn
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
RFRA_CODE: RFRA_CODE	character	1		1
RFRA_DESC: RFRA_DESC	character	2		50
Total Length:				51

Top of Page

File Name: rfin_typ
Table Name: ref_financial_transaction_type
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
RFTT_CODE: RFTT_CODE	character	1		1
RFTT_LONG_NAME: LONG_NAME	character	2		50
RFTT_PLAN_ACT: FTT_PL_ACT	character	52		1
RFTT_DESC: RFTT_DESC	character	53		250
Total Length:				302

Top of Page

File Name: rhaz_sub
Table Name: ref_hazardous_substance
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
RHS_SEQ_ID: RHS_SEQ_ID	number	1		20
RHS_NMBR: RHS_NMBR	character	21		15
RHS_NAME: RHS_NAME1 RHS_NAME2 RHS_NAME3 RHS_NAME4 RHS_NAME5 RHS_NAME6 RHS_NAME7 RHS_NAME8	character character character character character character character character	36 286 536 786 1,036 1,286 1,536 1,786		250 250 250 250 250 250 250 250
RCG_CODE: RCG_CODE	character	2,036		2
RHS_NAMING_AGENCY_CODE: RHS_AG_CODE	character	2,038		50
Total Length:				2,087

Top of Page

File Name: rifms
Table Name: ref_ifms_entry
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
RIE_CODE: RIE_CODE	character	1		1
RIE_DESC: RIE_DESC	character	2		50
Total Length:				51

Top of Page

File Name: rmd_resp
Table Name: remedial_response
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
SITE_ID: SITE_ID	character	1		7
RMDLR_RESP_ID: RESP_ID	number	8		20
RRTG_CODE: RRTG_CODE	character	28		2
R_RTT_CODE: R_RTT_CODE	character	30		4
RMEDIA_CODE: RMED_CODE	character	34		2
ACT_CODE_ID: ACT_CODE	character	36		3
RAT_CODE: RAT_CODE	character	39		2
Total Length:				40

Top of Page

File Name: rmedia
Table Name: ref_media
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
RMEDIA_CODE: RMED_CODE	character	1		2
RMEDIA_DESC: RMED_DESC	character	3		80
Total Length:				82

Top of Page

File Name: rmv_resp
Table Name: removal_response
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
SITE_ID: SITE_ID	character	1		7
RMDLR_RESP_ID: RESP_ID	number	8		20
RRTG_CODE: RRTG_CODE	character	28		2
R_RTT_CODE: R_RTT_CODE	character	30		4
RMEDIA_CODE: RMED_CODE	character	34		2
ACT_CODE_ID: ACT_CODE	character	36		3
RAT_CODE: RAT_CODE	character	39		2
Total Length:				40

Top of Page

File Name: rnon_npl
Table Name: ref_non_npl_status
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
RNON_NPL_STATUS_CODE: NON_NPL_CD	character	1		2
RNON_NPL_STATUS_DESC: NON_NPL_DS	character	3		80
Total:				82

Top of Page

File Name: rnpl_sta
Table Name: ref_npl_status
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
RNPL_STATUS_CODE: NPL_CD	character	1		1
RNPL_STATUS_DESC: NPL_DS	character	2		50
Total:				51

Top of Page

File Name: rpla_sta
Table Name: ref_planning_status
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
RPS_CODE: RPS_CODE	character	1		2
RPS_DESC: RPS_DESC	character	3		80
Total:				82

Top of Page

File Name: rprog_pri
Table Name: ref_program_priority_type
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
RPPT_CODE: RPPT_CODE	character	1		2
RPPT_DESC: RPPT_DESC	character	3		50
Total:				52

Top of Page

File Name: rregion
Table Name: ref_region
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
RREGION_CODE: REGION_CD	character	1		2
RREGION_DESC: REGION_DS	character	3		80
Total Length:				82

Top of Page

File Name: rrespfed
Table Name: ref_resp_fed_agncy
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
RRESP_FED_AGNCY_CODE: RESP_FA_CD	character	1		4
RRESP_FED_AGNCY_DESC: RESP_FA_DS	character	5		75
Total Length:				79

Top of Page

File Name: rrole
Table Name: ref_role
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
RROLE_CODE: RROLE_CODE	character	1		5
RROLE_DESC: RROLE_DESC	character	6		80
Total Length:				85

Top of Page

File Name: rrsp_tec
Table Name: ref_response_technology_type
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
RRTG_CODE: RRTG_CODE	character	1		2
RMEDIA_CODE: RMED_CODE	character	3		2
R_RTT_CODE: R_RTT_CODE	character	5		4
R_RTT_NAME: R_RTT_NAME	character	9		80
R_RTT_TORC: R_RTT_TORC	character	89		1
RTT_DEFINITION: R_RTT_DEF1 R_RTT_DEF2	character character	90 340		250 250
Total:				589

Top of Page

File Name: rrtgrp
Table Name: ref_response_type_group
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
RRTG_CODE: RRTG_CODE	character	1		2
RRTG_DESC: RRTG_DESC	character	3		80
Total Length:				82

Top of Page

File Name: rsatype
Table Name: ref_site_alias_type
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
RSAT_CODE: RSAT_CODE	character	1		2
RSAT_DESC: RSAT_DESC	character	3		40
Total Length:				42

Top of Page

File Name: rsit_cat
Table Name: ref_site_category
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
RESC_CATEGORY_CODE: SCAT_CD	character	1		2
RESC_CATEGORY_DESC: SCAT_DS	character	3		80
Total Length:				82

Top of Page

File Name: rsit_set
Table Name: ref_site_setting
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
RSITE_SETTING_CODE: SIT_SET_CD	character	1		2
RSITE_SETTING_DESC: SIT_SET_DS	character	3		50
Total Length:				52

Top of Page

File Name: rsit_typ
Table Name: ref_site_incident_type
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
RSIT_CODE: RST_CODE	character	1		2
RSIT_DESC: RST_DESC	character	3		50
Total Length:				52

Top of Page

File Name: rsitsubc
Table Name: ref_site_sub_category
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
RSSC_SUB_CATEGORY_CODE: SUBC_CD	character	1		2
RSSC_SUB_CATEGORY_DESC: SUBC_DS	character	3		100
Total Length:				102

Top of Page

File Name: rsparea
Table Name: ref_superfund_program_area
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
SPA_CODE: SPA_CODE	character	1		2
SPA_NAME: SPA_NAME	character	3		50
Total Length:				52

Top of Page

File Name: rstate
Table Name: ref_state
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
RSTATE_CODE: STATE_CODE	character	1		2
RSTATE_NAME: STATE_NM	character	3		40
RS_NAVAJO_NATION_FLAG: NAV_NAT_FL	character	43		1
Total Length:				43

Top of Page

File Name: rstincat
Table Name: ref_site_incident_category
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
RSITINC_CODE: RSITINC_CD	character	1		1
RSITINC_DESC: RSITINC_DS	character	2		50
Total Length:				51

Top of Page

File Name: rvolunit
Table Name: ref_volume_unit
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
RVOLUME_UNIT_CODE: VOL_UN_CD	character	1		4
RVOLUME_UNIT_DESC: VOL_UN_DS	character	5		50
Total Length:				54

Top of Page

File Name: sit_prog
Table Name: site_program_priority_init
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
SITE_ID: SITE_ID	character	1		7
RPPT_CODE: RPPT_CODE	character	8		2
Total Length:				9

Top of Page

File Name: sit_subc
Table Name: site_type_sub_category
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
SITE_ID: SITE_ID	character	1		7
RSSC_SUB_CATEGORY_CODE: SCAT_CD	character	8		2
RESC_CATEGORY_CODE: SUBC_CD	character	10		2
STSC_OTHER_SUB_TEXT: OTH_SB_TXT	character	12		40
STSC_PRIMARY_FLAG: STSC_P_FL	character	52		1
Total Length:				52

Top of Page

File Name: sit_typc
Table Name: site_type_category
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
SITE_ID: SITE_ID	character	1		7
RESC_CATEGORY_CODE: SCAT_CD	character	8		2
STC_PRIMARY_FLAG: PRIM_FLG	character	10		1
Total Length:				10

Top of Page

File Name: site
Table Name: site
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
SITE_ID: SITE_ID	character	1		7
SITE_EPA_ID: EPA_ID	character	8		12
SITE_SHORT_NAME: SHORT_NM	character	20		25
SITE_NAME: SITE_NAME	character	45		80
SITE_STRT_ADRS1: STRT_ADRS1	character	125		40
SITE_STRT_ADRS2: STRT_ADRS2	character	165		40
SITE_CITY_NAME: CITY	character	205		25
SITE_ZIP_CODE: ZIP	character	230		10
SITE_CNTY_NAME: CNTY_NAME	character	240		40
SITE_CNGRSNL_DSTRCT_CODE: CNG_DSTRCT	character	280		59
SITE_DMNSN_NMBR: DMNSN_NM	number	339	2	20
SITE_ORPHN_FLAG: ORPHN_FL	character	359		1
SITE_RCRA_ID: RCRA_ID	character	360		12
SITE_IFMS_SSID_CODE: SSID_CODE	character	372		4
SITE_USGS_QDRNGL_DESC: USGS_Q_DS	character	376		40
SITE_USGS_HYDRO_UNIT_NMBR: HYDRO_UNIT	character	416		8
SITE_INIT_BY_PROG_IND: INT_PRG_IN	character	424		1
SITE_NFRAP_FLAG: NFRAP_FLAG	character	425		3
SITE_SMSA_NMBR: SMSA_NMBR	character	428		4
SITE_PARENT_ID: PARENT_ID	character	432		7
RST_CODE: RST_CODE	character	439		2
RREGION_CODE: REGION_CD	character	441		2
RSTATE_CODE: STATE_CODE	character	443		2
RSITINC_CODE: RSITINC_CD	character	445		1
RSITE_SETTING_CODE: SIT_SET_CD	character	446		2
RNPL_STATUS_CODE: NPL_CD	character	448		1
RDMNSN_UNIT_CODE: DIM_UN_CD	character	449		4
RBRAC_CODE: RBRAC_CODE	character	453		1
RFED_FCLTY_CODE: FCLTY_CODE	character	454		1
RRESP_FED_AGNCY_CODE: RESP_FA_CD	character	455		4
RNON_NPL_STATUS_CODE: NON_NPL_CD	character	459		2
NON_NPL_STATUS_DT: NNPL_ST_DT	character(date:yyyymmdd)	461		8
SITE_FIPS_CODE: FIPS_CODE	character	469		5
SITE_CC_CONCURRENCE_DATE: CC_CON_DT	character(date:yyyymmdd)	474		8
SITE_CC_CONCURRENCE_FY: CC_CON_FY	character	482		4
SITE_ALIAS_EPA_ID: SA_EPA_ID	character	486		12
SITE_FUDS_FLAG: FUDS_FLAG	character	498		1
Total Length:				498

Top of Page

File Name: site_ali
Table Name: site_alias
CERCLIS NAME: DBF Field Name	Format	Start	Length
SITE_ID: SITE_ID	character	1	7
SITE_ALIAS_ID: ALIAS_ID	number	8	20
SA_NAME: SA_NAME	character	28	80
SITE_ALIAS_CITY_NAME: ALIAS_CITY	character	108	40
SITE_ALIAS_STRT_ADRS: ALIAS_STRT	character	148	40
SITE_ALIAS_ZIP_CODE: ALIAS_ZIP	character	188	10
RSTATE_CODE: STATE_CODE	character	198	2
SITE_ALIAS_NPL_LISTING_FLAG: SA_NPL_FLG	character	200	1
SITE_ALIAS_CNTY_NAME: SA_CNTY	character	201	40
SITE_ALIAS_FIPS_CODE: SA_FIPS	character	241	5
SITE_ALIAS_CNGRSNL_DSTRCT_CODE: SA_CNGDSCD	character	246	59
RSATE_CODE: RSAT_CODE	character	305	2
Total Length:			306

Top of Page

File Name: wa_src
Table Name: waste_src_media_contaminated
CERCLIS NAME: DBF Field Name	Format	Start	Decimal	Length
SITE_ID: SITE_ID	character	1		7
WSMC_NMBR: WSMC_NMBR	number	8		20
ACT_CODE_ID: ACT_CODE	character	28		3
RAT_CODE: RAT_CODE	character	31		2
WSMC_NAME: WSMC_NAME	character	33		100
WSMC_VOL_HIGH: VOL_HIGH	number	133	2	20
WMSC_VOL_LOW: VOL_LOW	number	153	2	20
RVOLUME_UNIT_CODE: VOL_UN_CD	character	173		4
RMEDIA_CODE: RMED_CODE	character	177		2
Total Length:				178

Top of Page

OSWER Home | Superfund Home

CERCLIS and Archived Sites Record Layout

Local Navigation