Healthcare Provider Searchable Field DMO

Represents searchable healthcare provider information including provider details, facility information, specialties, and other attributes used for provider search and discovery.

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

• HealthcareProviderId has a FOREIGNKEY relationship with the Healthcare Provider DMO Id field.
• FacilityId has a FOREIGNKEY relationship with the Account DMO Id field.
• OperatingHoursId has a FOREIGNKEY relationship with the Operating Hours DMO Id field.

• cdp_sys_record_currency
• CertificationType
• ConditionText
• DataSourceId
• DataSourceObjectId
• EducationType
• FacilityAddressText
• FacilityCityName
• FacilityCountryCode
• FacilityCountryName
• FacilityGeocodeAccuracy
• FacilityId
• FacilityLatitude
• FacilityLongitude
• FacilityName
• FacilityPhoneNumber
• FacilityPostalCode
• FacilityStateCode
• FacilityStateName
• FacilityStreetName
• GenderRestrictionText
• HealthcareProviderGenderText
• HealthcareProviderId
• HealthcareProviderName
• HealthcareProviderType
• HealthcarePrvdSearchableFldNm
• Id
• InternalOrganizationId
• IsAcceptingNewPatients
• IsAccessible
• IsMarkedForDelete
• IsUpdateNeeded
• KQ_FacilityId
• KQ_HealthcareProviderId
• KQ_Id
• KQ_OperatingHoursId
• LanguagesSpokenText
• LicenseJurisdictionCtryNm
• LicenseJurisdictionRegionName
• LicenseJurisdictionStateName
• LicenseName
• LicenseStatus
• NationalProviderIdentifier
• OperatingHoursId
• PhotoUrl
• PlanType
• ProviderSrchSyncLogIdentifier
• ServiceCode
• ServiceText
• SpecialtyName
• SubspecialtyName
• UniqueKey

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

• Field API Name: CertificationType__c
• Data Type: TEXT
• Description: Type of certification held by the healthcare provider.

• Field API Name: ConditionText__c
• Data Type: TEXT
• Description: Medical condition or conditions treated by the provider.

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

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

• Field API Name: EducationType__c
• Data Type: TEXT
• Description: Type of education completed by the healthcare provider.

• Field API Name: FacilityAddressText__c
• Data Type: TEXT
• Description: Complete address of the healthcare facility.

• Field API Name: FacilityCityName__c
• Data Type: TEXT
• Description: City name where the healthcare facility is located.

• Field API Name: FacilityCountryCode__c
• Data Type: TEXT
• Description: Country code for the facility location.

• Field API Name: FacilityCountryName__c
• Data Type: TEXT
• Description: Country where the healthcare facility is located.

• Field API Name: FacilityGeocodeAccuracy__c
• Data Type: TEXT
• Description: Accuracy level of the facility’s geocode coordinates.

• Field API Name: FacilityId__c
• Data Type: TEXT
• Description: Unique identifier for the healthcare facility.

• Field API Name: FacilityLatitude__c
• Data Type: DOUBLE
• Description: Latitude coordinate of the healthcare facility location.

• Field API Name: FacilityLongitude__c
• Data Type: DOUBLE
• Description: Longitude coordinate of the healthcare facility location.

• Field API Name: FacilityName__c
• Data Type: TEXT
• Description: Name of the healthcare facility.

• Field API Name: FacilityPhoneNumber__c
• Data Type: TEXT
• Description: Phone number of the healthcare facility.

• Field API Name: FacilityPostalCode__c
• Data Type: TEXT
• Description: Postal code of the healthcare facility.

• Field API Name: FacilityStateCode__c
• Data Type: TEXT
• Description: State code for the facility location.

• Field API Name: FacilityStateName__c
• Data Type: TEXT
• Description: State name where the healthcare facility is located.

• Field API Name: FacilityStreetName__c
• Data Type: TEXT
• Description: Street address of the healthcare facility.

