Workflow Tables Column Locator

Name

Description

Suspect Orders

Special Alerts

Order Search

Persona Orders

AGEO

Identifies the age of an order in minutes.

X

X

X

X

AGNT

The initials of the Agent managing the suspect transaction.

X

X

X

X

AGTD

Identifies the age of an order by the date and time it came into the Workflow and was assigned.

X

X

X

X

AMNT

The amount of the transaction.

X

X

X

X

AUTH

The authorization status of the transaction, such as Approve or Decline.

X

X

X

X

AUTO AGENT RULE ID

Shows unique ID for an Auto Agent rule triggered by a transaction.

X

B2CC

Displays data for Billing Country.

X

X

X

X

BILL_EMAIL_AGE

Displays the number of days since the Billing Email was first seen.

X

X

X

X

BIN_COUNTRY

The unique bank identification number for a country.

X

X

X

X

BIN_PLUS_FOUR

The unique bank identification number plus four.

X

X

X

X

BRND

Displays the Payment Brand.

X

X

X

X

DATE

The date on which the transaction was made.

X

X

X

X

DVCC

Displays data for the country code configured on a device.

X

X

X

X

DVID

Displays the unique device ID value for the device used in the transaction.

X

X

X

X

EICS

If available, displays the Ekata Identity Check Score.

X

X

X

X

EINS

If available, displays the Ekata Identity Network Score.

X

X

X

X

ETHOCA

Shows Y if the transaction is matched to an Ethoca Alert.

X

X

X

X

EMAL

The email address associated with the transaction.

X

X

X

X

FRAUD_STATUS

If available, displays the Fraud Status of TC40 for Visa or SAFE for Mastercard.

X

X

X

X

GEOX

Geographical location of the riskiest country associated with the persona from the last 14 days.

X

X

X

X

IPAD

The IP address associated with the transaction.

X

X

X

X

KAPT

Indicates availability of the Data Collector

X

X

X

X

NAME

The customer name associated with the transaction.

X

X

X

X

NETW

The network type associated with the transaction, such as Library, Prison, or School.

X

X

X

X

ORDR

The unique order number used by Agents to identify the transaction.

X

X

X

X

ORIGINAL PERSONA SCORE

The original risk score of the transaction.

X

PERSONA SCORE

The current risk assessment score for the transaction.

X

X

X

X

PREPAID

Identifies if the Credit Card BIN has a prepaid or reloadable prepaid indicator.

X

PTOK

Payment token or method of payment used.

X

X

X

X

PTYP

The payment credentials or credit card type.

X

X

X

X

QAGE

Identifies the amount of time the transaction has been in the current queue.

X

X

X

X

REAS

Indicates the reason that the order is under review.

X

X

X

X

REASON_CODE

Displays a custom created reason code.

X

X

X

X

REGN

Region associated with the highest risk region, with GEOX, and other persona fields. This field is the riskiest region among clustered transactions in the persona. The data can come from the DDC or merchant data from RIS – depending on which one has the riskiest region. If no collector data is used, then the value would only come from RIS.

However, if the data coming from the collector indicates the device is mobile, then this value is prioritized because it is more accurate, even if it is less risky than other transactions in the cluster.

This region data comes from the DDC device_location table and from the RIS ris_detail table.

X

X

X

X

RFCB

Indicates a refund or chargeback.

X

X

X

X

RIS RULE ID

Shows unique ID for a rule triggered by a transaction.

X

X

X

X

S2CC

Column in the Order Search results display for Shipping Country.

X

X

X

X

S2EM

Displays Ship to Email Address data.

X

X

X

X

S2NM

Displays Ship to Name data.

X

X

X

X

SAFETY RATING

An indicator of a transaction’s safety relative to all the transactions that pass through the system. A safe transaction will have a relatively high Safety Rating and an unsafe transaction will have a relatively low Safety Rating.

The Safety Rating ranges from .1 (unsafe) to 99.9 (very safe).

X

X

X

X

SHIP_EMAIL_AGE

Displays the number of days since the Shipping Email was first seen.

X

X

X

X

SHTP

The shipping type, either regular or other.

X

X

X

X

SITE

The merchant-owned website used by the customer to make the transaction.

X

X

X

X

STAT

The current status of the order, such as Review, Escalate, or Expired.

X

X

X

X

TRAN

The unique number used by the merchant to identify the transaction.

X

X

X

X

UNIQ

Cookie customer values used by the merchant for tracking.

X

X

X

X

VELO

Indicates customer purchasing activity within the last 2 weeks.

X

X

X

X

VMAX

Indicates the most vigorous customer purchasing activity during a 6-hour period within the last 2 weeks.

X

X

X

X