GM_PERS_COLLAB

(SQL Table)
 Index Back

Collaborator Table

Collaborators data.

  • Related Language Record: GM_PERS_COL_LNG

  • Parent record: PERSONAL_DATA

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSONAL_DATA

    2 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

    Default Value: 10

    3 ORG Character(30) VARCHAR2(30) NOT NULL Organization
    4 EMPLID_RELATED Character(11) VARCHAR2(11) NOT NULL Related People ID

    Prompt Table: GM_PERSONAL1_VW

    5 NAME Character(50) VARCHAR2(50) NOT NULL Name
    6 COLLABORATION_TYPE Character(4) VARCHAR2(4) NOT NULL Collaboration Type
    ARTL=Article
    BOOK=Book
    COPY=Copyright
    OTHR=Other
    PAPR=Paper
    PATN=Patent
    PROJ=Project
    PROP=Proposal
    REPT=Report
    SOFT=Software System
    SRCH=Research

    Default Value: OTHR

    7 COLLAB_START_DT Date(10) DATE Collaboration Start Date
    8 COLLAB_END_DT Date(10) DATE Collaboration End Date
    9 COMMENTS Long Character CLOB Comment