Fivetran documentation

Search the docs

/

Workday Adaptive Planning

Explore the interactive ERD

Table & Field Reference

dimension_value_property

Column	Type	Keys
`id`	Long	PK
`dimension_id`	Long	PKFK
`dimension_value_id`	Long	PKFK
`name`	String
`value`	Double

dimension_value_attribute_mapping

Column	Type	Keys
`attribute_id`	Long	PKFK
`dimension_id`	Long	PKFK
`dimension_value_id`	Long	PKFK
`value_id`	Long	PKFK

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	PKFK
`attribute_id`	Long	PKFK
`value_id`	Long	PKFK

level_attribute_mapping

Column	Type	Keys
`attribute_id`	Long	PKFK
`level_id`	Long	PKFK
`value_id`	Long	PKFK

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	PKFK
`dimension_value_id`	Long	PKFK

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