Onboarding Status
This report captures status information of all applications / accounts for ISVs during the onboarding process. It provides the status information across the onboarding journey at any given point until the account is Enabled for processing. Further, ISVs can develop the merchant onboarding pipeline and conduct appropriate analysis utilizing reports.
The report also captures the following statuses:
- Simplified Onboarding App form (before the application is submitted): Registration pending’, ‘Business info pending’, ‘Owner Info pending’, ‘KYC check pending’, ‘Bank Info Pending’, ‘Bank Documents Pending’, and ‘Submit Pending’ (Note: there is no Submitted status, the next status will be ‘Processing group compliance’ – see below).
- Credit Underwriting (after the merchant application is submitted): ‘Processing’, ‘Rejected’, ‘Withdrawn’, ‘Approved’, ‘Enabled’, ‘Disabled’.
Creation Date
This report processes two sets of data - a) Before the merchant application is submitted b) After the merchant application is submitted. The creation date definition varies for these two sets of data.
- CREATION_DATE (before the merchant application is submitted): If the merchant application is not submitted, the creation date corresponds to the day when the application was first accessed by the merchant.
- CREATION_DATE (after the merchant application is submitted): Once the merchant application is submitted, the creation date corresponds to the day when the merchant application is actually submitted.
There are a number of fields that get populated only after the merchant application is submitted. These fields will have the value "NA" before the merchant application is submitted: (PRODUCT_NAME,PRODUCT_ID,ACCOUNT_ID,ACCOUNT_NAME,LEGAL NAME, COUNTRY, PROCESSING_CURRENCY, BUSINESS_CATEGORY, LAST_COMMENT_ENTERED, ON_HOLD_INDICATOR, ON_HOLD_REASON_CODE, ON_HOLD_REASON, NOTE, AMEX_MID, PROCESSING_TYPE, AGENT_PROFILE_1, AGENT_PROFILE_2, DEFAULT_BANK, ENABLED_DATE)
By default the report returns data for CREATION_DATE = (Current date (UTC) - 30 day) to Current date
Column | Column Header Description | Definition | Data Type | Sample Value |
---|---|---|---|---|
A | APPLICATION_ID | This is the unique number created for the merchant application | String | XYZ123 |
B | PARTNER_NAME | Name of the ISV Partner | String | XYZ Ltd |
C | PARTNER_ID | ID number of the ISV Partner | String | 1020 |
D | PRODUCT_NAME | ISV Partner Product Name (Product = Payfac Link or Account Management API) | String | Rentmoola-DD |
E | PRODUCT_ID | ID number of the Product page in Geneva/Netbanx | String | 38012 |
F | ACCOUNT_ID | FMA # of the account boarded | String | 1002584542 |
G | ACCOUNT_NAME | DBA name of the account boarded | String | Test Name |
H | CREATION_DATE | Date when the FMA was created / Date the Application was started | String | 2019-11-28 17:51:18.0 |
I | LEGAL_NAME | Legal name of the account boarded | String | Confidential |
J | COUNTRY | Country of the account boarded | String | CANADA |
K | PROCESSING_CURRENCY | Processing currency of the account boarded | String | CAD |
L | BUSINESS_CATEGORY | MCC (Merchant Category Code) of the account boarded | String | 6513 REAL ESTATE AGENTS AND MANAGERS-RENTALS |
M | STATUS | Status | String | Enabled |
N | LAST_COMMENT_ENTERED | Comments from Ops or Risk team | String | See notes |
O | ON_HOLD_INDICATOR | Notates if there are Payment Holds | String | N |
P | ON_HOLD_REASON_CODE | Reason code for Hold | String | RMD |
Q | ON_HOLD_REASON | Hold Reason code definition | String | Require Micro Deposit |
R | NOTE | Additional Notes | String | Response attached |
S | AMEX_MID | Amex MID provided | String | 999999999 |
T | PROCESSING_TYPE | Notates Credit Card (CC) or Direct Debit (DD) account | String | DD |
U | AGENT_PROFILE_1 | Agents that are tagged to the FMA | String | |
V | AGENT_PROFILE_2 | Agents that are tagged to the FMA | String | |
W | DEFAULT_BANK | Sponsor Bank | String | BMO |
X | ENABLED_DATE | Date the account was set to Enabled status | Enabled | 2019-12-06 11:26:31.0 |