# Adobe Workfront schema ERD

Table and field reference for the Fivetran Adobe Workfront connector.

## Table & Field Reference

### timesheet_profile

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| group_id | Unknown |  |
| is_overtime_disabled | Unknown |  |
| name | Unknown |  |
| obj_code | Unknown |  |

### program_metadata_flag

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| flag | Unknown |  |
| program_label | Unknown |  |

### program_metadata_operation

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| operation | Unknown |  |
| program_label | Unknown |  |

### program_metadata_field_flag

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| flag | Unknown |  |
| program_field_label | Unknown |  |

### program_metadata_field_operation

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| label | Unknown |  |
| program_field_label | Unknown |  |
| value | Unknown |  |

### program_metadata_field

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| enum_target_obj_code | Unknown |  |
| enum_type | Unknown |  |
| field_type | Unknown |  |
| label | Unknown |  |
| program_label | Unknown |  |
| type_obj_code | Unknown |  |
| url | Unknown |  |

### program_metadata_reference

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| enum_target_obj_code | Unknown |  |
| enum_type | Unknown |  |
| field_type | Unknown |  |
| label | Unknown |  |
| program_label | Unknown |  |
| target_type_obj_code | Unknown |  |
| type_obj_code | Unknown |  |
| url | Unknown |  |

### program_metadata_collection

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| enum_target_obj_code | Unknown |  |
| enum_type | Unknown |  |
| field_type | Unknown |  |
| label | Unknown |  |
| program_label | Unknown |  |
| target_type_obj_code | Unknown |  |
| type_obj_code | Unknown |  |
| url | Unknown |  |

### program_metadata_search

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| enum_target_obj_code | Unknown |  |
| enum_type | Unknown |  |
| field_type | Unknown |  |
| label | Unknown |  |
| program_label | Unknown |  |
| target_type_obj_code | Unknown |  |
| type_obj_code | Unknown |  |
| url | Unknown |  |

### program_metadata_custom_category

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| id | Unknown |  |
| name | Unknown |  |
| obj_code | Unknown |  |
| program_custom_type | Unknown |  |

### program_metadata_custom

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| program_label | Unknown |  |
| type | Unknown |  |

### program_metadata_action_argument

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| name | Unknown |  |
| program_action_label | Unknown |  |
| type | Unknown |  |

### program_metadata_action

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| flags | Json |  |
| label | Unknown |  |
| program_label | Unknown |  |
| result_type | Unknown |  |

### program_metadata_query_argument

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| name | Unknown |  |
| program_query_label | Unknown |  |
| type | Unknown |  |

### program_metadata_query

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| label | Unknown |  |
| program_label | Unknown |  |
| result_type | Unknown |  |

### program_metadata

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| label | Unknown |  |
| name | Unknown |  |
| obj_code | Unknown |  |

### project_custom_value

| Column | Type | Keys |
| --- | --- | --- |
| column_name | Unknown | PK |
| project_id | Unknown | PK, FK |
| value | Unknown |  |

### project_accessor

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| project_id | Unknown | PK, FK |
| accessor_id | Unknown |  |

### project_pending_update_method

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| project_id | Unknown | PK, FK |
| pending_update_method | Unknown |  |

### project_owner_privilege

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| project_id | Unknown | PK, FK |
| owner_privilege | Unknown |  |

### project_audit_type

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| project_id | Unknown | PK, FK |
| audit_type | Unknown |  |

### project_bc_completion_state

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| project_id | Unknown | PK, FK |
| bc_completion_state | Unknown |  |

