Program table

  • Release version: Australia
  • Updated March 12, 2026
  • 1 minute to read
  • The Program [sn_hcls_program] table stores the programs offered by healthcare organizations.

    Key features

    • Extends the Product Specification [sn_prd_pm_product_specification] table to model all programs available from healthcare organizations.
    • Includes the program name, eligibility criteria, medication product, and duration of the program.

    Role required to configure the table: sn_hcls.admin.

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

    Table 1. Program table fields

    Field

    Data type

    Description

    Active

    True/False

    Option to indicate that the program is in use.

    Eligibility criteria

    Reference

    Checklist associated with the program.

    End Date

    Date

    End date of the program duration.

    Medication product

    List

    Medication product associated with the program.

    Name

    String

    Name of the program

    Number

    String

    Alpha-numeric identifier of the program.

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

    Start Date

    Date

    Start date of the program duration.

    State

    String

    Status of the program as Draft or Published.

    Description

    String

    Brief description of the program as would be shown on the case name created for the program.