| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | T7PIQSRMGEN | Settings for Use of Records Management | 2 | RMSID | ID of Records Management System for Student Record | nvarchar | 32 | 0 | | |
TOPInformation System |
2 | TIVISRMOTBS | Basic Settings for Each Object Type | 5 | RMSID | RMS ID | nvarchar | 32 | 0 | | |
TOPRecords and Case Management |
3 | RMPSGENSPHIST | History Table for Generic SP Objects | 3 | RMSID | RMS ID | nvarchar | 32 | 0 | | |
4 | RMPSGENSPHISTS | Additional Information for History Table GSP | 3 | RMSID | RMS ID | nvarchar | 32 | 0 | | |
5 | RMPSMAP2DLATTRIB | Mapping Metadata: Definition of Download Format Such as X500 | 2 | RMSID | RMS ID | nvarchar | 32 | 0 | | |
6 | RMPSPEINDOCTYP | Basic Customizing of Incoming Objects | 4 | RMSID | RMS ID | nvarchar | 32 | 0 | | |
7 | RMPSPRO_FOLDHIST | History Table for Used Folder | 3 | RMSID | RMS ID in SRM | nvarchar | 32 | 0 | | |
8 | RMPS_RESUB | Resubmission - Additional Fields Public Sector | 3 | RMSID | RMS ID in SRM | nvarchar | 32 | 0 | | |
9 | RMPS_T_RESUB | Resubmissions (new) | 3 | RMSID | RMS ID in SRM | nvarchar | 32 | 0 | | |
TOPSAP Records Management |
10 | SRMLOCSRTINDX | Index Table for Search Results | 4 | RMSID | RMS ID | nvarchar | 32 | 0 | | |
11 | SRMORGFAV | BC-RM: Organizer Favorites | 4 | RMSID | RMS ID in SRM | nvarchar | 32 | 0 | | |
12 | SRMORGHIS | SRM Organizer : Worklist | 3 | RMSID | RMS ID in SRM | nvarchar | 32 | 0 | | |
13 | SRMORGRES | Resubmit | 3 | RMSID | RMS ID in SRM | nvarchar | 32 | 0 | | |
14 | SRMORGRL2 | BC-RM : Roles (new) | 4 | RMSID | RMS ID in SRM | nvarchar | 32 | 0 | | |
15 | SRMORGRL2T | Text Table: View Elements | 5 | RMSID | RMS ID in SRM | nvarchar | 32 | 0 | | |
16 | SRMORGROL | SRM View Generator : Role Definition | 3 | RMSID | RMS ID in SRM | nvarchar | 32 | 0 | | |
17 | SRMORGROLT | Text Table for View Definition | 4 | RMSID | RMS ID in SRM | nvarchar | 32 | 0 | | |
18 | SRMSTART_T | Start Data SRM | 6 | RMSID | Character field, length 64 | nvarchar | 64 | 0 | | |
19 | SRMUSERQUERY | Stored Search Query v. Users According to Element Type | 6 | RMSID | RMS ID in SRM | nvarchar | 32 | 0 | | |
20 | SRMXMLIDXI | Indexing of SRM xml docs (record instance) | 4 | RMSID | | nvarchar | 32 | 0 | | |
21 | SRMXMLIDXM | Indexing of SRM xml docs (record model) | 4 | RMSID | | nvarchar | 32 | 0 | | |
22 | SRMXMLIDXP | Indexing of SRM xml docs (file plan) | 4 | RMSID | | nvarchar | 32 | 0 | | |