### project

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| converted_op_task_originator_id | Unknown | FK |
| entered_by_id | Unknown | FK |
| last_updated_by_id | Unknown | FK |
| owner_id | Unknown | FK |
| portfolio_id | Unknown | FK |
| program_id | Unknown | FK |
| resource_pool_id | Unknown | FK |
| sponsor_id | Unknown | FK |
| submitted_by_id | Unknown | FK |
| team_id | Unknown | FK |
| actual_benefit | Unknown |  |
| actual_completion_date | Unknown |  |
| actual_cost | Unknown |  |
| actual_duration_minute | Unknown |  |
| actual_expense_cost | Unknown |  |
| actual_labor_cost | Unknown |  |
| actual_revenue | Unknown |  |
| actual_risk_cost | Unknown |  |
| actual_start_date | Unknown |  |
| actual_value | Unknown |  |
| actual_work_required | Unknown |  |
| alignment | Unknown |  |
| alignment_score_card_id | Unknown |  |
| approval_completion_date | Unknown |  |
| approval_process_id | Unknown |  |
| approval_start_date | Unknown |  |
| auto_baseline_recur_on | Unknown |  |
| auto_baseline_recurrence_type | Unknown |  |
| bcwp | Unknown |  |
| bcws | Unknown |  |
| billed_revenue | Unknown |  |
| budget | Unknown |  |
| budget_status | Unknown |  |
| budgeted_completion_date | Unknown |  |
| budgeted_cost | Unknown |  |
| budgeted_hour | Unknown |  |
| budgeted_labor_cost | Unknown |  |
| budgeted_start_date | Unknown |  |
| category_id | Unknown |  |
| company_id | Unknown |  |
| completion_type | Unknown |  |
| condition | Unknown |  |
| condition_type | Unknown |  |
| converted_op_task_entry_date | Unknown |  |
| converted_op_task_name | Unknown |  |
| cpi | Unknown |  |
| csi | Unknown |  |
| currency | Unknown |  |
| current_approval_step_id | Unknown |  |
| customer_id | Unknown |  |
| deliverable_score_card_id | Unknown |  |
| deliverable_success_score | Unknown |  |
| description | Unknown |  |
| display_order | Unknown |  |
| duration_minute | Unknown |  |
| eac | Unknown |  |
| eac_calculation_method | Unknown |  |
| enable_auto_baseline | Unknown |  |
| entry_date | Unknown |  |
| est_completion_date | Unknown |  |
| est_start_date | Unknown |  |
| ext_ref_id | Unknown |  |
| filter_hour_type | Unknown |  |
| finance_last_update_date | Unknown |  |
| fixed_cost | Unknown |  |
| fixed_end_date | Unknown |  |
| fixed_revenue | Unknown |  |
| fixed_start_date | Unknown |  |
| group_id | Unknown |  |
| has_budget_conflict | Unknown |  |
| has_calc_error | Unknown |  |
| has_document | Unknown |  |
| has_expense | Unknown |  |
| has_message | Unknown |  |
| has_note | Unknown |  |
| has_rate_override | Unknown |  |
| has_resolvable | Unknown |  |
| has_timed_notification | Unknown |  |
| has_timeline_exception | Unknown |  |
| is_original_planned_hours_set | Unknown |  |
| is_status_complete | Unknown |  |
| last_calc_date | Unknown |  |
| last_condition_note_id | Unknown |  |
| last_note_id | Unknown |  |
| last_update_date | Unknown |  |
| leveling_mode | Unknown |  |
| milestone_path_id | Unknown |  |
| name | Unknown |  |
| next_auto_baseline_date | Unknown |  |
| number_open_op_tasks | Unknown |  |
| obj_code | Unknown |  |
| optimization_score | Unknown |  |
| original_work_required | Unknown |  |
| pending_calculation | Unknown |  |
| percent_complete | Unknown |  |
| performance_index_method | Unknown |  |
| personal | Unknown |  |
| planned_benefit | Unknown |  |
| planned_completion_date | Unknown |  |
| planned_cost | Unknown |  |
| planned_expense_cost | Unknown |  |
| planned_labor_cost | Unknown |  |
| planned_revenue | Unknown |  |
| planned_risk_cost | Unknown |  |
| planned_start_date | Unknown |  |
| planned_value | Unknown |  |
| pop_account_id | Unknown |  |
| portfolio_priority | Unknown |  |
| previous_status | Unknown |  |
| priority | Unknown |  |
| progress_status | Unknown |  |
| project_roi | Unknown |  |
| projected_completion_date | Unknown |  |
| projected_start_date | Unknown |  |
| queue_def_id | Unknown |  |
| rejection_issue_id | Unknown |  |
| remaining_cost | Unknown |  |
| remaining_revenue | Unknown |  |
| remaining_risk_cost | Unknown |  |
| resource_planner_budgeted_labor_cost | Unknown |  |
| risk | Unknown |  |
| risk_performance_index | Unknown |  |
| schedule_id | Unknown |  |
| schedule_mode | Unknown |  |
| selected_on_portfolio_optimizer | Unknown |  |
| spi | Unknown |  |
| status | Unknown |  |
| status_update | Unknown |  |
| summary_completion_type | Unknown |  |
| sync_burndown_date | Unknown |  |
| template_id | Unknown |  |
| total_op_task_count | Unknown |  |
| total_task_count | Unknown |  |
| update_type | Unknown |  |
| url | Unknown |  |
| version | Unknown |  |
| work | Unknown |  |
| work_required | Unknown |  |
| work_required_expression | Unknown |  |

### program_custom_value

| Column | Type | Keys |
| --- | --- | --- |
| column_name | Unknown | PK |
| program_id | Unknown | PK, FK |
| value | Unknown |  |

### program

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| entered_by_id | Unknown | FK |
| last_updated_by_id | Unknown | FK |
| owner_id | Unknown | FK |
| portfolio_id | Unknown | FK |
| audit_types | Json |  |
| category_id | Unknown |  |
| customer_id | Unknown |  |
| description | Unknown |  |
| entry_date | Unknown |  |
| ext_ref_id | Unknown |  |
| group_id | Unknown |  |
| has_document | Unknown |  |
| has_message | Unknown |  |
| has_note | Unknown |  |
| is_active | Unknown |  |
| last_update_date | Unknown |  |
| name | Unknown |  |
| obj_code | Unknown |  |
| security_root_id | Unknown |  |
| security_root_obj_code | Unknown |  |

