HONOR_AWARD_TBL

(SQL Table)
 Index Back

Honors/Awards Table

HONOR_AWARD_TBL stores the Honors and Awards that people receive at external organizations and at your institution.

  • Related Language Record: HONOR_AWARD_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    2 AWARD_CODE Character(6) VARCHAR2(6) NOT NULL Award Code
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: HONOR_AWARD_TBL.DESCR

    7 INTERNAL_EXTERNAL Character(1) VARCHAR2(1) NOT NULL Internal/External
    E=External
    I=Internal

    Default Value: E

    8 GRANTOR Character(20) VARCHAR2(20) NOT NULL The name of the person granting the award
    9 TRANSCRIPT_LEVEL Character(2) VARCHAR2(2) NOT NULL Transcript level
    00=Never Print
    20=Print on Official
    40=Print on Unofficial
    60=Print on Student Life
    80=Print on Degree Progress
    10 DESCRFORMAL Character(50) VARCHAR2(50) NOT NULL Formal Description field

    Default Value: HONOR_AWARD_TBL.DESCR