ID

46050

Description

Item catalog SHIP-NEXT part 8

Keywords

  1. 10/8/24 10/8/24 - Martin Dugas
Copyright Holder

University Medicine of Greifswald

Uploaded on

October 8, 2024

DOI

To request one please log in.

License

Creative Commons BY 4.0

Model comments :

You can comment on the data model here. Via the speech bubbles at the itemgroups and items you can add comments to those specificially.

Itemgroup comments for :

Item comments for :


    No comments

    In order to download data models you must be logged in. Please log in or register for free.

    Study SHIP-NEXT_metadata_20240913_NEXT|NEXT0|PHA

    x0.pha_ident

    Item Group x0.pha_ident
    Description

    Item Group x0.pha_ident

    Serial Number - Drug Per Test Person
    Description

    pha_lfd_nr

    Data type

    float

    Alias
    VAR_NAMES
    pha_lfd_nr
    LABEL
    Serial Number - Drug Per Test Person
    DATA_TYPE
    float
    MISSING_LIST_TABLE
    missing_table_3040
    GROUP_VAR_OBSERVER
    x0.pha_interviewer
    TIME_VAR
    x0.pha_start
    STUDY_SEGMENT
    x0.pha_ident
    VARIABLE_ORDER
    140
    LABEL_DE
    Laufende Nummer - Arzneimittel je Proband
    REPORT_NAME
    PHA
    TABLE_NAME
    T_PHA
    UNIQUE_NAME
    x0.pha_lfd_nr
    SOURCE
    NEXT
    DCE
    NEXT-0
    HIERARCHY
    NEXT|NEXT0|PHA|IDENT|PHA_IDENT
    Source of Drugs/Drug Source
    Description

    pha_quelleam

    Data type

    integer

    Alias
    VAR_NAMES
    pha_quelleam
    LABEL
    Source of Drugs/Drug Source
    DATA_TYPE
    integer
    VALUE_LABELS
    1=Medication package: scanning of the PZN|2=Medication package: keyboard input of PZN|3=Drug package: drug name|4=Package insert|5=Medication schedule|6=Prescription|7=Subject details|8=RECORDING (phone/note): Keyboard entry of PZN|9=RECORDING (telephone/slip): Drug name|10=RECORDING (drug package): Keystroke entry of PZN
    MISSING_LIST_TABLE
    missing_table_3040
    GROUP_VAR_OBSERVER
    x0.pha_interviewer
    TIME_VAR
    x0.pha_start
    STUDY_SEGMENT
    x0.pha_ident
    VARIABLE_ORDER
    150
    LABEL_DE
    Arzneimittelquelle
    VALUE_LABELS_DE
    1=Medikamentenpackung: Einscannen der PZN|2=Medikamentenpackung: Tastatureingabe der PZN|3=Medikamentenpackung: Arzneimittelname|4=Beipackzettel|5=Medikamentenplan|6=Rezept|7=Probandenangaben|8=NACHERHEBUNG (Telefon/Zettel): Tastatureingabe der PZN|9=NACHERHEBUNG (Telefon/Zettel): Arzneimittelname|10=NACHERHEBUNG (Medikamentenpackung): Tastatureingabe der PZN
    REPORT_NAME
    PHA
    TABLE_NAME
    T_PHA
    UNIQUE_NAME
    x0.pha_quelleam
    SOURCE
    NEXT
    DCE
    NEXT-0
    HIERARCHY
    NEXT|NEXT0|PHA|IDENT|PHA_IDENT
    Drug Label After Code Revision
    Description

    pha_bezeichnung

    Data type

    string

    Alias
    VAR_NAMES
    pha_bezeichnung
    LABEL
    Drug Label After Code Revision
    DATA_TYPE
    string
    MISSING_LIST_TABLE
    missing_table_3040
    GROUP_VAR_OBSERVER
    x0.pha_interviewer
    TIME_VAR
    x0.pha_start
    STUDY_SEGMENT
    x0.pha_ident
    VARIABLE_ORDER
    160
    LABEL_DE
    Arzneimittelbezeichnung nach der Nachkodierung
    REPORT_NAME
    PHA
    TABLE_NAME
    T_PHA
    UNIQUE_NAME
    x0.pha_bezeichnung
    SOURCE
    NEXT
    DCE
    NEXT-0
    HIERARCHY
    NEXT|NEXT0|PHA|IDENT|PHA_IDENT
    Central Pharma Number After Code Revision
    Description

    pha_pzn

    Data type

    float

    Alias
    VAR_NAMES
    pha_pzn
    LABEL
    Central Pharma Number After Code Revision
    DATA_TYPE
    float
    MISSING_LIST_TABLE
    missing_table_3040
    GROUP_VAR_OBSERVER
    x0.pha_interviewer
    TIME_VAR
    x0.pha_start
    STUDY_SEGMENT
    x0.pha_ident
    VARIABLE_ORDER
    170
    LABEL_DE
    Pharmazentralnummer nach der Nachkodierung
    REPORT_NAME
    PHA
    TABLE_NAME
    T_PHA
    UNIQUE_NAME
    x0.pha_pzn
    SOURCE
    NEXT
    DCE
    NEXT-0
    HIERARCHY
    NEXT|NEXT0|PHA|IDENT|PHA_IDENT
    ATC Code After Code Revision
    Description

    pha_atc

    Data type

    string

    Alias
    VAR_NAMES
    pha_atc
    LABEL
    ATC Code After Code Revision
    DATA_TYPE
    string
    MISSING_LIST_TABLE
    missing_table_3040
    GROUP_VAR_OBSERVER
    x0.pha_interviewer
    TIME_VAR
    x0.pha_start
    STUDY_SEGMENT
    x0.pha_ident
    VARIABLE_ORDER
    180
    LABEL_DE
    ATC-Code nach der Nachkodierung
    REPORT_NAME
    PHA
    TABLE_NAME
    T_PHA
    UNIQUE_NAME
    x0.pha_atc
    SOURCE
    NEXT
    DCE
    NEXT-0
    HIERARCHY
    NEXT|NEXT0|PHA|IDENT|PHA_IDENT
    Standard Packaging/Package Size
    Description

    pha_npg

    Data type

    string

    Alias
    VAR_NAMES
    pha_npg
    LABEL
    Standard Packaging/Package Size
    DATA_TYPE
    string
    VALUE_LABELS
    1=N1|2=N2|3=N3|4=2*N1 (A)|5=N1+N2 (B)|6=combination package (K)|7=not affected (N)|8=not refundable
    MISSING_LIST_TABLE
    missing_table_3040
    GROUP_VAR_OBSERVER
    x0.pha_interviewer
    TIME_VAR
    x0.pha_start
    STUDY_SEGMENT
    x0.pha_ident
    VARIABLE_ORDER
    190
    LABEL_DE
    Normpackungsgröße
    VALUE_LABELS_DE
    1=N1|2=N2|3=N3|4=2*N1 (A)|5=N1+N2 (B)|6=Kombinationspackung (K)|7=nicht betroffen (N)|8=nicht erstattungsfähig (Z)
    REPORT_NAME
    PHA
    TABLE_NAME
    T_PHA
    UNIQUE_NAME
    x0.pha_npg
    SOURCE
    NEXT
    DCE
    NEXT-0
    HIERARCHY
    NEXT|NEXT0|PHA|IDENT|PHA_IDENT
    Code Revision Takes Place/Will Be Made
    Description

    pha_nc

    Data type

    integer

    Alias
    VAR_NAMES
    pha_nc
    LABEL
    Code Revision Takes Place/Will Be Made
    DATA_TYPE
    integer
    VALUE_LABELS
    0=No|1=Yes
    MISSING_LIST_TABLE
    missing_table_3040
    GROUP_VAR_OBSERVER
    x0.pha_interviewer
    TIME_VAR
    x0.pha_start
    STUDY_SEGMENT
    x0.pha_ident
    VARIABLE_ORDER
    190
    LABEL_DE
    Nachkodierung erfolgt
    VALUE_LABELS_DE
    0=Nein|1=Ja
    REPORT_NAME
    PHA
    TABLE_NAME
    T_PHA
    UNIQUE_NAME
    x0.pha_nc
    SOURCE
    NEXT
    DCE
    NEXT-0
    HIERARCHY
    NEXT|NEXT0|PHA|IDENT|PHA_IDENT
    Dosage Form
    Description

    pha_darreichungsform

    Data type

    string

    Alias
    VAR_NAMES
    pha_darreichungsform
    LABEL
    Dosage Form
    DATA_TYPE
    string
    MISSING_LIST_TABLE
    missing_table_3040
    GROUP_VAR_OBSERVER
    x0.pha_interviewer
    TIME_VAR
    x0.pha_start
    STUDY_SEGMENT
    x0.pha_ident
    VARIABLE_ORDER
    200
    LABEL_DE
    Darreichungsform
    REPORT_NAME
    PHA
    TABLE_NAME
    T_PHA
    UNIQUE_NAME
    x0.pha_darreichungsform
    SOURCE
    NEXT
    DCE
    NEXT-0
    HIERARCHY
    NEXT|NEXT0|PHA|IDENT|PHA_IDENT
    Code Revision Source
    Description

    pha_nc_ident

    Data type

    integer

    Alias
    VAR_NAMES
    pha_nc_ident
    LABEL
    Code Revision Source
    DATA_TYPE
    integer
    VALUE_LABELS
    0=by hand|1=per IDOM
    MISSING_LIST_TABLE
    missing_table_3040
    GROUP_VAR_OBSERVER
    x0.pha_interviewer
    TIME_VAR
    x0.pha_start
    STUDY_SEGMENT
    x0.pha_ident
    VARIABLE_ORDER
    200
    LABEL_DE
    Nachkodierungsquelle
    VALUE_LABELS_DE
    0=per Hand|1=per IDOM
    REPORT_NAME
    PHA
    TABLE_NAME
    T_PHA
    UNIQUE_NAME
    x0.pha_nc_ident
    SOURCE
    NEXT
    DCE
    NEXT-0
    HIERARCHY
    NEXT|NEXT0|PHA|IDENT|PHA_IDENT
    Safety of Code Revision
    Description

    pha_nc_sicherheit

    Data type

    integer

    Alias
    VAR_NAMES
    pha_nc_sicherheit
    LABEL
    Safety of Code Revision
    DATA_TYPE
    integer
    VALUE_LABELS
    1=impossible|2=unsure|3=sure
    MISSING_LIST_TABLE
    missing_table_3040
    GROUP_VAR_OBSERVER
    x0.pha_interviewer
    TIME_VAR
    x0.pha_start
    STUDY_SEGMENT
    x0.pha_ident
    VARIABLE_ORDER
    210
    LABEL_DE
    Sicherheit der Nachkodierung
    VALUE_LABELS_DE
    1=unmöglich|2=unsicher|3=sicher
    REPORT_NAME
    PHA
    TABLE_NAME
    T_PHA
    UNIQUE_NAME
    x0.pha_nc_sicherheit
    SOURCE
    NEXT
    DCE
    NEXT-0
    HIERARCHY
    NEXT|NEXT0|PHA|IDENT|PHA_IDENT
    Package/Packaging Size
    Description

    pha_pg

    Data type

    integer

    Alias
    VAR_NAMES
    pha_pg
    LABEL
    Package/Packaging Size
    DATA_TYPE
    integer
    MISSING_LIST_TABLE
    missing_table_3040
    GROUP_VAR_OBSERVER
    x0.pha_interviewer
    TIME_VAR
    x0.pha_start
    STUDY_SEGMENT
    x0.pha_ident
    VARIABLE_ORDER
    210
    LABEL_DE
    Packungsgröße
    REPORT_NAME
    PHA
    TABLE_NAME
    T_PHA
    UNIQUE_NAME
    x0.pha_pg
    SOURCE
    NEXT
    DCE
    NEXT-0
    HIERARCHY
    NEXT|NEXT0|PHA|IDENT|PHA_IDENT
    Price
    Description

    pha_preis

    Data type

    float

    Alias
    VAR_NAMES
    pha_preis
    LABEL
    Price
    DATA_TYPE
    float
    MISSING_LIST_TABLE
    missing_table_3040
    GROUP_VAR_OBSERVER
    x0.pha_interviewer
    TIME_VAR
    x0.pha_start
    STUDY_SEGMENT
    x0.pha_ident
    VARIABLE_ORDER
    220
    LABEL_DE
    Preis in Cent
    REPORT_NAME
    PHA
    TABLE_NAME
    T_PHA
    UNIQUE_NAME
    x0.pha_preis
    SOURCE
    NEXT
    DCE
    NEXT-0
    HIERARCHY
    NEXT|NEXT0|PHA|IDENT|PHA_IDENT
    Identification Status After Code Revision
    Description

    pha_id_status

    Data type

    integer

    Alias
    VAR_NAMES
    pha_id_status
    LABEL
    Identification Status After Code Revision
    DATA_TYPE
    integer
    VALUE_LABELS
    1=with PCN/ATC complete|2=with PZN/ATC partly|3=with PZN/no ATC|4=no PCN/ATC completed|5=no PZN/ATC partly|6=no PZN/no ATC
    MISSING_LIST_TABLE
    missing_table_3040
    GROUP_VAR_OBSERVER
    x0.pha_interviewer
    TIME_VAR
    x0.pha_start
    STUDY_SEGMENT
    x0.pha_ident
    VARIABLE_ORDER
    220
    LABEL_DE
    Identifikationsstatus nach der Nachkodierung
    VALUE_LABELS_DE
    1=mit PZN / ATC komplett|2=mit PZN / ATC teilweise|3=mit PZN / kein ATC|4=keine PZN / ATC komplett|5=keine PZN / ATC teilweise|6=keine PZN / kein ATC
    REPORT_NAME
    PHA
    TABLE_NAME
    T_PHA
    UNIQUE_NAME
    x0.pha_id_status
    SOURCE
    NEXT
    DCE
    NEXT-0
    HIERARCHY
    NEXT|NEXT0|PHA|IDENT|PHA_IDENT
    Fixed Price
    Description

    pha_festpreis

    Data type

    float

    Alias
    VAR_NAMES
    pha_festpreis
    LABEL
    Fixed Price
    DATA_TYPE
    float
    MISSING_LIST_TABLE
    missing_table_3040
    GROUP_VAR_OBSERVER
    x0.pha_interviewer
    TIME_VAR
    x0.pha_start
    STUDY_SEGMENT
    x0.pha_ident
    VARIABLE_ORDER
    230
    LABEL_DE
    Festpreis in Cent
    REPORT_NAME
    PHA
    TABLE_NAME
    T_PHA
    UNIQUE_NAME
    x0.pha_festpreis
    SOURCE
    NEXT
    DCE
    NEXT-0
    HIERARCHY
    NEXT|NEXT0|PHA|IDENT|PHA_IDENT
    Manufacturer Code
    Description

    pha_herstellerschluessel

    Data type

    string

    Alias
    VAR_NAMES
    pha_herstellerschluessel
    LABEL
    Manufacturer Code
    DATA_TYPE
    string
    MISSING_LIST_TABLE
    missing_table_3040
    GROUP_VAR_OBSERVER
    x0.pha_interviewer
    TIME_VAR
    x0.pha_start
    STUDY_SEGMENT
    x0.pha_ident
    VARIABLE_ORDER
    240
    LABEL_DE
    Herstellerschlüssel
    REPORT_NAME
    PHA
    TABLE_NAME
    T_PHA
    UNIQUE_NAME
    x0.pha_herstellerschluessel
    SOURCE
    NEXT
    DCE
    NEXT-0
    HIERARCHY
    NEXT|NEXT0|PHA|IDENT|PHA_IDENT
    PHA: Application Form
    Description

    pha_applikationsform

    Data type

    string

    Alias
    VAR_NAMES
    pha_applikationsform
    LABEL
    PHA: Application Form
    DATA_TYPE
    string
    MISSING_LIST_TABLE
    missing_table_3040
    GROUP_VAR_OBSERVER
    x0.pha_interviewer
    TIME_VAR
    x0.pha_start
    STUDY_SEGMENT
    x0.pha_ident
    VARIABLE_ORDER
    250
    LABEL_DE
    Applikationsform
    REPORT_NAME
    PHA
    TABLE_NAME
    T_PHA
    UNIQUE_NAME
    x0.pha_applikationsform
    SOURCE
    NEXT
    DCE
    NEXT-0
    HIERARCHY
    NEXT|NEXT0|PHA|IDENT|PHA_IDENT
    Original Drug Label
    Description

    pha_bezeichnung_orig

    Data type

    string

    Alias
    VAR_NAMES
    pha_bezeichnung_orig
    LABEL
    Original Drug Label
    DATA_TYPE
    string
    MISSING_LIST_TABLE
    missing_table_3040
    GROUP_VAR_OBSERVER
    x0.pha_interviewer
    TIME_VAR
    x0.pha_start
    STUDY_SEGMENT
    x0.pha_ident
    VARIABLE_ORDER
    280
    LABEL_DE
    Original Arzneimittelbezeichnung
    REPORT_NAME
    PHA
    TABLE_NAME
    T_PHA
    UNIQUE_NAME
    x0.pha_bezeichnung_orig
    SOURCE
    NEXT
    DCE
    NEXT-0
    HIERARCHY
    NEXT|NEXT0|PHA|IDENT|PHA_IDENT
    Original Central Pharma Number
    Description

    pha_pzn_orig

    Data type

    float

    Alias
    VAR_NAMES
    pha_pzn_orig
    LABEL
    Original Central Pharma Number
    DATA_TYPE
    float
    MISSING_LIST_TABLE
    missing_table_3040
    GROUP_VAR_OBSERVER
    x0.pha_interviewer
    TIME_VAR
    x0.pha_start
    STUDY_SEGMENT
    x0.pha_ident
    VARIABLE_ORDER
    290
    LABEL_DE
    Original Pharmazentralnummer
    REPORT_NAME
    PHA
    TABLE_NAME
    T_PHA
    UNIQUE_NAME
    x0.pha_pzn_orig
    SOURCE
    NEXT
    DCE
    NEXT-0
    HIERARCHY
    NEXT|NEXT0|PHA|IDENT|PHA_IDENT
    Original ATC-Code
    Description

    pha_atc_orig

    Data type

    string

    Alias
    VAR_NAMES
    pha_atc_orig
    LABEL
    Original ATC-Code
    DATA_TYPE
    string
    MISSING_LIST_TABLE
    missing_table_3040
    GROUP_VAR_OBSERVER
    x0.pha_interviewer
    TIME_VAR
    x0.pha_start
    STUDY_SEGMENT
    x0.pha_ident
    VARIABLE_ORDER
    300
    LABEL_DE
    Original ATC-Code
    REPORT_NAME
    PHA
    TABLE_NAME
    T_PHA
    UNIQUE_NAME
    x0.pha_atc_orig
    SOURCE
    NEXT
    DCE
    NEXT-0
    HIERARCHY
    NEXT|NEXT0|PHA|IDENT|PHA_IDENT
    Identification Status Before Code Revision
    Description

    pha_id_status_orig

    Data type

    integer

    Alias
    VAR_NAMES
    pha_id_status_orig
    LABEL
    Identification Status Before Code Revision
    DATA_TYPE
    integer
    VALUE_LABELS
    1=with PCN/ATC complete|2=with PZN/ATC partly|3=with PZN/no ATC|4=no PCN/ATC completed|5=no PZN/ATC partly|6=no PZN/no ATC
    MISSING_LIST_TABLE
    missing_table_3040
    GROUP_VAR_OBSERVER
    x0.pha_interviewer
    TIME_VAR
    x0.pha_start
    STUDY_SEGMENT
    x0.pha_ident
    VARIABLE_ORDER
    310
    LABEL_DE
    Identifikationsstatus vor der Nachkodierung
    VALUE_LABELS_DE
    1=mit PZN / ATC komplett|2=mit PZN / ATC teilweise|3=mit PZN / kein ATC|4=keine PZN / ATC komplett|5=keine PZN / ATC teilweise|6=keine PZN / kein ATC
    REPORT_NAME
    PHA
    TABLE_NAME
    T_PHA
    UNIQUE_NAME
    x0.pha_id_status_orig
    SOURCE
    NEXT
    DCE
    NEXT-0
    HIERARCHY
    NEXT|NEXT0|PHA|IDENT|PHA_IDENT

    Similar models

    x0.pha_ident

    Name
    Type
    Description | Question | Decode (Coded Value)
    Data type
    Alias
    Item Group
    Item Group x0.pha_ident
    pha_lfd_nr
    Item
    Serial Number - Drug Per Test Person
    float
    pha_lfd_nr (VAR_NAMES)
    Serial Number - Drug Per Test Person (LABEL)
    float (DATA_TYPE)
    missing_table_3040 (MISSING_LIST_TABLE)
    x0.pha_interviewer (GROUP_VAR_OBSERVER)
    x0.pha_start (TIME_VAR)
    x0.pha_ident (STUDY_SEGMENT)
    140 (VARIABLE_ORDER)
    Laufende Nummer - Arzneimittel je Proband (LABEL_DE)
    PHA (REPORT_NAME)
    T_PHA (TABLE_NAME)
    x0.pha_lfd_nr (UNIQUE_NAME)
    NEXT (SOURCE)
    NEXT-0 (DCE)
    NEXT|NEXT0|PHA|IDENT|PHA_IDENT (HIERARCHY)
    Item
    Source of Drugs/Drug Source
    integer
    pha_quelleam (VAR_NAMES)
    Source of Drugs/Drug Source (LABEL)
    integer (DATA_TYPE)
    1=Medication package: scanning of the PZN|2=Medication package: keyboard input of PZN|3=Drug package: drug name|4=Package insert|5=Medication schedule|6=Prescription|7=Subject details|8=RECORDING (phone/note): Keyboard entry of PZN|9=RECORDING (telephone/slip): Drug name|10=RECORDING (drug package): Keystroke entry of PZN (VALUE_LABELS)
    missing_table_3040 (MISSING_LIST_TABLE)
    x0.pha_interviewer (GROUP_VAR_OBSERVER)
    x0.pha_start (TIME_VAR)
    x0.pha_ident (STUDY_SEGMENT)
    150 (VARIABLE_ORDER)
    Arzneimittelquelle (LABEL_DE)
    1=Medikamentenpackung: Einscannen der PZN|2=Medikamentenpackung: Tastatureingabe der PZN|3=Medikamentenpackung: Arzneimittelname|4=Beipackzettel|5=Medikamentenplan|6=Rezept|7=Probandenangaben|8=NACHERHEBUNG (Telefon/Zettel): Tastatureingabe der PZN|9=NACHERHEBUNG (Telefon/Zettel): Arzneimittelname|10=NACHERHEBUNG (Medikamentenpackung): Tastatureingabe der PZN (VALUE_LABELS_DE)
    PHA (REPORT_NAME)
    T_PHA (TABLE_NAME)
    x0.pha_quelleam (UNIQUE_NAME)
    NEXT (SOURCE)
    NEXT-0 (DCE)
    NEXT|NEXT0|PHA|IDENT|PHA_IDENT (HIERARCHY)
    Code List
    Source of Drugs/Drug Source
    CL Item
    Medication package: scanning of the PZN (1)
    CL Item
    Medication package: keyboard input of PZN (2)
    CL Item
    Drug package: drug name (3)
    CL Item
    Package insert (4)
    CL Item
    Medication schedule (5)
    CL Item
    Prescription (6)
    CL Item
    Subject details (7)
    CL Item
    RECORDING (phone/note): Keyboard entry of PZN (8)
    CL Item
    RECORDING (telephone/slip): Drug name (9)
    CL Item
    RECORDING (drug package): Keystroke entry of PZN (10)
    pha_bezeichnung
    Item
    Drug Label After Code Revision
    string
    pha_bezeichnung (VAR_NAMES)
    Drug Label After Code Revision (LABEL)
    string (DATA_TYPE)
    missing_table_3040 (MISSING_LIST_TABLE)
    x0.pha_interviewer (GROUP_VAR_OBSERVER)
    x0.pha_start (TIME_VAR)
    x0.pha_ident (STUDY_SEGMENT)
    160 (VARIABLE_ORDER)
    Arzneimittelbezeichnung nach der Nachkodierung (LABEL_DE)
    PHA (REPORT_NAME)
    T_PHA (TABLE_NAME)
    x0.pha_bezeichnung (UNIQUE_NAME)
    NEXT (SOURCE)
    NEXT-0 (DCE)
    NEXT|NEXT0|PHA|IDENT|PHA_IDENT (HIERARCHY)
    pha_pzn
    Item
    Central Pharma Number After Code Revision
    float
    pha_pzn (VAR_NAMES)
    Central Pharma Number After Code Revision (LABEL)
    float (DATA_TYPE)
    missing_table_3040 (MISSING_LIST_TABLE)
    x0.pha_interviewer (GROUP_VAR_OBSERVER)
    x0.pha_start (TIME_VAR)
    x0.pha_ident (STUDY_SEGMENT)
    170 (VARIABLE_ORDER)
    Pharmazentralnummer nach der Nachkodierung (LABEL_DE)
    PHA (REPORT_NAME)
    T_PHA (TABLE_NAME)
    x0.pha_pzn (UNIQUE_NAME)
    NEXT (SOURCE)
    NEXT-0 (DCE)
    NEXT|NEXT0|PHA|IDENT|PHA_IDENT (HIERARCHY)
    pha_atc
    Item
    ATC Code After Code Revision
    string
    pha_atc (VAR_NAMES)
    ATC Code After Code Revision (LABEL)
    string (DATA_TYPE)
    missing_table_3040 (MISSING_LIST_TABLE)
    x0.pha_interviewer (GROUP_VAR_OBSERVER)
    x0.pha_start (TIME_VAR)
    x0.pha_ident (STUDY_SEGMENT)
    180 (VARIABLE_ORDER)
    ATC-Code nach der Nachkodierung (LABEL_DE)
    PHA (REPORT_NAME)
    T_PHA (TABLE_NAME)
    x0.pha_atc (UNIQUE_NAME)
    NEXT (SOURCE)
    NEXT-0 (DCE)
    NEXT|NEXT0|PHA|IDENT|PHA_IDENT (HIERARCHY)
    Item
    Standard Packaging/Package Size
    string
    pha_npg (VAR_NAMES)
    Standard Packaging/Package Size (LABEL)
    string (DATA_TYPE)
    1=N1|2=N2|3=N3|4=2*N1 (A)|5=N1+N2 (B)|6=combination package (K)|7=not affected (N)|8=not refundable (VALUE_LABELS)
    missing_table_3040 (MISSING_LIST_TABLE)
    x0.pha_interviewer (GROUP_VAR_OBSERVER)
    x0.pha_start (TIME_VAR)
    x0.pha_ident (STUDY_SEGMENT)
    190 (VARIABLE_ORDER)
    Normpackungsgröße (LABEL_DE)
    1=N1|2=N2|3=N3|4=2*N1 (A)|5=N1+N2 (B)|6=Kombinationspackung (K)|7=nicht betroffen (N)|8=nicht erstattungsfähig (Z) (VALUE_LABELS_DE)
    PHA (REPORT_NAME)
    T_PHA (TABLE_NAME)
    x0.pha_npg (UNIQUE_NAME)
    NEXT (SOURCE)
    NEXT-0 (DCE)
    NEXT|NEXT0|PHA|IDENT|PHA_IDENT (HIERARCHY)
    Code List
    Standard Packaging/Package Size
    CL Item
    N1 (1)
    CL Item
    N2 (2)
    CL Item
    N3 (3)
    CL Item
    2*N1 (A) (4)
    CL Item
    N1+N2 (B) (5)
    CL Item
    combination package (K) (6)
    CL Item
    not affected (N) (7)
    CL Item
    not refundable (8)
    Item
    Code Revision Takes Place/Will Be Made
    integer
    pha_nc (VAR_NAMES)
    Code Revision Takes Place/Will Be Made (LABEL)
    integer (DATA_TYPE)
    0=No|1=Yes (VALUE_LABELS)
    missing_table_3040 (MISSING_LIST_TABLE)
    x0.pha_interviewer (GROUP_VAR_OBSERVER)
    x0.pha_start (TIME_VAR)
    x0.pha_ident (STUDY_SEGMENT)
    190 (VARIABLE_ORDER)
    Nachkodierung erfolgt (LABEL_DE)
    0=Nein|1=Ja (VALUE_LABELS_DE)
    PHA (REPORT_NAME)
    T_PHA (TABLE_NAME)
    x0.pha_nc (UNIQUE_NAME)
    NEXT (SOURCE)
    NEXT-0 (DCE)
    NEXT|NEXT0|PHA|IDENT|PHA_IDENT (HIERARCHY)
    Code List
    Code Revision Takes Place/Will Be Made
    CL Item
    Yes (1)
    CL Item
    No (0)
    pha_darreichungsform
    Item
    Dosage Form
    string
    pha_darreichungsform (VAR_NAMES)
    Dosage Form (LABEL)
    string (DATA_TYPE)
    missing_table_3040 (MISSING_LIST_TABLE)
    x0.pha_interviewer (GROUP_VAR_OBSERVER)
    x0.pha_start (TIME_VAR)
    x0.pha_ident (STUDY_SEGMENT)
    200 (VARIABLE_ORDER)
    Darreichungsform (LABEL_DE)
    PHA (REPORT_NAME)
    T_PHA (TABLE_NAME)
    x0.pha_darreichungsform (UNIQUE_NAME)
    NEXT (SOURCE)
    NEXT-0 (DCE)
    NEXT|NEXT0|PHA|IDENT|PHA_IDENT (HIERARCHY)
    Item
    Code Revision Source
    integer
    pha_nc_ident (VAR_NAMES)
    Code Revision Source (LABEL)
    integer (DATA_TYPE)
    0=by hand|1=per IDOM (VALUE_LABELS)
    missing_table_3040 (MISSING_LIST_TABLE)
    x0.pha_interviewer (GROUP_VAR_OBSERVER)
    x0.pha_start (TIME_VAR)
    x0.pha_ident (STUDY_SEGMENT)
    200 (VARIABLE_ORDER)
    Nachkodierungsquelle (LABEL_DE)
    0=per Hand|1=per IDOM (VALUE_LABELS_DE)
    PHA (REPORT_NAME)
    T_PHA (TABLE_NAME)
    x0.pha_nc_ident (UNIQUE_NAME)
    NEXT (SOURCE)
    NEXT-0 (DCE)
    NEXT|NEXT0|PHA|IDENT|PHA_IDENT (HIERARCHY)
    Code List
    Code Revision Source
    CL Item
    by hand (0)
    CL Item
    per IDOM (1)
    Item
    Safety of Code Revision
    integer
    pha_nc_sicherheit (VAR_NAMES)
    Safety of Code Revision (LABEL)
    integer (DATA_TYPE)
    1=impossible|2=unsure|3=sure (VALUE_LABELS)
    missing_table_3040 (MISSING_LIST_TABLE)
    x0.pha_interviewer (GROUP_VAR_OBSERVER)
    x0.pha_start (TIME_VAR)
    x0.pha_ident (STUDY_SEGMENT)
    210 (VARIABLE_ORDER)
    Sicherheit der Nachkodierung (LABEL_DE)
    1=unmöglich|2=unsicher|3=sicher (VALUE_LABELS_DE)
    PHA (REPORT_NAME)
    T_PHA (TABLE_NAME)
    x0.pha_nc_sicherheit (UNIQUE_NAME)
    NEXT (SOURCE)
    NEXT-0 (DCE)
    NEXT|NEXT0|PHA|IDENT|PHA_IDENT (HIERARCHY)
    Code List
    Safety of Code Revision
    CL Item
    impossible (1)
    CL Item
    unsure (2)
    CL Item
    sure (3)
    pha_pg
    Item
    Package/Packaging Size
    integer
    pha_pg (VAR_NAMES)
    Package/Packaging Size (LABEL)
    integer (DATA_TYPE)
    missing_table_3040 (MISSING_LIST_TABLE)
    x0.pha_interviewer (GROUP_VAR_OBSERVER)
    x0.pha_start (TIME_VAR)
    x0.pha_ident (STUDY_SEGMENT)
    210 (VARIABLE_ORDER)
    Packungsgröße (LABEL_DE)
    PHA (REPORT_NAME)
    T_PHA (TABLE_NAME)
    x0.pha_pg (UNIQUE_NAME)
    NEXT (SOURCE)
    NEXT-0 (DCE)
    NEXT|NEXT0|PHA|IDENT|PHA_IDENT (HIERARCHY)
    pha_preis
    Item
    Price
    float
    pha_preis (VAR_NAMES)
    Price (LABEL)
    float (DATA_TYPE)
    missing_table_3040 (MISSING_LIST_TABLE)
    x0.pha_interviewer (GROUP_VAR_OBSERVER)
    x0.pha_start (TIME_VAR)
    x0.pha_ident (STUDY_SEGMENT)
    220 (VARIABLE_ORDER)
    Preis in Cent (LABEL_DE)
    PHA (REPORT_NAME)
    T_PHA (TABLE_NAME)
    x0.pha_preis (UNIQUE_NAME)
    NEXT (SOURCE)
    NEXT-0 (DCE)
    NEXT|NEXT0|PHA|IDENT|PHA_IDENT (HIERARCHY)
    Item
    Identification Status After Code Revision
    integer
    pha_id_status (VAR_NAMES)
    Identification Status After Code Revision (LABEL)
    integer (DATA_TYPE)
    1=with PCN/ATC complete|2=with PZN/ATC partly|3=with PZN/no ATC|4=no PCN/ATC completed|5=no PZN/ATC partly|6=no PZN/no ATC (VALUE_LABELS)
    missing_table_3040 (MISSING_LIST_TABLE)
    x0.pha_interviewer (GROUP_VAR_OBSERVER)
    x0.pha_start (TIME_VAR)
    x0.pha_ident (STUDY_SEGMENT)
    220 (VARIABLE_ORDER)
    Identifikationsstatus nach der Nachkodierung (LABEL_DE)
    1=mit PZN / ATC komplett|2=mit PZN / ATC teilweise|3=mit PZN / kein ATC|4=keine PZN / ATC komplett|5=keine PZN / ATC teilweise|6=keine PZN / kein ATC (VALUE_LABELS_DE)
    PHA (REPORT_NAME)
    T_PHA (TABLE_NAME)
    x0.pha_id_status (UNIQUE_NAME)
    NEXT (SOURCE)
    NEXT-0 (DCE)
    NEXT|NEXT0|PHA|IDENT|PHA_IDENT (HIERARCHY)
    Code List
    Identification Status After Code Revision
    CL Item
    with PCN/ATC complete (1)
    CL Item
    with PZN/ATC partly (2)
    CL Item
    with PZN/no ATC (3)
    CL Item
    no PCN/ATC completed (4)
    CL Item
    no PZN/ATC partly (5)
    CL Item
    no PZN/no ATC (6)
    pha_festpreis
    Item
    Fixed Price
    float
    pha_festpreis (VAR_NAMES)
    Fixed Price (LABEL)
    float (DATA_TYPE)
    missing_table_3040 (MISSING_LIST_TABLE)
    x0.pha_interviewer (GROUP_VAR_OBSERVER)
    x0.pha_start (TIME_VAR)
    x0.pha_ident (STUDY_SEGMENT)
    230 (VARIABLE_ORDER)
    Festpreis in Cent (LABEL_DE)
    PHA (REPORT_NAME)
    T_PHA (TABLE_NAME)
    x0.pha_festpreis (UNIQUE_NAME)
    NEXT (SOURCE)
    NEXT-0 (DCE)
    NEXT|NEXT0|PHA|IDENT|PHA_IDENT (HIERARCHY)
    pha_herstellerschluessel
    Item
    Manufacturer Code
    string
    pha_herstellerschluessel (VAR_NAMES)
    Manufacturer Code (LABEL)
    string (DATA_TYPE)
    missing_table_3040 (MISSING_LIST_TABLE)
    x0.pha_interviewer (GROUP_VAR_OBSERVER)
    x0.pha_start (TIME_VAR)
    x0.pha_ident (STUDY_SEGMENT)
    240 (VARIABLE_ORDER)
    Herstellerschlüssel (LABEL_DE)
    PHA (REPORT_NAME)
    T_PHA (TABLE_NAME)
    x0.pha_herstellerschluessel (UNIQUE_NAME)
    NEXT (SOURCE)
    NEXT-0 (DCE)
    NEXT|NEXT0|PHA|IDENT|PHA_IDENT (HIERARCHY)
    pha_applikationsform
    Item
    PHA: Application Form
    string
    pha_applikationsform (VAR_NAMES)
    PHA: Application Form (LABEL)
    string (DATA_TYPE)
    missing_table_3040 (MISSING_LIST_TABLE)
    x0.pha_interviewer (GROUP_VAR_OBSERVER)
    x0.pha_start (TIME_VAR)
    x0.pha_ident (STUDY_SEGMENT)
    250 (VARIABLE_ORDER)
    Applikationsform (LABEL_DE)
    PHA (REPORT_NAME)
    T_PHA (TABLE_NAME)
    x0.pha_applikationsform (UNIQUE_NAME)
    NEXT (SOURCE)
    NEXT-0 (DCE)
    NEXT|NEXT0|PHA|IDENT|PHA_IDENT (HIERARCHY)
    pha_bezeichnung_orig
    Item
    Original Drug Label
    string
    pha_bezeichnung_orig (VAR_NAMES)
    Original Drug Label (LABEL)
    string (DATA_TYPE)
    missing_table_3040 (MISSING_LIST_TABLE)
    x0.pha_interviewer (GROUP_VAR_OBSERVER)
    x0.pha_start (TIME_VAR)
    x0.pha_ident (STUDY_SEGMENT)
    280 (VARIABLE_ORDER)
    Original Arzneimittelbezeichnung (LABEL_DE)
    PHA (REPORT_NAME)
    T_PHA (TABLE_NAME)
    x0.pha_bezeichnung_orig (UNIQUE_NAME)
    NEXT (SOURCE)
    NEXT-0 (DCE)
    NEXT|NEXT0|PHA|IDENT|PHA_IDENT (HIERARCHY)
    pha_pzn_orig
    Item
    Original Central Pharma Number
    float
    pha_pzn_orig (VAR_NAMES)
    Original Central Pharma Number (LABEL)
    float (DATA_TYPE)
    missing_table_3040 (MISSING_LIST_TABLE)
    x0.pha_interviewer (GROUP_VAR_OBSERVER)
    x0.pha_start (TIME_VAR)
    x0.pha_ident (STUDY_SEGMENT)
    290 (VARIABLE_ORDER)
    Original Pharmazentralnummer (LABEL_DE)
    PHA (REPORT_NAME)
    T_PHA (TABLE_NAME)
    x0.pha_pzn_orig (UNIQUE_NAME)
    NEXT (SOURCE)
    NEXT-0 (DCE)
    NEXT|NEXT0|PHA|IDENT|PHA_IDENT (HIERARCHY)
    pha_atc_orig
    Item
    Original ATC-Code
    string
    pha_atc_orig (VAR_NAMES)
    Original ATC-Code (LABEL)
    string (DATA_TYPE)
    missing_table_3040 (MISSING_LIST_TABLE)
    x0.pha_interviewer (GROUP_VAR_OBSERVER)
    x0.pha_start (TIME_VAR)
    x0.pha_ident (STUDY_SEGMENT)
    300 (VARIABLE_ORDER)
    Original ATC-Code (LABEL_DE)
    PHA (REPORT_NAME)
    T_PHA (TABLE_NAME)
    x0.pha_atc_orig (UNIQUE_NAME)
    NEXT (SOURCE)
    NEXT-0 (DCE)
    NEXT|NEXT0|PHA|IDENT|PHA_IDENT (HIERARCHY)
    Item
    Identification Status Before Code Revision
    integer
    pha_id_status_orig (VAR_NAMES)
    Identification Status Before Code Revision (LABEL)
    integer (DATA_TYPE)
    1=with PCN/ATC complete|2=with PZN/ATC partly|3=with PZN/no ATC|4=no PCN/ATC completed|5=no PZN/ATC partly|6=no PZN/no ATC (VALUE_LABELS)
    missing_table_3040 (MISSING_LIST_TABLE)
    x0.pha_interviewer (GROUP_VAR_OBSERVER)
    x0.pha_start (TIME_VAR)
    x0.pha_ident (STUDY_SEGMENT)
    310 (VARIABLE_ORDER)
    Identifikationsstatus vor der Nachkodierung (LABEL_DE)
    1=mit PZN / ATC komplett|2=mit PZN / ATC teilweise|3=mit PZN / kein ATC|4=keine PZN / ATC komplett|5=keine PZN / ATC teilweise|6=keine PZN / kein ATC (VALUE_LABELS_DE)
    PHA (REPORT_NAME)
    T_PHA (TABLE_NAME)
    x0.pha_id_status_orig (UNIQUE_NAME)
    NEXT (SOURCE)
    NEXT-0 (DCE)
    NEXT|NEXT0|PHA|IDENT|PHA_IDENT (HIERARCHY)
    Code List
    Identification Status Before Code Revision
    CL Item
    with PCN/ATC complete (1)
    CL Item
    with PZN/ATC partly (2)
    CL Item
    with PZN/no ATC (3)
    CL Item
    no PCN/ATC completed (4)
    CL Item
    no PZN/ATC partly (5)
    CL Item
    no PZN/no ATC (6)

    Do you need help on how to use the search function? Please watch the corresponding tutorial video for more details and learn how to use the search function most efficiently.

    Watch Tutorial