WIXLIB

Page: 0SIS Applications Overview - 1992Change Date: 9/28/2012 9:28:53 AMSIS Planning ProjectCE – Computer Enrollment(Student Self-Service)TE – Telephone Enrollment(Student Self-Service)Manual PaperProcessesSIS Core ApplicationsSISExternal Systems(FedGov, MET etc.)Tightly CoupledSAMAD – AdmissionsFA – Financial AidAH – Academic HistoryLA – Loan Application ProcessingAR – Accounts ReceivableTA – Table, Audit and Data Dict.AS – Fee AssessmentCC – Course CatalogDB – DisbursementCM - CommunicationsCS – Course ScheduleDA – Degree AuditFL – FacilitiesGD – GradesGP – General PersonOS – Organization StructureRG – RegistrationDWH(Batch)CBC ExtractsFinaid (Legacy)(Student Self-Service)10% of current StuinfoCopyright 2011 Michigan State University. All rights reserved.SIS Applications Landscape.vsdIntegration Applications(Finance, HR, Payroll etc.)25% of current applications

SIS Applications OverviewPage: 1Change Date: 9/28/2012 9:28:53 AMSIS Planning ProjectSIS Central Applications (RO, OA, OFA, CO)ROPage 3OARO – Registrars OfficeApplicationsSIS Core ApplicationsSISPage 3-8External Systems(Aetna, Cashnet,FedGov, MET etc.)Page 4OA – Office of AdmissionsApplicationsPage 2Tightly CoupledPage 7Integration Applications(HR/Payroll, KFS, FAIS,ADIS, FAMIS etc.)SAMAD – AdmissionsFA – Financial AidAH – Academic HistoryLA – Loan Application ProcessingAR – Accounts ReceivableTA – Table, Audit and Data Dict.AS – Fee AssessmentCC – Course CatalogDB – DisbursementCM - CommunicationsCS – Course ScheduleDA – Degree AuditFL – FacilitiesGD – GradesGP – General PersonOS – Organization StructureRG – CBC ExtractsMSUDATAAISDB1 Etc.Manual PaperProcesses (Some1992 processesautomated;some new)Page 8Academic UnitApplications(College of Music SS etc.)Page 8Other Administrative andSupport Unit Applications(GradInfo, TMS etc.)OFAPage 5OFA – Office of FinancialAid ApplicationsCopyright 2011 Michigan State University. All rights reserved.SIS Applications Landscape.vsdCOPage 6CO – Controllers OfficeApplications

SIS Core Applications Data FlowPage: 2Change Date: 9/28/2012 9:28:53 AMSIS Planning ProjectMainframeServersSISTightly CoupledSAMMacros usingHostExplorer byOpenText(Hummingbird))(Real-Time)Screen BasedAD – AdmissionsFA – Financial AidAH – Academic HistoryLA – Loan Application ProcessingAR – Accounts ReceivableTA – Table, Audit and Data Dict.AS – Fee AssessmentCC – Course CatalogDB – DisbursementCM - CommunicationsCS – Course ScheduleDA – Degree AuditFL – FacilitiesGD – GradesGP – General PersonOS – Organization StructureRG – RegistrationScreen basedStaff/Faculty/Students/PublicVended product that enables a webapplication to communicate directlywith the SIS mainframe applicationin real time (Service Calls).ShadowIDMS Connector(Real-Time)Screen ElementsScheduled BatchJobs s etc.)FTPShadow(ProgressSoftware –InnerAccess)(Real-Time)SIS Supporting ApplicationsSupporting AppsWebEnroll, CLIFMS, DEGNAV,AthlInfo STuInfo etc.Data Files tobe processedinto SIS(Delayed)DB format like SISINFO DB(real time)DARSTRAN(IBM MQ Series)Cogito (ISP)(Real-Time)SIS/SAM IDMSDataBaseIBM MQ Series(Messaging)CBC Extracts-I(COBOL,DYL,SAS)(Delayed)CBC Extracts(Delayed)CBC: Client Base Computing – Aset of extracts from IDMS DB usedby clients to do their own reporting.Sole client reporting technique priorto data RealTime)SISREPL(Real-Time)Copy of IDMS DB (real time)Vended product that replicatesIDMS database to a MS SQL Serverdatabase using IBM messagingsystem MQ Series in real time.CBC Extracts-II(COBOL,DYL,SAS)(Delayed)Vended product that enables aweb application to communicatedirectly with the SIS mainframeapplication in real time (ScreenScraping).Staff/FacultySIS/SAM – IDMS OLTPMSUDATA(Delayed)FTPLoad/Update Utility(Delayed)AISDB1(Delayed)ETL or CopyCopy Sub-setof SIS Data(Delayed)Copies of SIS Data made to Centraland Departmental servers like SAP,HR, ES, OPB Servers, MSUEDW etc.In some cases the data isaggregated/transformed.Group of applicationsCopyright 2011 Michigan State University. All rights reserved.SIS Applications Landscape.vsd

