MicroStrategy ONE
Employee filters
This table contains all the attribute qualification filters based on a specified set of elements. The attribute is Employee-based.
| Filter | Description |
|
Full-time |
Position Status in list "Full-time" |
|
Part-time |
Position Status in list "Part-time" |
|
Recent Hires |
Date between prompted value and today's date |
|
Active Contractor |
Contract activity in list "Active" |
|
Executive Level |
Level in list "Executive" |
|
Executive Employees |
Set of employees where Level=Executive, relate by table F_EMP_LEVEL |
|
Involuntary Departure |
Leave Reason in list "Reduction in Force" |
|
Voluntary Departure |
Leave Reason in list "Retirement, Better Opportunity, Relocation, Personal Reasons, Other Reasons" |
|
Exempt |
Exempt status in list "1" |
|
Non-exempt |
Exempt status in list "0" |
|
Tenure <= 2 months |
Tenure in list "1, 2" |
|
Tenure 3 - 4 months |
Tenure in list "3, 4" |
|
Tenure 5 - 7 months |
Tenure in list "5, 6, 7" |
|
Tenure 8 -10 months |
Tenure in list "8, 9, 10" |
|
Tenure > 10 months |
Tenure in list "11, 12, 13, 14, 15, 16, 17, 18" |
|
Active Employee (Current) |
Current Status in list "Active" |
|
Inactive Employee (Current) |
Current Status in list "Inactive" |
|
Involuntary Departed and Inactive Current |
Inactive Employee (Current) AND Involuntary Departure |
|
Voluntary Departed and Inactive Current |
Inactive Employee (Current) AND Voluntary Departure |
|
Active Employee (Hist) |
Historical Status in list "Active" |
|
Departed Employees (Hist) |
Historical Status in list "Inactive" |
|
Involuntary Departed Employees |
Set of employees where Leave Reason = Reduction in force, relate by table L_EMPLOYEE AND Departed Employees (Hist) |
|
Voluntary Departed Employees |
Set of Employees where Leave Reason = "Retirement, Better Opportunity, Relocation, Personal Reasons, Other Reasons", relate by table L_EMPLOYEE AND Departed Employees (Hist) |
|
Departed Employees by Leave Reason |
Set of Employees, Year, Leave Reason where Departed Employees >0 relate by table L_EMPLOYEE |
|
Departed Employees > 0 (Hist) |
Evaluate the set at the report level where (Departed Employees greater than 0) |
|
Active Executives (Hist) |
Executive Employees AND Active Employee (Hist) |
|
Full-time and Active (Hist) |
Full-time AND Active Employee (Hist) |
|
Part-time and Active (Hist) |
Position Status In list (Part-time) AND Historical Status In list (Active) |
|
Tenure = 1 |
Tenure in list "1" |
|
Non-exempt and Active Employee (Hist) |
Active Employee (Hist) AND Non-Exempt |
|
Men |
Gender in list "M" |
|
Women |
Gender in list "F" |
|
White |
Ethnicity in list "White" |
|
Minority |
Ethnicity in list "Asian, African, Hispanic, Indian, Other" |
|
Minority Men |
Minority AND Men |
|
Minority Women |
Minority AND Women |
|
White Men |
White AND Men |
|
White Women |
White AND Women |
|
Minority Group is Not Null |
Minority Group (ID) is Not Null |
|
Active Employees with Minority Group (Hist) |
Active Employee (Hist) AND Minority Group is Not Null |
|
Tenure=1 and Minority Group |
Tenure = 1 AND Minority Group is Not Null |
|
Involuntary Departed Employees with Minority |
Set of Employees where Leave Reason = Reduction in Force AND Departed Employees (Hist) AND Minority Group is Not Null |
|
Department Transfer |
Department Transfer in list "1" |
|
Location Transfer |
Location Transfer in list "1" |
|
Employees with Department Transfer |
Set of Employees where {Department Transfers}=1, Relate by the Table F_EMP_HIST |
|
Department Transfer or Location Transfer |
Department transfer OR location transfer |
|
Active Transfers (Hist) |
Active Employee (Hist) AND Department Transfer or Location Transfer |