Patient Medical Procedure DMO

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

• PatientMedicalProcedureCodeId has a FOREIGNKEY relationship with the Code Set Bundle DMO Id field.
• PatientMedProcdStatusReasonCodeId has a FOREIGNKEY relationship with the Code Set Bundle DMO Id field.
• PatientId has a FOREIGNKEY relationship with the Patient DMO Id field.
• HealthcareProcedureId has a FOREIGNKEY relationship with the Healthcare Procedure DMO Id field.
• EstimatedUpperLengthUnitId has a FOREIGNKEY relationship with the Unit of Measure DMO Id field.
• EstimatedUpperDurationUnitId has a FOREIGNKEY relationship with the Unit of Measure DMO Id field.
• EstimatedLowerLengthUnitId has a FOREIGNKEY relationship with the Unit of Measure DMO Id field.
• EstimatedLowerDurationUnitId has a FOREIGNKEY relationship with the Unit of Measure DMO Id field.
• ReasonReferenceId has a FOREIGNKEY relationship with the Patient Health Condition DMO Id field.
• ReasonReferenceId has a FOREIGNKEY relationship with the Diagnostic Summary DMO Id field.
• ReasonReferenceId has a FOREIGNKEY relationship with the Care Observation DMO Id field.
• ProcedureAgeUOMId has a FOREIGNKEY relationship with the Unit of Measure DMO Id field.
• PerformedAtAgeUOMId has a FOREIGNKEY relationship with the Unit of Measure DMO Id field.
• PerformedAgeRangeUOMd has a FOREIGNKEY relationship with the Unit of Measure DMO Id field.
• PatientMedicalProcedureTypeId has a FOREIGNKEY relationship with the Code Set Bundle DMO Id field.
• RecordCreatedById has a FOREIGNKEY relationship with the Healthcare Provider DMO Id field.
• EstimatedDurationUnitId has a FOREIGNKEY relationship with the Unit of Measure DMO Id field.
• DiagnosticSummaryId has a FOREIGNKEY relationship with the Diagnostic Summary DMO Id field.
• ClinicalEncounterId has a FOREIGNKEY relationship with the Clinical Encounter DMO Id field.
• AssertionSourceId has a FOREIGNKEY relationship with the Healthcare Provider DMO Id field.
• AssertionSourceId has a FOREIGNKEY relationship with the Account DMO Id field.
• AccountId has a FOREIGNKEY relationship with the Account DMO Id field.
• HealthcareFacilityId has a FOREIGNKEY relationship with the Healthcare Facility DMO Id field.
• ReasonReferenceId has a FOREIGNKEY relationship with the Patient Medical Procedure DMO Id field.

• AccountId
• AssertionSourceId
• AssertionSourceObjectName
• cdp_sys_record_currency
• ClinicalEncounterId
• DataSourceId
• DataSourceObjectId
• DiagnosticSummaryId
• DurationTimeStringText
• EstimatedDurationUnitId
• EstimatedLowerDurationNumber
• EstimatedLowerDurationUnitId
• EstimatedLowerLengthNumber
• EstimatedLowerLengthUnitId
• EstimatedUpperDurationNumber
• EstimatedUpperDurationUnitId
• EstimatedUpperLengthNumber
• EstimatedUpperLengthUnitId
• HealthcareFacilityId
• HealthcareProcedureId
• Id
• InternalOrganizationId
• KQ_AccountId
• KQ_AssertionSourceId
• KQ_ClinicalEncounterId
• KQ_DiagnosticSummaryId
• KQ_EstimatedDurationUnitId
• KQ_EstimatedLowerDurationUnitId
• KQ_EstimatedLowerLengthUnitId
• KQ_EstimatedUpperDurationUnitId
• KQ_EstimatedUpperLengthUnitId
• KQ_HealthcareFacilityId
• KQ_HealthcareProcedureId
• KQ_Id
• KQ_PatientId
• KQ_PatientMedicalProcedureCodeId
• KQ_PatientMedicalProcedureTypeId
• KQ_PatientMedProcdStatusReasonCodeId
• KQ_PerformedAgeRangeUOMd
• KQ_PerformedAtAgeUOMId
• KQ_ProcedureAgeUOMId
• KQ_ReasonReferenceId
• KQ_RecordCreatedById
• Name
• PatientId
• PatientMedicalProcedureCodeId
• PatientMedicalProcedureEndDate
• PatientMedicalProcedureOutcomeCode
• PatientMedicalProcedureReasonCode
• PatientMedicalProcedureStartDate
• PatientMedicalProcedureStatus
• PatientMedicalProcedureTypeId
• PatientMedProcdStatusReasonCodeId
• PerformedAgeRangeUOMd
• PerformedAtAgeLowerLimitNumber
• PerformedAtAgeNumber
• PerformedAtAgeUOMId
• PerformedAtAgeUpperLimitNumber
• ProcedureAgeNumber
• ProcedureAgeUOMId
• ReasonReferenceId
• ReasonReferenceObjectName
• RecordCreatedById
• RecordCreatedByObjectName

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

