| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | P2RP_SS | HR-PT: Payroll Results: Social Security | 34 | PRCOD | Professional category IRC code | nvarchar | 5 | 0 | | |
| 2 | T5PPBS9N | Portugal Public Sector - Professional Situation | 3 | PRCOD | Professional category IRC code | nvarchar | 5 | 0 | | |
| TOPKnowledge Base |
| 3 | ISMITPR | SDB: Symptom Trigger Problem | 8 | PRCOD | SDB: Code - Problem Damage | nvarchar | 4 | 0 | | |
| TOPPortugal |
| 4 | PA0337 | HR Master Record: Infotype 0337 (Prof.Classification - PT) | 25 | PRCOD | Professional category IRC code | nvarchar | 5 | 0 | | |
| 5 | T5PP1 | HR-PT: Professional categories assignment | 8 | PRCOD | Professional category IRC code | nvarchar | 5 | 0 | | |
| 6 | T5PP2 | HR-PT: Professional categories | 3 | PRCOD | Professional category IRC code | nvarchar | 5 | 0 | | |
| 7 | T5PP4 | HR-PT: Professional Category designation | 4 | PRCOD | Professional category IRC code | nvarchar | 5 | 0 | | |
| 8 | T5PS1 | HR-PT: professional categories assignment (IRC code) | 10 | PRCOD | Professional category IRC code | nvarchar | 5 | 0 | | |
| 9 | T5PS4 | HR-PT: Professional Category designation | 4 | PRCOD | Professional category IRC code | nvarchar | 5 | 0 | | |
| 10 | T5PS4T | HR-PT: text table for professional category designation | 5 | PRCOD | Professional category IRC code | nvarchar | 5 | 0 | | |
| TOPPublic Sector |
| 11 | T5VPPS1B | Process ID and codes for Norway Public Sector | 4 | PRCOD | Process Code for Norway PS | nvarchar | 10 | 0 | | |
| 12 | T5VPPS1BT | Process ID and codes for Norway Public Sector | 5 | PRCOD | Process Code for Norway PS | nvarchar | 10 | 0 | | |
| 13 | T5VPPS_SPKP | Code for SPK for leave-agreement with valid years | 7 | PRCOD | Process Code for Norway PS | nvarchar | 10 | 0 | | |
| 14 | T5VPPS_TMA | Temporary Agreement codes | 8 | PRCOD | Process Code for Norway PS | nvarchar | 10 | 0 | | |
