t1.pha_ident2

Item Group t1.pha_ident2
Description

Item Group t1.pha_ident2

PHA: Arzneimittelexposition
Description

am_exposition

Data type

integer

Alias
VAR_NAMES
am_exposition
LABEL
PHA: drug exposure
DATA_TYPE
integer
VALUE_LABELS
1=Yes|2=No
MISSING_LIST_TABLE
missing_table_136
STUDY_SEGMENT
t1.pha_ident2
VARIABLE_ORDER
1.0
LABEL_DE
PHA: Arzneimittelexposition
VALUE_LABELS_DE
1=Ja|2=Nein
TABLE_NAME
T_PHA
UNIQUE_NAME
t1.am_exposition
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PHA|PHA_IDENT|PHA_IDENT2
PHA: Laufende Nummer - Arzneimittel je Proband
Description

pha_lfd_nr

Data type

float

Alias
VAR_NAMES
pha_lfd_nr
LABEL
PHA: serial number - drug per test person
DATA_TYPE
float
MISSING_LIST_TABLE
missing_table_136
STUDY_SEGMENT
t1.pha_ident2
VARIABLE_ORDER
2.0
LABEL_DE
PHA: Laufende Nummer - Arzneimittel je Proband
TABLE_NAME
T_PHA
UNIQUE_NAME
t1.pha_lfd_nr
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PHA|PHA_IDENT|PHA_IDENT2
PHA: Arzneimittelquelle
Description

quelleam

Data type

integer

Alias
VAR_NAMES
quelleam
LABEL
PHA: source of drugs/drug source
DATA_TYPE
integer
VALUE_LABELS
1=Medication package: scanning of the PZN|2=Medication package: keyboard entry 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_136
STUDY_SEGMENT
t1.pha_ident2
VARIABLE_ORDER
3.0
LABEL_DE
PHA: 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
TABLE_NAME
T_PHA
UNIQUE_NAME
t1.quelleam
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PHA|PHA_IDENT|PHA_IDENT2
PHA-NC: Arzneimittelbezeichnung nach der Nachkodierung
Description

bezeichnung

Data type

string

Alias
VAR_NAMES
bezeichnung
LABEL
PHA-NC: drug label after code revision
DATA_TYPE
string
MISSING_LIST_TABLE
missing_table_136
STUDY_SEGMENT
t1.pha_ident2
VARIABLE_ORDER
4.0
LABEL_DE
PHA-NC: Arzneimittelbezeichnung nach der Nachkodierung
TABLE_NAME
T_PHA
UNIQUE_NAME
t1.bezeichnung
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PHA|PHA_IDENT|PHA_IDENT2
PHA-NC: Pharmazentralnummer nach der Nachkodierung
Description

Nonresponse: 8,85

Data type

float

Alias
VAR_NAMES
pzn
LABEL
PHA-NC: central pharma number after code revision
DATA_TYPE
float
MISSING_LIST_TABLE
missing_table_136
STUDY_SEGMENT
t1.pha_ident2
VARIABLE_ORDER
5.0
LABEL_DE
PHA-NC: Pharmazentralnummer nach der Nachkodierung
NOTE_TYPE
1 - data quality for request form
NOTE_DE
Nonresponse: 8,85
TABLE_NAME
T_PHA
UNIQUE_NAME
t1.pzn
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PHA|PHA_IDENT|PHA_IDENT2
PHA-NC: ATC-Code nach der Nachkodierung
Description

atc

Data type

string

Alias
VAR_NAMES
atc
LABEL
PHA-NC: ATC code after code revision
DATA_TYPE
string
MISSING_LIST_TABLE
missing_table_136
STUDY_SEGMENT
t1.pha_ident2
VARIABLE_ORDER
6.0
LABEL_DE
PHA-NC: ATC-Code nach der Nachkodierung
TABLE_NAME
T_PHA
UNIQUE_NAME
t1.atc
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PHA|PHA_IDENT|PHA_IDENT2
PHA-NC: Nachkodierung erfolgt
Description

