target_dimension table - SuperOffice

target_dimension Table (522)

Defining target dimension

Fields

Name	Description	Type	Nullable
target_dimension_id	Primary key	PK	No
entity_type	Entity type for this set of targets (Sale, Project, Selection, Appointment…)	Enum TargetEntityType	Yes
measurement_unit	What to measure (Amount, Count, Profit…	Enum TargetMeasurementUnit	Yes
assignment_level	What level this dimension can be assigned to (Company, Group, Associate)	Enum TargetAssignementLevel	Yes
dimension_list_field	List that defines the dimensions for this target matrix (ex: Sale type, source, partner, business, udef or extrafield lists…)	String(255)	Yes
selected_dimensions	id’s of the selected/wanted dimensions (what sale types or udef list lines that should be target dimensions)	FKArray	Yes
registered	Registered when	UtcDateTime	No
registered_associate_id	Registered by whom	FK associate	No
updated	Last updated when	UtcDateTime	No
updated_associate_id	Last updated by whom	FK associate	No
updatedCount	Number of updates made to this record	UShort	No

target_dimension table relationship diagram

Indexes

Fields	Types	Description
entity_type	Enum	Index
selected_dimensions	FKArray	Full text

Relationships

Table	Description
associate	Employees, resources and other users - except for External persons
SaleType	Type of sale - large solution, incremental, whatever fits the organization
target_group	Info about a set of (sales, project, selection…) targets

Replication Flags

None

Security Flags

Sentry controls access to items in this table using user’s Role and data rights matrix.

Related topics

Save Target Dimension Delete Target Dimension Get Target Dimension target_group table Create Default Target Dimension Get Target Group For Year And Dimension

⌘I