The Data Model

The Payology Mobile Check Capture Data Model

Payology Mobile Check Capture Data Model

The Payology Mobile Check Capture Solution has only two Object Scopes:

  1. Check Capture Submission Object
  2. CheckForce API Custom Setting (see section labeled Custom Settings Configuration for more info).

The fields within the Check Capture Submission Object are as follows:

Field

Field Type

Description

Check Capture Submission Name

Auto Number

Salesforce Record Name

Record ID

Lookup

Salesforce Record ID

API Account Number

Text (Encrypted)

Account Number extracted from Check by OCR.

API Account Number SHA512

Text

HASH'd Account Number extracted from Check by OCR.

API Amount

Currency

Amount of check extracted by OCR.

API Check Number

Text

Check Number extracted from Check by OCR.

API MICR Line

Text (Encrypted)

MICR line extracted from Check by OCR.

API Routing Number

Text

Routing Number extracted from Check by OCR.

Account

Lookup

Salesforce Account ID used to relate and Account to the Check Capture Submission Record.

Account Number

Text (Encrypted)

User entered/confirmed Account Number.

Account Number SHA512

Text

User entered/confirmed Account Number HASH'd.

Amount

Currency

User entered/confirmed Amount of Check.

Check Number

Text

User entered/confirmed Check Number.

Contact

Lookup

Salesforce Contact ID used to relate and Contact to the Check Capture Submission Record.

Error Report

Long Text Areas

Field used to store errors received on submissions.

Expected Amount

Currency

Amount derived from URL or API indicating the expected amount of check (i.e. Shopping Cart Amount must equal Amount).

Hash Id

Text

HASH'd Record ID

MICR Line

Text (Encrypted)

Confirmed/Updated MICR line based on User entered/confirmed values.

OCR Status

Picklist

Indicative of whether the rear check image was validated for an endorsement.

Processing Status

Picklist

Indicative of the status of the Check Capture Submission record.

Routing Number

Text

User entered/confirmed Routing Number.

Submission Count

Number

Number of Check Capture submission attempts.

URLData

URL

URL String captured on Redirect or via API.

Usability Endorsement

Checkbox

If Endorsement Validation is Enabled, this field can be used to determine whether the rear check image has been endorsed.

User Data Confirmed

Checkbox

Indicates that the User Entered Data matches the OCR extracted data.

User ID

Lookup

Salesforce User ID used to relate and User to the Check Capture Submission Record.

API Amount Confidence Ratio

Text

Confidence Ratio between 0 and 1000 of the OCR captured Check amount.

API Date on Check

Text

OCR Captured Date on Check

API MICR Line Confidence Ratio

Text

Confidence Ratio between 0 and 1000 of the OCR captured MICR line.

City

Text

OCR Captured City of Payer of Check.

Created By

Lookup

Salesforce User ID used in the creation of the Check Capture Submission Record.

Date on Check Confidence Ratio

Text

Confidence Ratio between 0 and 1000 of the OCR captured Date.

Front of Check Processing time

Text

Time in which it took the image processor to respond on submission of front check image.

Last Modified By

Lookup

Salesforce User ID used in the modification of the Check Capture Submission Record.

Name 1 Confidence Ratio

Text

Confidence Ratio between 0 and 1000 of the OCR captured Name 1.

Name 2 Confidence Ratio

Text

Confidence Ratio between 0 and 1000 of the OCR captured Name 2.

Owner

Lookup

Salesforce User ID assigned as owner of the Check Capture Submission Record.

Payer Name 1

Text

OCR Captured Payer Name on Check.

Payer Name 2

Text

OCR Captured Payer Name 2 on Check.

Payer Phone

Text

OCR Captured Phone Number on Check.

Payer PO Box

Text

OCR Captured PO Box on Check.

Payer State

Text

OCR Captured State on Check.

Payer Street

Text

OCR Captured Street on Check.

Payer ZIP Code

Text

OCR Captured Zip Code on Check.

PO Box Confidence Ratio

Text

Confidence Ratio between 0 and 1000 of the OCR captured PO Box.

Rear of Check Processing time

Text

Time in which it took the image processor to respond on submission of rear check image.

Temporary Id

Text

Temporary ID provided by Image Processor on submission of Front Check Image. Used in submission of Rear Check Image for cropping purposes.

Usability Courtesy Amount

Checkbox

Indicative of whether Courtesy Amount is present on Check.

Usability Date

Checkbox

Indicative of whether Date is present on Check.

Usability Integrity Test

Checkbox

Indicative of whether the Check has passed Integrity Testing.

Usability Legal Amount

Checkbox

Indicative of whether Legal Amount is present on Check.

Usability Micr Line

Checkbox

Indicative of whether the MICR line is present on Check.

Usability Payee

Checkbox

Indicative of whether the Payee is present on Check.

Usability Payor Name and Address

Checkbox

Indicative of whether Payer Name and Address is present on Check.

Usability Signature

Checkbox

Indicative of whether the signature is present on Check