CBLS Variables - Differences in Reporting Requirements

Attachment 6d. CBLS Differences in Variable Reporting Requirements
HHLPPSS Variables (OMB Control 0920-0931; Exp. Date 05/31/2018)				CBLS Variables (Extension revision request)			Differences (if blank, no change)
Table: 1, Record Type: Basic Format				Record Type: Basic Format			Removed Table # for Basic Format
Position	Field Name	Valid Values - Description		Position	Field Name	Valid Values - Description
1 to 3	FILEID	File identifier for record type. REQUIRED		1 to 3	FILEID	File identifier for record type. REQUIRED
		CHI - Child				CHI - Child
		ADD - Address				ADD - Address
		LAB - Lab				LAB - Lab
		INV - Investigation				INV - Investigation
		LNK – Child-to-address link				LNK – Child-to-address link
		HHI - healthy housing inspection					Removed Healthy Housing Inspection (HHI) Record Type
4	ACTION	Database action code. REQUIRED		4	ACTION	Database action code. REQUIRED
		A - Add record				A - Add record
		C - Change/replace				C - Change/replace
		D - Delete				D - Delete
5	QTR	Reporting quarter. All annual submissions should be “4" for fourth quarter. REQUIRED		5	QTR	Reporting quarter. All annual submissions should be “4" for fourth quarter. REQUIRED
		1 - First quarter (1/01/yy - 3/31/yy)				1 - First quarter (1/01/yy - 3/31/yy)
		2 - Second quarter (4/01/yy - 6/30/yy)				2 - Second quarter (4/01/yy - 6/30/yy)
		3 - Third quarter (7/01/yy - 9/30/yy)				3 - Third quarter (7/01/yy - 9/30/yy)
		4 - Fourth quarter (10/01/yy - 12/31/yy)				4 - Fourth quarter (10/01/yy - 12/31/yy)
6 to 7	RPT_YR	Reporting year. REQUIRED		6 to 7	RPT_YR	Reporting year. REQUIRED
		Last two digits of the reporting year.				Last two digits of the reporting year.
		Must be numeric.				Must be numeric.
8 to 12	PGMID	Program identifier. REQUIRED		8 to 12	PGMID	Program identifier. REQUIRED
		A unique identifier for the CLPPP (or lead database) submitting the data.				A unique identifier for the Awardee submitting the data, or for each lead reporting database within the Awardee jurisdiction.
		The first two positions must contain the state FIPS (Federal Information Processing Standard) code. The next three positions are pre-assigned for STELLAR databases and must be unique for each lead database within a state (including databases other than STELLAR). You may obtain a program ID from the Lead Poisoning Prevention Branch (LPPB).				The first two positions must contain the state FIPS (Federal Information Processing Standard) code. The next three positions are pre-assigned for HHLPSS and must be unique for each lead database within a state (including databases other than HHLPSS). Program ID is obtained from the Healthy Homes and Lead Poisoning Prevention Program (HHLPPP).	Systematic Tracking of Elevated Lead Levels And Remediation (STELLAR) Software retired & replaced with Healthy Homes and Lead Poisoning Surveillance System (HHLPSS) Software
13 to 20	CHILD_ID	Child identifier. REQUIRED		13 to 20	CHILD_ID	Child identifier. REQUIRED
		A unique identifier for a child; must be numeric and zero-filled. This would generally be a system-assigned sequential number within a database. The identifier is used in relational databases to eliminate redundant data. The child information exists only once, in one physical record, and is linked to related records by the child identifier.				A unique identifier for a child; must be numeric and zero-filled. This would generally be a system-assigned sequential number within a database. The identifier is used in relational databases to eliminate redundant data. The child information exists only once, in one physical record, and is linked to related records by the child identifier.
		When records from two or more databases are combined, the combination of PGMID and CHILD_ID form a unique identifier within the combined database.				When records from two or more databases are combined, the combination of PGMID and CHILD_ID form a unique identifier within the combined database.
13 to 20	ADDR_ID	Address identifier. REQUIRED		13 to 20	ADDR_ID	Address identifier. REQUIRED
		A unique identifier for an address; must be numeric and zero-filled. This would generally be a system-assigned sequential number within a database. The identifier is used in relational databases to eliminate redundant data. The address information exists only once, in one physical record, and is linked to related records by the identifier.				A unique identifier for an address; must be numeric and zero-filled. This would generally be a system-assigned sequential number within a database. The identifier is used in relational databases to eliminate redundant data. The address information exists only once, in one physical record, and is linked to related records by the identifier.
		When records from two or more databases are combined, the combination of PGMID and ADDR_ID form a unique identifier within the combined database.				When records from two or more databases are combined, the combination of PGMID and ADDR_ID form a unique identifier within the combined database.
