EnterpriseDW_SSAS
 Position SK (Position Attribute)
  Properties
Property Value
Name Position SK
ID Position SK
Attribute Type Regular
Usage Key
Description
Default Member
Discretization Bucket Count 0
Estimated Count 3789
Grouping Behavior EncourageGrouping
Instance Selection None
Is Aggregatable True
Key Uniqueness Guarantee False
Member Names Unique False
Members With Data NonLeafDataVisible
Members With Data Caption
Naming Template
Order By Name
Order By Attribute Id
Root Member If ParentIsBlankSelfOrMissing
Attribute Hierarchy Display Folder
Attribute Hierarchy Enabled True
Attribute Hierarchy Optimized State FullyOptimized
Attribute Hierarchy Ordered True
Attribute Hierarchy Visible True
  Attribute Relationships
Name
Attribute
Relationship Type
Cardinality
Optionality
Override Behavior
Position Code
Position Code
Flexible
Many
Mandatory
Strong
Position Title
Position Title
Flexible
Many
Mandatory
Strong
Position Status
Position Status
Flexible
Many
Mandatory
Strong
Position Type Code
Position Type Code
Flexible
Many
Mandatory
Strong
Position Type
Position Type
Flexible
Many
Mandatory
Strong
Function Code
Function Code
Flexible
Many
Mandatory
Strong
Function Description
Function Description
Flexible
Many
Mandatory
Strong
Date Established
Date Established
Flexible
Many
Mandatory
Strong
Date Inactivated
Date Inactivated
Flexible
Many
Mandatory
Strong
Job Group Code
Job Group Code
Flexible
Many
Mandatory
Strong
Job Group
Job Group
Flexible
Many
Mandatory
Strong
Job Class Code
Job Class Code
Flexible
Many
Mandatory
Strong
Pay Basis
Pay Basis
Flexible
Many
Mandatory
Strong
Budgeted
Budgeted
Flexible
Many
Mandatory
Strong
Regular Temporary
Regular Temporary
Flexible
Many
Mandatory
Strong
Pooled Indicator
Pooled Indicator
Flexible
Many
Mandatory
Strong
Exempt Status
Exempt Status
Flexible
Many
Mandatory
Strong
Primary Salary Account Number
Primary Salary Account Number
Flexible
Many
Mandatory
Strong
Count Of Active Assignments
Count Of Active Assignments
Flexible
Many
Mandatory
Strong
Count Of Inactive Assignments
Count Of Inactive Assignments
Flexible
Many
Mandatory
Strong
Inactive Reason Code
Inactive Reason Code
Flexible
Many
Mandatory
Strong
Inactive Reason
Inactive Reason
Flexible
Many
Mandatory
Strong
Fulltime Equivalent
Fulltime Equivalent
Flexible
Many
Mandatory
Strong
Weekly Authorized Hours
Weekly Authorized Hours
Flexible
Many
Mandatory
Strong
Position Fulltime Parttime
Position Fulltime Parttime
Flexible
Many
Mandatory
Strong
Inactive Vacant Date Range
Inactive Vacant Date Range
Flexible
Many
Mandatory
Strong
Location Code
Location Code
Flexible
Many
Mandatory
Strong
Location
Location
Flexible
Many
Mandatory
Strong
Multiple Funds
Multiple Funds
Flexible
Many
Mandatory
Strong
Powered by BI Documenter