MIS-86-002-2

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

MIS-86-002-2

Data Quality Measure

Last updated

Key Information

Measure Name	% missing: BILLED-AMT (CRX00003)
File Type	CRX
Measure ID	MIS-86-002-2
Measure Type	Claims Percentage
Content area	MIS

Validation

Validation Type	Inferential

Measure Priority

Measure Priority	Medium
Focus Area	Managed care
Category	Expenditures

Claim Information

Claim Type	Medicaid,Enc or CHIP,Enc
Adjustment Type	Original and Replacement
Crossover Type	All Indicators

Thresholds

Minimum	0
Maximum	0.02
TA Minimun	0
TA Maximum	0.02
Longitudinal Threshold	N/A
For TA (for including in compliance training)	TA- Inferential
For TA (Longitudinal)	No

Data Elements

DD Data Element	BILLED-AMT
DD Data Element Number	CRX121

Annotation

Numeric

Specification

STEP 1: Active non-duplicate RX claims 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 or S-CHIP Encounter: Original and Replacement, Paid Claims

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

1. TYPE-OF-CLAIM = "3" or "C"

2. ADJUSTMENT-IND = "0" or "4"

STEP 3: Exclude sub-capitation encounters (For measure MIS-86-002-2 ONLY)

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

1. SOURCE-LOCATION is NOT equal to "22" or "23"

STEP 4: Missing data element

Of the claims that meet the criteria from STEP 2 (or STEP 3 for selected measure), select those where

For alphanumeric data elements:

1. [DATA-ELEMENT-NAME] does not contain any alpha character (A-Z or a-z) OR any digit 1-9

For numeric data elements:

1. [DATA-ELEMENT-NAME] does not contain any digit 1-9

STEP 5: Calculate percentage

Divide the count of claim lines from STEP 4 by the count of claim lines from STEP 2 (or STEP 3 for selected measure)

Published Date	Data Guide Version	DQM	Action	Field	Before	After
09/06/2023	3.12.0	MIS-86-002-2	UPDATE	Specification	STEP 1: Active non-duplicate OT claims during DQ report monthDefine the OT 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 or S-CHIP Encounter: Original and Replacement, Paid ClaimsOf the claims that meet the criteria from STEP 1, further restrict them by the following criteria:1. TYPE-OF-CLAIM = "3" or "C"2. ADJUSTMENT-IND = "0" or "4"STEP 3: Exclude sub-capitation encounters (For measure MIS-86-002-2 ONLY) Of the claims that meet the criteria from STEP 2, further restrict them by the following criteria:1. SOURCE-LOCATION is NOT equal to "22" or "23"STEP 4: Missing data elementOf the claims that meet the criteria from STEP 2 (or STEP 3 for selected measure), select those whereFor alphanumeric data elements:1. [DATA-ELEMENT-NAME] does not contain any alpha character (A-Z or a-z) OR any digit 1-9For numeric data elements: 1. [DATA-ELEMENT-NAME] does not contain any digit 1-9STEP 5: Calculate percentageDivide the count of claim lines from STEP 4 by the count of claim lines from STEP 2 (or STEP 3 for selected measure)	STEP 1: Active non-duplicate RX claims 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 or S-CHIP Encounter: Original and Replacement, Paid ClaimsOf the claims that meet the criteria from STEP 1, further restrict them by the following criteria:1. TYPE-OF-CLAIM = "3" or "C"2. ADJUSTMENT-IND = "0" or "4"STEP 3: Exclude sub-capitation encounters (For measure MIS-86-002-2 ONLY) Of the claims that meet the criteria from STEP 2, further restrict them by the following criteria:1. SOURCE-LOCATION is NOT equal to "22" or "23"STEP 4: Missing data elementOf the claims that meet the criteria from STEP 2 (or STEP 3 for selected measure), select those whereFor alphanumeric data elements:1. [DATA-ELEMENT-NAME] does not contain any alpha character (A-Z or a-z) OR any digit 1-9For numeric data elements: 1. [DATA-ELEMENT-NAME] does not contain any digit 1-9STEP 5: Calculate percentageDivide the count of claim lines from STEP 4 by the count of claim lines from STEP 2 (or STEP 3 for selected measure)
04/21/2023	3.6.0	MIS-86-002-2	UPDATE	Specification	STEP 1: Active non-duplicate OT claims during DQ report monthDefine the OT 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 or S-CHIP Encounter: Original and Replacement, Paid ClaimsOf the claims that meet the criteria from STEP 1, further restrict them by the following criteria:1. TYPE-OF-CLAIM = "3" or "C"2. ADJUSTMENT-IND = "0" or "4"STEP 3: Missing data elementOf the claims that meet the criteria from STEP 2, select those whereFor alphanumeric data elements:1. [DATA-ELEMENT-NAME] does not contain any alpha character (A-Z or a-z) OR any digit 1-9For numeric data elements: 1. [DATA-ELEMENT-NAME] does not contain any digit 1-9STEP 4: Calculate percentageDivide the count of claim lines from STEP 3 by the count of claim lines from STEP 2	STEP 1: Active non-duplicate OT claims during DQ report monthDefine the OT 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 or S-CHIP Encounter: Original and Replacement, Paid ClaimsOf the claims that meet the criteria from STEP 1, further restrict them by the following criteria:1. TYPE-OF-CLAIM = "3" or "C"2. ADJUSTMENT-IND = "0" or "4"STEP 3: Exclude sub-capitation encounters (For measure MIS-86-002-2 ONLY) Of the claims that meet the criteria from STEP 2, further restrict them by the following criteria:1. SOURCE-LOCATION is NOT equal to "22" or "23"STEP 4: Missing data elementOf the claims that meet the criteria from STEP 2 (or STEP 3 for selected measure), select those whereFor alphanumeric data elements:1. [DATA-ELEMENT-NAME] does not contain any alpha character (A-Z or a-z) OR any digit 1-9For numeric data elements: 1. [DATA-ELEMENT-NAME] does not contain any digit 1-9STEP 5: Calculate percentageDivide the count of claim lines from STEP 4 by the count of claim lines from STEP 2 (or STEP 3 for selected measure)