Care Request Item DMO

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

• ClinicalServiceRequestId has a FOREIGNKEY relationship with the Clinical Service Request DMO Id field.
• ClinicalDeterminationReasonId has a FOREIGNKEY relationship with the Code Set DMO Id field.
• CareRequestQuantityTypeId has a FOREIGNKEY relationship with the Unit of Measure DMO Id field.
• CareRequestId has a FOREIGNKEY relationship with the Care Request DMO Id field.
• CareRequestCaseId has a FOREIGNKEY relationship with the Case DMO Id field.
• ProcedureCodeSetId has a FOREIGNKEY relationship with the Code Set DMO Id field.
• ProcedureCodeSetId has a FOREIGNKEY relationship with the Code Set Bundle DMO Id field.
• ProcedureCodeId has a FOREIGNKEY relationship with the Healthcare Procedure DMO Id field.
• ModifierCodeSetId has a FOREIGNKEY relationship with the Code Set DMO Id field.
• ModifierCodeSetId has a FOREIGNKEY relationship with the Code Set Bundle DMO Id field.
• ModifiedProcedureCodeSetId has a FOREIGNKEY relationship with the Code Set DMO Id field.
• ModifiedProcedureCodeSetId has a FOREIGNKEY relationship with the Code Set Bundle DMO Id field.
• ModifiedProcedureCodeId has a FOREIGNKEY relationship with the Healthcare Procedure DMO Id field.
• ReasonCodeId has a FOREIGNKEY relationship with the Code Set DMO Id field.
• ReasonCodeId has a FOREIGNKEY relationship with the Care Request Diagnosis DMO Id field.
• TransportLocationId has a FOREIGNKEY relationship with the Healthcare Facility DMO Id field.
• ServicingFacilityId has a FOREIGNKEY relationship with the Healthcare Facility DMO Id field.
• ContentDocumentId has a FOREIGNKEY relationship with the Content Document DMO Id field.
• ServicingProviderId has a FOREIGNKEY relationship with the Healthcare Provider DMO Id field.
• ServicingFacilityId has a FOREIGNKEY relationship with the Healthcare Practitioner Facility DMO Id field.
• ReasonCodeId has a FOREIGNKEY relationship with the Code Set Bundle DMO Id field.

• AmbulanceTransportDistanceNumber
• AmbulanceTransportReason
• AmbulanceTransportType
• ApprovedLengthOfStayDayQuantity
• ApprovedLevelOfCare
• ApprovedServiceEndDate
• ApprovedServiceStartDate
• AuthorizationApprovalIdentifier
• AuthorizationReferenceIdentifier
• CareRequestCaseId
• CareRequestId
• CareRequestQuantityTypeId
• cdp_sys_record_currency
• ClinicalDetermination
• ClinicalDeterminationNotesText
• ClinicalDeterminationReasonId
• ClinicalServiceRequestId
• ContentDocumentId
• CurrentLevelOfCare
• DataSourceId
• DataSourceObjectId
• DecisionDateTime
• DeniedLevelOfCare
• DeniedServiceCodeDescription
• DeniedServiceQuantity
• FreeFormProcedureDescription
• Id
• InternalOrganizationId
• KQ_CareRequestCaseId
• KQ_CareRequestId
• KQ_CareRequestQuantityTypeId
• KQ_ClinicalDeterminationReasonId
• KQ_ClinicalServiceRequestId
• KQ_ContentDocumentId
• KQ_Id
• KQ_ModifiedProcedureCodeId
• KQ_ModifiedProcedureCodeSetId
• KQ_ModifierCodeSetId
• KQ_ProcedureCodeId
• KQ_ProcedureCodeSetId
• KQ_ReasonCodeId
• KQ_ServicingFacilityId
• KQ_ServicingProviderId
• KQ_TransportLocationId
• LengthOfStayDays
• MedicationApprovedQuantityNumber
• MedicationRequestDeniedQuantityNumber
• MedicationRequestedQuantityNumber
• MedicationRequestModifiedQuantityNumber
• ModifiedCodeDescription
• ModifiedCodeIdentifierText
• ModifiedCodeType
• ModifiedCodeTypeIdentifierText
• ModifiedEffectiveDate
• ModifiedEndDate
• ModifiedLevelOfCare
• ModifiedProcedureCodeId
• ModifiedProcedureCodeSetId
• ModifiedProcedureCodeSetObject
• ModifiedProcedureCodeType
• ModifiedServiceCodeModifier
• ModifiedServiceCodeModifier2
• ModifiedServiceCodeModifier2Desc
• ModifiedServiceCodeModifier3Desc
• ModifiedServiceCodeModifier4
• ModifiedServiceCodeModifier4Desc
• ModifiedServiceCodeModifierDesc
• ModifiedServiceCodModifier3
• ModifierCodeSetId
• ModifierCodeSetObject
• Name
• Priority
• ProcedureCodeId
• ProcedureCodeSetId
• ProcedureCodeSetObject
• ReasonCodeId
• ReasonCodeObject
• RequestedLengthOfStayDayQuantity
• RequestedLevelOfCare
• RequestedQuantity
• RequestedServiceEndDate
• RequestedServiceStartDate
• RequestStatus
• RequestStatusReason
• ServiceCategoryCodeText
• ServiceCategoryText
• ServiceCodeType
• ServiceCodeTypeIdentifier
• ServiceEffectiveDate
• ServiceEndDate
• ServicingFacilityId
• ServicingFacilityObject
• ServicingProviderId
• SourceSystemIdentifierText
• SourceSystemModifiedDate
• SourceSystemText
• TransportLocationId
• Type

