RULE-7191

Tier	2.1
Tier Description	Relational error
Error Category	E2101
Error Category Message	Missing parent record (single file)
Rule Type	Two Record Type (1 to 1)
File Segment Number	ELG00021
Data Element Name	ENROLLMENT-TIME-SPAN-SEGMENT.SUBMITTING-STATE • VARIABLE-DEMOGRAPHICS-ELIGIBILITY.CHIP-CODE • ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-EFF-DATE • ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-END-DATE • VARIABLE-DEMOGRAPHICS-ELIGIBILITY.VARIABLE-DEMOGRAPHIC-ELEMENT-EFF-DATE • VARIABLE-DEMOGRAPHICS-ELIGIBILITY.VARIABLE-DEMOGRAPHIC-ELEMENT-END-DATE • FILE-HEADER-RECORD-ELIGIBILITY.END-OF-TIME-PERIOD • ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-TYPE • ENROLLMENT-TIME-SPAN-SEGMENT.MSIS-IDENTIFICATION-NUM
Validation Logic	if ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-TYPE equals '1', then for every record of type ENROLLMENT-TIME-SPAN-SEGMENT, there must be a valid record of type VARIABLE-DEMOGRAPHICS-ELIGIBILITY that matches on the join keys and (ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-EFF-DATE >= VARIABLE-DEMOGRAPHICS-ELIGIBILITY.VARIABLE-DEMOGRAPHIC-ELEMENT-EFF-DATE and ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-END-DATE <= VARIABLE-DEMOGRAPHICS-ELIGIBILITY.VARIABLE-DEMOGRAPHIC-ELEMENT-END-DATE), and VARIABLE-DEMOGRAPHICS-ELIGIBILITY.CHIP-CODE is equal to one of the following: '1', '2'
Rule Definition	If enrollment type is for Medicaid or Medicaid expansion CHIP on an enrollment time span segment from an ELG file, then the effective date and end date on the enrollment time span segment must fall within the effective and end dates of one or more continuous variable demographics eligibility segments and the CHIP code must be for Medicaid or Medicaid expansion CHIP on the variable demographic eligibility segment.
Denominator Logic	# of ENROLLMENT-TIME-SPAN segments with ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-TYPE equals '1'

