CN PEARS Data

Districts with an active CN PEARS flag have access to the following data when creating integration maps:

Field

Type

Character Length

Description

Form ID

Integration Constant

3

Constant value on the integration map

Sequence Number

System Generated

6

FOH stored value

Today’s Date

MMDDYYYY

8

Current date

Sponsor Name

Integration Constant

64

District Name

Agreement Number

System Generated

16

School ID/PEARS ID

2 Digit Start Month

System Generated

2

Selected date range on the integration job

4 Digit Start Year

System Generated

4

Selected date range on the integration job

School Description

System Generated

64

School description

School ID

System Generated

7

School ID

PEARS Supper Operating Days

Daily Entry or Import

7

Number of days for Supper meal counts

PEARS Supper Attendance

Imported

7

Supper Attendance value

Notes: The PEARS Supper Attendance field calculates the sum of the Supper Attendance of a date range (it does not take the maximum value of the date range).

The Supper Export Simple CS integration job produces the same number for Supper Attendance as the SNP Claims report for the AR3. Total Attendance field.

PEARS Supper Free Eligible

System Generated

7

Supper Enrollment

PEARS Supper Served

System Generated

7

Supper Attendance

Number of Serving Days

System Generated

8

Number of days served

Serve Date

Date

8

Selected date range

Breakfast Severe Need Average Daily Participation

Calculated

7

Breakfast meal count/breakfast enrollment * 100

Breakfast Non-Severe Need Average Daily Participation

Calculated

7

Breakfast meal count/breakfast enrollment * 100

Lunch Severe Need Average Daily Participation

Calculated

7

Lunch meal count/lunch enrollment * 100

Lunch Non-Severe Need Average Daily Participation

Calculated

7

Lunch meal count/lunch enrollment * 100

Severe Need Breakfast Total Meals Served

Daily Entry

7

Number of total severe breakfast meals served

Provision Type Breakfast

True/False System Flag

8

CEP flag

Provision Type Lunch

True/False System Flag

8

CEP flag

Free Approved Applications

Calculated

7

Highest free approved application value for the date or date range selected. Value mapped to the Philly Basic Claims “G” section.

Reduced Approved Applications

Calculated

7

Highest reduced approved applications value for the date or date range selected. Value mapped to the Philly Basic Claims “G” section.

PEARS Daily Enrollment

Imported

7

DC Enrollment, if not imported = 0

PEARS Lunch Enrollment

Imported

7

Lunch Enrollment, if not imported = 0

Lunch Operating Days

System Generated

2

Number of days lunch served

Lunch Paid Meals Served

Daily Entry

7

Paid lunch meals served

Lunch Free Meals Served

Daily Entry

7

Free lunch meals served

Lunch Reduced Meals Served

Daily Entry

7

Reduced lunch meals served

Lunch Total Meals Served

Daily Entry

7

Total lunch meals served

PEARS Breakfast Enrollment

Imported

7

Breakfast Enrollment

Breakfast Operating Days

System Generated

2

Number of days breakfast served

Breakfast Free Meals Served

Daily Entry

7

Free breakfast meals served

Breakfast Reduced Meals Served

Daily Entry

7

Reduced breakfast meals served

Breakfast Paid Meals Served

Daily Entry

7

Free breakfast meals served

Breakfast Total Meals Served

Daily Entry

7

Total breakfast meals served

PEARS SND Enrollment

Imported

7

Severe need breakfast enrollment

Severe Need Breakfast Operating Days

System Generated

2

Number of days severe need breakfast served

Severe Need Breakfast Free Meals Served

Daily Entry

7

Number of days free severe need breakfast served

Severe Need Breakfast Reduced Meals Served

Daily Entry

7

Number of days reduced severe need breakfast served

Severe Need Breakfast Paid Meals Served

Daily Entry

7

Number of days paid severe need breakfast served

PEARS Supper Enrollment

Imported

7

Supper Enrollment