nc

Data type

integer

Alias
VAR_NAMES
nc
LABEL
PHA-NC: code revision takes place/will be made
DATA_TYPE
integer
VALUE_LABELS
0=No|1=Yes
MISSING_LIST_TABLE
missing_table_136
STUDY_SEGMENT
t1.pha_ident2
VARIABLE_ORDER
7.0
LABEL_DE
PHA-NC: Nachkodierung erfolgt
VALUE_LABELS_DE
0=Nein|1=Ja
TABLE_NAME
T_PHA
UNIQUE_NAME
t1.nc
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PHA|PHA_IDENT|PHA_IDENT2
PHA-NC: Nachkodierungsquelle
Description

nc_ident

Data type

integer

Alias
VAR_NAMES
nc_ident
LABEL
PHA-NC: code revision source
DATA_TYPE
integer
VALUE_LABELS
0=by hand|1=per IDOM
MISSING_LIST_TABLE
missing_table_136
STUDY_SEGMENT
t1.pha_ident2
VARIABLE_ORDER
8.0
LABEL_DE
PHA-NC: Nachkodierungsquelle
VALUE_LABELS_DE
0=per Hand|1=per IDOM
TABLE_NAME
T_PHA
UNIQUE_NAME
t1.nc_ident
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PHA|PHA_IDENT|PHA_IDENT2
PHA-NC: Sicherheit der Nachkodierung
Description

nc_sicherheit

Data type

integer

Alias
VAR_NAMES
nc_sicherheit
LABEL
PHA-NC: safety of code revision
DATA_TYPE
integer
VALUE_LABELS
1=impossible|2=unsure|3=sure
MISSING_LIST_TABLE
missing_table_136
STUDY_SEGMENT
t1.pha_ident2
VARIABLE_ORDER
9.0
LABEL_DE
PHA-NC: Sicherheit der Nachkodierung
VALUE_LABELS_DE
1=unmöglich|2=unsicher|3=sicher
TABLE_NAME
T_PHA
UNIQUE_NAME
t1.nc_sicherheit
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PHA|PHA_IDENT|PHA_IDENT2
PHA-NC: Identifikationsstatus nach der Nachkodierung
Description

id_status

Data type

integer

Alias
VAR_NAMES
id_status
LABEL
PHA-NC: 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_136
STUDY_SEGMENT
t1.pha_ident2
VARIABLE_ORDER
10.0
LABEL_DE
PHA-NC: 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
TABLE_NAME
T_PHA
UNIQUE_NAME
t1.id_status
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PHA|PHA_IDENT|PHA_IDENT2
PHA: Normpackungsgröße
Description

Nonresponse: 5,88

Data type

string

Alias
VAR_NAMES
npg
LABEL
PHA: 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_136
STUDY_SEGMENT
t1.pha_ident2
VARIABLE_ORDER
11.0
LABEL_DE
PHA: 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)
NOTE_TYPE
1 - data quality for request form
NOTE_DE
Nonresponse: 5,88
TABLE_NAME
T_PHA
UNIQUE_NAME
t1.npg
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PHA|PHA_IDENT|PHA_IDENT2
PHA: Darreichungsform
Description

darreichungsform

Data type

string

Alias
VAR_NAMES
darreichungsform
LABEL
PHA: dosage form
DATA_TYPE
string
MISSING_LIST_TABLE
missing_table_136
STUDY_SEGMENT
t1.pha_ident2
VARIABLE_ORDER
12.0
LABEL_DE
PHA: Darreichungsform
TABLE_NAME
T_PHA
UNIQUE_NAME
t1.darreichungsform
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PHA|PHA_IDENT|PHA_IDENT2
PHA: Packungsgröße
Description

pg

Data type

integer

Alias
VAR_NAMES
pg
LABEL
PHA: package/packaging size
DATA_TYPE
integer
MISSING_LIST_TABLE
missing_table_136
STUDY_SEGMENT
t1.pha_ident2
VARIABLE_ORDER
13.0
LABEL_DE
PHA: Packungsgröße
TABLE_NAME
T_PHA
UNIQUE_NAME
t1.pg
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PHA|PHA_IDENT|PHA_IDENT2
PHA: Preis
Description

