Functional Testing

 

See attached document for more detail on how the tests have been run: https://www.projects.ed.ac.uk/webfm_send/1421

1.  Deliverable 1.1:  Changes to HR database, application, and extracts:

Reference (From BRD)

Scenario / Acceptance Criteria

Tested By

Date Tested

Outcome Pass/Fail

Notes

 1.1

 Confirm that all new/changed fields appear in the HR application

 Alyson Shaw

 17/04/13

 FAILed originally, but Jira successfully addressed and closed.  so now PASS

Initially had problem viewing the fields but worked out how to fix that and did so (implementation plan to be updated). Identified the following issues:

 https://www.jira.is.ed.ac.uk/jira/browse/HRS071-27

 Note that this is a very minor point and would not affect system functioning normally

 1.2

 Confirm that all new/changed fields appear in the HR Self Service screens

 Alyson Shaw

 17/04/13

 PASS

 

 1.3

 Confirm that the new/changed fieldsappear in the HR extract.

 Alyson Shaw

 17/04/13

 PASS

 

1.4

Confirm that the new/changed fields appear in the PPIPMI extract.

Note:  PPIP de-scoped March 2013

   N/A

  

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

2.  Deliverable 1.2:  Changes to HESA and HESA Archive database, application, extracts, and BOXI universes:

2b. 

 

Reference (From BRD)

Scenario / Acceptance Criteria

Tested By

Date Tested

Outcome Pass/Fail

Notes

 2.1

 Confirm that the new/changed fields appear in the HESA database.

 Alyson Shaw

 17/04/13

 PASS

 

 2.2

 Confirm that the new/changed fields appear in the HESA Archive database.

 Alyson Shaw

 17/04/13

 PASS

 

 2.3

Run the archive process.  Confirm that the new/changed fields appear in the HESA Archive universe.

 

 

 

 I have not run the archive process because it will insert the records with archive year of 2012 instead of 2013 (it sets year by subtracting 7 months from run-date) . This would result in there being 2 archives for 2012 on the table which could cause confusion and introduce problems in testing.  This is existing design of the archive - think designed this way as not meant to be run till after the hesa return has been submitted - and hesa return as at 31-July. However the universe does have placeholders for the new data items.  AS 18/04

2.4

Confirm that all new/changed fields appear in the new HESA application.

Note:  The new Apex forms will be implemented to Test at a later date (their development has been delayed by the scheduling of Oracle's Apex course.)

 

tbc

tbc

to be tested at a later date

2.5

Confirm that the new/changed fields appear in the HESA universe.

 Alyson Shaw

 17/04/13

 PASS

 

2.6

Confirm that the new/changed fields appear in the HESA Archive universe.

 Alyson Shaw

 17/04/13

PASS

 

 

 

 

Deliverable 1.2:  Supporting data from PURE:

 

 

Reference (From BRD)

Scenario / Acceptance Criteria

Tested By

Date Tested

Outcome Pass/Fail

Notes

2.7-9

 Upload the csv data file from GaSP into the HR HESA Person table.   Confirm that the new Research fields from the csv file appear in the HESA universe.

 Alyson Shaw

 17/04/13

 N/A

This scenario is not quite valid.

The csv file was loaded up at implementation time. It sits in a temp table but the hesa universe does not have a direct view on that table. However the new fields do show up in the universe along with the other fields we added to the extract table

 

3.  Deliverable 1.3:  Changes to eRecruitment database, application, extract, and BOXI universe:

 

Reference (From BRD)

Scenario / Acceptance Criteria

Tested By

Date Tested

Outcome Pass/Fail

Notes

 3.1

 Confirm that the new/changed SOC field appears in the eRecruitment application.

 

 

 

This is being done by HR systems team 

 3.3

 Confirm that the new SOC values for records extracted from eRecruitment appear in the HR application.

 

 

 

This cannot be tested until all done in eRecruitment and we have test applicants set up

 3.4

 Confirm that the new SOC values appear in the eRecruitment universe. 

Note: Item removed because PPDR meeting agreed to pass this task to eRecruitment Phase 1B project.

 

 

 

 N/A

 

4.  Deliverable 1.4:  Changes to PPIPMI database and BOXI universe:

 

Reference (From BRD)

Scenario / Acceptance Criteria

Tested By

Date Tested

Outcome Pass/Fail

Notes

4.1 

 Confirm that the new/changed fields appear in the PPIPMI universe.

Note:  PPIP de-scoped March 2013

 

 

 

 N/A

  

5.  Deliverable 2.1:  Update the HESA extract facility for required final return functionality:

 

Reference (From BRD)

Scenario / Acceptance Criteria

Tested By

Date Tested

Outcome Pass/Fail

Notes

 5.1

Confirm that the new verstion of the HESA extract (to xml) has been deployed

 Alyson Shaw

 17/04/13

 PASS

 

  

6.  Deliverable 2.2:  Update the HESA submission method:

 

Reference (From BRD)

Scenario / Acceptance Criteria

Tested By

Date Tested

Outcome Pass/Fail

Notes

 6.1

Confirm that all Staff fields appear in the HESA xml files

 Alyson Shaw

 17/04/13

 PASS

 On test many of the fields will be null because the new ACTSOC values have not been set against people’s records and this has knock on effects for population of other fields. where the fields are null they do not show in the xml and this means that after the first test run it looks as if ,any of them are missing.However for the purposes of integration testing I am satisfied that the overall process is working and detailed scenario testing can take place at UAT

 6.2

Confirm that all Contract fields appear in the HESA xml files

 Alyson Shaw

 17/04/13

 PASS

 Same comment as above

 6.3

 Confirm that no Grades file is produced

 Alyson Shaw

 17/04/13

 PASS

 

 

  

 

 

 

Project Info

Project
HR HESA Staff Return 12/13
Code
HRS071
Programme
Human Resources (HRS)
Project Manager
Nikki Stuart
Project Sponsor
Sheila Gupta
Current Stage
Close
Status
Closed
Start Date
24-Oct-2012
Planning Date
n/a
Delivery Date
n/a
Close Date
06-Dec-2013
Programme Priority
1
Overall Priority
Higher
Category
Compliance