Patient table

  • Release version: Australia
  • Updated March 12, 2026
  • 3 minutes to read
  • The Patient [sn_hcls_patient] table stores the details of a patient in your healthcare organization.

    Key features

    • Extends the Consumer profile [sn_csm_consumer_profile] table.
    • Stores details of a patient, the central object in the Healthcare and Life Sciences data model.
    • Stores basic patient information including first name, last name, date of birth, gender, primary and secondary emails, home, work and mobile phones.
    • Includes the consumer attribute associated with the patient that is a reference to the Consumer [csm_consumer] table. A Consumer record is automatically created when a patient is created in the Patient [sn_hcls_patient] table.

    Role required to configure the table: sn_hcls.admin.

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

    Table 1. Patient table fields

    Field

    Data type

    Description

    Birth place

    Reference

    Birth place of the patient.

    Date of birth

    String

    Birth date of the patient.

    Deceased

    True/False

    Option to indicate the patient is deceased.

    Deceased date/time

    Date/Time

    Date and time of patient's death.

    Ethnicity

    Choice list

    Ethnic group the patient identifies with.

    The following types are available by default:
    • Hispanic or Latino
    • Not Hispanic or Latino
    • Unable to report due to do policy/law

    First name

    String

    First name of the patient.

    Gender

    Choice list

    Gender of the patient.

    The following types are available by default:
    • Female
    • Male
    • Non binary
    • Not disclosed
    • Other

    Guarantor id

    String

    Identifier that applies to a person who is responsible for paying all charges for services ordered on behalf of the patient

    Home phone

    String

    Home phone number of the patient.

    Interpreter required

    True/False

    Option to indicate that an interpreter is needed during patient interactions.

    Is DOB estimated

    True/False

    Option to indicate the date of birth (DOB) of the patient is an estimated value.

    Language code

    Reference

    Represents the preferred language of interaction for the patient.

    Last name

    String

    Last name of the patient.

    Marital status

    Choice list

    Marital status of the patient.

    Middle name

    String

    Middle name of the patient.

    Mobile phone

    String

    Mobile phone number of the patient.

    Occupation

    String

    Occupation of the patient.

    Name

    String

    Name to identify the patient.

    Number

    String

    Alpha-numeric profile identifier of the patient.

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

    Preferred communication channel

    Choice list

    Patient's preferred communication channel, including email, phone, or chat.

    The value is dependent on the value entered in the Preferred communication method field.

    Preferred communication method

    Choice list

    Patient's preferred communication method, including email, text, or phone.

    Prefix

    String

    Part of the patient name that is acquired as a title due to academic, legal, employment or nobility status, and that appears at the start of the name.

    For example, Mr. or Mrs.

    Primary email

    String

    Email address of the patient to which any correspondence is sent.

    Race

    Choice list

    Race of the patient.

    The following types are available by default:
    • American Indian or Alaska Native
    • Asian
    • Black or African American
    • Native Hawaiian or Other Pacific Islander
    • Other Race

      Unable to report due to do policy/law

    • White

    Research consent given

    True/False

    Option to indicate that the patient has given consent to take part in research programs.

    Secondary email

    String

    Alternative email address of the patient.

    SMS consent given

    True/False

    Option to indicate that the patient has given consent to be communicated with via SMS. Protected health information is shared only if indicated.

    Source

    Reference

    Source system details of an external healthcare system in a ServiceNow instance.

    Suffix

    String

    Part of the patient name that is acquired as a title due to academic, legal, employment or nobility status, and that appears at the end of the name.

    For example, MD or PhD.

    Work phone

    String

    Work phone number of the patient.