Employee_Hist

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Employee_Hist_Id int 4 null
Employee_Id int 4 null
Insert_Date datetime 16,3 null
Insert_User varchar 50 null
Last_Update_Date datetime 16,3 null
Last_Update_User varchar 50 null
Delete_Ind bit 1 √ null
Population_Information_Id int 4 null
Population_Information.Population_Information_id Implied ConstraintR
Source_System_Id int 4 √ null
Source_System.Source_System_id Implied ConstraintR
EmployeeType varchar 10 null
StartDate datetime 16,3 null
EndDate datetime 16,3 √ null
Rate money 21,4 √ null
RateType varchar 10 √ null
DriveTimeRate money 21,4 √ null
HoursPerWeek decimal 17,2 √ null
Company_ID int 4 √ null
IsExcludeLabor bit 1 null
PayForMileage bit 1 null
PayForNonPatientCare varchar 10 null
CreatedDate datetime 16,3 null
LaborBonusType varchar 10 null
LaborBonusRate money 21,4 null
LastModifiedDate datetime 16,3 null
Department_ID int 4 √ null
PerVisitRateSet_ID int 4 √ null
IsExcludeInvoicePayroll bit 1 null
ExemptFromOvertimePay bit 1 null

Relationships

Close relationships within degrees of separation