| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /WSOPT/NAVINODE | Nodes Navigation Tree | 2 | LEVEL1 | WSO: Navigation Node 1 | nvarchar | 64 | 0 | | |
| 2 | PAPBSGB_SWF_ABS | SWF: Absences | 4 | LEVEL1 | SWF: LA or School Level | nvarchar | 1 | 0 | | |
| 3 | PAPBSGB_SWF_ATP | SWF : Agency TP | 4 | LEVEL1 | SWF: LA or School Level | nvarchar | 1 | 0 | | |
| 4 | PAPBSGB_SWF_CONT | SWF: Contract Details | 4 | LEVEL1 | SWF: LA or School Level | nvarchar | 1 | 0 | | |
| 5 | PAPBSGB_SWF_CTRL | SWF : Control | 4 | LEVEL1 | SWF: LA or School Level | nvarchar | 1 | 0 | | |
| 6 | PAPBSGB_SWF_CUR2 | SWF: Curriculum | 4 | LEVEL1 | SWF: LA or School Level | nvarchar | 1 | 0 | | |
| 7 | PAPBSGB_SWF_CURR | SWF: Curriculum | 4 | LEVEL1 | SWF: LA or School Level | nvarchar | 1 | 0 | | |
| 8 | PAPBSGB_SWF_EP | SWF: Educational Psychologists | 3 | LEVEL1 | SWF: LA or School Level | nvarchar | 1 | 0 | | |
| 9 | PAPBSGB_SWF_INFO | SWF: Staff Information | 4 | LEVEL1 | SWF: LA or School Level | nvarchar | 1 | 0 | | |
| 10 | PAPBSGB_SWF_PAY | SWF: Additional Payments | 4 | LEVEL1 | SWF: LA or School Level | nvarchar | 1 | 0 | | |
| 11 | PAPBSGB_SWF_QUAL | SWF: Qualifications | 4 | LEVEL1 | SWF: LA or School Level | nvarchar | 1 | 0 | | |
| 12 | PAPBSGB_SWF_QUL2 | SWF: Qualifications | 4 | LEVEL1 | SWF: LA or School Level | nvarchar | 1 | 0 | | |
| 13 | PAPBSGB_SWF_STAF | SWF: Staff Details | 4 | LEVEL1 | SWF: LA or School Level | nvarchar | 1 | 0 | | |
| 14 | PAPBSGB_SWF_VACA | SWF: Vacancies | 4 | LEVEL1 | SWF: LA or School Level | nvarchar | 1 | 0 | | |
| 15 | T7AEPBS04 | Job Class Group | 5 | LEVEL1 | Job Classification Code Field 1 | nvarchar | 30 | 0 | | |
| TOPClinical System |
| 16 | N1FORMULARY | Medication: Drug Formulary | 98 | LEVEL1 | Medication: Mnemonic | nvarchar | 32 | 0 | | |
| 17 | N1MEDS_DS12 | Medication: Formulary Grouping Areas | 3 | LEVEL1 | Medication: First Grouping Level | nvarchar | 1 | 0 | | |
| TOPExpenditure Certification |
| 18 | FMEUFFNS | Financing Source | 6 | LEVEL1 | Level 1 | nvarchar | 4 | 0 | | |
| 19 | FMEUFLEV1 | Financing Source Level 1 | 2 | LEVEL1 | Level 1 | nvarchar | 4 | 0 | | |
| 20 | FMEUFLEV1T | Financing Source Level 1 - Text Table | 2 | LEVEL1 | Level 1 | nvarchar | 4 | 0 | | |
| 21 | FMEUFLEV2 | Financing Source Level 2 | 2 | LEVEL1 | Level 1 | nvarchar | 4 | 0 | | |
| 22 | FMEUFLEV2T | Financing Source Level 2 - Text Table | 2 | LEVEL1 | Level 1 | nvarchar | 4 | 0 | | |
| 23 | FMEUFLEV3 | Financing Source Level 3 | 2 | LEVEL1 | Level 1 | nvarchar | 4 | 0 | | |
| 24 | FMEUFLEV3T | Financing Source Level 3 - Text Table | 2 | LEVEL1 | Level 1 | nvarchar | 4 | 0 | | |
| 25 | FMEUFLEV4 | Financing Source Level 4 | 2 | LEVEL1 | Level 1 | nvarchar | 4 | 0 | | |
| 26 | FMEUFLEV4T | Financing Source Level 4 - Text Table | 2 | LEVEL1 | Level 1 | nvarchar | 4 | 0 | | |
| TOPPerformance Assessment Workbench |
| 27 | SLS_PAWMEN | PAW - Menu entries | 5 | LEVEL1 | PAW - Hierarchie Level 1 | nvarchar | 4 | 0 | | |
| TOPProject System |
| 28 | SAVESORT_PS_LOG | to save the sort for ps_log | 14 | LEVEL1 | Natural Number | int | 10 | 0 | | |
