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

Validation Rule
Last updated

No Updates

Tier 2.1
Tier Description Relational error
Error Category E2102
Error Category Message Values inconsistently specified (multi record, single file)
Rule Type Two Record Type (1 to 1)
File Segment Number MCR00002
Data Element Name MANAGED-CARE-MAIN.SUBMITTING-STATE • MANAGED-CARE-SERVICE-AREA.MANAGED-CARE-SERVICE-AREA-NAME
Validation Logic 'if MANAGED-CARE-MAIN.MANAGED-CARE-SERVICE-AREA equals '2' and MANAGED-CARE-SERVICE-AREA has a valid, non-null value for MANAGED-CARE-SERVICE-AREA-NAME, then If the length of (MANAGED-CARE-SERVICE-AREA.MANAGED-CARE-SERVICE-AREA-NAME) = 5, the value must be contained in the set of valid values with id: 'COUNTY' else if the length of (MANAGED-CARE-SERVICE-AREA.MANAGED-CARE-SERVICE-AREA-NAME) = 3, then the concatenation of MANAGED-CARE-MAIN.SUBMITTING-STATE and MANAGED-CARE-SERVICE-AREA.MANAGED-CARE-SERVICE-AREA-NAME must be contained in the set of valid values with id: 'COUNTY' and (if MANAGED-CARE-SERVICE-AREA.MANAGED-CARE-SERVICE-AREA-EFF-DATE is non-null then MANAGED-CARE-SERVICE-AREA.MANAGED-CARE-SERVICE-AREA-EFF-DATE is >= Valid Values Effective-Date and MANAGED-CARE-SERVICE-AREA.MANAGED-CARE-SERVICE-AREA-EFF-DATE is <= Valid Values End-Date'
Rule Definition If managed care service area is for county on a managed care main segment from an MCR file, then the managed care service area name value reported must be in the list of valid values for county.
Denominator Logic # of MANAGED-CARE-SERVICE-AREA segments with MANAGED-CARE-MAIN.MANAGED-CARE-SERVICE-AREA equal to '2' AND with MANAGED-CARE-SERVICE-AREA.MANAGED-CARE-SERVICE-AREA-NAME equal to a valid, non-null value