Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
UserHistoryOID | int | NOT NULL | unique ID for referencing records from this table |
PatientAccountID | varchar(30) | NOT NULL | References PatientAccountID from HPatientVisit, unique ID of a Hospital Stay from SAP |
VisitOID | int | NULL | 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 |
UpdateTime | datetime | NOT NULL | date/time when the change documented in the record took place |
UserOID | int | NULL | 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 |
LoginID | varchar(100) | NULL | LoginID from the HSUser table for the record referenced by the value in the UserOID field |
KindOfEntry | varchar(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 |
KindOfAction | varchar(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 |
SAPID | varchar(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 |
EntryValue | varchar(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' |
FullUserName | varchar(160) | NULL | Full name of the Staff associated with the User referenced by the value in the UserOID field |
CommentText | VARCHAR(500) | NULL | Text of comment, supported only if KindOfEntry='E' or 'S' |
CommentUserOID | INT | NULL | ObjectID from the HSUser table, user that entered comment |
CommentUserLastName | VARCHAR(60) | NULL | Last name of the Staff associated with the User that entered comment |
CommentUserFirstName | VARCHAR(30) | NULL | First name of the Staff associated with the User that entered comment |
CommentDateTime | SMALLDATETIME | NULL | Date/Time when comment was entered |