INSTR_ADVISOR

(SQL Table)
 Index Back

Instructor/Advisor table

This table contains the instructors and advisors and the type of instructors they are.

  • Parent record: PERSON

    • # 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 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    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 ACAD_ORG Character(10) VARCHAR2(10) NOT NULL Academic Organization

    Prompt Table: ACAD_ORG_TBL_VW

    6 ADVISOR Character(1) VARCHAR2(1) NOT NULL Advisor

    Y/N Table Edit

    Default Value: N

    7 INSTR_TYPE Character(4) VARCHAR2(4) NOT NULL Instructor Type
    ADJ=Adjunct Professor
    ADV=Advisor Only
    ASSC=Associate Professor
    ASST=Assistant Professor
    EMRT=Emeritus
    INST=Instructor
    LECT=Lecturer
    PROF=Professor
    TA=Teaching Assistant
    UNDF=Undefined
    VLEC=Visiting Lecturer
    VPRF=Visiting Professor
    8 INSTR_AVAILABLE Character(2) VARCHAR2(2) NOT NULL Instructor Available
    A=Available
    S=Sabbatical
    U=Unavailable

    Default Value: A