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 |
|
|