Data Rules

Current Claim Year: 2024

Last updated: 19 August, 2024

Download All Rules Download Example Submission Zip Download Example Submission XLSX

Quarterly Claims > Specification > Data Rules > Site

Claims data

Cedars claim data submission comprises of five 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

Site

The Site table's primary key is SiteID. Table validation checks that the primary key is unique regardless of the letter case. It also checks that Site.SiteID matches with a Claim.SiteID. The SiteID field also joins to the PII Site table.

Required fields

Field Name	Description	Data Type
SiteID	The unique and persistent record identifier and the primary key for the Site table. Must match a SiteID in the Claim table. All values must start with the PA code.	Text (up to 255 characters)
Site.SiteID starts with the PA code of the program administrator or 'SW' for statewide claims.
SiteCity	The site city.	Text (up to 255 characters)
SiteState	The site state, e.g. 'CA'.	Text (up to 255 characters)
Site.SiteState equals 'CA'.
SiteZipCode	The site zip code.	Text (up to 255 characters)
Site.SiteZipCode is a California zip code.
Residential_Flag	Flag to identify residential sites.	Boolean (0 for false, 1 for true)
NAICSCode	The site NAICS code (e.g. 112910).	Text (up to 255 characters)
Site.NAICSCode is required when Site.Residential_Flag equals false.