PGM_CHC_REQ_ACT

(SQL Table)
 Index Back

Activity Changes

Changes to the activities in the Project change request is stored here.

  • Related Language Record: PGM_CHC_ACT_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: PROJ_ACT_SRCH

    5 ACTION_TYPES Character(1) VARCHAR2(1) NOT NULL Action
    A=1 - Add
    E=2 - Edit
    T=3 - Delete
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 ACT_STATUS_OLD Character(1) VARCHAR2(1) NOT NULL Old Status
    8 ACTIVITY_STATUS Character(1) VARCHAR2(1) NOT NULL Activity Status

    Prompt Table: %EDITTABLE2

    9 START_DT_OLD Date(10) DATE Old Start Date : means start date before change is made to the start date
    10 START_DT Date(10) DATE Start Date
    11 END_DT_OLD Date(10) DATE Old End Date
    12 END_DT Date(10) DATE End Date
    13 MILESTONE_FLG_OLD Character(1) VARCHAR2(1) NOT NULL Old Milestone

    Y/N Table Edit

    14 PC_MILESTONE_FLG Character(1) VARCHAR2(1) NOT NULL Milestone Activity
    N=No
    Y=Yes

    Y/N Table Edit

    15 COMMENTS_DETAIL Character(254) VARCHAR2(254) NOT NULL Comments
    16 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.
    17 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
    18 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
    19 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.