Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
TableID | int identity | 4 | √ | null |
|
|
||
PayGroup | varchar | 100 | √ | null |
|
|
||
CompanyCode | varchar | 20 | √ | null |
|
|
||
Company | varchar | 100 | √ | null |
|
|
||
OrgLevel1Code | varchar | 20 | √ | null |
|
|
||
OrgLevel1 | varchar | 100 | √ | null |
|
|
||
OrgLevel3Code | varchar | 20 | √ | null |
|
|
||
OrgLevel3 | varchar | 100 | √ | null |
|
|
||
LocationCode | varchar | 20 | √ | null |
|
|
||
LocationName | varchar | 100 | √ | null |
|
|
||
Location | varchar | 100 | √ | null |
|
|
||
ProjectCode | varchar | 20 | √ | null |
|
|
||
Project | varchar | 100 | √ | null |
|
|
||
EmployeeNumber | varchar | 20 | √ | null |
|
|
||
EmployeeName | varchar | 100 | √ | null |
|
|
||
JobCode | varchar | 20 | √ | null |
|
|
||
job | varchar | 100 | √ | null |
|
|
||
JobTitle | varchar | 100 | √ | null |
|
|
||
EmployeeType | varchar | 20 | √ | null |
|
|
||
SalaryorHourly | varchar | 20 | √ | null |
|
|
||
PayDate | date | 6 | √ | null |
|
|
||
CurrentHours | float | 8 | √ | null |
|
|
||
EarningsStub | varchar | 50 | √ | null |
|
|
||
CurrentAmount | float | 8 | √ | null |
|
|
||
CreatedDate | datetime | 16,3 | √ | (getdate()) |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PK__UltiPro___7D5F018EA6805B97 | Primary key | Asc | TableID |
Diagram producer might be missing
No diagrams were produced please see application output for any errors