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. |
|
TimeFrame | Derived | Calculated |
|
| 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. |
|
ResidencyStatus |
|
|
|
|
|
ResidencyStatus/Code |
|
|
|
|
|
ResidencyStatus/OtherCodeList |
|
|
|
|
|
NonResidentAttendReason |
|
|
|
|
|
SIF_Metadata |
|
|
|
|
|
SIF_ExtendedElements/ | Mapped | Students/ | LunchStatus |
|
|
SIF_ExtendedElements/ | Mapped | Students/ | StudentHomeSchooled |
|
|