---
sourceDocument: Australia Healthcare and Life Sciences
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/de-DE/healthcare-life-sciences

 Release :

    - australia

ft:locale :

    - de-DE

ft:publication_title :

    - Australia Healthcare and Life Sciences

ft:clusterId :

    - hcls

bundleId :

    - hcls

workflow :

    - Customer and Industry


---

# Member plan table

# Member plan table {#ariaid-title1}

* Freigeben Version: Australia
* 
* Aktualisiert 12. März 2026
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 Minute Lesedauer

The Member Plan \[sn_hcls_member_plan\] table stores the details of a health insurance plan associated with a patient.{#hcls-memb-plan-table__memb-plan-table-sd}

## Key features {#hcls-memb-plan-table__section_iz3_qgz_4pb}

* Extends the Healthcare sold product \[sn_hcls_sold_product\] table to store member plan details.
* Extends the Install base item \[sn_install_base_item\] table to store member plan details.
* Models the health insurance data associated with a patient, including the member number, group number, the payer plan that is purchased and start and end dates of the plan.

{#hcls-memb-plan-table__ul_od3_lhk_4pb}

Role required to configure the table: sn_hcls.admin.

For more information, see Healthcare and Life Sciences data model.
{#hcls-memb-plan-table__table_ikm_hwn_npb__entry__3}

| Field | Data type | Description |
|-|-|-|
| Effective from | Date | Start date from when the member plan is effective. |
| Effective to | Date | End date until when the member plan is effective. |
| External identifier | String | Identifier of the record in an electronic medical record (EMR) system. |
| Group number | String | Group number or policy number of the member. |
| Member | Reference | The associated member's first and last name. |
| Member number | String | Unique ID number of the patient that enables healthcare providers to verify insurance coverage and arrange payment for services. |
| Number | String | Alpha-numeric profile identifier of the member plan. |
| Patient | Reference | Name of the patient in whose name is the plan. |
| Plan priority | String | Priority of the plan. The priority of the plan is: * Primary: The first member plan to which the patient is the subscriber and that is used as if there's no other plans for the patient. * Secondary: The second member plan to which the patient is listed as a dependent. * Tertiary: The third member plan to be billed for the patient. The tertiary plan is used after the primary and secondary plans have been successfully processed. {#hcls-memb-plan-table__ul_nwq_dzn_npb} |
| Payer plan | Reference | Member plan taken by the patient. |
| Relation to subscriber | Reference | Relationship of the dependent member with the subscriber. |
| Rx Bin | String | Number to identify how a prescription drug will be reimbursed and where a pharmacy can send a reimbursement claim to. |
| Rx Group | String | Alphanumeric or numeric value of the member plan that is used to process prescription benefits. |
| Rx PCN | String | Processor control number (PCN) used in routing of pharmacy reimbursements. |
| Source | Reference | Source system details of an external healthcare system in a ServiceNow instance. |
| Subscriber | Reference | Subscriber's patient record. |
[Tabelle : 1. Member plan table fields]

{#hcls-memb-plan-table__table_ikm_hwn_npb}