JDBC Driver for Oracle Fusion Cloud Financials

Build 26.0.9770

ProjectsProjectTeamMembers

An object that includes attributes that are used to store values while creating or updating team members on a project. A project team member is a person who is assigned a role on a project.

Columns

Name Type SupportedFinders Description
ProjectsProjectId [KEY] Long Unique identifier of the project.
FinishDate Date FindChargeableProjectsByPersonIdAndDateRange, findChargeableProjectsByTeamMemberAndDateRange Date on which the assignment of the project team member to the project is scheduled to end.
PersonEmail String Email of the person assigned as a team member to the project.
PersonName String FindByProjectTeamMember, findByProjectRoleAndProjectTeamMember Name of the person assigned as a team member to the project.
ProjectId Long FindByProjectId, PrimaryKey Unique identifier of the project.
ProjectRole String FindByProjectRoleAndProjectTeamMember A classification of the relationship that an employee has to a project. You use project roles to define an employee's level of access to project information. Examples are Project Manager, Project Accountant and Technical Lead.
StartDate Date FindChargeableProjectsByPersonIdAndDateRange, findChargeableProjectsByTeamMemberAndDateRange Date from which the assignment of the team member to the project is scheduled to begin.
TeamMemberId [KEY] Long Unique identifier of the team member assigned to the project.
PersonId Long FindChargeableProjectsByTeamMemberAndDateRange, findChargeableProjectsByPersonIdAndDateRange Unique identifier of the person assigned as a team member to the project.
TrackTimeFlag Bool Indicates whether time cards are expected from internal team members. Valid values are true and false. The default value is false. Information about missing time cards is displayed on the project manager dashboard.
ResourcePlanningCostRate Decimal Cost Rate of the resource assignment for the planning purpose. If no value is specified, Cost Rate of the resource defined in Project Enterprise Resource is used if it is available in the project currency.
ResourceAllocationPercentage Decimal Percentage of time for which a resource is assigned to the project. The default value is 100.
ResourceAssignmentEffortInHours Decimal Number of hours for which a resource is assigned to the project.
ResourcePlanningBillRate Decimal Bill Rate of the resource assignment for the planning purpose. If no value is specified, Bill Rate of the resource defined in Project Enterprise Resource is used if it is available in the project currency.
AssignmentType String Indicates if a request is for a billable or a nonbillable assignment. Examples are BILLABLE, NON-BILLABLE, or leave blank.
BillablePercentReason String Indicates the reason that the billable percentage of the project resource assignment is less than 100%. For a non-billable assignment, the value is ignored.
AssignmentTypeCode String Indicates if a request is for a billable or a nonbillable assignment. Examples are BILLABLE, NON-BILLABLE, or leave blank.
BillablePercentReasonCode String Indicates if a request is for a billable or a nonbillable assignment. Examples are BILLABLE, NON-BILLABLE, or leave blank.
BillablePercent String Indicates if a request is for a billable or a nonbillable assignment. Examples are BILLABLE, NON-BILLABLE, or leave blank.
ActiveDate Date FindByProjectTeamMember, findByProjectRoleAndProjectTeamMember activedate
ClassCategory String FindProjectsByClassCategory classcategory
Finder String finder
OwningOrganizationName String FindByOrg owningorganizationname
PartyName String FindByPartyName partyname
ProjectName String FindByProjectName projectname
ProjectStatus String FindByProjectStatus projectstatus
SearchAttribute String FindChargeableProjectsByPersonIdAndDateRange searchattribute
SourceApplicationCode String FindBySourceApplication sourceapplicationcode
SourceProjectReference String FindBySourceApplication sourceprojectreference

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770