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.
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 | ELG00014 |
Data Element Name | MANAGED-CARE-PARTICIPATION.SUBMITTING-STATE • MANAGED-CARE-PARTICIPATION.MANAGED-CARE-PLAN-ENROLLMENT-EFF-DATE • MANAGED-CARE-PARTICIPATION.MANAGED-CARE-PLAN-ENROLLMENT-END-DATE • ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-EFF-DATE • ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-END-DATE • FILE-HEADER-RECORD-ELIGIBILITY.END-OF-TIME-PERIOD • MANAGED-CARE-PARTICIPATION.MSIS-IDENTIFICATION-NUM |
Validation Logic | if MANAGED-CARE-PARTICIPATION has a non-null value for MSIS-IDENTIFICATION-NUM and MANAGED-CARE-PARTICIPATION.MANAGED-CARE-PLAN-ENROLLMENT-END-DATE is greater than or equal to 'cutover date', then for every record of type MANAGED-CARE-PARTICIPATION, there must be a valid record of type ENROLLMENT-TIME-SPAN-SEGMENT that matches on the join keys and (MAX(MANAGED-CARE-PARTICIPATION.MANAGED-CARE-PLAN-ENROLLMENT-EFF-DATE, 'cutover date') >= ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-EFF-DATE and MANAGED-CARE-PARTICIPATION.MANAGED-CARE-PLAN-ENROLLMENT-END-DATE <= ENROLLMENT-TIME-SPAN-SEGMENT.ENROLLMENT-END-DATE) |
Rule Definition | If the MSIS ID is populated on a managed care participation ELG file segment and the managed care participation managed care plan enrollment end date is greater than or equal to the states tmsis cutover date then the effective and end dates on the managed care participation segment must fall with the effective and end dates of one or more continuous enrollment time span segments. |
Denominator Logic | # of MANAGED-CARE-PARTICIPATION segments with MANAGED-CARE-PARTICIPATION has a non-null value for MSIS-IDENTIFICATION-NUM, and with MANAGED-CARE-PARTICIPATION.MANAGED-CARE-PLAN-ENROLLMENT-END-DATE is greater than or equal to 'cutover date' |