Tables installed with Social Benefits Playbook

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

    • This section describes the tables installed with the Social Benefits Playbook application and shows how they store and manage information.

    Social Benefits tables installed

    Table 1. Public Sector Digital Services Social Benefits tables
    Table Description Extends Table
    Social Benefits Case

    [sn_gsm_social_benefits_case]

    		 Contains cases involving social benefit applications or claims, capturing information about eligibility, application process, and benefit disbursement. 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)
    Social Benefits Item Received

    [sn_gsm_social_benefits_install_base_item]

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