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 | 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 | ELG00007 |
Data Element Name | HEALTH-HOME-SPA-PROVIDERS.SUBMITTING-STATE • HEALTH-HOME-SPA-PROVIDERS.HEALTH-HOME-PROV-NUM • HEALTH-HOME-SPA-PROVIDERS.HEALTH-HOME-SPA-PROVIDER-EFF-DATE • HEALTH-HOME-SPA-PROVIDERS.HEALTH-HOME-SPA-PROVIDER-END-DATE • PROV-IDENTIFIERS.PROV-IDENTIFIER-EFF-DATE • PROV-IDENTIFIERS.PROV-IDENTIFIER-END-DATE • FILE-HEADER-RECORD-ELIGIBILITY.END-OF-TIME-PERIOD • HEALTH-HOME-SPA-PROVIDERS.HEALTH-HOME-SPA-NAME |
Validation Logic | if HEALTH-HOME-SPA-PROVIDERS has a non-null value for HEALTH-HOME-SPA-NAME and HEALTH-HOME-SPA-PROVIDERS.HEALTH-HOME-SPA-PROVIDER-END-DATE is greater than or equal to 'cutover date', then for every record of type HEALTH-HOME-SPA-PROVIDERS, there must be a valid record of type PROV-IDENTIFIERS that matches on the join keys and (MAX(HEALTH-HOME-SPA-PROVIDERS.HEALTH-HOME-SPA-PROVIDER-EFF-DATE, 'cutover date') >= PROV-IDENTIFIERS.PROV-IDENTIFIER-EFF-DATE and HEALTH-HOME-SPA-PROVIDERS.HEALTH-HOME-SPA-PROVIDER-END-DATE <= PROV-IDENTIFIERS.PROV-IDENTIFIER-END-DATE) |
Rule Definition | If the health home spa name is populated on a health home SPA providers ELG file segment and the health home SPA providers health home spa provider end date is greater than the states tmsis cutover date then the effective and end dates on the health home SPA providers segment must fall with the effective and end dates of one or more continuous provider identifiers segments. |
Denominator Logic | # of HEALTH-HOME-SPA-PROVIDERS segments with HEALTH-HOME-SPA-PROVIDERS has a non-null value for HEALTH-HOME-SPA-NAME and with HEALTH-HOME-SPA-PROVIDERS.HEALTH-HOME-SPA-PROVIDER-END-DATE is greater than or equal to 'cutover date' |