| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | ADMI_URIS | Alternative Paths for Archive Files | 3 | POLICY_TYPE | Audit Area | nvarchar | 10 | 0 | | |
2 | GRFNPOLICY | DB table for policy common information in policy management | 4 | POLICY_TYPE | Policy Type | nvarchar | 10 | 0 | | |
3 | GRRMRESP | Response attributes | 37 | POLICY_TYPE | Policy Type | nvarchar | 10 | 0 | | |
TOPArchive Development Kit |
4 | ADMI_FILE_RULES | IRM Rules Applied for Archive Files | 5 | POLICY_TYPE | Audit Area | nvarchar | 10 | 0 | | |
TOPGRC Risk Management |
5 | GRRMRESPONSE | Table for Response | 36 | POLICY_TYPE | Policy Type | nvarchar | 10 | 0 | | |
TOPInformation Retention Manager |
6 | IRM_T_POL_TYPE | IRM: Policy Types | 2 | POLICY_TYPE | IRM: Policy Type | nvarchar | 10 | 0 | | |
7 | IRM_T_POL_TYPE_T | IRM: Description for Rule Types | 3 | POLICY_TYPE | IRM: Policy Type | nvarchar | 10 | 0 | | |
8 | LRM_BS_RST_CONDS | IRM: Conditions for Business Suite and Residence Times | 5 | POLICY_TYPE | Audit Area | nvarchar | 10 | 0 | | |
9 | LRM_BS_RST_RULES | IRM: Rules for Business Suite and Residence Times | 5 | POLICY_TYPE | Audit Area | nvarchar | 10 | 0 | | |
10 | LRM_BS_RTP_CONDS | IRM: Conditions for Business Suite and Retention Periods | 5 | POLICY_TYPE | Audit Area | nvarchar | 10 | 0 | | |
11 | LRM_BS_RTP_RULES | IRM: Rules for Business Suite and Retention Periods | 5 | POLICY_TYPE | Audit Area | nvarchar | 10 | 0 | | |
12 | LRM_PD_RTP_CONDS | IRM: Conditions for Retention Rules for Paper Documents | 5 | POLICY_TYPE | Audit Area | nvarchar | 10 | 0 | | |
13 | LRM_PD_RTP_RULES | IRM: Rules for Retention of Paper Documents | 5 | POLICY_TYPE | Audit Area | nvarchar | 10 | 0 | | |
TOPIRM Run Time |
14 | LRM_RE_NR | IRM: Number Assignment for Rules | 5 | POLICY_TYPE | Audit Area | nvarchar | 10 | 0 | | |
15 | LRM_T_EXIT_POL | Dummy Table for Jump to Policy Maintenance | 5 | POLICY_TYPE | Audit Area | nvarchar | 10 | 0 | | |
16 | LRM_T_OT_POL_FLD | Selected Fields in Policy | 5 | POLICY_TYPE | Audit Area | nvarchar | 10 | 0 | | |
17 | LRM_T_OT_POL_ORI | Policy (Origin) | 5 | POLICY_TYPE | Audit Area | nvarchar | 10 | 0 | | |
18 | LRM_T_OT_PT | Available Policy Types (Available Audit Areas) | 5 | POLICY_TYPE | Audit Area | nvarchar | 10 | 0 | | |
19 | LRM_T_PT | Policy Types (Audit Areas) | 3 | POLICY_TYPE | Audit Area | nvarchar | 10 | 0 | | |
20 | LRM_T_PT_T | Policy Types - Descriptions | 4 | POLICY_TYPE | Audit Area | nvarchar | 10 | 0 | | |
TOPRetention Warehouse |
21 | IWP_REPOS_BW | Available Tables for BW | 5 | POLICY_TYPE | Audit Area | nvarchar | 10 | 0 | | |
22 | IWP_REPOS_BW_C | Available Tables for BW - Customer adoptions | 5 | POLICY_TYPE | Audit Area | nvarchar | 10 | 0 | | |
23 | IWP_REPOS_BW_V | Available Views for BW | 3 | POLICY_TYPE | Audit Area | nvarchar | 10 | 0 | | |
24 | IWP_REPOS_BW_V_C | Available Views for BW - Customer adoption | 3 | POLICY_TYPE | Audit Area | nvarchar | 10 | 0 | | |