Districts with an active CN PEARS flag have access to the following data when creating integration maps:
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 |