MicroStrategy ONE
Employee, Level, and Contractor facts
FTE Coefficient
This fact is used to calculate the number of Full Time Equivalents.
Fact: FTE Coefficient
Comment: None
Definition:
| Expression | Mapping Method | Source Table Name |
|
EMP_FTE_COEF |
Automatic |
L_EMPLOYEE |
Tenure
This fact is used to calculate the maximum tenure of departed employees.
Fact: Tenure
Comment: None
Definition:
| Expression | Mapping Method | Source Table Name |
|
SENIORITY |
Automatic |
F_EMP_HIST |
Department Transfer
This fact is used to calculate the total number of department transfers.
Fact: Department Transfer
Comment: None
Definition:
| Expression | Mapping Method | Source Table Name |
|
DPTM_TRANSFER_FLG |
Automatic |
F_EMP_HIST |
Location Transfer
This fact is used to calculate the total number of location transfers.
Fact: Location Transfer
Comment: None
Definition:
| Expression | Mapping Method | Source Table Name |
|
LOC_TRANSFER_FLG |
Automatic |
F_EMP_HIST |
Birth Date
Birth Date, Hire Date, and Leave Date are useful as functions arguments.
Fact: Birth Date
Comment: None
Definition:
| Expression | Mapping Method | Source Table Name |
|
EMP_BIRTH_DATE |
Automatic |
L_EMPLOYEE |
Hire Date
Birth Date, Hire Date, and Leave Date are useful as functions arguments.
Fact: Hire Date
Comment: None
Definition:
| Expression | Mapping Method | Source Table Name |
|
HIRE_DATE |
Automatic |
L_EMPLOYEE |
Leave Date
Birth Date, Hire Date, and Leave Date are useful as functions arguments.
Fact: Leave Date
Comment: None
Definition:
| Expression | Mapping Method | Source Table Name |
|
LEAVE_DATE |
Automatic |
L_EMPLOYEE |
Salary Rate
The Salary Rate, Contract Start Date, and Contract End Date facts are typical elements of an employee contract.
Fact: Salary Rate
Comment: None
Definition:
| Expression | Mapping Method | Source Table Name |
|
SALARY_RATE |
Automatic |
L_CONTRACTOR |
Contract Start Date
The Salary Rate, Contract Start Date, and Contract End Date facts are typical elements of an employee contract.
Fact: Contract Start Date
Comment: None
Definition:
| Expression | Mapping Method | Source Table Name |
|
CONTRACT_START_DATE |
Automatic |
L_CONTRACTOR |
Contract End Date
The Salary Rate, Contract Start Date, and Contract End Date facts are typical elements of an employee contract.
Fact: Contract End Date
Comment: None
Definition:
| Expression | Mapping Method | Source Table Name |
|
CONTRACT_END_DATE |
Automatic |
L_CONTRACTOR |
Level Industry Mode
The Level Industry Mode, Level Max Salary, and Level Min Salary facts are used to compare actual employee salaries to market salaries.
Fact: Level Industry Mode
Comment: None
Definition:
| Expression | Mapping Method | Source Table Name |
|
LEVEL_IND_STD |
Automatic |
F_EMP_LEVEL |
Level Max Salary
The Level Industry Mode, Level Max Salary, and Level Min Salary facts are used to compare actual employee salaries to market salaries.
Fact: Level Max Salary
Comment: None
Definition:
| Expression | Mapping Method | Source Table Name |
|
LEVEL_MAX_SALARY |
Automatic |
F_EMP_LEVEL |
Level Min Salary
The Level Industry Mode, Level Max Salary, and Level Min Salary facts are used to compare actual employee salaries to market salaries.
Fact: Level Min Salary
Comment: None
Definition:
| Expression | Mapping Method | Source Table Name |
|
LEVEL_MIN_SALARY |
Automatic |
F_EMP_LEVEL |