FFS-14-007-4

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

FFS-14-007-4

Data Quality Measure

Last updated

Key Information

Measure Name	% of claim headers with PRESCRIPTION-QUANTITY-ACTUAL = 1
File Type	CRX
Measure ID	FFS-14-007-4
Measure Type	Claims Percentage
Content area	FFS

Validation

Validation Type	Longitudinal and Inferential

Measure Priority

Measure Priority	Medium
Focus Area	N/A
Category	Utilization

Claim Information

Claim Type	Medicaid,FFS
Adjustment Type	Original
Crossover Type	Non-Crossover

Thresholds

Minimum	0
Maximum	0.2
TA Minimun	0
TA Maximum	0.2
Longitudinal Threshold	0.25
For TA (for including in compliance training)	TA- Inferential
For TA (Longitudinal)	No

Data Elements

DD Data Element	PRESCRIPTION-QUANTITY-ACTUAL
DD Data Element Number	CRX132

Annotation

Calculate the percentage of Medicaid FFS: original, non-crossover, paid RX records where a single drug, service, or product was rendered/dispensed

Specification

STEP 1: Active non-duplicate paid RX records during DQ report month

Define the RX claims universe at the header level by importing both headers and lines that satisfy the following criteria:

For Headers:

1. Reporting Period from the filename = DQ report month

2. CLAIM-STATUS-CATEGORY is not equal to "F2" or is missing

3. CLAIM-DENIED-INDICATOR is not equal to "0" or is missing

4. TYPE-OF-CLAIM is not equal to "Z" or is missing

5. CLAIM-STATUS is not equal to ("26","026","87","087","542","585", "654") or is missing

6. No Header Duplicates: Duplicates are dropped at the header level, if the following four data elements are the same: ICN-ORIG, ICN-ADJ, ADJUDICATION-DATE, and ADJUSTMENT-IND.

For Lines:

1. Reporting Period from the filename = DQ report month

2. CLAIM-LINE-STATUS is not equal to ("26","026","87","087","542","585","654") or is missing

3. No Line Duplicates: Duplicates are dropped at the line level if the following data elements are the same: ICN-ORIG, ICN-ADJ, ADJUDICATION-DATE, LINE-NUM-ORIG, LINE-NUM-ADJ, and LINE-ADJSTMT-IND.

4. Lines merge to a header using ICN-ORIG, ICN-ADJ, ADJUDICATION-DATE, and ADJUSTMENT-IND=LINE-ADJSTMT-IND.

STEP 2: Medicaid FFS: Original, Non-Crossover, Paid Claims

Of the claims that meet the criteria from STEP 1, further restrict them by the following criteria:

1. TYPE-OF-CLAIM = "1"

2. ADJUSTMENT-IND = "0"

3. CROSSOVER-INDICATOR = "0" or is missing

STEP 3: Drugs, services, or products rendered is 1

Of the records that meet the criteria from STEP 2, count line records with

1. PRESCRIPTION-QUANTITY-ACTUAL = 1

STEP 4 : Calculate percentage for measure

Divide the count of line records from STEP 3 by the count of line records from STEP 2

Published Date	Data Guide Version	DQM	Action	Field	Before	After
11/15/2023	3.16.0	FFS-14-007-4	UPDATE	Measure name	% of claim headers with OT-RX-CLAIM-QUANTITY-ACTUAL = 1	% of claim headers with PRESCRIPTION-QUANTITY-ACTUAL = 1
11/15/2023	3.16.0	FFS-14-007-4	UPDATE	Specification	STEP 1: Active non-duplicate paid RX records during DQ report monthDefine the RX claims universe at the header level by importing both headers and lines that satisfy the following criteria:For Headers:1. Reporting Period from the filename = DQ report month2. CLAIM-STATUS-CATEGORY is not equal to "F2" or is missing3. CLAIM-DENIED-INDICATOR is not equal to "0" or is missing4. TYPE-OF-CLAIM is not equal to "Z" or is missing5. CLAIM-STATUS is not equal to ("26","026","87","087","542","585", "654") or is missing6. No Header Duplicates: Duplicates are dropped at the header level, if the following four data elements are the same: ICN-ORIG, ICN-ADJ, ADJUDICATION-DATE, and ADJUSTMENT-IND.For Lines:1. Reporting Period from the filename = DQ report month2. CLAIM-LINE-STATUS is not equal to ("26","026","87","087","542","585","654") or is missing3. No Line Duplicates: Duplicates are dropped at the line level if the following data elements are the same: ICN-ORIG, ICN-ADJ, ADJUDICATION-DATE, LINE-NUM-ORIG, LINE-NUM-ADJ, and LINE-ADJSTMT-IND.4. Lines merge to a header using ICN-ORIG, ICN-ADJ, ADJUDICATION-DATE, and ADJUSTMENT-IND=LINE-ADJSTMT-IND.STEP 2: Medicaid FFS: Original, Non-Crossover, Paid ClaimsOf the claims that meet the criteria from STEP 1, further restrict them by the following criteria:1. TYPE-OF-CLAIM = "1"2. ADJUSTMENT-IND = "0"3. CROSSOVER-INDICATOR = "0" or is missingSTEP 3: Drugs, services, or products rendered is 1Of the records that meet the criteria from STEP 2, count line records with1. OT-RX-CLAIM-QUANTITY-ACTUAL = 1STEP 4 : Calculate percentage for measureDivide the count of line records from STEP 3 by the count of line records from STEP 2	STEP 1: Active non-duplicate paid RX records during DQ report monthDefine the RX claims universe at the header level by importing both headers and lines that satisfy the following criteria:For Headers:1. Reporting Period from the filename = DQ report month2. CLAIM-STATUS-CATEGORY is not equal to "F2" or is missing3. CLAIM-DENIED-INDICATOR is not equal to "0" or is missing4. TYPE-OF-CLAIM is not equal to "Z" or is missing5. CLAIM-STATUS is not equal to ("26","026","87","087","542","585", "654") or is missing6. No Header Duplicates: Duplicates are dropped at the header level, if the following four data elements are the same: ICN-ORIG, ICN-ADJ, ADJUDICATION-DATE, and ADJUSTMENT-IND.For Lines:1. Reporting Period from the filename = DQ report month2. CLAIM-LINE-STATUS is not equal to ("26","026","87","087","542","585","654") or is missing3. No Line Duplicates: Duplicates are dropped at the line level if the following data elements are the same: ICN-ORIG, ICN-ADJ, ADJUDICATION-DATE, LINE-NUM-ORIG, LINE-NUM-ADJ, and LINE-ADJSTMT-IND.4. Lines merge to a header using ICN-ORIG, ICN-ADJ, ADJUDICATION-DATE, and ADJUSTMENT-IND=LINE-ADJSTMT-IND.STEP 2: Medicaid FFS: Original, Non-Crossover, Paid ClaimsOf the claims that meet the criteria from STEP 1, further restrict them by the following criteria:1. TYPE-OF-CLAIM = "1"2. ADJUSTMENT-IND = "0"3. CROSSOVER-INDICATOR = "0" or is missingSTEP 3: Drugs, services, or products rendered is 1Of the records that meet the criteria from STEP 2, count line records with1. PRESCRIPTION-QUANTITY-ACTUAL = 1STEP 4 : Calculate percentage for measureDivide the count of line records from STEP 3 by the count of line records from STEP 2