| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | T5P6NP | Parishes | 7 | PATXT | Parish name | nvarchar | 200 | 0 | | |
| 2 | T7RU53PT | Status for time accounting for PSG | 4 | PATXT | Employee Attribute Text | nvarchar | 20 | 0 | | |
| TOPMaster Data |
| 3 | T457P | Text Table for Order Types in the Planned Order | 5 | PATXT | Long text for planned order type | nvarchar | 15 | 0 | | |
| TOPPension fund General Parts |
| 4 | T5CAB | Parameter Area Name | 6 | PATXT | HR-CH: PC parameter area name | nvarchar | 15 | 0 | | |
| TOPPersonnel Cost Planning and Simulation |
| 5 | T77HCP_PARA_T | Method Parameter Texts | 3 | PATXT | Name | nvarchar | 40 | 0 | | |
| TOPPortugal |
| 6 | T5P6P | HR-PT: Parishes | 4 | PATXT | Parish | nvarchar | 30 | 0 | | |
| TOPPublic Sector |
| 7 | T7MXPBS31T | Payment center description | 4 | PATXT | Payment center description | nvarchar | 130 | 0 | | |
