PII Data Rules

Current Claim Year: 2024

Last updated: 19 August, 2024

Download All PII Data Rules

Quarterly Claims  >  Specification  >  PII Data Rules  >  PII_Site

PII Data

The reporting of Personally Identifiable Information (PII) data is done outside of Cedars at the same time as the Cedars claim submissions. In aggregate, PA PII submissions are expected to align exactly with that year's cumulative Cedars claim data.

The PII submission consists of two tables. Each table should be a .csv file, zipped together into a .zip file. The CSV data files must use the "|" character as the delimiter with unquoted text values.

Select table to view fields and rules

PII_Contact

PII_Site

For more information read the Claims User Guide
What is PII Data? Preparing your Claims PII file Programs and measures exempt from PII data reporting

PII_Site

The data in the tables must adhere to the rules specified here, including the primary key rules. The Site table's primary key is SiteID. Table validation checks that the primary key is unique. Primary key values are case-insensitive, which means that Customer123 is the same ID as CUSTOMER123.

  Required fields

Field Name Description Data Type Rules
 SiteID The unique and persistent record identifier and the primary key for the PII Site table. Must match a SiteID in the Claim table. All values must start with the PA code. Text (up to 255 characters)
 SiteAddress The street address of the site. Text (up to 255 characters)
SiteUnitNumber The site unit number, if applicable. Text (up to 255 characters)
ElectricServiceAccountID The service account ID for the site electricity service. Text (up to 255 characters) ElectricServiceAccountID is required when GasServiceAccountID is blank.
GasServiceAccountID The service account ID for the site gas service. Text (up to 255 characters) GasServiceAccountID is required when ElectricServiceAccountID is blank.
 ServiceAccountName The name for the service account. This is usually the customer's name. Text (up to 255 characters)
SchoolIdentifier The unique and persistent school identifier. Text (up to 255 characters)