Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| CompanyCode | int | 4 | √ | null |
|
|
||
| CompanyName | varchar | 50 | √ | null |
|
|
||
| EmployeeNumber | varchar | 10 | √ | null |
|
|
||
| EmployeeName | varchar | 100 | √ | null |
|
|
||
| JobCode | varchar | 50 | √ | null |
|
|
||
| JobTitle | varchar | 100 | √ | null |
|
|
||
| JobAlt | varchar | 50 | √ | null |
|
|
||
| EmployeeTypeCode | varchar | 20 | √ | null |
|
|
||
| EmployeeType | varchar | 50 | √ | null |
|
|
||
| Salary_HourlyCode | varchar | 5 | √ | null |
|
|
||
| Salary_Hourly | varchar | 20 | √ | null |
|
|
||
| EmploymentStatusCode | varchar | 5 | √ | null |
|
|
||
| EmployeeStatus | varchar | 20 | √ | null |
|
|
||
| Full_PartTimeCode | varchar | 5 | √ | null |
|
|
||
| Full_PartTime | varchar | 20 | √ | null |
|
|
||
| OriginalHireDate | date | 6 | √ | null |
|
|
||
| LastHireDate | date | 6 | √ | null |
|
|
||
| EffectiveDate | date | 6 | √ | null |
|
|
||
| TerminationDate | date | 6 | √ | null |
|
|
||
| Age | int | 4 | √ | null |
|
|
||
| GenderCode | varchar | 5 | √ | null |
|
|
||
| Gender | varchar | 20 | √ | null |
|
|
||
| JobChangeReasonCode | varchar | 20 | √ | null |
|
|
||
| JobChangeReason | varchar | 50 | √ | null |
|
|
||
| TerminationTypeCode | varchar | 5 | √ | null |
|
|
||
| TerminationType | varchar | 20 | √ | null |
|
|
||
| OKtoRehire | varchar | 100 | √ | null |
|
|
||
| SupervisorName | varchar | 100 | √ | null |
|
|
||
| SuperVisor_EmployeeNumber | varchar | 10 | √ | null |
|
|
||
| HireSourceCode | varchar | 50 | √ | null |
|
|
||
| HireSource | varchar | 50 | √ | null |
|
|
||
| PayGroupCode | varchar | 20 | √ | null |
|
|
||
| PayGroup | varchar | 20 | √ | null |
|
|
||
| ProjectCode | varchar | 20 | √ | null |
|
|
||
| Project | varchar | 50 | √ | 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 | 20 | √ | null |
|
|
||
| NationalUnion | varchar | 50 | √ | null |
|
|
||
| LocalUnionCode | varchar | 20 | √ | null |
|
|
||
| LocalUnion | varchar | 50 | √ | null |
|
|
||
| Ethnicity | varchar | 20 | √ | null |
|
|
||
| ActionTakenDate_Time | varchar | 100 | √ | null |
|
|
||
| FieldUpdated | varchar | 20 | √ | null |
|
|
||
| OldValue | varchar | 50 | √ | null |
|
|
||
| OldValueDescription | varchar | 50 | √ | null |
|
|
||
| NewValue | varchar | 50 | √ | null |
|
|
||
| NewValueDescription | varchar | 50 | √ | null |
|
|
||
| UserName | varchar | 50 | √ | null |
|
|
||
| TermiationReasonCodeOld | varchar | 20 | √ | null |
|
|
||
| TerminationReasonOld | varchar | 50 | √ | null |
|
|
||
| Notes | varchar | 1000 | √ | null |
|
|
Diagram producer might be missing
No diagrams were produced please see application output for any errors