From 2004, applicant name information will be held in different Hercules views for different systems. This View selects the applicant name information belonging to all the systems.
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT APPNO , TIMESTAMP , CHECKDIGIT , NAMECHANGEDATE , TITLE , FORENAMES , SURNAME , BIRTHDATE , SEX FROM IGS_UC_U_IVSTARN_2003