The following table lists all RiskMinder database tables and their description.
|
Table Name |
Description |
|---|---|
|
ARQGEOANONYMIZER1 |
Stores the known IP addresses of the anonymizers that do not propagate the end-user IP addresses. This is the primary table. Note: While reloading data to this table, RiskMinder Server refers to ARQGeoAnonymizer2. |
|
ARQGEOANONYMIZER2 |
Stores the known IP addresses of the anonymizers that do not propagate the end-user IP addresses. This is the secondary table. Note: While reloading data to this table, RiskMinder Server refers to ARQGeoAnonymizer1. |
|
ARQGEOPOINT1 |
Stores the geo-location information for different ranges of IP addresses. This information is obtained from Quova. Note: While reloading data to this table, RiskMinder Server refers to ARQGEOPOINT2. |
|
ARQGEOPOINT2 |
Stores the geo-location information for different ranges of IP addresses. This information is obtained from Quova. Note: While reloading data to this table, RiskMinder Server refers to ARQGEOPOINT1. |
|
ARQUOVAVERSION |
Tracks the files from Quova that were uploaded to ARQ* tables. |
|
ARRF_CASE_TXN |
Contains the Case-to-Transaction mapping and related details of the default Channel. If you define a specific Channel for your deployment, then another database table is created with the Channel name appended to the default table, for example, ARRF_CASE_TXN_<channel_name>. |
|
ARRF_CMA |
Contains the repeated transactions of the same combination of Cardholder-Merchant-Amount (CMA). Note: If the rule is not used, then the table is empty. |
|
ARRF_IMA |
Contains the repeated transactions of the same combination of IP-Merchant-Amount. Note: If the rule is not used, the table is empty. |
|
ARRFADDONEXPOSEDPARAMS |
Stores the parameter details used by the custom rules you deploy. This table also stores the information whether specific parameters can be modified by a custom rule during processing. Note: It is recommended that you consult CA Support before modifying any parameters. |
|
ARRFADDONRULELISTDATA |
Contains list data and corresponding dataset version. This is used by rules or rule fragments that use IN_LIST and IN_CATEGORY operators. |
|
ARRFADDONRULEMAPPINGDATA |
Contains mapping of the elements and the category to which it belongs to. This data is used by rules that use the IN_CATEGORY operator to store the DATA-to-Category mapping. For example, Merchant rules in a 3-D Secure deployment. |
|
ARRFADDONRULETYPE |
Stores the detailed configuration information for custom rules implemented for each organization in the system. |
|
ARRFADVICECODE |
Stores the list of available risk advices. |
|
ARRFADVICECONFIG |
Stores mapping of risk score ranges and corresponding advice. Note: Currently, this mapping is same for all the organizations. |
|
ARRFBASECHANNELELEMENTS |
Stores the mapping of all common elements and their configurations across channels. |
|
ARRFBUCKETCONFIG |
Stores the details of all categories used for signature matching by MFP and DeviceDNA. In other words, this table contains the master list of all classifications, and their details, such as attributes and relative weight that is used in the DeviceDNA algorithm. |
|
ARRFBUCKETELEMENTCONFIG |
Stores the configuration details for all elements in all categories used for signature matching by DeviceDNA. In addition, this table contains the classification for these elements. |
|
ARRFCASEAUDITLOG |
Stores the case details and other case-related activities that are logged. |
|
ARRFCASEQUEUES |
Stores the definitions of each case queue. |
|
ARRFCASES |
Stores the details of all the open cases in the system, irrespective of the queue they belong to. |
|
ARRFCHANNEL |
Stores the basic definition (such as, case transaction table name and audit log table name) of all Channels that exist in the system. |
|
ARRFCHANNELDETAILCATEGORY |
Stores the details on various categories that GUI display elements belong to, for each channel. |
|
ARRFCHANNELELEMENTS |
Stores the details of all Channel elements. |
|
ARRFCHANNELMSGPROPERTIES |
Stores channel-specific localization information, such as channel display names and keys. Note: Localization is not supported in the current release. |
|
ARRFCHANNELTXNTYPE |
Stores the mapping details of all transactions supported for each channel in the system. |
|
ARRFCHANNELTXNTYPEELEMENTS |
Stores the channel-wise details of all possible element types that can come as a part of the request.In other words, this table stores the mapping of channel elements to action. |
|
ARRFCLIENTCERTSANDKEYS |
Stores SSL keys and certificates required for communicating with a de-tokenization service. Note: Currently, this table is applicable only for TransFort-RiskMinder integration deployments. |
|
ARRFCLIENTSSLROOTCAS |
Stores the client trust stores and the corresponding root CA certificates for two-way SSL authentication. |
|
ARRFCONFIGURATION |
Stores global- and organization-level miscellaneous RiskMinder configurations. This includes the information related to case details and other case-related activities that are logged. |
|
ARRFCOUNTRY |
Stores the list of all countries and their ISO codes. |
|
ARRFCOUNTRYLIST |
Stores the list of all countries as listed in Quova data. |
|
ARRFCURRCONVRATES |
Stores the list of all supported currencies and their corresponding conversion rates. |
|
ARRFCURRENCY |
Stores the details of all currencies, their ISO codes, and exponents for each. |
|
ARRFCURRENTCMSCHEDULE |
Stores the case schedules created by Case Management Queuing Server. |
|
ARRFCURRENTORGCONFIG |
Stores the current configuration for all organizations in the system. |
|
ARRFDATAVERSIONMAPPING |
Stores all configured RiskMinder configuration information. The information in this table contains version information, and therefore can contain multiple entries per configuration. |
|
ARRFDBERRORCODES |
Contains all database error codes that indicate a possible communication failure. Note: It is recommended that you consult CA Support before editing this table. |
|
ARRFDEVICECONTEXT |
Stores the context information (such as device status, timestamp of the transaction, and the requested action) for each incoming transaction from a user device. Note: This information is used for Device Velocity checks. |
|
ARRFDEVICEINFO |
Stores detailed information for all devices used for user transactions. |
|
ARRFDEVICEINFOHIST |
Stores the history of all user devices registered with the system. |
|
ARRFDEVICETYPE |
Stores the master list of all supported desktop and hand-held devices. |
|
ARRFDEVUSERASSO |
Stores all information related to user-device mapping. |
|
ARRFDEVUSERASSO_ARCHIVE |
Stores all archived information related to user-device mapping. |
|
ARRFDISPLAYNAMES |
Stores all variable strings (for DISPLAYNAMEKEY) that are used by Administration Console labels (ARRFMESSAGES). |
|
ARRFELEMENTSSUPPORTEDVALUES |
Stores the Case Management layout details for viewing transaction details. |
|
ARRFELEMOPREGIONMAP |
Stores the detailed mapping for all elements-to-operations that you can use while using the Rules Builder to create custom rules. In other words, this table stores the metadata used for organizing the Rule Builder screen. |
|
ARRFEXCEPTIONUSER |
Stores the list of users marked as Exception Users. |
|
ARRFEXCPUSERHIST |
Stores the history of all users who were marked as exception users. |
|
ARRFINSTANCEAUDITLOG |
Stores all details related to all instances configured in the system along with all activities (such as restart, update, refresh, and shutdown) that were performed on the instance. In other words, this table stores the audit trail of all management activities for each instance in the system. |
|
ARRFINSTANCES |
Stores the details of all server instances configured in the system. These instances can either be RiskMinder Server instances or Case Management Queuing Server instances. |
|
ARRFIPCONTEXT |
Stores the IP context that is used by the IP velocity rule. Note: This table is for future use. |
|
ARRFLIBRARYTOTYPEMAPPING |
Stores the mapping of all supported custom rule types with the corresponding library name. Note: This table is for future use. |
|
ARRFLOCALE |
Stores information related to all supported locales. |
|
ARRFMESSAGES |
Stores the Response and Reason Codes messages. |
|
ARRFNEGATIVECOUNTRYLIST |
Stores the list of all negative countries. |
|
ARRFOPERATORS |
Stores the list of all operators (used for creating rules by using Rule Builder) supported by RiskMinder. |
|
ARRFORGCHANNEL |
Stores the list of all supported Channels for each organization. |
|
ARRFORGQUEUES |
Stores the list and basic details of all queues that belong to an organization and Channel. |
|
ARRFOTHERELEMENTS |
Stores detailed information for all non-channel elements (such as system time) using which you can write custom rules. In other words, this table stores the list of elements that are not passed during a transaction, but are used or displayed in the Rule Builder screen. |
|
ARRFPROTOCOLREGISTRY |
Stores configuration of each listener port of RiskMinder Server. |
|
ARRFQUEUEADMIN |
Stores the Queue-to-Administrator mapping details. |
|
ARRFRULEDEPENDENCY |
Stores the details of what other rules a rule is dependent on. |
|
ARRFSERVERS |
Stores the mapping of available RiskMinder Server instances. |
|
ARRFSITES |
Stores site details for each de-tokenization service. Note: Currently, this table is applicable only for TransFort-RiskMinder integration deployments. This table will soon be deprecated. |
|
ARRFSYSAUDITLOG |
Stores all details related to all transactions (risk evaluation and other activities) that are logged. If you configure additional Channels for your deployment, then corresponding tables are created and named with the Channel name appended to the default table name, for example, ARRFSYSAUDITLOG_<channel_name>. |
|
ARRFSYSORGCONFIG |
Stores all versions of configurations available for all organizations in the system. Note: This table stores both history and the changes made by the administrator. |
|
ARRFSYSPARAMSCONFIG |
Contains detailed information about all RiskMinder system parameters that are configurable by using Administration Console. Note: This table stores both history and the changes that are made by the administrator. |
|
ARRFSYSRULEEXECCONFIG |
Stores the configuration information for all rules. This information includes version and configuration for each rule. Note: This table stores both history and the changes that are made by the administrator. |
|
ARRFSYSTERMRULESCORECONFIG |
Stores configuration information for each rule and the corresponding result that impacts the risk score. |
|
ARRFTRUSTEDIPLIST |
Stores the information for all trusted aggregators, IP addresses, and ranges. |
|
ARRFTXNTYPE |
Stores the master list of all transaction types supported in the system. |
|
ARRFUAOSLIST |
Stores the master list of all User-Agent OS strings-to-actual-Operating System-and-Version mappings. This information is used for logical upgrades for Windows. |
|
ARRFUNTRUSTEDIPLIST |
Stores the details of all negative IP addresses. |
|
ARRFUNTRUSTEDIPLIST_ |
Stores the archived information for the ARRFUNTRUSTEDIPLIST table. In other words, this table serves as an archive of details related to all deleted negative IP addresses. |
|
ARRFUNTRUSTEDIPTYPE |
Stores the mapping for all supported negative IP types. |
|
ARRFUPLOADAUDITLOG |
Stores the details of the operations performed on the GeoPoint and GeoAnonymizer tables. |
|
ARRFUSERCONTEXT |
Stores the context information (such as user status, timestamp of the transaction, and the requested action) for each incoming transaction from a user. Note: This information is used for User Velocity checks. |
|
ARRFUSERCONTEXT_ARCHIVE |
Stores the archived information for the ARRFUSERCONTEXT table. In other words, this table serves as an archive for user context information for deleted users.
|
|
Copyright © 2013 CA.
All rights reserved.
|
|