preis

Data type

float

Alias
VAR_NAMES
preis
LABEL
PHA: price in cent
DATA_TYPE
float
MISSING_LIST_TABLE
missing_table_136
STUDY_SEGMENT
t1.pha_ident2
VARIABLE_ORDER
14.0
LABEL_DE
PHA: Preis
TABLE_NAME
T_PHA
UNIQUE_NAME
t1.preis
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PHA|PHA_IDENT|PHA_IDENT2
PHA: Festpreis
Description

festpreis

Data type

float

Alias
VAR_NAMES
festpreis
LABEL
PHA: fixed price in cent
DATA_TYPE
float
MISSING_LIST_TABLE
missing_table_136
STUDY_SEGMENT
t1.pha_ident2
VARIABLE_ORDER
15.0
LABEL_DE
PHA: Festpreis
TABLE_NAME
T_PHA
UNIQUE_NAME
t1.festpreis
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PHA|PHA_IDENT|PHA_IDENT2
PHA: Original Arzneimittelbezeichnung
Description

bezeichnung_orig

Data type

string

Alias
VAR_NAMES
bezeichnung_orig
LABEL
PHA: original drug label
DATA_TYPE
string
MISSING_LIST_TABLE
missing_table_136
STUDY_SEGMENT
t1.pha_ident2
VARIABLE_ORDER
16.0
LABEL_DE
PHA: Original Arzneimittelbezeichnung
TABLE_NAME
T_PHA
UNIQUE_NAME
t1.bezeichnung_orig
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PHA|PHA_IDENT|PHA_IDENT2
PHA: Original Pharmazentralnummer
Description

Nonresponse: 9,68

Data type

float

Alias
VAR_NAMES
pzn_orig
LABEL
PHA: original central pharma number
DATA_TYPE
float
MISSING_LIST_TABLE
missing_table_136
STUDY_SEGMENT
t1.pha_ident2
VARIABLE_ORDER
17.0
LABEL_DE
PHA: Original Pharmazentralnummer
NOTE_TYPE
1 - data quality for request form
NOTE_DE
Nonresponse: 9,68
TABLE_NAME
T_PHA
UNIQUE_NAME
t1.pzn_orig
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PHA|PHA_IDENT|PHA_IDENT2
PHA: Original ATC-Code
Description

Nonresponse: 10,55

Data type

string

Alias
VAR_NAMES
atc_orig
LABEL
PHA: original ATC-Code
DATA_TYPE
string
MISSING_LIST_TABLE
missing_table_136
STUDY_SEGMENT
t1.pha_ident2
VARIABLE_ORDER
18.0
LABEL_DE
PHA: Original ATC-Code
NOTE_TYPE
1 - data quality for request form
NOTE_DE
Nonresponse: 10,55
TABLE_NAME
T_PHA
UNIQUE_NAME
t1.atc_orig
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PHA|PHA_IDENT|PHA_IDENT2
PHA: Identifikationsstatus vor der Nachkodierung
Description

id_status_orig

Data type

integer

Alias
VAR_NAMES
id_status_orig
LABEL
PHA: 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_136
STUDY_SEGMENT
t1.pha_ident2
VARIABLE_ORDER
19.0
LABEL_DE
PHA: 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
TABLE_NAME
T_PHA
UNIQUE_NAME
t1.id_status_orig
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PHA|PHA_IDENT|PHA_IDENT2
Herstellerschlüssel
Description

Nonresponse: 11,63

Data type

string

Alias
VAR_NAMES
herstellerschluessel
LABEL
Manufacturer key
DATA_TYPE
string
MISSING_LIST_TABLE
missing_table_136
STUDY_SEGMENT
t1.pha_ident2
VARIABLE_ORDER
20.0
LABEL_DE
Herstellerschlüssel
NOTE_TYPE
1 - data quality for request form
NOTE_DE
Nonresponse: 11,63
TABLE_NAME
T_PHA
UNIQUE_NAME
t1.herstellerschluessel
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PHA|PHA_IDENT|PHA_IDENT2
Applikationsform
Description

