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:
- Imports fraud csv from support
- Looks up payments in PayCenter CPR, copies fields to output.
- Looks up payments in Blue CPR, copies fields to output.
- A stored procedure is called.
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 |