FC_TIME_DTL

(SQL Table)
 Index Back

Forecast Time Detail

This record contains the summary of hours entered for a given project and activity. There will be one or more records in this table for each row in FC_TIME_HDR (parent table). Activity id may be left blank if not required according to Projects definition. There should only be one record in this table for each PC business unit and project if no activity has been defined for the selected project. There may be one or more records in this table if project activities are selected.

  • Parent record: FC_TIME_HDR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 BEGIN_DT Date(10) DATE NOT NULL Begin Date
    3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

    Default Value: 1

    4 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

    Prompt Table: SP_BUPCGL_NONVW

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

    Prompt Table: PC_BUGL_TEAM_VW

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

    Prompt Table: PC_ACTEAM_TE_VW

    7 ASSIGNMENT_ID Character(15) VARCHAR2(15) NOT NULL Work Assignment ID
    8 RES_UID Character(15) VARCHAR2(15) NOT NULL Resource ID
    9 ACT_UID Character(15) VARCHAR2(15) NOT NULL Task ID
    10 TOTAL_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Total Hours
    11 REMAINING_HRS Number(8,2) DECIMAL(7,2) NOT NULL Remaining Hours
    12 COMPLETION_DATE Date(10) DATE Completion Date
    13 FORECAST_LEVEL Character(1) VARCHAR2(1) NOT NULL Forecast Level
    A=Project/Activity
    P=Project

    Default Value: A

    14 FORECAST_RATE Character(1) VARCHAR2(1) NOT NULL Standard Rate
    E=Resource
    J=Job Code
    R=Role

    Default Value: R

    15 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role
    16 BILLING_ACTION Character(1) VARCHAR2(1) NOT NULL Billing Action
    B=Billable
    I=Internal
    P=Personal
    U=Nonbillable

    Default Value: B

    17 APPROVAL_STATUS Character(1) VARCHAR2(1) NOT NULL Approval Status
    A=Approved
    D=Denied
    E=Sent Back for Revision
    H=On Hold
    I=Initial
    M=Resubmitted
    P=In Process
    R=Rerouted
    S=Submitted

    Default Value: P

    18 APPROVAL_DT Date(10) DATE Date of Approval
    19 APPROVAL_OPRID Character(30) VARCHAR2(30) NOT NULL A system generated value that reflects the operator that approved a given transaction.