Developer Testing
Confirmation of Standards Adherence
Activity | Date Tested | Notes |
|
| |
|
| |
|
|
Developer Tests and Outcomes
1.1 BRD 5.1 Admission Status and Applicant Data Timing
Test | Outcome |
Value ‘Applicant’ appears when: - SA11_STUAPP_STATUS = ‘A’ - SA113_LATEST_REPLY_FOR_DESC is null | PASS |
Value ‘Applicant Conditional Insurance’ appears when: - “SA11_STUAPP_STATUS” = ‘A’ - “SA113_LATEST_REPLY_FOR_DESC” = ‘I’ - “SA111_LATEST_DESC” = ‘C’ | PASS |
Value ‘Applicant Unconditional Insurance’ appears when: - “SA11_STUAPP_STATUS” = ‘A’ - “SA113_LATEST_REPLY_FOR_DESC” = ‘I’ - “SA111_LATEST_DESC” = ‘U’ | PASS |
Value ‘Applicant Conditional Firm’ appears when: - “SA11_STUAPP_STATUS” = ‘A’ - “SA113_LATEST_REPLY_FOR_DESC” = ‘F’ - “SA111_LATEST_DESC” = ‘C’ | PASS |
Value ‘Applicant Unconditional Firm’ appears when: - “SA11_STUAPP_STATUS” = ‘A’ - “DATE_UCAS_UF” is null | PASS |
1.2 BRD 5.2 Modified Address Fields in EUGEX
Test | Outcome |
Column “HOME_ADDRESS” does not appear in the view | PASS |
Columns “HOME_ADDRESS_1”, “HOME_ADDRESS_2” and “HOME_ADDRESS_3” appear in the view | PASS |
1.3 BRD 5.3 Removal of Term Time Address from the Feed
Test | Outcome |
Following columns do not appear in the view: - TERM_ADDRESS - TERM_TOWN - TERM_COUNTY - TERM_POSTCODE - TERM_TEL | PASS |
1.4 BRD 5.6 Domicile Feed Validation
Test | Outcome |
Following values appear in the column “START_DOMICILE_GROUPING“ of the amended view: - SCOTLAND - CHANNELISLOFMAN - OTHER UK - ALL UK - OVERSEAS - UNASSIGNABLE | PASS |
1.5 BRD 5.7 Amendments to Selection conditions for the EUGEX Accommodation view
Test | Outcome |
Records which meet following criteria are included in the amended view:
( sa10_student_applicant = 'S' and sa106_within_grace_period = 'Y' ) AND sa43_programme_startdate > to_date('01/JAN/2010','DD/MON/YYYY') AND SA107_MOST_CURRENT = 'Y' | PASS |
Records which meet following criteria are included in the amended view:
( sa10_student_applicant = 'A' and SA111_LATEST_DESC in ('C', 'U') AND SA113_LATEST_REPLY_FOR_DESC not in ('D') ) AND sa43_programme_startdate > to_date('01/JAN/2010','DD/MON/YYYY') AND SA107_MOST_CURRENT = 'Y' | PASS |
Records which meet following criteria are included in the amended view:
(sa10_student_applicant in ('ZN','XD') ) AND sa43_programme_startdate > to_date('01/JAN/2010','DD/MON/YYYY') AND SA107_MOST_CURRENT = 'Y' | PASS |