### document_version

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| document_id | Unknown | FK |
| entered_by_id | Unknown | FK |
| last_updated_by_id | Unknown | FK |
| proofed_by_user_id | Unknown | FK |
| accessor_id | Unknown |  |
| active_proof_stage | Unknown |  |
| advanced_proofing_option | Unknown |  |
| create_proof | Unknown |  |
| customer_id | Unknown |  |
| doc_size | Unknown |  |
| doc_status | Unknown |  |
| document_provider_id | Unknown |  |
| document_type_label | Unknown |  |
| entry_date | Unknown |  |
| ext | Unknown |  |
| external_download_url | Unknown |  |
| external_integration_type | Unknown |  |
| external_preview_url | Unknown |  |
| external_storage_id | Unknown |  |
| file_name | Unknown |  |
| file_type | Unknown |  |
| format_doc_size | Unknown |  |
| format_entry_date | Unknown |  |
| icon | Unknown |  |
| is_proof_automated | Unknown |  |
| is_proofable | Unknown |  |
| last_callback_date | Unknown |  |
| location | Unknown |  |
| proof_decision | Unknown |  |
| proof_id | Unknown |  |
| proof_stage_id | Unknown |  |
| proof_status | Unknown |  |
| proof_status_date | Unknown |  |
| proof_status_msg_key | Unknown |  |
| version | Unknown |  |

### reportable_budgeted_hour

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | FK |
| user_id | Unknown | FK |
| allocation_date | Unknown |  |
| budgeted_hour | Unknown |  |
| obj_code | Unknown |  |
| planned_budgeted_hour | Unknown |  |
| role_id | Unknown |  |

### portfolio_custom_value

| Column | Type | Keys |
| --- | --- | --- |
| column_name | Unknown | PK |
| portfolio_id | Unknown | PK, FK |
| value | Unknown |  |

### portfolio

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| entered_by_id | Unknown | FK |
| last_updated_by_id | Unknown | FK |
| owner_id | Unknown | FK |
| accessor_id | Unknown |  |
| aligned | Unknown |  |
| alignment_score_card_id | Unknown |  |
| audit_types | Json |  |
| budget | Unknown |  |
| category_id | Unknown |  |
| currency | Unknown |  |
| customer_id | Unknown |  |
| description | Unknown |  |
| entry_date | Unknown |  |
| ext_ref_id | Unknown |  |
| group_id | Unknown |  |
| has_document | Unknown |  |
| has_message | Unknown |  |
| has_note | Unknown |  |
| is_active | Unknown |  |
| last_update_date | Unknown |  |
| name | Unknown |  |
| net_value | Unknown |  |
| obj_code | Unknown |  |
| on_budget | Unknown |  |
| on_time | Unknown |  |
| portfolio_net_value | Unknown |  |
| portfolio_roi | Unknown |  |
| roi | Unknown |  |

### hour_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| app_global_id | Unknown |  |
| count_as_revenue | Unknown |  |
| customer_id | Unknown |  |
| description | Unknown |  |
| description_key | Unknown |  |
| ext_ref_id | Unknown |  |
| is_active | Unknown |  |
| name | Unknown |  |
| name_key | Unknown |  |
| obj_code | Unknown |  |
| obj_id | Unknown |  |
| obj_obj_code | Unknown |  |
| overhead_type | Unknown |  |
| scope | Unknown |  |

### mile

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| color | Unknown |  |
| customer_id | Unknown |  |
| description | Unknown |  |
| ext_ref_id | Unknown |  |
| milestone_path_id | Unknown |  |
| name | Unknown |  |
| obj_code | Unknown |  |
| sequence | Unknown |  |

### users_web_dav_profile

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| user_id | Unknown | PK, FK |
| profile_type | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| default_hour_type_id | Unknown | FK |
| entered_by_id | Unknown | FK |
| last_updated_by_id | Unknown | FK |
| manager_id | Unknown | FK |
| resource_pool_id | Unknown | FK |
| team_id | Unknown | FK |
| access_level_id | Unknown |  |
| actual_deactivation_date | Unknown |  |
| address | Unknown |  |
| address_2 | Unknown |  |
| api_key_create_date | Unknown |  |
| avatar_date | Unknown |  |
| avatar_size | Unknown |  |
| avatar_x | Unknown |  |
| avatar_y | Unknown |  |
| billing_per_hour | Unknown |  |
| category_id | Unknown |  |
| city | Unknown |  |
| company_id | Unknown |  |
| cost_per_hour | Unknown |  |
| country | Unknown |  |
| customer_id | Unknown |  |
| default_interface | Unknown |  |
| delegation_to_id | Unknown |  |
| email_addr | Unknown |  |
| entry_date | Unknown |  |
| ext_ref_id | Unknown |  |
| first_name | Unknown |  |
| fte | Unknown |  |
| has_api_access | Unknown |  |
| has_document | Unknown |  |
| has_note | Unknown |  |
| has_proof_license | Unknown |  |
| has_reserved_times | Unknown |  |
| home_group_id | Unknown |  |
| home_team_id | Unknown |  |
| is_active | Unknown |  |
| last_entered_note_id | Unknown |  |
| last_login_date | Unknown |  |
| last_name | Unknown |  |
| last_note_id | Unknown |  |
| last_update_date | Unknown |  |
| latest_update_note_id | Unknown |  |
| layout_template_id | Unknown |  |
| license_type | Unknown |  |
| locale | Unknown |  |
| log_time_in_days | Unknown |  |
| login_count | Unknown |  |
| mobile_phone_number | Unknown |  |
| my_info | Unknown |  |
| name | Unknown |  |
| obj_code | Unknown |  |
| password_date | Unknown |  |
| persona | Unknown |  |
| phone_extension | Unknown |  |
| phone_number | Unknown |  |
| portal_profile_id | Unknown |  |
| postal_code | Unknown |  |
| registration_expire_date | Unknown |  |
| reset_password_expire_date | Unknown |  |
| role_id | Unknown |  |
| schedule_id | Unknown |  |
| scheduled_deactivation_date | Unknown |  |
| sso_access_only | Unknown |  |
| sso_username | Unknown |  |
| state | Unknown |  |
| status_update | Unknown |  |
| time_zone | Unknown |  |
| timesheet_profile_id | Unknown |  |
| title | Unknown |  |
| ui_template_id | Unknown |  |
| username | Unknown |  |
| work_hours_per_day | Unknown |  |
| work_time | Unknown |  |

