Patient table
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.
| 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. |
Parent Topic:Healthcare and Life Sciences data model tables