SIS Registrars Office (RO) Applications - InscopePage: 3Change Date: 9/28/2012 9:28:53 AMSIS Planning Project120122AOPPreEnrl111AOP Pre-EnrollmentDegNav134J9100123GradApp101SISRO Online Forms forFaculty and StaffSAMTightly Coupled107AD – AdmissionsFA – Financial AidAH – Academic HistoryLA – Loan Application ProcessingAR – Accounts ReceivableTA – Table, Audit and Data Dict.AS – Fee AssessmentCC – Course CatalogDB – DisbursementCM - CommunicationsCS – Course ScheduleDA – Degree AuditFL – FacilitiesGD – GradesGP – General PersonOS – Organization StructureRG – RegistrationCoursesCSWorkCopyCourse Scheduling WorkCopySchedule of CoursesStudentAC117APAdminAcademic ProgramsAdministrative System245128SoC252SIS Core Applications (Jnn)ROFormsTranscriptsTranscriptsSIGStudent 00Web EnrollGraduate Application109WebEnroll255Athlete Information SystemDegree NavigatorElectronic StudentAcademic Folder105J9902ESAF110106AthlInfoWebGIJ7000Change of Address forStudentsWeb Grades Interface112InstrSysInstructor SystemSubTermCoursesSIS Subterm SREPLCBC ExtractsMSUDATAAISDB1 Etc.129TrnsCrdtJ3100100Transfer CreditTransfer Course DescriptionsClassroom EventsCalendarSOMStudent ConfidentialMessage CenterCo-Sponsored StudyAbroad ProgramsNSCH250MSDSFMichigan Student DataSystem File257SPFormsSatisfactory AcademicProgress FormsCopyright 2011 Michigan State University. All rights reserved.260ECSStudent EmergencyContact System103AcadPrgrms253ETEReportsEnrollment and Term EndReportsAcademic ProgramsSIS Applications Landscape.vsd258GuestAppGuest Application forAnother Institution261DeansList251Dean's ListNational Student ClearingHouse FTPNSCHF

SIS Office of Admissions (OA) Applications - InscopePage: 4Change Date: 9/28/2012 9:28:53 AMSIS Planning S205J2506OAPortal204PhaseIIAdmissions Test ScoreLoad MacrosProspect Load MacroMath Placement TestScoresLanguage Placement TestScoresOA Student PortalEntity Personnel CodeUpdatePhase II174203ESMenu173Enrollment Services Menu192MassCancel202MSUAppSIS Core Applications (Jnn)SISDocTrackOAAOPToolsJ2915Student Attribute LoadMacrosAOP Tools121AOPSchdCOLADMNT UpdateTightly CoupledSAM200AD – AdmissionsFA – Financial AidAH – Academic HistoryLA – Loan Application ProcessingAR – Accounts ReceivableTA – Table, Audit and Data Dict.AS – Fee AssessmentCC – Course CatalogDB – DisbursementCM - CommunicationsCS – Course ScheduleDA – Degree AuditFL – FacilitiesGD – GradesGP – General PersonOS – Organization StructureRG – RegistrationSALMacro212COLADMNTMass CancelMSU Application forAdmissionDocument Tracking DMSREPLSISREPLCBC ExtractsMSUDATAAISDB1 Etc.AOPAsgn201AOPApptAOP Assignment SystemAOP Appointment197199AppKeyEntyReplaceApplication Keying FormEntity Replacement196195J2900PGBLADSPGBL SystemAOP 2nd Day SchedulingSystem186EMASCRMCustomer RelationManagement138EntityInfoJ9905Entity Information SystemCopyright 2011 Michigan State University. All rights reserved.188CreateOAWSGenerate OAS WorksheetsADS System193EntySearchEntity Search116AOPCAPJ2507AOP College AdvisingProfilesSIS Applications FISHFISH

