[BLC] Legacy Data Platform (LDP) Migration Project 2023

SBCTC-IT Mail itmail at sbctc.edu
Wed Feb 8 09:46:36 PST 2023


Date:                February 8, 2023

From:               Grant Rodeheaver

Subject:           Legacy Data Platform (LDP) Migration Project 2023 

Dear college community:

Now that Washington’s community and technical colleges have migrated to ctcLink, we are preparing for the eventual shutdown of the Legacy HP-UX (Hewlett Packard Unix) environment.  Legacy environments must be shut down before June 30, 2023, or the college system will incur substantial licensing and maintenance costs.  

What is the Scope of the LDP Migration Project?

Legacy data will be migrated to SQL Server and a read-only application developed to provide secure access to users to a limited subset of screens and reports needed to continue critical business.

Colleges will no longer use DataExpress as this product relies on the sunsetting HP-UX platform. The application under development includes replication of display-only access to screens and batch reports in:

  *   Financial Management System (FMS)
  *   Payroll/Personnel Management System (PPMS)
  *   Student Management System (SMS)

What is Not in Scope?

  *   The Legacy Transcript Project is not within the scope of the LDP application project.
  *   Integration to Advisor Data Portal (ADP) is not within the scope of the LDP application project.
  *   Degree Audit data is not targeted for migration.
  *   FAM and Account Management already have a user interface and are not targeted for migration, as the data is already on the SQL server.
  *   FMS Query is not within the scope of this project. FMS Query is an MS-Access front-end reporting tool for financial reports (e.g., Budget Status, Expense, Payroll, Revenue, Grants and Contracts) used as the front-end tool to access the information in a user-friendly format. Colleges can currently run ad hoc queries writing and extracts against their SQL data to populate an Access database.
  *   Ad hoc reporting.

What to Expect

  *   We will be reaching out shortly to form an ad hoc LDP Migration Project advisory group comprised of knowledgeable Legacy users systemwide for guidance and application testing. Expertise in the following areas is key:
     *   Financial Management System (FMS)
     *   Payroll/Personnel Management System (PPMS)
     *   Student Management System (SMS)
     *   DataExpress/Database Reporting
     *   Organizational Data Stores (ODS) or other data extract tools
  *   A survey to gather systemwide input about Legacy data access needs will be distributed when ready. Responses will help SBCTC build and refine technical requirements for the new Legacy Data Platform (application).
  *   When the Legacy Data application is ready, designated Legacy data users at each college and SBCTC will receive secure logins and instructions on how to access the application.

Get Involved

If you are willing to be part of the LDP Migration Project advisory group, please contact Sanjiv Bhagat<mailto:sbhagat at sbctc.edu>, Project Manager, SBCTC IT Project Management Office. This ad hoc group will be called upon for various activities (e.g., review surveys, communications, and documentation drafts; requirements checking, application testing).

The LDP Migration Project is led by Ray Gartner, SBCTC Application Services Director. Ben Geertz, SBCTC Support Analyst and longtime HP/Legacy expert, is serving as lead developer on the project, with additional support from team members, Terry Davenport (PPMS), Eric Messelt (FMS), and Ryan Jackson (SMS).

Stay tuned and please reach out if you have any questions or concerns. 

Thank you,


Grant Rodeheaver

Deputy Executive Director / CIO, IT Division

Washington State Board for Community and Technical Colleges

grodeheaver at sbctc.edu • o: 360-704-3939 • c: 360-280-4733

sbctc.edu<https://www.sbctc.edu/> • Twitter: @SBCTCWashington<https://twitter.com/SBCTCWashington> • Facebook: @WASBCTC<https://www.facebook.com/wasbctc/>

Please DO NOT REPLY to SBCTC-ITD Mail regarding this e-mail. SBCTC-ITD Mail is an unmonitored mailbox, and your message will not be received.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ctc.edu/pipermail/blc_lists.ctc.edu/attachments/20230208/49436a55/attachment-0001.html>

More information about the BLC mailing list