Project_templates

The Entity Fields custom field is available for the Project Templates table.

Columns

Name Type Length Precision Scale References In Description
billing_rate_card_id NUMBER 39 0
billing_schedule_type VARCHAR2 60 Billing schedule type
date_scheduled_end TIMESTAMP
date_template_start TIMESTAMP Date template start
is_inactive VARCHAR2 3 Project is inactive
is_limit_time_to_assignees VARCHAR2 3 Whether only project resources assigned to the project can enter time and expenses for this project
is_source_item_from_brc VARCHAR2 3
project_expense_type_id NUMBER 39 0 Project expense type ID
project_manager_id NUMBER 39 0 employee_id
Employees
scheduling_method_id VARCHAR2 15
template_id NUMBER 39 0 billing_rate_card_id
Billing_rate_cards
Template ID
template_name VARCHAR2 83 Template name
use_budget_from_allocations VARCHAR2 3 Use budget from allocations
use_calculated_billing_budget VARCHAR2 3 Use calculated billing budget
use_calculated_cost_budget VARCHAR2 3 Use calculated cost budget

Foreign keys in this table

FK Name FK Column Name PK Table Name PK Column Name Key Seq
project_templates_billing_rate_cards_fk template_id Billing_rate_cards billing_rate_card_id 1
project_templates_employees_fk project_manager_id Employees employee_id 1