The Entity Fields custom field is available for the Project Templates table.
Name | Type | Length | Precision | Scale | References | In | Description |
---|---|---|---|---|---|---|---|
billing_rate_card_id | NUMBER | 39 | 0 | Billing rate card ID | |||
billing_schedule_type | VARCHAR2 | 60 | Billing schedule type | ||||
date_scheduled_end | TIMESTAMP | Scheduled end date | |||||
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 | Whether service item is sourced in from billing rate card onto a task assignment | ||||
project_expense_type_id | NUMBER | 39 | 0 | Project expense type ID | |||
project_manager_id | NUMBER | 39 | 0 |
employee_id |
Employees |
Project manager ID | |
scheduling_method_id | VARCHAR2 | 15 | Project scheduling method | ||||
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 |
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 |