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