Spreadsheet: a5123540-0f84-4667-a31c-836977bc89b3
Sheet: SIF Objects List

Object | Provide | Subscribe | Events |  | Clearinghouse | eTranscripts | SSID
CalendarSummary | x |  |  |  | x
DisciplineIncident | x |  |  |  | x
LEAInfo | x |  |  |  | x | x | x
SchoolCourseInfo | x |  |  |  | x | x
SchoolInfo | x |  |  |  | x | x | x
SectionInfo | x |  |  |  | x
StaffPersonal | o |  |  |  | o |  |  | Not needed if alternative mapping used (UT.081, UT.086, UT.087) See VRF Environment Variable Notes: Vrf.Target.usesStaffPersonal
StudentAcademicRecord | x |  |  |  |  | x |  | See VRF Environment Variable Notes
StudentAttendanceSummary | x |  |  |  | x |  |  | See VRF Environment Variable Notes: Vrf.Property.ProrateMembershipDays
StudentDemographicRecord | x |  |  |  |  | x |  | See VRF Environment Variable Notes
StudentGrade | o |  |  |  | x |  |  | Not needed if alternative mapping used (UT.096, [NAME]) See VRF Environment Variable Notes: Vrf.Target.usesStudentGrade
StudentParticipation | x |  |  |  | x |  |  | See VRF Environment Variable Notes: Vrf.Property.SubtractSIFProgramDays
StudentPersonal | x | x | x |  | x | x | x
StudentSchoolEnrollment | x |  | x |  | x | x | x
StudentSectionEnrollment | x |  |  |  | x
TermInfo | x |  |  |  | x
VRF Environment Variable Notes
Vrf.Target.usesStaffPersonal
Object: StaffPersonal
Purpose: indicates if StaffPersonal required - i.e. if manifest uses StaffPersonal for Course Master teacher IDs
Default value: 'false' (SIS2000)
Usage: set value 'true' for PowerSchool or any other SIS that uses StaffPersonal for Course Master teacher IDs, rather than extended element
Vrf.Target.usesStudentGrade
Object: StudentGrade
Purpose: indicates if StudentGrade required - i.e. if manifest uses StudentGrade for Course Membership credits earned and grade earned
Default value: 'false' (SIS2000)
Usage: set value 'true' for PowerSchool or any other SIS that uses StudentGrade for Course Membership credits earned and grade earned, rather than extended element
Vrf.Property.SubtractSIFProgramDays
Object: StudentParticipation (manifest SQL flag, does not affect SIF collection)
Purpose: indicates if manifest needs to subtract [NAME] and S3 self-contained program days from School Membership days
Default value: 'false' (SIS2000)
Usage: set value 'true' for PowerSchool or any other SIS that includes self-contained program days in the published School Membership value
Vrf.Property.ProrateMembershipDays
Object: StudentAttendanceSummary (manifest SQL flag, does not affect SIF collection)
Purpose: indicates if manifest needs to prorate StudentAttendanceSummary data between multiple enrollments at same school
Default value: 'false' (PowerSchool)
Usage: set value 'true' for SIS2000 or any other SIS that does not create a separate StudentAttendanceSummary record for each StudentSchoolEnrollment record
Notes: Should be set true for any SIS agent that does not populate StudentAttendanceSummary/StudentSchoolEnrollmentRefId
Vrf.Target.usesSREGradeLevelSIFQuery
Vrf.Target.skipsSREGradeLevelSIFQuery
Object: StudentAcademicRecord, StudentDemographicRecord
Purpose: Used in tandem to indicate if collection SIF_Query should use or skip grade level constraints on SRE (transcript) objects
Default values: uses = false, skips = 'true' (SIS2000)
Usage: set Vrf.Target.usesSREGradeLevelSIFQuery = ‘true’ and Vrf.Target.skipsSREGradeLevelSIFQuery = ‘false’ for PowerSchool or any other SIS that supports SIF_Query
for constraining grade level in SRE requests
Notes
Default settings should work for any SIS, but may be slower where SIS agent supports SIF_Query grade level constraint (e.g. PowerSchool)
If either default value is overridden, both must be – one must always be false and the other must be true
StudentDemographicRecord must also support constraining record selection by grade level (in StudentAcademicRecord)
In the future, if only the 'uses' variable becomes necessary, the 'skips' variable (though no longer necessary) will not require deletion