Purpose: Placements created outside of SL&L can be bulk imported to create new placement records. Edits to existing placements can also be made using this feature.
Fields: All headers in the template must be uploaded as provided. Optional fields may be left blank but the header must remain on the column. The file must contain the following columns in the following order:
Placement ID
⦁ Explanation: used to identify the specific placement record, unique identifier
⦁ Example: 6559110123
⦁ Field Type and Length: numeric
⦁ Sample file column: A
⦁ Import Status: Optional*
*If no Placement ID is provided then this row will be treated as a new placement record and an ID will be assigned. If an existing Placement ID is provided then updates will be made to that placement record.
Intern Email
⦁ Explanation: Student email address, used to identity the student being placed
⦁ Example: astudent@university.edu
⦁ Field Type and Length: text
⦁ Sample file column: B
⦁ Import Status: Required
Term Code
⦁ Explanation: the term code during which the placement will occur
⦁ Example: SP24
⦁ Field Type and Length: alphanumeric
⦁ Sample file column: C
⦁ Import Status: Required
Course Code
⦁ Explanation: The code for the course associated with the placement
⦁ Example: Edu 101
⦁ Field Type and Length: Alphanumeric
⦁ Sample file column: D
⦁ Import Status: Required
Section Name
⦁ Explanation: Course section associated with the placement
⦁ Example: EDU 101 SP24 SEC02
⦁ Field Type and Length: Alphanumeric
⦁ Sample file column: E
⦁ Import Status: Required
Site ID
⦁ Explanation: Unique ID for the placement site. Site IDs can be found in the site tab or by downloading the list of sites in SL&L
⦁ Example: 5f7d3d58
⦁ Field Type and Length: Alphanumeric
⦁ Sample file column: F
⦁ Import Status: Optional*
*Site ID, Mentor Email, and Supervisor Email are all optional, however at least one of these must be provided in order to create a new placement record
Mentor Email
⦁ Explanation: Email address for the mentor associated with the placement
⦁ Example: amentor@schools.edu
⦁ Field Type and Length: email
⦁ Sample file column: G
⦁ Import Status: Optional*
*Site ID, Mentor Email, and Supervisor Email are all optional, however at least one of these must be provided in order to create a new placement record
Supervisor Email
⦁ Explanation: email address for the placement supervisor
⦁ Example: asupervisor@university.edu
⦁ Field Type and Length: email
⦁ Sample file column: H
⦁ Import Status: Optional*
*Site ID, Mentor Email, and Supervisor Email are all optional, however at least one of these must be provided in order to create a new placement record
Placement Details
⦁ Explanation: enter any additional information or tags associated with the placement
⦁ Example: “Early Field”, “Rural”, “English Learners”, “Private School”
⦁ Field Type and Length: Alpha
⦁ Sample file column: I
⦁ Import Status: Optional
Content Areas
⦁ Explanation: Content areas related to placement
⦁ Example: “Math”, “English”
⦁ Field Type and Length: Alpha
⦁ Sample file column: J
⦁ Import Status: Optional
Grade Levels
⦁ Explanation: Grade levels associated with the placement. Accepted values are:
- Pre-kindergarten
- Kindergarten
- 1st
- 2nd
- 3rd
- 4th
- 5th
- 6th
- 7th
- 8th
- 9th
- 10th
- 11th
- 12th
- 13th
- Adult Education
⦁ Example: “Kindergarten”, “2nd”, “Adult Education”
⦁ Field Type and Length: Alpha
⦁ Sample file column: K
⦁ Import Status: Optional
Start Date
⦁ Explanation: Date the placement will begin
⦁ Example: 1/1/2024
⦁ Field Type and Length: date
⦁ Sample file column: L
⦁ Import Status: Optional
End Date
⦁ Explanation: Date the placement will end
⦁ Example: 5/15/2024
⦁ Field Type and Length: date
⦁ Sample file column: M
⦁ Import Status: Optional
Notes
⦁ Explanation: Additional notes about the placement
⦁ Example: “First placement”
⦁ Field Type and Length: open text, 500 characters
⦁ Sample file column: N
⦁ Import Status: Optional