GM_IN_CNT_TYP

(SQL Table)
 Index Back

Institution Contact Types

.

  • Parent record: GM_IN_CONTACTS

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

    Prompt Table: SP_SETID_NONVW

    2 INSTID Character(5) VARCHAR2(5) NOT NULL Institution ID

    Prompt Table: GM_INSTITUTION

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSONAL_DATA

    5 OFFICIAL_TYPE Character(3) VARCHAR2(3) NOT NULL Official Type
    ADM=Administrative Official
    BUS=Business Officer
    CEO=Chief Executive Officer
    DEA=Dean
    DEP=Department Administrator
    HEA=Department Head
    IO=Institution Officer
    PRO=Provost
    PRS=President
    REP=Authorized Inst. Rep/Payee
    SEN=Senior Official