Program service table

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

    • The Program service [sn_hcls_program_service] table stores the program services associated with a program.

    Key features

    • Extends the Product Specification [sn_prd_pm_product_specification] table to model all program services available within a program.
    • Includes the program service name and duration of the program service.

    Role required to configure the table: sn_hcls.admin.

    For more information, see Healthcare and Life Sciences data model.

    Table 1. Program service table fields

    Field

    Data type

    Description

    Active

    True/False

    Option to indicate that the program service is in use.

    End Date

    Date

    End date of the program service duration.

    Name

    String

    Name of the program service

    Number

    String

    Alpha-numeric identifier of the program service.

    The value is auto-generated and is incremented every time you add a new program service to an instance. The initial value for the Number field is PGSRV00001001.
    Note:
    To customize the number, define the auto-numbering format for the Program service [sn_hcls_program_service] table. For more information, see Add auto-numbering records in a table.

    Start Date

    Date

    Start date of the program service duration.

    State

    String

    Status of the program service as Draft or Published.

    Description

    String

    Brief description of the program service.