FLAT FILE SPECIFICATIONS - CHANGE LOG

Handler Module	Biennial Report Module	Financial Assurance Module	Permit Module
e-Manifest Module	Corrective Action Module	GIS Module

HANDLER MODULE

Date	File Name	English Name	Change Type	Excel Column	Field Length	Data Type
10/30/2020	HD_HANDLER	Location Latitude	New	CG	10	Number
10/30/2020	HD_HANDLER	Location Longitude	New	CH	11	Number
10/30/2020	HD_HANDLER	Location GIS Primary	New	CI	1	Alphanumeric
10/30/2020	HD_HANDLER	Location GIS Origin	New	CJ	1	Alphanumeric
10/30/2020	HD_EPISODIC_PROJECT		New			File
10/30/2020	HD_EPISODIC_EVENT	Episodic Event Other Description	Deleted	G	80	Alphanumeric
10/30/2020	HD_EPISODIC_EVENT	Emergency Contact Telephone Number	Revised	G	15	Alphanumeric
10/30/2020	HD_EPISODIC_EVENT	Emergency Contact Telephone Extension	Revised	H	6	Alphanumeric
10/30/2020	HD_EPISODIC_EVENT	Emergency Contact First Name	Revised	I	38	Alphanumeric
10/30/2020	HD_EPISODIC_EVENT	Emergency Contact Last Name	Revised	J	38	Alphanumeric
10/30/2020	HD_EPISODIC_EVENT	Emergency Contact Email	Revised	K	80	Alphanumeric
10/30/2020	HD_EPISODIC_EVENT	Event Start Date	Revised	L	8	Date (YYYYMMDD)
10/30/2020	HD_EPISODIC_EVENT	Event End Date	Revised	M	8	Date (YYYYMMDD)
10/30/2020	HD_LU_EPISODIC_EVENT		Deleted			File
10/30/2020	HD_LU_EPISODIC_PROJECT		New			File
10/30/2020	HD_REPORTING	Location Latitude	New	DN	10	Number
10/30/2020	HD_REPORTING	Location Longitude	New	DO	11	Number
10/30/2020	HD_REPORTING	Location GIS Primary	New	DP	1	Alphanumeric
10/30/2020	HD_REPORTING	Location GIS Origin	New	D1	1	Alphanumeric
1/8/2021	HD_EPISODIC_PROJECT	Episodic Other Project Description	Revised	G	255	Alphanumeric
5/19/2022	HD_HANDLER	Biennial Report Exempt Indicator	New	CK	1	Alphanumeric
5/19/2022	HD_REPORTING	Significant Non-Complier With a Compliance Schedule Universe	Deleted	DC	1	Alphanumeric
8/4/2023	HD_HANDLER	Contact Preferred Language	New	CL	2	Alphanumeric
8/4/2023	HD_REPORTING	Contact Preferred Language	New	DR	2	Alphanumeric
8/4/2023	HD_ADDL_CONTACT		New			File
8/4/2023	HD_LU_CONTACT_TYPE		New			File
8/4/2023	HD_LU_LANGUAGE		New			File

BIENNIAL REPORT MODULE

Date	File Name	English Name	Change Type	Excel Column	Field Length	Data Type
1/8/2021	BR_REPORTING	Country Code	New	BH	2	Alphanumeric
1/8/2021	BR_REPORTING	Mixed Waste	New	BI	1	Alphanumeric

FINANCIAL ASSURANCE MODULE

Date	File Name	English Name	Change Type	Excel Column	Field Length	Data Type
5/19/2022	FA_COST_ESTIMATE	Update Due Date	New	K	8	Date (YYYYMMDD)
5/19/2022	FA_COST_ESTIMATE	Current Cost Estimate Indicator	New	L	1	Alphanumeric
5/19/2022	FA_MECHANISM	Provider Contact Email	New	J	80	Alphanumeric
5/19/2022	FA_MECHANISM_DETAIL	Financial Test / Corporate Guarantee Alternative	New	I	1	Alphanumeric
5/19/2022	FA_MECHANISM_DETAIL	Facility Face Value Amount	New	J	13	Number
5/19/2022	FA_MECHANISM_DETAIL	Current Mechanism Detail Indicator	New	K	1	Alphanumeric

