ODBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

ProjectTemplatesProjectTeamMembers

The Project Team Member resource is used to view project team members. A project team member is a person who is assigned a role on a project.

Columns

Name Type Description
ProjectTemplatesProjectTemplateId [KEY] Long Unique identifier of the project template.
AssignmentType String Indicates if a request is for a billable or a nonbillable assignment. Examples are BILLABLE, NON-BILLABLE, or leave blank.
AssignmentTypeCode String Code to indicate if a request is for a billable or a nonbillable assignment. Examples are BILLABLE, NON-BILLABLE, or leave blank.
BillablePercent Int Indicates the percentage of assignment time that is billable for an assignment that is defined as billable assignment. For a non-billable assignment, the value is ignored. Valid values are positive integers between 0 and 100.
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.
BillablePercentReasonCode String Code that 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.
FinishDate Date 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.
PersonId Long Unique identifier of the person assigned as a team member to the project.
PersonName String Name of the person assigned as a team member to the project.
ProjectRoleId Long 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.
ProjectRoleName String 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.
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.
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.
StartDate Date 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.
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.
CreatedBy String The user who created the record.
CreationDate Datetime The date when the record was created.
LastUpdateDate Datetime The date when the record was last updated.
LastUpdatedBy String The user who last updated the record.
Finder String Finder criteria used to filter project template team members based on specific search parameters and conditions.
ProjectTemplateId Long Unique identifier of the project template.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434