Tables installed with Grants Management

  • Release version: Zurich
  • Updated October 23, 2025
  • 1 minute to read

    • This section describes the tables installed with the Grants Management application and shows how they store and manage information.

    Grants Management tables installed

    Table 1. Public Sector Digital Services Grants Management tables
    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)
    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. N/A
    Business Registration Request

    [sn_gsm_business_registration]

    		 Contains information about new business registration requests. N/A
    Government Service Document

    [sn_gsm_document]

    		 Contains information about service documents. Documents (ds_document)
    Government Service Evaluation Task

    [sn_gsm_government_service_evaluation_task]

    		 Contains information about service evaluation tasks. Government Service Task (sn_gsm_government_service_task)
    Grant Award

    [sn_gsm_grants_mgmt_items _received]

    		 Tracks individual social benefit items received by constituents, noting benefit type, amount, and date of issuance. Install Base Item (sn_install_base_item)