Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
CompanyCode | varchar | 25 | √ | null |
|
|
||
Company | varchar | 100 | √ | null |
|
|
||
EmployeeNumber | varchar | 25 | 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 | varchar | 25 | √ | null |
|
|
||
LastHireDate | varchar | 25 | √ | null |
|
|
||
EffectiveDate | varchar | 25 | √ | null |
|
|
||
TerminationDate | varchar | 25 | √ | 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 | varchar | 25 | √ | 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 | varchar | 25 | √ | 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 |
|
|
Diagram producer might be missing
No diagrams were produced please see application output for any errors