| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /CPD/D_MP_ST_ARV | Table for Status Area version | 5 | AREA_ID | Scope Area | nvarchar | 4 | 0 | | |
2 | /CPD/D_MP_ST_HRA | Status Header Area | 5 | AREA_ID | Scope Area | nvarchar | 4 | 0 | | |
3 | /CPD/PWSC_AREAS | Status Management : Areas | 2 | AREA_ID | Scope Area | nvarchar | 4 | 0 | | |
4 | /CPD/PWSC_AREA_T | Area Description | 2 | AREA_ID | Scope Area | nvarchar | 4 | 0 | | |
5 | /CPD/PWSC_ST_ARA | Status/ Key figures to Areas | 3 | AREA_ID | Scope Area | nvarchar | 4 | 0 | | |
6 | /CPD/PWSC_TLA_AR | Status Management : Template to Area mapping | 2 | AREA_ID | Scope Area | nvarchar | 4 | 0 | | |
7 | /CPD/PWSC_TRD_AR | Status Management : Trends to Area mapping | 3 | AREA_ID | Scope Area | nvarchar | 4 | 0 | | |
8 | ZSRMPROTOCOL | SRM protocol entries | 5 | AREA_ID | Area - ID | nvarchar | 32 | 0 | | |
TOPCase Management |
9 | SRMMIMESPS | Table of Possible SPS IDs for File Extensions | 1 | AREA_ID | Area - ID | nvarchar | 32 | 0 | | |
TOPCollaboration Folders |
10 | CFX_AREA | Collaboration Folders: Area | 2 | AREA_ID | Area ID | varbinary | 16 | 0 | | |
11 | CFX_AREA_VISITOR | Collaboration Folders: Area Visitors | 2 | AREA_ID | Area ID | varbinary | 16 | 0 | | |
12 | CFX_FOL | Collaboration Folders: Folder | 4 | AREA_ID | Area ID | varbinary | 16 | 0 | | |
13 | CFX_HIST_FOL | CFX: Redundant Storage Topic ID for Folder ID (1:n) | 3 | AREA_ID | Area ID | varbinary | 16 | 0 | | |
14 | CFX_NTF_OBJECT | Collaboration Folders: Objects for the Notifications | 6 | AREA_ID | Area ID | varbinary | 16 | 0 | | |
TOPCross-Application Components |
15 | CFX_OBJ_EXP_DATE | Last export detail of the object | 6 | AREA_ID | UUID in character form | nvarchar | 32 | 0 | | |
TOPLine Maintenance |
16 | /ISDFPS/LMAREA | Area Table | 2 | AREA_ID | Area | nvarchar | 30 | 0 | | |
17 | /ISDFPS/LMAREAT | Text Table for Areas | 3 | AREA_ID | Area | nvarchar | 30 | 0 | | |
TOPPatient Management |
18 | N1COMPLDEGREE | Completion Status | 4 | AREA_ID | Work Area of a Monitoring Configuration | nvarchar | 10 | 0 | | |
19 | N1MONCON | Monitoring Configuration | 3 | AREA_ID | Work Area of a Monitoring Configuration | nvarchar | 10 | 0 | | |
TOPRecords and Case Management |
20 | RMPSAREAFRAMW | OBSOLETE!!! USE STANDARD METHODS!!! | 1 | AREA_ID | Area - ID | nvarchar | 32 | 0 | | |
21 | RMPS_AI_SCEN | Scenario Definitions | 5 | AREA_ID | Area - ID | nvarchar | 32 | 0 | | |
TOPSAP Records Management |
22 | RCMBDVGETDOIAPP | Document Client Config: Get DOI app. from win registry or DB | 2 | AREA_ID | Area - ID | nvarchar | 32 | 0 | | |
23 | SRMPROTOCOL | SRM protocol entries | 5 | AREA_ID | Area - ID | nvarchar | 32 | 0 | | |
24 | SRM_ECM_CSO | Client Supplied Owners of Document Locks | 2 | AREA_ID | Key of Area ID | nvarchar | 1 | 0 | | |
25 | SRM_ECM_HASH | HashValues of SRM/ECM optimistic locking (value comparision) | 2 | AREA_ID | Key of Area ID | nvarchar | 1 | 0 | | |
26 | SRM_ECM_NNT | Lookup table for RM node names in ECM integration | 2 | AREA_ID | Key of Area ID | nvarchar | 1 | 0 | | |
27 | SRM_ECM_NNT_AREA | Key of Records Management Area | 2 | AREA_ID | Key of Area ID | nvarchar | 1 | 0 | | |
28 | SRM_ECM_RNT | Lookup table for RM node names in ECM integration | 2 | AREA_ID | Key of Area ID | nvarchar | 1 | 0 | | |