GM_IN_CONTACTS

(SQL Table)
 Index Back

Institution Contacts

This record is used to store the officials that are associated with a particular Institution. There can be many officials for one Institution.

  • Parent record: GM_IN_CONTAC_DT

    • # 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: GM_PERSONAL1_VW

    5 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Prompt Table: GM_JOBCODE_VW2

    6 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: LOCATION_TBL

    7 E_ADDR_TYPE Character(4) VARCHAR2(4) NOT NULL Email Type
    BUSN=Business
    CAMP=Campus
    DORM=Dorm
    HOME=Home
    OTHR=Other

    Prompt Table: GM_IN_EMAIL_VW

    8 UNLIMITED_FLAG Character(1) VARCHAR2(1) NOT NULL Unlimited Threshold

    Y/N Table Edit

    9 LEGAL_BIND Character(3) VARCHAR2(3) NOT NULL Legally Bind Institution

    Y/N Table Edit

    10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: BUS_UNIT_TBL_PC.CURRENCY_CD

    Prompt Table: CURRENCY_CD_TBL

    11 APPROVAL_THRESHOLD Number(10,0) DECIMAL(10) NOT NULL Threshold Amount