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 | ELG00009 |
Data Element Name | LOCK-IN-INFORMATION.SUBMITTING-STATE • LOCK-IN-INFORMATION.LOCKIN-PROV-NUM • LOCK-IN-INFORMATION.LOCKIN-EFF-DATE • LOCK-IN-INFORMATION.LOCKIN-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 LOCK-IN-INFORMATION has a non-null value for LOCKIN-PROV-NUM and LOCK-IN-INFORMATION.LOCKIN-END-DATE is greater than or equal to 'cutover date', then for every record of type LOCK-IN-INFORMATION, there must be a valid record of type PROV-IDENTIFIERS that matches on the join keys and (MAX(LOCK-IN-INFORMATION.LOCKIN-EFF-DATE, 'cutover date') >= PROV-IDENTIFIERS.PROV-IDENTIFIER-EFF-DATE and LOCK-IN-INFORMATION.LOCKIN-END-DATE <= PROV-IDENTIFIERS.PROV-IDENTIFIER-END-DATE) |
Rule Definition | If the lock-in provider number is populated on a lock-in information ELG file segment and the lock-in information lockin end date is greater than the states tmsis cutover date then the effective and end dates on the lock-in information segment must fall with the effective and end dates of one or more continuous provider identifiers segments. |
Denominator Logic | # of LOCK-IN-INFORMATION segments with LOCK-IN-INFORMATION has a non-null value for LOCKIN-PROV-NUM and with LOCK-IN-INFORMATION.LOCKIN-END-DATE is greater than or equal to 'cutover date' |