EXTR_ACTVTY_TBL

(SQL Table)
 Index Back

Extracurricular Activity Table

EXTR_ACTVTY_TBL stores the Extracurricular Activities that people have participated in at external organizations and at your institution.

  • Related Language Record: EXTR_ACTVTY_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_CS.SETID

    Prompt Table: SETID_TBL

    2 EXTRA_ACTIVITY Character(6) VARCHAR2(6) NOT NULL Extracurricular Activity
    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: EXTR_ACTVTY_TBL.DESCR

    7 OFFERED Character(1) VARCHAR2(1) NOT NULL Offered
    B=Internal and External
    E=External
    I=Internal

    Default Value: B

    8 EXTRA_ACTVTY_TYPE Character(4) VARCHAR2(4) NOT NULL Activity Type
    ATHL=Athletics
    CLUB=Club
    EMPL=Employment
    GOVT=Student Government
    MUSC=Music
    OTHR=Other
    PUBL=Publications
    THEA=Theater
    VOLN=Volunteer

    Default Value: OTHR

    9 EXTRA_ACTVTY_PRIM Number(3,0) SMALLINT NOT NULL Extra Activity Primacy