| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPPublic Sector |
1 | T5PBSR6A | Scheme of Services | 3 | SHCOD | Scheme Code. E.g. Super Scale, Time Scale etc. | nvarchar | 2 | 0 | | |
2 | T5PBSR6AT | Text for Scheme of Services | 4 | SHCOD | Scheme Code. E.g. Super Scale, Time Scale etc. | nvarchar | 2 | 0 | | |
3 | T5PBSR6C | Assignment between Scheme Code and Salary Code | 3 | SHCOD | Scheme Code. E.g. Super Scale, Time Scale etc. | nvarchar | 2 | 0 | | |
4 | T5PBSR6D | (Not used, will be deleted in 4.6) | 4 | SHCOD | Scheme Code. E.g. Super Scale, Time Scale etc. | nvarchar | 2 | 0 | | |
5 | T5PBSR6E | Annual Wage Adjustment for Basic Component | 4 | SHCOD | Scheme Code. E.g. Super Scale, Time Scale etc. | nvarchar | 2 | 0 | | |
6 | T5PBSR6J | Annual Wage Adjustment for MVC Component | 3 | SHCOD | Scheme Code. E.g. Super Scale, Time Scale etc. | nvarchar | 2 | 0 | | |
7 | T5PBSR6M | Assignment between Pay Scale Types and Scheme Code | 4 | SHCOD | Scheme Code. E.g. Super Scale, Time Scale etc. | nvarchar | 2 | 0 | | |