This Table contains Student and Employee Name details
In Campus Solutions, there are two core tables from which all name reporting tables are derived:
These tables are not available for reporting, but there are alternatives available in Campus Solutions. The best choices are the PERSON_NAME - Current Primary Name View table which displays primary name only, and the UM_NAMES_VW - Person Names Query View which includes name history. Both of these pull from the NAMES and the NAME_TYPE_TBLs.
Additionally, there exists SCC_NAMES_QVW - Person Names Query View which is a field by field view of the NAMES table, and HCR_NM_TYP_I - Name Type Table Interface VW which is a field by field view of the NAME_TYPE_TBL.
SELECT A.EMPLID, A.NAME_TYPE, A.EFFDT, A.EFF_STATUS, A.COUNTRY_NM_FORMAT, A.NAME, A.NAME_INITIALS, A.NAME_PREFIX, A.NAME_SUFFIX, A.NAME_ROYAL_PREFIX, A.NAME_ROYAL_SUFFIX, A.NAME_TITLE, A.LAST_NAME_SRCH, A.FIRST_NAME_SRCH, A.LAST_NAME, A.FIRST_NAME, A.MIDDLE_NAME, A.SECOND_LAST_NAME, A.SECOND_LAST_SRCH, A.NAME_AC, A.PREF_FIRST_NAME, A.PARTNER_LAST_NAME, A.PARTNER_ROY_PREFIX, A.LAST_NAME_PREF_NLD, A.NAME_DISPLAY, A.NAME_FORMAL, LASTUPDOPRID, LASTUPDDTTM FROM PS_NAMES A;