PERMITTING MODULE

Date	File Name	English Name	Change Type	Excel Column	Field Length	Data Type
5/19/2022	PM_UNIT_DETAIL	Current Unit Detail Indicator	New	P	1	Alphanumeric

E-MANIFEST MODULE

Date	File Name	English Name	Change Type	Excel Column	Field Length	Data Type
3/19/2023	EM_MANIFEST	Total Acute Waste Quantity, in Kilograms	New	AN	22	Number
3/19/2023	EM_MANIFEST	Total Acute Waste Quantity, in Tons	New	AO	22	Number
3/19/2023	EM_MANIFEST	Total Hazardous Wate Quantity, in Kilograms	New	AP	22	Number
3/19/2023	EM_MANIFEST	Total Hazardous Waste Quantity, in Tons	New	AQ	22	Number
3/19/2023	EM_MANIFEST	Total Non-Acute Waste Quantity, in Kilograms	New	AR	22	Number
3/19/2023	EM_MANIFEST	Total Non-Acute Waste Quantity, in Tons	New	AS	22	Number
3/19/2023	EM_MANIFEST	Total Non-Hazardous Waste Quantity, in Kilograms	New	AT	22	Number
3/19/2023	EM_MANIFEST	Total Non-Hazardous Waste Quantity, in Tons	New	AU	22	Number
3/19/2023	EM_MANIFEST	Total Waste Quantity, in Kilograms	New	AV	22	Number
3/19/2023	EM_MANIFEST	Total Waste Quantity, in Tons	New	AW	22	Number
3/19/2023	EM_MANIFEST	Broker ID	New	AX	15	Alphanumeric
3/19/2023	EM_WASTE_LINE	Hazardous Waste Quantity, in Kilograms	New	AI	22	Number
3/19/2023	EM_WASTE_LINE	Hazardous Waste Quantity, in Tons	New	AJ	22	Number
3/19/2023	EM_WASTE_LINE	Non-Hazardous Waste Quantity, in Kilograms	New	AK	22	Number
3/19/2023	EM_WASTE_LINE	Non-Hazardous Waste Quantity, in Tons	New	AL	22	Number
7/14/2024	EM_FEDERAL_WASTE_CODE		Deleted			File
7/14/2024	EM_STATE_WASTE_CODE		Deleted			File
7/14/2024	EM_WASTE_LINE	Federal Waste Codes	New	AM	4000	Alphanumeric
7/14/2024	EM_WASTE_LINE	State Waste Codes	New	AN	4000	Alphanumeric
5/1/2025	EM_MANIFEST	Previous Residue	New	AY	1	Alphanumeric
5/1/2025	EM_MANIFEST	New Manifest Destination	New	AZ	30	Alphanumeric
5/1/2025	EM_MANIFEST	Original Manifest Tracking Numbers	New	BA	255	Alphanumeric
5/1/2025	EM_MANIFEST	Original Certified Date	New	BB	8	Date (YYYYMMDD)

CORRECTIVE ACTION MODULE

Date	File Name	English Name	Change Type	Excel Column	Field Length	Data Type
1/10/2025	AAREA4	Area Acreage	New	N	22	Number

GIS MODULE

Date	File Name	English Name	Change Type	Excel Column	Field Length	Data Type
1/10/2025	GS_GIS		Deleted
1/10/2025	GS_GIS_LAT_LONG		Deleted
1/10/2025	GS_LU_AREA_SOURCE		Deleted
1/10/2025	GS_LU_COORDINATE		Deleted
1/10/2025	GS_LU_GEOGRAPHIC_REFERENCE		Deleted
1/10/2025	GS_LU_GEOMETRIC		Deleted
1/10/2025	GS_LU_HORIZONTAL_COLLECTION		Deleted
1/10/2025	GS_LU_HORIZONTAL_REFERENCE		Deleted
1/10/2025	GS_LU_VERIFICATION		Deleted