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

Validation Rule
Last updated

No Updates

Tier 3.0
Tier Description Relational error
Error Category E3001
Error Category Message Missing corresponding record (2 record types, multi file) (ex. missing eligibility record for claim header)
Rule Type Two Record Type (1 to 1)
File Segment Number ELG00021
Data Element Name INDIVIDUAL-HEALTH-INSURANCE-PREMIUM-PAYMENT.SUBMITTING-STATE • INDIVIDUAL-HEALTH-INSURANCE-PREMIUM-PAYMENT.MSIS-IDENTIFICATION-NUM • ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-EFF-DATE • ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-END-DATE • INDIVIDUAL-HEALTH-INSURANCE-PREMIUM-PAYMENT.PREMIUM-PERIOD-START-DATE
Validation Logic if INDIVIDUAL-HEALTH-INSURANCE-PREMIUM-PAYMENT has a valid, non-null value for MSIS-IDENTIFICATION-NUM and INDIVIDUAL-HEALTH-INSURANCE-PREMIUM-PAYMENT.ADJUSTMENT-IND does not equal '1', then for every record of type INDIVIDUAL-HEALTH-INSURANCE-PREMIUM-PAYMENT, there must be a valid record of type ENROLLMENT-TIME-SPAN-SEGMENT that matches on the join keys(ENROLLMENT-TIME-SPAN-SEGMENT[SUBMITTING-STATE, MSIS-IDENTIFICATION-NUM], INDIVIDUAL-HEALTH-INSURANCE-PREMIUM-PAYMENT[SUBMITTING-STATE, MSIS-IDENTIFICATION-NUM]) and INDIVIDUAL-HEALTH-INSURANCE-PREMIUM-PAYMENT.PREMIUM-PERIOD-START-DATE must be in (ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-EFF-DATE, ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-END-DATE)
Rule Definition If a financial transaction is a non-void, and the MSIS ID is populated on Individual Health Insurance Premium Payment segment, then the MSIS ID value reported must be equal to a submitting state MSIS ID on a enrollment time span segment from a ELG file where the effective and end dates of the enrollment time span segment overlap with the premium period start date on the financial transaction.
Denominator Logic # of FTX Individual Health Insurance Premium Payment Transactions with INDIVIDUAL-HEALTH-INSURANCE-PREMIUM-PAYMENT has a valid, non-null value for MSIS-ID and with INDIVIDUAL-HEALTH-INSURANCE-PREMIUM-PAYMENT.ADJUSTMENT-IND does not equal to '1'