21 to 249	---	Table-specific variable format area based on required reporting. The contents and format depend on the value in the field FILEID. See Tables 1-5 to follow.		21 to 249	---	Table-specific variable format area based on required reporting. The contents and format depend on the value in the field FILEID. See Tables 1-5 to follow.
Table: 3				Table: 1			Moved CHILD Record to Table 1.
Record Type: Child				Record Type: Child
FILEID: CHI				FILEID: CHI
Position	Field Name	Valid Values - Description		Position	Field Name	Valid Values - Description
1 to 3	FILEID	CHI – Child. REQUIRED		1 to 3	FILEID	CHI – Child. REQUIRED
		File identifier for record type.				File identifier for record type.
4	ACTION	Database action code. REQUIRED		4	ACTION	Database action code. REQUIRED
		A - Add record				A - Add record
		C - Change/replace				C - Change/replace
		D - Delete				D - Delete
5	QTR	Reporting quarter. All annual submissions should be “4" for fourth quarter. REQUIRED		5	QTR	Reporting quarter. All annual submissions should be “4" for fourth quarter. REQUIRED
		1 - First quarter (1/01/yy - 3/31/yy)				1 - First quarter (1/01/yy - 3/31/yy)
		2 - Second quarter (4/01/yy - 6/30/yy)				2 - Second quarter (4/01/yy - 6/30/yy)
		3 - Third quarter (7/01/yy - 9/30/yy)				3 - Third quarter (7/01/yy - 9/30/yy)
		4 - Fourth quarter (10/01/yy - 12/31/yy)				4 - Fourth quarter (10/01/yy - 12/31/yy)
6 to 7	RPT_YR	Reporting year. REQUIRED		6 to 7	RPT_YR	Reporting year. REQUIRED
		Last two digits of the reporting year.				Last two digits of the reporting year.
		Must be numeric.				Must be numeric.
8 to 12	PGMID	Program identifier. REQUIRED		8 to 12	PGMID	Program identifier. REQUIRED
		A unique identifier for the Awardee submitting the data, or for each lead reporting database within the Awardee jurisdiction.				A unique identifier for the Awardee submitting the data, or for each lead reporting database within the Awardee jurisdiction.
13 to 20	CHILD_ID	Child identifier. REQUIRED		13 to 20	CHILD_ID	Child identifier. REQUIRED
		A unique identifier for a child; must be numeric and zero-filled.				A unique identifier for a child; must be numeric and zero-filled.
21 to 28	DOB	Child's date of birth. (CCYYMMDD) REQUIRED		21 to 28	DOB	Child's date of birth. (CCYYMMDD) REQUIRED
		Birth date cannot be after the end of the reporting year.				Birth date cannot be after the end of the reporting year.
		Child may not be older than 16 years at the start of the reporting year.				Child may not be older than 16 years at the start of the reporting year.
29	GENDER	Gender.		29	SEX	Sex. REQUIRED	"SEX" instead of "GENDER"
		1 – Male				1 – Male	Change to required variable
		2 – Female				2 – Female
		9 – Unknown				9 – Unknown
30	ETHNIC	Ethnicity (Select only one).		30	ETHNIC	Ethnicity (Select only one). REQUIRED	Addition of 'unknown' category.
		1 – Hispanic or Latino				1 – Hispanic or Latino	Change to required variable
		2 – Not Hispanic or Latino				2 – Not Hispanic or Latino
						9 – Unknown
31	RACE	Race (More than one can be selected).		31	RACE	Race (Select only one). REQUIRED	Addition of 'more than one race' and 'unknown' to available categories
		1 – American Indian or Alaskan Native				1 – American Indian or Alaskan Native	Change to required variable
		2 – Asian				2 – Asian
		3 – Black or African American				3 – Black or African American
		4 – Native Hawaiian or Other Pacific Islander				4 – Native Hawaiian or Other Pacific Islander
		5 – White				5 – White
						6 – More than one race
						9 – Unknown
32	CHELATED	Chelation therapy administered.		32	CHELATED	Chelation therapy administered. REQUIRED	Change to required variable
		1 – Yes				1 – Yes
		2 – No				2 – No
		9 – Unknown				9 – Unknown
