| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | P2CN_BI | Payroll result: Social Insurances and PHF (CN) | 21 | ERIND | Employer contribution base indicator | nvarchar | 1 | 0 | | |
| 2 | P2CN_II | Payroll result: Social Insurances and PHF (CN) | 21 | ERIND | Employer contribution base indicator | nvarchar | 1 | 0 | | |
| 3 | P2CN_MI | Payroll result: Social Insurances and PHF (CN) | 21 | ERIND | Employer contribution base indicator | nvarchar | 1 | 0 | | |
| 4 | P2CN_PHF | Payroll result: Social Insurances and PHF (CN) | 21 | ERIND | Employer contribution base indicator | nvarchar | 1 | 0 | | |
| 5 | P2CN_PI | Payroll result: Social Insurances and PHF (CN) | 21 | ERIND | Employer contribution base indicator | nvarchar | 1 | 0 | | |
| 6 | P2CN_UI | Payroll result: Social Insurances and PHF (CN) | 21 | ERIND | Employer contribution base indicator | nvarchar | 1 | 0 | | |
| 7 | T510N | Pay Scales for Annual Salaries (NA) | 12 | ERIND | Checkbox | nvarchar | 1 | 0 | | |
| TOPChina |
| 8 | T7CN20 | Contribution base | 19 | ERIND | Employer contribution base indicator | nvarchar | 1 | 0 | | |
| TOPCompensation Management |
| 9 | T710A | Pay Grade | 14 | ERIND | Single-Character Indicator | nvarchar | 1 | 0 | | |
