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

Attribute	Description
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