| DepartmentType |
entity |
linkspeaker_phone |
Unique identifier for the type of department in a company. A single department encompasses multiple roles. |
<1K |
| HeadCountAccuracyThreshold |
entity |
linkspeaker_phone |
This table stores the details of the entities which breach the accuracy threshold of +/- 40%, when vendor headcount data for the latest month is compared with the latest available self-sourced headcount data. |
<1K |
| HeadCountAverageTenure |
entity |
linkspeaker_phone |
The average employee tenure by role, level and department at a given company. |
4.1 M |
| HeadCountAverageTenureUncons |
entity |
linkspeaker_phone |
The average employee tenure by role, level and department at a given company, not aggregated as per the corporate structure applicable for that company. |
157.2 K |
| HeadCountByMetro |
entity |
linkspeaker_phone |
The headcount data by state and city i.e. USA Only. |
4.9 M |
| HeadCountByMetroUncons |
entity |
linkspeaker_phone |
The headcount data for a company by state and city i.e. USA Only. This is not aggregated as per the corporate structure applicable for that company. |
79.3 K |
| HeadCountByMonth |
entity |
linktimelinespeaker_phone |
The headcount data by role (department) and level (profile). |
4.0 M |
| HeadCountByMonthByLevel |
entity |
linktimelinespeaker_phone |
Headcount data by month, broken down by level. History available since 2010. |
4.1 M |
| HeadCountByMonthByRoleDepartment |
entity |
linktimelinespeaker_phone |
Headcount data by month, broken down by role and department. History available since 2010. |
4.1 M |
| HeadCountByMonthBySubRoleUncons |
entity |
linktimelinespeaker_phone |
This table represents the headcount information for a given company broken down by sub-role, and on a by-month basis. This table does NOT contain historical data starting from 2010, but instead, history is built on a go-forward basis. |
397.8 K |
| HeadCountByNextEmployer |
entity |
linkspeaker_phone |
Headcount movement data from current company to next company by role and department. This table represents the movement of N number of employees from 'XYZ' role in a current company to the next company. |
72.8 M |
| HeadCountByNextEmployerLtm |
entity |
linkspeaker_phone |
Headcount movement data from current company to next company by role and department. This table represents the movement of N number of employees from 'XYZ' role in a current company to the next company over the last twelve months. |
273.3 K |
| HeadCountByPreviousEmployer |
entity |
linkspeaker_phone |
Headcount movement data from previous company to current company by role and department. This table represents the movement of N number of employees from a previous company into 'XYZ' role of the current company. |
74.9 M |
| HeadCountByPreviousEmployerLtm |
entity |
linkspeaker_phone |
Headcount movement data from previous company to current company by role and department. This table represents the movement of N number of employees from a previous company into 'XYZ' role of the current company over the last twelve months. |
88.8 K |
| HeadCountByState |
entity |
linkspeaker_phone |
The headcount data by state i.e. USA Only. |
3.4 M |
| HeadCountByStateUncons |
entity |
linkspeaker_phone |
The headcount data for a company by state i.e. USA Only. This is not aggregated as per the corporate structure applicable for that company. |
70.8 K |
| HeadCountByTerritory |
entity |
linkspeaker_phone |
The headcount data by territory. |
4.6 M |
| HeadCountByTerritoryUncons |
entity |
linkspeaker_phone |
The headcount data for a company by territory, not aggregated as per the corporate structure applicable for that company. |
802.0 K |
| HeadCountByTitle |
entity |
linkspeaker_phone |
Headcount data by job title. This table contains headcount values against job titles, which is also mapped to roles & sub-roles. Roles are also used in HeadCountByMonthByRoleDepartment table. Employee count values by role are aggregated from this data. |
76.3 M |
| HeadCountMonthly |
entity |
linktimelinespeaker_phone |
Headcount data by month, history available since 2010. |
4.1 M |
| HeadCountTenure |
entity |
linkspeaker_phone |
The average employee tenure by role or level at a given company. |
3.8 M |
| HeadcountCompany |
entity |
linktimelinespeaker_phone |
The headcount mapping with CiqCompanyId and KeyInstn. |
4.1 M |
| RoleType |
entity |
linkspeaker_phone |
Unique identifier for the type of role in a company. A single role encompasses multiple sub-roles. |
<1K |
| SubRoleType |
entity |
linkspeaker_phone |
Unique identifier for the type of sub-role in a company. |
<1K |