Penn Computing

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

PS_ORG_CONTACT Table - Data Element Index

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

  • EXT_ORG_ID
  • ORG_CONTACT
  • EMPLID
  • CONTACT_NAME
  • JOBTITLE
  • ORG_LOCATION
  • ORG_DEPARTMENT
  • EMAILID
  • ORG_CONTACT_TYPE
  • URL_ADDRESS
  • CHG_OTHER

  • Data element Definition
    EXT_ORG_ID


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


    Indexed - No
    Format - NUMBER
    Nullable - N
    One-up number / counter of organization contacts.
    EMPLID


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


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Name of individual who is the contact at the organization.
    JOBTITLE


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Title of contact.
    ORG_LOCATION


    Indexed - No
    Format - NUMBER
    Nullable - N
    Number of the org location record of where the contact is located.
    ORG_DEPARTMENT


    Indexed - No
    Format - NUMBER
    Nullable - N
    Number of the org department record of where the contact is located.
    EMAILID


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    email address of contact
    ORG_CONTACT_TYPE


    Indexed - Yes
    Format - VARCHAR2
    Nullable - N
    Type of conctact, e.g. matching gift contact, primary contact, etc.
    URL_ADDRESS


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    URL_ADDRESS
    CHG_OTHER


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Yes/no field

    PS_ORG_CONTACT 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