03 March 2025

Database Changes for 4.34

This section contains details of database changes between the full 4.33 and 4.34 releases.

Table changes:

The following tables have been added.

Table Name Column Name
COHORTS Details of all cohort groups.
COHORT_FILTERS Many-to-Many linking of cohort groups to filter definitions.
COHORT_FILTER_VALUES Selected values for each filter associated with each cohort.
COHORT_PERIODS Applicable periods to which a cohort group applies to.
FILTER_DEFINITIONS Details of all filter definitions, used for example when creating cohort groups.

The following columns have been added.

Table Name Column Name Type (Size) Nullable Description
PEOPLE_CDR HOMELESS_EXCLUSION VARCHAR2(10) Y Homeless or affected by Housing Exclusion is defined as being roofless or houseless i.e. (sleeping rough), it may also include situations of living in temporary, insecure or poor-quality housing. [FK=CDR_VERIFIERS.CODE(RV_DOMAIN=HOMELESS_EXCLUSION)]
PEOPLE_CDR LONG_TERM_DESTINATION VARCHAR2(10) Y The current main employment status. [FK=CDR_VERIFIERS.CODE(RV_DOMAIN=LTDESTINATION)]
PEOPLE_CDR LONG_TERM_EMPLOYMENT VARCHAR2(10) Y The employment situation on joining the programme. [FK=CDR_VERIFIERS.CODE(RV_DOMAIN=LTEMPLOYMENT)]
PEOPLE_CDR VPRS VARCHAR2(1) N Should be selected if a student is participating in Vulnerable Persons Relocation Scheme. [FK=CDR_VERIFIERS.CODE(RV_DOMAIN=VPRS)] [DEFAULT=0]
PEOPLE_HESA NATION VARCHAR2(2) Y The country of the legal nationality of a student. [FK=HESA_VERIFIERS.CODE(RV_DOMAIN=NATION)]

The following columns have been changed.

Table Name Column Name Type (Size) Nullable Previous Values Type (Size) [Nullable]
HOURS_STATISTICS COURSE_HOURS NUMBER(10,2) Y NUMBER(5,2)[Y]
HOURS_STATISTICS NOTIONAL_STUDENT_HOURS NUMBER(10,2) Y NUMBER(5,2)[Y]
HOURS_STATISTICS STUDENT_HOURS NUMBER(10,2) Y NUMBER(5,2)[Y]
HOURS_STATISTICS TOTAL_STUDENT_HOURS NUMBER(10,2) Y NUMBER(6,2)[Y]

View changes:

The EBS_VERIFIER_CUSTOM_WEB_CONFIG view has been added.

The following columns have been added.

View Name Column Name
DM_APP_OFFERS OFFER_TO_ACCEPT_DAYS
EBS_CDRGENERATERETURN REL_BROUGHT
EBS_EXAM_CANDIDATES HOMELESS_EXCLUSION
EBS_EXAM_CANDIDATES P_CDR_LONG_TERM_DESTINATION
EBS_EXAM_CANDIDATES P_CDR_LONG_TERM_EMPLOYMENT
EBS_EXAM_CANDIDATES VPRS
EBS_LEARNERS HOMELESS_EXCLUSION
EBS_LEARNERS P_CDR_LONG_TERM_DESTINATION
EBS_LEARNERS VPRS
EBS_LEARNERS P_CDR_LONG_TERM_EMPLOYMENT
EBS_LEARNERS_DEDUP HOMELESS_EXCLUSION
EBS_LEARNERS_DEDUP P_CDR_LONG_TERM_DESTINATION
EBS_LEARNERS_DEDUP VPRS
EBS_LEARNERS_DEDUP P_CDR_LONG_TERM_EMPLOYMENT
EBS_STAFFUSER PERSONAL_EMAIL

The following columns have been dropped.

View Name Column Name
EBS_CDRGENERATERETURN COM_BACKGROUND

Service Pack 4 Changes

The following changes have been made for 4.34 Service Pack 4:

The following columns have been added.

Table Name Column Name Type (Size) Nullable Description
UIO_HESA UNITLGTH  VARCHAR2(1) Y Specifies the duration of a unit in order to describe the length of the course for a HESA SA return (for example: day, month, year and so on).
UIO_HESA SPLENGTH NUMERIC(2) Y Number of units to describe the length of the course for a HESA SA return.