| 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 | | |