Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| JobHistory_Id | int identity | 4 | null |
|
|
|||||
| PayGroup | varchar | 255 | √ | null |
|
|
||||
| EJHSystemId | varchar | 255 | null |
|
|
|||||
| OrgLevel3Code | varchar | 255 | √ | null |
|
|
||||
| OrgLevel3 | varchar | 255 | √ | null |
|
|
||||
| OrgLevel3Desc | varchar | 255 | √ | null |
|
|
||||
| EmployeeName | varchar | 255 | √ | null |
|
|
||||
| SSN_Unformatted | varchar | 10 | √ | null |
|
|
||||
| OriginalHireDate | datetime | 16,3 | √ | null |
|
|
||||
| LastHireDate | datetime | 16,3 | √ | null |
|
|
||||
| EmployeeStatus | varchar | 255 | √ | null |
|
|
||||
| Job | varchar | 255 | √ | null |
|
|
||||
| EmployeeType | varchar | 100 | √ | null |
|
|
||||
| EjhDateTimeCreated | datetime | 16,3 | √ | null |
|
|
||||
| EffectiveDate | datetime | 16,3 | √ | null |
|
|
||||
| HourlyPayRate | varchar | 255 | √ | null |
|
|
||||
| JobChangeReason | varchar | 255 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
