PROJECT_TEAM

(SQL Table)
 Index Back

Project Team Member

Resources (both labor and non-labor) that are assigned to a project. Labor resources may be generic (employee not yet identified) or named (employee has been identified). Non-labor resources are material and assets. When project row-level security is turned on at the User ID level, using the List option, the Project team will also control row-level security to the project. 06/01/2004 - PR_FS_B005 changes done with respect to "Estimating Labor PRL/ARL Changes" TDD.

  • Related Language Record: PROJ_TEAM_LANG

  • 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: 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 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

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

    Default Value: E

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

    Prompt Table: %EDITTABLE

    6 EMAIL_NOTIFICATION Character(1) VARCHAR2(1) NOT NULL Email Notify for Status Change
    N=No
    Y=Yes

    Default Value: Y

    7 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
    8 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

    Default Value: P

    9 REQ_ASSIGNMENT_ID Character(15) VARCHAR2(15) NOT NULL Work Assignment ID
    10 REQ_ASSIGN_METHOD Character(1) VARCHAR2(1) NOT NULL Requirement fulfill method
    A=Assigned Status change from PC
    D=Direct Assignment from Project
    E=Map to an existing team member
    M=Direct assignment from MSP
    R=Assignment from RS
    S=Service Order
    W=Search & Assign from Workbench
    11 PLAN_PROJROLE Character(15) VARCHAR2(15) NOT NULL Requirement Project Role

    Prompt Table: PROJ_ROLE

    12 SOURCE_REQ Character(25) VARCHAR2(25) NOT NULL Source Requirement ID
    13 SO_ID Character(15) VARCHAR2(15) NOT NULL Service Order ID
    14 SO_LINE Number(3,0) SMALLINT NOT NULL Line Number
    15 TEAM_SCHED_CNT Number(4,0) SMALLINT NOT NULL Project Team Count

    Default Value: 1

    16 RES_UID Character(15) VARCHAR2(15) NOT NULL Resource ID
    17 LASTUPDSOURCE Character(1) VARCHAR2(1) NOT NULL Team member source
    18 USER_FIELD_1 Character(10) VARCHAR2(10) NOT NULL User Field 1
    19 FROM_JCODE Character(6) VARCHAR2(6) NOT NULL Job Code
    20 PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage
    21 APPT_TYPE_MTH_ACAD Number(6,2) DECIMAL(5,2) NOT NULL Academic Appointment Months
    22 APPT_TYPE_MTH_CAL Number(6,2) DECIMAL(5,2) NOT NULL Calendar Appointment Months
    23 APPT_TYPE_MTH_SUMR Number(6,2) DECIMAL(5,2) NOT NULL Summer Appointment Months
    24 DESCRLONG Long Character CLOB Long Description
    25 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage

    Default Value: OPR_DEF_TBL_PC.UNIT_OF_MEASURE

    Prompt Table: %EDIT_UOM

    26 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
    27 COST_RATE Number(27,3) DECIMAL(26,3) NOT NULL Cost Rate

    Default Value: 0

    28 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: PROJECT.CURRENCY_CD

    Prompt Table: CURRENCY_CD_TBL

    29 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

    30 PLAN_STARTDT Date(10) DATE Planned Start Date

    Default Value: PROJECT.START_DT

    31 PLAN_ENDDT Date(10) DATE Planned End Date

    Default Value: PROJECT.END_DT

    32 EXCEPTION_NUM Number(3,0) SMALLINT NOT NULL Exception Flag
    33 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.
    34 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
    35 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
    36 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.
    37 BILL_RATE Number(27,3) DECIMAL(26,3) NOT NULL Billing Rate

    Default Value: 0

    38 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
    39 ORIGINAL_RES_ID Character(30) VARCHAR2(30) NOT NULL Original Resource ID
    40 BILL_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Bill Currency Code

    Default Value: PROJECT.CURRENCY_CD

    Prompt Table: CURRENCY_CD_TBL

    41 CREDIT_PCT Number(6,2) DECIMAL(5,2) NOT NULL Percentage Credit
    42 RESOURCE_STS Character(2) VARCHAR2(2) NOT NULL 11/15/2004 - New field added.
    AL=Allocated
    CA=Cancelled
    CM=Committed
    CO=Considered
    CP=Completed
    RE=Rejected
    RQ=Requested

    Default Value: CO

    43 POOL_ID Character(10) VARCHAR2(10) NOT NULL Pool ID field.

    Prompt Table: RS_POOL_ACTIVE

    44 PER_STATUS Character(1) VARCHAR2(1) NOT NULL Personnel Status
    E=Employee
    N=Non-Employee
    45 REGION_CD Character(10) VARCHAR2(10) NOT NULL Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.

    Prompt Table: RS_REGION_VW
    Set Control Field: REGION_CD

    46 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
    47 TASK_TYPE Character(18) VARCHAR2(18) NOT NULL Task Category

    Prompt Table: RS_TASK_CAT

    48 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
    49 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL Asset Subtype

    Prompt Table: AM_SUBTYPE

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

    Prompt Table: MFG_MODEL

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

    Prompt Table: MANUFACTURER

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

    Prompt Table: PC_CR_PRL_VW

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

    Prompt Table: PC_CR_PRL_VW