RULE-7429

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	ELG00010
Data Element Name	MFP-INFORMATION.SUBMITTING-STATE • ELIGIBILITY-DETERMINANTS.PRIMARY-ELIGIBILITY-GROUP-IND • MFP-INFORMATION.MFP-ENROLLMENT-EFF-DATE • MFP-INFORMATION.MFP-ENROLLMENT-END-DATE • ELIGIBILITY-DETERMINANTS.ELIGIBILITY-DETERMINANT-EFF-DATE • ELIGIBILITY-DETERMINANTS.ELIGIBILITY-DETERMINANT-END-DATE • FILE-HEADER-RECORD-ELIGIBILITY.END-OF-TIME-PERIOD • MFP-INFORMATION.MSIS-IDENTIFICATION-NUM • ELIGIBILITY-DETERMINANTS.RESTRICTED-BENEFITS-CODE
Validation Logic	if MFP-INFORMATION has a non-null value for MSIS-IDENTIFICATION-NUM, then for every record of type MFP-INFORMATION, there must be a valid record of type ELIGIBILITY-DETERMINANTS that matches on the join keys and (MFP-INFORMATION.MFP-ENROLLMENT-EFF-DATE >= ELIGIBILITY-DETERMINANTS.ELIGIBILITY-DETERMINANT-EFF-DATE and MFP-INFORMATION.MFP-ENROLLMENT-END-DATE <= ELIGIBILITY-DETERMINANTS.ELIGIBILITY-DETERMINANT-END-DATE), and ELIGIBILITY-DETERMINANTS.PRIMARY-ELIGIBILITY-GROUP-IND equals '1' and ELIGIBILITY-DETERMINANTS.RESTRICTED-BENEFITS-CODE equals 'D'
Rule Definition	If MSIS ID is populated on an mfp information segment from an ELG file, then the effective date and end date on the mfp information segment must fall within the effective and end dates of one or more continuous eligibility determinants segments and the primary eligibility group indicator is equal to '1' and the restricted benefits code must be for Medicaid Money Follows the Person (MFP) rebalancing demonstration on the eligibility determinants segment.
Denominator Logic	# of MFP-INFORMATION segments with MFP-INFORMATION 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-7429	ADD	Data Dictionary - Validation Rules	N/A	if MFP-INFORMATION has a non-null value for MSIS-IDENTIFICATION-NUM then for every record of type MFP-INFORMATION, there must be a valid record of type ELIGIBILITY-DETERMINANTS that matches on the join keys (SUBMITTING-STATE, MSIS-IDENTIFICATION-NUM) and (MFP-INFORMATION.MFP-ENROLLMENT-EFF-DATE is greater than or equal to ELIGIBILITY-DETERMINANTS.ELIGIBILITY-DETERMINANT-EFF-DATE and MFP-INFORMATION.MFP-ENROLLMENT-END-DATE is less than or equal to ELIGIBILITY-DETERMINANTS.ELIGIBILITY-DETERMINANT-END-DATE), and ELIGIBILITY-DETERMINANTS.PRIMARY-ELIGIBILITY-GROUP-IND is equal to '1' and ELIGIBILITY-DETERMINANTS.RESTRICTED-BENEFITS-CODE is equal to 'D'
01/28/2022	3.0.0	RULE-7429	UPDATE	Data Dictionary - Validation Rules	if MFP-INFORMATION has a non-null value for MSIS-IDENTIFICATION-NUM then for every record of type MFP-INFORMATION, there must be a valid record of type ELIGIBILITY-DETERMINANTS that matches on the join keys (SUBMITTING-STATE, MSIS-IDENTIFICATION-NUM) and (MFP-INFORMATION.MFP-ENROLLMENT-EFF-DATE is greater than or equal to ELIGIBILITY-DETERMINANTS.ELIGIBILITY-DETERMINANT-EFF-DATE and MFP-INFORMATION.MFP-ENROLLMENT-END-DATE is less than or equal to ELIGIBILITY-DETERMINANTS.ELIGIBILITY-DETERMINANT-END-DATE), and ELIGIBILITY-DETERMINANTS.PRIMARY-ELIGIBILITY-GROUP-IND is equal to '1' and ELIGIBILITY-DETERMINANTS.RESTRICTED-BENEFITS-CODE is equal to 'D'	if MFP-INFORMATION has a non-null value for MSIS-IDENTIFICATION-NUM, then for every record of type MFP-INFORMATION, there must be a valid record of type ELIGIBILITY-DETERMINANTS that matches on the join keys and (MAX(MFP-INFORMATION.MFP-ENROLLMENT-EFF-DATE, null) >= ELIGIBILITY-DETERMINANTS.ELIGIBILITY-DETERMINANT-EFF-DATE and MFP-INFORMATION.MFP-ENROLLMENT-END-DATE <= ELIGIBILITY-DETERMINANTS.ELIGIBILITY-DETERMINANT-END-DATE), and ELIGIBILITY-DETERMINANTS.PRIMARY-ELIGIBILITY-GROUP-IND equals '1' and ELIGIBILITY-DETERMINANTS.RESTRICTED-BENEFITS-CODE equals 'D'