PC_CPY_ADES_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

    Prompt Table: SP_BU_PC_NONVW

    2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

    Prompt Table: PROJ_SCRTY_VW

    3 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

    Prompt Table: PROJ_ACTIVITY

    4 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.
    5 PC_CPY_UNIQUEID Character(15) VARCHAR2(15) NOT NULL Copy Unique ID
    6 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    7 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    8 DESCRLONG Long Character CLOB Long Description