| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | T7RUPFTYPEERT | PFR Error types: Texts | 4 | PKTXT | Name of Package Type | nvarchar | 100 | 0 | | |
| 2 | T7RUPFTYPEPKT | PFR package types: Texts | 4 | PKTXT | Name of Package Type | nvarchar | 100 | 0 | | |
| TOPClinical System |
| 3 | N2BK | IS-H*MED: Basic Nursing Catalog | 5 | PKTXT | Short Text of Basic Nursing Catalog Entry | nvarchar | 30 | 0 | | |
| TOPPatient Accounting |
| 4 | TN46T | IS-H: Text for Person Group (PPA Billing) | 4 | PKTXT | IS-H: Text for Person Group (PPA Billing) | nvarchar | 25 | 0 | | |
| TOPProcess Controls -Automated Controls |
| 5 | GRPCRTA_HRDA0011 | HR Master Record: Infotype 0011 (Ext.Bank Transfers) | 9 | PKTXT | Name of Employee Subgroup | nvarchar | 20 | 0 | | |
| 6 | GRPCRTA_HRDA0045 | PC HR control data for infotype 0045 - Loan | 9 | PKTXT | Name of Employee Subgroup | nvarchar | 20 | 0 | | |
| 7 | GRPCRTA_HRDA0078 | PC HR control data for infotype 0078 - Loan Payments | 9 | PKTXT | Name of Employee Subgroup | nvarchar | 20 | 0 | | |
| 8 | GRPCRTA_HRDA0267 | PC HR control data for infotype 0267 | 9 | PKTXT | Name of Employee Subgroup | nvarchar | 20 | 0 | | |
| 9 | GRPCRTA_HRDAT1 | PC HR control data for infotype 0014 and 0015 | 9 | PKTXT | Name of Employee Subgroup | nvarchar | 20 | 0 | | |
| 10 | GRPCRTA_HRDAT2 | PC HR control data for infotype 0014 and 0015 | 9 | PKTXT | Name of Employee Subgroup | nvarchar | 20 | 0 | | |
| TOPWorkforce Management Application |
| 11 | WFAEM_V503K_T | Employee Subgroup text table | 4 | PKTXT | Text (20 Characters) | nvarchar | 20 | 0 | | |
| TOPWorkforce Management Core |
| 12 | WFMEM_V503K_T | Employee Subgroup text table | 4 | PKTXT | Text (20 Characters) | nvarchar | 20 | 0 | | |
