Penn Computing

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

PS_PERSONAL_PHONE Table - Data Element Index

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

  • EMPLID
  • PHONE_TYPE
  • COUNTRY_CODE
    		•
  • PHONE
  • EXTENSION
  • PREF_PHONE_FLAG
    		•

    Data element Definition
    EMPLID


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


    Indexed - Yes
    Format - VARCHAR2
    Nullable - N    		Phone number type (ex. 'HOM1' for first home phone).
    COUNTRY_CODE


    Indexed - No
    Format - VARCHAR2
    Nullable - N    		Phone country code.
    PHONE


    Indexed - No
    Format - VARCHAR2
    Nullable - N    		Phone number.
    EXTENSION


    Indexed - No
    Format - VARCHAR2
    Nullable - N    		Extension
    PREF_PHONE_FLAG


    Indexed - No
    Format - VARCHAR2
    Nullable - N    		Yes/No flag indicating preferred phone.

    PS_PERSONAL_PHONE 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