GM_DEPT_CNTCT_V

(SQL View)
Index Back

Department Contacts

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

SELECT A.SETID , A.DEPTID , A.EFFDT , A.EMPLID , B.NAME , A.JOBCODE , A.TITLE , A.LOCATION_SETID , A.LOCATION , A.E_ADDR_TYPE , A.UNLIMITED_FLAG , A.LEGAL_BIND , A.CURRENCY_CD , A.APPROVAL_THRESHOLD FROM PS_GM_DEPT_CONTACT A , PS_PERS_DATA_EFFDT B WHERE B.EMPLID = A.EMPLID AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_PERS_DATA_EFFDT B1 WHERE B1.EMPLID = B.EMPLID AND B1.EFFDT <= %CurrentDateIn)

  • Related Language Record: GM_DEPT_CON_LNG
  • Parent record: GM_DEPT_CONT_DT
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    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 NAME Character(50) VARCHAR2(50) NOT NULL Name
    6 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Prompt Table: GM_JOBCODE_VW2

    7 TITLE Character(35) VARCHAR2(35) NOT NULL Title
    8 LOCATION_SETID Character(5) VARCHAR2(5) NOT NULL Location Set ID
    9 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: LOCATION_TBL

    10 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_VW2

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

    Y/N Table Edit

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

    Y/N Table Edit

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

    Default Value: BUS_UNIT_TBL_PC.CURRENCY_CD

    Prompt Table: CURRENCY_CD_TBL

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