Tables and Flows installed with Public Sector Digital Services Core

  • Release version: Australia
  • Updated March 12, 2026
  • 1 minute to read

    • This section describes the tables and flows installed with the Public Sector Digital Services Core application and shows how they store and manage information.

    Public Sector Digital Services Core tables installed

    Table 1. Public Sector Digital Services Core tables
    Table Description Extends Table
    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 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)
    Task Document Verification Task Mapping

    [sn_gsm_task_gvt_mapping]

    		 Maps case tasks created for document resubmission requests to the specific Document Verification Tasks that initiated them. Enables tracking and association of flagged documents back to the case task that triggered the resubmission request, supporting cases where multiple documents are flagged for different reasons. None

    Flows installed

    Table 2. Public Sector Digital Services Core flows
    Flow Description
    Create blocked by record if Case Task is associated with government case

    [create_blocked_by_record_if_case_task_is_associated_with_government_case]

    		 Creates a blocked by record if the Case Task is associated with a government case.
    Create blocked by record if Government case needs customer information

    [create_blocked_by_record_if_case_needs_customer_information]

    		 Creates a blocked by record if the Government case needs more customer information.
    Resolve blocked by record if Case Task is closed and associated with Government Case

    [resolve_blocked_by_record_if_case_task_is_closed_and_associated_with_government_case]

    		 Removes the blocked by record for the associated Government case if the Government case is resolved.
    Resolve blocked by record if user information is provided for Government case

    [resolve_blocked_by_record_if_user_information_is_provided_for_govt_case]

    		 Removes the blocked by record if the case task is closed.