Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
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 |
|
|
||
SSN | varchar | 20 | √ | null |
|
|
||
EmployeeNumber | varchar | 20 | √ | null |
|
|
||
EmployeeName | varchar | 100 | √ | null |
|
|
||
PositionCode | varchar | 20 | √ | null |
|
|
||
Position | varchar | 100 | √ | null |
|
|
||
JobTitle | varchar | 100 | √ | null |
|
|
||
EmployeeType | varchar | 20 | √ | null |
|
|
||
SalaryorHourly | varchar | 20 | √ | null |
|
|
||
PayDate | date | 6 | √ | null |
|
|
||
CurrentHours | varchar | 20 | √ | null |
|
|
||
EarningsStub | varchar | 50 | √ | null |
|
|
||
CurrentAmount | varchar | 20 | √ | null |
|
|
Diagram producer might be missing
No diagrams were produced please see application output for any errors