Dimensions

Dimension Description Subject area

Is Archived

 Shows if the team is archived Common
Department Description Description of the department. Departments are stored under teams in Infor Workforce Management. Common
Department ID ID of the department Common
Department Name Name of the department. Departments are stored under teams in Infor Workforce Management. Common
Department Flag1 Department Flag 1 Common
Department Flag2 Department Flag 2 Common
Department Flag3 Department Flag 3 Common
Department Flag4 Department Flag 4 Common
Department Flag5 Department Flag 5 Common
Department Val1 Department Val 1 Common
Department Val2 Department Val 2 Common
Department Val3 Department Val 3 Common
Department Val4 Department Val 4 Common
Department Val5 Department Val 5 Common
Department ID Unique ID associated with a department Common
Department Name Name of the department Common
Docket ID

Employee production quantity. These measurements include standard quantity, standard time, machine parts, and part numbers.

Dockets are often tracked within incentive payout production monitoring systems. The Distinct ID of that document is the Docket ID.

 Common
Employee Default Labor ID Unique ID associated with an employee Common
Employee Default Labor Percentage Employee default labor percentage Common
Employee ID Unique ID associated with an employee Common
Hour Type ID Name of the hour type. Hour types are used to classify the pay category and the multiple that should be applied to a period. For example, UNPAID refers to the unpaid category and REG refers to the regular pay. Other valid types are OT1, OT2, OT3, and OTS. Common
Job ID Unique ID of a job Common
Project ID Unique ID of a project Common
Project Name Name of the project Common
Time Code ID Time codes, also known as earnings codes or pay codes, are used to classify the extent of time an employee is scheduled to work. Each period is represented by a different time code and defines whether an employee was working, not working or absent. The code value of 1 or 0. Common
Employee Default Labor Flag1 Employee default labor flag 1 Common
Employee Default Labor Flag2 Employee default labor flag 2 Common
Employee Default Labor Flag3 Employee default labor flag 3 Common
Employee Default Labor Flag4 Employee default labor flag 4 Common
Employee Default Labor Flag5 Employee default labor flag 5 Common

Employee Default Labor Flag6

 Employee default labor flag 6 Common
