Abre Export

Modified on Fri, Nov 10, 2023 at 1:21 PM

Abre Export


Overview

This task exports data for Abre. It will create up to twenty csv files: Courses, Staff, Staff Schedules, Students, Student Schedules, AD, EL, Parent Contacts, Attendance, Student Assessments, Grades, Assignments, Student Counselors, Attendance Cumulative, Attendance Cumulative 2, Attendance State Metrics, Student Unweighted GPA, Student Credits, Behavior and Discipline.


Options

The export can be configured to save locally, be sent in an email, or have the files sent to another machine using (S)FTP.

Individual files can be selected to be included.

Individual schools can be selected to be included.


Output

Courses

Column

School Code

Course Code

Section Code

Staff ID

Term Code

Period


Staff

Column

Staff ID

School Code

First Name

Middle Name

Last Name

Gender

Date of Birth

Address Line 1
Address Line 2
City
State
Zip Code
Phone
Email
Hiring Date


Staff Schedules

Column

Staff ID

School Code

Course Code

Section Code

Term Code

Period

Course Name

Teacher Name


Students

Column

StudentID

Student First Name

Student Middle Name

Student Last Name

Gender

Ethnicity Code

Ethnicity Description

Date of Birth
Email
SSID
IEP Status
Gifted Status
Economically Disadvantaged
Title 1
Title 3
ELL Status
School Code
School Name
Current Grade
Status
Username
Password
504 Status
Ok to Publish


Student Schedules

Column

StudentID

Student First Name

Student Last Name

School Code

Course Code

Course Name

Staff ID

Teacher Name
Term Code
Period
Student IEP Status
Student Gifted Status
Student ELL Status
Room Number


AD

Column

Email

Student ID


EL

Column

Student ID

Status

Status Code

Date Identified

Home Language

Home Language Code

Native Language

Native Language Code
Place of Birth
Country of Birth
Country of Birth Code
US Start Date
English Proficiency


Parent Contacts

Column

Student ID

Parent First Name

Parent Last Name

Parent Address Line 1

Parent Address Line 2

Parent City

Parent State

Parent Zip Code
Parent Phone 1
Parent Phone 2
Parent Email
Relationship
Description
Primary Contact


Attendance

Column

Student ID

School Code

Absence Date

Absence Reason Code

Absence Reason Description

Absence Category Code

Hours Missed

Attendance Level


Student Assessments

Column

Student ID

First Name

Last Name

Grade Level

Status

Test Name

Test Date

Assessment Area
Accommodations
Scaled Score
Performance Level
School Code


Grades

Column

Student ID

Course Code

Section Code

School Code

Staff ID

Term Code

Period

Class Name
Teacher Name
Letter Grade
Percentage
Performance


Assignments

Column

Student ID

Course Code

Section Code

School Code

Staff ID

Term Code

Period

Title
Description
Due Date
Category
Earned Points
Possible Points
Weight
Comment
Published


Student Counselors

Column

Student First Name

Student Last Name

Student ID

Grade Level

Student Status

Student IEP Status

Student Gifted Status

Student ELL Status
Counselor First Name
Counselor Last Name
Counselor Staff ID
School Code


Attendance Cumulative

Column

Student ID

Hours Attended

Days Attended

Hours Absent Excused

Days Absent Excuse

Hours Absent Unexcused

Days Absent Unexcused


Attendance Cumulative 2

Column

Student ID

Days Enrolled

Days Attended

Days Absent Total

Days Absent Excused

Days Absent Unexcused

Hours Attended

Hours Absent Excused
Hours Absent Unexcused
Max Enrollment
Max Allowed Absences
Current Absences
ADA (Average Daily Attendance)
Recoverability


Attendance State Metrics

Column

Student ID

Absence Hours Month Total

Absence Hours Month Total Cutpoint

Absence Hours Year Total

Absence Hours Year Total Cutpoint

Absence Hours Consecutive Unexcused

Absence Hours Consec Unexcused Cutpoint

Absence Hours Month Unexcused
Absence Hours Month Unexcused
Absence Hours Year Unexcused
Absence Hours Year Unexcused Cutpoint


Student Unweighted GPA

Column

Student ID

Student First Name

Student Last Name

GPA

School Building


Student Credits

Column

Student ID

Total Credits

Academic End Year

Term

Subject Area


Behavior

Column

Student ID

Incident ID

Incident Date

Referring Staff

Behavior Code

Behavior Description

Response Code

Response Description
Response Total Days


Discipline

Column

StudentID

SSID

endYear

Role

IncidentBuilding

IncidentID

IncidentTitle

IncidentDate
IncidentTime
Location
SubmittedBy
Status
EventID
EventType
EventCode
EventName
EventStateCode
EventStateName
EventCategory
ActionID
ActionCode
ActionName
ActionStateCode
ActionStateName
SuspensionStartDate
SuspensionEndDate
Expulsion
LawReferred



Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article