Clinical Service Request DMO

A request for a procedure, diagnostic, or other service to be planned, proposed, or performed for a patient.

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

• BodySiteId has a FOREIGNKEY relationship with the Code Set Bundle DMO Id field.
• AccountId has a FOREIGNKEY relationship with the Account DMO Id field.
• PatientHealthConditionId has a FOREIGNKEY relationship with the Patient Health Condition DMO Id field.
• HealthcarePerformerTypeCodeId has a FOREIGNKEY relationship with the Code Set Bundle DMO Id field.
• HealthcareFacilityCodeId has a FOREIGNKEY relationship with the Code Set Bundle DMO Id field.
• DiagnosticSummaryId has a FOREIGNKEY relationship with the Clinical Encounter Diagnosis DMO Id field.
• ClinicalServiceRqstPreqCodeId has a FOREIGNKEY relationship with the Code Set Bundle DMO Id field.
• ClinicalServiceRequestGroupId has a FOREIGNKEY relationship with the Clinical Service Request Identifier DMO Id field.
• ClinicalServiceRequestCategoryId has a FOREIGNKEY relationship with the Code Set Bundle DMO Id field.
• RequesterId has a FOREIGNKEY relationship with the Patient Registered Device DMO Id field.
• RequesterId has a FOREIGNKEY relationship with the Account DMO Id field.
• RelatedCareObservationId has a FOREIGNKEY relationship with the Care Observation DMO Id field.
• ReasonCodeId has a FOREIGNKEY relationship with the Code Set Bundle DMO Id field.
• QuantityNumeratorUnitOfMeasureId has a FOREIGNKEY relationship with the Unit of Measure DMO Id field.
• PerformerId has a FOREIGNKEY relationship with the Patient Registered Device DMO Id field.
• PerformerId has a FOREIGNKEY relationship with the Healthcare Provider DMO Id field.
• PerformerId has a FOREIGNKEY relationship with the Account DMO Id field.
• HealthcareFacilityId has a FOREIGNKEY relationship with the Healthcare Facility DMO Id field.
• OriginalClinicalServiceRequestId has a FOREIGNKEY relationship with the Clinical Service Request DMO Id field.
• CaseId has a FOREIGNKEY relationship with the Case DMO Id field.
• ClinicalEncounterId has a FOREIGNKEY relationship with the Clinical Encounter DMO Id field.
• DiseaseInvestigationId has a FOREIGNKEY relationship with the Disease Investigation DMO Id field.
• PerformerId has a FOREIGNKEY relationship with the Asset DMO Id field.
• RequestCodeId has a FOREIGNKEY relationship with the Code Set Bundle DMO Id field.
• RequesterId has a FOREIGNKEY relationship with the Asset DMO Id field.
• RequesterId has a FOREIGNKEY relationship with the Healthcare Provider DMO Id field.

• AccountId
• BodySiteId
• CaseId
• cdp_sys_record_currency
• ClinicalEncounterId
• ClinicalServiceRequestCategoryId
• ClinicalServiceRequestEndDate
• ClinicalServiceRequestGroupId
• ClinicalServiceRequestPriority
• ClinicalServiceRequestSignedDate
• ClinicalServiceRequestSourceChannel
• ClinicalServiceRequestStartDate
• ClinicalServiceRequestStatus
• ClinicalServiceRequestType
• ClinicalServiceRqstPreqCodeId
• ClinicalServiceRqstQtyType
• CreatedDateTime
• DataSourceId
• DataSourceObjectId
• DiagnosticSummaryId
• DiseaseInvestigationId
• HasPrerequisites
• HealthcareFacilityCodeId
• HealthcareFacilityId
• HealthcarePerformerTypeCodeId
• Id
• InternalOrganizationId
• IsAccepted
• KQ_AccountId
• KQ_BodySiteId
• KQ_CaseId
• KQ_ClinicalServiceRequestCategoryId
• KQ_ClinicalServiceRequestGroupId
• KQ_ClinicalServiceRqstPreqCodeId
• KQ_DiagnosticSummaryId
• KQ_HealthcareFacilityCodeId
• KQ_HealthcareFacilityId
• KQ_HealthcarePerformerTypeCodeId
• KQ_Id
• KQ_OriginalClinicalServiceRequestId
• KQ_PatientHealthConditionId
• KQ_PerformerId
• KQ_QuantityNumeratorUnitOfMeasureId
• KQ_ReasonCodeId
• KQ_RelatedCareObservationId
• KQ_RequesterId
• Name
• OriginalClinicalServiceRequestId
• PatientHealthConditionId
• PatientInstructionText
• PerformerId
• PerformerObject
• QuantityDenominatorNumber
• QuantityNumeratorNumber
• QuantityNumeratorUnitOfMeasureId
• ReasonCodeId
• ReferralScore
• RelatedCareObservationId
• RequestCodeId
• RequesterId
• RequesterObject
• StatusReason

