| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPHuman Resources |
| 1 | AHEM | Employees - History | 99 | PersGroup | Person Group | nVarChar | 5 | 0 | -1 | 101=Subject to Social Insurance, 102=Apprentice, 104=Home Worker, 105=Trainee, 106=Student, 108=Early Retirement, 109=Part-Time Employee, 110=Short-Term Employee, 112=Family Member: Agriculture, 113=Addnl Income: Agriculture, 114=Addnl Income: Seasonal Agriculture, 116=Receiving Compensation Pay, 118=Irregularly Employed, 119=Pensioner, 99 |
| 2 | OHEM | Employees | 99 | PersGroup | Person Group | nVarChar | 5 | 0 | -1 | 101=Subject to Social Insurance, 102=Apprentice, 104=Home Worker, 105=Trainee, 106=Student, 108=Early Retirement, 109=Part-Time Employee, 110=Short-Term Employee, 112=Family Member: Agriculture, 113=Addnl Income: Agriculture, 114=Addnl Income: Seasonal Agriculture, 116=Receiving Compensation Pay, 118=Irregularly Employed, 119=Pensioner, 99 |
