> For the complete documentation index, see [llms.txt](https://docs.openg2p.org/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.openg2p.org/~/changes/xKUM0sBXFkyR8F24yAMq/g2p-bridge/development/design-specifications/helper-tables/benefit_program.md).

# 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 | <p>TRUE / FALSE<br>Specifies whether Beneficiary ID will travel to Sponsor Bank<br>OR<br>Beneficiary ID will be translated to Account Number (Financial Address) and then travel downstream to Sponsor Bank</p> |


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.openg2p.org/~/changes/xKUM0sBXFkyR8F24yAMq/g2p-bridge/development/design-specifications/helper-tables/benefit_program.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.