### task_custom_value

| Column | Type | Keys |
| --- | --- | --- |
| column_name | Unknown | PK |
| task_id | Unknown | PK, FK |
| value | Unknown |  |

### task

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| assigned_to_id | Unknown | FK |
| converted_op_task_originator_id | Unknown | FK |
| entered_by_id | Unknown | FK |
| last_updated_by_id | Unknown | FK |
| milestone_id | Unknown | FK |
| parent_id | Unknown | FK |
| project_id | Unknown | FK |
| submitted_by_id | Unknown | FK |
| team_id | Unknown | FK |
| actual_completion_date | Unknown |  |
| actual_cost | Unknown |  |
| actual_duration | Unknown |  |
| actual_duration_minute | Unknown |  |
| actual_expense_cost | Unknown |  |
| actual_labor_cost | Unknown |  |
| actual_revenue | Unknown |  |
| actual_start_date | Unknown |  |
| actual_work | Unknown |  |
| actual_work_required | Unknown |  |
| approval_completion_date | Unknown |  |
| approval_est_start_date | Unknown |  |
| approval_planned_start_date | Unknown |  |
| approval_process_id | Unknown |  |
| approval_projected_start_date | Unknown |  |
| approval_start_date | Unknown |  |
| audit_type | Json |  |
| backlog_order | Unknown |  |
| bcwp | Unknown |  |
| bcws | Unknown |  |
| billing_amount | Unknown |  |
| billing_record_id | Unknown |  |
| can_start | Unknown |  |
| category_id | Unknown |  |
| color | Unknown |  |
| commit_date | Unknown |  |
| completion_pending_date | Unknown |  |
| condition | Unknown |  |
| constraint_date | Unknown |  |
| converted_op_task_entry_date | Unknown |  |
| converted_op_task_name | Unknown |  |
| cost_amount | Unknown |  |
| cost_type | Unknown |  |
| cpi | Unknown |  |
| csi | Unknown |  |
| current_approval_step_id | Unknown |  |
| customer_id | Unknown |  |
| description | Unknown |  |
| duration | Unknown |  |
| duration_minute | Unknown |  |
| duration_type | Unknown |  |
| duration_unit | Unknown |  |
| eac | Unknown |  |
| entry_date | Unknown |  |
| est_completion_date | Unknown |  |
| est_start_date | Unknown |  |
| ext_ref_id | Unknown |  |
| group_id | Unknown |  |
| handoff_date | Unknown |  |
| has_completion_constraint | Unknown |  |
| has_document | Unknown |  |
| has_expense | Unknown |  |
| has_message | Unknown |  |
| has_note | Unknown |  |
| has_resolvable | Unknown |  |
| has_start_constraint | Unknown |  |
| has_timed_notification | Unknown |  |
| hours_per_point | Unknown |  |
| indent | Unknown |  |
| is_agile | Unknown |  |
| is_critical | Unknown |  |
| is_duration_locked | Unknown |  |
| is_leveling_excluded | Unknown |  |
| is_ready | Unknown |  |
| is_status_complete | Unknown |  |
| is_work_required_locked | Unknown |  |
| iteration_id | Unknown |  |
| kanban_board_id | Unknown |  |
| kanban_flag | Unknown |  |
| last_condition_note_id | Unknown |  |
| last_note_id | Unknown |  |
| last_update_date | Unknown |  |
| leveling_start_delay | Unknown |  |
| leveling_start_delay_minute | Unknown |  |
| name | Unknown |  |
| number_of_children | Unknown |  |
| number_open_op_task | Unknown |  |
| obj_code | Unknown |  |
| original_duration | Unknown |  |
| original_work_required | Unknown |  |
| parent_lag | Unknown |  |
| parent_lag_type | Unknown |  |
| pending_calculation | Unknown |  |
| pending_update_method | Json |  |
| percent_complete | Unknown |  |
| personal | Unknown |  |
| planned_completion_date | Unknown |  |
| planned_cost | Unknown |  |
| planned_duration | Unknown |  |
| planned_duration_minute | Unknown |  |
| planned_expense_cost | Unknown |  |
| planned_labor_cost | Unknown |  |
| planned_revenue | Unknown |  |
| planned_start_date | Unknown |  |
| previous_status | Unknown |  |
| priority | Unknown |  |
| progress_status | Unknown |  |
| projected_completion_date | Unknown |  |
| projected_duration_minute | Unknown |  |
| projected_start_date | Unknown |  |
| recurrence_number | Unknown |  |
| recurrence_rule_id | Unknown |  |
| reference_number | Unknown |  |
| rejection_issue_id | Unknown |  |
| remaining_duration_minute | Unknown |  |
| resource_scope | Unknown |  |
| revenue_type | Unknown |  |
| role_id | Unknown |  |
| security_root_id | Unknown |  |
| security_root_obj_code | Unknown |  |
| slack_date | Unknown |  |
| spi | Unknown |  |
| status | Unknown |  |
| status_update | Unknown |  |
| story_point | Unknown |  |
| task_constraint | Unknown |  |
| task_number | Unknown |  |
| template_task_id | Unknown |  |
| tracking_mode | Unknown |  |
| url | Unknown |  |
| version | Unknown |  |
| wbs | Unknown |  |
| work | Unknown |  |
| work_effort | Unknown |  |
| work_required | Unknown |  |

