| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | P2CN_BI | Payroll result: Social Insurances and PHF (CN) | 30 | PITAX | Pre/post tax indicator | nvarchar | 1 | 0 | | |
| 2 | P2CN_II | Payroll result: Social Insurances and PHF (CN) | 30 | PITAX | Pre/post tax indicator | nvarchar | 1 | 0 | | |
| 3 | P2CN_MI | Payroll result: Social Insurances and PHF (CN) | 30 | PITAX | Pre/post tax indicator | nvarchar | 1 | 0 | | |
| 4 | P2CN_PHF | Payroll result: Social Insurances and PHF (CN) | 30 | PITAX | Pre/post tax indicator | nvarchar | 1 | 0 | | |
| 5 | P2CN_PI | Payroll result: Social Insurances and PHF (CN) | 30 | PITAX | Pre/post tax indicator | nvarchar | 1 | 0 | | |
| 6 | P2CN_SUI | Payroll result: Supplementary Insurance (CN) | 30 | PITAX | Pre/post tax indicator | nvarchar | 1 | 0 | | |
| 7 | P2CN_UI | Payroll result: Social Insurances and PHF (CN) | 30 | PITAX | Pre/post tax indicator | nvarchar | 1 | 0 | | |
| TOPChina |
| 8 | T7CN25 | Contribution Area | 5 | PITAX | Pre/post tax indicator | nvarchar | 1 | 0 | | |
