# Workday Adaptive Planning schema ERD

Table and field reference for the Fivetran Workday Adaptive Planning connector.

## Table & Field Reference

### dimension_value_property

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| dimension_id | Long | PK, FK |
| dimension_value_id | Long | PK, FK |
| name | String |  |
| value | Double |  |

### dimension_value_attribute_mapping

| Column | Type | Keys |
| --- | --- | --- |
| attribute_id | Long | PK, FK |
| dimension_id | Long | PK, FK |
| dimension_value_id | Long | PK, FK |
| value_id | Long | PK, FK |

### dimension_value

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| code | String |  |
| description | String |  |
| display_name | String |  |
| name | String |  |
| short_name | String |  |

### account

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| parent_id | Long | FK |
| account_type_code | String |  |
| actuals_by | String |  |
| balance_type | String |  |
| code | String |  |
| data_entry_type | String |  |
| data_privacy | String |  |
| decimal_precision | Int |  |
| description | String |  |
| display_as | String |  |
| enable_actuals | Boolean |  |
| exchange_rate_type | String |  |
| has_formula | Boolean |  |
| has_salary_detail | Boolean |  |
| is_assumption | Boolean |  |
| is_breakback_eligible | Boolean |  |
| is_contra | Boolean |  |
| is_default_root | Boolean |  |
| is_group | Boolean |  |
| is_importable | Boolean |  |
| is_intercompany | Boolean |  |
| is_linked | Boolean |  |
| is_system | Boolean |  |
| level_dim_rollup | String |  |
| level_dim_weight_acct_id | Int |  |
| name | String |  |
| owning_sheet_id | String |  |
| plan_by | String |  |
| rollup_text | String |  |
| short_name | String |  |
| start_expanded | Boolean |  |
| sub_type | String |  |
| suppress_zeroes | Boolean |  |
| time_rollup | String |  |
| time_stratum | String |  |
| time_weight_acct_id | Int |  |

### dimension

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| auto_create | Boolean |  |
| code | String |  |
| description | String |  |
| display_name_type | String |  |
| keep_sorted | Boolean |  |
| list_dimension | Boolean |  |
| name | String |  |
| seq_no | Int |  |
| short_name | String |  |
| use_on_levels | Boolean |  |

### level

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| parent_id | Long | FK |
| available_start | String |  |
| code | String |  |
| currency | String |  |
| description | String |  |
| display_name | String |  |
| has_children | Boolean |  |
| is_elimination | Boolean |  |
| is_importable | Boolean |  |
| is_linked | Boolean |  |
| name | String |  |
| publish_currency | String |  |
| short_name | String |  |
| workflow_status | String |  |

### account_attribute_mapping

| Column | Type | Keys |
| --- | --- | --- |
| account_id | Long | PK, FK |
| attribute_id | Long | PK, FK |
| value_id | Long | PK, FK |

### level_attribute_mapping

| Column | Type | Keys |
| --- | --- | --- |
| attribute_id | Long | PK, FK |
| level_id | Long | PK, FK |
| value_id | Long | PK, FK |

### currency

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| code | String |  |
| description | String |  |
| is_corporate_currency | Boolean |  |
| is_reporting_currency | Boolean |  |
| precision | Int |  |
| user_defined | Boolean |  |

### attribute

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| auto_create | Boolean |  |
| code | String |  |
| dimension_id | Long |  |
| display_name_type | String |  |
| keep_sorted | Boolean |  |
| name | String |  |
| seq_no | String |  |
| type | String |  |

### attribute_value

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| attribute_id | Long | FK |
| parent_id | Long | FK |
| code | String |  |
| description | String |  |
| display_name | String |  |
| name | String |  |

### dimension_value_mapping

| Column | Type | Keys |
| --- | --- | --- |
| dimension_id | Long | PK, FK |
| dimension_value_id | Long | PK, FK |

### custom_report

| Column | Type | Keys |
| --- | --- | --- |
| account_code | String | PK |
| account_name | String | PK |
| custom_dimensions_ | String | PK |
| level_name | String | PK |
| time | String | PK |
| version_name | String | PK |
| value | Double |  |

### version

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| parent_id | Long | FK |
| completed_values_thru | String |  |
| description | String |  |
| enabled_for_workflow | Boolean |  |
| end_plan | String |  |
| end_ver | String |  |
| has_audit_trail | Boolean |  |
| is_default_version | Boolean |  |
| is_importable | Boolean |  |
| is_locked | Boolean |  |
| is_predictive | Boolean |  |
| is_virtual | Boolean |  |
| left_scroll | String |  |
| lock_leading | String |  |
| name | String |  |
| short_name | String |  |
| start_plan | String |  |
| start_scroll | String |  |
| start_ver | String |  |
| type | String |  |

## Relationships

- dimension_value_property(dimension_value_id) → dimension_value(id)
- dimension_value_property(dimension_id) → dimension(id)
- dimension_value_attribute_mapping(dimension_value_id) → dimension_value(id)
- dimension_value_attribute_mapping(dimension_id) → dimension(id)
- dimension_value_attribute_mapping(value_id) → attribute_value(id)
- dimension_value_attribute_mapping(attribute_id) → attribute(id)
- account(parent_id) → account(id)
- level(parent_id) → level(id)
- account_attribute_mapping(account_id) → account(id)
- account_attribute_mapping(attribute_id) → attribute(id)
- account_attribute_mapping(value_id) → attribute_value(id)
- level_attribute_mapping(level_id) → level(id)
- level_attribute_mapping(attribute_id) → attribute(id)
- level_attribute_mapping(value_id) → attribute_value(id)
- attribute_value(attribute_id) → attribute(id)
- attribute_value(parent_id) → attribute_value(id)
- dimension_value_mapping(dimension_value_id) → dimension_value(id)
- dimension_value_mapping(dimension_id) → dimension(id)
- version(parent_id) → version(id)