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.38.0

RULE-7191

Validation Rule
Last updated

No Updates

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 • 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
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'