Skip to content

ZFC Data Contribution

The support team maintains a csv file to track fraud incidents. A (planned) process prepares the ZFC data contribution.

Process

PayCenterODI SSIS package:

  1. Imports fraud csv from support
  2. Looks up payments in PayCenter CPR, copies fields to output.
  3. Looks up payments in Blue CPR, copies fields to output.
  4. A stored procedure is called.

file

Payments

BoyarServices.PaymentRepo.Zelle

Get payments of given Zelle payment ids. Reporting source for the ODI ZFC SSIS job.

Database Boyar_PaymentRepo
Object [zelle_reporting].[spGetDataContributionPayments]
Param @zellePaymentids varchar(max) Comma-separated ids
name type length nullable desc
PaymentId bigint 8 No Table identifier
ZellePaymentId varchar 13 No
SenderZelleCustomerId varchar 255 Yes
SenderZelleOrgId varchar 5 No
SenderZelleProfileOrgId varchar 128 Yes
PaymentActivityId bigint 8 No Activity of the current status
PaymentActivityStatus varchar 80 No See table below
PaymentActivityStatusEffectiveAt datetime2 6 No UTC
Amount decimal 9 No
InitiatedAt datetime2 6 No UTC
Status
Created
Pending
PendingProfile
Sent
Failed
Expired
PendingAcceptance
Accepted
PendingProcessing
Delivered
Denied
Settled
AcceptWithoutPosting
Resent