Data Rules

Current Claim Year: 2026

Last Updated: 2026-06-09

Download All Rules Download Example Input ZIP Download Example Input XLSX

Quarterly Claims > Specification > Data Rules > Participant

Claims data

Cedars claim data submission comprises of six required relational tables. View each tables field, description, data type and applicable data rules.

Select table to view fields and rules

For more information read the Claims User Guide

Data Rules

Participant

The Participant table uses a compound primary key made up of PrgID, PrgYear, ParticipantType, and SiteID. The combination of these four fields must be unique for each record. This structure allows a single program site to be associated with multiple participant types. If SiteID is null, it is interpreted as applying to all sites for the given PrgID. Each record must have a unique combination of PrgID, PrgYear, ParticipantType, and SiteID, ignoring letter case.

Participant.PrgYear must match a valid ProgramCost.PrgYear. Participant.SiteID must match a valid Site.SiteID when provided (i.e., when not null).

Required fields

Field Name	Description	Data Type
PrgID	The unique and persistent program identifier. The Participant primary key is PrgID, PrgYear, ParticipantType, and SiteID in combination.	Text (up to 255 characters)
Participant.PrgID is in the Program valuelist.
PrgYear	The claim year. The Participant primary key is PrgID, PrgYear, ParticipantType, and SiteID in combination.	Number (integer)
ParticipantType	The unique and persistent participant identifier. The Participant primary key is PrgID, PrgYear, ParticipantType, and SiteID in combination.	Text (up to 255 characters)
Participant.ParticipantType is in the ParticipantType valuelist.
SiteID	Identifies the specific site associated with the programs participant type. When populated, must match a valid Site.SiteID. If SiteID is null, the record applies to all sites for the given PrgID and ParticipantType. In this case, no records may exist for the same PrgID and ParticipantType with a populated SiteID. All values must begin with the PA code. The Participant primary key is PrgID, PrgYear, ParticipantType, and SiteID in combination.	Text (up to 255 characters)
ParticipantCount	Total number of participants in the program.	Number (integer)
Participant.ParticipantCount is greater than or equal to 1.
EquityTargeted	Number of participants qualifying as Equity Targeted.	Number (integer)
DAC	Number of participants in a disadvantaged community as identified by census tracts.	Number (integer)
HTR	Number of participants qualifying as Hard-to-Reach.	Number (integer)
Underserved	Number of participants qualifying as underserved community.	Number (integer)
Comments	Clarifying comments or details not included in the other participant reporting fields.	Text (any length)