• Field API Name: ssot__AccountId__c
• Data Type: TEXT
• Description: a person receiving or registered to receive medical treatment.

• Field API Name: ssot__BodySiteId__c
• Data Type: TEXT
• Description: Location on the body of a Patient Health Condition. Based on HL7 body-site. Examples: 263002 for ‘Thoracic Nerve’ and 256002 for ‘Kupffer Cell’.

• Field API Name: ssot__CaseId__c
• Data Type: TEXT
• Description: The case associated with the clinical service request.

• 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__ClinicalEncounterId__c
• Data Type: TEXT
• Description: An encounter is an interaction between a patient and healthcare provider(s) for the purpose of providing healthcare service(s) or assessing the health status of a patient.

• Field API Name: ssot__ClinicalServiceRequestCategoryId__c
• Data Type: TEXT
• Description: The category of the clinical service request. Based on HL7 servicerequest-category. Eample values: 108252007 ‘Laboratory procedure’, 409063005 ‘Counselling’, 409073007 ‘Education.

• Field API Name: ssot__ClinicalServiceRequestEndDate__c
• Data Type: DATETIME
• Description: The end time for the service request.

• Field API Name: ssot__ClinicalServiceRequestGroupId__c
• Data Type: TEXT
• Description: A clinical service request that serves to group others.

• Field API Name: ssot__ClinicalServiceRequestPriority__c
• Data Type: TEXT
• Description: The priority of the service request. Values: routine, urgent, ASAP.

• Field API Name: ssot__ClinicalServiceRequestSignedDate__c
• Data Type: DATETIME
• Description: The date the service request was signed.

• Field API Name: ssot__ClinicalServiceRequestSourceChannel__c
• Data Type: TEXT
• Description: The channel through which the clinical service request originated.

• Field API Name: ssot__ClinicalServiceRequestStartDate__c
• Data Type: DATETIME
• Description: The start time for the service request.

• Field API Name: ssot__ClinicalServiceRequestStatus__c
• Data Type: TEXT
• Description: The status of the service request. Values: Draft, Active, On-Hold, Revoked, Completed, Entered-in-Error, Unknown.

• Field API Name: ssot__ClinicalServiceRequestType__c
• Data Type: TEXT
• Description: The type of the service request. Values: Proposal, Plan, Directive, Order, Original-Order, Reflex-Order, Filler-Order, Instance-Order, Option.

• Field API Name: ssot__ClinicalServiceRqstPreqCodeId__c
• Data Type: TEXT
• Description: Definition TBD, part of Code Set.

• Field API Name: ssot__ClinicalServiceRqstQtyType__c
• Data Type: TEXT
• Description: Indicates the type of quantity related to the service request.

• Field API Name: ssot__CreatedDateTime__c
• Data Type: DATETIME
• Description: The date and time when the clinical service request was created.

• 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__DiagnosticSummaryId__c
• Data Type: TEXT
• Description: The findings and interpretation of diagnostic tests performed on patients, groups of patients, devices, and locations, and/or specimens derived from these. Example: Laboratory (Clinical Chemistry, Haematology, Microbiology,).

• Field API Name: ssot__DiseaseInvestigationId__c
• Data Type: TEXT
• Description: The disease investigation related to the clinical service request.

• Field API Name: ssot__HasPrerequisites__c
• Data Type: BOOLEAN
• Description: True if there are any prerequisites for the service request.

• Field API Name: ssot__HealthcareFacilityCodeId__c
• Data Type: TEXT
• Description: Definition TBD, part of Code Set.

• Field API Name: ssot__HealthcareFacilityId__c
• Data Type: TEXT
• Description: A physical facility where medical care is given or pharmaceuticals are dispensed.

• Field API Name: ssot__HealthcarePerformerTypeCodeId__c
• Data Type: TEXT
• Description: Definition TBD, part of Code Set.

• Field API Name: ssot__Id__c
• Data Type: TEXT
• Description: Required. A unique, system-generated identifier for this ClinicalServiceRequest record. 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__IsAccepted__c
• Data Type: BOOLEAN
• Description: Whether the request must not be performed.

• Field API Name: KQ_AccountId__c
• Data Type: TEXT
• Description: Key Qualifier system field for AccountId

