Tables and Flows installed with Public Sector Digital Services Core

  • Rversion finale: Australia
  • Mis à jour 12 mars 2026
  • 1 minute de lecture

    • 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

    Tableau 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. 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)

    Flows installed

    Tableau 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.