RULE-7539

An official website of the United States government

Official websites use .gov
A .gov website belongs to an official government organization in the United States.

Secure .gov websites use HTTPS
A lock () or https:// means you've safely connected to the .gov website. Share sensitive information only on official, secure websites.

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 • 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.MSIS-IDENTIFICATION-NUM
Validation Logic	if ENROLLMENT-TIME-SPAN-SEGMENT has a non-null value for MSIS-IDENTIFICATION-NUM, 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)
Rule Definition	If MSIS ID is populated 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 MSIS ID is populated in the variable demographics eligibility segment.
Denominator Logic	# of ENROLLMENT-TIME-SPAN segments with ENROLLMENT-TIME-SPAN has a non-null value for MSIS-IDENTIFICATION-NUM

Published Date	Data Guide Version	Validation Rule	Action	Field	Before	After
07/02/2021	3.0.0	RULE-7539	ADD	Data Dictionary - Validation Rules	N/A	if ENROLLMENT-TIME-SPAN has a non-null value for MSIS-IDENTIFICATION-NUM then for every record of type ENROLLMENT-TIME-SPAN, 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.ENROLLMENT-EFF-DATE is greater than or equal to VARIABLE-DEMOGRAPHICS-ELIGIBILITY.VARIABLE-DEMOGRAPHIC-ELEMENT-EFF-DATE and ENROLLMENT-TIME-SPAN.ENROLLMENT-END-DATE is less than or equal to VARIABLE-DEMOGRAPHICS-ELIGIBILITY.VARIABLE-DEMOGRAPHIC-ELEMENT-END-DATE)
01/28/2022	3.0.0	RULE-7539	UPDATE	Data Dictionary - Validation Rules	if ENROLLMENT-TIME-SPAN has a non-null value for MSIS-IDENTIFICATION-NUM then for every record of type ENROLLMENT-TIME-SPAN, 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.ENROLLMENT-EFF-DATE is greater than or equal to VARIABLE-DEMOGRAPHICS-ELIGIBILITY.VARIABLE-DEMOGRAPHIC-ELEMENT-EFF-DATE and ENROLLMENT-TIME-SPAN.ENROLLMENT-END-DATE is less than or equal to VARIABLE-DEMOGRAPHICS-ELIGIBILITY.VARIABLE-DEMOGRAPHIC-ELEMENT-END-DATE)	if ENROLLMENT-TIME-SPAN-SEGMENT has a non-null value for MSIS-IDENTIFICATION-NUM, 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)