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

RULE-2357

Validation Rule
Last updated

Tier 3.0
Tier Description Relational error
Error Category E3002
Error Category Message Values inconsistently specified (multiple record types, multi file)
Rule Type Two Record Type (1 to 1)
File Segment Number ELG00013
Data Element Name LTSS-PARTICIPATION.SUBMITTING-STATE • LTSS-PARTICIPATION.LTSS-PROV-NUM • LTSS-PARTICIPATION.LTSS-ELIGIBILITY-EFF-DATE • LTSS-PARTICIPATION.LTSS-ELIGIBILITY-END-DATE • PROV-IDENTIFIERS.PROV-IDENTIFIER-EFF-DATE • PROV-IDENTIFIERS.PROV-IDENTIFIER-END-DATE • FILE-HEADER-RECORD-ELIGIBILITY.END-OF-TIME-PERIOD
Validation Logic if LTSS-PARTICIPATION has a non-null value for LTSS-PROV-NUM and LTSS-PARTICIPATION.LTSS-ELIGIBILITY-END-DATE is greater than or equal to 'cutover date', then for every record of type LTSS-PARTICIPATION, there must be a valid record of type PROV-IDENTIFIERS that matches on the join keys and (MAX(LTSS-PARTICIPATION.LTSS-ELIGIBILITY-EFF-DATE, 'cutover date') >= PROV-IDENTIFIERS.PROV-IDENTIFIER-EFF-DATE and LTSS-PARTICIPATION.LTSS-ELIGIBILITY-END-DATE <= PROV-IDENTIFIERS.PROV-IDENTIFIER-END-DATE)
Rule Definition If the LTSS provider number is populated on a LTSS participation ELG file segment and the LTSS participation LTSS eligibility end date is greater than the states tmsis cutover date then the effective and end dates on the LTSS participation segment must fall with the effective and end dates of one or more continuous provider identifiers segments.
Denominator Logic # of LTSS-PARTICIPATION segments with LTSS-PARTICIPATION has a non-null value for LTSS-PROV-NUM and with LTSS-PARTICIPATION.LTSS-ELIGIBILITY-END-DATE is greater than or equal to 'cutover date'