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

BIN_COUNTRY

The unique bank identification number for a country.

X

X

X

BIN_PLUS_FOUR

The unique bank identification number plus four.

X

X

X

CBD_SCORE

Displays the Chargeback Defender Score for the transaction.

X

X

X

CAT1

Products or services associated with Category 1.

X

X

X

X

CAT2

Products or services associated with Category 2.

X

X

X

X

CVIB

Displays the LN Instant ID CVI score for a billing address.

X

X

X

X

CVIS

Displays the LN Instant ID CVI score for a shipping address address.

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

EMAL

The email address associated with the transaction.

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

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

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

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

SCOR

The current risk assessment score for the transaction.

X

X

X

X

SITE

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

X

X

X

X

SHTP

The shipping type, either regular or other.

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

XCSR

The original risk score of the transaction.

X