| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | LRM_T_OC_OG | Object Groups | 3 | POLICY_CATEGORY | Policy Category | nvarchar | 3 | 0 | | |
2 | LRM_T_OC_OG_T | Object Groups - Description | 4 | POLICY_CATEGORY | Policy Category | nvarchar | 3 | 0 | | |
3 | LRM_T_OC_RG | Rule Groups | 3 | POLICY_CATEGORY | Policy Category | nvarchar | 3 | 0 | | |
4 | LRM_T_OC_RG_F | Rule Groups - Fields | 3 | POLICY_CATEGORY | Policy Category | nvarchar | 3 | 0 | | |
5 | LRM_T_OC_RG_T | Rule Groups - Description | 4 | POLICY_CATEGORY | Policy Category | nvarchar | 3 | 0 | | |
TOPArchive Development Kit |
6 | ADMI_FILE_RULES | IRM Rules Applied for Archive Files | 4 | POLICY_CATEGORY | Policy Category | nvarchar | 3 | 0 | | |
TOPInformation Retention Manager |
7 | IRM_T_EXIT_POL | IRM: Dummy Table for Branching to Policy Maintenance | 3 | POLICY_CATEGORY | IRM: Policy Category | nvarchar | 3 | 0 | | |
8 | IRM_T_OT_POL_CAT | IRM: Obj. Types - References (Policy-Spec. Specifications) | 3 | POLICY_CATEGORY | IRM: Policy Category | nvarchar | 3 | 0 | | |
9 | IRM_T_POL_CAT | IRM: Policy Categories | 1 | POLICY_CATEGORY | IRM: Policy Category | nvarchar | 3 | 0 | | |
10 | IRM_T_POL_CAT_T | IRM: Descriptions for Policy Categories | 2 | POLICY_CATEGORY | IRM: Policy Category | nvarchar | 3 | 0 | | |
11 | IRM_T_POL_TYPE | IRM: Policy Types | 1 | POLICY_CATEGORY | IRM: Policy Category | nvarchar | 3 | 0 | | |
12 | IRM_T_POL_TYPE_T | IRM: Description for Rule Types | 2 | POLICY_CATEGORY | IRM: Policy Category | nvarchar | 3 | 0 | | |
13 | LRM_BS_RST_CONDS | IRM: Conditions for Business Suite and Residence Times | 4 | POLICY_CATEGORY | Policy Category | nvarchar | 3 | 0 | | |
14 | LRM_BS_RST_RULES | IRM: Rules for Business Suite and Residence Times | 4 | POLICY_CATEGORY | Policy Category | nvarchar | 3 | 0 | | |
15 | LRM_BS_RTP_CONDS | IRM: Conditions for Business Suite and Retention Periods | 4 | POLICY_CATEGORY | Policy Category | nvarchar | 3 | 0 | | |
16 | LRM_BS_RTP_RULES | IRM: Rules for Business Suite and Retention Periods | 4 | POLICY_CATEGORY | Policy Category | nvarchar | 3 | 0 | | |
17 | LRM_PD_RTP_CONDS | IRM: Conditions for Retention Rules for Paper Documents | 4 | POLICY_CATEGORY | Policy Category | nvarchar | 3 | 0 | | |
18 | LRM_PD_RTP_RULES | IRM: Rules for Retention of Paper Documents | 4 | POLICY_CATEGORY | Policy Category | nvarchar | 3 | 0 | | |
TOPIRM Run Time |
19 | LRM_RE_NR | IRM: Number Assignment for Rules | 4 | POLICY_CATEGORY | Policy Category | nvarchar | 3 | 0 | | |
20 | LRM_RE_RES_STRUC | Registration of Rule Structure for OC and PC | 2 | POLICY_CATEGORY | Policy Category | nvarchar | 3 | 0 | | |
21 | LRM_T_EXIT_POL | Dummy Table for Jump to Policy Maintenance | 4 | POLICY_CATEGORY | Policy Category | nvarchar | 3 | 0 | | |
22 | LRM_T_OC_PC | Policy Category for Result Fields of Object Category | 2 | POLICY_CATEGORY | Policy Category | nvarchar | 3 | 0 | | |
23 | LRM_T_OC_RF | Result Fields of Policies | 2 | POLICY_CATEGORY | Policy Category | nvarchar | 3 | 0 | | |
24 | LRM_T_OC_RF_T | Result Fields of Policies - Description | 3 | POLICY_CATEGORY | Policy Category | nvarchar | 3 | 0 | | |
25 | LRM_T_OT_PC | Policy Categories Available for Object Types | 3 | POLICY_CATEGORY | Policy Category | nvarchar | 3 | 0 | | |
26 | LRM_T_OT_PC_STAT | Available Policy Categories for Object Type - Status | 3 | POLICY_CATEGORY | Policy Category | nvarchar | 3 | 0 | | |
27 | LRM_T_OT_POL_FLD | Selected Fields in Policy | 4 | POLICY_CATEGORY | Policy Category | nvarchar | 3 | 0 | | |
28 | LRM_T_OT_POL_ORI | Policy (Origin) | 4 | POLICY_CATEGORY | Policy Category | nvarchar | 3 | 0 | | |
29 | LRM_T_OT_PT | Available Policy Types (Available Audit Areas) | 4 | POLICY_CATEGORY | Policy Category | nvarchar | 3 | 0 | | |
30 | LRM_T_PC | Policy Categories | 1 | POLICY_CATEGORY | Policy Category | nvarchar | 3 | 0 | | |
31 | LRM_T_PC_T | Policy Categories - Descriptions | 2 | POLICY_CATEGORY | Policy Category | nvarchar | 3 | 0 | | |
32 | LRM_T_PT | Policy Types (Audit Areas) | 2 | POLICY_CATEGORY | Policy Category | nvarchar | 3 | 0 | | |
33 | LRM_T_PT_T | Policy Types - Descriptions | 3 | POLICY_CATEGORY | Policy Category | nvarchar | 3 | 0 | | |
34 | LRM_T_RE_CON | Switch for Rule Engine | 3 | POLICY_CATEGORY | Policy Category | nvarchar | 3 | 0 | | |
35 | LRM_T_SIM | IRM Simulator | 3 | POLICY_CATEGORY | Policy Category | nvarchar | 3 | 0 | | |
TOPRetention Warehouse |
36 | IWP_REPOS_BW | Available Tables for BW | 4 | POLICY_CATEGORY | Policy Category | nvarchar | 3 | 0 | | |
37 | IWP_REPOS_BW_C | Available Tables for BW - Customer adoptions | 4 | POLICY_CATEGORY | Policy Category | nvarchar | 3 | 0 | | |
38 | IWP_REPOS_BW_V | Available Views for BW | 2 | POLICY_CATEGORY | Policy Category | nvarchar | 3 | 0 | | |
39 | IWP_REPOS_BW_V_C | Available Views for BW - Customer adoption | 2 | POLICY_CATEGORY | Policy Category | nvarchar | 3 | 0 | | |