• Field API Name: ssot__AmbulanceTransportDistanceNumber__c
• Data Type: DOUBLE
• Description: Numeric value representing the ambulance transport distance number. Do not include currency symbols or commas.

• Field API Name: ssot__AmbulanceTransportReason__c
• Data Type: TEXT
• Description: Reason for ambulance transport.

• Field API Name: ssot__AmbulanceTransportType__c
• Data Type: TEXT
• Description: The type of ambulance transport.

• Field API Name: ssot__ApprovedLengthOfStayDayQuantity__c
• Data Type: DOUBLE
• Description: The number of days requested for the admission.

• Field API Name: ssot__ApprovedLevelOfCare__c
• Data Type: TEXT
• Description: The approved level of care for the patient.

• Field API Name: ssot__ApprovedServiceEndDate__c
• Data Type: DATEONLY
• Description: The end date of the approved service that the patient received.

• Field API Name: ssot__ApprovedServiceStartDate__c
• Data Type: DATEONLY
• Description: The start date of the approved service that the patient received.

• Field API Name: ssot__AuthorizationApprovalIdentifier__c
• Data Type: TEXT
• Description: The unique identifier assigned to the item on approval of the authorization request.

• Field API Name: ssot__AuthorizationReferenceIdentifier__c
• Data Type: TEXT
• Description: Alphanumeric string representing the authorization reference identifier.

• Field API Name: ssot__CareRequestCaseId__c
• Data Type: TEXT
• Description: The case related to the care request.

• Field API Name: ssot__CareRequestId__c
• Data Type: TEXT
• Description: The care request for the care request item.

• Field API Name: ssot__CareRequestQuantityTypeId__c
• Data Type: TEXT
• Description: Quantity type for the request, such as days, units, or visits. This is a One to One (1:1) relationship field. CareRequestItems is the relationship name and Unit of Measure is the referenced object. Maximum size is 36 characters.

• 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__ClinicalDetermination__c
• Data Type: TEXT
• Description: The clinical determination of the care request.

• Field API Name: ssot__ClinicalDeterminationNotesText__c
• Data Type: TEXT
• Description: Alphanumeric string representing the clinical determination notes text.

• Field API Name: ssot__ClinicalDeterminationReasonId__c
• Data Type: TEXT
• Description: The reason for the clinical determination.

• Field API Name: ssot__ClinicalServiceRequestId__c
• Data Type: TEXT
• Description: The clinical service request associated with the care request item.

• Field API Name: ssot__ContentDocumentId__c
• Data Type: TEXT
• Description: The content document that’s attached to the reviewer note.

• Field API Name: ssot__CurrentLevelOfCare__c
• Data Type: TEXT
• Description: The level of care the patient is receiving.

• 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__DecisionDateTime__c
• Data Type: DATETIME
• Description: The date and time when the last decision was made for this care request item.

• Field API Name: ssot__DeniedLevelOfCare__c
• Data Type: TEXT
• Description: The level of care denied for the patient.

• Field API Name: ssot__DeniedServiceCodeDescription__c
• Data Type: TEXT
• Description: Description of the denied service code.

• Field API Name: ssot__DeniedServiceQuantity__c
• Data Type: DOUBLE
• Description: The quantity of the denied service.

• Field API Name: ssot__FreeFormProcedureDescription__c
• Data Type: TEXT
• Description: Free-form description of the procedure.

• Field API Name: ssot__Id__c
• Data Type: TEXT
• Description: Required. A unique, system-generated identifier for this CareRequestItem 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: KQ_CareRequestCaseId__c
• Data Type: TEXT
• Description: Key Qualifier system field for CareRequestCaseId