SIS Office of Financial Aid (OFA) Applications - InscopePage: 5Change Date: 9/28/2012 9:28:53 AMSIS Planning Project143PLUSLAF144Parent Plus LoanApplication FormParentTaxParent Tax VerificationForms for Financial Aid145PLUSRep168PLUS Replacement Form171Short Term LoanAuthorization FormSIS Core Applications (Jnn)SISFAPackaging170Financial Aid Packaging167STLAuthFATrackFinancial Aid TrackAssignmentScholarship AwardAdministration FormSSNDMacroSSN Discrepancy Macro237FISAPInstitutional Reporting(FISAP) - FederalCopyright 2011 Michigan State University. All rights PLSISREPLCBC ExtractsMSUDATAAISDB1 Etc.IRStateOFAInstitutional Reporting(OFA) - State239IRStateMSUInstitutional Reporting(OFA) - MSUSIS Applications Landscape.vsdReconRPJ55 Reconcilliation ReportProcessingCS – Course ScheduleDA – Degree AuditFL – FacilitiesGD – GradesGP – General PersonOS – Organization StructureRG – RegistrationSAAF235Tightly CoupledAD – AdmissionsFA – Financial AidAH – Academic HistoryLA – Loan Application ProcessingAR – Accounts ReceivableTA – Table, Audit and Data Dict.AS – Fee AssessmentCC – Course CatalogDB – DisbursementCM - CommunicationsPgmSubmitterDaily Program Submitter236SCFScholarship CandidateFinder169NPCNet Price Calculator andAid Estimator278BestimatorBill Estimator

SIS Controllers Office (CO) Applications - InscopePage: 6Change Date: 9/28/2012 9:28:53 AMSIS Planning Project149156AMSAdvance t TrackerQB165METWebBOAQuickBooksMET WebCORE148RCS222CORE - One StepCashiering SystemBank LockboxSIS151150AD – AdmissionsFA – Financial AidAH – Academic HistoryLA – Loan Application ProcessingAR – Accounts ReceivableTA – Table, Audit and Data Dict.AS – Fee AssessmentCC – Course CatalogDB – DisbursementCM - CommunicationsCS – Course ScheduleDA – Degree AuditFL – FacilitiesGD – GradesGP – General PersonOS – Organization StructureRG – RegistrationCBSCashiering BankruptcySystemCollectPlus136CollectPlus Debt Collectionand RecoverySAMTightly Coupled220CWSCheck Writing SystemA42SIS Core Applications (Jnn)Return Check System152BankLockboxFALSJ9000Fees Assessment LoadSystem125FStipendsA78153Fellowship Stipends166PanOpticPanOptic DocumentImaging SystemCopyright 2011 Michigan State University. All rights reserved.DWH(RealTime)DWH(Batch)IDMSREPLSISREPLCBC ExtractsMSUDATAAISDB1 tPid MailSIS Applications Landscape.vsd2441099 Reporting221Direct Billing rWindstar International TaxNavigatorCASHNetCASHNet PaymentProcessingInstitutional Reporting - CO154DBSTravelAgencyTuition CalculatorECSIPCA76ECSInterfaceECSI Mainframe BatchInterfaceECSI PC loanmanagement bCredit161SITSA7700Student InternationalTaxation System

SIS Integration ApplicationsPage: 7Change Date: 9/28/2012 9:28:53 AMSIS Planning Project283180KFS280N81181Kuali Financial SystemN82HR207D2001ID Cards206ITSIDMDataOutD20209Data Outputs from IDM toUnitsMultiD20 Identity ManagementSystemMultiCOHuman Resource System HRIDMD20D6501281Digital Measures IS Security System184Graduate ApplicationUSPeople SearchInfrastructure Team IDM MultiN81OOIMultiCAMPBooksSISN82226PayrollCAMPSIS Core Applications (Jnn)OPB210PayrollCAMPBooks J9904ROOrganization Of Interest264DMCANRH42UHSSAMTightly Coupled284AD – AdmissionsFA – Financial AidAH – Academic HistoryLA – Loan Application ProcessingAR – Accounts ReceivableTA – Table, Audit and Data Dict.AS – Fee AssessmentCC – Course CatalogDB – DisbursementCM - CommunicationsCOUniversity Housing System RHSSISDataOutData Outputs from SISCore to UnitsPICRA1401Person Identity CrossReferenceMultiCS – Course ScheduleDA – Degree AuditFL – FacilitiesGD – GradesGP – General PersonOS – Organization StructureRG – Registration177LON-CAPACourse management andlearning support system MultiDWH(RealTime)DWH(Batch)IDMSREPLSISREPLCBC ExtractsMSUDATAAISDB1 Etc.276SISAPPSSIS entInformation System182BI183N84Business IntelligenceOPBMSUEDWN85MSU Enterprise DataWarehouse on Oracle269OPBCopyright 2011 Michigan State University. All rights reserved.MSUDIMN85MSU Dimensional DataWarehouse on Oracle263OPBKMMN81Kuali MaterialManagement System208USDITSFAISFaculty Activity InformationSystemEGRSIS Applications Landscape.vsd274176PBSPlanning and BudgetSystemOPB175ANGELAngel LearningManagement SystemMultiFAMISFacilities AdministrationManagement Info System PPUA