33	CHEL_TYPE	Type of chelation.		33	CHEL_TYPE	Type of chelation. REQUIRED	Change to required variable
		1 – Inpatient				1 – Inpatient
		2 – Outpatient				2 – Outpatient
		3 – Both				3 – Both
		9 – Unknown				9 – Unknown
		Cannot be blank if CHELATED =1. Cannot be 1, 2, or 3 if CHELATED =2 or 9.				Cannot be blank if CHELATED =1. Cannot be 1, 2, or 3 if CHELATED =2 or 9.
34	CHEL_FUND	Source of funding for the chelation therapy.		34	CHEL_FUND	Source of funding for the chelation therapy. REQUIRED	Change to required variable
		1 – Public, includes Medicaid				1 – Public, includes Medicaid
		2 – Private insurance				2 – Private insurance
		3 – Parent self-pay				3 – Parent self-pay
		8 – Other				8 – Other
		9 – Unknown				9 – Unknown
		Cannot be blank if CHELATED = 1.				Cannot be blank if CHELATED = 1.
35	NPLSZ	Non-paint lead source - other.		35	NPLSZ	Non-paint lead source - other. REQUIRED	Change to required variable
		1 – Yes				1 – Yes
		2 – No				2 – No
		9 – Unknown				9 – Unknown
36	NPLSM	Non-paint lead source - traditional medicines.		36	NPLSM	Non-paint lead source - traditional medicines. REQUIRED	Change to required variable
		1 – Yes				1 – Yes
		2 – No				2 – No
		9 – Unknown				9 – Unknown
37	NPLSO	Non-paint lead source – occupation of household member.		37	NPLSO	Non-paint lead source – occupation of household member. REQUIRED
		1 – Yes				1 – Yes
		2 – No				2 – No
		9 – Unknown				9 – Unknown
38	NPLSH	Non-paint lead source - hobby of household member.		38	NPLSH	Non-paint lead source - hobby of household member. REQUIRED	Change to required variable
		1 – Yes				1 – Yes
		2 – No				2 – No
		9 – Unknown				9 – Unknown
39	NPLSP	Non-paint lead source - pottery, imported or improperly fired.		39	NPLSP	Non-paint lead source - pottery, imported or improperly fired. REQUIRED
		1 – Yes				1 – Yes
		2 – No				2 – No
		9 – Unknown				9 – Unknown
40	NPLSC	Non-paint lead source - child occupation.		40	NPLSC	Non-paint lead source - child occupation. REQUIRED	Change to required variable
		1 – Yes				1 – Yes
		2 – No				2 – No
		9 – Unknown				9 – Unknown
				41	BIRTH	Country of birth.	Country of birth ("BIRTH")is a new variable
						1 – U.S.
						2 – Other
						3 – Unknown
Table: 2				Table: 2
Record Type: Address				Record Type: Address
FILEID: ADD				FILEID: ADD
Position	Field Name	Valid Values - Description		Position	Field Name	Valid Values - Description
1 to 3	FILEID	ADD – Address. REQUIRED		1 to 3	FILEID	ADD – Address. REQUIRED
		File identifier for record type.				File identifier for record type.
4	ACTION	Database action code. REQUIRED		4	ACTION	Database action code. REQUIRED
		A - Add record				A - Add record
		C - Change/replace				C - Change/replace
		D - Delete				D - Delete
5	QTR	Reporting quarter. All annual submissions should be “4" for fourth quarter. REQUIRED		5	QTR	Reporting quarter. All annual submissions should be “4" for fourth quarter. REQUIRED
		1 - First quarter (1/01/yy - 3/31/yy)				1 - First quarter (1/01/yy - 3/31/yy)
		2 - Second quarter (4/01/yy - 6/30/yy)				2 - Second quarter (4/01/yy - 6/30/yy)
		3 - Third quarter (7/01/yy - 9/30/yy)				3 - Third quarter (7/01/yy - 9/30/yy)
		4 - Fourth quarter (10/01/yy - 12/31/yy)				4 - Fourth quarter (10/01/yy - 12/31/yy)
6 to 7	RPT_YR	Reporting year. REQUIRED		6 to 7	RPT_YR	Reporting year. REQUIRED
		Last two digits of the reporting year.				Last two digits of the reporting year.
		Must be numeric.				Must be numeric.