• Field API Name: KQ_CareRequestId__c
• Data Type: TEXT
• Description: Key Qualifier system field for CareRequestId

• Field API Name: KQ_CareRequestQuantityTypeId__c
• Data Type: TEXT
• Description: Key Qualifier system field for CareRequestQuantityTypeId

• Field API Name: KQ_ClinicalDeterminationReasonId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ClinicalDeterminationReasonId

• Field API Name: KQ_ClinicalServiceRequestId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ClinicalServiceRequestId

• Field API Name: KQ_ContentDocumentId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ContentDocumentId

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

• Field API Name: KQ_ModifiedProcedureCodeId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ModifiedProcedureCodeId

• Field API Name: KQ_ModifiedProcedureCodeSetId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ModifiedProcedureCodeSetId

• Field API Name: KQ_ModifierCodeSetId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ModifierCodeSetId

• Field API Name: KQ_ProcedureCodeId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ProcedureCodeId

• Field API Name: KQ_ProcedureCodeSetId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ProcedureCodeSetId

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

• Field API Name: KQ_ServicingFacilityId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ServicingFacilityId

• Field API Name: KQ_ServicingProviderId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ServicingProviderId

• Field API Name: KQ_TransportLocationId__c
• Data Type: TEXT
• Description: Key Qualifier system field for TransportLocationId

• Field API Name: ssot__LengthOfStayDays__c
• Data Type: DOUBLE
• Description: The number of days a patient is admitted.

• Field API Name: ssot__MedicationApprovedQuantityNumber__c
• Data Type: DOUBLE
• Description: The approved quantity of the care item.

• Field API Name: ssot__MedicationRequestDeniedQuantityNumber__c
• Data Type: DOUBLE
• Description: Quantity of medication requested that was denied.

• Field API Name: ssot__MedicationRequestedQuantityNumber__c
• Data Type: DOUBLE
• Description: The quantity of the item that is requested.

• Field API Name: ssot__MedicationRequestModifiedQuantityNumber__c
• Data Type: DOUBLE
• Description: The modified quantity of requested care.

• Field API Name: ssot__ModifiedCodeDescription__c
• Data Type: TEXT
• Description: Description of the modified service code.

• Field API Name: ssot__ModifiedCodeIdentifierText__c
• Data Type: TEXT
• Description: Alphanumeric string representing the modified code identifier text.

• Field API Name: ssot__ModifiedCodeType__c
• Data Type: TEXT
• Description: Code type for the modified service.

• Field API Name: ssot__ModifiedCodeTypeIdentifierText__c
• Data Type: TEXT
• Description: Alphanumeric string representing the modified code type identifier text.

• Field API Name: ssot__ModifiedEffectiveDate__c
• Data Type: DATEONLY
• Description: Effective date for the modified service.

• Field API Name: ssot__ModifiedEndDate__c
• Data Type: DATEONLY
• Description: Termination date for the modified service.

• Field API Name: ssot__ModifiedLevelOfCare__c
• Data Type: TEXT
• Description: The modified level of care for the patient.

• Field API Name: ssot__ModifiedProcedureCodeId__c
• Data Type: TEXT
• Description: The code for the modified service, drug, or equipment. ModifiedProcedureCodeId is deprecated in a future release, so use ModifiedProcedureCodeSetId instead.

• Field API Name: ssot__ModifiedProcedureCodeSetId__c
• Data Type: TEXT
• Description: The code set for the modified service, drug, or device associated with the care request item.

• Field API Name: ssot__ModifiedProcedureCodeSetObject__c
• Data Type: TEXT
• Description: The object name of the Modified Procedure Code Set field record.

• Field API Name: ssot__ModifiedProcedureCodeType__c
• Data Type: TEXT
• Description: Rereference to modified procedure code type.

• Field API Name: ssot__ModifiedServiceCodeModifier__c
• Data Type: TEXT
• Description: Modifier for the service code.

• Field API Name: ssot__ModifiedServiceCodeModifier2__c
• Data Type: TEXT
• Description: Second modifier for service code.

• Field API Name: ssot__ModifiedServiceCodeModifier2Desc__c
• Data Type: TEXT
• Description: Description of the second modifier for the service code.

• Field API Name: ssot__ModifiedServiceCodeModifier3Desc__c
• Data Type: TEXT
• Description: Description of the third modifier for the service code.

• Field API Name: ssot__ModifiedServiceCodeModifier4__c
• Data Type: TEXT
• Description: Fourth modifier for service code.

• Field API Name: ssot__ModifiedServiceCodeModifier4Desc__c
• Data Type: TEXT
• Description: Description of the fourth modifier for the service code.

