PC_ACTDESC_TAO

(SQL Table)
Index Back

Project Activity Description

  • Parent record: PROJECT
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: PROJ_ACTIVITY.BUSINESS_UNIT

    2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
    3 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
    4 PC_CPY_UNIQUEID Character(15) VARCHAR2(15) NOT NULL Copy Unique ID
    5 DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    6 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: PROJ_ACTIVITY.SETID

    7 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    8 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    9 DESCRLONG Long Character CLOB Long Description