EnterpriseDW_SSAS
 Assignment SK (Assignment Attribute)
  Properties
Property Value
Name Assignment SK
ID Assignment SK
Attribute Type Regular
Usage Key
Description
Default Member
Discretization Bucket Count 0
Estimated Count 24351
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 Key
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
Assignment AK
Assignment AK
Flexible
Many
Mandatory
Strong
Person Id
Person Id
Flexible
Many
Mandatory
Strong
Position Code
Position Code
Flexible
Many
Mandatory
Strong
Assignment Sequence Number
Assignment Sequence Number
Flexible
Many
Mandatory
Strong
Job Title
Job Title
Flexible
Many
Mandatory
Strong
Assignment Status
Assignment Status
Flexible
Many
Mandatory
Strong
Assignment Type Code
Assignment Type Code
Flexible
Many
Mandatory
Strong
Assignment Type
Assignment Type
Flexible
Many
Mandatory
Strong
Function Code
Function Code
Flexible
Many
Mandatory
Strong
Function Desc
Function Desc
Flexible
Many
Mandatory
Strong
Primary Salary Account Number
Primary Salary Account Number
Flexible
Many
Mandatory
Strong
Start Date
Start Date
Flexible
Many
Mandatory
Strong
End Date
End Date
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
Institutional Assignment Type Code
Institutional Assignment Type Code
Flexible
Many
Mandatory
Strong
Institutional Assignment Type
Institutional Assignment Type
Flexible
Many
Mandatory
Strong
Primary Assignment
Primary Assignment
Flexible
Many
Mandatory
Strong
Regular Temporary
Regular Temporary
Flexible
Many
Mandatory
Strong
Exempt Status
Exempt Status
Flexible
Many
Mandatory
Strong
Assignment Fulltime Parttime
Assignment Fulltime Parttime
Flexible
Many
Mandatory
Strong
Assignment End Date Range
Assignment End Date Range
Flexible
Many
Mandatory
Strong
Last Payment Date Range
Last Payment Date Range
Flexible
Many
Mandatory
Strong
End Basis Code
End Basis Code
Flexible
Many
Mandatory
Strong
End Basis
End Basis
Flexible
Many
Mandatory
Strong
Base Salary
Base Salary
Flexible
Many
Mandatory
Strong
Actual Salary
Actual Salary
Flexible
Many
Mandatory
Strong
Daily Rate
Daily Rate
Flexible
Many
Mandatory
Strong
Hourly Rate
Hourly Rate
Flexible
Many
Mandatory
Strong
Overtime Rate
Overtime Rate
Flexible
Many
Mandatory
Strong
Total Salary
Total Salary
Flexible
Many
Mandatory
Strong
Powered by BI Documenter