Skip to main content
Skip table of contents

StudentSchoolEnrollment

The PowerSchool SIF Agent provides publishing capabilities for the following data object and its elements:

Element/@Attribute

Source

Table

Column

Notes

 

@RefId

Mapped

Students

StudentSchlEnrl_guid

The ID (GUID) that uniquely identifies a particular enrollment.

 

@StudentPersonalRefId

Mapped

Students

StudentPers_guid

The ID (GUID) of the student to whom this information is linked.

 

@SchoolInfoRefId

Mapped

Schools

SchoolInfo_guid

The ID (GUID) of the school to which this enrollment applies.

 

@MembershipType

Mapped

PS_Enrollment_SIF_WY

(View)

MembershipType

The type of this enrollment as it relates to the school identified in SchoolInfoRefId.
Valid values:
Home
Concurrent

 

TimeFrame

Derived

Calculated
Current, Historical, Future, or TBD based on Students.EntryDate and Students.ExitDate

 

 

The timeframe of the enrollment based on the SIF_Date in the SIF_Header of the message. For events, it is determined as of the date the event is generated. For requests and responses, it is calculated based on the date of the request.

@SchoolYear

Derived

Managed by the SIF agent

 

 

School year for which this enrollment is applicable, expressed as the four-digit year in which the school year ends e.g., "2011" for the 2010-11 school year).

EntryDate

Mapped

PS_Enrollment_SIF_WY

(View)

EntryDate

The date from when this enrollment is valid.

 

EntryType

 

 

 

 

 

EntryType/Code

Mapped

Students

EntryCode

Code indicating the type of entry for this enrollment.

 

EntryType/OtherCodeList

 

 

 

 

 

GradeLevel

Mapped

Students

Grade_Level

Grade or academic level of student.

 

Homeroom

 

 

 

 

 

@Sif_RefObject

 

Optional

 

 

 

Counselor

 

 

 

 

 

@Sif_RefObject

 

Optional

 

 

 

ExitDate

Mapped

PS_Enrollment_SIF_WY

(View)

LeaveDate

The ending date of this enrollment. If the student has exited before the end of the school year, ExitDate must have a value.

 

ExitStatus

 

 

 

 

 

ExitStatus/Code

 

 

 

Code indicating the exit type for this enrollment.

 

ExitStatus/OtherCodeList

 

 

 

 

 

ExitType

 

 

 

Required when a student has exited.

 

ExitType/Code

Mapped

Students

ExitCode

Code indicating the exit status for this enrollment.

 

ExitType/OtherCodeList

 

 

 

 

 

FTE

 

 

 

 

 

FTPTStatus

Derived

Students

HalfDay

Required when StudentSchoolEnrollment/GradeLevel = PK or KG.
If the GradeLevel = KG, and the FTPTStatus = PartTime, then StudentGradeLevel will be set to HK.
Valid values:
FullTime – Full Day Program
PartTime – Half Day Program

 

ResidencyStatus

 

 

 

 

 

ResidencyStatus/Code

 

 

 

 

 

ResidencyStatus/OtherCodeList

 

 

 

 

 

NonResidentAttendReason

 

 

 

 

 

SIF_Metadata

 

 

 

 

 

SIF_ExtendedElements/
SIF_ExtendedElements/
SIF_ExtendedElementName=
"StudentLunch"

Mapped

Students/
ReEnrollments

LunchStatus

 

 

SIF_ExtendedElements/
SIF_ExtendedElements/
SIF_ExtendedElementName=
"StudentHomeSchooled"

Mapped

Students/
ReEnrollments

StudentHomeSchooled

 

 

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.