Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
EmployeeName | varchar | 255 | null |
|
|
|||
EmployeeNumber | varchar | 255 | null |
|
|
|||
SSN_Unformatted | varchar | 14 | null |
|
|
|||
EffectiveDate | datetime | 16,3 | null |
|
|
|||
CompanyCode | varchar | 255 | null |
|
|
|||
CompanyName | varchar | 255 | null |
|
|
|||
EmploymentStatusCode | varchar | 255 | null |
|
|
|||
Status | varchar | 255 | null |
|
|
|||
JobCode | varchar | 255 | null |
|
|
|||
JobDescription | varchar | 2147483647 | null |
|
|
|||
EmploymentTypeCode | varchar | 50 | null |
|
|
|||
EmploymentType | varchar | 2147483647 | null |
|
|
|||
Full_PartTimeCode | varchar | 5 | null |
|
|
|||
Full_PartTime | varchar | 255 | null |
|
|
|||
Hourly_SalariedCode | varchar | 5 | null |
|
|
|||
Hourly_Salaried | varchar | 255 | null |
|
|
|||
OrgLevel1Code | varchar | 20 | null |
|
|
|||
OrgLevel1 | varchar | 255 | null |
|
|
|||
OrgLevel2Code | varchar | 20 | null |
|
|
|||
OrgLevel2 | varchar | 255 | null |
|
|
|||
OrgLevel3Code | varchar | 20 | null |
|
|
|||
OrgLevel3 | varchar | 255 | null |
|
|
|||
OrgLevel4Code | varchar | 20 | null |
|
|
|||
OrgLevel4 | varchar | 255 | null |
|
|
|||
PayGroupCode | varchar | 50 | null |
|
|
|||
PayGroup | varchar | 255 | null |
|
|
|||
ProjectCode | varchar | 50 | null |
|
|
|||
Project | varchar | 255 | null |
|
|
|||
HireSourceCode | varchar | 50 | null |
|
|
|||
HireSource | varchar | 255 | null |
|
|
|||
BirthDate | datetime | 16,3 | null |
|
|
|||
OriginalHire | datetime | 16,3 | null |
|
|
|||
LastHireDate | datetime | 16,3 | null |
|
|
|||
GenderCode | varchar | 1 | null |
|
|
|||
Gender | varchar | 6 | null |
|
|
|||
Age_Years | varchar | 2 | null |
|
|
|||
Job_Alternate | varchar | 255 | null |
|
|
|||
SupervisorName_FirstMILastSuffix_History | varchar | 255 | null |
|
|
|||
SupervisorEmployeeNumber_History | varchar | 255 | null |
|
|
|||
LocalUnionCode | varchar | 50 | null |
|
|
|||
LocalUnion | varchar | 255 | null |
|
|
|||
NationalUnionCode | varchar | 50 | null |
|
|
|||
NationalUnion | varchar | 255 | null |
|
|
|||
Ethnicity | varchar | 255 | null |
|
|
|||
HeadcountMonth | datetime | 16,3 | null |
|
|
|||
TurnoverMonth | datetime | 16,3 | null |
|
|