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

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 ELG00003
Data Element Name VARIABLE-DEMOGRAPHICS-ELIGIBILITY.SUBMITTING-STATE • ELIGIBILITY-DETERMINANTS.ELIGIBILITY-DETERMINANT-END-DATE • ELIGIBILITY-DETERMINANTS.PRIMARY-ELIGIBILITY-GROUP-IND • ELIGIBILITY-DETERMINANTS.ELIGIBILITY-GROUP • VARIABLE-DEMOGRAPHICS-ELIGIBILITY.VARIABLE-DEMOGRAPHIC-ELEMENT-EFF-DATE • VARIABLE-DEMOGRAPHICS-ELIGIBILITY.VARIABLE-DEMOGRAPHIC-ELEMENT-END-DATE • ELIGIBILITY-DETERMINANTS.ELIGIBILITY-DETERMINANT-EFF-DATE • FILE-HEADER-RECORD-ELIGIBILITY.END-OF-TIME-PERIOD • VARIABLE-DEMOGRAPHICS-ELIGIBILITY.CHIP-CODE • VARIABLE-DEMOGRAPHICS-ELIGIBILITY.MSIS-IDENTIFICATION-NUM
Validation Logic if VARIABLE-DEMOGRAPHICS-ELIGIBILITY.CHIP-CODE equals '2' and VARIABLE-DEMOGRAPHICS-ELIGIBILITY.VARIABLE-DEMOGRAPHIC-ELEMENT-END-DATE is greater than or equal to '2015-01-01', then for every record of type VARIABLE-DEMOGRAPHICS-ELIGIBILITY, there must be a valid record of type ELIGIBILITY-DETERMINANTS that matches on the join keys and (MAX(VARIABLE-DEMOGRAPHICS-ELIGIBILITY.VARIABLE-DEMOGRAPHIC-ELEMENT-EFF-DATE, '2015-01-01') >= ELIGIBILITY-DETERMINANTS.ELIGIBILITY-DETERMINANT-EFF-DATE and VARIABLE-DEMOGRAPHICS-ELIGIBILITY.VARIABLE-DEMOGRAPHIC-ELEMENT-END-DATE <= ELIGIBILITY-DETERMINANTS.ELIGIBILITY-DETERMINANT-END-DATE), and ELIGIBILITY-DETERMINANTS.ELIGIBILITY-DETERMINANT-END-DATE is greater than or equal to '2015-01-01' and ELIGIBILITY-DETERMINANTS.PRIMARY-ELIGIBILITY-GROUP-IND equals '1' and ELIGIBILITY-DETERMINANTS.ELIGIBILITY-GROUP is equal to one of the following: '07', '31', '61'
Rule Definition If a segment is a variable demographics eligibility segment from an ELG file, and the chip code is M-CHIP, then the max(variable demographics eligibility effective date, 2015-01-01) is greater than or equal to eligibility determinants effective date and the variable demographics eligibility end date is less than or equal to eligibility determinants end date and the eligibility determinants end date is greater than or equal to '2015-01-01' and the primary eligibility group indicator is equal to '1' and the eligibility group is equal to '07', '31', or '61'
Denominator Logic # of VARIABLE-DEMOGRAPHICS-ELIGIBILITY segments with VARIABLE-DEMOGRAPHICS-ELIGIBILITY.CHIP-CODE is equal to '2'