• Field API Name: KQ_BodySiteId__c
• Data Type: TEXT
• Description: Key Qualifier system field for BodySiteId

• Field API Name: KQ_CaseId__c
• Data Type: TEXT
• Description: Key Qualifier system field for CaseId

• Field API Name: KQ_ClinicalServiceRequestCategoryId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ClinicalServiceRequestCategoryId

• Field API Name: KQ_ClinicalServiceRequestGroupId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ClinicalServiceRequestGroupId

• Field API Name: KQ_ClinicalServiceRqstPreqCodeId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ClinicalServiceRqstPreqCodeId

• Field API Name: KQ_DiagnosticSummaryId__c
• Data Type: TEXT
• Description: Key Qualifier system field for DiagnosticSummaryId

• Field API Name: KQ_HealthcareFacilityCodeId__c
• Data Type: TEXT
• Description: Key Qualifier system field for HealthcareFacilityCodeId

• Field API Name: KQ_HealthcareFacilityId__c
• Data Type: TEXT
• Description: Key Qualifier system field for HealthcareFacilityId

• Field API Name: KQ_HealthcarePerformerTypeCodeId__c
• Data Type: TEXT
• Description: Key Qualifier system field for HealthcarePerformerTypeCodeId

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

• Field API Name: KQ_OriginalClinicalServiceRequestId__c
• Data Type: TEXT
• Description: Key Qualifier system field for OriginalClinicalServiceRequestId

• Field API Name: KQ_PatientHealthConditionId__c
• Data Type: TEXT
• Description: Key Qualifier system field for PatientHealthConditionId

• Field API Name: KQ_PerformerId__c
• Data Type: TEXT
• Description: Key Qualifier system field for PerformerId

• Field API Name: KQ_QuantityNumeratorUnitOfMeasureId__c
• Data Type: TEXT
• Description: Key Qualifier system field for QuantityNumeratorUnitOfMeasureId

• Field API Name: KQ_ReasonCodeId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ReasonCodeId

• Field API Name: KQ_RelatedCareObservationId__c
• Data Type: TEXT
• Description: Key Qualifier system field for RelatedCareObservationId

• Field API Name: KQ_RequesterId__c
• Data Type: TEXT
• Description: Key Qualifier system field for RequesterId

• Field API Name: ssot__Name__c
• Data Type: TEXT
• Description: Name of a Clinical Service Request.

• Field API Name: ssot__OriginalClinicalServiceRequestId__c
• Data Type: TEXT
• Description: A record of a request for a procedure or diagnostic or other service to be planned, proposed, or performed with or on a patient. Example: 1) Request for Head CT procedure 2) Order for an implant or a CT scan or lipid panel.

• Field API Name: ssot__PatientHealthConditionId__c
• Data Type: TEXT
• Description: The justification of why the procedure was performed.

• Field API Name: ssot__PatientInstructionText__c
• Data Type: TEXT
• Description: Instructions for the patient.

• Field API Name: ssot__PerformerId__c
• Data Type: TEXT
• Description: The record is of the person or device that performs the service request.

• Field API Name: ssot__PerformerObject__c
• Data Type: TEXT
• Description: The object name of the performer record id.

• Field API Name: ssot__QuantityDenominatorNumber__c
• Data Type: DOUBLE
• Description: The denominator value of the quantity associated with the service request.

• Field API Name: ssot__QuantityNumeratorNumber__c
• Data Type: DOUBLE
• Description: The numerator value of the quantity associated with the service request.

• Field API Name: ssot__QuantityNumeratorUnitOfMeasureId__c
• Data Type: TEXT
• Description: The numerator value of the quantity associated with the clinical service request.

• Field API Name: ssot__ReasonCodeId__c
• Data Type: TEXT
• Description: The system-generated code that justifies the service request.

• Field API Name: ssot__ReferralScore__c
• Data Type: DOUBLE
• Description: A calculated score indicating the priority of the referral for the clinical service request.

• Field API Name: ssot__RelatedCareObservationId__c
• Data Type: TEXT
• Description: Measurements and simple assertions made about a patient, device or other subject. Example: Glucose levels in blood.

• Field API Name: ssot__RequestCodeId__c
• Data Type: TEXT
• Description: Definition TBD, part of Code Set.

• Field API Name: ssot__RequesterId__c
• Data Type: TEXT
• Description: The record is of the person or device that requested the service request.

• Field API Name: ssot__RequesterObject__c
• Data Type: TEXT
• Description: The object name of the requester record id.

• Field API Name: ssot__StatusReason__c
• Data Type: TEXT
• Description: The reason for the current status of the clinical service request.