Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| CompanyCode | varchar | 255 | null |
|
|
|||||
| Company | varchar | 255 | null |
|
|
|||||
| EmployeeName_LastSuffix_FirstMI | varchar | 255 | null |
|
|
|||||
| EmployeeNumber | varchar | 255 | null |
|
|
|||||
| SSN_Unformatted | varchar | 255 | null |
|
|
|||||
| JobCode | varchar | 255 | null |
|
|
|||||
| Job | varchar | 255 | null |
|
|
|||||
| Job_Alternate | varchar | 255 | null |
|
|
|||||
| EmploymentTypeCode | varchar | 255 | null |
|
|
|||||
| EmploymentType | varchar | 255 | null |
|
|
|||||
| Salary_HourlyCode | varchar | 255 | null |
|
|
|||||
| Salary_Hourly | varchar | 255 | null |
|
|
|||||
| EmploymentStatusCode | varchar | 255 | null |
|
|
|||||
| EmploymentStatus | varchar | 255 | null |
|
|
|||||
| Full_PartTimeCode | varchar | 255 | null |
|
|
|||||
| Full_PartTime | varchar | 255 | null |
|
|
|||||
| BirthDate | datetime | 16,3 | null |
|
|
|||||
| OriginalHire | datetime | 16,3 | null |
|
|
|||||
| LastHire | datetime | 16,3 | null |
|
|
|||||
| TerminationDate | datetime | 16,3 | null |
|
|
|||||
| Age_Years | varchar | 255 | null |
|
|
|||||
| GenderCode | varchar | 255 | null |
|
|
|||||
| Gender | varchar | 255 | null |
|
|
|||||
| TerminationReasonCode | varchar | 255 | null |
|
|
|||||
| TerminationReason | varchar | 2147483647 | null |
|
|
|||||
| TerminationTypeCode | varchar | 255 | null |
|
|
|||||
| TerminationType | varchar | 2147483647 | null |
|
|
|||||
| EligibleToRehire | varchar | 2147483647 | null |
|
|
|||||
| SupervisorName_FirstMILastSuffix | varchar | 255 | null |
|
|
|||||
| SupervisorEmployeeNumber | varchar | 255 | null |
|
|
|||||
| HireSourceCode | varchar | 255 | null |
|
|
|||||
| HireSource | varchar | 255 | null |
|
|
|||||
| PayGroupCode | varchar | 255 | null |
|
|
|||||
| PayGroup | varchar | 255 | null |
|
|
|||||
| ProjectCode | varchar | 255 | null |
|
|
|||||
| Project | varchar | 255 | null |
|
|
|||||
| Orglevel1Code | varchar | 255 | null |
|
|
|||||
| Orglevel1 | varchar | 255 | null |
|
|
|||||
| Orglevel2Code | varchar | 255 | null |
|
|
|||||
| Orglevel2 | varchar | 255 | null |
|
|
|||||
| Orglevel3Code | varchar | 255 | null |
|
|
|||||
| Orglevel3 | varchar | 255 | null |
|
|
|||||
| Orglevel4Code | varchar | 255 | null |
|
|
|||||
| Orglevel4 | varchar | 255 | null |
|
|
|||||
| NationalUnionCode | varchar | 255 | null |
|
|
|||||
| NationalUnion | varchar | 255 | null |
|
|
|||||
| LocalUnionCode | varchar | 255 | null |
|
|
|||||
| LocalUnion | varchar | 255 | null |
|
|
|||||
| Ethnicity | varchar | 255 | null |
|
|
|||||
| Ref_Value | varchar | 200 | √ | null |
|
|
||||
| Insert_Date | datetime | 16,3 | √ | null |
|
|
||||
| Insert_User | varchar | 20 | √ | null |
|
|
||||
| Last_Update_Date | datetime | 16,3 | √ | null |
|
|
||||
| Last_Update_User | varchar | 20 | √ | null |
|
|
||||
| Delete_Ind | bit | 1 | √ | null |
|
|
||||
| Population_Information_Id | int | 4 | null |
|
|
|||||
| Source_System_Id | int | 4 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
