benefit_program_configuration

This is a configuration table that stores account details (with sponsor banks) for a benefit program.

The design assumes that every benefit program has exactly one financial account with a sponsor bank.

The design caters for the following thought process

  1. Multiple programs exist and share the same funding account

  2. Multiple programs exist with each program using a dedicated funding account in the same FSP (financial service provider / Bank)

  3. Multiple programs exist with programs using different funding accounts across different FSPs

AttributeDescription

benefit_program_mnemonic

Uniquely identifies a benefit program. Is Primary Key.

benefit_program_name

Describes the benefit program

funding_org_code

The Government department or Social Welfare organization that administers this program - Short Code

funding_org_name

Name of the Organization corresponding to the short code

sponsor_bank_code

Financial Service Provider - Institution - where the account is maintained - The account that funds the program

sponsor_bank_branch_code

The branch code - where the funding account is maintained

sponsor_bank_account_number

Complete account number (financial address) with Bank Code, Branch Code, any other identifier as required Unique Index Every benefit program needs to be funded by a dedicated funding account with a sponsor bank

sponsor_bank_account_currency

The currency in which the account (the funding account) is maintained

id_mapper_resolution_required

TRUE / FALSE Specifies whether Beneficiary ID will travel to Sponsor Bank OR Beneficiary ID will be translated to Account Number (Financial Address) and then travel downstream to Sponsor Bank

Last updated

Logo

Copyright © OpenG2P. This work is licensed under Creative Common Attribution (CC-BY-4.0) International license unless otherwise noted.