PC_WC_SELPRJTM

(SQL Table)
 Index Back

Selected Projects for Update

  • Related Language Record: PC_WC_SELPRT_LG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    3 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
    4 TEAM_MEMBER_CLASS Character(1) VARCHAR2(1) NOT NULL 05/26/2004 - FS Translate Value "O" added.
    A=Asset
    L=Labor
    M=Material
    O=Other
    5 TEAM_MEMBER_IND Character(1) VARCHAR2(1) NOT NULL Team Member Indicator
    E=Employee
    G=Generic Resource
    N=Not Applicable
    6 TEAM_MEMBER Character(30) VARCHAR2(30) NOT NULL Team Member

    Prompt Table: PC_ALLEMP_VW

    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    8 UPDATE_TYPE Character(1) VARCHAR2(1) NOT NULL Update Type
    A=Activity User Fields
    D=End Date
    E=Project Template Status
    L=Project Location
    M=Project Manager
    S=Status
    T=Project Team
    U=Project User Fields
    Y=Type
    9 UPDATE_REASON Character(254) VARCHAR2(254) NOT NULL Update Description
    10 START_DT Date(10) DATE Start Date
    11 END_DT Date(10) DATE End Date
    12 NEWENDDT Date(10) DATE New End Date
    13 PRJENDDT Character(1) VARCHAR2(1) NOT NULL Project End Dates
    14 PRJTEAMENDDT Character(1) VARCHAR2(1) NOT NULL Project Team End Dates
    15 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role

    Prompt Table: PROJ_ROLE
    Set Control Field: BUSINESS_UNIT

    16 SCHED_NUM Number(5,0) INTEGER NOT NULL Team sequence number
    17 START_DT_2 Date(10) DATE Start Date
    18 END_DT_2 Date(10) DATE End Date