Jump to main content.


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

 

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


Local Navigation


Jump to main content.