Member Plan DMO

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

• PurchaserPlanId has a FOREIGNKEY relationship with the Purchaser Plan DMO Id field.
• PayerAccountId has a FOREIGNKEY relationship with the Account DMO Id field.
• PatientId has a FOREIGNKEY relationship with the Patient DMO Id field.
• MemberAccountId has a FOREIGNKEY relationship with the Account DMO Id field.
• MemberIndividualId has a FOREIGNKEY relationship with the Individual DMO Id field.
• SubscriberIndividualId has a FOREIGNKEY relationship with the Individual DMO Id field.
• HealthcarePayerNetworkId has a FOREIGNKEY relationship with the Healthcare Payer Network DMO Id field.

• AffiliationServiceTypeText
• cdp_sys_record_currency
• DataSourceId
• DataSourceObjectId
• EffectiveFromDate
• EffectiveToDate
• ExternalIdentifier
• GroupNumberText
• HealthcarePayerNetworkId
• Id
• InternalOrganizationId
• IssuerNumberText
• KQ_Id
• KQ_MemberAccountId
• KQ_MemberIndividualId
• KQ_PatientId
• KQ_PayerAccountId
• KQ_PurchaserPlanId
• KQ_SubscriberIndividualId
• LastVerificationDate
• MemberAccountId
• MemberId
• MemberIndividualId
• MemberNumber
• MemberPlanNoteText
• Name
• PatientId
• PayerAccountId
• PayerId
• PlanType
• PrimaryCarePhysicianName
• PurchaserPlanId
• RelationshipToSubscriber
• SourceSystemModifiedDate
• SourceSystemName
• Status
• SubscriberId
• SubscriberIndividualId
• VerificationStatus

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

• 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.

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

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

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

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

• Field API Name: ssot__ExternalIdentifier__c
• Data Type: TEXT
• Description: External Identifier for a MemberPlan.

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

• Field API Name: ssot__HealthcarePayerNetworkId__c
• Data Type: TEXT
• Description: The payer insurance plan or network that’s associated with the patient.

• 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.

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

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

• Field API Name: KQ_Id__c
• Data Type: TEXT
• Description: Key Qualifier system field for Id

• Field API Name: KQ_MemberAccountId__c
• Data Type: TEXT
• Description: Key Qualifier system field for MemberAccountId

• Field API Name: KQ_MemberIndividualId__c
• Data Type: TEXT
• Description: Key Qualifier system field for MemberIndividualId

• Field API Name: KQ_PatientId__c
• Data Type: TEXT
• Description: Key Qualifier system field for PatientId

• Field API Name: KQ_PayerAccountId__c
• Data Type: TEXT
• Description: Key Qualifier system field for PayerAccountId

• Field API Name: KQ_PurchaserPlanId__c
• Data Type: TEXT
• Description: Key Qualifier system field for PurchaserPlanId

• Field API Name: KQ_SubscriberIndividualId__c
• Data Type: TEXT
• Description: Key Qualifier system field for SubscriberIndividualId

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

• 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.

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

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

• Field API Name: ssot__MemberNumber__c
• Data Type: TEXT
• Description: The member’s reference number for this plan.

• Field API Name: ssot__MemberPlanNoteText__c
• Data Type: TEXT
• Description: Notes about this member plan.

• Field API Name: ssot__Name__c
• Data Type: TEXT
• Description: Name of the Member Plan.

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

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

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

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

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

• Field API Name: ssot__PurchaserPlanId__c
• Data Type: TEXT
• Description: The payer plan that a purchaser makes available to its members and members’ dependents.

• Field API Name: ssot__RelationshipToSubscriber__c
• Data Type: TEXT
• Description: The relationship of this member to the plan’s subscriber.

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

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

• Field API Name: ssot__Status__c
• Data Type: TEXT
• Description: Whether the plan is active.

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

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

• Field API Name: ssot__VerificationStatus__c
• Data Type: TEXT
• Description: The status of the plan’s verification.