Student Enrollment Data

studentReference/studentIdentity

Student enrolled in the school.

Integer

StudentUniqueId downloaded from State

Derived from:

[Students]DCID

M

schoolCalendarReference

R

/localEducationAgencyId

The LEA for which the calendar is defined.

Integer

LEAId downloaded from state.

Derived from:

[Prefs]Value where name=’districtnumber

R

/schoolYear

The school year for the District Calendar

Integer

Derived from:

YearId for term selected in the PowerSchool UI and

[DistrictCalendar]CalendarYear

R

/districtCalendarNumber

The number that the district has assigned to uniquely identify the calendar within the district

Integer

[TNDistrictCalendar]CalendarNumber

R

/schoolId

The school associated with the School Calendar.

Integer

SchoolID downloaded from State

Derived from:

[Prefs]Name=districtnumber 
[Prefs]Value

and

[Schools]Alternate_School_Number if
value is greater than 0
Otherwise [Schools]School_Number

R

/number

The number assigned to the instructional program to uniquely identify the instructional program within the school. May be any number between 01 and 99.

Integer

[S_TN_SCH_InstrProgram_C]InstructionalProgramNbr

and

[S_TN_SCH_InstrProgram_C]PowerSchoolTrack

Student track derived from:

[Students]Track

or

[ReEnrollments]Track

or [S_TN_STU_ConcurrentEnroll_C]ConTrack

schoolReference/schoolIdentity

School enrolling the student.

Integer

SchoolID downloaded from State

Derived from:

[Prefs]Name=districtnumber 
[Prefs]Value

and

[Schools]Alternate_School_Number if
value is greater than 0
Otherwise [Schools]School_Number

M

primarySchool

Indicates if a given enrollment record should be considered the primary record for a student. If omitted, the default is true.

Boolean

Derived from:

[S_TN_STU_X]ISPToS

[S_TN_REN_X]ISPToS

P: ‘True’; else ‘False’

O

schoolYear

The school year associated with the student’s enrollment.

Enumerated List

Derived from:

YearId for term selected in the PowerSchool UI

R

entryDate

The month, day, and year on which an individual enters and begins to receive instructional services in a campus.

Date

[Students]EntryDate (current)

[ReEnrollments]EntryDate (historical)

[S_TN_STU_ConcurrentEnroll_C]EntryDate

M

entryGradeLevel

The grade level or primary instructional level at which a student enters and receives services in a school or an educational institution during a given academic session.

Descriptor

Derived from:

[S_TN_STU_X]TransitionalGrade

[S_TN_REN_X]TransitionalGrade

[Students]Grade_Level (current)

[ReEnrollments]Grade_Level (historical)

If the TransitionalGrade flag is set,
then ‘T’ + grade level; else, grade level.

R

entryType

The process by which a student enters a school during a given academic session.

Descriptor

[Students]EntryCode (current)

[ReEnrollments]EntryCode (historical)

[S_TN_STU_ConcurrentEnroll_C]EntryCode

R

repeatGradeIndicator

An indicator of whether the student is enrolling to repeat a grade level, either by failure or by an agreement to hold the student back.

This element is required if applicable; otherwise it is excluded from publishing.

Boolean

Derived from:

[S_TN_STU_X]EndofServiceAction

R or D: ‘True’; else ‘False’

C

classOfSchoolYear

The projected High School graduation year.

This element is required if applicable; otherwise it is excluded from publishing.

Enumerated List

[Students]ClassOf

C

exitWithdrawDate

The month, day, and year of the first day after the date of an individual's last attendance at a campus (if known), the day on which an individual graduated, or the date on which it becomes known officially that an individual left school.

This element is required if applicable; otherwise it is excluded from publishing.

Date

[Students]ExitDate (current)

[ReEnrollments]ExitDate (historical)

[S_TN_STU_ConcurrentEnroll_C]ExitDate

C

exitWithdrawType

The circumstances under which the student exited from membership in an educational institution.

 This element is required if applicable; otherwise it is excluded from publishing.

