Adobe Workfront

Explore the interactive ERD

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	PKFK
`value`	Unknown

project_accessor

Column	Type	Keys
`index`	Unknown	PK
`project_id`	Unknown	PKFK
`accessor_id`	Unknown

project_pending_update_method

Column	Type	Keys
`index`	Unknown	PK
`project_id`	Unknown	PKFK
`pending_update_method`	Unknown

project_owner_privilege

Column	Type	Keys
`index`	Unknown	PK
`project_id`	Unknown	PKFK
`owner_privilege`	Unknown

project_audit_type

Column	Type	Keys
`index`	Unknown	PK
`project_id`	Unknown	PKFK
`audit_type`	Unknown

project_bc_completion_state

Column	Type	Keys
`index`	Unknown	PK
`project_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`report_status`	Unknown

team_op_task_change_order_status

Column	Type	Keys
`index`	Unknown	PK
`team_id`	Unknown	PKFK
`order_status`	Unknown

team_op_task_issue_status

Column	Type	Keys
`index`	Unknown	PK
`team_id`	Unknown	PKFK
`issue_status`	Unknown

team_op_task_request_status

Column	Type	Keys
`index`	Unknown	PK
`team_id`	Unknown	PKFK
`request_status`	Unknown

team_task_status

Column	Type	Keys
`index`	Unknown	PK
`team_id`	Unknown	PKFK
`task_status`	Unknown

team_work_on_it_op_task_bug_report_status

Column	Type	Keys
`index`	Unknown	PK
`team_id`	Unknown	PKFK
`status`	Unknown

team_work_on_it_op_task_change_order_status

Column	Type	Keys
`index`	Unknown	PK
`team_id`	Unknown	PKFK
`status`	Unknown

team_work_on_it_op_task_issue_status

Column	Type	Keys
`index`	Unknown	PK
`team_id`	Unknown	PKFK
`status`	Unknown

team_work_on_it_op_task_request_status

Column	Type	Keys
`index`	Unknown	PK
`team_id`	Unknown	PKFK
`status`	Unknown

team_work_on_it_task_status

Column	Type	Keys
`index`	Unknown	PK
`team_id`	Unknown	PKFK
`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