Site Data Imports

Purpose: Multiple placement sites may be added at one time using this import.  Edits to existing sites can also be made using this feature.  Please note, sites listed in the NCES database cannot be added or edited.

 

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:

 

Site ID

     ⦁ Explanation: Unique Identifier for site

     ⦁ Example: 5f7d3d58

     ⦁ Field Type and Length: text

     ⦁ Sample file column: A

     ⦁ Import Status: Optional*

*If no site ID is provided the system will create a new site and assign an ID.  If an existing Site ID is provided, the system will update that record with details provided in the CSV file

 

Site Name

     ⦁ Explanation: Name of the site

     ⦁ Example: Austin Elementary School

     ⦁ Field Type and Length: text

     ⦁ Sample file column: A

     ⦁ Import Status: Required

 

Street Address

     ⦁ Explanation: Street number and Street where the site is located

     ⦁ Example: 123 Main St

     ⦁ Field Type and Length: Alphanumeric

     ⦁ Sample file column: B

     ⦁ Import Status: Optional

 

City or Zip Code

     ⦁ Explanation: Either the city or the zip code of the site can be provided

     ⦁ Example: “Austin” or “73301”

     ⦁ Field Type and Length: alphanumeric

     ⦁ Sample file column: C

     ⦁ Import Status: Required

 

Country

     ⦁ Explanation: Country where the site is located

     ⦁ Example: United States

     ⦁ Field Type and Length: Text

     ⦁ Sample file column: D

     ⦁ Import Status: Required

 

Site Website

     ⦁ Explanation: Provide a link to the partner site website

     ⦁ Example: www.elementaryschool.com

     ⦁ Field Type and Length: text

     ⦁ Sample file column: E

     ⦁ Import Status: Optional

 

Site Type

     ⦁ Explanation: Use “Ed Prep” if the site if for an education prep related placement; use “Other Program” if the placement is for another program (ie. social work or other clinical placement)

     ⦁ Example: “Ed Prep” or “Other Program”

     ⦁ Field Type and Length: text

     ⦁ Sample file column: F

     ⦁ Import Status: Required


The following fields are only relevant for “Ed Prep” type sites; please leave these fields blank if the site type is “Other Program”

Lowest Grade

     ⦁ Explanation: Lowest grade available for placements at the site; the system will select all grades between the “Lowest Grade” and “Highest Grade” provided.  Accepted Values are:

  • Pre-Kindergarten
  • Kindergarten
  • 1st
  • 2nd
  • 3rd
  • 4th
  • 5th
  • 6th
  • 7th
  • 8th
  • 9th
  • 10th
  • 11th
  • 12th
  • 13th
  • Adult Education

     ⦁ Example: Pre-Kindergarten

     ⦁ Field Type and Length: text

     ⦁ Sample file column: G

     ⦁ Import Status: Optional

 

Highest Grade

     ⦁ Explanation: Lowest grade available for placements at the site; the system will select all grades between the “Lowest Grade” and “Highest Grade” provided.  For example, if “Pre-Kindergarten” is provided in “lowest grade” and “2nd” is provided in “Highest Grade”, then values of “Pre-Kindergarten”, “Kindergarten”,  “1st”, and “2nd” will be included.  Accepted Values are:

  • Pre-Kindergarten
  • Kindergarten
  • 1st
  • 2nd
  • 3rd
  • 4th
  • 5th
  • 6th
  • 7th
  • 8th
  • 9th
  • 10th
  • 11th
  • 12th
  • 13th
  • Adult Education

     ⦁ Example: 2nd

     ⦁ Field Type and Length: text

     ⦁ Sample file column: H

     ⦁ Import Status: Optional

 

Title 1 Status

     ⦁ Explanation: Is the school a Title 1 site?  Accepted values are “yes”, “no”, or “unknown”.  If no value is provided then “Unknown” will be selected.

     ⦁ Example: Yes

     ⦁ Field Type and Length: text

     ⦁ Sample file column: I

     ⦁ Import Status: Optional

 

