RULE-7192

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 '2', 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 equals '3'
Rule Definition	If enrollment type is for S-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 S-CHIP on the variable demographic eligibility segment.
Denominator Logic	# of ENROLLMENT-TIME-SPAN segments with ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-TYPE equals '2'

Published Date	Data Guide Version	Validation Rule	Action	Field	Before	After
12/13/2019	2.3.0	RULE-7192	UPDATE	Data Dictionary - Validation Rules	if ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-TYPE equals '2', 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 (VARIABLE-DEMOGRAPHICS-ELIGIBILITY.VARIABLE-DEMOGRAPHIC-ELEMENT-EFF-DATE, VARIABLE-DEMOGRAPHICS-ELIGIBILITY.VARIABLE-DEMOGRAPHIC-ELEMENT-END-DATE) must be in (ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-EFF-DATE, ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-END-DATE), where VARIABLE-DEMOGRAPHICS-ELIGIBILITY.CHIP-CODE is equal to one of the following: '3'	IF ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-TYPE = "2" Then VARIABLE-DEMOGRAPHICS-ELIGIBILITY.CHIP-CODE must be in ("3") 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-7192	UPDATE	Data Dictionary - Validation Rules	if ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-TYPE equals '2', 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 equals '3'	if ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-TYPE equals '2', 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 equals '3'
01/28/2022	3.0.0	RULE-7192	UPDATE	Data Dictionary - Validation Rules	if ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-TYPE equals '2', 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 equals '3'	if ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-TYPE equals '2', 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 equals '3'
08/30/2018	2.3.0	RULE-7192	UPDATE	Data Dictionary - Validation Rules	IF ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-TYPE = "2" Then VARIABLE-DEMOGRAPHICS-ELIGIBILITY.CHIP-CODE must be equal to "3" 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-7192	ADD	Data Dictionary - Validation Rules	N/A	IF ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-TYPE = "2" Then VARIABLE-DEMOGRAPHICS-ELIGIBILITY.CHIP-CODE must be equal to "3" 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-7192	UPDATE	Data Dictionary - Validation Rules	N/A	IF ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-TYPE = "2" Then VARIABLE-DEMOGRAPHICS-ELIGIBILITY.CHIP-CODE must be equal to "3". 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