### resource_planner_filter

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |
| obj_code | Unknown |  |

### template_owner_privilege

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| template_id | Unknown | PK, FK |
| owner_privilege | Unknown |  |

### template

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| entered_by_id | Unknown | FK |
| last_updated_by_id | Unknown | FK |
| owner_id | Unknown | FK |
| portfolio_id | Unknown | FK |
| program_id | Unknown | FK |
| sponsor_id | Unknown | FK |
| team_id | Unknown | FK |
| accessor_ids | Unknown |  |
| approval_process_id | Unknown |  |
| auto_baseline_recur_on | Unknown |  |
| auto_baseline_recurrence_type | Unknown |  |
| budget | Unknown |  |
| category_id | Unknown |  |
| company_id | Unknown |  |
| completion_day | Unknown |  |
| completion_type | Unknown |  |
| condition_type | Unknown |  |
| currency | Unknown |  |
| customer_id | Unknown |  |
| deliverable_score_card_id | Unknown |  |
| deliverable_success_score | Unknown |  |
| description | Unknown |  |
| duration_expression | Unknown |  |
| duration_minute | Unknown |  |
| enable_auto_baseline | Unknown |  |
| entry_date | Unknown |  |
| ext_ref_id | Unknown |  |
| filter_hour_type | Unknown |  |
| fixed_cost | Unknown |  |
| fixed_revenue | Unknown |  |
| group_id | Unknown |  |
| has_document | Unknown |  |
| has_expense | Unknown |  |
| has_note | Unknown |  |
| has_timed_notification | Unknown |  |
| is_active | Unknown |  |
| last_note_id | Unknown |  |
| last_update_date | Unknown |  |
| leveling_mode | Unknown |  |
| milestone_path_id | Unknown |  |
| name | Unknown |  |
| pending_calculation | Unknown |  |
| pending_update_methods | Json |  |
| performance_index_method | Unknown |  |
| planned_benefit | Unknown |  |
| planned_cost | Unknown |  |
| planned_expense_cost | Unknown |  |
| planned_labor_cost | Unknown |  |
| planned_revenue | Unknown |  |
| planned_risk_cost | Unknown |  |
| priority | Unknown |  |
| queue_def_id | Unknown |  |
| reference_number | Unknown |  |
| risk | Unknown |  |
| schedule_id | Unknown |  |
| schedule_mode | Unknown |  |
| start_day | Unknown |  |
| summary_completion_type | Unknown |  |
| update_type | Unknown |  |
| url | Unknown |  |
| version | Unknown |  |
| work_required | Unknown |  |

### resource_manager

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | FK |
| resource_manager_id | Unknown | FK |
| customer_id | Unknown |  |
| obj_code | Unknown |  |
| project_priority | Unknown |  |
| template_id | Unknown |  |

### project_metadata_flag

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| flag | Unknown |  |
| project_label | Unknown |  |

### project_metadata_operation

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| operation | Unknown |  |
| project_label | Unknown |  |

### project_metadata_field_flag

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| flag | Unknown |  |
| project_field_label | Unknown |  |

### project_metadata_field_operation

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| label | Unknown |  |
| project_field_label | Unknown |  |
| value | Unknown |  |

### project_metadata_field

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| enum_target_obj_code | Unknown |  |
| enum_type | Unknown |  |
| field_type | Unknown |  |
| label | Unknown |  |
| project_label | Unknown |  |
| type_obj_code | Unknown |  |
| url | Unknown |  |

### project_metadata_reference

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| enum_target_obj_code | Unknown |  |
| enum_type | Unknown |  |
| field_type | Unknown |  |
| label | Unknown |  |
| project_label | Unknown |  |
| target_type_obj_code | Unknown |  |
| type_obj_code | Unknown |  |
| url | Unknown |  |

### project_metadata_collection

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| enum_target_obj_code | Unknown |  |
| enum_type | Unknown |  |
| field_type | Unknown |  |
| label | Unknown |  |
| project_label | Unknown |  |
| target_type_obj_code | Unknown |  |
| type_obj_code | Unknown |  |
| url | Unknown |  |

### project_metadata_search

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| enum_target_obj_code | Unknown |  |
| enum_type | Unknown |  |
| field_type | Unknown |  |
| label | Unknown |  |
| project_label | Unknown |  |
| target_type_obj_code | Unknown |  |
| type_obj_code | Unknown |  |
| url | Unknown |  |

### project_metadata_custom_category

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| id | Unknown |  |
| name | Unknown |  |
| obj_code | Unknown |  |
| project_custom_type | Unknown |  |