Descriptor

[Students[ExitCode (current)

[ReEnrollments]ExitCode (historical)

[S_TN_STU_ConcurrentEnroll_C]ExitCode

C

graduationPlanReference/graduationPlanIdentity

graduationPlan is required if applicable; otherwise it is excluded from publishing.

This complex type is reported for middle and high school students only; it is not reported for concurrent enrollments.

C

/graduationPlanType

The graduation plan associated with the student enrolled in the school.

Descriptor

[S_TN_STU_X]CourseOfStudy

[S_TN_REN_X]CourseOfStudy

M

/educationOrganizationReference/
educationOrganizationIdentity

For standard plans defined by an education organization, this is the reference to the organization defining the plan. Individualized plans do not require this reference.

Integer

SchoolID downloaded from State

Derived from:

[Prefs]Name=districtnumber 
[Prefs]Value

and

[Schools]Alternate_School_Number
if value is greater than 0
Otherwise [Schools]School_Number

M

/graduationSchoolYear

The graduation school year associated with the graduation plan.

Enumerated List

[Students]ClassOf

M

homelessMcKinneyServedIndicator

Indication if the student is served by McKinney-Vento. Only reported if ‘Y’.

Varchar(1)

[S_TN_STU_X]HomelessServedByMcKinney

[S_TN_REN_X]HomelessServedByMcKinney

C

homelessUnaccompaniedIndicator

Indication if the student is Homeless and unaccompanied. Only reported if ‘Y’.

Varchar(1)

[S_TN_STU_X]HomelessUnaccompaniedYouth

[S_TN_REN_X]HomelessUnaccompaniedYouth

C

completionDocumentPeriod

The graduation period for the student, Spring, Summer, or Early

Descriptor

[S_TN_STU_X]GraduationPeriod

1: 'SP'

2: 'SU'

3: 'EA'

C

completionDocument

The type of completion document for the student at the end of the school enrollment, e.g. Regular Diploma, Honors, Special Ed, Certificate, GED

Descriptor

[S_TN_STU_X]Completion

C

completionDocumentDate

The date that the student’s end of service documentation was completed.

Date

[S_TN_STU_X]CompletionDate

R

fundingStatus (0-many)

R

/fundingStatus

The funding status of the student while enrolled at the associated school; an indication of whether the student is eligible for state funding.

Descriptor

[S_TN_STU_X]FundIneligStatus

R

/fundingBeginDate

The start date for the funding status.

Date

[S_TN_STU_X]FundIneligBeginDate

R

/fundingEndDate

The end date for the funding status.

Date

[S_TN_STU_X]FundIneligEndDate

O

instructionalServices (0-many)

The targeted assistance a student receives.

Descriptor

[S_TN_STU_TAInstrAssistance_C]AssistanceID

O

supportServices (0-many)

The student’s TA Support Service types

Descriptor

[S_TN_STU_TASupportAssistance_C]AssistanceID

O

totalInstructionalMins

The number of minutes for a full time student of this grade, expressed in minutes.

Integer

[S_TN_STU_X]StudentStandardDay

[S_TN_REN_X]StudentStandardDay

If blank:

[S_TN_SCH_X]StndDayDuration

R

studentStandardDayEffectiveDate

The start date for this student’s standard day. This is the student’s first in-session day as of their school entry date

Date

[Calendar_Day]Date

Derived from:

Firstin-session day following
student’s entry date.

R

studentReference/studentIdentity

The student enrolled in the section.

Integer

StudentUniqueId downloaded from State

Derived from:

[CC]StudentID

M

sectionReference/sectionIdentity

The section in which the student is enrolled.

M

/locationReference/locationIdentity

The location, typically a classroom, where the section meets.

M

//classroomIdentificationCode

A unique number or alphanumeric code assigned to a room by a school, school system, state, or other agency or resource.

Varchar(20)

[Sections]Room

Default: ‘OPEN’

M

//schoolReference/schoolIdentity

The school for the section’s classroom.

Integer

SchoolID downloaded from State

Derived from:

[Prefs]Name=districtnumber 
[Prefs]Value

and

[Schools]Alternate_School_Number if value is greater than 0
Otherwise [Schools]School_Number

M

/classPeriodReference/classPeriodIdentity

The class period during which the section meets.

M

//classPeriodName

An indication of the portion of a typical daily session in which students receive instruction in a specified subject, for example, morning, sixth period, block period, or AB schedules.

Varchar(20)

[Period]Period_Number

Derived from:

[Section_Meeting]Period_Number

M

//schoolReference/schoolIdentity

The school for which the period is defined.

Integer

SchoolID downloaded from State

Derived from:

[Prefs]Name=districtnumber 
[Prefs]Value

and

[Schools]Alternate_School_Number if value is greater than 0
Otherwise [Schools]School_Number

M

/courseOfferingReference/courseOfferingIdentity

The course offering taught in the section.

M

//localCourseCode

The local code assigned by the LEA or Campus that identifies the organization of subject matter and related learning experiences provided for the instruction of students; must match LocalCourseCode in corresponding CourseOffering.

Varchar(60)

If Report Course.Section setting is set to Yes, then Local Course Number + Section_Number +’_’+ Section DCID

Otherwise,

[Sections]ID

M

//term

The name of the term in which the section is offered, for example, First semester, Second semester, Year long, Summer school. This must match Term in corresponding CourseOffering.

Enumerated List

[Sections]TermID

[Terms]Portion

[Terms]Abbreviation

M

//schoolYear

The identifier for the school year, for example, 2010-2011. This must match SchoolYear in corresponding CourseOffering.

Enumerated List

[Terms]YearID

M

//schoolReference/schoolIdentity

The school offering the course; must match SchoolID in corresponding CourseOffering.

Integer

SchoolID downloaded from State

Derived from:

[Prefs]Name=districtnumber 
[Prefs]Value

and

[Schools]Alternate_School_Number if value is greater than 0
Otherwise [Schools]School_Number

M

beginDate

Month, day, and year of the student's entry or assignment to the section. If blank, default is the start date of the first grading period.

Date

[CC]DateEnrolled

R

endDate

Month, day, and year of the withdrawal or exit of the student from the section.

This element is required if applicable; otherwise it is excluded from publishing.

Date

[CC]DateLeft

C

homeroomIndicator

Indicator that the class is the student's designated homeroom used for daily attendance reporting.

Boolean

[S_TN_CRS_X]HomeroomClass_TF

1: ‘True’

If blank:

[Courses]Alt_Course_Number

If Alt_Course_Number in ('0003', '0100', '0200', '0300' ,'0400' , '0500', '0600', '0700', '0800', '9385', '9685') ‘True’

The UI is a checkbox, so if it is checked the value is '1' and Homeroom Indicator = 'true'.  Otherwise (i.e., if the value is null or zero (or anything <> 1), then the alt_course_number rule is used to determine true or false.

R

vocationalOutsideIEPIndicator

Indicator of whether the student’s course meets vocational qualification above the base 23.5 Special Ed.

Boolean

‘True’ if all of the following conditions are met:

[Courses]Vocational = 1

Student has a record in [SpEnrollments] where [Gen]ID = [SpEnrollments] ProgramID

[Gen]Name = ‘Option 07’, ‘Option 08’, or ‘Option 09’

Student has a record in [S_TN_STU_EasyIEP_X] where ‘OutsideIEP’ is not blank

Else: ‘False’

C

schoolReference/schoolID

School where the student is currently enrolled.

Integer

SchoolID downloaded from State

Derived from:

[Prefs]Name=districtnumber 
[Prefs]Value

and

[Schools]Alternate_School_Number if value is greater than 0
Otherwise [Schools]School_Number

R

studentUniqueId

The student with which the classification is associated.

Integer

StudentUniqueId downloaded from State.

Derived from:

[S_TN_STU_StuClassification_C]ForeignKey
or [S_TN_STU_LunchClassification_C]ForeignKey

R

entryDate

The student's current enrollment date

Date

[Students]EntryDate

[ReEnrollments]EntryDate

R

descriptor

studentClassificationType – Information used to further identify and classify a student.

Note: A student may require multiple classification types.

Descriptor

Derived from:

[S_TN_STU_StuClassification_C]ClassificationType

[S_TN_STU_LunchClassification_C]ClassificationType

• R: 'Regular'
• A: 'Alternative'
• G: 'GED+2'
• T: 'Title I'
• M: 'Magnet'
• P: 'Private'
• L: 'Pre-K EconDis'
• H: 'Homeless'
• I: 'Migrant'
• K: 'Residential Mental Health Facilities'
• D: 'Adult'
• C: 'Rita'
• O: 'Lottery Funded P4 only'
• Q: 'State funded: expansion/pilot'
• F: 'Lottery Funded P3, P4 only'
• E: 'Head Start Funded P3, P4'
• V: 'Even Start Funded P3, P4'
• B: 'Fee Based P3, P4'
• N: 'Early Reading First P3, P4'
• W: 'Imagination Library'
• 1: 'LEAPs participant'
• 2: '21st CCL Participant'
• FOS01: 'Foster Care'
• DYS01: 'Dyslexia Specific'
• PDG01: 'PDG Expansion'
• PDG02: 'VPK with PDG enhancement'

R

beginDate

The first day that the student was in this classification.

Date

Derived from:

[Students]EntryDate

[ReEnrollments]EntryDate

And

[S_TN_STU_StuClassification_C]BeginDate

[S_TN_STU_LunchClassification_C]BeginDate

R

endDate

The last day that the student was in this classification.

Date

Derived from:

[Students]ExitDate

[ReEnrollments]ExitDate

And

[S_TN_STU_StuClassification_C]EndDate

[S_TN_STU_LunchClassification_C]EndDate

O

graduationPlanType

The type of academic plan the student is following for graduation, for example, Minimum, Recommended, Distinguished, or Standard.

Descriptor

[S_TN_STU_X]CourseOfStudy

[S_TN_REN_X]CourseOfStudy

A record is published for each of the three valid values (Technical, University, and Dual) for each secondary school and each graduating school year represented by the published students.

M

individualPlan

An indicator of whether the graduation plan is tailored for an individual.

Boolean

'False'

R

totalRequiredCredits

The total number of credits required for graduation under this plan.

R

/credit

The total number of credits required for graduation under this plan.

Decimal(9,2)

'22'

R

educationOrganizationReference/
educationOrganizationIdentity

The reference to the education organization defining the plan.

Integer

SchoolID downloaded from State

Derived from:

[Prefs]Name=districtnumber 
[Prefs]Value

and

[Schools]Alternate_School_Number if value is greater than 0
Otherwise [Schools]School_Number

Separate record for each school using GraduationPlan

M

graduationSchoolYear

The graduation school year associated with the graduation plan.

Enumerated List

[Students]ClassOf

Separate record for each graduation year for selected students

M

studentReference/studentIdentity

A unique alphanumeric code assigned to a student.

Integer

StudentUniqueId downloaded from State

Derived from:

[Transportation]StudentId

R

educationOrganizationReference/
educationOrganizationIdentity

The EducationOrganization associated with the student.

Integer

SchoolID downloaded from State

Derived from:

[Prefs]Name=districtnumber 
[Prefs]Value

and

[Schools]Alternate_School_Number if value is greater than 0
Otherwise [Schools]School_Number

R

amBusNumber

The number of the bus for the student's bus route (AM).

Varchar(10)

[Transportation]BusNumber

R

pmBusNumber

The number of the bus for the student's bus route (PM).

Varchar(10)

[Transportation]BusNumber

R

estimatedMilesFromSchool

The number of miles the student travels to or from school.

Decimal(5,2)

[Transportation]Distance

When [Transportation]DistanceIndicator = 'K', the Distance is multiplied by 0.621371 to calculate the miles.

If AM distance and PM distance are different values, the larger value is used.

R