PC_PERCENT1_TAO

(SQL Table)
 Index Back

Project Activities

  • Parent record: PROJECT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT

    Prompt Table: SP_BU_PC_NONVW

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

    Default Value: OPR_DEF_TBL_PC.PROJECT_ID

    Prompt Table: SP_PROJ_NONVW

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

    Prompt Table: PC_TYPE_ACT_VW

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

    Default Value: 0

    6 START_DT Date(10) DATE Start Date
    7 END_DT Date(10) DATE End Date
    8 PC_PERCENT_CURRENT Signed Number(27,2) DECIMAL(25,2) NOT NULL Current Value
    9 PC_PERCENT_TOTAL Signed Number(27,2) DECIMAL(25,2) NOT NULL Total Value
    10 SUMMARY_ACT Character(1) VARCHAR2(1) NOT NULL Flag to indicate whether an activity is summary or detail.
    N=Detail Activity
    Y=Summary Activity
    11 PC_CALC_METHOD Character(1) VARCHAR2(1) NOT NULL Calculation Method
    A=Budget Amount
    D=Duration
    F=Forecast Amount
    H=Forecast Hours
    M=Manual
    U=Budget Hours
    12 PC_SUM_METHOD Character(1) VARCHAR2(1) NOT NULL Summary Method
    N=None
    S=Straight-Line
    W=Weighted
    13 RETAIN_HISTORY Character(1) VARCHAR2(1) NOT NULL Indicator to determine how often history is retained.
    D=Daily
    M=Monthly
    Q=Quarterly
    W=Weekly

    Default Value: W