Production and delivery for EVE Extract

  • Updated

By default, EVE is produced as double pipe '| |' delimited files on a nightly basis. These files are available through the Q2 GoAnywhere server at https://sftp.q2ebanking.com/ in the \Inbound\EVE_Extract directory. Q2 sets up and maintains this server, but your FI is responsible for pulling the files from this location. This server holds files from the past seven days. After the seven-day grace period, the files are deleted. The files cannot be regenerated or retransmitted. Per customer request, files may be zipped, and the FI will have to unzip files to use them. The zipped file name will follow the same pattern listed in the "Delivered file names" section below but will end in .zip instead of .txt.

Tip

If your dataset includes data as a result of Interactive Test Drive (ITD) activity, please remember to exclude this data in your queries to prevent skewing your insights. This data can be identified by excluding activity that belongs to the Zone your Interactive Test Drive environment is assigned to. For example, if Zone 6 is assigned to ITD, excluding any transactions originating from Zone 6 will remove any ITD transactions.

The Online Banking User ID

The one constant that runs through all EVE extracts is the user_id. This unique identifier references the online banking users in the UserData extract. You can trace the actions of a single user throughout the data with their user_id information.

Delivered file names

EVE delivers the following files:

  • ####_AccountNotification.yyyyMMdd.HHmmss.txt

  • ####_AuditScore.yyyyMMdd.HHmmss.txt

  • ####_AuthorizingGTDevice.yyyyMMdd.HHmmss.txt

  • ####_ClosedAccountData.yyyyMMdd.HHmmss.txt

  • ####_CustomerEnabledTreasuryFeatures.yyyyMMdd.HHmmss.txt

  • ####_CustomerLevelGTEntitlements.yyyyMMdd.HHmmss.txt

  • ####_CustomerGTLimits.yyyyMMdd.HHmmss.txt

  • ####_CustomerPIIData.yyyyMMdd.HHmmss.txt

  • ####_DeliveredSecurityAlert.yyyyMMdd.HHmmss.txt

  • ####_DirectConnectLogin.yyyyMMdd.HHmmss.txt

  • ####_DirectConnectTransactions.yyyyMMdd.HHmmss.txt

  • ####_DisclaimerAcceptance.yyyyMMdd.HHmmss.txt

  • ####_EStatementData.yyyyMMdd.HHmmss.txt

  • ####_GeneratedACHActivity.yyyyMMdd.HHmmss.txt

  • ####_GeneratedTransactionActivity.yyyyMMdd.HHmmss.txt

  • ####_GoalsData.yyyyMMdd.HHmmss.txt

  • ####_LogonActivity.yyyyMMdd.HHmmss.txt

  • ####_LogonAuthenticationDetail.yyyyMMdd.HHmmss.txt

  • ####_NotificationContactDetail.yyyyMMdd.HHmmss.txt

  • ####_PFMHostAccountDataElements.yyyyMMdd.HHmmss.txt

  • ####_PFMHostTransactionHistory.yyyyMMdd.HHmmss.txt

  • ####_PFMTransactionClassifications.yyyyMMdd.HHmmss.txt

  • ####_PhoneNumber.yyyyMMdd.HHmmss.txt

  • ####_ProductIDs.yyyyMMdd.HHmmss.txt

  • ####_Recipient.yyyyMMdd.HHmmss.txt

  • ####_RecipientAccount.yyyyMMdd.HHmmss.txt

  • ####_RecipientFI.yyyyMMdd.HHmmss.txt

  • ####_RecurringTransactions.yyyyMMdd.HHmmss.txt

  • ####_RemoteDepositActivity.yyyyMMdd.HHmmss.txt

  • ####_Subsidairy.yyyyMMdd.HHmmss.txt

  • ####_TemplatePayments.yyyyMMdd.HHmmss.txt

  • ####_Tempates.yyyyMMdd.HHmmss.txt

  • ####_ThirdPartyData.yyyyMMdd.HHmmss.txt

  • ####_UnProcessedTransactions.yyyyMMdd.HHmmss.txt

  • ####_UserAccountData.yyyyMMdd.HHmmss.txt

  • ####_UserAccountNickname.yyyyMMdd.HHmmss.txt

  • ####_UserAdmin.yyyyMMdd.HHmmss.txt

  • ####_UserData.yyyyMMdd.HHmmss.txt

  • ####_UserDataPII.yyyyMMdd.HHmmss.txt

  • ####_UserEnabledAlerts.yyyyMMdd.HHmmss.txt

  • ####_UserEnrollment.yyyyMMdd.HHmmss.txt

  • ####_UserLevelGTEntitlements.yyyyMMdd.HHmmss.txt

  • ####_UserLogon.yyyyMMdd.HHmmss.txt

  • ####_UserThemes.yyyyMMdd.HHmmss.txt

Note

If any add-on products are not purchased, files containing that data will be empty.

Files will either contain data for the current or previous day's user behavior. The following files contain data for the previous day's user behavior. The date in their file names will display as the previous day's date. For example, if today is 10/6/2023, the date in the file name will appear as 20231005.

  • AccountNotification

  • AuditScore

  • AuthorizingGTDevice

  • DeliveredSecurityAlert

  • DirectConnectLogin

  • DirectConnectTransactions

  • DisclaimerAcceptance

  • GeneratedACHActivity

  • GeneratedTransactionActivity

  • LogonActivity

  • LogonAuthenticationDetail

  • PFMHostTransactionHistory

  • PFMTransactionClassifications

  • RemoteDepositActivity

  • UserEnrollment

All other files will contain data for the current day's user behavior.

Related articles

IN THIS ARTICLE