Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| Reporting_date | date | 6 | √ | null |
|
|
||
| Company_Code | varchar | 50 | √ | null |
|
|
||
| Company | varchar | 100 | √ | null |
|
|
||
| Org_Level_1_Code_Division | varchar | 50 | √ | null |
|
|
||
| Org_Level_1 | varchar | 50 | √ | null |
|
|
||
| Org_Level_2_Code_Region | varchar | 50 | √ | null |
|
|
||
| Org_Level_2 | varchar | 50 | √ | null |
|
|
||
| Org_Level_3_Code_Company | varchar | 50 | √ | null |
|
|
||
| Org_Level_3_Company_Name | varchar | 100 | √ | null |
|
|
||
| Org_Level_4_Code_Department | varchar | 50 | √ | null |
|
|
||
| Org_Level_4_Department_Name | varchar | 100 | √ | null |
|
|
||
| Project_Code | varchar | 50 | √ | null |
|
|
||
| Project | varchar | 200 | √ | null |
|
|
||
| Pay_Group_Code | varchar | 50 | √ | null |
|
|
||
| Pay_Group | varchar | 50 | √ | null |
|
|
||
| Job_Code | varchar | 150 | √ | null |
|
|
||
| Job_Title | varchar | 200 | √ | null |
|
|
||
| Job_Alternate | varchar | 50 | √ | null |
|
|
||
| Employee_Name | varchar | 150 | √ | null |
|
|
||
| Employment_Status_Code | varchar | 50 | √ | null |
|
|
||
| Employment_Status | varchar | 50 | √ | null |
|
|
||
| Employee_Number | varchar | 50 | null |
|
|
|||
| Date_Of_Birth | varchar | 50 | √ | null |
|
|
||
| Original_Hire_Date | varchar | 50 | √ | null |
|
|
||
| Last_Hire_Date | varchar | 50 | √ | null |
|
|
||
| Supervisor_EmployeeNumber | int | 4 | √ | null |
|
|
||
| Supervisor_Name | varchar | 150 | √ | null |
|
|
||
| Employee_Type_Code | varchar | 50 | √ | null |
|
|
||
| Ethnic_Code | varchar | 50 | √ | null |
|
|
||
| Ethnicity | varchar | 50 | √ | null |
|
|
||
| Gender_Code | varchar | 50 | √ | null |
|
|
||
| Gender | varchar | 50 | √ | null |
|
|
||
| Hire_Source_Code | varchar | 50 | √ | null |
|
|
||
| Hire_Source | varchar | 150 | √ | null |
|
|
||
| Job_Family_Code | varchar | 50 | √ | null |
|
|
||
| Job_Family | varchar | 50 | √ | null |
|
|
||
| Job_Group_Code | varchar | 100 | √ | null |
|
|
||
| Job_Group | varchar | 100 | √ | null |
|
|
||
| Employee_Type | varchar | 50 | √ | null |
|
|
||
| Full_Part_Time_Code | varchar | 50 | √ | null |
|
|
||
| Deduction_Benefit_Group_Code | varchar | 50 | √ | null |
|
|
||
| Deduction_Benefit_Group | varchar | 100 | √ | null |
|
|
||
| SalaryHourly_Code | varchar | 50 | √ | null |
|
|
||
| SalaryHourly | varchar | 50 | √ | null |
|
|
||
| Annual_Salary | float | 8 | √ | null |
|
|
||
| Hourly_Pay_Rate | float | 8 | √ | null |
|
|
||
| Other_Rate_1 | float | 8 | √ | null |
|
|
||
| Other_Rate_2 | float | 8 | √ | null |
|
|
||
| Other_Rate_3 | float | 8 | √ | null |
|
|
||
| Other_Rate_4 | float | 8 | √ | null |
|
|
||
| Key_Employee | varchar | 1000 | √ | null |
|
|
||
| Age | varchar | 50 | √ | null |
|
|
||
| Age_Years | varchar | 50 | √ | null |
|
|
||
| Employee_EducationYear | varchar | 50 | √ | null |
|
|
||
| Employee_EducationDiscipline | varchar | 100 | √ | null |
|
|
||
| Current_Performance_Rating | varchar | 100 | √ | null |
|
|
||
| Current_Potential_Rating | varchar | 100 | √ | null |
|
|
||
| Current_Performance_Notes | varchar | 1000 | √ | null |
|
|
||
| Advancement_Notes | varchar | 1000 | √ | null |
|
|
Diagram producer might be missing
No diagrams were produced please see application output for any errors