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

RULE-2017

Validation Rule
Last updated

Tier 2.1
Tier Description Relational error
Error Category E2102
Error Category Message Values inconsistently specified (multi record, single file)
Rule Type Three Record Type Rule
File Segment Number ELG00002
Data Element Name PRIMARY-DEMOGRAPHICS-ELIGIBILITY.DATE-OF-BIRTH • ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-EFF-DATE
Validation Logic 'if ELIGIBILITY-DETERMINANTS.CONCEPTION-TO-BIRTH-IND does not equal '1' and ELIGIBILITY-DETERMINANTS.ELIGIBILITY-GROUP does not equal '64' and PRIMARY-DEMOGRAPHICS-ELIGIBILITY has a valid, non-null value for DATE-OF-BIRTH and ENROLLMENT-TIME-SPAN-SEGMENT has a valid, non-null value for ENROLLMENT-EFF-DATE, then the difference between dates PRIMARY-DEMOGRAPHICS-ELIGIBILITY.DATE-OF-BIRTH and ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-EFF-DATE is less than or equal to 125 years'
Rule Definition If conception-to-birth indicator is not for conception-to-birth coverage on a variable demographic segment from an ELG file and the eligibility group is not for conception-to-birth coverage on a corresponding eligiblity determinants segment from an ELG file, then the date of birth on the primary demographics segment must be less than or equal to 125 years before the effective date on any enrollment time span segment with the same MSIS ID.
Denominator Logic # of PRIMARY-DEMOGRAPHICS-ELIGIBILITY segments with PRIMARY-DEMOGRAPHICS-ELIGIBILITY.DATE-OF-BIRTH equal to a valid, non-null value AND with PRIMARY-DEMOGRAPHICS-ELIGIBILITY.PRIMARY-DEMOGRAPHIC-ELEMENT-EFF-DATE and PRIMARY-DEMOGRAPHICS-ELIGIBILITY.PRIMARY-DEMOGRAPHIC-ELEMENT-END-DATE that overlap ELIGIBILITY-DETERMINANTS.ELIGIBILITY-DETERMINANT-EFF-DATE and ELIGIBILITY-DETERMINANTS.ELIGIBILITY-DETERMINANT-END-DATE AND with ELIGIBILITY-DETERMINANTS.CONCEPTION-TO-BIRTH-IND not equal to '1' AND with ELIGIBILITY-DETERMINANTS.ELIGIBILITY-GROUP not equal to '64'