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-7423

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-DEATH • PRIMARY-DEMOGRAPHICS-ELIGIBILITY.DATE-OF-BIRTH • FILE-HEADER-RECORD-ELIGIBILITY.START-OF-TIME-PERIOD
Validation Logic 'if PRIMARY-DEMOGRAPHICS-ELIGIBILITY has a non-null value for MSIS-IDENTIFICATION-NUM and PRIMARY-DEMOGRAPHICS-ELIGIBILITY has a non-null and not invalidly formatted value for PRIMARY-DEMOGRAPHIC-ELEMENT-EFF-DATE and PRIMARY-DEMOGRAPHICS-ELIGIBILITY has a non-null and not invalidly formatted value for PRIMARY-DEMOGRAPHIC-ELEMENT-END-DATE and ENROLLMENT-TIME-SPAN-SEGMENT has a non-null value for MSIS-IDENTIFICATION-NUM and ENROLLMENT-TIME-SPAN-SEGMENT has a non-null and not invalidly formatted value for ENROLLMENT-EFF-DATE and ENROLLMENT-TIME-SPAN-SEGMENT has a non-null and not invalidly formatted value for ENROLLMENT-END-DATE and PRIMARY-DEMOGRAPHICS-ELIGIBILITY.PRIMARY-DEMOGRAPHIC-ELEMENT-EFF-DATE and PRIMARY-DEMOGRAPHICS-ELIGIBILITY.PRIMARY-DEMOGRAPHIC-ELEMENT-END-DATE are overlapping with ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-EFF-DATE and ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-END-DATE and PRIMARY-DEMOGRAPHICS-ELIGIBILITY has a non-null and not invalidly formatted value for DATE-OF-BIRTH, then (PRIMARY-DEMOGRAPHICS-ELIGIBILITY has a non-null and not invalidly formatted value for DATE-OF-DEATH and (the difference between dates PRIMARY-DEMOGRAPHICS-ELIGIBILITY.DATE-OF-BIRTH and PRIMARY-DEMOGRAPHICS-ELIGIBILITY.DATE-OF-DEATH is less than or equal to 120 years and the difference between dates PRIMARY-DEMOGRAPHICS-ELIGIBILITY.DATE-OF-BIRTH and PRIMARY-DEMOGRAPHICS-ELIGIBILITY.DATE-OF-DEATH is greater than or equal to -1 years)) or (PRIMARY-DEMOGRAPHICS-ELIGIBILITY has a null value for DATE-OF-DEATH and (the difference between dates PRIMARY-DEMOGRAPHICS-ELIGIBILITY.DATE-OF-BIRTH and FILE-HEADER-RECORD-ELIGIBILITY.START-OF-TIME-PERIOD is less than or equal to 120 years and the difference between dates PRIMARY-DEMOGRAPHICS-ELIGIBILITY.DATE-OF-BIRTH and FILE-HEADER-RECORD-ELIGIBILITY.START-OF-TIME-PERIOD is greater than or equal to -1 years))'
Rule Definition If a primary demographics eligibility segment has a value populated for MSIS ID, date of death and date of birth, then the difference between the date of birth and date of death must be between -1 year and 120 years, or if the date of death is not populated, then the the difference between the date of birth and file header record eligibility segment start of time period is between -1 years and 120 years.
Denominator Logic # of PRIMARY-DEMOGRAPHICS-ELIGIBILITY segments with PRIMARY-DEMOGRAPHICS-ELIGIBILITY has a non-null value for MSIS-IDENTIFICATION-NUM and PRIMARY-DEMOGRAPHICS-ELIGIBILITY.PRIMARY-DEMOGRAPHIC-ELEMENT-EFF-DATE has non-null and not invalidly formatted value and PRIMARY-DEMOGRAPHICS-ELIGIBILITY.PRIMARY-DEMOGRAPHIC-ELEMENT-END-DATE has non-null and not invalidly formatted value and ENROLLMENT-TIME-SPAN-ELG00021 has a non-null value for MSIS-IDENTIFICATION-NUM and ENROLLMENT-TIME-SPAN-ELG00021.ENROLLMENT-EFF-DATE has non-null and not invalidly formatted value and ENROLLMENT-TIME-SPAN-ELG00021.ENROLLMENT-END-DATE has non-null and not invalidly formatted value and PRIMARY-DEMOGRAPHICS-ELIGIBILITY.PRIMARY-DEMOGRAPHIC-ELEMENT-EFF-DATE is less than or equal to ENROLLMENT-TIME-SPAN-ELG00021.ENROLLMENT-END-DATE and PRIMARY-DEMOGRAPHICS-ELIGIBILITY.PRIMARY-DEMOGRAPHIC-ELEMENT-END-DATE is greater than or equal to ENROLLMENT-TIME-SPAN-ELG00021.ENROLLMENT-EFF-DATE