Franklin California

Plugin 2.1.0.22012 Contains:

DC Import Configuration

California

The following is the file layout for your district. See the State Direct Certification document for details on performing the DC process.

Plug-In Name: California

Match Style: State Match

File Type: Delimited by "^"

Number of Heading Lines: 0

Export Available: No

Advanced Setup Available: No

File Format:

CALPADS File Element	Field Type	Max Length	Business Rule
Academic Year ID	CS	9	Format: CCYY-CCYY (ex. 2008-2009) Indicates the school year associated with the file. May not be blank.
Reporting LEA	CS	7	This will default to the institution identifier of the User ID. May not be blank.
School of Attendance	CS	7	The 7 digit code associated with the student's school of attendance. May not be blank.
Local Student ID	CS	16	The student's Local Identifier associated with the enrollment. May not be blank.
SSID	CS	10	The SSID for the student. May not be blank.
Student Legal First Name	CS	30	The Legal First Name of the student. May not be blank.
Student Legal Middle Name	CS	30	The Legal Middle Name of the student. Optional and may be blank.
Student Legal Last Name	CS	50	The Legal Last Name of the student. May not be blank.
Certification Date	DT	8	The date the student was certified eligible for NSLP. May not be blank.
Certification Status	CS	1	S Student directly certified for free meals because the student is receiving SNAP/CalFresh benefits T Student directly certified for free meals because the student is receiving TANF benefits M Student is directly certified for free meals because the student met income eligibility criteria through Medicaid/Medi-Cal program R Student is directly certified for reduced-price meals because the student met the income eligibility criteria through Medicaid/Medi-Cal program N Student is not certified to receive free or reduced-price meals

Review updated changes to CALPADS DC Extract as of January 9, 2017.