Nonresponse: 9,51

Data type

string

Alias
VAR_NAMES
applikationsform
LABEL
Application form
DATA_TYPE
string
MISSING_LIST_TABLE
missing_table_136
STUDY_SEGMENT
t1.pha_ident2
VARIABLE_ORDER
21.0
LABEL_DE
Applikationsform
NOTE_TYPE
1 - data quality for request form
NOTE_DE
Nonresponse: 9,51
TABLE_NAME
T_PHA
UNIQUE_NAME
t1.applikationsform
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PHA|PHA_IDENT|PHA_IDENT2

Similar models

t1.pha_ident2

Name
Type
Description | Question | Decode (Coded Value)
Data type
Alias
Item Group
Item Group t1.pha_ident2
Item
PHA: Arzneimittelexposition
integer
am_exposition (VAR_NAMES)
PHA: drug exposure (LABEL)
integer (DATA_TYPE)
1=Yes|2=No (VALUE_LABELS)
missing_table_136 (MISSING_LIST_TABLE)
t1.pha_ident2 (STUDY_SEGMENT)
1.0 (VARIABLE_ORDER)
PHA: Arzneimittelexposition (LABEL_DE)
1=Ja|2=Nein (VALUE_LABELS_DE)
T_PHA (TABLE_NAME)
t1.am_exposition (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PHA|PHA_IDENT|PHA_IDENT2 (HIERARCHY)
Code List
PHA: Arzneimittelexposition
CL Item
Ja (1)
CL Item
Nein (2)
pha_lfd_nr
Item
PHA: Laufende Nummer - Arzneimittel je Proband
float
pha_lfd_nr (VAR_NAMES)
PHA: serial number - drug per test person (LABEL)
float (DATA_TYPE)
missing_table_136 (MISSING_LIST_TABLE)
t1.pha_ident2 (STUDY_SEGMENT)
2.0 (VARIABLE_ORDER)
PHA: Laufende Nummer - Arzneimittel je Proband (LABEL_DE)
T_PHA (TABLE_NAME)
t1.pha_lfd_nr (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PHA|PHA_IDENT|PHA_IDENT2 (HIERARCHY)
Item
PHA: Arzneimittelquelle
integer
quelleam (VAR_NAMES)
PHA: source of drugs/drug source (LABEL)
integer (DATA_TYPE)
1=Medication package: scanning of the PZN|2=Medication package: keyboard entry 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_136 (MISSING_LIST_TABLE)
t1.pha_ident2 (STUDY_SEGMENT)
3.0 (VARIABLE_ORDER)
PHA: 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)
T_PHA (TABLE_NAME)
t1.quelleam (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PHA|PHA_IDENT|PHA_IDENT2 (HIERARCHY)
Code List
PHA: Arzneimittelquelle
CL Item
Medikamentenpackung: Einscannen der PZN (1)
CL Item
Medikamentenpackung: Tastatureingabe der PZN (2)
CL Item
Medikamentenpackung: Arzneimittelname (3)
CL Item
Beipackzettel (4)
CL Item
Medikamentenplan (5)
CL Item
Rezept (6)
CL Item
Probandenangaben (7)
CL Item
NACHERHEBUNG (Telefon/Zettel): Tastatureingabe der PZN (8)
CL Item
NACHERHEBUNG (Telefon/Zettel): Arzneimittelname (9)
CL Item
NACHERHEBUNG (Medikamentenpackung): Tastatureingabe der PZN (10)
bezeichnung
Item
PHA-NC: Arzneimittelbezeichnung nach der Nachkodierung
string
bezeichnung (VAR_NAMES)
PHA-NC: drug label after code revision (LABEL)
string (DATA_TYPE)
missing_table_136 (MISSING_LIST_TABLE)
t1.pha_ident2 (STUDY_SEGMENT)
4.0 (VARIABLE_ORDER)
PHA-NC: Arzneimittelbezeichnung nach der Nachkodierung (LABEL_DE)
T_PHA (TABLE_NAME)
t1.bezeichnung (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PHA|PHA_IDENT|PHA_IDENT2 (HIERARCHY)
pzn
Item
PHA-NC: Pharmazentralnummer nach der Nachkodierung
float
pzn (VAR_NAMES)
PHA-NC: central pharma number after code revision (LABEL)
float (DATA_TYPE)
missing_table_136 (MISSING_LIST_TABLE)
t1.pha_ident2 (STUDY_SEGMENT)
5.0 (VARIABLE_ORDER)
PHA-NC: Pharmazentralnummer nach der Nachkodierung (LABEL_DE)
1 - data quality for request form (NOTE_TYPE)
Nonresponse: 8,85 (NOTE_DE)
T_PHA (TABLE_NAME)
t1.pzn (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PHA|PHA_IDENT|PHA_IDENT2 (HIERARCHY)
atc
Item
PHA-NC: ATC-Code nach der Nachkodierung
string
atc (VAR_NAMES)
PHA-NC: ATC code after code revision (LABEL)
string (DATA_TYPE)
missing_table_136 (MISSING_LIST_TABLE)
t1.pha_ident2 (STUDY_SEGMENT)
6.0 (VARIABLE_ORDER)
PHA-NC: ATC-Code nach der Nachkodierung (LABEL_DE)
T_PHA (TABLE_NAME)
t1.atc (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PHA|PHA_IDENT|PHA_IDENT2 (HIERARCHY)
Item
PHA-NC: Nachkodierung erfolgt
integer
nc (VAR_NAMES)
PHA-NC: code revision takes place/will be made (LABEL)
integer (DATA_TYPE)
0=No|1=Yes (VALUE_LABELS)
missing_table_136 (MISSING_LIST_TABLE)
t1.pha_ident2 (STUDY_SEGMENT)
7.0 (VARIABLE_ORDER)
PHA-NC: Nachkodierung erfolgt (LABEL_DE)
0=Nein|1=Ja (VALUE_LABELS_DE)
T_PHA (TABLE_NAME)
t1.nc (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PHA|PHA_IDENT|PHA_IDENT2 (HIERARCHY)
Code List
PHA-NC: Nachkodierung erfolgt
CL Item
Ja (1)
CL Item
Nein (0)
Item
PHA-NC: Nachkodierungsquelle
integer
nc_ident (VAR_NAMES)
PHA-NC: code revision source (LABEL)
integer (DATA_TYPE)
0=by hand|1=per IDOM (VALUE_LABELS)
missing_table_136 (MISSING_LIST_TABLE)
t1.pha_ident2 (STUDY_SEGMENT)
8.0 (VARIABLE_ORDER)
PHA-NC: Nachkodierungsquelle (LABEL_DE)
0=per Hand|1=per IDOM (VALUE_LABELS_DE)
T_PHA (TABLE_NAME)
t1.nc_ident (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PHA|PHA_IDENT|PHA_IDENT2 (HIERARCHY)
Code List
PHA-NC: Nachkodierungsquelle
CL Item
per Hand (0)
CL Item
per IDOM (1)
Item
PHA-NC: Sicherheit der Nachkodierung
integer
nc_sicherheit (VAR_NAMES)
PHA-NC: safety of code revision (LABEL)
integer (DATA_TYPE)
1=impossible|2=unsure|3=sure (VALUE_LABELS)
missing_table_136 (MISSING_LIST_TABLE)
t1.pha_ident2 (STUDY_SEGMENT)
9.0 (VARIABLE_ORDER)
PHA-NC: Sicherheit der Nachkodierung (LABEL_DE)
1=unmöglich|2=unsicher|3=sicher (VALUE_LABELS_DE)
T_PHA (TABLE_NAME)
t1.nc_sicherheit (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PHA|PHA_IDENT|PHA_IDENT2 (HIERARCHY)
Code List
PHA-NC: Sicherheit der Nachkodierung
CL Item
unmöglich (1)
CL Item
unsicher (2)
CL Item
sicher (3)
Item
PHA-NC: Identifikationsstatus nach der Nachkodierung
integer
id_status (VAR_NAMES)
PHA-NC: 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_136 (MISSING_LIST_TABLE)
t1.pha_ident2 (STUDY_SEGMENT)
10.0 (VARIABLE_ORDER)
PHA-NC: 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)
T_PHA (TABLE_NAME)
t1.id_status (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PHA|PHA_IDENT|PHA_IDENT2 (HIERARCHY)
Code List
PHA-NC: Identifikationsstatus nach der Nachkodierung
CL Item
mit PZN / ATC komplett (1)
CL Item
mit PZN / ATC teilweise (2)
CL Item
mit PZN / kein ATC (3)
CL Item
keine PZN / ATC komplett (4)
CL Item
keine PZN / ATC teilweise (5)
CL Item
keine PZN / kein ATC (6)
Item
PHA: Normpackungsgröße
string
npg (VAR_NAMES)
PHA: 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_136 (MISSING_LIST_TABLE)
t1.pha_ident2 (STUDY_SEGMENT)
11.0 (VARIABLE_ORDER)
PHA: 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)
1 - data quality for request form (NOTE_TYPE)
Nonresponse: 5,88 (NOTE_DE)
T_PHA (TABLE_NAME)
t1.npg (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PHA|PHA_IDENT|PHA_IDENT2 (HIERARCHY)
Code List
PHA: Normpackungsgröße
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
Kombinationspackung (K) (6)
CL Item
nicht betroffen (N) (7)
CL Item
nicht erstattungsfähig (Z) (8)
darreichungsform
Item
PHA: Darreichungsform
string
darreichungsform (VAR_NAMES)
PHA: dosage form (LABEL)
string (DATA_TYPE)
missing_table_136 (MISSING_LIST_TABLE)
t1.pha_ident2 (STUDY_SEGMENT)
12.0 (VARIABLE_ORDER)
PHA: Darreichungsform (LABEL_DE)
T_PHA (TABLE_NAME)
t1.darreichungsform (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PHA|PHA_IDENT|PHA_IDENT2 (HIERARCHY)
pg
Item
PHA: Packungsgröße
integer
pg (VAR_NAMES)
PHA: package/packaging size (LABEL)
integer (DATA_TYPE)
missing_table_136 (MISSING_LIST_TABLE)
t1.pha_ident2 (STUDY_SEGMENT)
13.0 (VARIABLE_ORDER)
PHA: Packungsgröße (LABEL_DE)
T_PHA (TABLE_NAME)
t1.pg (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PHA|PHA_IDENT|PHA_IDENT2 (HIERARCHY)
preis
Item
PHA: Preis
float
preis (VAR_NAMES)
PHA: price in cent (LABEL)
float (DATA_TYPE)
missing_table_136 (MISSING_LIST_TABLE)
t1.pha_ident2 (STUDY_SEGMENT)
14.0 (VARIABLE_ORDER)
PHA: Preis (LABEL_DE)
T_PHA (TABLE_NAME)
t1.preis (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PHA|PHA_IDENT|PHA_IDENT2 (HIERARCHY)
festpreis
Item
PHA: Festpreis
float
festpreis (VAR_NAMES)
PHA: fixed price in cent (LABEL)
float (DATA_TYPE)
missing_table_136 (MISSING_LIST_TABLE)
t1.pha_ident2 (STUDY_SEGMENT)
15.0 (VARIABLE_ORDER)
PHA: Festpreis (LABEL_DE)
T_PHA (TABLE_NAME)
t1.festpreis (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PHA|PHA_IDENT|PHA_IDENT2 (HIERARCHY)
bezeichnung_orig
Item
PHA: Original Arzneimittelbezeichnung
string
bezeichnung_orig (VAR_NAMES)
PHA: original drug label (LABEL)
string (DATA_TYPE)
missing_table_136 (MISSING_LIST_TABLE)
t1.pha_ident2 (STUDY_SEGMENT)
16.0 (VARIABLE_ORDER)
PHA: Original Arzneimittelbezeichnung (LABEL_DE)
T_PHA (TABLE_NAME)
t1.bezeichnung_orig (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PHA|PHA_IDENT|PHA_IDENT2 (HIERARCHY)
pzn_orig
Item
PHA: Original Pharmazentralnummer
float
pzn_orig (VAR_NAMES)
PHA: original central pharma number (LABEL)
float (DATA_TYPE)
missing_table_136 (MISSING_LIST_TABLE)
t1.pha_ident2 (STUDY_SEGMENT)
17.0 (VARIABLE_ORDER)
PHA: Original Pharmazentralnummer (LABEL_DE)
1 - data quality for request form (NOTE_TYPE)
Nonresponse: 9,68 (NOTE_DE)
T_PHA (TABLE_NAME)
t1.pzn_orig (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PHA|PHA_IDENT|PHA_IDENT2 (HIERARCHY)
atc_orig
Item
PHA: Original ATC-Code
string
atc_orig (VAR_NAMES)
PHA: original ATC-Code (LABEL)
string (DATA_TYPE)
missing_table_136 (MISSING_LIST_TABLE)
t1.pha_ident2 (STUDY_SEGMENT)
18.0 (VARIABLE_ORDER)
PHA: Original ATC-Code (LABEL_DE)
1 - data quality for request form (NOTE_TYPE)
Nonresponse: 10,55 (NOTE_DE)
T_PHA (TABLE_NAME)
t1.atc_orig (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PHA|PHA_IDENT|PHA_IDENT2 (HIERARCHY)
Item
PHA: Identifikationsstatus vor der Nachkodierung
integer
id_status_orig (VAR_NAMES)
PHA: 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_136 (MISSING_LIST_TABLE)
t1.pha_ident2 (STUDY_SEGMENT)
19.0 (VARIABLE_ORDER)
PHA: 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)
T_PHA (TABLE_NAME)
t1.id_status_orig (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PHA|PHA_IDENT|PHA_IDENT2 (HIERARCHY)
Code List
PHA: Identifikationsstatus vor der Nachkodierung
CL Item
mit PZN / ATC komplett (1)
CL Item
mit PZN / ATC teilweise (2)
CL Item
mit PZN / kein ATC (3)
CL Item
keine PZN / ATC komplett (4)
CL Item
keine PZN / ATC teilweise (5)
CL Item
keine PZN / kein ATC (6)
herstellerschluessel
Item
Herstellerschlüssel
string
herstellerschluessel (VAR_NAMES)
Manufacturer key (LABEL)
string (DATA_TYPE)
missing_table_136 (MISSING_LIST_TABLE)
t1.pha_ident2 (STUDY_SEGMENT)
20.0 (VARIABLE_ORDER)
Herstellerschlüssel (LABEL_DE)
1 - data quality for request form (NOTE_TYPE)
Nonresponse: 11,63 (NOTE_DE)
T_PHA (TABLE_NAME)
t1.herstellerschluessel (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PHA|PHA_IDENT|PHA_IDENT2 (HIERARCHY)
applikationsform
Item
Applikationsform
string
applikationsform (VAR_NAMES)
Application form (LABEL)
string (DATA_TYPE)
missing_table_136 (MISSING_LIST_TABLE)
t1.pha_ident2 (STUDY_SEGMENT)
21.0 (VARIABLE_ORDER)
Applikationsform (LABEL_DE)
1 - data quality for request form (NOTE_TYPE)
Nonresponse: 9,51 (NOTE_DE)
T_PHA (TABLE_NAME)
t1.applikationsform (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PHA|PHA_IDENT|PHA_IDENT2 (HIERARCHY)