| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /IAM/D_I_ROOT | Root node DB table | 49 | CAT_ID | Category ID | nvarchar | 4 | 0 | | |
2 | /OTX/RM_AUTHFLD | Authorisation Mapping - Fields | 5 | CAT_ID | Category ID | nvarchar | 10 | 0 | | |
3 | /OTX/RM_TPCATS | Declaration categories | 3 | CAT_ID | Category ID | nvarchar | 10 | 0 | | |
4 | /OTX/RM_TPMAPC | Mapping of SAP properties to Livelink category attributes | 3 | CAT_ID | Category ID | nvarchar | 10 | 0 | | |
5 | /OTX/RM_TPSMAPC | Mapping of SAP group attrs to Livelink category group attrs | 3 | CAT_ID | Category ID | nvarchar | 10 | 0 | | |
6 | /OTX/RM_WSC_CAT | Declaration categories | 3 | CAT_ID | Category ID | nvarchar | 10 | 0 | | |
7 | /OTX/RM_WSC_GMAP | Mapping of SAP group attrs to Livelink category group attrs | 3 | CAT_ID | Category ID | nvarchar | 10 | 0 | | |
8 | /OTX/RM_WSC_MAP | Mapping of SAP properties to Livelink category attributes | 3 | CAT_ID | Category ID | nvarchar | 10 | 0 | | |
TOPClinical System |
9 | N1RAD_TASK_CAT | Categories - Radiological Task Assignments | 4 | CAT_ID | Categories: Category Key | nvarchar | 6 | 0 | | |
10 | N2VDNOTE_CAT | Categorisation of a Progress Note | 6 | CAT_ID | Categories: Category Key | nvarchar | 6 | 0 | | |
11 | TN2CAT | Categories: Categories in Category Set | 5 | CAT_ID | Categories: Category Key | nvarchar | 6 | 0 | | |
12 | TN2CATC | Categories: Categories for End Users | 3 | CAT_ID | Categories: Category Key | nvarchar | 6 | 0 | | |
13 | TN2CATCT | Categories: Categories for End Users (Texts) | 3 | CAT_ID | Categories: Category Key | nvarchar | 6 | 0 | | |
TOPLogistics - General |
14 | EPM_KPICATEGORYT | KPI Text (Language-Dependent) | 2 | CAT_ID | Technical Name for KPI Category | nvarchar | 30 | 0 | | |
15 | EPM_KPI_CATALOG | KPIs Available in Company Catalog | 3 | CAT_ID | Technical Name for KPI Category | nvarchar | 30 | 0 | | |
16 | EPM_KPI_CATALOGH | History of KPIs in KPI Catalog | 4 | CAT_ID | Technical Name for KPI Category | nvarchar | 30 | 0 | | |
17 | EPM_KPI_CATEGORY | Possible KPI Categories | 2 | CAT_ID | Technical Name for KPI Category | nvarchar | 30 | 0 | | |
TOPOffice Suite Program |
18 | /OSP/T_RAUI_CTG | OSP Catalog Table | 2 | CAT_ID | Report Catalog ID | nvarchar | 4 | 0 | | |
19 | /OSP/T_RAUI_CTGT | OSP Catalog Text Table | 3 | CAT_ID | Report Catalog ID | nvarchar | 4 | 0 | | |
20 | /OSP/T_RAUI_DEL | Table to Store the Reports Delivery types | 2 | CAT_ID | Report Catalog ID | nvarchar | 4 | 0 | | |
21 | /OSP/T_RAUI_DELV | Table to Store the Reports Delivery types | 2 | CAT_ID | Report Catalog ID | nvarchar | 4 | 0 | | |
22 | /OSP/T_RAUI_MVL | OSP Report Parameterization Table | 2 | CAT_ID | Report Catalog ID | nvarchar | 4 | 0 | | |
23 | /OSP/T_RAUI_PBH | OSP Report Parameterization Table | 2 | CAT_ID | Report Catalog ID | nvarchar | 4 | 0 | | |
24 | /OSP/T_RAUI_PBHT | OSP Report Parameter Text Table | 3 | CAT_ID | Report Catalog ID | nvarchar | 4 | 0 | | |
25 | /OSP/T_RAUI_RDC | OSP Reports Data Change Events Table | 2 | CAT_ID | Report Catalog ID | nvarchar | 4 | 0 | | |
26 | /OSP/T_RAUI_REL | OSP Related Reports Table | 2 | CAT_ID | Report Catalog ID | nvarchar | 4 | 0 | | |
27 | /OSP/T_RAUI_RMT | OSP Report Mendocino Timepoints Table | 2 | CAT_ID | Report Catalog ID | nvarchar | 4 | 0 | | |
28 | /OSP/T_RAUI_ROLE | Table to store multiple roles assigned to a report template. | 2 | CAT_ID | Report Catalog ID | nvarchar | 4 | 0 | | |
29 | /OSP/T_RAUI_RTP | OSP Reports System Timepoints Table | 2 | CAT_ID | Report Catalog ID | nvarchar | 4 | 0 | | |
30 | /OSP/T_RAUI_SCH | OSP Report Scheduling Table | 2 | CAT_ID | Report Catalog ID | nvarchar | 4 | 0 | | |
31 | /OSP/T_RAUI_SCHT | OSP Report Scheduling Text Table | 3 | CAT_ID | Report Catalog ID | nvarchar | 4 | 0 | | |
32 | /OSP/T_RAUI_SEL | OSP Reports Selection Table | 2 | CAT_ID | Report Catalog ID | nvarchar | 4 | 0 | | |
33 | /OSP/T_RAUI_SELT | OSP Reports Selection Text Table | 3 | CAT_ID | Report Catalog ID | nvarchar | 4 | 0 | | |
34 | /OSP/T_RAUI_SREL | OSP Mendocino Applications' Related Reports Table | 2 | CAT_ID | Report Catalog ID | nvarchar | 4 | 0 | | |
35 | /OSP/T_REPORTS | OSP : Reports table used in Report Checksum BKT | 7 | CAT_ID | Report Catalog ID | nvarchar | 4 | 0 | | |