# Healthcare Provider Facility Specialty DMO

## Object Properties

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

## Relationships

- **PractitionerFacilityId** has a FOREIGNKEY relationship with the [Healthcare Facility DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-healthcarefacilitydmo-dmo.md) `Id` field.
- **PractitionerFacilityId** has a FOREIGNKEY relationship with the [Healthcare Practitioner Facility DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-healthcarepractitionerfacilitydmo-dmo.md) `Id` field.
- **HealthcareSpecialty** has a FOREIGNKEY relationship with the [Care Specialty DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-carespecialtydmo-dmo.md) `Id` field.

## Fields

- [cdp_sys_record_currency](#cdp_sys_record_currency)
- [DataSourceId](#datasourceid)
- [DataSourceObjectId](#datasourceobjectid)
- [EffectiveFromDate](#effectivefromdate)
- [EffectiveToDate](#effectivetodate)
- [HealthcareSpecialty](#healthcarespecialty)
- [Id](#id)
- [InternalOrganizationId](#internalorganizationid)
- [IsActive](#isactive)
- [IsPrimarySpecialty](#isprimaryspecialty)
- [KQ_HealthcareSpecialty](#kq_healthcarespecialty)
- [KQ_Id](#kq_id)
- [KQ_PractitionerFacilityId](#kq_practitionerfacilityid)
- [Name](#name)
- [PractitionerFacilityId](#practitionerfacilityid)
- [PractitionerFacilityObject](#practitionerfacilityobject)
- [ProviderSpecialtyRole](#providerspecialtyrole)
- [SourceSystem](#sourcesystem)
- [SourceSystemIdentifier](#sourcesystemidentifier)
- [SourceSystemModified](#sourcesystemmodified)

### 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 record is effective.

### EffectiveToDate

- **Field API Name:** `ssot__EffectiveToDate__c`
- **Data Type:** DATEONLY
- **Description:** The date on which this record is no longer effective.

### HealthcareSpecialty

- **Field API Name:** `ssot__HealthcareSpecialty__c`
- **Data Type:** TEXT
- **Description:** Identifies the specialty associated with this provider facility specialty record.

### Id

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

### InternalOrganizationId

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

### IsActive

- **Field API Name:** `ssot__IsActive__c`
- **Data Type:** BOOLEAN
- **Description:** Whether the record is active.

### IsPrimarySpecialty

- **Field API Name:** `ssot__IsPrimarySpecialty__c`
- **Data Type:** BOOLEAN
- **Description:** Whether this specialty is the practitioner's primary specialty at this facility, or the facility's primary specialty.

### KQ_HealthcareSpecialty

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

### KQ_Id

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

### KQ_PractitionerFacilityId

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

### Name

- **Field API Name:** `ssot__Name__c`
- **Data Type:** TEXT
- **Description:** Name of the specialty provided at this provider facility.

### PractitionerFacilityId

- **Field API Name:** `ssot__PractitionerFacilityId__c`
- **Data Type:** TEXT
- **Description:** Practitioner facility associated with this provider facility specialty record.

### PractitionerFacilityObject

- **Field API Name:** `ssot__PractitionerFacilityObject__c`
- **Data Type:** TEXT
- **Description:** The object name of the Practitioner Facility field record.

### ProviderSpecialtyRole

- **Field API Name:** `ssot__ProviderSpecialtyRole__c`
- **Data Type:** TEXT
- **Description:** Role of the specialty for the provider or practitioner.

### SourceSystem

- **Field API Name:** `ssot__SourceSystem__c`
- **Data Type:** TEXT
- **Description:** System from which this request was sourced.

### SourceSystemIdentifier

- **Field API Name:** `ssot__SourceSystemIdentifier__c`
- **Data Type:** TEXT
- **Description:** ID of the system from which the request was sourced.

### SourceSystemModified

- **Field API Name:** `ssot__SourceSystemModified__c`
- **Data Type:** DATETIME
- **Description:** Timestamp of the most recent update from the source system.