• Field API Name: ssot__AssertionSourceId__c
• Data Type: TEXT
• Description: The Individual who is making the procedure statement.

• Field API Name: ssot__AssertionSourceObjectName__c
• Data Type: TEXT
• Description: The name of the object of the assertion source record.

• 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__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__DurationTimeStringText__c
• Data Type: TEXT
• Description: Estimated or actual date, date-time, period, or age when the procedure was performed. Allows a period to support complex procedures that span more than one date, and also allows for the length of the procedure to be captured.

• Field API Name: ssot__EstimatedDurationUnitId__c
• Data Type: TEXT
• Description: The Unit of Time used in measurements of the medical procedure. Examples include minutes, hours, days.

• Field API Name: ssot__EstimatedLowerDurationNumber__c
• Data Type: DOUBLE
• Description: Estimated or actual date, date-time, period, or age when the procedure was performed. Allows a period to support complex procedures that span more than one date, and also allows for the length of the procedure to be captured.

• Field API Name: ssot__EstimatedLowerDurationUnitId__c
• Data Type: TEXT
• Description: The Unit of Time used in measurements of the medical procedure. Examples include minutes, hours, days.

• Field API Name: ssot__EstimatedLowerLengthNumber__c
• Data Type: DOUBLE
• Description: Estimated or actual date, date-time, period, or age when the procedure was performed. Allows a period to support complex procedures that span more than one date, and also allows for the length of the procedure to be captured.

• Field API Name: ssot__EstimatedLowerLengthUnitId__c
• Data Type: TEXT
• Description: The Unit of Time used in measurements of the medical procedure. Examples include minutes, hours, days.

• Field API Name: ssot__EstimatedUpperDurationNumber__c
• Data Type: DOUBLE
• Description: Estimated or actual date, date-time, period, or age when the procedure was performed. Allows a period to support complex procedures that span more than one date, and also allows for the length of the procedure to be captured.

• Field API Name: ssot__EstimatedUpperDurationUnitId__c
• Data Type: TEXT
• Description: The Unit of Time used in measurements of the medical procedure. Examples include minutes, hours, days.

• Field API Name: ssot__EstimatedUpperLengthNumber__c
• Data Type: DOUBLE
• Description: Estimated or actual date, date-time, period, or age when the procedure was performed. Allows a period to support complex procedures that span more than one date, and also allows for the length of the procedure to be captured.

• Field API Name: ssot__EstimatedUpperLengthUnitId__c
• Data Type: TEXT
• Description: The Unit of Time used in measurements of the medical procedure. Examples include minutes, hours, days.

• 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__HealthcareProcedureId__c
• Data Type: TEXT
• Description: A medical procedure is a course of action intended to achieve a result in the delivery of healthcare. Other common kinds of procedures are therapeutic (, intended to treat, cure, or restore function or structure), such as surgical and physical rehab.

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

• Field API Name: KQ_AssertionSourceId__c
• Data Type: TEXT
• Description: Key Qualifier system field for AssertionSourceId

• Field API Name: KQ_ClinicalEncounterId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ClinicalEncounterId

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

• Field API Name: KQ_EstimatedDurationUnitId__c
• Data Type: TEXT
• Description: Key Qualifier system field for EstimatedDurationUnitId

• Field API Name: KQ_EstimatedLowerDurationUnitId__c
• Data Type: TEXT
• Description: Key Qualifier system field for EstimatedLowerDurationUnitId

• Field API Name: KQ_EstimatedLowerLengthUnitId__c
• Data Type: TEXT
• Description: Key Qualifier system field for EstimatedLowerLengthUnitId

• Field API Name: KQ_EstimatedUpperDurationUnitId__c
• Data Type: TEXT
• Description: Key Qualifier system field for EstimatedUpperDurationUnitId

• Field API Name: KQ_EstimatedUpperLengthUnitId__c
• Data Type: TEXT
• Description: Key Qualifier system field for EstimatedUpperLengthUnitId

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

• Field API Name: KQ_HealthcareProcedureId__c
• Data Type: TEXT
• Description: Key Qualifier system field for HealthcareProcedureId

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

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

• Field API Name: KQ_PatientMedicalProcedureCodeId__c
• Data Type: TEXT
• Description: Key Qualifier system field for PatientMedicalProcedureCodeId

• Field API Name: KQ_PatientMedicalProcedureTypeId__c
• Data Type: TEXT
• Description: Key Qualifier system field for PatientMedicalProcedureTypeId

