Peer Testing - HR HESA

SDS Process Name:  Amend HESA extract tables

SDS Paragraph Ref

Pass/Fail

Notes / link to JIRA issue

New holding table for LEVELS

 PASS

 DBA issues were raised and are being dealt with separately

New holding tables for CURACCDIS

 PASS

 DBA issues were raised and are being dealt with separately

New columns in HESA extract tables

 PASS

 

Increase size of CCENTRE1, CCENTRE2, CCENTRE3 column

 PASS

 

Remove redundant columns from HESA extract tables

 PASS

 

Drop obsolete extract tables

 PASS

 

 

 

SDS Process Name:  Amend PLSQL extract procedures

SDS Paragraph Ref

Pass/Fail

Notes / link to JIRA issue

UOE_HESA_UTILS.GET_HESA_ACEMPFUN

 PASS

 

UOE_HESA_UTILS.GET_HESA_TERMS

 PASS

 

UOE_HESA_UTILS.GET_HESA_MOEMP

 PASS

 

UOE_HESA_UTILS.GET_HESA_NHSCON

 PASS

 

UOE_HESA_UTILS.GET_HESA_NHSCONGR

 PASS

 

UOE_HESA_UTILS.GET_HESA_HSPEC

 PASS

 

UOE_HESA_UTILS.CALC_HOURS_WORKED

 PASS

 

UOEPP.UOE_HESA_API

 PASS

 

UOEPP.UOE_HESA_API.STEP_THROUGH_EXTRACT

 PASS

 

UOEPP.UOE_HESA_API.EXECUTE_STEP_BY_NAME

 PASS

 

 UOEPP.UOE_HESA_EXTRACT_STEPS.SUM_ASS_CREATE_ATYP_CONT

 PASS

 

UOEPP.UOE_HESA_EXTRACT_STEPS.SUM_ASS_CREATE_ATYP_NO_CONT

 PASS

 

UOEPP.UOE_HESA_EXTRACT_STEPS.RAW_ASS_CREATE_TYP_MAIN

 PASS

 

UOEPP.UOE_HESA_EXTRACT_STEPS.SUM_ASS_UPDATE_ALL

 PASS

 

UOEPP.UOE_HESA_EXTRACT_STEPS.SUM_ASS_UPDATE_TYP

 PASS

 

UOEPP.UOE_HESA_EXTRACT_STEPS.SUM_ASS_UPDATE_ATYP

 PASS

 

UOEPP.UOE_HESA_EXTRACT_STEPS.RAW_ASS_UPDATE_ATYP

 PASS

 

UOEPP.UOE_HESA_EXTRACT_STEPS.SUM_ASS_CREATE_TYP_MAIN

 PASS

 

UOEPP.UOE_HESA_EXTRACT_STEPS.HESA_CONT_CREATE_TYP

RETESTED 10/04 PASS

 

UOEPP.UOE_HESA_EXTRACT_STEPS.HESA_CONT_CREATE_ATYP

 PASS

 

UOEOO.UOE_HESA_EXTRACT_STEPS.UOE_HESA_CONT_UPDATE_TYP_SALSRC

 PASS

 

UOEPP.UOE_HESA_EXTRACT_STEPS.UOE_HESA_CONT_UPDATE_TYP_CCENTRE

 PASS

 

UOEPP.UOE_HESA_EXTRACT_STEPS.UOE_CONT_UPDATE_ATYP_CENTRE

 PASS

 

UOEPP.UOE_HESA_EXTRACT_STEPS.FIND_MISSING_CONTRACTS

 PASS

 

UOEPP.UOE_HESA_EXTRACT_STEPS.FIND_PREVIOUS_CONTRACTS

 PASS

 

UOEPP.UOE_HESA_EXTRACT_STEPS.HESA_PEOPLE_CREATE

 PASS

 

UOEPP.UOE_HESA_EXTRACT_STEPS.CLEAROUT

 PASS

 

UOEPP.UOE_HESA_EXTRACT_STEPS.HESA_PEOPLE_UPDATE_BASIC

RETESTED 10/04 PASS

 

 

New procedure UOE_HESA_EXTRACT_STEPS.HESA_CONT_UPDATE

 PASS

 

 

SDS Process Name:  APEX

SDS Paragraph Ref

Pass/Fail

Notes / link to JIRA issue

Authentication and Authorisation

Tested with users who have HR permissions and users with no permissions

PASS

 Users with no permissions cannot access the system.

Structure of the APEX application

 PASS

 

APEX Forms

 PASS

See details below

APEX: Person Details Page

     --  Headings don't run the full width of the page

PASS at retest

FAIL, but tester willing to accept

HRS071-29,HRS071-41, HRS071-38,HRS071-30, HRS071-34

HRS071-42

APEX: Edit Employee Details

PASS at retest

HRS071-35,HRS071-32, HRS071-33, HRS071-36, HRS071-37

APEX: Edit Contract Details

PASS at retest

HRS071-35,HRS071-40, HRS071-39

APEX: Create Person Details

PASS at retest

HRS071-59,HRS071-43, HRS071-44

APEX: Create Contract Details

PASS at retest

HRS071-51, HRS071-53, HRS071-60, HRS071-49, HRS071-50, HRS071-45, HRS071-53, HRS071-52, HRS071-45

APEX: Tabs & Breadcrumbs

    -- Breadcrumb on Create New Contract Details page

PASS at retest

FAIL, but tester willing to accept

HRS071-46

HRS071-47

APEX: Further testing in Internet Explorer

PASS at retest

HRS071-58

HR changes to call APEX instead of the form

Tested connection to both links & with valid & invalid logins

 PASS

 

 For details, please see Apex Test Plan.

 

Other

SDS Paragraph Ref

Pass/Fail

Notes / link to JIRA issue

HESA Archive Process

 

RETESTED 10/04 PASS

 

 

HR HESA UNIVERSE

 PASS

 

HR HESA  ARCHIVE UNIVERSE

 PASS