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.28.0

RULE-1869

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 CRX00002
Data Element Name CLAIM-HEADER-RECORD-RX.PRESCRIPTION-FILL-DATEFILE-HEADER-RECORD-RX.END-OF-TIME-PERIOD
Validation Logic 'if CLAIM-HEADER-RECORD-RX.CLAIM-STATUS-CATEGORY does not equal 'F2' and CLAIM-HEADER-RECORD-RX has a valid, non-null value for PRESCRIPTION-FILL-DATE and FILE-HEADER-RECORD-RX has a valid, non-null value for END-OF-TIME-PERIOD, then CLAIM-HEADER-RECORD-RX.PRESCRIPTION-FILL-DATE is less than or equal to FILE-HEADER-RECORD-RX.END-OF-TIME-PERIOD'
Rule Definition If prescription fill date is populated on a non-denied claim from an RX file and end of time period is populated on the file header, then the prescription fill date value reported must be before or equal to the end of time period value reported.
Denominator Logic # of RX claims with CLAIM-HEADER-RECORD-RX.CLAIM-STATUS-CATEGORY not equal to 'F2' AND with CLAIM-HEADER-RECORD-RX.PRESCRIPTION-FILL-DATE equal to a valid, non-null value AND with FILE-HEADER-RECORD-RX.END-OF-TIME-PERIOD equal to a valid, non-null value