### project_metadata_custom

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| project_label | Unknown |  |
| type | Unknown |  |

### project_metadata_action_argument

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| name | Unknown |  |
| project_action_label | Unknown |  |
| type | Unknown |  |

### project_metadata_action

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| flags | Json |  |
| label | Unknown |  |
| project_label | Unknown |  |
| result_type | Unknown |  |

### project_metadata_query_argument

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| name | Unknown |  |
| project_query_label | Unknown |  |
| type | Unknown |  |

### project_metadata_query

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| label | Unknown |  |
| project_label | Unknown |  |
| result_type | Unknown |  |

### project_metadata

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| label | Unknown |  |
| name | Unknown |  |
| obj_code | Unknown |  |

### document

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| checked_out_by_id | Unknown | FK |
| last_updated_by_id | Unknown | FK |
| owner_id | Unknown | FK |
| portfolio_id | Unknown | FK |
| program_id | Unknown | FK |
| project_id | Unknown | FK |
| task_id | Unknown | FK |
| user_id | Unknown | FK |
| accessor_ids | Json |  |
| advanced_proofing_option | Unknown |  |
| category_id | Unknown |  |
| check_out_timestamp | Unknown |  |
| create_proof | Unknown |  |
| current_version_id | Unknown |  |
| customer_id | Unknown |  |
| description | Unknown |  |
| doc_obj_code | Unknown |  |
| document_request_id | Unknown |  |
| download_url | Unknown |  |
| ext_ref_id | Unknown |  |
| has_note | Unknown |  |
| is_private | Unknown |  |
| is_public | Unknown |  |
| iteration_id | Unknown |  |
| last_mod_date | Unknown |  |
| last_note_id | Unknown |  |
| last_sync_date | Unknown |  |
| last_update_date | Unknown |  |
| last_version_num | Unknown |  |
| name | Unknown |  |
| obj_id | Unknown |  |
| op_task_id | Unknown |  |
| preview_url | Unknown |  |
| public_token | Unknown |  |
| reference_number | Unknown |  |
| reference_obj_code | Unknown |  |
| reference_obj_id | Unknown |  |
| reference_object_closed | Unknown |  |
| reference_object_name | Unknown |  |
| release_version_id | Unknown |  |
| security_root_id | Unknown |  |
| security_root_obj_code | Unknown |  |
| template_id | Unknown |  |
| template_task_id | Unknown |  |
| top_doc_obj_code | Unknown |  |
| top_obj_id | Unknown |  |

### resource_pool

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| entered_by_id | Unknown | FK |
| last_updated_by_id | Unknown | FK |
| customer_id | Unknown |  |
| description | Unknown |  |
| entry_date | Unknown |  |
| ext_ref_id | Unknown |  |
| last_update_date | Unknown |  |
| name | Unknown |  |
| obj_code | Unknown |  |

### reserved_time

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | FK |
| customer_id | Unknown |  |
| end_date | Unknown |  |
| ext_ref_id | Unknown |  |
| start_date | Unknown |  |

### hour

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| approved_by_id | Unknown | FK |
| hour_type_id | Unknown | FK |
| last_updated_by_id | Unknown | FK |
| owner_id | Unknown | FK |
| project_id | Unknown | FK |
| project_overhead_id | Unknown | FK |
| task_id | Unknown | FK |
| timesheet_id | Unknown | FK |
| actual_cost | Unknown |  |
| approved_on_date | Unknown |  |
| billing_record_id | Unknown |  |
| customer_id | Unknown |  |
| day | Unknown |  |
| description | Unknown |  |
| dup_id | Unknown |  |
| entry_date | Unknown |  |
| ext_ref_id | Unknown |  |
| has_rate_override | Unknown |  |
| hour | Unknown |  |
| last_update_date | Unknown |  |
| obj_code | Unknown |  |
| op_task_id | Unknown |  |
| resource_revenue | Unknown |  |
| role_id | Unknown |  |
| security_root_id | Unknown |  |
| security_root_obj_code | Unknown |  |
| status | Unknown |  |
| work_hours_per_day | Unknown |  |

### rate

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | FK |
| company_id | Unknown |  |
| customer_id | Unknown |  |
| end_date | Unknown |  |
| ext_ref_id | Unknown |  |
| name | Unknown |  |
| obj_code | Unknown |  |
| rate_value | Unknown |  |
| role_id | Unknown |  |
| security_root_id | Unknown |  |
| security_root_obj_code | Unknown |  |
| start_date | Unknown |  |
| template_id | Unknown |  |

### calendar

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| entered_by_id | Unknown | FK |
| calendar_info_id | Unknown |  |
| customer_id | Unknown |  |
| entry_date | Unknown |  |
| name | Unknown |  |
| obj_code | Unknown |  |
| obj_id | Unknown |  |
| obj_obj_code | Unknown |  |

### team_op_task_bug_report_status

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| team_id | Unknown | PK, FK |
| report_status | Unknown |  |

### team_op_task_change_order_status

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| team_id | Unknown | PK, FK |
| order_status | Unknown |  |

### team_op_task_issue_status

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| team_id | Unknown | PK, FK |
| issue_status | Unknown |  |

