Table column information

Unique identifier of the benefit component offered to the employee.

Cost of the benefit component per employee per quarter paid by the employer.

Cost of the benefit component per quarter paid by the employee.

Unique identifier of individual working for the company.

Number of participants per employee. The minimum value for this field is 1.

Unique identifier for the quarter. This is a time hierarchy table. The default format for the quarter id is YYYYQ and is stored as an integer.

Annual salary specific to an employee in a certain year.

Bonus potential specific to an employee in a certain year.

Unique identifier of individual working for the company.

Unique identifier for the year. This is a time hierarchy table. The default format for the year id is YYYY and is stored as an integer.

Compensation amount monthly paid to the employee.

Unique identifier of the compensation type or item

Unique identifier of individual working for the company.

Unique identifier for the month. This is a time hierarchy table. The default format for the month id is YYYYMM and is stored as an integer.

Identifies whether a department transfer occurred for an employee.

Unique identifier of the department where the employees work.

Unique identifier of the office location of employees.

Unique identifier of the employee status.

Unique identifier of an individual working for the company.

Unique identifier of the previous departments of the employees.

Unique identifier of the previous locations of employees.

Identifies whether a transfer of location occurred for an employee.

Unique identifier for the month. This is a time dimension table. The default format for the month id is YYYYMM and is stored as an integer.

Stores the months of seniority for each employee.

Unique identifier of the employee's level.

Indicates the mode of the industry or market standard salary for every employee level.

Maximum salary given to a specific level of employee.

Minimum salary given to a specific level of employee.

Unique identifier for the year. This is a time hierarchy table. The default format for the year id is YYYY and is stored as an integer.

Tracks all the dates in the system. All valid calendar dates for reporting purposes will have to be defined here.

Unique identifier of individual working for the company.

Unique identifier of the employee's qualifications.

Level or score assigned to an employee with a specific qualification.

Unique identifier of an individual working for the company.

Number of extra hours worked per employee per month. Value is obtained by multiplying the number of effective extra hours worked by a chosen coefficient.

Unique identifier for the month. This is a time hierarchy table. The default format for the month id is YYYYMM and is stored as an integer.

Performance score assigned to the employee.

Unique identifier of an individual working for the company.

Unique identifier for the year. This is a time dimension table. The default format for the year id is YYYY and is stored as an integer.

Unique identifier of the department where employees work.

Unique identifier of the office location of employees.

Amount planned for employee compensations.

Target number of employees.

Unique identifier for the quarter. This is a time dimension table. The default format for the quarter id is YYYYQ and is stored as an integer.

Unique identifier of the job.

Unique identifier for the month. This is a time hierarchy table. The default format for the month id is YYYYMM and is stored as an integer.

Number of accepted offers.

Number of interviewed candidates per position.

Number of received resumes per position.

Number of rejected offers.

Number of offers sent per position.

Unique identifier of the department to which the employee belongs.

Satisfaction score by survey fields, year and department.

Number of returned surveys. For every returned survey, the number 1 is entered.

Unique identifier of the survey field.

Unique identifier for the year. This is a time hierarchy table. The default format for the year id is YYYY and is stored as an integer.

Sequential key not used in the project, to ensure no duplicate rows in the table.

Unique identifier of individuals working for the company.

Total number of days accrued by the employee. This number can be calculated by multiplying the employee tenure with a company-specific value.

Total number of days used by the employee.

Unique identifier of the type of time off.

Unique identifier for the month. This is a time hierarchy table. The default format for the month id is YYYYMM and is stored as an integer.

Target number of employees.

Textual description of the benefit component offered to the employee.

Unique identifier of the benefit component offered to the employee.

Unique identifier of the type of benefit offered to the employee.

Textual description of the type of benefit offered to the employee.

Unique identifier of the type of benefit offered to the employee.

Tracks all the dates in the system. All valid calendar dates for reporting purposes must be defined here.

Unique identifier for the month. This is a time hierarchy table. The default format for the month id is YYYYMM and is stored as an integer.

Unique identifier for the quarter. This is a time hierarchy table. The default format for the quarter id is YYYYQ and is stored as an integer.

Unique identifier for the year. This is a time hierarchy table. The default format for the year id is YYYY and is stored as an integer.

ID of the previous month. For example, for December 2003 it is November 2003. This is stored in the same format as the MONTH_ID (YYYYMM).

Textual description of the month.

Unique identifier for the month. This is a time hierarchy table. The default format for the month id is YYYYMM and is stored as an integer.

Unique identifier for the quarter. This is a time hierarchy table. The default format for the quarter id is YYYYQ and is stored as an integer.

Unique identifier for the year. This is a time hierarchy table. The default format for the year id is YYYY and is stored as an integer.

ID of the previous quarter. For example, for Q4 2003 it is Q3 2003. This is stored in the same format as the QTR_ID (YYYYQ).

Textual description of the quarter.