• Field API Name: KQ_PatientMedProcdStatusReasonCodeId__c
• Data Type: TEXT
• Description: Key Qualifier system field for PatientMedProcdStatusReasonCodeId

• Field API Name: KQ_PerformedAgeRangeUOMd__c
• Data Type: TEXT
• Description: Key Qualifier system field for PerformedAgeRangeUOMd

• Field API Name: KQ_PerformedAtAgeUOMId__c
• Data Type: TEXT
• Description: Key Qualifier system field for PerformedAtAgeUOMId

• Field API Name: KQ_ProcedureAgeUOMId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ProcedureAgeUOMId

• Field API Name: KQ_ReasonReferenceId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ReasonReferenceId

• Field API Name: KQ_RecordCreatedById__c
• Data Type: TEXT
• Description: Key Qualifier system field for RecordCreatedById

• Field API Name: ssot__Name__c
• Data Type: TEXT
• Description: Required. The primary name or label for this PatientMedicalProcedure record. Maximum size is 255 characters.

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

• Field API Name: ssot__PatientMedicalProcedureCodeId__c
• Data Type: TEXT
• Description: The specific procedure that’s performed. Based on HL7 procedure-code. Examples: 245002 for ‘Division of nerve ganglion’, 334003 for ‘Panorex examination of mandible.

• Field API Name: ssot__PatientMedicalProcedureEndDate__c
• Data Type: DATETIME
• Description: Estimated or actual date, date-time, period, or age when the procedure was performed. Allows a period to support complex procedures that span more than one date, and also allows for the length of the procedure to be captured.

• Field API Name: ssot__PatientMedicalProcedureOutcomeCode__c
• Data Type: TEXT
• Description: The outcome of the procedure: did it resolve the reasons for the procedure being performed?. Based on HL7 procedure-outcome. Values: Successful, Unsuccessful, Partially Successful.

• Field API Name: ssot__PatientMedicalProcedureReasonCode__c
• Data Type: TEXT
• Description: The justification of why the procedure was performed. Based on HL7 procedure-reason. Examples: 12003 for ‘Choroidal hemorrhage’, 140004 for ‘Chronic pharyngitis’.

• Field API Name: ssot__PatientMedicalProcedureStartDate__c
• Data Type: DATETIME
• Description: Estimated or actual date, date-time, period, or age when the procedure was performed. Allows a period to support complex procedures that span more than one date, and also allows for the length of the procedure to be captured.

• Field API Name: ssot__PatientMedicalProcedureStatus__c
• Data Type: TEXT
• Description: The state of the medical procedure. Generally, this is the in-progress or completed state. Based on HL7.event-status. Example values: preparation, in-progress, not-done, on-hold, stopped.

• Field API Name: ssot__PatientMedicalProcedureTypeId__c
• Data Type: TEXT
• Description: classifies the procedure for searching, sorting and display purposes. Based on HL7.

• Field API Name: ssot__PatientMedProcdStatusReasonCodeId__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__PerformedAgeRangeUOMd__c
• Data Type: TEXT
• Description: Estimated or actual date, date-time, period, or age when the procedure was performed. Allows a period to support complex procedures that span more than one date, and also allows for the length of the procedure to be captured.

• Field API Name: ssot__PerformedAtAgeLowerLimitNumber__c
• Data Type: DOUBLE
• Description: The lower range of ages recommended for the procedure.

• Field API Name: ssot__PerformedAtAgeNumber__c
• Data Type: DOUBLE
• Description: The patient’s age when the procedure was performed.

• Field API Name: ssot__PerformedAtAgeUOMId__c
• Data Type: TEXT
• Description: Estimated or actual date, date-time, period, or age when the procedure was performed. Allows a period to support complex procedures that span more than one date, and also allows for the length of the procedure to be captured.

• Field API Name: ssot__PerformedAtAgeUpperLimitNumber__c
• Data Type: DOUBLE
• Description: The upper range of ages recommended for the procedure.

• Field API Name: ssot__ProcedureAgeNumber__c
• Data Type: DOUBLE
• Description: Estimated or actual date, date-time, period, or age when the procedure was performed. Allows a period to support complex procedures that span more than one date, and also allows for the length of the procedure to be captured.

• Field API Name: ssot__ProcedureAgeUOMId__c
• Data Type: TEXT
• Description: Estimated or actual date, date-time, period, or age when the procedure was performed. Allows a period to support complex procedures that span more than one date, and also allows for the length of the procedure to be captured.

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

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

• Field API Name: ssot__RecordCreatedById__c
• Data Type: TEXT
• Description: The person/individual who originally created the record.

• Field API Name: ssot__RecordCreatedByObjectName__c
• Data Type: TEXT
• Description: The person/individual who originally created the record.