Ultipro_EmployeeComp

73728 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Reporting_Date date 6 null
Company_Code int 4 √ null
Company nvarchar 200 √ null
Org_Level_1_Code_Division nvarchar 100 √ null
Org_Level_1 nvarchar 100 √ null
Org_Level_2_Code_Region nvarchar 100 √ null
Org_Level_2 nvarchar 100 √ null
Org_Level_3_Code_Company nvarchar 100 √ null
Org_Level_3_Company_Name nvarchar 200 √ null
Org_Level_4_Code_Department int 4 √ null
Org_Level_4_Department_Name nvarchar 200 √ null
Project_Code int 4 √ null
Project nvarchar 400 √ null
Pay_Group_Code int 4 √ null
Pay_Group nvarchar 100 √ null
Job_Code nvarchar 300 √ null
Job_Title nvarchar 400 √ null
Job_Alternate nvarchar 100 √ null
Employee_Name nvarchar 300 √ null
Employment_Status_Code nvarchar 100 √ null
Employment_Status nvarchar 100 √ null
Employee_Number varchar 50 null
Date_Of_Birth date 6 √ null
Original_Hire_Date date 6 √ null
Last_Hire_Date date 6 √ null
Supervisor_EmployeeNumber varchar 50 √ null
Supervisor_Name nvarchar 300 √ null
Employee_Type_Code nvarchar 100 √ null
Ethnic_Code nvarchar 100 √ null
Ethnicity nvarchar 100 √ null
Gender_Code nvarchar 100 √ null
Gender nvarchar 100 √ null
Hire_Source_Code nvarchar 100 √ null
Hire_Source nvarchar 300 √ null
Job_Family_Code nvarchar 100 √ null
Job_Family nvarchar 100 √ null
Job_Group_Code nvarchar 200 √ null
Job_Group nvarchar 200 √ null
Employee_Type nvarchar 100 √ null
Full_Part_Time_Code nvarchar 100 √ null
Deduction_Benefit_Group_Code nvarchar 100 √ null
Deduction_Benefit_Group nvarchar 200 √ null
SalaryHourly_Code nvarchar 100 √ null
SalaryHourly nvarchar 100 √ 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 nvarchar 2000 √ null
Age float 8 √ null
Age_Years int 4 √ null
Employee_EducationYear nvarchar 100 √ null
Employee_EducationDiscipline nvarchar 200 √ null
Current_Performance_Rating nvarchar 200 √ null
Current_Potential_Rating nvarchar 200 √ null
Current_Performance_Notes nvarchar 2000 √ null
Advancement_Notes nvarchar 2000 √ null
CreatedDate datetime 16,3 √ (getdate())

Indexes

Constraint Name Type Sort Column(s)
PK_EmployeeNumber_ReportingDate Primary key Asc/Asc Employee_Number + Reporting_Date

Diagram producer might be missing

No diagrams were produced please see application output for any errors