Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| CompanyCode | int | 4 | √ | null |
|
|
||
| Company | varchar | 100 | √ | null |
|
|
||
| EmployeeNumber | int | 4 | null |
|
|
|||
| EmployeeName | varchar | 150 | √ | null |
|
|
||
| JobCode | varchar | 50 | null |
|
|
|||
| Job | varchar | 100 | √ | null |
|
|
||
| EmployeeTypeCode | varchar | 50 | √ | null |
|
|
||
| EmployeeType | varchar | 50 | √ | null |
|
|
||
| FullPartTimeCode | varchar | 20 | √ | null |
|
|
||
| FulPartTime | varchar | 10 | √ | null |
|
|
||
| SalaryHourlyCode | varchar | 10 | √ | null |
|
|
||
| SalaryHourly | varchar | 20 | √ | null |
|
|
||
| EmployeeStatusCode | varchar | 10 | √ | null |
|
|
||
| EmployeeStatus | varchar | 10 | √ | null |
|
|
||
| OriginalHireDate | datetime | 16,3 | √ | null |
|
|
||
| LastHireDate | datetime | 16,3 | √ | null |
|
|
||
| EffectiveDate | datetime | 16,3 | null |
|
|
|||
| TerminationDate | datetime | 16,3 | √ | null |
|
|
||
| TerminationReasonCode | varchar | 20 | √ | null |
|
|
||
| TerminationReason | varchar | 100 | √ | null |
|
|
||
| TerminationTypeCode | varchar | 5 | √ | null |
|
|
||
| TerminationType | varchar | 20 | √ | null |
|
|
||
| JobChangeReasonCode | varchar | 20 | √ | null |
|
|
||
| JobChangeReason | varchar | 100 | √ | null |
|
|
||
| OKToRehire | varchar | 10 | √ | null |
|
|
||
| AgeYears | int | 4 | √ | null |
|
|
||
| GenderCode | varchar | 10 | √ | null |
|
|
||
| Gender | varchar | 20 | √ | null |
|
|
||
| SupervisorName | varchar | 150 | √ | null |
|
|
||
| SupervisorEmployeeNumber | varchar | 50 | √ | null |
|
|
||
| HireSourceCode | varchar | 20 | √ | null |
|
|
||
| HireSource | varchar | 100 | √ | null |
|
|
||
| PayGroupCode | int | 4 | √ | null |
|
|
||
| PayGroup | varchar | 50 | √ | null |
|
|
||
| ProjectCode | varchar | 20 | √ | null |
|
|
||
| Project | varchar | 150 | √ | null |
|
|
||
| OrgLevel1Code | varchar | 20 | √ | null |
|
|
||
| OrgLevel1 | varchar | 50 | √ | null |
|
|
||
| OrgLevel2Code | varchar | 20 | √ | null |
|
|
||
| OrgLevel2 | varchar | 50 | √ | null |
|
|
||
| OrgLevel3Code | varchar | 20 | √ | null |
|
|
||
| OrgLevel3 | varchar | 50 | √ | null |
|
|
||
| OrgLevel4Code | varchar | 20 | √ | null |
|
|
||
| OrgLevel4 | varchar | 50 | √ | null |
|
|
||
| NationalUnionCode | varchar | 50 | √ | null |
|
|
||
| NationalUnion | varchar | 50 | √ | null |
|
|
||
| LocalUnionCode | varchar | 50 | √ | null |
|
|
||
| LocalUnion | varchar | 50 | √ | null |
|
|
||
| EthnicCode | varchar | 10 | √ | null |
|
|
||
| Ethnicity | varchar | 50 | √ | null |
|
|