Start a conversation Sign in
Start a conversation
  1. Xenegrade
  2. Integrated and Custom Features
  3. Custom Applications

Export SIRIS Data

The Export SIRIS workflow is a custom process to export SIRIS data to an XML format.

To Export SIRIS Data

  • Release 2: Go to Admin Menu > Export Functions > Export SIRIS
  • Release 3: This custom workflow is not yet available in Release 3.
  • Select a [Session] desired to filter the data. Required.
  • Select the [Branch] desired to filter the data. Optional. If no selection is made, all Branches are included in the output.
  • Select the [Data to Export]. Required.
  • Click the [Export] button.
  • A fully white screen will display while the data is processed. Once the process is completed, a [File Save As] popup form will display.
  • Enter a file name and location to save the XML file locally. You may name the file as desired.
  • Close the white screen.

Notes:

  • The export should only be run be one user at a time.
  • Each time the export is run, the export file that is created in the background is deleted and replaced with a new version.

Data Definitions for the Sections Export

  • In addition to the filters selected by the user, this additional filter is hard coded into the export:
    • Includes only course sections where students have assignments with a status of "Enrolled/Active" and also have attendance recorded for the same course section.
  • The fields included in the XML export are obtained and defined as follows:
  • campusCourseId: CourseID
  • SUNYCourseId: Null
  • campusSectionId: SectionID
  • SUNYSectionId: Null
  • sectionTitle: CourseTitle
  • sectionContentCode: CIP Code
  • academicDepartmentCode: Null
  • sectionBeginDate: Date Start
  • sectionEndDate: End Date
  • sectionCensusDate: Calculated as (DateStart + (datediff(d, DateStart, DateEnd) * .20)) where "datediff(d" is the number of days marking the 20% date. (added 6/30/2022)
  • sectionTerm: Where Session contains Summer = 1, Fall = 2, Winter = 3, Spring = 4
  • onlineInstructionType: 001
  • instructionType: 001
  • studentCreditContactHourRelationship: 001
  • otherContactHourSpecification: Null
  • totalFacultyContactHours: Section Total Hours
  • totalStudentContactHours: Section Total Hours
  • sectionStudentEnrollment: Active assignment count
  • fundingSource: 5
  • sectionFee: 0
  • insuranceIndicator: 001
  • locationType: 9
  • locationSiteAnotherCollege: Null
  • locationSiteStudyAbroad: Null
  • simultaneousUsage: Null
  • sunySubCampusIdentifier: Null
  • sectionYear: Four digit year based on the Date Start
  • internshipType: Null
  • Meetings
    • dayCode: Code for Monday through Sunday starting as 001 through 007
    • startHour: Null
    • startMinute: Null
    • endHour: Null
    • endMinute: Null
    • buildingCode: Remote
    • buildingRoomCode: remote
    • desiredFacilityRequirements: Null
  • Instructors
    • instructorSSN: Staff SSN
    • instructorLocalCampusId: Staf SSN
    • instructorSUNYId: Null
    • instructorLastName: Staff Last Name
    • instructorFirstName: Staff First Name
    • instructorMiddleInitial: Null
    • fullTimeIndicator: Staff Active Status field
    • academicRank: 7
    • tenureStatus: 3
    • highestDegreeEarned: 4
  • Enrollments
    • studentSSN: Student SSN
    • studentLocalCampusId: Client XenDirect ID
    • studentSUNYId: Null
    • studentLastName: Student Last Name
    • creditsAttempted: To be determined
    • creditsEarned: To be determined
    • gradeEarned: Grade from Assignment record
    • withdrawDate: Null
    • studentOnlineIndicator: 1

Data Definitions for the Students Export

  • In addition to the filters selected by the user, this additional filter is hard coded into the export:
    • Includes only course sections where students have assignments with a status of "Enrolled/Active" and also have attendance recorded for the same course section.
  • The fields included in the XML export are obtained and defined as follows:
    • actionCode: A
    • studentSegmentIndicator: Null
    • studentLocalId: Null
    • SUNYStudentId: Null
    • ssn: Student SSN
    • dateOfBirth: Client date of birth
    • gender: Client Gender
    • studentNameLast: Client Last Name
    • studentNameFirst: Client First Name
    • studentNameMiddle: Client Middle Initial
    • studentNameSuffix: Client Name Suffix
    • countryOfCitizenship: Currently 999 - Need to determine how to convert to code
    • visaCode: Null
    • permanentStreetAddress: Client Mailing Street 1
    • permanentAptPOBox: Null
    • permanentCity: Client Mailing City
    • permanentCounty: Currently 029 - Need to determine how to convert to code
    • permanentStateUSTerritory: Client Mailing State
    • permanentZipCode: Client Mailing Postal Code
    • permanentCountryCode: Currently USA - To be determined how to convert
    • permanentForeignProvince: Null
    • permanentForeignPostalCode: Null
    • englishAsNativeLanguage: Client English Native Language
    • hispanicOrigin: Client Ethnicity
    • raceCategory: Client Ethnicity
    • militaryServiceStatus: Null
    • formerInstitutionUnitId: Null
    • formerInstitutionCeeb: Null
    • highestDegreeEarned: 009
    • highSchoolStatus: Null
    • highSchoolGraduationYear: Null
    • highSchoolCeeb: Null
    • admissionStatus: 005
    • higherEducationHistory: Null
    • primaryAcademicProgramId: Null
    • primaryAcademicAwardLevel: 008
    • secondaryAcademicProgramId: Null
    • totalCreditHours: 19.00
    • stateSupportedLowerDivisionCredits: Null
    • stateSupportedUpperDivisionCredits: Null
    • stateSupportedGraduateCredits: Null
    • accumulatedCreditHours: Null
    • transferCreditHours: Null
    • cumulativeGradePointAverage: Null
    • pellGrantRecipientIndicator: 0
    • tapGrantRecipientIndicator: 0
    • tuitionRateIndicator: 006
    • housingIndicator: 002
    • studentGoal: Null

Page last revised 6/30/2022


Choose files or drag and drop files