| Excerpt |
|---|
Workday illustrated with all other systems PeopleSoft system at a very high level. |
Group | # | Name | Content Description | Timing | Use of data or Business Process Supported | ||||
|---|---|---|---|---|---|---|---|---|---|
A | 1 | Workday/PS | Employee Biographical Data, Employee status and affiliation, transaction data to support PS Campus Solutions | Realtime for new employees, updates and deletes | |||||
| 2 | PS/Workday | Employee ID creation | Realtime for new employees, updates and deletes | |||||
| 3 | IdCard SES | Student and Employee ID data Employment/Work Study | Daily Batch and Real-time components | ID Card generation | ||||
| 4 | Library | Student and Employee data | Daily Batch | Library patron privileges. | ||||
| 5 | ELM | Campus Community data for all students and employees | Daily Batch | To provide courses to Human Resources, EHS, Cash Management, KFS, Gannett (and others in future) a person's bio/demo data must exist in ELM. | ||||
| 6 | IdMgmt | Just Student ID data (Employee data has to be taken out of the existing feed) | Daily Batch | To keep the Directory current, Reference Groups providing access, WhoIam and NETID management tools operating. | ||||
| 7 | EMN | Just Student Emergency data (Employee data has to be taken out of the existing feed) | Daily Batch | To feed the 3rd party EMN system. | ||||
To support hiring of eligible students by departments send student employee data, eligibility and I9 information from PeopleSoft to Workday. | |||||||||
| 4 | B | 1 | SES | Student Employment/Work Study | Daily Batch | To support Financial Aid's work study tracking and award processing. Send student data and eligibility information to Workday from Student Records and Financial Aid (I9s)gross earning for student employees into PeopleSoft Financial Aid system for tracking against overall award amounts. | ||
| 2 | Workday/Kronos | 5 | Student and Employee ID data Hourly employees and their supervisors | Daily Batch | To support pay for hourly staff. | |||
| 3 | Kronos/Workday | Time collection detail for hourly employees | Daily Batch | To support pay for hourly staff. | ||||
| 4 | KFS/Workday | Account, Org and department data | Daily Batch and Real-time | Support for financial processes involving labor data. Requires the correct account, org and department | ||||
| 5 | Workday/KFS | Liability, position, salary earnings detail, gross pay encumbrance data | Daily Batch | To support accounting of labor related transactions. | ||||
| 6 | 3rd Parties | Banks and benefits providers | Unknown | TBD | ||||
| 7 | Warehouses | HR and Payroll detail | Daily Batch | All analytical and reporting needs for HR/Payroll required for the University's analysis and operational reporting not provided by Workday, particularly for historical needs starting with the first use of Workday. Conversion of old HR/Payroll data to a new Workday Era warehouse is yet to be defined in scope. | ||||
| 8 | Transportation | Names of employees, permit withholdings for Payroll | Daily Batch | Transportation tickets, permit creation and change processes require employee data. This interface is expected to be a Transportation office and HR/Workday responsibility and is not included in the CIT estimates. CIT is not expecting to own or steward this interface. | ||||
and Real-time components | Id Card system resides in PeopleSoft. This system relies on person, job and student data to produce id cards for all of the Cornell Community. Peoplesoft is the data repository and system of record for all University ID Card data and photos. The PeopleSoft ID card system processes new hires and students, inactivates terminated employees, deceased employees and students who are no longer active in a program and re-activates rehires. | ||||||||
| 6 | Grad Earnings | Students Charges, Financial Aid, Academic data and Payroll Earnings data. | Real-time (view only - transactional) | To provide the Grad School with a complete picture of a student’s financial picture. Provides a summarized view of Students Charges, Financial Aid, Academic data and Payroll Earnings data. | ||||
| 7 | Library | Student bio/demo and academic data (Employee data has to be taken out of the existing feed) | Daily Batch | Library patron privileges. | ||||
| 8 | Campus Community data for all students and employees |
| 9 | ELM | Employee job data (workforce and position) | Daily Batch | To provide courses to Human Resources, EHS, Cash Management, KFS, Gannett (and others in future) a person's jobbio/position demo data must exist in ELM. | |
| 10 9 | EMN Employee | Student Emergency data (Employee data has to be taken out of the existing feed) ID data | Daily Batch | To feed the 3rd party Emergency Mass Notification system. | ||||
| 11 10 | IdMgmt Emergency phone number, text enabled or not flag, and emergency contact table. | Student ID data (Employee data has to be taken out of the existing feed) | Daily Batch | To keep the Directory current, Reference Groups providing access, WhoIam and NETID management tools operating. | ||||
B | 12 1 | Grad Earnings | Employee job data (workforce and position) Emergency phone number, text enabled or not flag, and emergency contact table. | Daily Batch | To provide the Grad School with a complete picture of a student's financial picture. Provides a summarized view of Students Charges, Financial Aid, Academic data and Payroll Earnings data. | ||||
| 13 | SES | Student Employment/Work Study | Daily Batch | To support Financial Aid's work study tracking and award processing. Send gross earning for student employees into PeopleSoft Financial Aid system for tracking against overall award amounts. | ||||
C | 1 | Other Systems | Systems downstream from the HR/Payroll warehouse will be indirectly affected and are not included in scope. | periodic batch | One example is Digital Measure's Activity Insight, which extracts some HR data for the Academic Reporting processes the software support | ||||
| 2 | IdMgmt | Systems downstream of the Directory that use HR attributes will be affected and are not included in the scope. | batch or real time | One example is Vivo, which pulls basic HR data from the directory. If the attributes change or are removed these systems will be affected. courses to Human Resources, EHS, Cash Management, KFS, Gannett (and others in future) a person's job/position data must exist in ELM. |
| Gliffy Diagram | ||||||||
|---|---|---|---|---|---|---|---|---|
|