PROJ_ACTIVITY

(SQL Table)
Index Back

Project Activities

Activities (also known as Tasks) that make up a Project. Activities may be summary activities or detail activities. Summary activities are only used if the project has a work breakdown structure (wbs) where detail activities may roll up to summary activities.

  • Related Language Record: PROJ_ACTIVTY_LG
  • 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: OPR_DEF_TBL_PC.BUSINESS_UNIT

    Prompt Table: SP_BU_PC_NONVW

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

    Default Value: OPR_DEF_TBL_PC.PROJECT_ID

    Prompt Table: SP_PROJ_NONVW

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

    Prompt Table: PC_TYPE_ACT_VW

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 ACTIVITY_TYPE Character(5) VARCHAR2(5) NOT NULL Activity Type
    A=Activity Type
    E=Entry Type
    G=Group Type/Origin
    O=Activity Type/Origin
    R=Entry Type/Reason

    Prompt Table: PROJ_ACT_TBL

    7 WBS_ID Character(100) VARCHAR2(100) NOT NULL WBS ID

    Prompt Table: PC_WBS_DTL_VW

    8 SYSTEM_SOURCE Character(3) VARCHAR2(3) NOT NULL Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.

    Default Value: PPC

    9 ACT_TEMPLATE_ID Character(15) VARCHAR2(15) NOT NULL Activity Template

    Prompt Table: PROJ_ACT_TMP_VW

    10 ACT_TEMPLATE_SW Character(1) VARCHAR2(1) NOT NULL Use Activity as Template

    Y/N Table Edit

    Default Value: N

    11 WORK_ORDER_ID Character(15) VARCHAR2(15) NOT NULL Work Order ID
    12 WORK_ORDER_DTL_ID Character(15) VARCHAR2(15) NOT NULL Work Order Detail
    13 AFUDC_ACT_SW Character(1) VARCHAR2(1) NOT NULL Allow AFUDC Calculation

    Y/N Table Edit

    Default Value: PROJECT.AFUDC_PROJ_SW

    14 TARGET_ACT_SW Character(1) VARCHAR2(1) NOT NULL Allow Node to be target

    Y/N Table Edit

    Default Value: N

    15 SALES_TAX_ACT_SW Character(1) VARCHAR2(1) NOT NULL Allow Sales Tax Calculation

    Y/N Table Edit

    Default Value: N

    16 PERCENT_COMPLETE Number(6,2) DECIMAL(5,2) NOT NULL % Complete

    Default Value: 0

    17 START_DT Date(10) DATE NOT NULL Start Date

    Default Value: PROJECT.START_DT

    18 END_DT Date(10) DATE NOT NULL End Date
    19 EARLY_START_DT Date(10) DATE Early Start Date
    20 LATE_START_DT Date(10) DATE Late Start Date
    21 ACTUAL_START_DT Date(10) DATE Actual Start Date
    22 EARLY_FINISH_DT Date(10) DATE Early Finish Date
    23 LATE_FINISH_DT Date(10) DATE Late Finish Date
    24 ACTUAL_FINISH_DT Date(10) DATE Actual Finish Date
    25 BASELINE_FINISH_DT Date(10) DATE Baseline Finish Date
    26 BASELINE_START_DT Date(10) DATE Baseline Start Date
    27 BCWP Number(3,0) SMALLINT NOT NULL BCWP - Worked Performed
    28 BCWS Number(3,0) SMALLINT NOT NULL BCWS Work Scheduled
    29 ACT_TYPE_SCH Character(5) VARCHAR2(5) NOT NULL Schedule Activity Type

    Prompt Table: PC_ACT_TYPE_SCH

    30 INTEGRATION_ID Character(40) VARCHAR2(40) NOT NULL 3rd Prty Integr Identifier
    31 INTEGRATION_TRG Character(3) VARCHAR2(3) NOT NULL Integration Trigger
    32 INTEGRATION_ANTYPE Character(5) VARCHAR2(5) NOT NULL Integration AnType Override
    33 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.
    34 DRAWING_NAME Character(8) VARCHAR2(8) NOT NULL Drawing Name
    35 ACTIVITY_USER1 Character(10) VARCHAR2(10) NOT NULL User 1
    36 ACTIVITY_USER2 Character(10) VARCHAR2(10) NOT NULL User 2
    37 ACTIVITY_USER3 Character(10) VARCHAR2(10) NOT NULL User 3
    38 ACTIVITY_USER4 Character(10) VARCHAR2(10) NOT NULL User 4
    39 ACTIVITY_USER5 Character(10) VARCHAR2(10) NOT NULL User 5
    40 PC_ACT_USER_DT1 Date(10) DATE Date 1
    41 PC_ACT_USER_DT2 Date(10) DATE Date 2
    42 PC_USER_CURRENCY Character(3) VARCHAR2(3) NOT NULL User Currency

    Prompt Table: CURRENCY_CD_TBL

    43 PC_ACT_USERAMT1 Signed Number(17,2) DECIMAL(15,2) NOT NULL Amount 1
    44 PC_ACT_USERAMT2 Signed Number(17,2) DECIMAL(15,2) NOT NULL Amount 2
    45 PC_ACT_USERAMT3 Signed Number(17,2) DECIMAL(15,2) NOT NULL Amount 3
    46 PC_MSP_UNIQUE_ID Character(22) VARCHAR2(22) NOT NULL Proj Act Unique ID
    47 PC_MILESTONE_FLG Character(1) VARCHAR2(1) NOT NULL Milestone Activity
    N=No
    Y=Yes

    Y/N Table Edit

    48 IN_USE_FLAG Character(1) VARCHAR2(1) NOT NULL Row in use flag
    49 PC_SCH_FIELD1 Character(40) VARCHAR2(40) NOT NULL Generic field used for Projects Third Party Schedule Integration.
    50 PC_SCH_FIELD2 Character(40) VARCHAR2(40) NOT NULL Generic field used for Projects Third Party Schedule Integration.
    51 PC_SCH_FIELD3 Character(40) VARCHAR2(40) NOT NULL Generic field used for Projects Third Party Schedule Integration.
    52 PC_SCH_FIELD4 Character(40) VARCHAR2(40) NOT NULL Generic field used for Projects Third Party Schedule Integration.
    53 PC_SCH_FIELD5 Character(40) VARCHAR2(40) NOT NULL Generic field used for Projects Third Party Schedule Integration.
    54 PC_SCH_FIELD6 Character(40) VARCHAR2(40) NOT NULL Generic field used for Projects Third Party Schedule Integration.
    55 PC_SCH_FIELD7 Character(40) VARCHAR2(40) NOT NULL Generic field used for Projects Third Party Schedule Integration.
    56 WAIVED_FA_CLC_MTHD Character(1) VARCHAR2(1) NOT NULL This field allows a user to defined whether waived facilities and administrative costs are determined by subtracting the budgeted/funded amount from the institution amount or from the sponsor amount.
    I=Institution Minus Funded
    S=Sponsor Minus Funded

    Default Value: BUS_UNIT_OPT_PC.WAIVED_FA_CLC_MTHD

    57 ENFORCE Character(1) VARCHAR2(1) NOT NULL Enforce project team based prompt. Besides the defined translate values, this field is updated with a value of 'N' when team is not enforced in any of the products.
    E=Expenses
    N=No
    T=Time&Labor
    Y=Exp and TL

    Default Value: N

    58 SUMMARY_ACT Character(1) VARCHAR2(1) NOT NULL Flag to indicate whether an activity is summary or detail.
    N=Detail Activity
    Y=Summary Activity

    Default Value: N

    59 PC_DURATION Number(11,2) DECIMAL(10,2) NOT NULL Duration
    60 PC_CHC_ACT_SW Character(1) VARCHAR2(1) NOT NULL Enable Change Control

    Y/N Table Edit

    Default Value: PROJECT.PC_CHC_SW

    61 PGM_SCHED_METHOD Character(1) VARCHAR2(1) NOT NULL The method to be used for Project Scheduling. Valid methods are: Fixed Units, Fixed Duration, and Fixed Work
    D=Fixed Duration
    U=Fixed Units
    W=Fixed Work

    Default Value: PROJECT.PGM_SCHED_METHOD

    62 ASSGND_WORK Signed Number(16,2) DECIMAL(14,2) NOT NULL Assigned Work
    63 ACTUAL_WORK Signed Number(16,2) DECIMAL(14,2) NOT NULL Actual Work
    64 REMAINING_WORK Signed Number(16,2) DECIMAL(14,2) NOT NULL New Remaining work in hours
    65 BASELINE_WORK Signed Number(16,2) DECIMAL(14,2) NOT NULL Baseline Work
    66 COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Cost
    67 DEFAULT_CURR_SW Character(1) VARCHAR2(1) NOT NULL Default Currency

    Default Value: Y

    68 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.
    69 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
    70 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
    71 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.
    72 LEVEL1 Number(5,0) INTEGER NOT NULL Level 1
    73 LEVEL2 Number(5,0) INTEGER NOT NULL Level 2
    74 LEVEL3 Number(5,0) INTEGER NOT NULL Level 3
    75 LEVEL4 Number(5,0) INTEGER NOT NULL Level 4
    76 LEVEL5 Number(5,0) INTEGER NOT NULL Level 5
    77 LEVEL6 Number(5,0) INTEGER NOT NULL Level 6
    78 LEVEL7 Number(5,0) INTEGER NOT NULL Level 7
    79 LEVEL8 Number(5,0) INTEGER NOT NULL Level 8
    80 LEVEL9 Number(5,0) INTEGER NOT NULL Level 9
    81 LEVEL10 Number(5,0) INTEGER NOT NULL Level 10
    82 LEVEL11 Number(5,0) INTEGER NOT NULL Level 11
    83 LEVEL12 Number(5,0) INTEGER NOT NULL Level 12
    84 LEVEL13 Number(5,0) INTEGER NOT NULL Level 13
    85 LEVEL14 Number(5,0) INTEGER NOT NULL Level 14
    86 LEVEL15 Number(5,0) INTEGER NOT NULL Level 15
    87 LEVEL16 Number(5,0) INTEGER NOT NULL Level 16
    88 LEVEL17 Number(5,0) INTEGER NOT NULL Level 17
    89 LEVEL18 Number(5,0) INTEGER NOT NULL Level 18
    90 LEVEL19 Number(5,0) INTEGER NOT NULL Level 19
    91 LEVEL20 Number(5,0) INTEGER NOT NULL Level 20
    92 LEVEL21 Number(5,0) INTEGER NOT NULL Level 21
    93 LEVEL22 Number(5,0) INTEGER NOT NULL Level 22
    94 LEVEL23 Number(5,0) INTEGER NOT NULL Level 23
    95 LEVEL24 Number(5,0) INTEGER NOT NULL Level 24
    96 LEVEL25 Number(5,0) INTEGER NOT NULL Level 25
    97 LEVEL26 Number(5,0) INTEGER NOT NULL Level 26
    98 LEVEL_NUM Number(3,0) SMALLINT NOT NULL Level

    Default Value: 1

    99 ROW_NUMBER_5 Number(5,0) INTEGER NOT NULL Row Number
    100 DEADLINE_DT Date(10) DATE Deadline Date
    101 CONSTRAINT_DT Date(10) DATE Constraint Date
    102 CONSTRAINT_TYPE Character(4) VARCHAR2(4) NOT NULL Constraint Type
    ALAP=As Late As Possible
    ASAP=As Soon As Possible
    ENET=End No Earlier Than
    ENLT=End No Later Than
    MEO=Must End On
    MSO=Must Start On
    SNET=Start No Earlier Than
    SNLT=Start No Later Than
    103 COSTING_ACT_SW Character(1) VARCHAR2(1) NOT NULL Activity Costing Switch - determines whether an activity is available for charging. 'Y' = charging is allowed; 'N' = charging is not allowed.

    Y/N Table Edit

    104 PC_ACT_OWNER Character(11) VARCHAR2(11) NOT NULL Activity Owner - The employee id of the individual who is responsible for the execution of an activity or a group of activities.

    Prompt Table: PC_TEAM_PROM_VW

    105 BILL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Bill Amount
    106 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: PROJECT.CURRENCY_CD

    107 PC_ACT_DEF_CALC_MT Character(1) VARCHAR2(1) NOT NULL Activity Calculation Method
    D=Duration
    E=End Date
    S=Start Date

    Default Value: PROJECT.PC_ACT_DEF_CALC_MT

    108 PARTICIPATING Character(1) VARCHAR2(1) NOT NULL Participating

    Y/N Table Edit

    Default Value: Y

    109 P6_WBS_FLAG Character(1) VARCHAR2(1) NOT NULL A flag, when set to Y(es) indicates that an activity originated from a Primavera WBS.
    N=Activity
    Y=Work Breakdown Structure