• Field API Name: GenderRestrictionText__c
• Data Type: TEXT
• Description: Gender restrictions for patients at this facility or provider.

• Field API Name: HealthcareProviderGenderText__c
• Data Type: TEXT
• Description: Gender of the healthcare provider.

• Field API Name: HealthcareProviderId__c
• Data Type: TEXT
• Description: Unique identifier for the healthcare provider.

• Field API Name: HealthcareProviderName__c
• Data Type: TEXT
• Description: Name of the healthcare provider.

• Field API Name: HealthcareProviderType__c
• Data Type: TEXT
• Description: Type or category of the healthcare provider.

• Field API Name: HealthcarePrvdSearchableFldNm__c
• Data Type: TEXT
• Description: Name of the healthcare provider searchable field record.

• Field API Name: Id__c
• Data Type: TEXT
• Description: Primary key identifier for the provider searchable field record.

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

• Field API Name: IsAcceptingNewPatients__c
• Data Type: BOOLEAN
• Description: Indicates whether the healthcare provider is currently accepting new patients.

• Field API Name: IsAccessible__c
• Data Type: BOOLEAN
• Description: Indicates whether the facility is accessible for patients with disabilities.

• Field API Name: IsMarkedForDelete__c
• Data Type: BOOLEAN
• Description: Indicates whether this record is marked for deletion.

• Field API Name: IsUpdateNeeded__c
• Data Type: BOOLEAN
• Description: Indicates whether this record needs to be updated.

• Field API Name: KQ_FacilityId__c
• Data Type: TEXT
• Description: Key Qualifier system field for FacilityId

• Field API Name: KQ_HealthcareProviderId__c
• Data Type: TEXT
• Description: Key Qualifier system field for HealthcareProviderId

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

• Field API Name: KQ_OperatingHoursId__c
• Data Type: TEXT
• Description: Key Qualifier system field for OperatingHoursId

• Field API Name: LanguagesSpokenText__c
• Data Type: TEXT
• Description: Languages spoken by the healthcare provider or at the facility.

• Field API Name: LicenseJurisdictionCtryNm__c
• Data Type: TEXT
• Description: Country name where the provider’s license is issued.

• Field API Name: LicenseJurisdictionRegionName__c
• Data Type: TEXT
• Description: Region name where the provider’s license is issued.

• Field API Name: LicenseJurisdictionStateName__c
• Data Type: TEXT
• Description: State name where the provider’s license is issued.

• Field API Name: LicenseName__c
• Data Type: TEXT
• Description: Name of the license held by the healthcare provider.

• Field API Name: LicenseStatus__c
• Data Type: TEXT
• Description: Current status of the provider’s license.

• Field API Name: NationalProviderIdentifier__c
• Data Type: TEXT
• Description: National Provider Identifier (NPI) for the healthcare provider.

• Field API Name: OperatingHoursId__c
• Data Type: TEXT
• Description: Operating hours of the healthcare facility or provider.

• Field API Name: PhotoUrl__c
• Data Type: TEXT
• Description: URL to a photo of the healthcare provider.

• Field API Name: PlanType__c
• Data Type: TEXT
• Description: Type of insurance plan accepted by the provider.

• Field API Name: ProviderSrchSyncLogIdentifier__c
• Data Type: TEXT
• Description: Identifier for the provider search synchronization log.

• Field API Name: ServiceCode__c
• Data Type: TEXT
• Description: Code identifying the service provided.

• Field API Name: ServiceText__c
• Data Type: TEXT
• Description: Name of the service provided by the healthcare provider.

• Field API Name: SpecialtyName__c
• Data Type: TEXT
• Description: Primary medical specialty of the healthcare provider.

• Field API Name: SubspecialtyName__c
• Data Type: TEXT
• Description: Medical subspecialty of the healthcare provider.

• Field API Name: UniqueKey__c
• Data Type: TEXT
• Description: Unique key for identifying the provider search record.