---
schema_version: "1"
id: 5c62e09ef1a1381e599d84fdf22a63a0db400db7a77a53f4de31e0fe5ac3c53d
title: Member Plan DMO
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/data-cloud/data-cloud-dmo-mapping/guides/std_dmos/c360dm-si-memberplandmo-dmo.md
canonical_url: https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-memberplandmo-dmo.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: cb8163a40f1d73ec691fe00b42b1be7ffc2c11b9a0dfa7324b16b284f07e2744
products:
  - Data 360 DMO and Mapping Guide
  - Data 360 Developer Documentation
---
# Member Plan DMO

## Object Properties

**Object API Name:** `ssot__MemberPlan__dlm`  
**Category:** Unassigned  
**Availability:** Available in 254 and later versions  
**Primary Key Field:** Id  

## Relationships

- **PurchaserPlanId** has a FOREIGNKEY relationship with the [Purchaser Plan DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-purchaserplandmo-dmo.md) `Id` field.
- **PayerAccountId** has a FOREIGNKEY relationship with the [Account DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-accountdmo-dmo.md) `Id` field.
- **PatientId** has a FOREIGNKEY relationship with the [Patient DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-patientdmo-dmo.md) `Id` field.
- **MemberAccountId** has a FOREIGNKEY relationship with the [Account DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-accountdmo-dmo.md) `Id` field.
- **MemberIndividualId** has a FOREIGNKEY relationship with the [Individual DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-individualdmo-dmo.md) `Id` field.
- **SubscriberIndividualId** has a FOREIGNKEY relationship with the [Individual DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-individualdmo-dmo.md) `Id` field.
- **HealthcarePayerNetworkId** has a FOREIGNKEY relationship with the [Healthcare Payer Network DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-healthcarepayernetworkdmo-dmo.md) `Id` field.


## Fields

