NY Program Services Import

Introduction

Use the NY Program Services Import process to update the Program Services (Program Fact) data for students. Students are identified by their Student Number.

Import Template

The following table contains information related to import file columns and associated field values.

Element	Description	Required
Student_Number	Enter the locally assigned student number.	Y
ProgramServiceCode	Enter the appropriate Program Service code. See Program Service Codes for valid values. Note: When the Program Service Category is set to English Learner Language, values for Program Intensity will be populated.	N
ProgramServiceCategory	Enter the appropriate Program Service Category. See Program Service Category Codes for valid values.	N
BeginningDate	Enter the program service beginning date (First date that student received services).	N
EndingDate	Enter the program service ending date (First day that services were no longer received). Leave blank for open-ended programs. Notes: School-level program services must be properly ended when the student leaves the school. If a student's 0231 Program Service Code record is closed, the following program service codes must also be closed: 1232 – Students with interrupted Formal Education (SIFE) 5720 – Title III: Services to Non-Immigrant LEP Students 5731 – Title III: Language Instruction Immigrant LEP Students 5709 – English as a Second Language	N
CTETechPrepCategory	Enter the CTE/Tech Prep Category if applicable. See Career and Technical Education (CTE)/Tech Prep Category Codes for valid values. Note: This field is only required if the Program Service Category is Career and Technical (CTE)/Tech Prep.	N
ProgramIntensity	Enter the program intensity. Enrollee – CTE or TP/CP Enrollee Participant – CTE or TP/CP Participant Concentrator – CTE or TP/CP Concentrator Notes: This field is only required for CTE/Tech Prep program services. The value indicates the student’s progression through the program service. As the student reaches each level of intensity, the description must be updated.	N
ExitReasonCode	Enter the student’s reason for exiting the program service.	N
ParticipationInfoCode	Enter the participation code. This field indicates whether a Career Technical Education (CTE)/Tech Prep program follows a conventional CTE program approach, or the Tech Prep program approach. Notes: This field is only required for CTE/Tech Prep program services.	N
StateLocationID	Enter a value to override the NY SED BEDS code assigned to the school (Start Page > District Setup > Schools/School Info > Edit School). Leave the field blank if the program service is offered at the district level.	N
ProgramServiceLevel	Enter the Program Service Level (School or District), based on the Program Service Category and/or the Program Service Code. Valid values: S – School D – District	N
SchoolID	Enter the ID of the school where the program takes place.	N
Program Eligibility Code 1	Enter the student's primary program eligibility code. See Program Eligibility Codes for valid values.	N
Program Eligibility Code 2	Enter the student's secondary program eligibility code. See Program Eligibility Codes for valid values.	N
Program Eligibility Code 3	Enter the student's tertiary program eligibility code. See Program Eligibility Codes for valid values.	N
Program Eligibility Code 4	Enter the student's quaternary program eligibility code. See Program Eligibility Codes for valid values.	N
Program Eligibility Code 5	Enter the student's quinary program eligibility code. See Program Eligibility Codes for valid values.	N
Nighttime Residence	Enter the student's nighttime residence code. See Primary Nighttime Residence Codes for valid values.	N

Sample Import File

Import Process

These changes are permanent. Verify that the file format is correct and that the information to be imported is valid.

Create and populate a .csv import file in ASCII format using the above template.
Navigate to Start Page > Special Functions > Importing & Exporting > NY Program Service Import
Click Browse, and select your saved import file.
Click Import. The import process results page appears and indicates if the import was successful for all records.
Verify that imported data is accurate by navigating to Start Page> [Make a student selection] > State/Province - NY