HALLWAYS HOME | SUPPORT HOME | REGISTER | REPORT A BUG |CONTACT US

 

 

 

       

Hallways4 > Support > Getting Started > Importing Student PEIMS Data

 

  Importing Student Data: Step 1

 

 

 

Hallways 4 comes with the ability to import student data directly into Hallways from Excel.

Organizing Student Data

Download the Sample Excel file here.

The student data should be organized as follows:

COL.

Field Name

Data Type

Explanation

A

ID

General

Student's unique Local ID number

B

LastName

General

Last Name

C

FirstName

General

First Name

D

Initial

General

Middle Initial

E

Address

General

Street Address

F

City

General

City

G

State

General

State

H

PostalCode

General

Zip Code

I

HomePhone

General

10 digit phone number: numbers only, no dashes

J

Gender

General

Student Gender: M or F

K

Birthdate

Date/Time

Birthdate: must be in MM/DD/YY format

L

Parent/Guardian

General

Parent/Guardian Name

M

Grade

General

Student’s Grade: See Below

N

Age

General

Student’s Age

O

Intake

Date/Time

Date first seen: must be in MM/DD/YY format

P

Discharge

Date/Time

Date discharged: must be in MM/DD/YY format

Q

Status

General

Student's counseling status

R

ETH

General

Ethnicity

S

DIS

General

Economically Disadvantaged

T

TII

General

TII Status

U

MIG

General

Migrant

V

BIL

General

Bilingual

W

ESL

General

English Second Language

X

SPECD

General

Special Ed

Y

GT

General

Gifted/Talented

Z

SEX

General

Gender

AA

ADA

General

ADA Eligibility

AB

LEP

General

Limited English Proficiency

AC

PP

General

Parental Permission

AD

Risk

General

At Risk

AE

TECH

General

Technological Program

AF

IMM

General

Immigrant

AG

HL

General

Home Language

 

Student ID numbers must be unique to each student. The numbers 0, 1, 2, and 3 are reserved by Hallways. If you don’t have Student ID numbers assigned, use the Excel Column Fill function to assign numbers.

 Student Grades should be in the format: PK, K, 01, 02, 03 etc. up to 11, 12

Be sure to set the student’s Status (Column Q) as current if you are currently providing services to the student.

When you have finished organizing the data, save the file and close it. Be sure to keep it as an Excel 97-2003 (.xls) file or Hallways will not be able to read it.

Importing Student Data: Step 2 >>