Employee Default Labor Flag7 Employee default labor flag 7 Common
Employee Default Labor Flag8 Employee default labor flag 8 Common
Employee Default Labor Flag9 Employee default labor flag 9 Common
Employee Default Labor Flag10 Employee default labor flag 10 Common
Employee Default Labor Udf1 Employee Default Labor Udf 1 Common
Employee Default Labor Udf2 Employee Default Labor Udf 2 Common
Employee Default Labor Udf3 Employee Default Labor Udf 3 Common
Employee Default Labor Udf4 Employee Default Labor Udf 4 Common
Employee Default Labor Udf5 Employee Default Labor Udf 5 Common
Employee Default Labor Udf6 Employee Default Labor Udf 6 Common
Employee Default Labor Udf7 Employee Default Labor Udf 7 Common
Employee Default Labor Udf8 Employee Default Labor Udf 8 Common
Employee Default Labor Udf9 Employee Default Labor Udf 9 Common
Employee Default Labor Udf10 Employee Default Labor Udf 10 Common
Employee Availability Shows if the employee is available for the task Common
Employee Birth Date Birth date of the employee Common
Employee Day Start Time Time of day an employee begins the work Common
Employee Default Minutes Minimum amount of time an employee needs to work in a workday Common
Employee Effective Date Date when the employee starts working on the assigned project Common
Employee First Name First name of the employee Common
Employee FTE Fulltime equivalency or FTE of the employees to the snapshot date Common
Employee Full Name Full name of the employee Common
Employee Full Time Shows whether the employee is a full-time employee of the organization Common
Employee Hire Date Date when the employee was hired in the organization Common
Employee History End Date Date when the employee is terminated from the organization. 01/01/3000 is shown as the default date. Common
Employee History Start Date Date when the employee was hired in the organization Common
Employee ID Employee unique ID Common
Employee Last Name Last name of the employee Common
Employee Pending Shows if tasks are pending for the employee. By default, this attribute is set to Not Pending. Common
Employee Seniority Date Date for which the employee first joined the organization Common
Employee Seniority Number Total number of years the employee has been in the organization Common
Employee Shift Pattern Offset Common
Employee Status Shows if the employee status is active Common
Employee System Scheduled Enabled Shows if the employee is automatically scheduled by the system. By default, an employee is assigned to system scheduling. Common
Employee Termination Date Date when the employee is terminated from the organization Common
FTE Group FTE group where the employee belongs Common
Length of Service at Termination Average length of service until the termination date analyzed by termination date Common
Length of Service at Termination Group Average length of service until the termination date by group analyzed by termination date Common
Employee Flag1 Employee Flag 1 Common
Employee Flag2 Employee Flag 2 Common
Employee Flag3 Employee Flag 3 Common
Employee Flag4 Employee Flag 4 Common
Employee Flag5 Employee Flag 5 Common
Employee Flag6 Employee Flag 6 Common
Employee Flag7 Employee Flag 7 Common
Employee Flag8 Employee Flag 8 Common
Employee Flag9 Employee Flag 9 Common
Employee Flag10 Employee Flag 10 Common
Employee Flag11 Employee Flag 11 Common
Employee Flag12 Employee Flag 12 Common
Employee Flag13 Employee Flag 13 Common
Employee Flag14 Employee Flag 14 Common
Employee Flag15 Employee Flag 15 Common
Employee Flag16 Employee Flag 16 Common
Employee Flag17 Employee Flag 17 Common
Employee Flag18 Employee Flag 18 Common
Employee Flag19 Employee Flag 19 Common
Employee Flag20 Employee Flag20 Common
Employee Val1 Employee Val 1 Common
Employee Val2 Employee Val 2 Common
Employee Val3 Employee Val 3 Common
Employee Val4 Employee Val 4 Common
Employee Val5 Employee Val 5 Common
Employee Val6 Employee Val 6 Common
Employee Val7 Employee Val 7 Common
Employee Val8 Employee Val 8 Common
Employee Val9 Employee Val 9 Common
Employee Val10 Employee Val 10 Common
Employee Val11 Employee Val 11 Common
Employee Val12 Employee Val 12 Common
Employee Val13 Employee Val 13 Common
Employee Val14 Employee Val 14 Common
Employee Val15 Employee Val 15 Common
Employee Val16 Employee Val 16 Common
Employee Val17 Employee Val 17 Common
Employee Val18 Employee Val 18 Common
Employee Val19 Employee Val 19 Common
Employee Val20 Employee Val 20 Common
Length of Service Tenure of the employee in the organization in months Common
Length of Service Group Tenure range of the employee. For example, for 24 months, the employee falls in the range of 21-25. Common
Seniority Tenure of the employee in months based on the hire date Common
Seniority Group Month range of the tenure of the employee in the organization Common
Snapshot Date Date when the record was last updated Common
Employee Job End Date Date when the employee leaves the job. By default, the end date is set to 01/01/3000 for employees who are still working in the organization. Common
Employee Job Preferred Shows if the job is preferred by the employee Common
Employee Job Rank Job ranking is a method used by organizations to assign a value or importance to each job within the company. This helps establish salary levels, career advancement opportunities, and overall organizational structure Common
Employee Job Rate Index Common
Employee Job Start Date Date when the employee started the job Common
Job Description Description of the job Common
Job Name Name of the job Common
Employee Job Flag1 Employee Job Flag 1 Common
Employee Job Flag2 Employee Job Flag 2 Common
Employee Job Flag3 Employee Job Flag 3 Common
Employee Job Flag4 Employee Job Flag 4 Common
Employee Job Flag5 Employee Job Flag 5 Common
Employee Job Udf1 Employee Job Udf 1 Common
Employee Job Udf2 Employee Job Udf 2 Common
Employee Job Udf3 Employee Job Udf3 Common
Employee Job Udf4 Employee Job Udf4 Common
Employee Job Udf5 Employee Job Udf5 Common
Employee Team End Date Date when the team will be dissolved or no longer needed. By default, the value is set to 01/01/3000. Common
Employee Team Is Archived Shows if the employee team is archived Common
Employee Team Start Date Date when the employee team was formed Common
Employee Team System Generated Shows if the team is system generated Common
Team Description Description of the team Common
Team Name Name of the team Common
Employee Team Flag1 Employee Team Flag 1 Common
Employee Team Flag2 Employee Team Flag 2 Common
Employee Team Flag3 Employee Team Flag 3 Common
Employee Team Flag4 Employee Team Flag 4 Common
Employee Team Flag5 Employee Team Flag 5 Common
Employee Team Udf1 Employee Team Udf 1 Common
Employee Team Udf2 Employee Team Udf 2 Common
Employee Team Udf3 Employee Team Udf 3 Common
Employee Team Udf4 Employee Team Udf 4 Common
Employee Team Udf5 Employee Team Udf 5 Common
Employee Work Type Description Work type description of the employee such as full time or part time Common
Employee Work Type Full Time Shows if the employee works full time in the organization Common
Employee Work Type Name Work type name of the employee such as full time or part time Common
Employee Work Type Pay Type Code Pay code of the employee Common
Employee Work Type Sort Order Order in which the employee work type is sorted Common
Employee Work Type Flag1 Employee Work Type Flag 1 Common
Employee Work Type Flag2 Employee Work Type Flag 2 Common
Employee Work Type Flag3 Employee Work Type Flag 3 Common
Employee Work Type Flag4 Employee Work Type Flag 4 Common
Employee Work Type Flag5 Employee Work Type Flag 5 Common
Employee Work Type Flag6 Employee Work Type Flag 6 Common
Employee Work Type Flag7 Employee Work Type Flag 7 Common
Employee Work Type Flag8 Employee Work Type Flag 8 Common
Employee Work Type Flag9 Employee Work Type Flag 9 Common
Employee Work Type Flag10 Employee Work Type Flag 10 Common
Employment Type Description Description of the employment type of an employee Common
Employment Type Name Name of the employment type of an employee. For example, Seasonal, Contractor, Intern, or Trainee. Common
Employment Type Sort Order Order in which the employment type is sorted Common
Employment Type Flag1 Employment Type Flag 1 Common
Employment Type Flag2 Employment Type Flag 2 Common
Employment Type Flag3 Employment Type Flag 3 Common
Employment Type Flag4 Employment Type Flag 4 Common
Employment Type Flag5 Employment Type Flag 5 Common
Employment Type Udf1 Employment Type Udf 1 Common
Employment Type Udf2 Employment Type Udf 2 Common
Employment Type Udf3 Employment Type Udf 3 Common
Employment Type Udf4 Employment Type Udf 4 Common
Employment Type Udf5 Employment Type Udf 5 Common
Job Code Job code defined for the position Common
Job Description Description of the job Common
Job Exclude From Qualify List of jobs excluded to be qualified Common
Job Inferred Tip Tip amount associated to a job Common
Job Name Name of the job Common
Job Preference Key Holder Unique identifier for a job preference Common
Job Report Health Care Type Health care type of a job Common
Job Shift Offset Job name that is used to compensate for another job Common
Job Tip Tip that is associated with a job Common
Job Tip Calculation Shows how the tip is calculated for a job Common
Job Title Code Job title code for the position Common
Job Unauthorized Shows if the job is authorized Common
Job Flag1 Job Flag 1 Common
Job Flag2 Job Flag 2 Common
Job Flag3 Job Flag 3 Common
Job Flag4 Job Flag 4 Common
Job Flag5 Job Flag 5 Common
Job Val1 Job Val 1 Common
Job Val2 Job Val 2 Common
Job Val3 Job Val 3 Common
Job Val4 Job Val 4 Common
Job Val5 Job Val 5 Common
Job Val6 Job Val 6 Common
Job Val7 Job Val 7 Common
Job Val8 Job Val 8 Common
Job Val9 Job Val 9 Common
Job Val10 Job Val 10 Common
Last Load Date Date the data load was done on Birst Common
Last Update Date when Birst was last updated Common
Hier Depth Depth of hierarchy in the organization Common
Hier Max Depth The maximum depth of hierarchy of a team in the organization. By default, the value is set to 8. Common
Parent Team Description Functionality of the parent or home team. For example, RECEIVING team is the central receiving department. Common
Parent Team ID ID of the parent or home team Common
Parent Team Level Parent team hierarchy in the organization Common
Parent Team Name Name of the parent or home team Common
Team Description Functionality of the team. For example, RECEIVING team is the central receiving department. Common
Team ID ID of the team Common
Team Level Team hierarchy in the organization Common
Team Level 1 ID Level where the team is associated with the unique ID 1 Common
Team Level 1 Name Name of the team level 1 Common
Team Level 2 ID Level where the team is associated with the unique ID 2 Common
Team Level 2 Name Name of the team level 2 Common
Team Level 3 ID Level where the team is associated with the unique ID 3 Common
Team Level 3 Name Name of the team level 3 Common
Team Level 4 ID Level where the team is associated with the unique ID 4 Common
Team Level 4 Name Name of the team level 4 Common
Team Level 5 ID Level where the team is associated with the unique ID 5 Common
Team Level 5 Name Name of the team level 5 Common
Team Level 6 ID Level where the team is associated with the unique ID 6 Common
Team Level 6 Name Name of the team level 6 Common
Team Level 7 ID Level where the team is associated with the unique ID 7 Common
Team Level 7 Name Name of the team level 7 Common
Team Level 8 ID Level where the team is associated with the unique ID 8 Common
Team Level 8 Name Name of the team level 8 Common
Team Level 9 ID Level where the team is associated with the unique ID 9 Common
Team Level 9 Name Name of the team level 9 Common
Team Level 10 ID Level where the team is associated with the unique ID 10 Common
Team Level 10 Name Name of the team level 10 Common
Team Name Name of the team Common
Team Type ID Child team type ID Common
Date A calendar date is a reference to a particular day represented within a calendar system. The calendar date allows the specific day to be identified. The number of days between two dates can be calculated. For example, "25 June 2024" is ten days after "15 June 2024" Common
Day Day of the week Common
Day Number Day number in the year that corresponds with the order of that day in sequence Common
Day of Month Day of the month Common
Day of Week Day of the week Common
Day of Week in Month Day of the week in a month Common
Day of Year Day of the year Common
Day Seq Number Unique number assigned to a day Common
Days Ago Historical or past days Common
Month Month of the year Common
Month Number Month number of the year Common
Month of Year Month of the year Common
Month Seq Number Unique number assigned to a month Common
Months Ago Historical or past months Common
Num Weeks In Month Number of weeks in a month Common
Quarter Quarter of the year Common
Quarter Number Quarter number of the year Common
Quarter Seq Number Unique number assigned to a quarter Common
Trailing 3 Month Name Trailing 3 month name Common
Week End Date Defined week end date Common
Week Number Week number of the year Common
Week of Month Week of the month Common
Week of Year Week of the year Common
Week Seq Number Unique number assigned to a week Common
Week Start Date Defined week start date Common
Weeks Ago Historical or past weeks Common
Year Year Common
Year Seq Number Unique number assigned to a year Common
Year/Month Month in a given year Common
Year/Quarter Quarter in a given year Common