Penn Computing

University of Pennsylvania
Penn Computing << go backback
PS_NAMES_MV Table   Tables and Data Elements   ATLAS Data Warehouse Home   Data Warehouse Home

PS_NAMES_MV Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.

  • EMPLID
  • NAME_TYPE
  • EFFDT
  • COUNTRY_NM_FORMAT
  • NAME
  • NAME_INITIALS
  • NAME_PREFIX
  • NAME_SUFFIX
  • NAME_ROYAL_PREFIX
  • NAME_ROYAL_SUFFIX
  • NAME_TITLE
  • LAST_NAME_SRCH
  • FIRST_NAME_SRCH
  • LAST_NAME
  • FIRST_NAME
  • MIDDLE_NAME
  • SECOND_LAST_NAME
  • SECOND_LAST_SRCH
  • NAME_AC
  • PREF_FIRST_NAME

  • Data element Definition
    EMPLID


    Indexed - Yes
    Format - VARCHAR2
    Nullable - N
    Unique identifier for individual (non-org) records.
    NAME_TYPE


    Indexed - Yes
    Format - VARCHAR2
    Nullable - N
    Indicates type of name, e.g. preferred name or birth name.
    EFFDT


    Indexed - Yes
    Format - DATE
    Nullable - N
    Effective date of the table row. Tells you which data is most "up to date", and which rows have been changed. By definition, tables with an "MV" suffix only show the "most effective dated row", i.e. the current valid row.
    COUNTRY_NM_FORMAT


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    NAME


    Indexed - Yes
    Format - VARCHAR2
    Nullable - N
    Name field (format ex. Mr. John Smith)
    NAME_INITIALS


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    NAME_PREFIX


    Indexed - Yes
    Format - VARCHAR2
    Nullable - N
    NAME_SUFFIX


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    NAME_ROYAL_PREFIX


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    NAME_ROYAL_SUFFIX


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    NAME_TITLE


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    LAST_NAME_SRCH


    Indexed - Yes
    Format - VARCHAR2
    Nullable - N
    FIRST_NAME_SRCH


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    LAST_NAME


    Indexed - Yes
    Format - VARCHAR2
    Nullable - N
    Last name, determined by NAME_TYPE field.
    FIRST_NAME


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    First name, determined by NAME_TYPE field.
    MIDDLE_NAME


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    SECOND_LAST_NAME


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    SECOND_LAST_SRCH


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    NAME_AC


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    PREF_FIRST_NAME


    Indexed - No
    Format - VARCHAR2
    Nullable - N

    PS_NAMES_MV Table   Tables and Data Elements   ATLAS Data Warehouse Home   Data Warehouse Home

    Questions about this page? Email us at da-staff@isc.upenn.edu

    Information Systems and Computing
    University of Pennsylvania
    Information Systems and Computing, University of Pennsylvania