Published Date	Data Guide Version	Validation Rule	Action	Field	Before	After
12/13/2019	2.3.0	RULE-7191	UPDATE	Data Dictionary - Validation Rules	IF ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-TYPE = "1" Then VARIABLE-DEMOGRAPHICS-ELIGIBILITY.CHIP-CODE must be in ("1","2") For every record of type ENROLLMENT-TIME-SPAN-SEGMENT, there must be a valid record of type VARIABLE-DEMOGRAPHICS-ELIGIBILITY that matches on the join keys (SUBMITTING-STATE, MSIS-IDENTIFICATION-NUM) AND VARIABLE-DEMOGRAPHICS-ELIGIBILITY.VARIABLE-DEMOGRAPHIC-ELEMENT-EFF-DATE >= ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-EFF-DATE and VARIABLE-DEMOGRAPHIC-ELEMENT-END-DATE <= ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-END-DATE	IF ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-TYPE = "1" Then VARIABLE-DEMOGRAPHICS-ELIGIBILITY.CHIP-CODE must be in ("1","2") For every record of type ENROLLMENT-TIME-SPAN-SEGMENT, there must be a valid record of type VARIABLE-DEMOGRAPHICS-ELIGIBILITY that matches on the join keys (SUBMITTING-STATE, MSIS-IDENTIFICATION-NUM) AND ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-EFF-DATE >= VARIABLE-DEMOGRAPHICS-ELIGIBILITY.VARIABLE-DEMOGRAPHIC-ELEMENT-EFF-DATE and ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-END-DATE <= VARIABLE-DEMOGRAPHICS-ELIGIBILITY.VARIABLE-DEMOGRAPHIC-ELEMENT-END-DATE
07/02/2021	3.0.0	RULE-7191	UPDATE	Data Dictionary - Validation Rules	if ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-TYPE equals '1', then for every record of type VARIABLE-DEMOGRAPHICS-ELIGIBILITY, there must be a valid record of type ENROLLMENT-TIME-SPAN-SEGMENT that matches on the join keys and (ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-EFF-DATE >= VARIABLE-DEMOGRAPHICS-ELIGIBILITY.VARIABLE-DEMOGRAPHIC-ELEMENT-EFF-DATE and ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-END-DATE <= VARIABLE-DEMOGRAPHICS-ELIGIBILITY.VARIABLE-DEMOGRAPHIC-ELEMENT-END-DATE), where VARIABLE-DEMOGRAPHICS-ELIGIBILITY.CHIP-CODE is equal to one of the following: '1', '2'	if ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-TYPE equals '1', then for every record of type ENROLLMENT-TIME-SPAN-SEGMENT, there must be a valid record of type VARIABLE-DEMOGRAPHICS-ELIGIBILITY that matches on the join keys and (ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-EFF-DATE >= VARIABLE-DEMOGRAPHICS-ELIGIBILITY.VARIABLE-DEMOGRAPHIC-ELEMENT-EFF-DATE and ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-END-DATE <= VARIABLE-DEMOGRAPHICS-ELIGIBILITY.VARIABLE-DEMOGRAPHIC-ELEMENT-END-DATE), where VARIABLE-DEMOGRAPHICS-ELIGIBILITY.CHIP-CODE is equal to one of the following: '1', '2'
01/28/2022	3.0.0	RULE-7191	UPDATE	Data Dictionary - Validation Rules	if ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-TYPE equals '1', then for every record of type ENROLLMENT-TIME-SPAN-SEGMENT, there must be a valid record of type VARIABLE-DEMOGRAPHICS-ELIGIBILITY that matches on the join keys and (ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-EFF-DATE >= VARIABLE-DEMOGRAPHICS-ELIGIBILITY.VARIABLE-DEMOGRAPHIC-ELEMENT-EFF-DATE and ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-END-DATE <= VARIABLE-DEMOGRAPHICS-ELIGIBILITY.VARIABLE-DEMOGRAPHIC-ELEMENT-END-DATE), where VARIABLE-DEMOGRAPHICS-ELIGIBILITY.CHIP-CODE is equal to one of the following: '1', '2'	if ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-TYPE equals '1', then for every record of type ENROLLMENT-TIME-SPAN-SEGMENT, there must be a valid record of type VARIABLE-DEMOGRAPHICS-ELIGIBILITY that matches on the join keys and (MAX(ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-EFF-DATE, null) >= VARIABLE-DEMOGRAPHICS-ELIGIBILITY.VARIABLE-DEMOGRAPHIC-ELEMENT-EFF-DATE and ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-END-DATE <= VARIABLE-DEMOGRAPHICS-ELIGIBILITY.VARIABLE-DEMOGRAPHIC-ELEMENT-END-DATE), and VARIABLE-DEMOGRAPHICS-ELIGIBILITY.CHIP-CODE is equal to one of the following: '1', '2'
08/30/2018	2.3.0	RULE-7191	UPDATE	Data Dictionary - Validation Rules	IF ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-TYPE = "1" Then VARIABLE-DEMOGRAPHICS-ELIGIBILITY.CHIP-CODE must be in ("1","2") For every record of type ENROLLMENT-TIME-SPAN-SEGMENT, there must be a valid record of type VARIABLE-DEMOGRAPHICS-ELIGIBILITY that matches on the join keys (SUBMITTING-STATE, MSIS-IDENTIFICATION-NUM) AND VARIABLE-DEMOGRAPHICS-ELIGIBILITY.VARIABLE-DEMOGRAPHIC-ELEMENT-EFF-DATE >= ENROLLMENT-TIME-SPAN-SEGMENT.EFF-DATE and VARIABLE-DEMOGRAPHIC-ELEMENT-END-DATE <= ENROLLMENT-TIME-SPAN-SEGMENT.END-DATE Note: The following data elements should be NOT NULL VARIABLE-DEMOGRAPHICS-ELIGIBILITY.VARIABLE-DEMOGRAPHIC-ELEMENT-EFF-DATE, VARIABLE-DEMOGRAPHICS-ELIGIBILITY.VARIABLE-DEMOGRAPHIC-ELEMENT-END-DATE, ENROLLMENT-TIME-SPAN-SEGMENT.EFF-DATE and ENROLLMENT-TIME-SPAN-SEGMENT.END-DATE	N/A
08/17/2018	2.3.0	RULE-7191	ADD	Data Dictionary - Validation Rules	N/A	IF ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-TYPE = "1" Then VARIABLE-DEMOGRAPHICS-ELIGIBILITY.CHIP-CODE must be in ("1","2") For every record of type ENROLLMENT-TIME-SPAN-SEGMENT, there must be a valid record of type VARIABLE-DEMOGRAPHICS-ELIGIBILITY that matches on the join keys (SUBMITTING-STATE, MSIS-IDENTIFICATION-NUM) AND VARIABLE-DEMOGRAPHICS-ELIGIBILITY.VARIABLE-DEMOGRAPHIC-ELEMENT-EFF-DATE >= ENROLLMENT-TIME-SPAN-SEGMENT.EFF-DATE and VARIABLE-DEMOGRAPHIC-ELEMENT-END-DATE <= ENROLLMENT-TIME-SPAN-SEGMENT.END-DATE Note: The following data elements should be NOT NULL VARIABLE-DEMOGRAPHICS-ELIGIBILITY.VARIABLE-DEMOGRAPHIC-ELEMENT-EFF-DATE, VARIABLE-DEMOGRAPHICS-ELIGIBILITY.VARIABLE-DEMOGRAPHIC-ELEMENT-END-DATE, ENROLLMENT-TIME-SPAN-SEGMENT.EFF-DATE and ENROLLMENT-TIME-SPAN-SEGMENT.END-DATE
11/23/2018	2.3.0	RULE-7191	UPDATE	Data Dictionary - Validation Rules	N/A	IF ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-TYPE = "1" Then VARIABLE-DEMOGRAPHICS-ELIGIBILITY.CHIP-CODE must be in ("1","2"). For every record of type ENROLLMENT-TIME-SPAN-SEGMENT, there must be a valid record of type VARIABLE-DEMOGRAPHICS-ELIGIBILITY that matches on the join keys (SUBMITTING-STATE, MSIS-IDENTIFICATION-NUM) AND VARIABLE-DEMOGRAPHICS-ELIGIBILITY.VARIABLE-DEMOGRAPHIC-ELEMENT-EFF-DATE >= ENROLLMENT-TIME-SPAN-SEGMENT.EFF-DATE and VARIABLE-DEMOGRAPHIC-ELEMENT-END-DATE <= ENROLLMENT-TIME-SPAN-SEGMENT.END-DATE Note: The following data elements should be NOT NULL VARIABLE-DEMOGRAPHICS-ELIGIBILITY.VARIABLE-DEMOGRAPHIC-ELEMENT-EFF-DATE, VARIABLE-DEMOGRAPHICS-ELIGIBILITY.VARIABLE-DEMOGRAPHIC-ELEMENT-END-DATE, ENROLLMENT-TIME-SPAN-SEGMENT.EFF-DATE and ENROLLMENT-TIME-SPAN-SEGMENT.END-DATE