UM_NAMES_VW - Person Names Query View

Body

This Table contains Student and Employee Name details 

Detailed Information

Data Systems

  • PeopleSoft Campus Solutions CSPRD 
  • PeopleSoft Campus Solutions Reporting CSRPT
Key Record.Fieldname Format XLAT Heading Text
  COUNTRY_NM_FORMAT - Format Using Char3   Use
Key EFFDT - Effective Date Date   Eff Date
  EFF_STATUS - Status as of Effective Date Char1 N Status
Key EMPLID - Empl ID Char11   ID
  FIRST_NAME - First Name Char30   First Name
  FIRST_NAME_SRCH - First Name Char30   First Name
  LASTUPDDTTM - Last Update Date/Time DateTm   Last Upd DtTm
  LASTUPDOPRID - by Char30   by
  LAST_NAME - Last Name Char30   Last
  LAST_NAME_PREF_NLD - Last Name Preference Char1 N Preference
  LAST_NAME_SRCH - Last Name Char30   Last
  MIDDLE_NAME - Middle Name Char30   Middle
  NAME - Name Char50   Name
  NAME_AC - Alternate Character Name Char50   AC Name
  NAME_DISPLAY - Display Name Char50   Display Name
  NAME_FORMAL - Formal Name Char60   Formal Name
  NAME_INITIALS - Name Initials Char6   Initials
  NAME_PREFIX - Name Prefix Char4   Prefix
  NAME_ROYAL_PREFIX - Name Royal Prefix Char15   Royal Prefix
  NAME_ROYAL_SUFFIX - Name Royal Suffix Char15   Royal Suffix
  NAME_SUFFIX - Name Suffix Char15   Suffix
  NAME_TITLE - Title Char30   Title
Key NAME_TYPE - Type of Name Char3   Name Type
  PARTNER_LAST_NAME - Last Name Partner Char30   Last Name
  PARTNER_ROY_PREFIX - Prefix Partner Char15   Prefix
  PREF_FIRST_NAME - Preferred First Name Char30   Preferred First
  SECOND_LAST_NAME - Second Last Name Char30   Second Last
  SECOND_LAST_SRCH - Second Name Char30   Second Name

Name Table Relationships

In Campus Solutions, there are two core tables from which all name reporting tables are derived:

  • NAMES  
  • NAME_TYPE_TBL

Name Types

Name Type Name Type Descr
DIP Diploma
FR1 Former
PRF Preferred/Chosen
PRI Legal

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.

SQL for UM_NAMES_VW
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;

Details

Details

Article ID: 158892
Created
Fri 5/10/24 4:27 AM
Modified
Wed 9/11/24 1:46 PM
Applies To
Faculty
Staff
Community

Related Services / Offerings

Related Services / Offerings (1)

DARTS (UMS Data) Inquiry
Submit an inquiry about UMS Data (except Data Governance)