PGM_CHC_REQ_RES

(SQL Table)
 Index Back

Resource Changes

Resource changes are stored here.This is a part of the project change request.Resources can be added, edited, deleted

  • Related Language Record: PGM_CHC_RES_LG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
    3 CHANGE_REQ_ID Character(15) VARCHAR2(15) NOT NULL Change Request ID
    4 TEAM_MEMBER Character(30) VARCHAR2(30) NOT NULL Team Member

    Prompt Table: %EDITTABLE3

    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

    Default Value: L

    6 TEAM_MEMBER_IND Character(1) VARCHAR2(1) NOT NULL Team Member Indicator
    E=Employee
    G=Generic Resource
    N=Not Applicable

    Default Value: G

    7 ACTION_TYPES Character(1) VARCHAR2(1) NOT NULL Action
    A=1 - Add
    E=2 - Edit
    T=3 - Delete
    8 SCHED_NUM Number(5,0) INTEGER NOT NULL Team sequence number

    Prompt Table: PROJ_TEAM_SCHED

    9 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role

    Prompt Table: PROJ_ROLE

    10 START_DT_OLD Date(10) DATE Old Start Date : means start date before change is made to the start date
    11 START_DT Date(10) DATE Start Date
    12 END_DT_OLD Date(10) DATE Old End Date
    13 END_DT Date(10) DATE End Date
    14 COMMENTS_DETAIL Character(254) VARCHAR2(254) NOT NULL Comments
    15 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.
    16 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
    17 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
    18 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.