Tables installed with Grants Management
This section describes the tables installed with the Grants Management application and shows how they store and manage information.
Grants Management tables installed
| Table | Description | Extends Table |
|---|---|---|
| Grants Management Case\[sn\_gsm\_grants\_mgmt\_case\] | Contains cases associated with grant management, including application details, review status, and decision outcomes. | Government Service Case \(sn\_gsm\_government\_service\_case\) |
| Funding Allocation Review Task\[sn\_gsm\_grnt\_mgmt\_funding\_allocation\_review\_task\] | Captures the recommendation reason and automatically computes the proposal and funding/decline counts along with the total allocated amount. | Government Service Task \(sn\_gsm\_government\_service\_task\) |
| Funding Allocation Proposal Mapping\[sn\_gsm\_grnt\_mgmt\_funding\_allocation\_case\_mapping\] | Links individual proposals to a Funding Allocation Review Task. A flag indicates whether the proposal is included in the batch or removed during the review. | None |
| Government Service Case\[sn\_gsm\_government\_service\_case\] | Contains records of individual cases related to government services, tracking requests, interactions, and resolutions for constituents seeking assistance from government agencies. | Customer Service Case \(sn\_customerservice\_case\) |
| Government Service Task\[sn\_gsm\_government\_service\_task\] | Contains tasks associated with government service cases, outlining specific actions to be performed, their status, and assigned personnel. | Customer Service Task \(sn\_customerservice\_task\) |
| Constituent Profile\[sn\_gsm\_constituent\_profile\] | Contains detailed profiles of constituents, including personal information, contact details, and engagement history with government services. | Consumer Profile \(sn\_csm\_consumer\_profile\) |
| Business Profile\[sn\_gsm\_business\_profile\] | Contains profiles of businesses interacting with government agencies, documenting registration information, contact details, and service engagements. | None |
| Business Registration Request\[sn\_gsm\_business\_registration\] | Contains information about new business registration requests. | None |
| Government Service Document\[sn\_gsm\_document\] | Contains information about service-related documents required for government service requests and case management. | Documents \(ds\_document\) |
| Government Service Evaluation Task\[sn\_gsm\_government\_service\_evaluation\_task\] | Contains information about evaluation tasks for assessing the quality and outcomes of government services provided to constituents. | Government Service Task \(sn\_gsm\_government\_service\_task\) |
Parent Topic:Public Sector Digital Services Grants Management Data Model