benefit_program

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
funding_sub_org_code	If there are sub departments under the Organization/Department, the short code of the sub org
funding_sub_org_name	Name of the Sub Organization corresponding to the sub org short code
sponsor_bank_code	Financial Service Provider - Institution - where the account is maintained - The account that funds the program
sponsor_bank_account_number	Complete account number (financial address) with Bank Code, Branch Code, any other identifier as required
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