- [AffiliationServiceTypeText](#affiliationservicetypetext)
- [cdp_sys_record_currency](#cdp_sys_record_currency)
- [DataSourceId](#datasourceid)
- [DataSourceObjectId](#datasourceobjectid)
- [EffectiveFromDate](#effectivefromdate)
- [EffectiveToDate](#effectivetodate)
- [ExternalIdentifier](#externalidentifier)
- [GroupNumberText](#groupnumbertext)
- [HealthcarePayerNetworkId](#healthcarepayernetworkid)
- [Id](#id)
- [InternalOrganizationId](#internalorganizationid)
- [IssuerNumberText](#issuernumbertext)
- [KQ_Id](#kq_id)
- [KQ_MemberAccountId](#kq_memberaccountid)
- [KQ_MemberIndividualId](#kq_memberindividualid)
- [KQ_PatientId](#kq_patientid)
- [KQ_PayerAccountId](#kq_payeraccountid)
- [KQ_PurchaserPlanId](#kq_purchaserplanid)
- [KQ_SubscriberIndividualId](#kq_subscriberindividualid)
- [LastVerificationDate](#lastverificationdate)
- [MemberAccountId](#memberaccountid)
- [MemberId](#memberid)
- [MemberIndividualId](#memberindividualid)
- [MemberNumber](#membernumber)
- [MemberPlanNoteText](#memberplannotetext)
- [Name](#name)
- [PatientId](#patientid)
- [PayerAccountId](#payeraccountid)
- [PayerId](#payerid)
- [PlanType](#plantype)
- [PrimaryCarePhysicianName](#primarycarephysicianname)
- [PurchaserPlanId](#purchaserplanid)
- [RelationshipToSubscriber](#relationshiptosubscriber)
- [SourceSystemModifiedDate](#sourcesystemmodifieddate)
- [SourceSystemName](#sourcesystemname)
- [Status](#status)
- [SubscriberId](#subscriberid)
- [SubscriberIndividualId](#subscriberindividualid)
- [VerificationStatus](#verificationstatus)

### AffiliationServiceTypeText

- **Field API Name:** `ssot__AffiliationServiceTypeText__c`
- **Data Type:** TEXT
- **Description:** An affiliation to a government service, such as the army or navy.

### cdp_sys_record_currency

- **Field API Name:** `ssot__cdp_sys_record_currency__c`
- **Data Type:** TEXT
- **Description:** System-generated metadata field that stores a 3-letter ISO currency code.

### DataSourceId

- **Field API Name:** `ssot__DataSourceId__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### DataSourceObjectId

- **Field API Name:** `ssot__DataSourceObjectId__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### EffectiveFromDate

- **Field API Name:** `ssot__EffectiveFromDate__c`
- **Data Type:** DATEONLY
- **Description:** The date from which this member plan is effective.

### EffectiveToDate

- **Field API Name:** `ssot__EffectiveToDate__c`
- **Data Type:** DATEONLY
- **Description:** The date on which this member plan ceases to be effective.

### ExternalIdentifier

- **Field API Name:** `ssot__ExternalIdentifier__c`
- **Data Type:** TEXT
- **Description:** External Identifier for a MemberPlan.

### GroupNumberText

- **Field API Name:** `ssot__GroupNumberText__c`
- **Data Type:** TEXT
- **Description:** The group number or policy number of the primary member.

### HealthcarePayerNetworkId

- **Field API Name:** `ssot__HealthcarePayerNetworkId__c`
- **Data Type:** TEXT
- **Description:** The payer insurance plan or network that's  associated with the patient.

### Id

- **Field API Name:** `ssot__Id__c`
- **Data Type:** TEXT
- **Description:** Required. A unique, system-generated identifier for this Member Plan. Maximum size is 36 characters.

### InternalOrganizationId

- **Field API Name:** `ssot__InternalOrganizationId__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### IssuerNumberText

- **Field API Name:** `ssot__IssuerNumberText__c`
- **Data Type:** TEXT
- **Description:** Reference number for the issuer of the plan.

### KQ_Id

- **Field API Name:** `KQ_Id__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for Id

### KQ_MemberAccountId

- **Field API Name:** `KQ_MemberAccountId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for MemberAccountId

### KQ_MemberIndividualId

- **Field API Name:** `KQ_MemberIndividualId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for MemberIndividualId

### KQ_PatientId

- **Field API Name:** `KQ_PatientId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for PatientId

### KQ_PayerAccountId

- **Field API Name:** `KQ_PayerAccountId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for PayerAccountId

### KQ_PurchaserPlanId

- **Field API Name:** `KQ_PurchaserPlanId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for PurchaserPlanId

### KQ_SubscriberIndividualId

- **Field API Name:** `KQ_SubscriberIndividualId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for SubscriberIndividualId

### LastVerificationDate

- **Field API Name:** `ssot__LastVerificationDate__c`
- **Data Type:** DATEONLY
- **Description:** The date on which this plan was last verified.

### MemberAccountId

- **Field API Name:** `ssot__MemberAccountId__c`
- **Data Type:** TEXT
- **Description:** Required. This is a Many To One (N:1) relationship field. MemberPlans is the relationship name. Patient object(s) are related to the Account referenced object. Maximum size is 15 characters.

### MemberId

- **Field API Name:** `ssot__MemberId__c`
- **Data Type:** TEXT
- **Description:** The Account of the member receiving this benefit item.

### MemberIndividualId

- **Field API Name:** `ssot__MemberIndividualId__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### MemberNumber

- **Field API Name:** `ssot__MemberNumber__c`
- **Data Type:** TEXT
- **Description:** The member's reference number for this plan.

### MemberPlanNoteText

- **Field API Name:** `ssot__MemberPlanNoteText__c`
- **Data Type:** TEXT
- **Description:** Notes about this member plan.

### Name

- **Field API Name:** `ssot__Name__c`
- **Data Type:** TEXT
- **Description:** Name of the Member Plan.

### PatientId

- **Field API Name:** `ssot__PatientId__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### PayerAccountId

- **Field API Name:** `ssot__PayerAccountId__c`
- **Data Type:** TEXT
- **Description:** The organization Account that pays for the member plan.

### PayerId

- **Field API Name:** `ssot__PayerId__c`
- **Data Type:** TEXT
- **Description:** The organization Account that pays for the member plan.

### PlanType

- **Field API Name:** `ssot__PlanType__c`
- **Data Type:** TEXT
- **Description:** Whether this plan is the primary, secondary, or tertiary plan.

### PrimaryCarePhysicianName

- **Field API Name:** `ssot__PrimaryCarePhysicianName__c`
- **Data Type:** TEXT
- **Description:** The name of the physician providing primary care under this plan.

### PurchaserPlanId

- **Field API Name:** `ssot__PurchaserPlanId__c`
- **Data Type:** TEXT
- **Description:** The payer plan that a purchaser makes available to its members and members' dependents.

### RelationshipToSubscriber

- **Field API Name:** `ssot__RelationshipToSubscriber__c`
- **Data Type:** TEXT
- **Description:** The relationship of this member to the plan's subscriber.

### SourceSystemModifiedDate

- **Field API Name:** `ssot__SourceSystemModifiedDate__c`
- **Data Type:** DATETIME
- **Description:** The date on which this plan record was last changed on the source system.

### SourceSystemName

- **Field API Name:** `ssot__SourceSystemName__c`
- **Data Type:** TEXT
- **Description:** The name of the system this plan record came from.

### Status

- **Field API Name:** `ssot__Status__c`
- **Data Type:** TEXT
- **Description:** Whether the plan is active.

### SubscriberId

- **Field API Name:** `ssot__SubscriberId__c`
- **Data Type:** TEXT
- **Description:** The account of the subscriber to the health plan.

### SubscriberIndividualId

- **Field API Name:** `ssot__SubscriberIndividualId__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### VerificationStatus

- **Field API Name:** `ssot__VerificationStatus__c`
- **Data Type:** TEXT
- **Description:** The status of the plan's verification.