Unique identifier for the quarter. This is a time hierarchy table. The default format for the quarter id is YYYYQ and is stored as an integer.

Unique identifier for the year. This is a time hierarchy table. The default format for the year id is YYYY and is stored as an integer.

The id of the previous year. For example, for 2003 it is 2002. This is stored in the same format as the YEAR_ID (YYYY).

Unique identifier for the year. This is a time hierarchy table. The default format for the year id is YYYY and is stored as an integer.

Textual description of the compensation type.

Unique identifier of the compensation type or item.

Flag indicating whether the contract is active or not.

Department where the contractor is working.

Location where the contractor is working.

Job title of the contractor.

Date on which the contract ended or will end.

Date on which the contract starts.

Textual description or name of the contractor.

Unique identifier of the individual or company working as contractor.

Salary rate of the contractor as $/h.

Textual description of the employee's age range.

Unique identifier of the employee's age range.

Textual description of the level of security clearance of the employee.

Unique identifier of the level of security clearance of the employee.

Textual description of the employee's degree type.

Unique identifier of the employee's degree type.

Textual description of the employee's division.

Unique identifier of the employee's division.

Textual description of the employee's department.

Unique identifier of the employee's department.

Unique identifier of the employee's division.

Textual description of the employee's education.

Unique identifier of the employee's education.

Textual description of the employee's ethnicity.

Unique identifier of the employee's ethnicity.

Textual description of the employee's gender.

Unique identifier of the employee's gender.

Textual description of the employee's immigration status.

Unique identifier of the employee's immigration status.

Textual description of the employee's level.

Unique identifier of the employee's level.

Textual description of the employee's office location.

Unique identifier of the employee's office location.

Unique identifier of the employee's region.

Textual description of the employee's minority group.

Unique identifier for the employee's minority group.

Textual description of the employee's marital status.

Unique identifier of the employee's marital status.

Textual description of the employee's nationality.

Unique identifier of the employee's nationality.

Textual description of the employee's position status

Unique identifier of the employee's position status.

Textual description of the employee's region.

Unique identifier of the employee's region.

Textual description of the employee's status.

Unique identifier of the employee's status.

Textual description of the nature of work or level of the employee.

Unique identifier of the nature of work or level of the employee.

Employee's date of birth.

Unique identifier of the employee's level of security clearance.

Unique identifier of the employee's current status.

Unique identifier of the employee's department.

1 for full-time employees; greater than 0 and less than 1 for part-time employees.

Employee's identification number.

Unique identifier of the employee's immigration status.

Unique identifier of the employee's level.

Unique identifier of the employee's office location.

Unique identifier for the employee's minority group.

Unique identifier of the employee's position status.

Unique identifier of the nature of work or level of the employee.

Years of employee's work experience, prior to her/his hire in the current company. Eventually, only years of related job experience can be tracked in this field.

Textual description or name of individual working for the company.

Unique identifier of the individual working for the company.

Indicates whether employee is exempt or not.

Date of hire of the employee.

Date on which the employee left the company.

Unique identifier of the reasons for departure.

Unique identifier for the recruiting source used to hire employees.

Unique identifier of the employee's supervisor.

Textual description of the reasons for closing a job search.

Unique identifier of the reason for closing a job search.

Mapped to the employee ID that closed the job opening by internal transfer.

Mapped to the employee ID that caused the job opening by internal transfer.

Level of clearance required by the specific job.

Date on which job associated with the vacant position was filled.

Unique identifier of the reason for closing a job search.

Unique identifier of the job.

Department in which the specific job is available.

Location where the specific job is available.

Day in which a vacant position was assigned a job code and the recruitment process began.

Unique identifier of the reason for starting a job search.

Number of years of experience required to fill the specific job.

Unique identifier of the job position in the company.

Textual description of the reasons for starting a job search.

Unique identifier of the reason for starting a job search.

Textual description of the reasons for departure.

Unique identifier of the reasons for departure.

Textual description of job positions in the company.

Unique identifier of job positions in the company.

Textual description of employee's qualifications.

Unique identifier of employee's qualifications.

Unique identifier of employee's qualification types.

Textual description of employee's qualification types.

Unique identifier of employee's qualification types.

Textual description for the recruiting source used to hire employees.

Unique identifier for the recruiting source used to hire employees.

Textual description of the survey field.

Unique identifier of the survey field.

Textual description of the type of time off.

Unique identifier of the type of time off.

Employee's city home address.

Employee's country.

Employee's home phone number.

Employee's state home address.

Employee's street home address.

Employee's home address ZIP code.

Unique identifier of individual working for the company.

Unique identifier of the employee's age range.

Unique identifier of the employee's degree type.

Unique identifier of employee's education.

Unique identifier of the employee's ethnicity.

Unique identifier of the employee's gender.

Unique identifier of the employee's marital status.

Unique identifier of the employee's nationality.