Peer Testing - PPIP
Process Testing | |||
SDS Process Name | SDS Paragraph Ref | Pass/Fail | Notes / link to JIRA issue |
Amendments to HRMI BOXI universe (PPIPMI) extract process | Reference Data Tables - create new tables | Pass but with clarification requested | NOTE: No longer applicable - PPIP removed from project scope after it was discovered that the Business Area Manager had also requested this work through a UniDesk call to Apps Mgt |
| Reference Data Tables - sql script PPIPMI_GENDER_IDENTITY | PASS |
|
| Reference Data Tables - sql script PPIPMI_DISABILITY | PASS |
|
| Reference Data Tables - sql script PPIPMI_SEXUAL_ORIENTATION | PASS | ||
| Reference Data Tables - sql script PPIPMI_RELIGION_BELIEF | PASS | ||
| Amendments to sql scripts - build_ppipmi_lookups.sql | PASS | ||
| Amendments to sql scripts - ppipmi_transfer_datamart.sql | PASS | ||
| Add new columns to extract tables | PASS | ||
| Amendments to Extract Scripts - uoe_mi_cur_assign_temp1_01.sql | PASS | ||
| Amendments to Extract Scripts - uoe_mi_cur_assign.sql | PASS | ||
| Amendments to Extract scripts - ppipmi_cur_assign_funding_01.sql | PASS | ||
| Amendments to Extract scripts - ppipmi_transfer_newlive_daily_01.sql | PASS | ||
| Amendments to Extract scripts - ppipmi_transfer_newslive_01.sql | PASS | ||
| Run the shell script to build the lookup tables | FAIL | NOTE: No longer applicable - PPIP removed from project scope after it was discovered that the Business Area Manager had also requested this work through a UniDesk call to Apps Mgt | |