8 to 12	PGMID	Program identifier. REQUIRED		8 to 12	PGMID	Program identifier. REQUIRED
		A unique identifier for the Awardee submitting the data, or for each lead reporting database within the Awardee jurisdiction.				A unique identifier for the Awardee submitting the data, or for each lead reporting database within the Awardee jurisdiction.
13 to 20	ADDR_ID	Address identifier. REQUIRED		13 to 20	ADDR_ID	Address identifier. REQUIRED
21 to 35	CITY	City name.		21 to 35	CITY	City name.
36 to 38	CNTY_FIPS	County FIPS code. REQUIRED		36 to 38	CNTY_FIPS	County FIPS code. REQUIRED
		Numeric, zero-filled.				Numeric, zero-filled.
		A list of counties their associated FIPS codes is available from lead poisoning prevention branch.				A list of counties their associated FIPS codes is available from HHLPPP.
39 to 47	ZIP	Zip code (5+4 format, no dash).		39 to 47	ZIP	Zip code (5+4 format, no dash).
		Left justified, blank-fill or zero-fill.				Left justified, blank-fill or zero-fill.
48 to 49	STATE	State abbreviation (two-letter alphabetic code).		48 to 49	STATE	State abbreviation (two-letter alphabetic code).
50 to 56	CENSUS	Census tract.		50 to 56	CENSUS	Census tract.
		Left justified, blank-fill.				Left justified, blank-fill.
57	RENOVATED	Residence renovated. REQUIRED		57	RENOVATED	Residence renovated. REQUIRED
		1 - Yes, once				1 - Yes, once
		2 - No				2 - No
		3 - Yes, more than once				3 - Yes, more than once
		9 - Unknown				9 - Unknown
58 to 65	START_REN	Date first renovation begun. (CCYYMMDD)		58 to 65	START_REN	Date first renovation begun. (CCYYMMDD)
		Date must be present when RENOVATED is coded 1 or 3.				Date must be present when RENOVATED is coded 1 or 3.
		Date must be blank when RENOVATED is coded 2 or 9.				Date must be blank when RENOVATED is coded 2 or 9.
66 to 73	COMP_REN	Date latest renovation completed. (CCYYMMDD)		66 to 73	COMP_REN	Date latest renovation completed. (CCYYMMDD)
		Cannot be earlier than START_REN.				Cannot be earlier than START_REN.
		Leave blank if renovation is ongoing as of the end of the reporting year.				Leave blank if renovation is ongoing as of the end of the reporting year.
Table: 5				Table: 3			Moved LAB Record to Table 3.
Record Type: Lab Results				Record Type: Lab Results
FILEID: LAB				FILEID: LAB
Position	Field Name	Valid Values - Description		Position	Field Name	Valid Values - Description
1 to 3	FILEID	LAB – Lab Results. REQUIRED		1 to 3	FILEID	LAB – Lab Results. REQUIRED
		File identifier for record type.				File identifier for record type.
4	ACTION	Database action code. REQUIRED		4	ACTION	Database action code. REQUIRED
		A - Add record				A - Add record
		C - Change/replace				C - Change/replace
		D - Delete				D - Delete
5	QTR	Reporting quarter. All annual submissions should be “4" for fourth quarter. REQUIRED		5	QTR	Reporting quarter. All annual submissions should be “4" for fourth quarter. REQUIRED
		1 - First quarter (1/01/yy - 3/31/yy)				1 - First quarter (1/01/yy - 3/31/yy)
		2 - Second quarter (4/01/yy - 6/30/yy)				2 - Second quarter (4/01/yy - 6/30/yy)
		3 - Third quarter (7/01/yy - 9/30/yy)				3 - Third quarter (7/01/yy - 9/30/yy)
		4 - Fourth quarter (10/01/yy - 12/31/yy)				4 - Fourth quarter (10/01/yy - 12/31/yy)
6 to 7	RPT_YR	Reporting year. REQUIRED		6 to 7	RPT_YR	Reporting year. REQUIRED
		Last two digits of the reporting year.				Last two digits of the reporting year.
		Must be numeric.				Must be numeric.
8 to 12	PGMID	Program identifier. REQUIRED		8 to 12	PGMID	Program identifier. REQUIRED
		A unique identifier for the Awardee submitting the data, or for each lead reporting database within the Awardee jurisdiction.				A unique identifier for the Awardee submitting the data, or for each lead reporting database within the Awardee jurisdiction.
