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:
| 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.
Notes:
| 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:
| 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