ALL-16-004-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:

ALL-16-004-4

Data Quality Measure

Last updated

Key Information

Measure Name	% of claim line record segments missing ADJUDICATION-DATE (CLT00003)
File Type	CLT
Measure ID	ALL-16-004-4
Measure Type	Claims Percentage
Content area	ALL MULTI MIS

Validation

Validation Type	Inferential

Measure Priority

Measure Priority	N/A
Focus Area	N/A
Category	N/A

Claim Information

Claim Type	Medicaid,FFS or Medicaid,Cap or Medicaid,Enc or Medicaid,Serv or Medicaid,Supp or CHIP,FFS or CHIP,Cap or CHIP,Enc or CHIP,Serv or CHIP,Supp
Adjustment Type	All Adjustment Types
Crossover Type	All Indicators

Thresholds

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

Data Elements

DD Data Element	ADJUDICATION-DATE
DD Data Element Number	CLT233

Annotation	N/A
Specification	N/A

Published Date	Data Guide Version	DQM	Action	Field	Before	After
11/20/2025	4.0.22	ALL-16-004-4	UPDATE	Annotation	Calculate the percentage of paid LT claim line record segments containing a missing value for adjudication date	N/A
11/20/2025	4.0.22	ALL-16-004-4	UPDATE	Specification	STEP 1: Active paid LT claims during DQ report monthDefine the LT claims universe at the line level by importing both headers and lines that satisfy the following criteria:1a. Limit to Report MonthReporting Period from the filename = DQ report month1b. Join Headers and LinesMerge headers and lines using: ICN-ORIG, ICN-ADJ, ADJUDICATION-DATE, and ADJUSTMENT-IND=LINE-ADJUSTMENT-IND, and keep all claims, including orphan lines1c. Keep headers and associated lines if header is not denied; keep lines if header is missing (If header is denied also drop associated lines)1. CLAIM-STATUS-CATEGORY is not equal to "F2" or is missing2. CLAIM-DENIED-INDICATOR is not equal to "0" or is missing3. TYPE-OF-CLAIM is not equal to "Z" or is missing4. CLAIM-STATUS is not equal to ("26","026","87","087","542","585", "654") or is missing1d. Keep line if line is not denied1. CLAIM-LINE-STATUS is not equal to ("26","026","87","087","542","585","654") or is missingSTEP 2: Missing adjudication dateOf the claim lines that meet the criteria from STEP 2, select those where:1. ADJUDICATION-DATE is missingSTEP 3: Calculate percentageDivide the count of rows from STEP 2 by the count of rows from STEP 1	N/A
08/13/2025	4.0.16	ALL-16-004-4	UPDATE	Specification	STEP 1: Active paid LT claims during DQ report monthDefine the LT claims universe at the line level by importing both headers and lines that satisfy the following criteria:1a. Limit to Report MonthReporting Period from the filename = DQ report month1b. Join Headers and LinesMerge headers and lines using: ICN-ORIG, ICN-ADJ, ADJUDICATION-DATE, and ADJUSTMENT-IND=LINE-ADJSTMT-IND, and keep all claims, including orphan lines1c. Keep headers and associated lines if header is not denied; keep lines if header is missing (If header is denied also drop associated lines)1. CLAIM-STATUS-CATEGORY is not equal to "F2" or is missing2. CLAIM-DENIED-INDICATOR is not equal to "0" or is missing3. TYPE-OF-CLAIM is not equal to "Z" or is missing4. CLAIM-STATUS is not equal to ("26","026","87","087","542","585", "654") or is missing1d. Keep line if line is not denied1. CLAIM-LINE-STATUS is not equal to ("26","026","87","087","542","585","654") or is missingSTEP 2: Missing adjudication dateOf the claim lines that meet the criteria from STEP 2, select those where:1. ADJUDICATION-DATE is missingSTEP 3: Calculate percentageDivide the count of rows from STEP 2 by the count of rows from STEP 1	STEP 1: Active paid LT claims during DQ report monthDefine the LT claims universe at the line level by importing both headers and lines that satisfy the following criteria:1a. Limit to Report MonthReporting Period from the filename = DQ report month1b. Join Headers and LinesMerge headers and lines using: ICN-ORIG, ICN-ADJ, ADJUDICATION-DATE, and ADJUSTMENT-IND=LINE-ADJUSTMENT-IND, and keep all claims, including orphan lines1c. Keep headers and associated lines if header is not denied; keep lines if header is missing (If header is denied also drop associated lines)1. CLAIM-STATUS-CATEGORY is not equal to "F2" or is missing2. CLAIM-DENIED-INDICATOR is not equal to "0" or is missing3. TYPE-OF-CLAIM is not equal to "Z" or is missing4. CLAIM-STATUS is not equal to ("26","026","87","087","542","585", "654") or is missing1d. Keep line if line is not denied1. CLAIM-LINE-STATUS is not equal to ("26","026","87","087","542","585","654") or is missingSTEP 2: Missing adjudication dateOf the claim lines that meet the criteria from STEP 2, select those where:1. ADJUDICATION-DATE is missingSTEP 3: Calculate percentageDivide the count of rows from STEP 2 by the count of rows from STEP 1
04/24/2025	4.0.7	ALL-16-004-4	ADD	N/A		Created