School Type

     ⦁ Explanation: Accepted values are:

  • Regular school
  • Special Education School
  • Vocational School
  • Other/Alternative School
  • Reportable Program

     ⦁ Example: Vocational School

     ⦁ Field Type and Length: text

     ⦁ Sample file column: J

     ⦁ Import Status: Optional

 

Charter

     ⦁ Explanation: Is the school a charter school? Accepted values are “yes” or “no”

     ⦁ Example: Yes

     ⦁ Field Type and Length: text

     ⦁ Sample file column: K

     ⦁ Import Status: Optional

 

Magnet

     ⦁ Explanation: Is the school a magnet school? Accepted values are “yes” or “no”

     ⦁ Example: Yes

     ⦁ Field Type and Length: text

     ⦁ Sample file column: K

     ⦁ Import Status: Optional

 

Geographic Locale

     ⦁ Explanation: Accepted values are “City”, “Suburban”, “Town”, “Rural”

     ⦁ Example: Rural

     ⦁ Field Type and Length: text

     ⦁ Sample file column: L

     ⦁ Import Status: Optional

 

The following 7 fields record student enrollment demographics.  The enrollment counts will be used to generate a pie chart that will be displayed on the site detail page.  Please enter a percentage value.

American Indian/Alaska Native American

     ⦁ Explanation: Percentage of student enrollment that is American Indian or Alaska Native American

     ⦁ Example: 15

     ⦁ Field Type and Length: numeric

     ⦁ Sample file column: M

     ⦁ Import Status: Optional

 

Asian

     ⦁ Explanation: Percentage of student enrollment that is Asian

     ⦁ Example: 15

     ⦁ Field Type and Length: numeric

     ⦁ Sample file column: N

     ⦁ Import Status: Optional

 

Black

     ⦁ Explanation: Percentage of student enrollment that is Black

     ⦁ Example: 15

     ⦁ Field Type and Length: numeric

     ⦁ Sample file column: O

     ⦁ Import Status: Optional

 

Hispanic

     ⦁ Explanation: Percentage of student enrollment that is Hispanic

     ⦁ Example: 15

     ⦁ Field Type and Length: numeric

     ⦁ Sample file column: P

     ⦁ Import Status: Optional

 

Native Hawaiian/Pacific Islander

     ⦁ Explanation: Percentage of student enrollment that is Native Hawaiian or Pacific Islander

     ⦁ Example: 15

     ⦁ Field Type and Length: numeric

     ⦁ Sample file column: Q

     ⦁ Import Status: Optional

 

White

     ⦁ Explanation: Percentage of student enrollment that is White

     ⦁ Example: 15

     ⦁ Field Type and Length: numeric

     ⦁ Sample file column: R

     ⦁ Import Status: Optional

 

Two or more races

     ⦁ Explanation: Percentage of student enrollment that is two or more races

     ⦁ Example: 15

     ⦁ Field Type and Length: numeric

     ⦁ Sample file column: S

     ⦁ Import Status: Optional

 

Free Lunch Eligible

     ⦁ Explanation: The percentage of the student population eligible to participate in the  free programs under the National School Lunch Act of 1946

     ⦁ Example: 35

     ⦁ Field Type and Length: numeric

     ⦁ Sample file column: T

     ⦁ Import Status: Optional

 

Reduced Price Lunch Eligible

     ⦁ Explanation: The percentage of the student population eligible to participate in the  Reduced-Price Lunch programs under the National School Lunch Act of 1946

     ⦁ Example: 35

     ⦁ Field Type and Length: numeric

     ⦁ Sample file column: U

     ⦁ Import Status: Optional

 

Free Lunch Eligible

     ⦁ Explanation: The percentage of the student population eligible to participate in the  free or programs under the National School Lunch Act of 1946

     ⦁ Example: 35

     ⦁ Field Type and Length: numeric

     ⦁ Sample file column: T

     ⦁ Import Status: Optional

Was this article helpful?
0 out of 1 found this helpful

Articles in this section

How to Contact Support
There are many ways to reach out! Click here for our support options.
Watermark Academy
Click to access the Watermark Academy for consultation, training, and implementation companion courses.