| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /WSOPT/NAVINODE | Nodes Navigation Tree | 3 | LEVEL2 | WSO: Navigation Node 2 | nvarchar | 64 | 0 | | |
2 | T7AEPBS04 | Job Class Group | 6 | LEVEL2 | Job Classification Code Field 2 | nvarchar | 30 | 0 | | |
TOPClinical System |
3 | N1FORMULARY | Medication: Drug Formulary | 99 | LEVEL2 | Medication: Mnemonic | nvarchar | 32 | 0 | | |
4 | N1MEDS_DS12 | Medication: Formulary Grouping Areas | 4 | LEVEL2 | Medication: Second Grouping Level | nvarchar | 1 | 0 | | |
TOPExpenditure Certification |
5 | FMEUFFNS | Financing Source | 7 | LEVEL2 | Level 2 | nvarchar | 4 | 0 | | |
6 | FMEUFLEV2 | Financing Source Level 2 | 3 | LEVEL2 | Level 2 | nvarchar | 4 | 0 | | |
7 | FMEUFLEV2T | Financing Source Level 2 - Text Table | 3 | LEVEL2 | Level 2 | nvarchar | 4 | 0 | | |
8 | FMEUFLEV3 | Financing Source Level 3 | 3 | LEVEL2 | Level 2 | nvarchar | 4 | 0 | | |
9 | FMEUFLEV3T | Financing Source Level 3 - Text Table | 3 | LEVEL2 | Level 2 | nvarchar | 4 | 0 | | |
10 | FMEUFLEV4 | Financing Source Level 4 | 3 | LEVEL2 | Level 2 | nvarchar | 4 | 0 | | |
11 | FMEUFLEV4T | Financing Source Level 4 - Text Table | 3 | LEVEL2 | Level 2 | nvarchar | 4 | 0 | | |
TOPLease Accounting |
12 | TFILA_GF_111 | Check Steps in Financing Classification | 6 | LEVEL2 | Substitution: Check Takes Place Later (Subtest) | nvarchar | 1 | 0 | | |
TOPPerformance Assessment Workbench |
13 | SLS_PAWMEN | PAW - Menu entries | 6 | LEVEL2 | PAW - Hierarchie Level 2 | nvarchar | 4 | 0 | | |