Tables installed with License and Permit Playbook

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

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

    License and Permit tables installed

    Table 1. Public Sector Digital Services License and Permit tables
    Table Description Extends Table
    License and Permit Case

    [sn_gsm_license_permit_case]

    		 Contains cases related to applications for licenses and permits, tracking application status, required documentation, and approval steps. 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)
    License and Permit Item Received

    [sn_gsm_license_permit_install_base_item]

    		 Contains the details of license and permit items that have been issued or received, including item identifiers, issuance dates, and recipient information. Install Base Item (sn_install_base_item)