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.
No Updates
Tier | 2.1 |
---|---|
Tier Description | Relational error |
Error Category | E2101 |
Error Category Message | Missing parent record (single file) |
Rule Type | Two Record Type (1 to 1) |
File Segment Number | ELG00003 |
Data Element Name | VARIABLE-DEMOGRAPHICS-ELIGIBILITY.SUBMITTING-STATE • VARIABLE-DEMOGRAPHICS-ELIGIBILITY.MSIS-IDENTIFICATION-NUM • ELIGIBILITY-DETERMINANTS.ELIGIBILITY-DETERMINANT-END-DATE • ELIGIBILITY-DETERMINANTS.PRIMARY-ELIGIBILITY-GROUP-IND • ELIGIBILITY-DETERMINANTS.ELIGIBILITY-GROUP • VARIABLE-DEMOGRAPHICS-ELIGIBILITY.VARIABLE-DEMOGRAPHIC-ELEMENT-EFF-DATE • VARIABLE-DEMOGRAPHICS-ELIGIBILITY.VARIABLE-DEMOGRAPHIC-ELEMENT-END-DATE • ELIGIBILITY-DETERMINANTS.ELIGIBILITY-DETERMINANT-EFF-DATE • FILE-HEADER-RECORD-ELIGIBILITY.END-OF-TIME-PERIOD • VARIABLE-DEMOGRAPHICS-ELIGIBILITY.CHIP-CODE |
Validation Logic | if VARIABLE-DEMOGRAPHICS-ELIGIBILITY.CHIP-CODE equals '3' and VARIABLE-DEMOGRAPHICS-ELIGIBILITY.VARIABLE-DEMOGRAPHIC-ELEMENT-END-DATE is greater than or equal to '2015-01-01', then for every record of type VARIABLE-DEMOGRAPHICS-ELIGIBILITY, there must be a valid record of type ELIGIBILITY-DETERMINANTS that matches on the join keys and (MAX(VARIABLE-DEMOGRAPHICS-ELIGIBILITY.VARIABLE-DEMOGRAPHIC-ELEMENT-EFF-DATE, '2015-01-01') >= ELIGIBILITY-DETERMINANTS.ELIGIBILITY-DETERMINANT-EFF-DATE and VARIABLE-DEMOGRAPHICS-ELIGIBILITY.VARIABLE-DEMOGRAPHIC-ELEMENT-END-DATE <= ELIGIBILITY-DETERMINANTS.ELIGIBILITY-DETERMINANT-END-DATE), and ELIGIBILITY-DETERMINANTS.ELIGIBILITY-DETERMINANT-END-DATE is greater than or equal to '2015-01-01' and ELIGIBILITY-DETERMINANTS.PRIMARY-ELIGIBILITY-GROUP-IND equals '1' and ELIGIBILITY-DETERMINANTS.ELIGIBILITY-GROUP is equal to one of the following: '61', '62', '63', '64', '65', '66', '67', '68' |
Rule Definition | If a segment is a variable demographics eligibility segment from an ELG file, and the chip code is for S-CHIP, then the max(variable demographics eligibility effective date, 2015-01-01) is greater than or equal to eligibility determinants effective date and the variable demographics eligibility end date is less than or equal to eligibility determinants end date and the eligibility determinants end date is greater than or equal to '2015-01-01' and the primary eligibility group indicator is equal to '1' and the eligibility group is equal to '61', '62', '63', '64', '65', '66', '67' or '68' |
Denominator Logic | # of VARIABLE-DEMOGRAPHICS-ELIGIBILITY segments with VARIABLE-DEMOGRAPHICS-ELIGIBILITY.CHIP-CODE is equal to '3' |