### team_op_task_request_status

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| team_id | Unknown | PK, FK |
| request_status | Unknown |  |

### team_task_status

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| team_id | Unknown | PK, FK |
| task_status | Unknown |  |

### team_work_on_it_op_task_bug_report_status

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| team_id | Unknown | PK, FK |
| status | Unknown |  |

### team_work_on_it_op_task_change_order_status

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| team_id | Unknown | PK, FK |
| status | Unknown |  |

### team_work_on_it_op_task_issue_status

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| team_id | Unknown | PK, FK |
| status | Unknown |  |

### team_work_on_it_op_task_request_status

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| team_id | Unknown | PK, FK |
| status | Unknown |  |

### team_work_on_it_task_status

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| team_id | Unknown | PK, FK |
| status | Unknown |  |

### team

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| owner_id | Unknown | FK |
| agile_estimate_type | Unknown |  |
| agile_methodology | Unknown |  |
| auto_add_next_story | Unknown |  |
| complete_days_on_kanban_board | Unknown |  |
| customer_id | Unknown |  |
| default_interface | Unknown |  |
| description | Unknown |  |
| estimate_by_hours | Unknown |  |
| group_id | Unknown |  |
| hours_per_point | Unknown |  |
| is_active | Unknown |  |
| is_agile | Unknown |  |
| is_standard_issue_list | Unknown |  |
| layout_template_id | Unknown |  |
| name | Unknown |  |
| obj_code | Unknown |  |
| schedule_id | Unknown |  |
| team_story_board_issue_statuses | Unknown |  |
| team_story_board_statuses | Unknown |  |
| team_type | Unknown |  |
| ui_template_id | Unknown |  |
| wip_limit | Unknown |  |
| work_on_it_status_change | Unknown |  |

### legacy_resource_pool

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown |  |
| description | Unknown |  |
| display_order | Unknown |  |
| ext_ref_id | Unknown |  |
| name | Unknown |  |
| obj_code | Unknown |  |

### timesheet

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| approver_id | Unknown | FK |
| last_updated_by_id | Unknown | FK |
| timesheet_profile_id | Unknown | FK |
| user_id | Unknown | FK |
| approver_can_edit_hour | Unknown |  |
| customer_id | Unknown |  |
| display_name | Unknown |  |
| end_date | Unknown |  |
| ext_ref_id | Unknown |  |
| has_notes | Unknown |  |
| hours_duration | Unknown |  |
| is_overtime_disabled | Unknown |  |
| last_note_id | Unknown |  |
| last_update_date | Unknown |  |
| obj_code | Unknown |  |
| overtime_hour | Unknown |  |
| regular_hour | Unknown |  |
| start_date | Unknown |  |
| status | Unknown |  |
| total_hour | Unknown |  |

### portfolio_metadata_flag

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| flag | Unknown |  |
| portfolio_label | Unknown |  |

### portfolio_metadata_operation

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| operation | Unknown |  |
| portfolio_label | Unknown |  |

### portfolio_metadata_field_flag

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| flag | Unknown |  |
| portfolio_field_label | Unknown |  |

### portfolio_metadata_field_operation

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| label | Unknown |  |
| portfolio_field_label | Unknown |  |
| value | Unknown |  |

### portfolio_metadata_field

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| enum_target_obj_code | Unknown |  |
| enum_type | Unknown |  |
| field_type | Unknown |  |
| label | Unknown |  |
| portfolio_label | Unknown |  |
| type_obj_code | Unknown |  |
| url | Unknown |  |

### portfolio_metadata_reference

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| enum_target_obj_code | Unknown |  |
| enum_type | Unknown |  |
| field_type | Unknown |  |
| label | Unknown |  |
| portfolio_label | Unknown |  |
| target_type_obj_code | Unknown |  |
| type_obj_code | Unknown |  |
| url | Unknown |  |

### portfolio_metadata_collection

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| enum_target_obj_code | Unknown |  |
| enum_type | Unknown |  |
| field_type | Unknown |  |
| label | Unknown |  |
| portfolio_label | Unknown |  |
| target_type_obj_code | Unknown |  |
| type_obj_code | Unknown |  |
| url | Unknown |  |

### portfolio_metadata_search

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| enum_target_obj_code | Unknown |  |
| enum_type | Unknown |  |
| field_type | Unknown |  |
| label | Unknown |  |
| portfolio_label | Unknown |  |
| target_type_obj_code | Unknown |  |
| type_obj_code | Unknown |  |
| url | Unknown |  |

### portfolio_metadata_custom_category

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| id | Unknown |  |
| name | Unknown |  |
| obj_code | Unknown |  |
| portfolio_custom_type | Unknown |  |

### portfolio_metadata_custom

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| portfolio_label | Unknown |  |
| type | Unknown |  |

### portfolio_metadata_action_argument

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| name | Unknown |  |
| portfolio_action_label | Unknown |  |
| type | Unknown |  |

### portfolio_metadata_action

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| flags | Json |  |
| label | Unknown |  |
| portfolio_label | Unknown |  |
| result_type | Unknown |  |

### portfolio_metadata_query_argument

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| name | Unknown |  |
| portfolio_query_label | Unknown |  |
| type | Unknown |  |

### portfolio_metadata_query

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| label | Unknown |  |
| portfolio_label | Unknown |  |
| result_type | Unknown |  |

