Previous Topic: RiskMinder Database TablesNext Topic: Used by Administration Console


Used by RiskMinder

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_
ARCHIVE

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.