Penn Computing

University of Pennsylvania
Penn Computing << go backback

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

PS_EMAIL_ADDRESSES Table - Data Element Index

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

  • EMPLID
  • E_ADDR_TYPE
    		•
  • EMAIL_ADDR
  • PREF_EMAIL_FLAG
    		•

    Data element Definition
    EMPLID


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


    Indexed - Yes
    Format - VARCHAR2
    Nullable - N    		 Email address type, e.g. personal or business
    EMAIL_ADDR


    Indexed - No
    Format - VARCHAR2
    Nullable - N    		 Email address
    PREF_EMAIL_FLAG


    Indexed - No
    Format - VARCHAR2
    Nullable - N    		Yes or No field indicating the person's preferred email address

    CNAC_CODES Table        Tables and Data Elements   General Ledger 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