PROJ_ACT_TEAM

(SQL Table)
Index Back

Project Activity Team Member

Project Activity Team Member (also known as Resource). This may include labor, material or asset resources. 06/01/2004 - PR_FS_B005 changes done with respect to "Estimating Labor PRL/ARL Changes" TDD.

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

    Default Value: PROJECT.BUSINESS_UNIT

    Prompt Table: SP_BU_PC_NONVW

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

    Prompt Table: PROJECT_ALL_VW

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

    Prompt Table: PROJ_ACTIVITY

    4 TEAM_MEMBER_CLASS Character(1) VARCHAR2(1) NOT NULL 05/26/2004 - FS Translate Value "O" added.
    A=Asset
    L=Labor
    M=Material
    O=Other

    Default Value: L

    5 TEAM_MEMBER_IND Character(1) VARCHAR2(1) NOT NULL Team Member Indicator
    E=Employee
    G=Generic Resource
    N=Not Applicable

    Default Value: G

    6 TEAM_MEMBER Character(30) VARCHAR2(30) NOT NULL Team Member

    Prompt Table: PGM_TEAM_PRM_VW

    7 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role

    Prompt Table: PROJ_ROLE

    8 SCHED_NUM Number(5,0) INTEGER NOT NULL Team sequence number

    Default Value: 1

    Prompt Table: PROJ_TEAM_SCHED

    9 SOURCE_FLAG Character(1) VARCHAR2(1) NOT NULL Team member created from
    6=Primavera P6
    G=Proposal Management
    M=MSP
    P=Projects online
    R=Resource Management
    10 ACT_UID Character(15) VARCHAR2(15) NOT NULL Task ID
    11 DESCRLONG Long Character CLOB Long Description
    12 LASTUPDSOURCE Character(1) VARCHAR2(1) NOT NULL Team member source
    13 USER_FIELD_1 Character(10) VARCHAR2(10) NOT NULL User Field 1
    14 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage

    Prompt Table: %EDIT_UOM

    15 PGM_RATE_TYPE Character(1) VARCHAR2(1) NOT NULL 06/15/2004 FS - Changed eff. dates to 1/1/1900 from 1/1/2000
    C=Override Rate
    E=Employee Rate
    J=Jobcode Rate
    R=Project Role Rate
    X=Custom Rate
    16 COST_RATE Number(27,3) DECIMAL(26,3) NOT NULL Cost Rate
    17 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: PROJECT.CURRENCY_CD

    Prompt Table: CURRENCY_CD_TBL

    18 COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Cost
    19 PC_BUDGET_ITEM Character(15) VARCHAR2(15) NOT NULL Project Budgeting: Budget Item 11/15/2004- FS - Added label COST_BUDGET_ITEM

    Prompt Table: %EDIT_BUD_CAT

    20 AVAIL_UNITS Number(6,0) INTEGER NOT NULL Availability Units

    Default Value: 100

    21 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity
    22 ASSGND_WORK Signed Number(16,2) DECIMAL(14,2) NOT NULL Assigned Work

    Default Value: 0

    23 ACTUAL_WORK Signed Number(16,2) DECIMAL(14,2) NOT NULL Actual Work
    24 REMAINING_WORK Signed Number(16,2) DECIMAL(14,2) NOT NULL New Remaining work in hours
    25 BASELINE_WORK Signed Number(16,2) DECIMAL(14,2) NOT NULL Baseline Work
    26 RESOURCE_NOTIFIED Character(1) VARCHAR2(1) NOT NULL Flag to indicate whether an activity resource has been notified of his/her assignment to the activity.
    N=Not Notified
    Y=Notified

    Y/N Table Edit

    Default Value: N

    27 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.
    28 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
    29 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
    30 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.
    31 BILL_RATE Number(27,3) DECIMAL(26,3) NOT NULL Billing Rate
    32 BILL_RATE_TYPE_1 Character(1) VARCHAR2(1) NOT NULL 06/03/2004 - PR_FS_B005 Estimanting Labor PRL/ARL Changes
    C=Override Rate
    E=Employee Rate
    J=Jobcode Rate
    R=Project Role Rate
    X=Custom Rate
    33 BILL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Bill Amount
    34 BILL_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Bill Currency Code

    Default Value: PROJECT.CURRENCY_CD

    Prompt Table: CURRENCY_CD_TBL

    35 ACT_ASSGN_DAYS Number(8,2) DECIMAL(7,2) NOT NULL Actual Assignment Days
    36 ASSIGNED_TO_WO Character(1) VARCHAR2(1) NOT NULL An indicator that if a project activitity resource is copied over to a work order.
    N=No
    Y=Yes

    Default Value: N

    37 EXCEPTION_NUM Number(3,0) SMALLINT NOT NULL Exception Flag

    Default Value: 0

    38 ASSET_TYPE Character(3) VARCHAR2(3) NOT NULL Asset Type
    010=IT Hardware
    020=IT Software
    040=Equipment
    050=Property
    060=Fleet
    070=Machinery
    080=Furniture
    090=Facility
    100=Intangible
    200=Asset Retirement Obligations
    999=Other
    39 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL Asset Subtype

    Prompt Table: AM_SUBTYPE

    40 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID

    Prompt Table: MANUFACTURER

    41 MODEL Character(30) VARCHAR2(30) NOT NULL Model

    Prompt Table: MFG_MODEL

    42 P6_MERGED_ASSIGNMT Character(1) VARCHAR2(1) NOT NULL An indicator that tells whether a resource assignment (activity team member) originated from a merging of multiple P6 assignments.
    N=Not Merged
    Y=Merged

    Y/N Table Edit

    Default Value: N

    43 DEF_CRATE_COST Character(15) VARCHAR2(15) NOT NULL The default Custom Rate Name for costing rate

    Prompt Table: PC_CR_PRL_VW

    44 DEF_CRATE_BILL Character(15) VARCHAR2(15) NOT NULL The default Custom Rate Name for billing rate

    Prompt Table: PC_CR_PRL_VW