Penn Computing

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

PS_EXT_DEGREE Table - Data Element Index

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

  • EMPLID
  • EXT_ORG_ID
  • EXT_DEGREE_NBR
  • DEGREE
  • DESCR
  • DEGREE_DT
  • DEGREE_STATUS
  • HONORS_CATEGORY
  • EXT_SUBJ_AREA_1
  • EXT_SUBJ_AREA_2
  • FIELD_OF_STUDY_1
  • FIELD_OF_STUDY_2
  • EXT_CAREER
  • EXT_DATA_NBR
  • LS_DATA_SOURCE

  • Data element Definition
    EMPLID


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


    Indexed - Yes
    Format - VARCHAR2
    Nullable - N
    Unique identifier for org (non-individual) records. In this table it is for the external degree granting school.
    EXT_DEGREE_NBR


    Indexed - Yes
    Format - NUMBER
    Nullable - N
    Part of the key, this is a counter of external degrees.
    DEGREE


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Non-Penn (external) degree.
    DESCR


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Type of degree.
    DEGREE_DT


    Indexed - No
    Format - DATE
    Nullable - Y
    Date of external degree.
    DEGREE_STATUS


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Status of degree, e.g. complete.
    HONORS_CATEGORY


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Honor category
    EXT_SUBJ_AREA_1


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Not used
    EXT_SUBJ_AREA_2


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Not used
    FIELD_OF_STUDY_1


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Free text for listing field of study
    FIELD_OF_STUDY_2


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Free text for listing field of study
    EXT_CAREER


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Type of degree
    EXT_DATA_NBR


    Indexed - No
    Format - NUMBER
    Nullable - N
    Not used
    LS_DATA_SOURCE


    Indexed - No
    Format - VARCHAR2
    Nullable - N

    PS_EXT_DEGREE 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