ACAD_DEGR_HONS

(SQL Table)
 Index Back

Student Degree Honors Table

The Student Degree Honors Table is a list of all Academic honors a student has earned for a degree.

  • 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

    Prompt Table: ACAD_DEGR

    3 HONORS_NBR Number(1,0) SMALLINT NOT NULL Honors Number
    4 HONORS_CODE Character(3) VARCHAR2(3) NOT NULL Honors Code

    Prompt Table: DEGR_HONORS_VW1

    5 HONORS_AWARD_DT Date(10) DATE Honors Award Date
    6 DIPLOMA_PRINT_FL Character(1) VARCHAR2(1) NOT NULL Print on Diploma

    Y/N Table Edit

    7 TRNSCR_PRINT_FL Character(1) VARCHAR2(1) NOT NULL Print on Transcript

    Y/N Table Edit

    8 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).