Penn Computing

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

PS_EXT_ORG_TBL_MV Table - Data Element Index

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

  • EXT_ORG_ID
  • EFFDT
  • EFF_STATUS
  • OTH_NAME_SORT_SRCH
  • EXT_ORG_TYPE
  • SCHOOL_CODE
  • LS_SCHOOL_TYPE
  • FICE_CD
  • ATP_CD
  • ADDRESS1
  • ADDRESS2
  • ADDRESS3
  • ADDRESS4
  • NUM1
  • NUM2
  • HOUSE_TYPE
  • GEO_CODE
  • CITY
  • IN_CITY_LIMIT
  • COUNTY
  • STATE
  • POSTAL
  • COUNTRY
  • DESCR
  • DESCR50
  • DESCRSHORT
  • ORG_CONTACT
  • ORG_LOCATION
  • ORG_DEPARTMENT
  • OFFERS_COURSES
  • PROPRIETORSHIP
  • ACT_CD
  • IPEDS_CD
  • SCHOOL_DISTRICT
  • ACCREDITED
  • TRANSCRIPT_XLATE
  • UNT_TYPE
  • EXT_TERM_TYPE
  • EXT_CAREER
  • SHARED_CATALOG
  • CATALOG_ORG
  • CHG_OTHER
  • SETID
  • VENDOR_ID
  • TAXPAYER_ID_NO
  • UP_ADDR_SRC_CD
  • DATETIME_UPDATED
  • OPRID
  • FULL_NAME

  • Data element Definition
    EXT_ORG_ID


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


    Indexed - No
    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.
    EFF_STATUS


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Effective status of data row ("A" = active, "I" = inactive).
    OTH_NAME_SORT_SRCH


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Search name.
    EXT_ORG_TYPE


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Organization type.
    SCHOOL_CODE


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Not populated.
    LS_SCHOOL_TYPE


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Not populated.
    FICE_CD


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Not populated.
    ATP_CD


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Not populated.
    ADDRESS1


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Address line 1. In a business address row, this field will often house the business name.
    ADDRESS2


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Address line 2. In a business address row, this field occasionally house the business name.
    ADDRESS3


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Address line 3.
    ADDRESS4


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Address line 4.
    NUM1


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Not populated
    NUM2


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Not populated.
    HOUSE_TYPE


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Not populated.
    GEO_CODE


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Not populated.
    CITY


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    City description.
    IN_CITY_LIMIT


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Not populated.
    COUNTY


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    County within state; sparsely populated in database
    STATE


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Two digit state code (ex. PA)
    POSTAL


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Zip code (for domestic zips, either 5 or nine digits, not formatted).
    COUNTRY


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Three digit country abbreviation (ex. 'USA')
    DESCR


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Organization Name
    DESCR50


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Organization Name
    DESCRSHORT


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Short Organization Name.
    ORG_CONTACT


    Indexed - No
    Format - NUMBER
    Nullable - N
    Number that corresponds to the primary contact record in the PS_ORG_CONTACT table.
    ORG_LOCATION


    Indexed - No
    Format - NUMBER
    Nullable - N
    Number that corresponds to the primary location record in the PS_ORG_LOCATION table.
    ORG_DEPARTMENT


    Indexed - No
    Format - NUMBER
    Nullable - N
    Number that corresponds to the primary department record in the PS_ORG_DEPT table.
    OFFERS_COURSES


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Yes no flag indicating that an organization is a school.
    PROPRIETORSHIP


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Indicates private vs. public, etc.
    ACT_CD


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Not populated.
    IPEDS_CD


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Not populated.
    SCHOOL_DISTRICT


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Not populated.
    ACCREDITED


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Not populated.
    TRANSCRIPT_XLATE


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Not populated.
    UNT_TYPE


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Not populated.
    EXT_TERM_TYPE


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Not populated.
    EXT_CAREER


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Not populated.
    SHARED_CATALOG


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Not populated.
    CATALOG_ORG


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Not populated.
    CHG_OTHER


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Not populated.
    SETID


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    This is the Atlas five character code representing the Penn unit that owns a designation. SETIDs map to BEN accounting centers with a few exceptions. UPENN is the default SETID for PENN. Student Financial Services and the President's general university
    VENDOR_ID


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    ID Field
    TAXPAYER_ID_NO


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Id Field
    UP_ADDR_SRC_CD


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Code indicating the source of the address or name update.
    DATETIME_UPDATED


    Indexed - No
    Format - DATE
    Nullable - Y
    Date and time of the last record update
    OPRID


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Id of data entry operator
    FULL_NAME


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Organization name.

    PS_EXT_ORG_TBL_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