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.

TMSIS Dataguide Medicaid.gov

Version:

3.40.0

RULE-7538

Validation Rule
Last updated

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.MSIS-IDENTIFICATION-NUM • ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-EFF-DATE • ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-END-DATE • PRIMARY-DEMOGRAPHICS-ELIGIBILITY.PRIMARY-DEMOGRAPHIC-ELEMENT-EFF-DATE • PRIMARY-DEMOGRAPHICS-ELIGIBILITY.PRIMARY-DEMOGRAPHIC-ELEMENT-END-DATE • FILE-HEADER-RECORD-ELIGIBILITY.END-OF-TIME-PERIOD
Validation Logic if ENROLLMENT-TIME-SPAN-SEGMENT has a non-null value for MSIS-IDENTIFICATION-NUM and ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-END-DATE is greater than or equal to 'cutover date', then for every record of type ENROLLMENT-TIME-SPAN-SEGMENT, there must be a valid record of type PRIMARY-DEMOGRAPHICS-ELIGIBILITY that matches on the join keys and (MAX(ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-EFF-DATE, null) >= PRIMARY-DEMOGRAPHICS-ELIGIBILITY.PRIMARY-DEMOGRAPHIC-ELEMENT-EFF-DATE and ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-END-DATE <= PRIMARY-DEMOGRAPHICS-ELIGIBILITY.PRIMARY-DEMOGRAPHIC-ELEMENT-END-DATE)
Rule Definition If MSIS ID is populated on an enrollment time span segment from an ELG file and enrollment time span end date is greater than the states T-MSIS cutover date, 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 primary demographics eligibility segments and the MSIS ID is populated in the primary demographics eligibility segment.
Denominator Logic # of ENROLLMENT-TIME-SPAN segments with ENROLLMENT-TIME-SPAN has a non-null value for MSIS-IDENTIFICATION-NUM and with ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-END-DATE is greater than or equal to 'cutover date'