PRV.009.122

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

PROV-AFFILIATED-PROGRAM-END-DATE

Data Element

DE Number

PRV122

System DE Number

PRV.009.122

File Name

File Segment Number

File Segment Name

PROV-AFFILIATED-PROGRAMS

Last updated

Overview Valid Values Related Rules Related DQ Measures Other Instances

Definition	The last calendar day on which all of the other data elements in the same segment were effective.
Size	9(8)
FLF Start Position	111
FLF Stop Position	118
Segment Key Field Identifier	Not Applicable
Coding Requirements	1. Value must be 8 characters in the form "CCYYMMDD" 2. The date must be a valid calendar date (i.e. Feb 29th only on the leap year, never April 31st or Sept 31st) 3. Value must be greater than or equal to associated Segment Effective Date value 4. Mandatory 5. Value of the CC component must be in [18,19,20,99]

Valid Value Code Set	Valid Value Code	Valid Value Name	Valid Value Description	Effective Start Date	Effective End Date

RULE ID	RULE Definition
RULE-2990	If the affiliated program type is equal to '2' (health plan (state assigned health plan ID)) on a provider affiliated programs PRV file segment and the provider affiliated programs prov affiliated program end date is greater than the states tmsis cutover date then the effective and end dates on the provider affiliated programs segment must fall with the effective and end dates of one or more continuous mangaged care main segments.
RULE-2995	If provider affiliated program effective date and provider affiliated program end date are populated on a provider affiliated programs segment from a PRV file, then the provider affiliated program effective date value reported must be before or equal to the provider affiliated program end date value reported.
RULE-2998	If a segment is a provider affiliated programs segment from a PRV file, then the provider affiliated program end date value reported must be a valid date of the form CCYYMMDD.

Measure ID	Measure Name
RULE-2996	Ratio of errors for overlapping segment eff/end dates [RULE-2996] to all active PROV-AFFILIATED-PROGRAMS (PRV00009) segments
PRV-5-008-8	Ratio of errors for overlapping segment eff/end dates [RULE-2996] to all active PROV-AFFILIATED-PROGRAMS (PRV00009) segments across all reporting and coverage periods

DE Number	System DE Number	DE Name	File Segment Number	File Segment Name

Published Date	Data Guide Version	Data Element	Action	Field	Before	After
09/12/2024	3.29.0	PRV.009.122	UPDATE	Coding requirement	1. Value must be 8 characters in the form "CCYYMMDD"2. The date must be a valid calendar date (i.e. Feb 29th only on the leap year, never April 31st or Sept 31st)3. Value must be greater than or equal to associated Segment Effective Date value4. Mandatory5. Value of the CC component must be in ['18', '19', '20', '99']	1. Value must be 8 characters in the form "CCYYMMDD"2. The date must be a valid calendar date (i.e. Feb 29th only on the leap year, never April 31st or Sept 31st)3. Value must be greater than or equal to associated Segment Effective Date value4. Mandatory5. Value of the CC component must be in [18,19,20,99]