13 to 20	CHILD_ID	Child identifier. REQUIRED		13 to 20	CHILD_ID	Child identifier. REQUIRED
21 to 28	SAMP_DATE	Date sample was drawn. (CCYYMMDD) REQUIRED.		21 to 28	SAMP_DATE	Date sample was drawn. (CCYYMMDD) REQUIRED.
		May not be prior to child DOB.				May not be prior to child DOB.
29 to 36	ADDR_ID	Address identifier. (Unique identifier of child's primary address on the date sample was drawn)		29 to 36	ADDR_ID	Address identifier. (Unique identifier of child's primary address on the date sample was drawn)
		Zero-fill if unknown.				Zero-fill if unknown.
37 to 39	RESULT	Sample result measured in µg/dL. Whole number, zero-filled. REQUIRED		37	PREGNANT	Pregnant at time of blood lead test.	"PREGNANT" is a new variable.
						1 – Yes	Sample result variable position 37-39 moved to positions 68-73 to accommodate change from whole number to two decimal points
						2 – No
						3 – N/A
						9 – Unknown
				38 to 39	--	BLANK	BLANK due to above change
40	fund_source	Source of funding for the laboratory test.		40	LAB_FUND	Source of funding for the laboratory test. REQUIRED	Changed variable name from fund_source to LAB_FUND
		1 – Public, includes Medicaid				1 – Public, includes Medicaid	Change to required variable
		2 – Private insurance				2 – Private insurance
		3 – Parent self-pay				3 – Parent self-pay
		8 – Other				8 – Other
		9 – Unknown				9 – Unknown
41	SAMP_TYPE	Sample type.		41	SAMP_TYPE	Sample type. REQUIRED	Change to required variable
		1 – Venous, blood lead				1 – Venous, blood lead
		2 – Capillary, blood lead				2 – Capillary, blood lead
		9 – Unknown				9 – Unknown
42	TEST_RSN	Test reason.		42	TEST_RSN	Test reason. REQUIRED	Change to required variable
		1 – Screening (asymptomatic child without previous elevated level)				1 – Screening (asymptomatic child without previous elevated level)
		2 – Clinical suspicion of lead poisoning (child symptomatic)				2 – Clinical suspicion of lead poisoning (child symptomatic)
		3 – Confirmatory test following elevated value by fingerstick				3 – Confirmatory test following elevated value by fingerstick
		4 – Follow-up, child with confirmed elevated level				4 – Follow-up, child with confirmed elevated level
		5 – EP, not for lead-screening				5 – EP, not for lead-screening
		9 – Unknown/other				9 – Unknown/other
43	LAB_TYPE	Type of laboratory processing sample.		43	LAB_TYPE	Type of laboratory processing sample. REQUIRED	Change to required variable
		1 – Public health laboratory				1 – Public health laboratory
		2 – Commercial laboratory				2 – Commercial laboratory
		3 – Clinical setting (i.e., lead screening)				3 – Clinical setting (i.e., lead screening)
		9 – Unknown				9 – Unknown
44	SCRN_SITE	Type of provider ordering test, or screening site.		44	SCRN_SITE	Type of provider ordering test, or screening site. REQUIRED	Change to required variable
		1 – CLPPP fixed-site specific to lead				1 – CLPPP fixed-site specific to lead
		2 – Door to door program				2 – Door to door program
		3 – Other fixed-site screening program, e.g. WIC				3 – Other fixed-site screening program, e.g. WIC
		4 – Private health care provider				4 – Private health care provider
		5 – Referred for confirmation, no screening information				5 – Referred for confirmation, no screening information
		9 – Unknown/other				9 – Unknown/other
45	Medicaid	1 - Yes		45	METH_ANAZ	Laboratory method used to analyze sample. REQUIRED	Medicaid indicator variable removed
		2 - No				1 – Inductively coupled plasma mass spectrometry (ICP-MS)
		9 - Unknown				2 – Graphite furnace atomic absorption spectroscopy (GFAAS) (also known as Electrothermal Atomic Absorption Spectroscopy (ETAAS))	Laboratory method ("METH_ANAZ") used to analyze sample is a new variable.
						3 – Anodic Stripping Voltammetry (ASV) (e.g., LeadCare®)
						9 – Unknown
				46 to 51	METH_LOD	Limit of detection of METH_ANAZ. (000.00)	Limit of detection ("METH_LOD") is a new variable.
						See Note below.
