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:
- Check Capture Submission Object
- 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 |
Updated over 1 year ago