EXT_DEGREE_VW

(SQL View)
 Index Back

External Degrees

EXT_DEGREE_VW is a view of the EXT_DEGREE table, it is used in the EXT_DEGREE_SUMMARY panel, there 's no default in this table.

SELECT EMPLID, EXT_ORG_ID, EXT_DEGREE_NBR, DEGREE, DESCR, DEGREE_DT, DEGREE_STATUS, EXT_DATA_NBR, EXT_CAREER FROM PS_EXT_DEGREE

  • Related Language Record: EXT_DEG_LANG_VW

  • Parent record: ACAD_HISTORY

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Default Value: SCC_PERS_SA_VW.EMPLID

    Prompt Table: PEOPLE_SRCH

    2 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

    Default Value: ACAD_HISTORY.EXT_ORG_ID

    Prompt Table: EXT_ORG_TBL

    3 EXT_DEGREE_NBR Number(3,0) SMALLINT NOT NULL External Degree Number
    4 DEGREE Character(8) VARCHAR2(8) NOT NULL Degree

    Prompt Table: DEGREE_TBL

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DEGREE_DT Date(10) DATE NOT NULL Admissions degree date.
    7 DEGREE_STATUS Character(1) VARCHAR2(1) NOT NULL Degree Status
    C=Complete
    D=Discontinued
    I=In Progress
    N=Incomplete
    8 EXT_DATA_NBR Number(3,0) SMALLINT NOT NULL External Data Nbr
    9 EXT_CAREER Character(4) VARCHAR2(4) NOT NULL External Career
    GRAD=Graduate
    HS=High School
    LAW=Law
    MED=Medical
    UGRD=Undergraduate