46-53	SAMP_ANAZ_DT	Date sample analyzed by lab. (CCYYMMDD)		52 to 59	SAMP_ANAZ_DT	Date sample analyzed by lab. (CCYYMMDD)
		May not be prior to SAMP_DATE.				May not be prior to SAMP_DATE.
54 to 61	RSLT_RPT_DT	Date results reported to/received by health department. (CCYYMMDD)		60 to 67	RSLT_RPT_DT	Date results reported to/received by health department. (CCYYMMDD)
		May not be prior to SAMP_DATE.				May not be prior to SAMP_DATE.
				68 to 73	RESULT	Sample result measured in µg/dL. (000.00) REQUIRED	Sample result variable moved from position 37-39 to positions 68-73 to accommodate change from whole number to two decimal points
						See Note below.
				74	RST_INTPCODE	Numeric result comparator (result interpretation code). REQUIRED	Numeric result comparator ("RST_INTPCODE") is a new variable.
						1 – Equal
						2 – Less Than
						3 – Greater Than
				75 to 80	LAB_LOD	Limit of detection of the lab that performed the results. (000.00)	Limit of detection of the lab ("LAB_LOD") is a new variable.
						Only need for “No Result” test.
						See Note below.
				74 to 123	LAB_NAME	Name of Laboratory that reported result	Name of laboratory reporting results ("LAB_NAME") is a new variable.
				124 to 134	LAB_ID	Clinical Laboratory Improvement Amendment (CLIA) Number of laboratory	CLIA number ("LAB_ID") is a new variable.
				135 to 144	NPI	National Provider Identifier or NPI is a unique 10-digit identification number issued to health care providers in the United States by the Centers for Medicare and Medicaid Services (CMS).	NPI is a new variable.
				Note: Laboratory sample results and limits of detection (LODs) should all be shown right-justified, zero-filled on the left, and formatted with two decimal positions. If no decimal value, format with decimal and zero (000.00).
Table: 4				Table: 4
Record Type: Investigation				Record Type: Investigation
FILEID: INV				FILEID: INV
Position	Field Name	Valid Values - Description		Position	Field Name	Valid Values - Description
1 to 3	FILEID	INV – Investigation. REQUIRED		1 to 3	FILEID	INV – Investigation. REQUIRED
		File identifier for record type.				File identifier for record type.
4	ACTION	Database action code. REQUIRED		4	ACTION	Database action code. REQUIRED
		A - Add record				A - Add record
		C - Change/replace				C - Change/replace
		D - Delete				D - Delete
5	QTR	Reporting quarter. All annual submissions should be “4" for fourth quarter. REQUIRED		5	QTR	Reporting quarter. All annual submissions should be “4" for fourth quarter. REQUIRED
		1 - First quarter (1/01/yy - 3/31/yy)				1 - First quarter (1/01/yy - 3/31/yy)
		2 - Second quarter (4/01/yy - 6/30/yy)				2 - Second quarter (4/01/yy - 6/30/yy)
		3 - Third quarter (7/01/yy - 9/30/yy)				3 - Third quarter (7/01/yy - 9/30/yy)
		4 - Fourth quarter (10/01/yy - 12/31/yy)				4 - Fourth quarter (10/01/yy - 12/31/yy)
6 to 7	RPT_YR	Reporting year. REQUIRED		6 to 7	RPT_YR	Reporting year. REQUIRED
		Last two digits of the reporting year.				Last two digits of the reporting year.
		Must be numeric.				Must be numeric.
8 to 12	PGMID	Program identifier. REQUIRED		8 to 12	PGMID	Program identifier. REQUIRED
		A unique identifier for the Awardee submitting the data, or for each lead reporting database within the Awardee jurisdiction.				A unique identifier for the Awardee submitting the data, or for each lead reporting database within the Awardee jurisdiction.
13 to 20	ADDR_ID	Address identifier. REQUIRED		13 to 20	ADDR_ID	Address identifier. REQUIRED
21 to 28	DATE_REF	Date address referred for investigation. (CCYYMMDD) REQUIRED		21 to 28	DATE_REF	Date address referred for investigation. (CCYYMMDD) REQUIRED
29 to 36	INSP_COMP	Date address investigation inspection completed. (CCYYMMDD)		29 to 36	INSP_COMP	Date address investigation inspection completed. (CCYYMMDD)
		May not be prior to DATE_REF.				May not be prior to DATE_REF.
