Yale Workday ISR Forum and People Hub Updates

Workday@Yale Impacted Systems Remediation (ISR) Forum Topic: PeopleHub November 28, 2016

Workday@Yale Agenda Upcoming People Hub Communications Quick Review of Process Flow Quick Review of Stats People Hub Testing Status Defects Future People Hub Releases Next forum topics - 2 -

Workday@Yale Upcoming PeopleHub Communications Newly added and updated documents on the Impacted Systems Website Getting Started with People Hub Connection Information and People Service Technical Information on People Hub Structure Release Information on People Hub - 3 -

Application Access to People Data / Hub Workday@Yale - 4 -

Workday@Yale Quick review of stats Total systems flagged needing people data 107 Total systems needing People Hub access 66 Total systems with Access Request in queue 50 Access granted 17 Access in Process 6 Access Request Approved Not Yet Granted 20 Access Approval in Progress 5 Attended Clinics 2 Total systems that need follow up 16 - 5 -

Workday@Yale Testing Status Test Types Test Scenarios Responsible Test Case Execution Status Release 1 Test Case Execution Status Release 2 Connectivity Test Web services Pilot Teams Tested and Passed Tested and Passed JDBC/ODBC Reconciliation Test Row count validation PeopleHub Will test after Release 2 In Progress Behavioral Test First batch is collected PeopleHub Will test after Release 2 In Progress People Service Data type definition validation Data Validation Test PeopleHub Tested and identified issues In Progress PeopleHub Tested and identified issues In Progress Attribute value validation Null validation PeopleHub Tested and identified issues Tested and Identified Issues Missing record validation PeopleHub Tested and identified issues Tested and Passed Duplicate check validation PeopleHub Tested and identified issues Tested and Passed System specific validation Pilot Teams Tested and identified issues Tested and Identified Issues Change data capture validation HCM, PeopleHub, Pilot Teams Will test during ISR SIT Will test during ISR SIT Security and Access Control Test Data Group/Affiliation based on Access form PeopleHub Tested and Passed Tested and Passed System Specific Pilot Teams Tested and Passed Tested and Passed Performance Test Execution Time PeopleHub, Pilot Teams Will test after Release 2 In Progress Load and Concurrent Test TBD TBD TBD - 6 -

Workday@Yale Defects All the defects are tracked using ALM. Currently there are total 95 defects raised in the ALM. 74 defects are detected by PeopleHub team and 21 are detected by pilot teams. 38 defects are addressed and 12 defects are targeted to complete by December 5th. Release 2 Release 3 Status PeopleHub Pilot Teams PeopleHub Pilot Teams New 0 0 12 0 Tested and Closed 19 25 1 0 Fixed and Ready for Retest 1 15 29 8 Total 20 40 42 8 - 7 -

Workday@Yale Test Release 2 Tickets Addressed for November Release Added Yale relationship attribute Added sponsored identity attributes Added new name fields from IDR Added future worker/future contingent worker from workday Added additional attributes from workday Add affiliate address into the view Included logic in view to ensure one row per UPI Included logic in view to ensure that child rolls up to one parent in cost center hierarchy Renamed people hub views - 8 -

Workday@Yale Test Release 3 Tickets to be Addressed by December Release Data Content Related Tickets Add incremental load Add secondary positions Standardization a few attributes Add additional attributes Change data type of date attributes from varchar to date System and ETL Program Related Tickets Building jobs for data quality checks Logging and error control logic Incorporate data cleansing and data profiling process into ETL load process for staging, data vault and views Create indexes on columns for data vault and any needed for staging Incorporate ETL scheduling Incorporate Hashdiff column creation, join logic into ETL Talend process Incorporate ALM auto test case creation Coordinate environments to point to for SIT testing - 9 -

Workday@Yale Known Data Quality Questions Known Data Quality Issues Current Approach Additional Data Quality handling logic required Multiple records for the same UPI Filtering our UPI s with multiple rows, so that downstream system integration won t fail. The UPI s that are filtered out are reported in an error report. Yes Multiple ID s (i.e. Employee ID or Academic Affiliate ID or Sponsored Guest ID) for the same UPI for the same reporting period Filtering our UPI s with multiple ID s, so that downstream system integration won t fail. The UPI s that are filtered out are reported in an error report. Yes A cost center rolls up to more than one Department, a Department rolls up to more than one Department Grouping Filtering our Cost Center s with bad hierarchy, so that downstream system integration won t fail. The Cost Center s that are filtered out are reported in an error report. Yes - 10 -

Workday@Yale Standardized Attributes Attributes Standardized Value Gender M/F/N/Null Privacy_Indicator Null should be displayed as 0 Marital_Status Widow/Partnered/Single/Divorced/Separated/Married/Null Is_Coterminous_Appointment Y/N/Null Is_Current_Appointment Y/N/Null Has_Current_Academic_Appointment Y/N Worker_Active Y/N Has_Tenure Y/N Primary_position_Flag Y/N/Null Excluded_From_Head_Count Y/N/Null Nine_Over_Nine_Participant Y/N National_Identifier Separated by dash (XXX-XX-XXXX) Hispanic_or_Latino Y/N Primary_Academic_Appointment_Indicator Y/N/Null Matrix Manager Show matrix manager s reporting name HR_Partner Show HR partner s reporting name Compensation_Manager Show compensation manager s reporting name Manager Show manager s reporting name Strategic_Business_Partner Show strategic business partner s reporting name Business_Partner Show business partner s reporting name - 11 -

Next Forums Getting ready for ISR Integration Testing People Hub Others?