Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
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 |
|
|
|||||
Source_System_Id | int | 4 | √ | null |
|
|
||||
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 |
|
|