Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
DPC_UserHistory Contains history of changes of various DPC (Diagnosis and Procedure Coding) and DRG (Diagnosis-Related Grouping) - related information
Column Name Column Datatype Column Null Option Column Comment
UserHistoryOIDintNOT NULL unique ID for referencing records from this table
PatientAccountIDvarchar(30)NOT NULL References PatientAccountID from HPatientVisit, unique ID of a Hospital Stay from SAP
VisitOIDintNULL Interpretation depends on the value in the KindOfEntry field:
if KindOfEntry='E' - ObjectID from the HVisitActivity table from the chronologically first record belonging to the departmental Visit
if KindOfEntry='P' - ObjectID from the HPatientVisit table for the Visit associated with the Procedure, can be NULL if the Procedure is captured at Medical Case level
if KindOfEntry='S', 'G', 'H' - always NULL
UpdateTimedatetimeNOT NULL date/time when the change documented in the record took place
UserOIDintNULL ObjectID from the HSUser table, interpretation depends on the value in the KindOfEntry field:
if KindOfEntry='E' - User that updated the Departmental Visit status
if KindOfEntry='S' - User that updated the Medical Case status
if KindOfEntry='P' - User that updated the Procedure
if KindOfEntry='D' - User that updated the Diagnosis
if KindOfEntry='G' - User that updated the DRG Grouping
if KindOfEntry='H' - User that updated the Departmental Status
LoginIDvarchar(100)NULL LoginID from the HSUser table for the record referenced by the value in the UserOID field
KindOfEntryvarchar(1)NOT NULL defines type of data contained in the record, supported values:
'E' - record contains an entry of Departmental Visit Status(Soarian) change history for a departmental Visit
'S' - record contains an entry of Medical Case Status change history for Hospital Stay
'P' - record contains data of updated Procedure(OPS)
'D' - record contains data of updated Diagnosis
'H' - record contains data of Departmental Status(SAP)
'G' - record contains data of DRG Grouping change
KindOfActionvarchar(1)NOT NULL Interpretation depends on the value in the KindOfEntry field:
if KindOfEntry='E', 'S', 'G' or 'H' - always 'U', meaning 'update'
if KindOfEntry='P' - 'D' for deleted, 'U' for updated, 'I' for created Procedure
if KindOfEntry='D' - 'D' for deleted, 'U' for updated, 'I' for created Diagnosis
SAPIDvarchar(30)NULL Interpretation depends on the value in the KindOfEntry field:
if KindOfEntry='E' - HCUExternalAbbr from the HHealthcareUnit table for the Unit of the departmental Visit, matches Unit ID from SAP
if KindOfEntry='P' - SeqNo value associated with the Procedure in SAP
if KindOfEntry='D' - string in format @ where is the ICD code of the Diagnosis and is the SeqNo of the Diagnosis reported by SAP
if KindOfEntry='G', 'S' - always NULL
if KindOfEntry='H' - Departmental Status code, supported values are configurable in SAP
EntryValuevarchar(30)NOT NULL Interpretation depends on the value in the KindOfEntry field:
if KindOfEntry='E' - Departmental StatusID, supported values: 'Zu bearbeiten'(Initial), 'Codiert'(Coded), 'Freigegeben'(Released), 'Kontrolliert'(Verified)
if KindOfEntry='S' - Medical Case Status value, supported values are configurable in SAP
if KindOfEntry='P' - the OPS code of the Procedure
if KindOfEntry='D' - the ICD code of the Diagnosis
if KindOfEntry='G' - new DRG code
if KindOfEntry='H' - Departmental Status value, supported values: 'X' for 'status set'
FullUserNamevarchar(160)NULL Full name of the Staff associated with the User referenced by the value in the UserOID field
CommentTextVARCHAR(500)NULL Text of comment, supported only if KindOfEntry='E' or 'S'
CommentUserOIDINTNULL ObjectID from the HSUser table, user that entered comment
CommentUserLastNameVARCHAR(60)NULL Last name of the Staff associated with the User that entered comment
CommentUserFirstNameVARCHAR(30)NULL First name of the Staff associated with the User that entered comment
CommentDateTimeSMALLDATETIMENULL Date/Time when comment was entered

Return to Table-Index

  Soarian Clinicals Schema Documentation  
Copyright © 2023, Oracle and/or its affiliates