### portfolio_metadata

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| label | Unknown |  |
| name | Unknown |  |
| obj_code | Unknown |  |

### work_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | FK |
| task_id | Unknown | FK |
| user_id | Unknown | FK |
| assignment_id | Unknown |  |
| customer_id | Unknown |  |
| done_date | Unknown |  |
| ext_ref_id | Unknown |  |
| is_dead | Unknown |  |
| is_done | Unknown |  |
| last_viewed_date | Unknown |  |
| obj_code | Unknown |  |
| obj_id | Unknown |  |
| obj_obj_code | Unknown |  |
| op_task_id | Unknown |  |
| priority | Unknown |  |
| security_root_id | Unknown |  |
| security_root_obj_code | Unknown |  |
| snooze_date | Unknown |  |

## Relationships

- project_custom_value(project_id) → project(id)
- project_accessor(project_id) → project(id)
- project_pending_update_method(project_id) → project(id)
- project_owner_privilege(project_id) → project(id)
- project_audit_type(project_id) → project(id)
- project_bc_completion_state(project_id) → project(id)
- project(submitted_by_id) → users(id)
- project(entered_by_id) → users(id)
- project(portfolio_id) → portfolio(id)
- project(team_id) → team(id)
- project(owner_id) → users(id)
- project(program_id) → program(id)
- project(converted_op_task_originator_id) → users(id)
- project(last_updated_by_id) → users(id)
- project(resource_pool_id) → legacy_resource_pool(id)
- project(sponsor_id) → users(id)
- program_custom_value(program_id) → program(id)
- program(entered_by_id) → users(id)
- program(portfolio_id) → portfolio(id)
- program(owner_id) → users(id)
- program(last_updated_by_id) → users(id)
- document_version(entered_by_id) → users(id)
- document_version(proofed_by_user_id) → users(id)
- document_version(document_id) → document(id)
- document_version(last_updated_by_id) → users(id)
- reportable_budgeted_hour(user_id) → users(id)
- reportable_budgeted_hour(project_id) → project(id)
- portfolio_custom_value(portfolio_id) → portfolio(id)
- portfolio(entered_by_id) → users(id)
- portfolio(owner_id) → users(id)
- portfolio(last_updated_by_id) → users(id)
- users_web_dav_profile(user_id) → users(id)
- users(entered_by_id) → users(id)
- users(manager_id) → users(id)
- users(default_hour_type_id) → hour_type(id)
- users(last_updated_by_id) → users(id)
- users(resource_pool_id) → legacy_resource_pool(id)
- users(team_id) → team(id)
- task_custom_value(task_id) → task(id)
- task(assigned_to_id) → users(id)
- task(submitted_by_id) → users(id)
- task(entered_by_id) → users(id)
- task(team_id) → team(id)
- task(converted_op_task_originator_id) → users(id)
- task(last_updated_by_id) → users(id)
- task(milestone_id) → mile(id)
- task(project_id) → project(id)
- task(parent_id) → task(id)
- template_owner_privilege(template_id) → template(id)
- template(entered_by_id) → users(id)
- template(portfolio_id) → portfolio(id)
- template(team_id) → team(id)
- template(owner_id) → users(id)
- template(program_id) → program(id)
- template(last_updated_by_id) → users(id)
- template(sponsor_id) → users(id)
- resource_manager(project_id) → project(id)
- resource_manager(resource_manager_id) → users(id)
- document(user_id) → users(id)
- document(portfolio_id) → portfolio(id)
- document(task_id) → task(id)
- document(owner_id) → users(id)
- document(program_id) → program(id)
- document(last_updated_by_id) → users(id)
- document(project_id) → project(id)
- document(checked_out_by_id) → users(id)
- resource_pool(entered_by_id) → users(id)
- resource_pool(last_updated_by_id) → users(id)
- reserved_time(user_id) → users(id)
- hour(task_id) → task(id)
- hour(owner_id) → project(id)
- hour(project_overhead_id) → project(id)
- hour(last_updated_by_id) → users(id)
- hour(project_id) → project(id)
- hour(hour_type_id) → hour_type(id)
- hour(approved_by_id) → project(id)
- hour(timesheet_id) → timesheet(id)
- rate(project_id) → project(id)
- calendar(entered_by_id) → users(id)
- team_op_task_bug_report_status(team_id) → team(id)
- team_op_task_change_order_status(team_id) → team(id)
- team_op_task_issue_status(team_id) → team(id)
- team_op_task_request_status(team_id) → team(id)
- team_task_status(team_id) → team(id)
- team_work_on_it_op_task_bug_report_status(team_id) → team(id)
- team_work_on_it_op_task_change_order_status(team_id) → team(id)
- team_work_on_it_op_task_issue_status(team_id) → team(id)
- team_work_on_it_op_task_request_status(team_id) → team(id)
- team_work_on_it_task_status(team_id) → team(id)
- team(owner_id) → users(id)
- timesheet(user_id) → users(id)
- timesheet(approver_id) → users(id)
- timesheet(last_updated_by_id) → users(id)
- timesheet(timesheet_profile_id) → timesheet_profile(id)
- work_item(user_id) → users(id)
- work_item(task_id) → task(id)
- work_item(project_id) → project(id)