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