37 to 44	ABAT_COMP	Date address hazard remediation or abatement completed. (CCYYMMDD)		37 to 44	ABAT_COMP	Date address hazard remediation or abatement completed. (CCYYMMDD)
		May not be prior to INSP_COMP.				May not be prior to INSP_COMP.
45 to 48	YEAR	Year the dwelling was constructed. (YYYY)		45 to 48	YEAR	Year the dwelling was constructed. (YYYY)
		Blank if unknown.				Blank if unknown.
		May not be after reporting year.				May not be after reporting year.
49	OWNERSHIP	Residential ownership status.		49	OWNERSHIP	Residential ownership status. REQUIRED	Change to required variable
		1 – Private, owner-occupied				1 – Private, owner-occupied
		2 – Rental, privately owned				2 – Rental, privately owned
		3 – Rental, publicly owned				3 – Rental, publicly owned
		4 – Rental, Section 8				4 – Rental, Section 8
		9 – Unknown				9 – Unknown
50	DWELL_TYPE	Type of dwelling.		50	DWELL_TYPE	Type of dwelling. REQUIRED	Change to required variable
		1 – Attached, single family				1 – Attached, single family
		2 – Day care center				2 – Day care center
		3 – Detached, single family				3 – Detached, single family
		4 – Multi-unit				4 – Multi-unit
		5 – School				5 – School
		8 – Other				8 – Other
		9 – Unknown				9 – Unknown
51	PAINT_HAZ	Dwelling with peeling, chipping, or flaking paint.		51	PAINT_HAZ	Dwelling with peeling, chipping, or flaking paint. REQUIRED	Change to required variable
		1 – Yes, interior				1 – Yes, interior
		2 – Yes, exterior				2 – Yes, exterior
		3 – Yes, both				3 – Yes, both
		4 – No				4 – No
		9 – Not inspected				9 – Not inspected
		Must be 9 if INSP_COMP is blank.				Must be 9 if INSP_COMP is blank.
52 to 56	XRF	Highest XRF reading in mg/cm2. (000.0)		52 to 56	XRF	Highest XRF reading in mg/cm2. (000.0)
		See Note below.				See Note below.
57 to 64	DUST_FLOOR	Highest floor dust sample reading. (000000.0)		57 to 64	DUST_FLOOR	Highest floor dust sample reading. (000000.0)
		See Note below.				See Note below.
65	FLOOR_MSR	Unit of measure.		65	FLOOR_MSR	Unit of measure.
		U – mg/ft2				U – mg/ft2
		P – ppm				P – ppm
		Cannot be blank if DUST_FLOOR > 0.				Cannot be blank if DUST_FLOOR > 0.
66 to 73	DUST_SILL	Highest window sill dust sample reading. (000000.0)		66 to 73	DUST_SILL	Highest window sill dust sample reading. (000000.0)
		See Note below.				See Note below.
74	SILL_MSR	Unit of measure.		74	SILL_MSR	Unit of measure.
		U – mg/ft2				U – mg/ft2
		P – ppm				P – ppm
		Cannot be blank if DUST_SILL > 0.				Cannot be blank if DUST_SILL > 0.
75 to 82	DUST_WELL	Highest window well dust sample reading. (000000.0)		75 to 82	DUST_WELL	Highest window well dust sample reading. (000000.0)
		See Note below.				See Note below.
83	WELL_MSR	Unit of measure.		83	WELL_MSR	Unit of measure.
		U – mg/ft2				U – mg/ft2
		P – ppm				P – ppm
		Cannot be blank if DUST_WELL > 0.				Cannot be blank if DUST_WELL > 0.
84 to 91	PAINT	Highest paint chip sample reading. (000000.0)		84 to 91	PAINT	Highest paint chip sample reading. (000000.0)
		See Note below.				See Note below.
92	PAINT_MSR	Unit of measure.		92	PAINT_MSR	Unit of measure.
		U – mg/ft2				U – mg/ft2
		P – ppm				P – ppm
		M – mg/cm2				M – mg/cm2
		Cannot be blank if PAINT > 0.				Cannot be blank if PAINT > 0.
93 to 100	SOIL	Highest soil sample reading in ppm. (000000.0)		93 to 100	SOIL	Highest soil sample reading in ppm. (000000.0)
		See Note below.				See Note below.
101 to 108	WATER	Highest water sample reading in ppb. (000000.0)		101 to 108	WATER	Highest water sample reading in ppb. (000000.0)
		See Note below.				See Note below.
