RULE-7532

Tier	2.0
Tier Description	Relational error
Error Category	E2001
Error Category Message	Values inconsistently specified (single record type, single record)
Rule Type	One Record Type (Single Record)
File Segment Number	ELG00004
Data Element Name	ELIGIBLE-CONTACT-INFORMATION.ELIGIBLE-COUNTY-CODE • ELIGIBLE-CONTACT-INFORMATION.ELIGIBLE-STATE
Validation Logic	'if ELIGIBLE-CONTACT-INFORMATION has a non-null value for MSIS-IDENTIFICATION-NUM and ELIGIBLE-CONTACT-INFORMATION has a non-null value for ELIGIBLE-COUNTY-CODE, then the concatenation of ELIGIBLE-CONTACT-INFORMATION.ELIGIBLE-STATE and ELIGIBLE-CONTACT-INFORMATION.ELIGIBLE-COUNTY-CODE must be contained in the set of valid values with id: 'COUNTY' and (if ELIGIBLE-CONTACT-INFORMATION.ELIGIBLE-ADDR-EFF-DATE is non-null then ELIGIBLE-CONTACT-INFORMATION.ELIGIBLE-ADDR-EFF-DATE >= Valid Values Effective-Date and ELIGIBLE-CONTACT-INFORMATION.ELIGIBLE-ADDR-EFF-DATE <= Valid Values End-Date)'
Rule Definition	If the MSIS ID is populated on a eligible contact information segment from an ELG file, then the eligible county code is in the eligible state.
Denominator Logic	# of ELIGIBLE-CONTACT-INFORMATION segments with ELIGIBLE-CONTACT-INFORMATION has a non-null value for MSIS-IDENTIFICATION-NUM and with ELIGIBLE-CONTACT-INFORMATION has a non-null value for ELIGIBLE-COUNTY-CODE

Published Date	Data Guide Version	Validation Rule	Action	Field	Before	After
08/11/2023	3.11.0	RULE-7532	UPDATE	Data Dictionary - Validation Rules	if ELIGIBLE-CONTACT-INFORMATION has a non-null value for MSIS-IDENTIFICATION-NUM, then ELIGIBLE-CONTACT-INFORMATION has a non-null value for ELIGIBLE-COUNTY-CODE and the concatenation of ELIGIBLE-CONTACT-INFORMATION.ELIGIBLE-STATE and ELIGIBLE-CONTACT-INFORMATION.ELIGIBLE-COUNTY-CODE must be contained in the set of valid values with id: 'COUNTY' and (if ELIGIBLE-CONTACT-INFORMATION.ELIGIBLE-ADDR-EFF-DATE is non-null then ELIGIBLE-CONTACT-INFORMATION.ELIGIBLE-ADDR-EFF-DATE >= Valid Values Effective-Date and ELIGIBLE-CONTACT-INFORMATION.ELIGIBLE-ADDR-EFF-DATE <= Valid Values End-Date)and ELIGIBLE-CONTACT-INFORMATION has a non-null value for ELIGIBLE-ZIP-CODE and the concatenation of ELIGIBLE-CONTACT-INFORMATION.ELIGIBLE-STATE and substring(ELIGIBLE-CONTACT-INFORMATION.ELIGIBLE-ZIP-CODE, 0, 5) must be contained in the set of valid values with id: 'ZIP-CODE' and (if ELIGIBLE-CONTACT-INFORMATION.ELIGIBLE-ADDR-EFF-DATE is non-null then ELIGIBLE-CONTACT-INFORMATION.ELIGIBLE-ADDR-EFF-DATE >= Valid Values Effective-Date and ELIGIBLE-CONTACT-INFORMATION.ELIGIBLE-ADDR-EFF-DATE <= Valid Values End-Date)'	f ELIGIBLE-CONTACT-INFORMATION has a non-null value for MSIS-IDENTIFICATION-NUM, and ELIGIBLE-CONTACT-INFORMATION has a non-null value for ELIGIBLE-COUNTY-CODE then the concatenation of ELIGIBLE-CONTACT-INFORMATION.ELIGIBLE-STATE and ELIGIBLE-CONTACT-INFORMATION.ELIGIBLE-COUNTY-CODE must be contained in the set of valid values with id: 'COUNTY' and (if ELIGIBLE-CONTACT-INFORMATION.ELIGIBLE-ADDR-EFF-DATE is non-null then ELIGIBLE-CONTACT-INFORMATION.ELIGIBLE-ADDR-EFF-DATE >= Valid Values Effective-Date and ELIGIBLE-CONTACT-INFORMATION.ELIGIBLE-ADDR-EFF-DATE <= Valid Values End-Date)
05/12/2023	3.7.0	RULE-7532	ADD	Data Dictionary - Validation Rules	N/A	if ELIGIBLE-CONTACT-INFORMATION has a non-null value for MSIS-IDENTIFICATION-NUM, then ELIGIBLE-CONTACT-INFORMATION has a non-null value for ELIGIBLE-COUNTY-CODE and the concatenation of ELIGIBLE-CONTACT-INFORMATION.ELIGIBLE-STATE and ELIGIBLE-CONTACT-INFORMATION.ELIGIBLE-COUNTY-CODE must be contained in the set of valid values with id: 'COUNTY' and (if ELIGIBLE-CONTACT-INFORMATION.ELIGIBLE-ADDR-EFF-DATE is non-null then ELIGIBLE-CONTACT-INFORMATION.ELIGIBLE-ADDR-EFF-DATE >= Valid Values Effective-Date and ELIGIBLE-CONTACT-INFORMATION.ELIGIBLE-ADDR-EFF-DATE <= Valid Values End-Date) and ELIGIBLE-CONTACT-INFORMATION has a non-null value for ELIGIBLE-ZIP-CODE and the concatenation of ELIGIBLE-CONTACT-INFORMATION.ELIGIBLE-STATE and substring(ELIGIBLE-CONTACT-INFORMATION.ELIGIBLE-ZIP-CODE, 0, 5) must be contained in the set of valid values with id: 'ZIP-CODE' and (if ELIGIBLE-CONTACT-INFORMATION.ELIGIBLE-ADDR-EFF-DATE is non-null then ELIGIBLE-CONTACT-INFORMATION.ELIGIBLE-ADDR-EFF-DATE >= Valid Values Effective-Date and ELIGIBLE-CONTACT-INFORMATION.ELIGIBLE-ADDR-EFF-DATE <= Valid Values End-Date)