Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
TableID | int identity | 4 | √ | null |
|
|
||
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 | 5 | √ | 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 | datetime | 16,3 | √ | 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 |
|
|
||
CreatedDate | datetime | 16,3 | √ | (getdate()) |
|
|
||
Notes | varchar | 1000 | √ | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PK__PointInT__7D5F018E8FEFA2A7 | Primary key | Asc | TableID |
Diagram producer might be missing
No diagrams were produced please see application output for any errors