EnterpriseDW_SSAS
 Person ID (Employee Attribute)
  Properties
Property Value
Name Person ID
ID Employee SK
Attribute Type Regular
Usage Key
Description
Default Member
Discretization Bucket Count 0
Estimated Count 11241
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
Employee AK
Employee AK
Flexible
Many
Mandatory
Strong
Employee Type Code
Employee Type Code
Flexible
Many
Mandatory
Strong
Employee Type
Employee Type
Flexible
Many
Mandatory
Strong
Full Name
Full Name
Flexible
Many
Mandatory
Strong
Last Name
Last Name
Flexible
Many
Mandatory
Strong
First Name
First Name
Flexible
Many
Mandatory
Strong
Middle Initial
Middle Initial
Flexible
Many
Mandatory
Strong
Gender Code
Gender Code
Flexible
Many
Mandatory
Strong
Gender
Gender
Flexible
Many
Mandatory
Strong
Ethnicity Code
Ethnicity Code
Flexible
Many
Mandatory
Strong
Ethnicity
Ethnicity
Flexible
Many
Mandatory
Strong
State Code
State Code
Flexible
Many
Mandatory
Strong
State
State
Flexible
Many
Mandatory
Strong
Zip Code
Zip Code
Flexible
Many
Mandatory
Strong
County FIPS Code
County FIPS Code
Flexible
Many
Mandatory
Strong
County
County
Flexible
Many
Mandatory
Strong
Country Code
Country Code
Flexible
Many
Mandatory
Strong
Country
Country
Flexible
Many
Mandatory
Strong
Citizenship Code
Citizenship Code
Flexible
Many
Mandatory
Strong
Citizenship
Citizenship
Flexible
Many
Mandatory
Strong
Country Of Citizenship Code
Country Of Citizenship Code
Flexible
Many
Mandatory
Strong
Country Of Citizenship
Country Of Citizenship
Flexible
Many
Mandatory
Strong
Has Active Assignment
Has Active Assignment
Flexible
Many
Mandatory
Strong
Number Of Active Assignments
Number Of Active Assignments
Flexible
Many
Mandatory
Strong
Last Active Assignment Date Range
Last Active Assignment Date Range
Flexible
Many
Mandatory
Strong
Last Pay Check Date Range
Last Pay Check Date Range
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 Desc
Function Desc
Flexible
Many
Mandatory
Strong
Primary Salary Account Number
Primary Salary Account Number
Flexible
Many
Mandatory
Strong
Is A Student
Is A Student
Flexible
Many
Mandatory
Strong
Employee Student Id
Employee Student Id
Flexible
Many
Mandatory
Strong
Has Direct Deposit
Has Direct Deposit
Flexible
Many
Mandatory
Strong
Hire Date
Hire Date
Flexible
Many
Mandatory
Strong
Employee Fulltime Parttime
Employee Fulltime Parttime
Flexible
Many
Mandatory
Strong
Termination Date
Termination Date
Flexible
Many
Mandatory
Strong
Termination Date Range
Termination Date Range
Flexible
Many
Mandatory
Strong
Years Of Service To Institution
Years Of Service To Institution
Flexible
Many
Mandatory
Strong
Date Of Birth
Date Of Birth
Flexible
Many
Mandatory
Strong
Location Code
Location Code
Flexible
Many
Mandatory
Strong
Location
Location
Flexible
Many
Mandatory
Strong
Employee Age
Employee Age
Flexible
Many
Mandatory
Strong
Powered by BI Documenter