Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | Not null | Unique identifier that can be used for referencing records in this table |
IsDeleted | smallint | Not null | Indicates if the record is active, supported values: 0 - record is active, 1 - record is inactive |
Patient_oid | int | Not null | References the ObjectID from the table HPatient |
Birthdate | datetime | Null | Birth date of the Patient |
PatientAccountID | Varchar(20) | Not null | References PatientAccountID from HPatientVisit, unique ID of a Hospital Stay from SAP |
StartingVisit_oid | Int | Not null | References ObjectID from HPatientVisit |
OpNum | Int | Not 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 |
AdmissionDateTime | Smalldatetime | Not null | Admission date of the Hospital Stay |
DischargeDateTime | Smalldatetime | Not null | Discharge date of the Hospital Stay or MAX_DATE if the Patient is not discharged yet |
LastIPVisit_oid | Int | Not null | References ObjectID from HPatientVisit |
LastIPVisitMRU_oid | Int | Not null | References ObjectID from HHealthcareUnit table for the last Department of the Hospital Stay |
LastIPVisitLocation_oid | Int | Not null | References ObjectID from HHealthcareUnit table for the last Patient Location of the Hospital Stay |
OPVisit_oid | Int | Not null | References ObjectID from HPatientVisit for the Visit associated with the triggering Procedure, otherwise NULL |
OPVisitMRU_oid | Int | Not null | References ObjectID from HHealthcareUnit table for the Department of the Visit associated with the triggering Procedure, otherwise NULL |
FormID | Varchar(10) | Not null | Identifies type of the Form, supported values are defined by QSMED |
FormName | Varchar(50) | Not null | Descriptive name of the Form type, defined by QSMED |
FormObligation | Char(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 |
FormStatus | int | Not 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) |
FormErrorStatus | int | Not 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 |
Storno | int | Not 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 |
FullSortString | Varchar(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) |
FormCompletedDate | smalldatetime | Not 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). |
ExportState | Varchar(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 |
ExportNo | Int | Not Null | Sequential number of the last export attempt |
ExportStateTS | SmallDateTime | Null | Date/time of the last export attempt |
ExportStateReason | Varchar(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 |
IsReleasedBeforeLinking | bit | not NULL | 'True'(1) if the Form has been released before the Medical Case became part of a Recurrent Medical Case, otherwise 'false'(0) |
|
|