109	INDHAZ	Industrial hazard near dwelling.		109	INDHAZ	Industrial hazard near dwelling.
		1 – Yes				1 – Yes
		2 – No				2 – No
		9 – Unknown				9 – Unknown
				110 to 117	DATE_DUE	Date remediation due. (CCYYMMDD)	Date remediation due ("DATE_DUE") is a new variable
				118	INV_CLOS_RES	Investigation closure reason.	Investigation closure reason ("INV_CLOS_RES") is a new variable
						A – Administratively closed
						B – Batch closed
						C – Remediation complete
						D – Unit demolished
						F – Insufficient funds
						I – Permanent injunction
						M – Family moved
						N - No hazard found
						R – Inspection refused
						U – No longer rental unit
				119 to 126	CLEAR_DATE	Date clearance testing completed. (CCYYMMDD)	Date clearance testing completed ("CLEAR_DATE") is a new variable.
				127	CLEAR_RSLT	Clearance Testing Results	Clearance testing results ("CLEAR_RSLT") is a new variable.
						1 – Passed
						2 – Failed
						9 – Unknown
Table: 6				Table: 5			Moved LINK Record to Table 5
Record Type: Child-to-address link (Optional record type)				Record Type: Child-to-address link (Optional record type)
FILEID: LNK				FILEID: LNK
Position	Field Name	Valid Values - Description		Position	Field Name	Valid Values - Description
1 to 3	FILEID	LNK – Child-to-Address Link. REQUIRED		1 to 3	FILEID	LNK – Child-to-Address Link. REQUIRED
		File identifier for record type.				File identifier for record type.
4	ACTION	Database action code. REQUIRED		4	ACTION	Database action code. REQUIRED
		A - Add record				A - Add record
		C - Change/replace				C - Change/replace
		D - Delete				D - Delete
5	QTR	Reporting quarter. All annual submissions should be “4" for fourth quarter. REQUIRED		5	QTR	Reporting quarter. All annual submissions should be “4" for fourth quarter. REQUIRED
		1 - First quarter (1/01/yy - 3/31/yy)				1 - First quarter (1/01/yy - 3/31/yy)
		2 - Second quarter (4/01/yy - 6/30/yy)				2 - Second quarter (4/01/yy - 6/30/yy)
		3 - Third quarter (7/01/yy - 9/30/yy)				3 - Third quarter (7/01/yy - 9/30/yy)
		4 - Fourth quarter (10/01/yy - 12/31/yy)				4 - Fourth quarter (10/01/yy - 12/31/yy)
6 to 7	RPT_YR	Reporting year. REQUIRED		6 to 7	RPT_YR	Reporting year. REQUIRED
		Last two digits of the reporting year.				Last two digits of the reporting year.
		Must be numeric.				Must be numeric.
8 to 12	PGMID	Program identifier. REQUIRED		8 to 12	PGMID	Program identifier. REQUIRED
		A unique identifier for the Awardee submitting the data, or for each lead reporting database within the Awardee jurisdiction.				A unique identifier for the Awardee submitting the data, or for each lead reporting database within the Awardee jurisdiction.
13 to 20	CHILD_ID	Child identifier. REQUIRED		13 to 20	CHILD_ID	Child identifier. REQUIRED
21 to 28	ADDR_ID	Address identifier. REQUIRED		21 to 28	ADDR_ID	Address identifier. REQUIRED
29	TYPE_ADDR	Type of Address.		29	TYPE_ADDR	Type of Address. REQUIRED	Change to required variable
		1 – Primary address				1 – Primary address
		2 – Relocation address				2 – Relocation address
		3 – Alternative				3 – Alternative
		4 – Supplemental				4 – Supplemental
		9 – Unknown				9 – Unknown
30 to 37	FIRST_OCC	Date the child first occupied or began spending time at address. (CCYYMMDD) REQUIRED		30 to 37	FIRST_OCC	Date the child first occupied or began spending time at address. (CCYYMMDD) REQUIRED	Change to required variable
		May not be after the end of the reporting period.				May not be after the end of the reporting period.
38 to 45	LAST_OCC	Date the child moved from or ceased spending time at address. (CCYYMMDD)		38 to 45	LAST_OCC	Date the child moved from or ceased spending time at address. (CCYYMMDD)
		May not be prior to FIRST_OCC.				May not be prior to FIRST_OCC.