+41 44 450 10 64 info@adjumed.com

Registry definitions

We can store individual filter definitions for each registry. On this page you will find the generic field definitions and codes.

Transfer file

Das Transferfile (TRSF) enthĂ€lt sĂ€mtliche Felddefinitionen und Codes sowie PrĂŒf-Algorithmen und Transcodierungen einer Register-Familie und ihrer einzelnen Register-Filter. Ein Register-Filter ist ein spezieller Fragebogen, der eine Auswahl der Felder einer Register-Familie enthĂ€lt. Die Register-Familie “AQC” enthĂ€lt beispielsweise den Register-Filter “AQC RTTM (reduce to the max) fĂŒr normale AQC-Eingaben, den Register-Filter “VisHSM” fĂŒr die Datenbank der Hochspezialisierten Viszeralchirurgie und den Register “SMOB” fĂŒr die Datenbank der Swiss Morbid Obesity Study Group. Diese drei Register-Filter haben zum Teil identische Felder und Felder, welche ineinander transcodiert werden.

The transfer file is an Excel file that contains a series (tabs) of spreadsheets. The number of worksheets depends on the number of filters in a registry family. The worksheets “Project name main form (superior)”, “Special master data” and “Transcodes” are available by default. For example, the AQC project has a total of 35 worksheets in 2017.

The “Project name main form (superior)” sheet contains all field names and codes for the respective project. The codes are located in the “Master data” column; if a code is very long, it is moved to the “Special master data” sheet. Mainform also contains extracts of all the project’s filters.

The filter check routines are documented on the other table sheets, as is the “mandatory” flag, check columns Y and Z.

The transfer file of the AQC project 2014 can be found here:

You can find the documents for your specific project here:

Columns in the TRSF file

The main form is listed in the columns in A-V:

  • Field_ID: Internal ID Adjumed.net, one-to-one
  • FeldNummer: in der Import-Datei vom KIS zu liefernde Feld-Nummer
  • FieldName: technical field description
  • FieldLabel (_fr/_it/_en/_cn): Title of the input field in the frontend
  • FieldType: Type of input field (e.g. RadioButtonList)
  • FieldFormat: see the following section “Field format”
  • MinValue / MaxValue: permissible input range. A value that falls below or exceeds this definition is not imported
  • ControlParameter: internal value
  • Master data (_fr/_it/_en/_cn): Field content with selection option for the user (language-specific output in the frontend)
  • Remarks: internal
  • Level: on which form level the field is displayed in the frontend – for AQC: A0 = KL (case), A1 = OP (surgery), A2 = ET (intervention part), B1 = GB (birth)

Registry filters are listed in the columns >V. Each filter has a specific title, e.g. “2014 SGC Minimal Dataset” or “2015 AQC” and consists of the following five columns:

  • Form_ID: if there is a number here, the field is part of the corresponding filter
  • Group: Grouping (representation)
  • Priority: Order of the fields in the filter (position)
  • Mandatory: how is it displayed to the user in the frontend? (mandatory = black, optional = gray)
  • Test routine: how is it checked? For example, a field in the input can be optional but still be checked under certain conditions (e.g. IsEmpty)

Field formats

  • AN# – alphanumeric, number of letters/digits (TextBox, DropDownList, RadioButtonList, CustomTreeViewList)
  • DA – date (TextBox)
  • NU# – positive number, number of digits (TextBox, DropDownList, RadioButtonList, CustomTreeViewList)
  • R/O – read only (Label, Literal, FormGroupTitle, CollapsiblePanel)
  • SM – time hh:mm (TextBox)
  • ZE – time hh:mm:ss (TextBox)
  • DE99.99 – decimal number, digits before and after decimal point (TextBox)
  • DE-99 / DE-99.99 – negative number or negative decimal number (positive numbers also possible) (TextBox)

Questions? Our hotline is here for you.

Nous parlons aussi le Français. N'hesitez pas à nous contacter!

+41 44 450 10 64