| client_id |
MANTL identifier for the client financial institution. |
STRING
|
Data Export, Console, Direct SQL |
| application_created_at |
Timestamp of when the application was created in 24-hour format YYYY-MM-DD HH:MM:SS |
TIMESTAMP
|
Data Export, Console, Direct SQL |
| application_submitted_at |
Timestamp of when the application was first submitted in the 24-hour format YYYY-MM-DD HH:MM:SS |
TIMESTAMP
|
Data Export, Console, Direct SQL |
| application_first_assigned_at |
Timestamp of when the application was first assigned to an assignee in the 24-hour format YYYY-MM-DD HH:MM:SS |
TIMESTAMP
|
Data Export, Console, Direct SQL |
| account_created_at |
Timestamp of when the application was booked in the 24-hour format YYYY-MM-DD HH:MM:SS |
TIMESTAMP
|
Data Export, Console, Direct SQL |
| application_last_updated_at |
Last Modified Timestamp. Timestamp of when the application was last updated in the 24-hour format YYYY-MM-DD HH:MM:SS |
TIMESTAMP
|
Data Export, Console, Direct SQL |
| handoff_last_sent_at |
Timestamp of the last time a handoff was sent to the account owner. Displayed in the 24-hour format YYYY-MM-DD HH:MM:SS |
TIMESTAMP
|
Data Export, Console, Direct SQL |
| application_last_reviewed_at |
Timestamp of the last time the application went through a KYC review. Displayed in the 24-hour format YYYY-MM-DD HH:MM:SS |
TIMESTAMP
|
Data Export, Console, Direct SQL |
| application_canceled_at |
Timestamp of when the application was canceled (if applicable) in the 24-hour format YYYY-MM-DD HH:MM:SS |
TIMESTAMP
|
Data Export, Console, Direct SQL |
| application_id |
Unique MANTL identifier for the application. |
STRING
|
Data Export, Console, Direct SQL |
| application_type |
The type of application created. [Create Account, Add Authorized Signer, Update Persons] |
STRING
|
Data Export, Console, Direct SQL |
| reference_id |
Primary Key. Unique MANTL identifier for the account-application. |
STRING
|
Data Export, Console, Direct SQL |
| account_type |
The type of account that the application relates to. |
STRING
|
Data Export, Console, Direct SQL |
| is_bulk_application |
True/False whether or not an application would open multiple accounts when booked |
BOOLEAN
|
Data Export, Console, Direct SQL |
| account_variant |
The raw account variant type or the label of the account variant designated by the client. |
STRING
|
Data Export, Console, Direct SQL |
| product_type |
Type of product the applicant has selected. [Checking, Savings, CD] |
STRING
|
Data Export, Console, Direct SQL |
| product_name |
Name of the product that is being applied for on this application. |
STRING
|
Data Export, Console, Direct SQL |
| major_code |
Product major code. |
STRING
|
Data Export, Console, Direct SQL |
| minor_code |
Product minor code. |
STRING
|
Data Export, Console, Direct SQL |
| assignee_id |
MANTL unique identifier for someone set as the assignee for an application. |
STRING
|
Data Export, Console, Direct SQL |
| assignee_name |
Application assignee full name. |
STRING
|
Data Export, Console, Direct SQL |
| originating_branch_code |
The internal code of the originating branch |
STRING
|
Data Export, Console, Direct SQL |
| primary_officer_name |
The name of application's primary officer at the financial institution |
STRING
|
Data Export, Console, Direct SQL |
| primary_officer_code |
The internal code of the primary officer at the financial institution |
STRING
|
Data Export, Console, Direct SQL |
| application_status |
Current status of the application. [Not Submitted, Action Required, Manual Review Required, Approved, Booking Pending, Review Processing, Awaiting Booking Retry, Booking Processing, Rejected, Booked, Canceled] |
STRING
|
Data Export, Console, Direct SQL |
| cancellation_reason |
The reason for the application's cancellation. Empty if the application was not cancelled. |
STRING
|
Data Export, Console, Direct SQL |
| application_approval_type |
The type of approval that the application has received. Ex. ['Automated', 'Manual'] |
STRING
|
Data Export, Console, Direct SQL |
| application_is_submitted |
Indicates whether an application is submitted. [Yes, No] |
BOOLEAN
|
Data Export, Console, Direct SQL |
| account_is_created |
Indicates whether an application is booked. [Yes, No] |
BOOLEAN
|
Data Export, Console, Direct SQL |
| application_is_cancelled |
Indicates whether an application is booked. [Yes, No] |
BOOLEAN
|
Data Export, Console, Direct SQL |
| required_actions |
The list of items remaining on the Checklist that must be addressed before submitting the application. Ex. Missing Signatures, Missing Attestations, Missing Entity Fields |
STRING
|
Data Export, Console, Direct SQL |
| bypass_required_actions |
Yes or No regarding whether or not the application was submitted with overrides. |
STRING
|
Data Export, Console, Direct SQL |
| kyc_outcome |
Most recent KYC outcome for the application. [Approved, Rejected, Manual Review] |
STRING
|
Data Export, Console, Direct SQL |
| kyc_summary_tags |
List of summary tags returned from KYC evaluation. Ex. KYC Address Match, KYC Name Match |
STRING
|
Data Export, Console, Direct SQL |
| initial_kyc_outcome |
The initial KYC Outcome for the application. Ex. [Approved, Rejected, Manual Review] |
STRING
|
Data Export, Console, Direct SQL |
| kyc_approval_type |
Indicates whether an application was approved or denied without any human intervention (automated) or was manually reviewed. Ex. [Automated, Manual] |
STRING
|
Data Export, Console, Direct SQL |
| manual_evaluator_name |
PII. Name of individual that manually reviewed the application. |
STRING
|
Data Export, Console, Direct SQL |
| kyc_manual_review_notes |
Notes submitted during the manual review. |
STRING
|
Data Export, Console, Direct SQL |
| funding_method |
The type of funding input used for the initial deposit. [Instant Account Verification, Manual Entry, Debit Card, Internal Transfer] |
STRING
|
Data Export, Console, Direct SQL |
| funding_amount |
The amount of the initial funding in cents. |
FLOAT64
|
Data Export, Console, Direct SQL |
| manual_funding_notes |
The notes entered by the banker when a user funds manually in the branch |
STRING
|
Data Export, Console, Direct SQL |
| documents_uploaded |
List of documents uploaded by the applicant. |
STRING
|
Data Export, Console, Direct SQL |
| originating_experience |
Indicates if the application was started from the self-service flow, or from the MANTL Admin Console. [Online, In-Branch] |
STRING
|
Data Export, Console, Direct SQL |
| initial_session_id |
Identifier for the applicant's origin browser session which resulted in the acquisition data collection. |
STRING
|
Data Export, Console, Direct SQL |
| ip_address |
PII. The IP address for applications that originated online. |
STRING
|
Data Export, Console, Direct SQL |
| entrance_url__first_touch |
The origin URL for the applicant's first touch acquisition capture that led to additional behavior. |
STRING
|
Data Export, Console, Direct SQL |
| entrance_url__last_non_direct_touch |
The origin URL for the applicant's last non-direct touch acquisition capture that led to additional behavior. |
STRING
|
Data Export, Console, Direct SQL |
| promo_code |
The promo code from a campaign that was used and resulted in an application. |
STRING
|
Data Export, Console, Direct SQL |
| number_of_sessions |
Number of unique sessions until an application was submitted, for applications that originated online. |
INTEGER
|
Data Export, Console, Direct SQL |
| time_to_submit_application |
Time elapsed in minutes from when an application was created to when it was submitted. |
FLOAT64
|
Data Export, Console, Direct SQL |
| time_in_queue |
Time elapsed in minutes from when an application was created to when it was first assigned. Ex. 4.91 |
FLOAT64
|
Data Export, Console, Direct SQL |
| account_id |
Unique identifier for created accounts. |
STRING
|
Data Export, Console, Direct SQL |
| account_number |
PII. The new account number for an application that results in a booked account. Empty if the application didn't result in an account opening. |
STRING
|
Data Export, Console, Direct SQL |
| person_id |
MANTL unique identifier for the applicant. |
STRING
|
Data Export, Console, Direct SQL |
| person_core_id |
Applicant ID found in the financial institution's core. This is only included for applications successfully booked to the core. |
STRING
|
Data Export, Console, Direct SQL |
| is_application_with_existing_customer |
Indicator of whether an organization is an existing customer by checking if their org ID exists in the core. |
BOOLEAN
|
Data Export, Console, Direct SQL |
| is_new_membership |
A true/false value. 'true' indicates that our application created a new credit union membership for the applicant in the course of processing the application. Only populated for booked accounts. |
BOOLEAN
|
Console, Direct SQL |
| person_age |
Person age in years. |
INTEGER
|
Data Export, Console, Direct SQL |
| first_name |
The first name of the applicant, as entered by them on the application. |
STRING
|
Data Export, Console, Direct SQL |
| primary_address_city |
Person primary address city. |
STRING
|
Data Export, Console, Direct SQL |
| last_name |
The last name of the applicant, as entered by them on the application. |
STRING
|
Data Export, Console, Direct SQL |
| primary_address_state |
Person primary address state. |
STRING
|
Data Export, Console, Direct SQL |
| social_security_number |
PII. Person social security number. |
STRING
|
Data Export, Console, Direct SQL |
| person_date_of_birth |
PII. Person date of birth. |
STRING
|
Data Export, Console, Direct SQL |
| primary_address_zip_code |
Person primary address zip code. |
STRING
|
Data Export, Console, Direct SQL |
| additional_identification |
Additional identification methods provided by the applicant. |
STRING
|
Data Export, Console, Direct SQL |
| state_of_issue |
State of issue for additional identification method. |
STRING
|
Data Export, Console, Direct SQL |
| person_email_address |
PII. Person email address. |
STRING
|
Data Export, Console, Direct SQL |
| mobile_telephone |
PII. Person mobile telephone number. |
STRING
|
Data Export, Console, Direct SQL |
| issue_date |
Issue date of additional identification method. |
STRING
|
Data Export, Console, Direct SQL |
| expiration_date |
Expiration date of additional identification method. |
STRING
|
Data Export, Console, Direct SQL |
| primary_address_line_1 |
PII. Person primary address line one. |
STRING
|
Data Export, Console, Direct SQL |
| source_of_wealth |
Person source of wealth. |
STRING
|
Data Export, Console, Direct SQL |
| primary_address_line_2 |
PII. Person primary address line two. |
STRING
|
Data Export, Console, Direct SQL |
| occupation |
Person occupation details. |
STRING
|
Data Export, Console, Direct SQL |
| occupation_description |
The description of the applicant's occupation, as entered by them on the application. |
STRING
|
Data Export, Console, Direct SQL |
| title |
Title of person completing the application. |
STRING
|
Data Export, Console, Direct SQL |
| ownership_percentage |
Ownership percentage of the person completing the application. |
FLOAT64
|
Data Export, Console, Direct SQL |
| identification_id |
PII. ID number provided for additional identification method. |
STRING
|
Data Export, Console, Direct SQL |
| is_politically_exposed |
Enhanced due diligence field that indicates whether a person is politically exposed. [Yes, No] |
STRING
|
Data Export, Console, Direct SQL |
| politically_exposed_name_of_related_official |
Name of the politically exposed person to whom the applicant is related |
STRING
|
Data Export, Console, Direct SQL |
| us_residency_status |
US residency status of the applicant. [US Citizen, Permanent Resident, Non-Resident Alien] |
STRING
|
Data Export, Console, Direct SQL |
| politically_exposed_public_office_country |
Country of the public office of the politically exposed person to whom the applicant is related |
STRING
|
Data Export, Console, Direct SQL |
| politically_exposed_relationship_to_official |
Relationship of the applicant to the politically exposed person |
STRING
|
Data Export, Console, Direct SQL |
| organization_id |
MANTL system's unique identifier of the business that is applying for an account. |
STRING
|
Data Export, Console, Direct SQL |
| organization_core_id |
The core's unique identifier of the business that is applying for an account. This will only be populated if it is an existing customer of the financial institution applying for an account. |
STRING
|
Data Export, Console, Direct SQL |
| organization_type |
The type of business that is applying for an account. |
STRING
|
Data Export, Console, Direct SQL |
| organization_tax_id |
The EIN of a business applying for an account. This will be SSN if sole proprietor. |
STRING
|
Data Export, Console, Direct SQL |
| description_of_business |
The description of the business entered in the application. |
STRING
|
Data Export, Console, Direct SQL |
| business_address_city |
Business primary address city. |
STRING
|
Data Export, Console, Direct SQL |
| business_address_state |
Business primary address state. |
STRING
|
Data Export, Console, Direct SQL |
| business_address_zip_code |
Business primary address zip code. |
STRING
|
Data Export, Console, Direct SQL |
| industry_classification_naics |
The NAICS description and code of the business. |
STRING
|
Data Export, Console, Direct SQL |
| number_of_employees |
The number of employees at the business. |
STRING
|
Data Export, Console, Direct SQL |
| number_of_locations |
The number of business locations. |
STRING
|
Data Export, Console, Direct SQL |
| organization_legal_name |
PII. The full legal name of the business that is applying for an account. |
STRING
|
Data Export, Console, Direct SQL |
| is_nonprofit |
Yes or No regarding whether or not the business is a non-profit (if applicable). Ex. [Yes, No] |
STRING
|
Data Export, Console, Direct SQL |
| is_commercial_real_estate |
Yes or No regarding whether or not the primary business function is commercial real estate (if applicable). Ex. [Yes, No] |
STRING
|
Data Export, Console, Direct SQL |
| is_marijuana_related_business |
Yes or No regarding whether or not the business is marijuana or cannabis-related (if applicable). Ex. [Yes, No] |
STRING
|
Data Export, Console, Direct SQL |
| organization_dba |
PII. Doing Business As (DBA) name of the business that is applying for an account. |
STRING
|
Data Export, Console, Direct SQL |
| is_cash_intensive_business |
Yes or No regarding whether or not the business is cash intensive (if applicable). Ex. [Yes, No] |
STRING
|
Data Export, Console, Direct SQL |
| cash_intensive_business_type |
Type of cash-intensive business if applicable. Ex. Restaurants, Bars, Dry Cleaning, etc. |
STRING
|
Data Export, Console, Direct SQL |
| date_established |
PII. The date on which the business was established. |
STRING
|
Data Export, Console, Direct SQL |
| is_nonbanking_financial_institution |
Yes or No regarding whether or not the business is a non-banking financial institution (if applicable). Ex. [Yes, No] |
STRING
|
Data Export, Console, Direct SQL |
| business_website_url |
PII. The website URL of the business. |
STRING
|
Data Export, Console, Direct SQL |
| is_professional_services_provider |
Yes or No regarding whether or not the business is a provider of professional services (if applicable). Ex. [Yes, No] |
STRING
|
Data Export, Console, Direct SQL |
| is_designating_power_of_attorney |
Yes or No regarding whether or not the business is planning to grant power of attorney over this account to another party. Ex. [Yes, No] |
STRING
|
Data Export, Console, Direct SQL |
| business_address_line_1 |
PII. Business primary address line one. |
STRING
|
Data Export, Console, Direct SQL |
| business_address_line_2 |
PII. Business primary address line two. |
STRING
|
Data Export, Console, Direct SQL |
| purpose_of_account |
Purpose of the account as entered in the application. Ex. Payroll |
STRING
|
Data Export, Console, Direct SQL |
| expected_frequency_of_deposits |
The expected frequency of deposits. Ex. Weekly |
STRING
|
Data Export, Console, Direct SQL |
| expected_deposit_method |
The expected method of deposits. Ex. Domestic Wire Transfer |
STRING
|
Data Export, Console, Direct SQL |
| does_expect_cash_activity |
The expected cash activity for the account. Ex. [Yes, No] |
STRING
|
Data Export, Console, Direct SQL |
| does_expect_cash_deposits |
Yes or No regarding whether or not the business expects cash deposits (if applicable). Ex. [Yes, No] |
STRING
|
Data Export, Console, Direct SQL |
| expected_cash_deposit_volume |
The expected monthly cash deposit volume of the business. Ex. $50,001 - 250,000 |
STRING
|
Data Export, Console, Direct SQL |
| state_bar_info |
The state bar information for the business. |
STRING
|
Console, Direct SQL |
| does_expect_cash_withdrawals |
Yes or No regarding whether or not the business expects cash withdrawals (if applicable). Ex. [Yes, No] |
STRING
|
Data Export, Console, Direct SQL |
| expected_cash_withdrawal_volume |
The expected monthly cash withdrawal volume of the business. Ex. $50,001 - 250,000 |
STRING
|
Data Export, Console, Direct SQL |
| does_expect_check_activity |
Yes or No regarding whether or not the business expects check activity (if applicable). Ex. [Yes, No] |
STRING
|
Data Export, Console, Direct SQL |
| does_expect_check_deposits |
Yes or No regarding whether or not the business expects check deposits (if applicable). Ex. [Yes, No] |
STRING
|
Data Export, Console, Direct SQL |
| expected_check_deposit_volume |
The expected monthly check deposit volume of the business. Ex. $50,001 - 250,000 |
STRING
|
Data Export, Console, Direct SQL |
| does_expect_check_withdrawals |
Yes or No regarding whether or not the business expects check withdrawals (if applicable). Ex. [Yes, No] |
STRING
|
Data Export, Console, Direct SQL |
| expected_check_withdrawal_volume |
The expected monthly check withdrawal volume of the business. Ex. $50,001 - 250,000 |
STRING
|
Data Export, Console, Direct SQL |
| does_expect_internal_transfer_activity |
Yes or No regarding whether or not the business expects internal transfer activity (if applicable). Ex. [Yes, No] |
STRING
|
Data Export, Console, Direct SQL |
| does_expect_internal_deposits |
Yes or No regarding whether or not the business expects internal deposits (if applicable). Ex. [Yes, No] |
STRING
|
Data Export, Console, Direct SQL |
| expected_internal_deposit_volume |
The expected monthly internal deposit volume of the business. Ex. $50,001 - 250,000 |
STRING
|
Data Export, Console, Direct SQL |
| internal_deposit_account_details |
Account details for internal deposits. |
STRING
|
Data Export, Console, Direct SQL |
| purpose_of_internal_deposits |
The purpose of the account. Ex. Savings |
STRING
|
Data Export, Console, Direct SQL |
| does_expect_internal_withdrawals |
Yes or No regarding whether or not the business expects internal withdrawals (if applicable). Ex. [Yes, No] |
STRING
|
Data Export, Console, Direct SQL |
| expected_internal_withdrawals_volume |
The expected monthly internal withdrawal volume of the business. Ex. $50,001 - 250,000 |
STRING
|
Data Export, Console, Direct SQL |
| internal_withdrawals_account_details |
Account details for internal withdrawals. |
STRING
|
Data Export, Console, Direct SQL |
| purpose_of_internal_withdrawals |
The purpose of the account. Ex. Cash Purchases |
STRING
|
Data Export, Console, Direct SQL |
| does_expect_ach_origination_activity |
Yes or No regarding whether or not the business expects ACH origination activity (if applicable). Ex. [Yes, No] |
STRING
|
Data Export, Console, Direct SQL |
| does_expect_ach_origination_deposits |
Yes or No regarding whether or not the business expects ACH origination deposits (if applicable). Ex. [Yes, No] |
STRING
|
Data Export, Console, Direct SQL |
| expected_ach_origination_deposit_volume |
The expected monthly ACH origination deposit volume of the business. Ex. $50,001 - 250,000 |
STRING
|
Data Export, Console, Direct SQL |
| does_expect_ach_origination_withdrawals |
Yes or No regarding whether or not the business expects ACH origination withdrawals (if applicable). Ex. [Yes, No] |
STRING
|
Data Export, Console, Direct SQL |
| expected_ach_origination_withdrawal_volume |
The expected monthly ACH origination withdrawal volume of the business. Ex. $50,001 - 250,000 |
STRING
|
Data Export, Console, Direct SQL |
| does_expect_ach_transfer_activity |
Yes or No regarding whether or not the business expects ACH ACH transfer activity (if applicable). Ex. [Yes, No] |
STRING
|
Data Export, Console, Direct SQL |
| does_expect_domestic_ach_deposits |
Yes or No regarding whether or not the business expects domestic ACH deposits (if applicable). Ex. [Yes, No] |
STRING
|
Data Export, Console, Direct SQL |
| expected_domestic_ach_deposit_volume |
The expected monthly domestic ACH deposit volume of the business. Ex. $50,001 - 250,000 |
STRING
|
Data Export, Console, Direct SQL |
| does_expect_domestic_ach_withdrawals |
Yes or No regarding whether or not the business expects domestic ACH withdrawals (if applicable). Ex. [Yes, No] |
STRING
|
Data Export, Console, Direct SQL |
| expected_domestic_ach_withdrawal_volume |
The expected monthly domestic ACH withdrawal volume of the business. Ex. $50,001 - 250,000 |
STRING
|
Data Export, Console, Direct SQL |
| does_expect_foreign_ach_deposits |
Yes or No regarding whether or not the business expects foreign ACH deposits (if applicable). Ex. [Yes, No] |
STRING
|
Data Export, Console, Direct SQL |
| expected_foreign_ach_deposit_volume |
The expected monthly foreign ACH deposit volume of the business. Ex. $50,001 - 250,000 |
STRING
|
Data Export, Console, Direct SQL |
| expected_number_of_foreign_ach_deposits |
The expected number of monthly foreign ACH deposits. Ex. 2 |
STRING
|
Data Export, Console, Direct SQL |
| expected_foreign_deposit_ach_countries_involved |
The expected countries involved for foreign deposits, Ex. UK, FR, SP |
STRING
|
Data Export, Console, Direct SQL |
| does_expect_foreign_ach_withdrawals |
Yes or No regarding whether or not the business expects foreign ACH withdrawals (if applicable). Ex. [Yes, No] |
STRING
|
Data Export, Console, Direct SQL |
| expected_foreign_ach_withdrawal_volume |
The expected monthly foreign ACH withdrawal volume of the business. Ex. $50,001 - 250,000 |
STRING
|
Data Export, Console, Direct SQL |
| expected_number_of_foreign_ach_withdrawals |
The expected number of monthly foreign ACH withdrawals. Ex. 2 |
STRING
|
Data Export, Console, Direct SQL |
| expected_foreign_withdrawal_ach_countries_involved |
The expected countries involved for foreign deposits, Ex. UK, FR, SP |
STRING
|
Data Export, Console, Direct SQL |
| does_expect_wire_transfer_activity |
Yes or No regarding whether or not the business expects wire activity (if applicable). Ex. [Yes, No] |
STRING
|
Data Export, Console, Direct SQL |
| does_expect_domestic_wire_deposits |
Yes or No regarding whether or not the business expects domestic wire deposits (if applicable). Ex. [Yes, No] |
STRING
|
Data Export, Console, Direct SQL |
| expected_monthly_domestic_wire_deposit_volume |
The expected monthly domestic wire deposit volume of the business. Ex. $50,001 - 250,000 |
STRING
|
Data Export, Console, Direct SQL |
| purpose_of_domestic_wire_deposits |
The purpose of the domestic wire deposits. Ex. Purchase orders |
STRING
|
Data Export, Console, Direct SQL |
| does_expect_domestic_wire_withdrawals |
Yes or No regarding whether or not the business expects domestic wire withdrawals (if applicable). Ex. [Yes, No] |
STRING
|
Data Export, Console, Direct SQL |
| expected_domestic_wire_withdrawal_volume |
The monthly expected domestic wire withdrawal volume of the business. Ex. $50,001 - 250,000 |
STRING
|
Data Export, Console, Direct SQL |
| purpose_of_domestic_wire_withdrawals |
The purpose of domestic wire withdrawals. Ex. Purchase orders |
STRING
|
Data Export, Console, Direct SQL |
| does_expect_foreign_wire_deposits |
Yes or No regarding whether or not the business expects foreign wire transfer deposits (if applicable). Ex. [Yes, No] |
STRING
|
Data Export, Console, Direct SQL |
| expected_foreign_wire_deposit_volume |
The monthly expected foreign wire transfer deposit volume of the business. Ex. $50,001 - 250,000 |
STRING
|
Data Export, Console, Direct SQL |
| expected_number_of_foreign_wire_transfer_deposits |
The expected number of monthly foreign wire transfer deposits. Ex. 2 |
STRING
|
Data Export, Console, Direct SQL |
| expected_foreign_deposit_wire_transfers_countries_involved |
The expected countries involved for foreign wire transfer deposits. Ex. UK, FR, SP |
STRING
|
Data Export, Console, Direct SQL |
| purpose_of_foreign_wire_transfer_deposits |
The purpose of foreign wire transfer deposits. Ex. Foreign Affairs |
STRING
|
Data Export, Console, Direct SQL |
| does_expect_foreign_wire_withdrawals |
Yes or No regarding whether or not the business expects foreign wire transfer withdrawals (if applicable). Ex. [Yes, No] |
STRING
|
Data Export, Console, Direct SQL |
| expected_foreign_wire_withdrawal_volume |
The monthly expected foreign wire transfer withdrawal volume of the business. Ex. $50,001 - 250,000 |
STRING
|
Data Export, Console, Direct SQL |
| expected_number_of_foreign_wire_transfer_withdrawals |
The expected number of monthly foreign wire transfer withdrawals. Ex. 2 |
STRING
|
Data Export, Console, Direct SQL |
| expected_foreign_withdrawal_wire_transfers_countries_involved |
The expected countries involved for foreign wire transfer withdrawals. Ex. UK, FR, SP |
STRING
|
Data Export, Console, Direct SQL |
| purpose_of_foreign_wire_transfer_withdrawals |
The purpose of foreign wire transfer withdrawals. Ex. Foreign Affairs |
STRING
|
Data Export, Console, Direct SQL |
| does_expect_remote_deposits |
Yes or No regarding whether or not the business expects remote deposits (if applicable). Ex. [Yes, No] |
STRING
|
Data Export, Console, Direct SQL |
| expected_remote_deposit_volume |
The monthly expected remote deposit volume of the business. Ex. $50,001 - 250,000 |
STRING
|
Data Export, Console, Direct SQL |
| is_involved_in_digital_currency |
Yes or No regarding whether the business is involved in digital currency. |
BOOLEAN
|
Data Export, Console, Direct SQL |
| is_money_service_business |
Yes or No regarding whether the business transmits or converts money. |
BOOLEAN
|
Data Export, Console, Direct SQL |
| is_has_relationships_with_foreign_shell_banks |
Yes or No regarding whether the business has relationships with foreign shell banks. |
BOOLEAN
|
Data Export, Console, Direct SQL |
| is_has_private_banking_relationships_with_pep_or_nras |
Yes or No regarding whether the business has private banking relationships with Politically Exposed Persons or Non-Resident Aliens. |
BOOLEAN
|
Data Export, Console, Direct SQL |
| is_third_party_service_provider |
Yes or No regarding whether the business is a third-party service provider. |
BOOLEAN
|
Data Export, Console, Direct SQL |
| is_does_third_party_payment_processing |
Yes or No regarding whether the business does third-party payment processing. |
BOOLEAN
|
Data Export, Console, Direct SQL |
| is_owned_by_a_foreign_entity_or_individual |
Yes or No regarding whether the business is owned by a foreign entity or individual. |
BOOLEAN
|
Data Export, Console, Direct SQL |
| purpose_of_account_other_description_business |
Purpose of account description for "other" |
STRING
|
Data Export, Console, Direct SQL |
| is_publicly_traded |
Yes or No regarding whether the business is publicly traded. |
BOOLEAN
|
Data Export, Console, Direct SQL |
| ticker_symbol |
Ticker symbol for the business if it is publicly traded. |
STRING
|
Data Export, Console, Direct SQL |
| ngo_type |
Type of Non-Governmental Organization if applicable. |
STRING
|
Data Export, Console, Direct SQL |
| ngo_purpose_description |
Purpose of Non-Governmental Organization if applicable. |
STRING
|
Data Export, Console, Direct SQL |
| geographical_impact_of_ngo |
Geographical impact of Non-Governmental Organization if applicable. |
STRING
|
Data Export, Console, Direct SQL |
| ngo_funding_description |
Description of NGO funding if applicable. |
STRING
|
Data Export, Console, Direct SQL |
| ngo_source_of_funds_description |
Description of source of NGO funds if applicable. |
STRING
|
Data Export, Console, Direct SQL |
| ngo_disbursement_criteria_description |
NGO disbursement criteria if applicable. |
STRING
|
Data Export, Console, Direct SQL |
| provider_of_professional_services_type |
Provider of professional services type if applicable. |
STRING
|
Data Export, Console, Direct SQL |
| provider_of_professional_services_type_other_description |
Description of the provider of professional services if type 'Other' was selected |
STRING
|
Data Export, Console, Direct SQL |
| cash_intensive_business_type_description |
Type of cash-intensive business description if applicable. |
STRING
|
Data Export, Console, Direct SQL |
| atm_total_count |
Total count of ATMs operated by the business. |
STRING
|
Data Export, Console, Direct SQL |
| atm_location_description |
Description of ATM locations. |
STRING
|
Data Export, Console, Direct SQL |
| is_are_atm_accounts_with_bank |
Yes or No regarding whether the ATM accounts are with the bank. |
BOOLEAN
|
Data Export, Console, Direct SQL |
| is_does_customer_replenish_atm |
Yes or No regarding whether the customer replenishes the ATM(s). |
BOOLEAN
|
Data Export, Console, Direct SQL |
| nonbank_financial_institution_type |
Nonbank financial institution type if applicable. |
STRING
|
Data Export, Console, Direct SQL |
| is_has_purchased_50k_plus_of_precious_goods |
Yes or No regarding whether the business has purchased $50k+ of precious goods. |
BOOLEAN
|
Data Export, Console, Direct SQL |
| is_has_received_50k_plus_of_precious_goods |
Yes or No regarding whether the business has recieved $50k+ of precious goods. |
BOOLEAN
|
Data Export, Console, Direct SQL |
| is_does_nonbank_financial_institution_conduct_due_diligence |
Yes or No regarding whether the non-bank financial institution conducts due diligence if applicable. |
BOOLEAN
|
Data Export, Console, Direct SQL |
| is_does_nonbank_financial_institution_review_client_source_of_wealth |
Yes or No regarding whether the non-bank financial institution reviews client source of wealth if applicable. |
BOOLEAN
|
Data Export, Console, Direct SQL |
| is_does_nonbank_financial_institution_screen_clients_in_ofac_list |
Yes or No regarding whether the non-bank financial institution screens clients in the Office of Foreign Assets Control list if applicable. |
BOOLEAN
|
Data Export, Console, Direct SQL |
| is_has_aml_procedures_for_nonbank_financial_institution |
Yes or No regarding whether the non-bank financial institution has Anti-Money Laundering procedures if applicable. |
BOOLEAN
|
Data Export, Console, Direct SQL |
| nonbank_financial_institution_description |
Description of the non-bank financial institution if applicable. |
STRING
|
Data Export, Console, Direct SQL |
| is_involved_directly_in_marijuana_trade |
Yes or No regarding whether the business is involved directly in the marijuana trade. |
BOOLEAN
|
Data Export, Console, Direct SQL |
| atms_leased_or_owned |
Whether the ATMs operated by the business are leased or owned. |
STRING
|
Data Export, Console, Direct SQL |
| is_has_atms_on_site |
True or false value indicating the customers response to the qustion regarding the presence of ATMs on-site regarding whether the business has ATMs on site. |
BOOLEAN
|
Data Export, Console, Direct SQL |
| registration_state |
The state in which the business is registered. |
STRING
|
Data Export, Console, Direct SQL |
| registration_country |
The country in which the business is registered. |
STRING
|
Data Export, Console, Direct SQL |
| atm_replenish_method |
The method by which the ATMs are replenished, Ex Cash-on-Hand, etc. |
STRING
|
Data Export, Console, Direct SQL |
| is_has_aml_officer_for_nonbank_financial_institution |
Yes or No regarding whether the non-bank financial institution has an Anti-Money Laundering officer if applicable. |
BOOLEAN
|
Data Export, Console, Direct SQL |
| is_has_aml_training_for_nonbank_financial_institution |
Yes or No regarding whether the non-bank financial institution has Anti-Money Laundering training if applicable. |
BOOLEAN
|
Data Export, Console, Direct SQL |
| source_of_cash |
The source of cash for the business. |
STRING
|
Data Export, Console, Direct SQL |
| first_name_md5 |
MD5-hash of the first name of the applicant, as entered by them on the application. |
STRING
|
Direct SQL |
| first_name_sha256 |
SHA-256-hash of the first name of the applicant, as entered by them on the application. |
STRING
|
Direct SQL |
| last_name_md5 |
MD5-hash of the last name of the applicant, as entered by them on the application. |
STRING
|
Direct SQL |
| last_name_sha256 |
SHA-256-hash of the last name of the applicant, as entered by them on the application. |
STRING
|
Direct SQL |
| person_email_address_md5 |
The MD5 hash of the person email address. |
STRING
|
Direct SQL |
| person_email_address_sha256 |
The SHA-256 hash of the person email address. |
STRING
|
Direct SQL |
| mobile_telephone_md5 |
The MD5 hash of applicant's mobile phone number, as entered by them on the application. |
STRING
|
Direct SQL |
| mobile_telephone_sha256 |
The SHA-256 hash of applicant's mobile phone number, as entered by them on the application. |
STRING
|
Direct SQL |
| primary_address_zip_code_md5 |
The MD5 hash of the zip code of the primary address of the applicant, as entered by them on the application. |
STRING
|
Direct SQL |
| primary_address_zip_code_sha256 |
The SHA-256 hash of the zip code of the primary address of the applicant, as entered by them on the application. |
STRING
|
Direct SQL |
| marketing_channel__first_touch |
Marketing Channel derived from a user's first known interaction with an FI's website. |
STRING
|
Data Export, Console, Direct SQL |
| marketing_channel__last_non_direct_touch |
Marketing Channel derived from a user's last known interaction with an FI's website that had marketing parameters. |
STRING
|
Data Export, Console, Direct SQL |
| marketing_channel__app_start |
Marketing Channel derived from the session a user started the application. |
STRING
|
Data Export, Console, Direct SQL |
| marketing_channel__app_submit |
Marketing Channel derived from the session a user submitted the application. |
STRING
|
Data Export, Console, Direct SQL |
| real_estate_properties |
JSON-array-like string that lists the real estate properties owned by the business. |
STRING
|
Data Export, Console, Direct SQL |
| application_funnel_stage |
The highest numerical funnel stage reached on an application |
INTEGER
|
Data Export, Console, Direct SQL |
| application_funnel_stage_description |
None |
STRING
|
Data Export, Console, Direct SQL |
| application_canceled_by_experience |
The application originating experience that the user who cancelled the application was using |
STRING
|
Data Export, Console, Direct SQL |
| mantl_last_synced_at |
The time at which the record was last synced with MANTL's database. |
TIMESTAMP
|
Data Export, Console, Direct SQL |
| application_canceled_by_email |
The lower-cased email of the user that cancelled the application |
STRING
|
Data Export, Console, Direct SQL |