PGM_CHC_REQ_ARL

(SQL Table)
 Index Back

Activity Resource Changes

Activity Resource Changes are stored here.This is a part of the Project Change Request

  • Related Language Record: PGM_CHC_ARL_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 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

    Prompt Table: %EDITTABLE4

    5 TEAM_MEMBER Character(30) VARCHAR2(30) NOT NULL Team Member

    Prompt Table: %EDITTABLE5

    6 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

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

    Default Value: E

    8 ACTION_TYPES Character(1) VARCHAR2(1) NOT NULL Action
    A=1 - Add
    E=2 - Edit
    T=3 - Delete
    9 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role

    Prompt Table: PROJ_ROLE

    10 AVAIL_UNITS_OLD Number(6,0) INTEGER NOT NULL Old Units (%)
    11 AVAIL_UNITS Number(6,0) INTEGER NOT NULL New Units (%)
    12 COMMENTS_DETAIL Character(254) VARCHAR2(254) NOT NULL Comments
    13 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.
    14 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
    15 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
    16 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.