Tables installed with Grants Management

  • Release version: Australia
  • Updated March 12, 2026
  • 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)
    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)