Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HEQAFormList The table contains list of Quality Assuarance Forms triggered by 3rd party tool QSFilter and/or persisted in the 3rd party tool QSMED
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNot null Unique identifier that can be used for referencing records in this table
IsDeletedsmallintNot null Indicates if the record is active, supported values: 0 - record is active, 1 - record is inactive
Patient_oidintNot null References the ObjectID from the table HPatient
BirthdatedatetimeNull Birth date of the Patient
PatientAccountIDVarchar(20)Not null References PatientAccountID from HPatientVisit, unique ID of a Hospital Stay from SAP
StartingVisit_oidIntNot null References ObjectID from HPatientVisit
OpNumIntNot null Identifier of the Form instance generated by QSMed; uniquely identifies form instance inside of the corresponding Hospital Stay. 0 if FormStatus = -1, i.e. the Form is triggered but not created yet in QSMED
AdmissionDateTimeSmalldatetimeNot null Admission date of the Hospital Stay
DischargeDateTimeSmalldatetimeNot null Discharge date of the Hospital Stay or MAX_DATE if the Patient is not discharged yet
LastIPVisit_oidIntNot null References ObjectID from HPatientVisit
LastIPVisitMRU_oidIntNot null References ObjectID from HHealthcareUnit table for the last Department of the Hospital Stay
LastIPVisitLocation_oidIntNot null References ObjectID from HHealthcareUnit table for the last Patient Location of the Hospital Stay
OPVisit_oidIntNot null References ObjectID from HPatientVisit for the Visit associated with the triggering Procedure, otherwise NULL
OPVisitMRU_oidIntNot null References ObjectID from HHealthcareUnit table for the Department of the Visit associated with the triggering Procedure, otherwise NULL
FormIDVarchar(10)Not null Identifies type of the Form, supported values are defined by QSMED
FormNameVarchar(50)Not null Descriptive name of the Form type, defined by QSMED
FormObligationChar(1)Not null Defines the obligation for the Form; supported values:
'B' - nationwide, 'L' - statewide, 'K' - internal Hospital, 'I' - internal Hospital voluntary, 'F' - voluntary, 'N' - no Obligation, i.e. the Form is not triggered
FormStatusintNot null Status of the Form. Supported values:
1 - not documented(no Form instance has been created yet, but suggested by QSFilter)
0 - in progress
1 - released
3 - exported(Form sent to clearing centre, no answer yet)
2 - approved(Form sent to clearing centre, response of clearing centre 'OK')
4 - rejected(Form sent to clearing centre, response from clearing centre 'Not OK')
5 - cancelled(Form instance was created and then cancelled)
FormErrorStatusintNot null Error status of the Form reported by QSMED. Valid only if the FormStatus = 0(in progress).
Supported values: 0 - OK, 1 - Errors, 2 - Warnings
StornointNot null Triggered status of the Form instance as reported by QSFilter. Supported values:
0 - required, i.e. triggered
1 - not required because Patient admitted in previous year('Ueberlieger'); currently the code is not supported by QSFilter, instead 3 is returned, due to changes in AQUA specs
2 - not required because Admission date does not match QA specs
3 - not triggered
4 - Form is not known to the QSFilter(for Forms that do not belong to the standard set triggered by QSFilter but can be configured in qscust.def)
5 - not required because another Form of the same type exists for the same Hospital Stay
FullSortStringVarchar(300)Null String in the following format:(LastName padded to 60 chars)(FirstName padded to 30 chars)(Birthdate in ISO)(PatientOID padded with 0 to 20 chars)
FormCompletedDatesmalldatetimeNot null Date/time when the Form was transferred from one of the states presentable in QA WKL into the state not presentable in QA WKL. On the opposite transfer the value is set to MAX_DATE.
Presentable states: FormStatus = 'not documented'(-1) or 'in progress'(0).
ExportStateVarchar(15)Not Null Current state of the Medical Data Export by Rules Engine for the Form. Supported values:
'no_export' - no export has been performed yet, initial value
'in_progress' - export is running
'failed' - last export attempt failed
'cancelled' - last export attempt cancelled(by opening Form for editing)
'completed' - last export attempt successfully completed
ExportNoIntNot Null Sequential number of the last export attempt
ExportStateTSSmallDateTimeNull Date/time of the last export attempt
ExportStateReasonVarchar(20)Null Code for the reason of the most recent update of ExportState field value, supported values:
(empty string) - successful execution of the automatic export, no export attempt or manual export
'Success' - successful execution of the automatic export
'No_RulesEngine' - Rules Engine wrapper returned error code 61801, Rules Engine is not installed
'No_RulesEngineLiz' - Rules Engine wrapper returned error code 61844, no lizens
'No_EQA_Rules' - Rules Engine wrapper returned error code 61841, no EQA-related rules found
'RulesEngine_Down' - Rules Engine wrapper returned error code 61836, Rules Engine is down
'Unspecified_reason' - any other code returned by Rules Engine wrapper
IsReleasedBeforeLinkingbitnot NULL 'True'(1) if the Form has been released before the Medical Case became part of a Recurrent Medical Case, otherwise 'false'(0)

Return to Table-Index

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