PC_UPD_PRTM_LOG

(SQL Table)
 Index Back

Selected Projects for Update

  • Related Language Record: PC_UPD_PRTML_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 UPD_SEQ_NUM Number(5,0) INTEGER NOT NULL Update Sequence Number
    3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    4 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
    5 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
    6 TEAM_MEMBER_IND Character(1) VARCHAR2(1) NOT NULL Team Member Indicator
    E=Employee
    G=Generic Resource
    N=Not Applicable
    7 TEAM_MEMBER Character(30) VARCHAR2(30) NOT NULL Team Member
    8 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    9 SCHED_NUM Number(5,0) INTEGER NOT NULL Team sequence number
    10 UPD_STATUS Character(1) VARCHAR2(1) NOT NULL Update Status
    F=Failed
    S=Success
    11 UPDATE_REASON Character(254) VARCHAR2(254) NOT NULL Update Description
    12 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
    13 OLDVALUE Character(65) VARCHAR2(65) NOT NULL Old Value
    14 NEWVALUE Character(65) VARCHAR2(65) NOT NULL New Value
    15 DESCRLONG Long Character CLOB Long Description
    16 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    17 DTTM_PROCESSED DateTime(26) TIMESTAMP Datetime processed