ACAD_DEGR_PLAN

(SQL Table)
Index Back

Student Degree Plan Table

The Student Degree Plan Table is a list of all Academic Plans in which a student earned a degree at the university.

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

    Prompt Table: PEOPLE_SRCH

    2 STDNT_DEGR Character(2) VARCHAR2(2) NOT NULL Student Degree Nbr

    Default Value: 1

    Prompt Table: DEGREE_TBL

    3 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan

    Default Value: ACAD_PLAN.ACAD_PLAN

    Prompt Table: ACAD_PLAN_DP_VW

    4 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
    BAC=Bachelor (NLD)
    BBL=Vocational Coaching (NLD)
    BOL=Vocational Training (NLD)
    BUSN=Graduate Business
    CNED=Continuing Education
    CRED=Semester Credit
    EDU=Education (NLD)
    EXED=Extended Education
    GRAD=Graduate
    LAW=Law
    MEDS=Medical School
    NONA=Non Award
    PGRD=Postgraduate
    RSCH=Research
    TECH=Technical
    UENG=Undergraduate Engineering
    UGRD=Undergraduate
    VAVO=Advanced General Educ. (NLD)
    VETM=Veterinary Medicine

    Default Value: ACAD_DEGR.ACAD_CAREER

    Prompt Table: STDNT_CAREER

    5 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr

    Prompt Table: ACAD_PROG_AC_VW

    6 ACAD_DEGR_STATUS Character(1) VARCHAR2(1) NOT NULL Academic Degree Status
    A=Awarded
    R=Revoked
    7 DEGR_STATUS_DATE Date(10) DATE Degree Status Date

    Default Value: %date

    8 OVERRIDE_FL Character(1) VARCHAR2(1) NOT NULL Override Flag

    Y/N Table Edit

    Default Value: N

    9 DIPLOMA_DESCR Character(100) VARCHAR2(100) NOT NULL Diploma Description
    10 TRNSCR_DESCR Character(100) VARCHAR2(100) NOT NULL Transcript Description
    11 HONORS_PREFIX Character(3) VARCHAR2(3) NOT NULL Honors Prefix

    Prompt Table: DEGR_HONORS_VW1

    12 HONORS_SUFFIX Character(3) VARCHAR2(3) NOT NULL Honors Suffix

    Prompt Table: DEGR_HONORS_VW2

    13 GPA_PLAN Number(10,3) DECIMAL(9,3) NOT NULL Plan GPA
    14 CLASS_RANK_NBR Number(5,0) INTEGER NOT NULL Class Rank Nbr
    15 CLASS_RANK_TOT Number(5,0) INTEGER NOT NULL Class Rank Total
    16 PLAN_SEQUENCE Number(2,0) SMALLINT NOT NULL Plan Sequence
    17 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).