Data Setup Examples of Payment Distribution Details
Typically, each staging record will represent a single payment event - with a corresponding payment tender and payment. However, it is possible to specify complex relationships within a set of staging records. For example, it will be straightforward to define a set of staging records that represent a single tender but multiple payments (to model the single payment tender of a welfare agency which covers payments for multiple accounts). Similarly, it is equally possible to define a set of staging records that represent a single payment but multiple tenders (although not a common requirement).
Each staging record can represent:
- Zero or one new payment events. Typically, each detail staging record will represent a single payment event. However, it is possible to define multiple records for a single payment event. All details for a single payment event are identified by a common value on the staging record: Pay Event Process ID.
Pay Event Process ID. This field is used for grouping staging records and for organizing parallel threads (in the C1-PEPL2 process). Therefore, it is strongly encouraged that it bears a relationship to the tender account ID.
- A partial or one new payment tenders. Typically, each detail staging record will represent a single payment tender. However, it is possible to define multiple staging records for a single pay tender. All details for a single tender are identified by a common payment event ID as well as common tender information (tender type, tender account ID, check number, external reference, etc.).
- A partial or many new payments. Typically, each detail staging record will represent a set of one or many new payments. However, it is possible to define multiple staging records for a single payment. All details for a single payment are identified by a common payment event ID as well as common distribution rule and characteristic value information.
Staging Entry Example 1: One Payment Event, Two Tenders, Two Payments
Seq. |
Pay Event Process ID |
Tender Account ID |
Tender Ref. |
Date |
Rule Value |
Amount |
Tender Type |
Check No |
1 |
1234567890 |
1234567890 |
112A |
1/1/2006 |
113-54-8978 |
30.00 |
Check |
101 |
2 |
1234567890 |
1234567890 |
112B |
1/1/2006 |
575-40-3030 |
40.00 |
Check |
102 |
Staging Entry Example 2: One Payment Event, One Tender, Two Payments
Seq. |
Pay Event Process ID |
Tender Account ID |
Tender Ref. |
Date |
Rule Value |
Amount |
Tender Type |
Check No |
1 |
1234567890 |
1234567890 |
112A |
1/1/2006 |
113-54-8978 |
30.00 |
Check |
101 |
2 |
1234567890 |
1234567890 |
112A |
1/1/2006 |
575-40-3030 |
40.00 |
Check |
101 |
Staging Entry Example 3: One Payment Event, Two Tenders, One Payment
Seq. |
Pay Event Process ID |
Tender Account ID |
Tender Ref. |
Date |
Rule Value |
Amount |
Tender Type |
Check No |
1 |
1234567890 |
1234567890 |
112A |
1/1/2006 |
575-40-3030 |
30.00 |
Check |
101 |
2 |
1234567890 |
7878787870 |
888Q |
1/1/2006 |
575-40-3030 |
40.00 |
Check |
9872 |