• Field API Name: ssot__ModifiedServiceCodeModifierDesc__c
• Data Type: TEXT
• Description: Description of the modifier for the service code.

• Field API Name: ssot__ModifiedServiceCodModifier3__c
• Data Type: TEXT
• Description: Third modifier for service code.

• Field API Name: ssot__ModifierCodeSetId__c
• Data Type: TEXT
• Description: The modifier code set for the service code associated with the care request item.

• Field API Name: ssot__ModifierCodeSetObject__c
• Data Type: TEXT
• Description: The object name of the modifier code set record id.

• Field API Name: ssot__Name__c
• Data Type: TEXT
• Description: ID of the service code.

• Field API Name: ssot__Priority__c
• Data Type: TEXT
• Description: The priority of the authorization for the requested item.

• Field API Name: ssot__ProcedureCodeId__c
• Data Type: TEXT
• Description: The code for the service, drug, or equipment. ProcedureCodeId is deprecated in a future release, so use ProcedureCodeSetId instead.

• Field API Name: ssot__ProcedureCodeSetId__c
• Data Type: TEXT
• Description: The code set for the service, drug, or device associated with the care request item.

• Field API Name: ssot__ProcedureCodeSetObject__c
• Data Type: TEXT
• Description: The object name of the procedure code set field record.

• Field API Name: ssot__ReasonCodeId__c
• Data Type: TEXT
• Description: The reason for requesting the item.

• Field API Name: ssot__ReasonCodeObject__c
• Data Type: TEXT
• Description: The object name of the reason code field record.

• Field API Name: ssot__RequestedLengthOfStayDayQuantity__c
• Data Type: DOUBLE
• Description: The number of days requested for the admission.

• Field API Name: ssot__RequestedLevelOfCare__c
• Data Type: TEXT
• Description: The requested level of care for the patient.

• Field API Name: ssot__RequestedQuantity__c
• Data Type: DOUBLE
• Description: The count or numerical value of the quantity for this record.

• Field API Name: ssot__RequestedServiceEndDate__c
• Data Type: DATEONLY
• Description: The end date of the requested service.

• Field API Name: ssot__RequestedServiceStartDate__c
• Data Type: DATEONLY
• Description: The start date of the requested service.

• Field API Name: ssot__RequestStatus__c
• Data Type: TEXT
• Description: The authorization status of this service. Maximum size is 36 characters.

• Field API Name: ssot__RequestStatusReason__c
• Data Type: TEXT
• Description: Reason for the authorization status of this service. Maximum size is 36 characters.

• Field API Name: ssot__ServiceCategoryCodeText__c
• Data Type: TEXT
• Description: Alphanumeric string representing the service category code text.

• Field API Name: ssot__ServiceCategoryText__c
• Data Type: TEXT
• Description: Alphanumeric string representing the service category text.

• Field API Name: ssot__ServiceCodeType__c
• Data Type: TEXT
• Description: Code type for the service.

• Field API Name: ssot__ServiceCodeTypeIdentifier__c
• Data Type: TEXT
• Description: ID of the code type for the service.

• Field API Name: ssot__ServiceEffectiveDate__c
• Data Type: DATEONLY
• Description: Effective date for the service.

• Field API Name: ssot__ServiceEndDate__c
• Data Type: DATEONLY
• Description: Termination date for the service.

• Field API Name: ssot__ServicingFacilityId__c
• Data Type: TEXT
• Description: The facility where a patient receives service of the requested item.

• Field API Name: ssot__ServicingFacilityObject__c
• Data Type: TEXT
• Description: The object name of the servicing facility field record.

• Field API Name: ssot__ServicingProviderId__c
• Data Type: TEXT
• Description: The healthcare provider who provides the service of the requested item.

• Field API Name: ssot__SourceSystemIdentifierText__c
• Data Type: TEXT
• Description: Alphanumeric string representing the source system identifier text.

• Field API Name: ssot__SourceSystemModifiedDate__c
• Data Type: DATETIME
• Description: The date on which this care request item was last updated on the source system.

• Field API Name: ssot__SourceSystemText__c
• Data Type: TEXT
• Description: System from which the request was sourced. Maximum size is 255 characters.

• Field API Name: ssot__TransportLocationId__c
• Data Type: TEXT
• Description: The destination location for ambulance transport.

• Field API Name: ssot__Type__c
• Data Type: TEXT
• Description: The type of item request. Possible values are: - Filler Order - Instance Order - Option - Order - Original Order - Plan - Proposal - Reflex Order Maximum size is 15 characters