t1.piacontact

Item Group t1.piacontact
Description

Item Group t1.piacontact

Date of request
Description

piacrm_request_date

Data type

datetime

Alias
VAR_NAMES
piacrm_request_date
LABEL
Date of request
DATA_TYPE
datetime
MISSING_LIST_TABLE
missing_table_3040
STUDY_SEGMENT
t1.piacontact
VARIABLE_ORDER
10.0
LABEL_DE
Datum der Anfrage
TABLE_NAME
T_PIACONTACT
UNIQUE_NAME
t1.piacrm_request_date
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PIA|PIAOPD|PIACONTACT
type of request: content
Description

piacrm_content

Data type

integer

Alias
VAR_NAMES
piacrm_content
LABEL
type of request: content
DATA_TYPE
integer
VALUE_LABELS
0=no|1=yes
MISSING_LIST_TABLE
missing_table_3040
STUDY_SEGMENT
t1.piacontact
VARIABLE_ORDER
20.0
LABEL_DE
Art der Anfrage: Inhaltlich
VALUE_LABELS_DE
0=nein|1=ja
TABLE_NAME
T_PIACONTACT
UNIQUE_NAME
t1.piacrm_content
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PIA|PIAOPD|PIACONTACT
type of request: technical
Description

piacrm_technical

Data type

integer

Alias
VAR_NAMES
piacrm_technical
LABEL
type of request: technical
DATA_TYPE
integer
VALUE_LABELS
0=no|1=yes
MISSING_LIST_TABLE
missing_table_3040
STUDY_SEGMENT
t1.piacontact
VARIABLE_ORDER
30.0
LABEL_DE
Art der Anfrage: Technisch
VALUE_LABELS_DE
0=nein|1=ja
TABLE_NAME
T_PIACONTACT
UNIQUE_NAME
t1.piacrm_technical
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PIA|PIAOPD|PIACONTACT
type of request: study participation
Description

piacrm_study

Data type

integer

Alias
VAR_NAMES
piacrm_study
LABEL
type of request: study participation
DATA_TYPE
integer
VALUE_LABELS
0=no|1=yes
MISSING_LIST_TABLE
missing_table_3040
STUDY_SEGMENT
t1.piacontact
VARIABLE_ORDER
40.0
LABEL_DE
Art der Anfrage: Studienteilnahme
VALUE_LABELS_DE
0=nein|1=ja
TABLE_NAME
T_PIACONTACT
UNIQUE_NAME
t1.piacrm_study
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PIA|PIAOPD|PIACONTACT
type of request: other
Description

piacrm_other_yn

Data type

integer

Alias
VAR_NAMES
piacrm_other_yn
LABEL
type of request: other
DATA_TYPE
integer
VALUE_LABELS
0=no|1=yes
MISSING_LIST_TABLE
missing_table_3040
STUDY_SEGMENT
t1.piacontact
VARIABLE_ORDER
50.0
LABEL_DE
Art der Anfrage: Sonstiges
VALUE_LABELS_DE
0=nein|1=ja
TABLE_NAME
T_PIACONTACT
UNIQUE_NAME
t1.piacrm_other_yn
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PIA|PIAOPD|PIACONTACT
type of request: other details
Description

piacrm_other

Data type

string

Alias
VAR_NAMES
piacrm_other
LABEL
type of request: other details
DATA_TYPE
string
MISSING_LIST_TABLE
missing_table_3040
STUDY_SEGMENT
t1.piacontact
VARIABLE_ORDER
60.0
LABEL_DE
Art der Anfrage: Sonstiges Details
TABLE_NAME
T_PIACONTACT
UNIQUE_NAME
t1.piacrm_other
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PIA|PIAOPD|PIACONTACT
content-related: understanding of individual questions
Description

piacrm_content_grasp

Data type

integer

Alias
VAR_NAMES
piacrm_content_grasp
LABEL
content-related: understanding of individual questions
DATA_TYPE
integer
VALUE_LABELS
0=no|1=yes
MISSING_LIST_TABLE
missing_table_3040
STUDY_SEGMENT
t1.piacontact
VARIABLE_ORDER
70.0
LABEL_DE
Inhaltlich: Verständnis einzelner Fragen
VALUE_LABELS_DE
0=nein|1=ja
TABLE_NAME
T_PIACONTACT
UNIQUE_NAME
t1.piacrm_content_grasp
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PIA|PIAOPD|PIACONTACT
content-related: relations between questionnaires
Description

piacrm_content_relation

Data type

integer

Alias
VAR_NAMES
piacrm_content_relation
LABEL
content-related: relations between questionnaires
DATA_TYPE
integer
VALUE_LABELS
0=no|1=yes
MISSING_LIST_TABLE
missing_table_3040
STUDY_SEGMENT
t1.piacontact
VARIABLE_ORDER
80.0
LABEL_DE
Inhaltlich: Bezüge zwischen Fragebögen
VALUE_LABELS_DE
0=nein|1=ja
TABLE_NAME
T_PIACONTACT
UNIQUE_NAME
t1.piacrm_content_relation
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PIA|PIAOPD|PIACONTACT
content-related: accompanying materials
Description

piacrm_content_supportmat

Data type

integer

Alias
VAR_NAMES
piacrm_content_supportmat
LABEL
content-related: accompanying materials
DATA_TYPE
integer
VALUE_LABELS
0=no|1=yes
MISSING_LIST_TABLE
missing_table_3040
STUDY_SEGMENT
t1.piacontact
VARIABLE_ORDER
90.0
LABEL_DE
Inhaltlich: Begleitmaterialien
VALUE_LABELS_DE
0=nein|1=ja
TABLE_NAME
T_PIACONTACT
UNIQUE_NAME
t1.piacrm_content_supportmat
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PIA|PIAOPD|PIACONTACT
content-related: other
Description

piacrm_content_other_yn

Data type

integer

Alias
VAR_NAMES
piacrm_content_other_yn
LABEL
content-related: other
DATA_TYPE
integer
VALUE_LABELS
0=no|1=yes
MISSING_LIST_TABLE
missing_table_3040
STUDY_SEGMENT
t1.piacontact
VARIABLE_ORDER
100.0
LABEL_DE
Inhaltlich: Sonstiges
VALUE_LABELS_DE
0=nein|1=ja
TABLE_NAME
T_PIACONTACT
UNIQUE_NAME
t1.piacrm_content_other_yn
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PIA|PIAOPD|PIACONTACT
content-related: other
Description

piacrm_content_other

Data type

string

Alias
VAR_NAMES
piacrm_content_other
LABEL
content-related: other
DATA_TYPE
string
MISSING_LIST_TABLE
missing_table_3040
STUDY_SEGMENT
t1.piacontact
VARIABLE_ORDER
110.0
LABEL_DE
Inhaltlich: Sonstiges
TABLE_NAME
T_PIACONTACT
UNIQUE_NAME
t1.piacrm_content_other
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PIA|PIAOPD|PIACONTACT
technical: installation
Description

piacrm_tech_install

Data type

integer

Alias
VAR_NAMES
piacrm_tech_install
LABEL
technical: installation
DATA_TYPE
integer
VALUE_LABELS
0=no|1=yes
MISSING_LIST_TABLE
missing_table_3040
STUDY_SEGMENT
t1.piacontact
VARIABLE_ORDER
120.0
LABEL_DE
Technisch: Installation
VALUE_LABELS_DE
0=nein|1=ja
TABLE_NAME
T_PIACONTACT
UNIQUE_NAME
t1.piacrm_tech_install
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PIA|PIAOPD|PIACONTACT
technical: calling PIA page
Description

piacrm_tech_call_page

Data type

integer

Alias
VAR_NAMES
piacrm_tech_call_page
LABEL
technical: calling PIA page
DATA_TYPE
integer
VALUE_LABELS
0=no|1=yes
MISSING_LIST_TABLE
missing_table_3040
STUDY_SEGMENT
t1.piacontact
VARIABLE_ORDER
130.0
LABEL_DE
Technisch: Aufruf PIA-Seite
VALUE_LABELS_DE
0=nein|1=ja
TABLE_NAME
T_PIACONTACT
UNIQUE_NAME
t1.piacrm_tech_call_page
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PIA|PIAOPD|PIACONTACT
technical: registration
Description

piacrm_tech_registration

Data type

integer

Alias
VAR_NAMES
piacrm_tech_registration
LABEL
technical: registration
DATA_TYPE
integer
VALUE_LABELS
0=no|1=yes
MISSING_LIST_TABLE
missing_table_3040
STUDY_SEGMENT
t1.piacontact
VARIABLE_ORDER
140.0
LABEL_DE
Technisch: Anmeldung
VALUE_LABELS_DE
0=nein|1=ja
TABLE_NAME
T_PIACONTACT
UNIQUE_NAME
t1.piacrm_tech_registration
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PIA|PIAOPD|PIACONTACT
technical: registration email address
Description

piacrm_tech_email

Data type

integer

Alias
VAR_NAMES
piacrm_tech_email
LABEL
technical: registration email address
DATA_TYPE
integer
VALUE_LABELS
0=no|1=yes
MISSING_LIST_TABLE
missing_table_3040
STUDY_SEGMENT
t1.piacontact
VARIABLE_ORDER
150.0
LABEL_DE
Technisch: Registrierung E-Mail-Adresse
VALUE_LABELS_DE
0=nein|1=ja
TABLE_NAME
T_PIACONTACT
UNIQUE_NAME
t1.piacrm_tech_email
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PIA|PIAOPD|PIACONTACT
technical: in-app consent
Description

piacrm_tech_inapp

Data type

integer

Alias
VAR_NAMES
piacrm_tech_inapp
LABEL
technical: in-app consent
DATA_TYPE
integer
VALUE_LABELS
0=no|1=yes
MISSING_LIST_TABLE
missing_table_3040
STUDY_SEGMENT
t1.piacontact
VARIABLE_ORDER
160.0
LABEL_DE
Technisch: In-App-Einwilligung
VALUE_LABELS_DE
0=nein|1=ja
TABLE_NAME
T_PIACONTACT
UNIQUE_NAME
t1.piacrm_tech_inapp
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PIA|PIAOPD|PIACONTACT
technical: notifications from PIA
Description

piacrm_tech_notifications

Data type

integer

Alias
VAR_NAMES
piacrm_tech_notifications
LABEL
technical: notifications from PIA
DATA_TYPE
integer
VALUE_LABELS
0=no|1=yes
MISSING_LIST_TABLE
missing_table_3040
STUDY_SEGMENT
t1.piacontact
VARIABLE_ORDER
170.0
LABEL_DE
Technisch: Benachrichtigungen von PIA
VALUE_LABELS_DE
0=nein|1=ja
TABLE_NAME
T_PIACONTACT
UNIQUE_NAME
t1.piacrm_tech_notifications
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PIA|PIAOPD|PIACONTACT
technical: display of questionnaire content
Description

piacrm_tech_display

Data type

integer

Alias
VAR_NAMES
piacrm_tech_display
LABEL
technical: display of questionnaire content
DATA_TYPE
integer
VALUE_LABELS
0=no|1=yes
MISSING_LIST_TABLE
missing_table_3040
STUDY_SEGMENT
t1.piacontact
VARIABLE_ORDER
180.0
LABEL_DE
Technisch: Anzeige der Fragebogeninhalte
VALUE_LABELS_DE
0=nein|1=ja
TABLE_NAME
T_PIACONTACT
UNIQUE_NAME
t1.piacrm_tech_display
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PIA|PIAOPD|PIACONTACT
technical: unsubscribe
Description

piacrm_tech_unsubscribe

Data type

integer

Alias
VAR_NAMES
piacrm_tech_unsubscribe
LABEL
technical: unsubscribe
DATA_TYPE
integer
VALUE_LABELS
0=no|1=yes
MISSING_LIST_TABLE
missing_table_3040
STUDY_SEGMENT
t1.piacontact
VARIABLE_ORDER
190.0
LABEL_DE
Technisch: Abmeldung
VALUE_LABELS_DE
0=nein|1=ja
TABLE_NAME
T_PIACONTACT
UNIQUE_NAME
t1.piacrm_tech_unsubscribe
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PIA|PIAOPD|PIACONTACT
technical: other
Description

piacrm_tech_other_yn

Data type

integer

Alias
VAR_NAMES
piacrm_tech_other_yn
LABEL
technical: other
DATA_TYPE
integer
VALUE_LABELS
0=no|1=yes
MISSING_LIST_TABLE
missing_table_3040
STUDY_SEGMENT
t1.piacontact
VARIABLE_ORDER
200.0
LABEL_DE
Technisch: Sonstiges
VALUE_LABELS_DE
0=nein|1=ja
TABLE_NAME
T_PIACONTACT
UNIQUE_NAME
t1.piacrm_tech_other_yn
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PIA|PIAOPD|PIACONTACT
technical: other
Description

piacrm_tech_other

Data type

string

Alias
VAR_NAMES
piacrm_tech_other
LABEL
technical: other
DATA_TYPE
string
MISSING_LIST_TABLE
missing_table_3040
STUDY_SEGMENT
t1.piacontact
VARIABLE_ORDER
210.0
LABEL_DE
Technisch: Sonstiges
TABLE_NAME
T_PIACONTACT
UNIQUE_NAME
t1.piacrm_tech_other
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PIA|PIAOPD|PIACONTACT
Specification of the request - description of the problems
Description

piacrm_description

Data type

string

Alias
VAR_NAMES
piacrm_description
LABEL
Specification of the request - description of the problems
DATA_TYPE
string
MISSING_LIST_TABLE
missing_table_3040
STUDY_SEGMENT
t1.piacontact
VARIABLE_ORDER
220.0
LABEL_DE
Spezifikation der Anfrage - Beschreibung des Problems
TABLE_NAME
T_PIACONTACT
UNIQUE_NAME
t1.piacrm_description
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PIA|PIAOPD|PIACONTACT
examiner
Description

piacrm_examiner

Data type

float

Alias
VAR_NAMES
piacrm_examiner
LABEL
examiner
DATA_TYPE
float
MISSING_LIST_TABLE
missing_table_3040
STUDY_SEGMENT
t1.piacontact
VARIABLE_ORDER
230.0
LABEL_DE
Untersucher(in)
TABLE_NAME
T_PIACONTACT
UNIQUE_NAME
t1.piacrm_examiner
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PIA|PIAOPD|PIACONTACT
Status of processing the request
Description

piacrm_process

Data type

integer

Alias
VAR_NAMES
piacrm_process
LABEL
Status of processing the request
DATA_TYPE
integer
VALUE_LABELS
0=inquiry unprocessed|1=inquiry in progress|2=inquiry processed
MISSING_LIST_TABLE
missing_table_3040
STUDY_SEGMENT
t1.piacontact
VARIABLE_ORDER
240.0
LABEL_DE
Status der Bearbeitung der Anfrage
VALUE_LABELS_DE
0=Anfrage unbearbeitet|1=Anfrage in Bearbeitung|2=Anfrage bearbeitet
TABLE_NAME
T_PIACONTACT
UNIQUE_NAME
t1.piacrm_process
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PIA|PIAOPD|PIACONTACT
Problem solved
Description

piacrm_solution

Data type

integer

Alias
VAR_NAMES
piacrm_solution
LABEL
Problem solved
DATA_TYPE
integer
VALUE_LABELS
0=no|1=yes, completely|2=yes, partially
MISSING_LIST_TABLE
missing_table_3040
STUDY_SEGMENT
t1.piacontact
VARIABLE_ORDER
250.0
LABEL_DE
Lösung des Problems
VALUE_LABELS_DE
0=nein|1=Ja, vollständig|2=Ja, teilweise
TABLE_NAME
T_PIACONTACT
UNIQUE_NAME
t1.piacrm_solution
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PIA|PIAOPD|PIACONTACT
Description of solution
Description

piacrm_solution_description

Data type

string

Alias
VAR_NAMES
piacrm_solution_description
LABEL
Description of solution
DATA_TYPE
string
MISSING_LIST_TABLE
missing_table_3040
STUDY_SEGMENT
t1.piacontact
VARIABLE_ORDER
260.0
LABEL_DE
Beschreibung der Lösung
TABLE_NAME
T_PIACONTACT
UNIQUE_NAME
t1.piacrm_solution_description
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PIA|PIAOPD|PIACONTACT
forwarding of the request
Description

piacrm_request_fw_yn

Data type

integer

Alias
VAR_NAMES
piacrm_request_fw_yn
LABEL
forwarding of the request
DATA_TYPE
integer
VALUE_LABELS
0=no|1=yes
MISSING_LIST_TABLE
missing_table_3040
STUDY_SEGMENT
t1.piacontact
VARIABLE_ORDER
270.0
LABEL_DE
Weiterleitung der Anfrage
VALUE_LABELS_DE
0=nein|1=ja
TABLE_NAME
T_PIACONTACT
UNIQUE_NAME
t1.piacrm_request_fw_yn
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PIA|PIAOPD|PIACONTACT
forwarding of the request: project coordination
Description

piacrm_request_fw_pc

Data type

integer

Alias
VAR_NAMES
piacrm_request_fw_pc
LABEL
forwarding of the request: project coordination
DATA_TYPE
integer
VALUE_LABELS
0=no|1=yes
MISSING_LIST_TABLE
missing_table_3040
STUDY_SEGMENT
t1.piacontact
VARIABLE_ORDER
280.0
LABEL_DE
Weiterleitung der Anfrage: Projektkoordination
VALUE_LABELS_DE
0=nein|1=ja
TABLE_NAME
T_PIACONTACT
UNIQUE_NAME
t1.piacrm_request_fw_pc
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PIA|PIAOPD|PIACONTACT
date of forwarding of the request: project coordination
Description

piacrm_request_fw_pc_date

Data type

datetime

Alias
VAR_NAMES
piacrm_request_fw_pc_date
LABEL
date of forwarding of the request: project coordination
DATA_TYPE
datetime
MISSING_LIST_TABLE
missing_table_3040
STUDY_SEGMENT
t1.piacontact
VARIABLE_ORDER
290.0
LABEL_DE
Datum der Weiterleitung der Anfrage: Projektkoordination
TABLE_NAME
T_PIACONTACT
UNIQUE_NAME
t1.piacrm_request_fw_pc_date
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PIA|PIAOPD|PIACONTACT
forwarding of the request: HZI
Description

piacrm_request_fw_hzi

Data type

integer

Alias
VAR_NAMES
piacrm_request_fw_hzi
LABEL
forwarding of the request: HZI
DATA_TYPE
integer
VALUE_LABELS
0=no|1=yes
MISSING_LIST_TABLE
missing_table_3040
STUDY_SEGMENT
t1.piacontact
VARIABLE_ORDER
300.0
LABEL_DE
Weiterleitung der Anfrage: HZI
VALUE_LABELS_DE
0=nein|1=ja
TABLE_NAME
T_PIACONTACT
UNIQUE_NAME
t1.piacrm_request_fw_hzi
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PIA|PIAOPD|PIACONTACT
date of forwarding of the request: HZI
Description

piacrm_request_fw_hzi_date

Data type

datetime

Alias
VAR_NAMES
piacrm_request_fw_hzi_date
LABEL
date of forwarding of the request: HZI
DATA_TYPE
datetime
MISSING_LIST_TABLE
missing_table_3040
STUDY_SEGMENT
t1.piacontact
VARIABLE_ORDER
310.0
LABEL_DE
Datum der Weiterleitung der Anfrage: HZI
TABLE_NAME
T_PIACONTACT
UNIQUE_NAME
t1.piacrm_request_fw_hzi_date
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PIA|PIAOPD|PIACONTACT
forwarding of the request: participant management
Description

piacrm_request_fw_pbm

Data type

integer

Alias
VAR_NAMES
piacrm_request_fw_pbm
LABEL
forwarding of the request: participant management
DATA_TYPE
integer
VALUE_LABELS
0=no|1=yes
MISSING_LIST_TABLE
missing_table_3040
STUDY_SEGMENT
t1.piacontact
VARIABLE_ORDER
320.0
LABEL_DE
Weiterleitung der Anfrage: Probandenmanagement
VALUE_LABELS_DE
0=nein|1=ja
TABLE_NAME
T_PIACONTACT
UNIQUE_NAME
t1.piacrm_request_fw_pbm
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PIA|PIAOPD|PIACONTACT
date of forwarding of the request: participant management
Description

piacrm_request_fw_pbm_date

Data type

datetime

Alias
VAR_NAMES
piacrm_request_fw_pbm_date
LABEL
date of forwarding of the request: participant management
DATA_TYPE
datetime
MISSING_LIST_TABLE
missing_table_3040
STUDY_SEGMENT
t1.piacontact
VARIABLE_ORDER
330.0
LABEL_DE
Datum der Weiterleitung der Anfrage: Probandenmanagement
TABLE_NAME
T_PIACONTACT
UNIQUE_NAME
t1.piacrm_request_fw_pbm_date
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PIA|PIAOPD|PIACONTACT
Contact made?
Description

piacrm_contact_yn

Data type

integer

Alias
VAR_NAMES
piacrm_contact_yn
LABEL
Contact made?
DATA_TYPE
integer
VALUE_LABELS
0=no|1=yes|2=not required
MISSING_LIST_TABLE
missing_table_3040
STUDY_SEGMENT
t1.piacontact
VARIABLE_ORDER
340.0
LABEL_DE
Kontaktaufnahme erfolgt?
VALUE_LABELS_DE
0=nein|1=ja|2=nicht erforderlich
TABLE_NAME
T_PIACONTACT
UNIQUE_NAME
t1.piacrm_contact_yn
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PIA|PIAOPD|PIACONTACT
date of contact
Description

piacrm_contact_date

Data type

datetime

Alias
VAR_NAMES
piacrm_contact_date
LABEL
date of contact
DATA_TYPE
datetime
MISSING_LIST_TABLE
missing_table_3040
STUDY_SEGMENT
t1.piacontact
VARIABLE_ORDER
350.0
LABEL_DE
Datum der Kontaktaufnahme
TABLE_NAME
T_PIACONTACT
UNIQUE_NAME
t1.piacrm_contact_date
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PIA|PIAOPD|PIACONTACT
type of contact
Description

piacrm_contact_type

Data type

integer

Alias
VAR_NAMES
piacrm_contact_type
LABEL
type of contact
DATA_TYPE
integer
VALUE_LABELS
0=E-Mail|1=Phone
MISSING_LIST_TABLE
missing_table_3040
STUDY_SEGMENT
t1.piacontact
VARIABLE_ORDER
360.0
LABEL_DE
Art der Kontaktaufnahme
VALUE_LABELS_DE
0=E-Mail|1=Telefon
TABLE_NAME
T_PIACONTACT
UNIQUE_NAME
t1.piacrm_contact_type
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PIA|PIAOPD|PIACONTACT
Date of response (clarification)
Description

piacrm_response_date

Data type

datetime

Alias
VAR_NAMES
piacrm_response_date
LABEL
Date of response (clarification)
DATA_TYPE
datetime
MISSING_LIST_TABLE
missing_table_3039
STUDY_SEGMENT
t1.piacontact
VARIABLE_ORDER
370.0
LABEL_DE
Datum der Antwort (Klärung)
TABLE_NAME
T_PIACONTACT
UNIQUE_NAME
t1.piacrm_response_date
SOURCE
TREND
DCE
SHIPTrend-1
HIERARCHY
TREND|TREND1|PIA|PIAOPD|PIACONTACT

Similar models

t1.piacontact

Name
Type
Description | Question | Decode (Coded Value)
Data type
Alias
Item Group
Item Group t1.piacontact
piacrm_request_date
Item
Date of request
datetime
piacrm_request_date (VAR_NAMES)
Date of request (LABEL)
datetime (DATA_TYPE)
missing_table_3040 (MISSING_LIST_TABLE)
t1.piacontact (STUDY_SEGMENT)
10.0 (VARIABLE_ORDER)
Datum der Anfrage (LABEL_DE)
T_PIACONTACT (TABLE_NAME)
t1.piacrm_request_date (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PIA|PIAOPD|PIACONTACT (HIERARCHY)
Item
type of request: content
integer
piacrm_content (VAR_NAMES)
type of request: content (LABEL)
integer (DATA_TYPE)
0=no|1=yes (VALUE_LABELS)
missing_table_3040 (MISSING_LIST_TABLE)
t1.piacontact (STUDY_SEGMENT)
20.0 (VARIABLE_ORDER)
Art der Anfrage: Inhaltlich (LABEL_DE)
0=nein|1=ja (VALUE_LABELS_DE)
T_PIACONTACT (TABLE_NAME)
t1.piacrm_content (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PIA|PIAOPD|PIACONTACT (HIERARCHY)
Code List
type of request: content
CL Item
no (0)
CL Item
yes (1)
Item
type of request: technical
integer
piacrm_technical (VAR_NAMES)
type of request: technical (LABEL)
integer (DATA_TYPE)
0=no|1=yes (VALUE_LABELS)
missing_table_3040 (MISSING_LIST_TABLE)
t1.piacontact (STUDY_SEGMENT)
30.0 (VARIABLE_ORDER)
Art der Anfrage: Technisch (LABEL_DE)
0=nein|1=ja (VALUE_LABELS_DE)
T_PIACONTACT (TABLE_NAME)
t1.piacrm_technical (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PIA|PIAOPD|PIACONTACT (HIERARCHY)
Code List
type of request: technical
CL Item
no (0)
CL Item
yes (1)
Item
type of request: study participation
integer
piacrm_study (VAR_NAMES)
type of request: study participation (LABEL)
integer (DATA_TYPE)
0=no|1=yes (VALUE_LABELS)
missing_table_3040 (MISSING_LIST_TABLE)
t1.piacontact (STUDY_SEGMENT)
40.0 (VARIABLE_ORDER)
Art der Anfrage: Studienteilnahme (LABEL_DE)
0=nein|1=ja (VALUE_LABELS_DE)
T_PIACONTACT (TABLE_NAME)
t1.piacrm_study (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PIA|PIAOPD|PIACONTACT (HIERARCHY)
Code List
type of request: study participation
CL Item
no (0)
CL Item
yes (1)
Item
type of request: other
integer
piacrm_other_yn (VAR_NAMES)
type of request: other (LABEL)
integer (DATA_TYPE)
0=no|1=yes (VALUE_LABELS)
missing_table_3040 (MISSING_LIST_TABLE)
t1.piacontact (STUDY_SEGMENT)
50.0 (VARIABLE_ORDER)
Art der Anfrage: Sonstiges (LABEL_DE)
0=nein|1=ja (VALUE_LABELS_DE)
T_PIACONTACT (TABLE_NAME)
t1.piacrm_other_yn (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PIA|PIAOPD|PIACONTACT (HIERARCHY)
Code List
type of request: other
CL Item
no (0)
CL Item
yes (1)
piacrm_other
Item
type of request: other details
string
piacrm_other (VAR_NAMES)
type of request: other details (LABEL)
string (DATA_TYPE)
missing_table_3040 (MISSING_LIST_TABLE)
t1.piacontact (STUDY_SEGMENT)
60.0 (VARIABLE_ORDER)
Art der Anfrage: Sonstiges Details (LABEL_DE)
T_PIACONTACT (TABLE_NAME)
t1.piacrm_other (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PIA|PIAOPD|PIACONTACT (HIERARCHY)
Item
content-related: understanding of individual questions
integer
piacrm_content_grasp (VAR_NAMES)
content-related: understanding of individual questions (LABEL)
integer (DATA_TYPE)
0=no|1=yes (VALUE_LABELS)
missing_table_3040 (MISSING_LIST_TABLE)
t1.piacontact (STUDY_SEGMENT)
70.0 (VARIABLE_ORDER)
Inhaltlich: Verständnis einzelner Fragen (LABEL_DE)
0=nein|1=ja (VALUE_LABELS_DE)
T_PIACONTACT (TABLE_NAME)
t1.piacrm_content_grasp (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PIA|PIAOPD|PIACONTACT (HIERARCHY)
Code List
content-related: understanding of individual questions
CL Item
no (0)
CL Item
yes (1)
Item
content-related: relations between questionnaires
integer
piacrm_content_relation (VAR_NAMES)
content-related: relations between questionnaires (LABEL)
integer (DATA_TYPE)
0=no|1=yes (VALUE_LABELS)
missing_table_3040 (MISSING_LIST_TABLE)
t1.piacontact (STUDY_SEGMENT)
80.0 (VARIABLE_ORDER)
Inhaltlich: Bezüge zwischen Fragebögen (LABEL_DE)
0=nein|1=ja (VALUE_LABELS_DE)
T_PIACONTACT (TABLE_NAME)
t1.piacrm_content_relation (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PIA|PIAOPD|PIACONTACT (HIERARCHY)
Code List
content-related: relations between questionnaires
CL Item
no (0)
CL Item
yes (1)
Item
content-related: accompanying materials
integer
piacrm_content_supportmat (VAR_NAMES)
content-related: accompanying materials (LABEL)
integer (DATA_TYPE)
0=no|1=yes (VALUE_LABELS)
missing_table_3040 (MISSING_LIST_TABLE)
t1.piacontact (STUDY_SEGMENT)
90.0 (VARIABLE_ORDER)
Inhaltlich: Begleitmaterialien (LABEL_DE)
0=nein|1=ja (VALUE_LABELS_DE)
T_PIACONTACT (TABLE_NAME)
t1.piacrm_content_supportmat (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PIA|PIAOPD|PIACONTACT (HIERARCHY)
Code List
content-related: accompanying materials
CL Item
no (0)
CL Item
yes (1)
Item
content-related: other
integer
piacrm_content_other_yn (VAR_NAMES)
content-related: other (LABEL)
integer (DATA_TYPE)
0=no|1=yes (VALUE_LABELS)
missing_table_3040 (MISSING_LIST_TABLE)
t1.piacontact (STUDY_SEGMENT)
100.0 (VARIABLE_ORDER)
Inhaltlich: Sonstiges (LABEL_DE)
0=nein|1=ja (VALUE_LABELS_DE)
T_PIACONTACT (TABLE_NAME)
t1.piacrm_content_other_yn (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PIA|PIAOPD|PIACONTACT (HIERARCHY)
Code List
content-related: other
CL Item
no (0)
CL Item
yes (1)
piacrm_content_other
Item
content-related: other
string
piacrm_content_other (VAR_NAMES)
content-related: other (LABEL)
string (DATA_TYPE)
missing_table_3040 (MISSING_LIST_TABLE)
t1.piacontact (STUDY_SEGMENT)
110.0 (VARIABLE_ORDER)
Inhaltlich: Sonstiges (LABEL_DE)
T_PIACONTACT (TABLE_NAME)
t1.piacrm_content_other (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PIA|PIAOPD|PIACONTACT (HIERARCHY)
Item
technical: installation
integer
piacrm_tech_install (VAR_NAMES)
technical: installation (LABEL)
integer (DATA_TYPE)
0=no|1=yes (VALUE_LABELS)
missing_table_3040 (MISSING_LIST_TABLE)
t1.piacontact (STUDY_SEGMENT)
120.0 (VARIABLE_ORDER)
Technisch: Installation (LABEL_DE)
0=nein|1=ja (VALUE_LABELS_DE)
T_PIACONTACT (TABLE_NAME)
t1.piacrm_tech_install (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PIA|PIAOPD|PIACONTACT (HIERARCHY)
Code List
technical: installation
CL Item
no (0)
CL Item
yes (1)
Item
technical: calling PIA page
integer
piacrm_tech_call_page (VAR_NAMES)
technical: calling PIA page (LABEL)
integer (DATA_TYPE)
0=no|1=yes (VALUE_LABELS)
missing_table_3040 (MISSING_LIST_TABLE)
t1.piacontact (STUDY_SEGMENT)
130.0 (VARIABLE_ORDER)
Technisch: Aufruf PIA-Seite (LABEL_DE)
0=nein|1=ja (VALUE_LABELS_DE)
T_PIACONTACT (TABLE_NAME)
t1.piacrm_tech_call_page (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PIA|PIAOPD|PIACONTACT (HIERARCHY)
Code List
technical: calling PIA page
CL Item
no (0)
CL Item
yes (1)
Item
technical: registration
integer
piacrm_tech_registration (VAR_NAMES)
technical: registration (LABEL)
integer (DATA_TYPE)
0=no|1=yes (VALUE_LABELS)
missing_table_3040 (MISSING_LIST_TABLE)
t1.piacontact (STUDY_SEGMENT)
140.0 (VARIABLE_ORDER)
Technisch: Anmeldung (LABEL_DE)
0=nein|1=ja (VALUE_LABELS_DE)
T_PIACONTACT (TABLE_NAME)
t1.piacrm_tech_registration (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PIA|PIAOPD|PIACONTACT (HIERARCHY)
Code List
technical: registration
CL Item
no (0)
CL Item
yes (1)
Item
technical: registration email address
integer
piacrm_tech_email (VAR_NAMES)
technical: registration email address (LABEL)
integer (DATA_TYPE)
0=no|1=yes (VALUE_LABELS)
missing_table_3040 (MISSING_LIST_TABLE)
t1.piacontact (STUDY_SEGMENT)
150.0 (VARIABLE_ORDER)
Technisch: Registrierung E-Mail-Adresse (LABEL_DE)
0=nein|1=ja (VALUE_LABELS_DE)
T_PIACONTACT (TABLE_NAME)
t1.piacrm_tech_email (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PIA|PIAOPD|PIACONTACT (HIERARCHY)
Code List
technical: registration email address
CL Item
no (0)
CL Item
yes (1)
Item
technical: in-app consent
integer
piacrm_tech_inapp (VAR_NAMES)
technical: in-app consent (LABEL)
integer (DATA_TYPE)
0=no|1=yes (VALUE_LABELS)
missing_table_3040 (MISSING_LIST_TABLE)
t1.piacontact (STUDY_SEGMENT)
160.0 (VARIABLE_ORDER)
Technisch: In-App-Einwilligung (LABEL_DE)
0=nein|1=ja (VALUE_LABELS_DE)
T_PIACONTACT (TABLE_NAME)
t1.piacrm_tech_inapp (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PIA|PIAOPD|PIACONTACT (HIERARCHY)
Code List
technical: in-app consent
CL Item
no (0)
CL Item
yes (1)
Item
technical: notifications from PIA
integer
piacrm_tech_notifications (VAR_NAMES)
technical: notifications from PIA (LABEL)
integer (DATA_TYPE)
0=no|1=yes (VALUE_LABELS)
missing_table_3040 (MISSING_LIST_TABLE)
t1.piacontact (STUDY_SEGMENT)
170.0 (VARIABLE_ORDER)
Technisch: Benachrichtigungen von PIA (LABEL_DE)
0=nein|1=ja (VALUE_LABELS_DE)
T_PIACONTACT (TABLE_NAME)
t1.piacrm_tech_notifications (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PIA|PIAOPD|PIACONTACT (HIERARCHY)
Code List
technical: notifications from PIA
CL Item
no (0)
CL Item
yes (1)
Item
technical: display of questionnaire content
integer
piacrm_tech_display (VAR_NAMES)
technical: display of questionnaire content (LABEL)
integer (DATA_TYPE)
0=no|1=yes (VALUE_LABELS)
missing_table_3040 (MISSING_LIST_TABLE)
t1.piacontact (STUDY_SEGMENT)
180.0 (VARIABLE_ORDER)
Technisch: Anzeige der Fragebogeninhalte (LABEL_DE)
0=nein|1=ja (VALUE_LABELS_DE)
T_PIACONTACT (TABLE_NAME)
t1.piacrm_tech_display (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PIA|PIAOPD|PIACONTACT (HIERARCHY)
Code List
technical: display of questionnaire content
CL Item
no (0)
CL Item
yes (1)
Item
technical: unsubscribe
integer
piacrm_tech_unsubscribe (VAR_NAMES)
technical: unsubscribe (LABEL)
integer (DATA_TYPE)
0=no|1=yes (VALUE_LABELS)
missing_table_3040 (MISSING_LIST_TABLE)
t1.piacontact (STUDY_SEGMENT)
190.0 (VARIABLE_ORDER)
Technisch: Abmeldung (LABEL_DE)
0=nein|1=ja (VALUE_LABELS_DE)
T_PIACONTACT (TABLE_NAME)
t1.piacrm_tech_unsubscribe (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PIA|PIAOPD|PIACONTACT (HIERARCHY)
Code List
technical: unsubscribe
CL Item
no (0)
CL Item
yes (1)
Item
technical: other
integer
piacrm_tech_other_yn (VAR_NAMES)
technical: other (LABEL)
integer (DATA_TYPE)
0=no|1=yes (VALUE_LABELS)
missing_table_3040 (MISSING_LIST_TABLE)
t1.piacontact (STUDY_SEGMENT)
200.0 (VARIABLE_ORDER)
Technisch: Sonstiges (LABEL_DE)
0=nein|1=ja (VALUE_LABELS_DE)
T_PIACONTACT (TABLE_NAME)
t1.piacrm_tech_other_yn (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PIA|PIAOPD|PIACONTACT (HIERARCHY)
Code List
technical: other
CL Item
no (0)
CL Item
yes (1)
piacrm_tech_other
Item
technical: other
string
piacrm_tech_other (VAR_NAMES)
technical: other (LABEL)
string (DATA_TYPE)
missing_table_3040 (MISSING_LIST_TABLE)
t1.piacontact (STUDY_SEGMENT)
210.0 (VARIABLE_ORDER)
Technisch: Sonstiges (LABEL_DE)
T_PIACONTACT (TABLE_NAME)
t1.piacrm_tech_other (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PIA|PIAOPD|PIACONTACT (HIERARCHY)
piacrm_description
Item
Specification of the request - description of the problems
string
piacrm_description (VAR_NAMES)
Specification of the request - description of the problems (LABEL)
string (DATA_TYPE)
missing_table_3040 (MISSING_LIST_TABLE)
t1.piacontact (STUDY_SEGMENT)
220.0 (VARIABLE_ORDER)
Spezifikation der Anfrage - Beschreibung des Problems (LABEL_DE)
T_PIACONTACT (TABLE_NAME)
t1.piacrm_description (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PIA|PIAOPD|PIACONTACT (HIERARCHY)
piacrm_examiner
Item
examiner
float
piacrm_examiner (VAR_NAMES)
examiner (LABEL)
float (DATA_TYPE)
missing_table_3040 (MISSING_LIST_TABLE)
t1.piacontact (STUDY_SEGMENT)
230.0 (VARIABLE_ORDER)
Untersucher(in) (LABEL_DE)
T_PIACONTACT (TABLE_NAME)
t1.piacrm_examiner (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PIA|PIAOPD|PIACONTACT (HIERARCHY)
Item
Status of processing the request
integer
piacrm_process (VAR_NAMES)
Status of processing the request (LABEL)
integer (DATA_TYPE)
0=inquiry unprocessed|1=inquiry in progress|2=inquiry processed (VALUE_LABELS)
missing_table_3040 (MISSING_LIST_TABLE)
t1.piacontact (STUDY_SEGMENT)
240.0 (VARIABLE_ORDER)
Status der Bearbeitung der Anfrage (LABEL_DE)
0=Anfrage unbearbeitet|1=Anfrage in Bearbeitung|2=Anfrage bearbeitet (VALUE_LABELS_DE)
T_PIACONTACT (TABLE_NAME)
t1.piacrm_process (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PIA|PIAOPD|PIACONTACT (HIERARCHY)
Code List
Status of processing the request
CL Item
inquiry unprocessed (0)
CL Item
inquiry in progress (1)
CL Item
inquiry processed (2)
Item
Problem solved
integer
piacrm_solution (VAR_NAMES)
Problem solved (LABEL)
integer (DATA_TYPE)
0=no|1=yes, completely|2=yes, partially (VALUE_LABELS)
missing_table_3040 (MISSING_LIST_TABLE)
t1.piacontact (STUDY_SEGMENT)
250.0 (VARIABLE_ORDER)
Lösung des Problems (LABEL_DE)
0=nein|1=Ja, vollständig|2=Ja, teilweise (VALUE_LABELS_DE)
T_PIACONTACT (TABLE_NAME)
t1.piacrm_solution (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PIA|PIAOPD|PIACONTACT (HIERARCHY)
Code List
Problem solved
CL Item
no (0)
CL Item
yes, completely (1)
CL Item
yes, partially (2)
piacrm_solution_description
Item
Description of solution
string
piacrm_solution_description (VAR_NAMES)
Description of solution (LABEL)
string (DATA_TYPE)
missing_table_3040 (MISSING_LIST_TABLE)
t1.piacontact (STUDY_SEGMENT)
260.0 (VARIABLE_ORDER)
Beschreibung der Lösung (LABEL_DE)
T_PIACONTACT (TABLE_NAME)
t1.piacrm_solution_description (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PIA|PIAOPD|PIACONTACT (HIERARCHY)
Item
forwarding of the request
integer
piacrm_request_fw_yn (VAR_NAMES)
forwarding of the request (LABEL)
integer (DATA_TYPE)
0=no|1=yes (VALUE_LABELS)
missing_table_3040 (MISSING_LIST_TABLE)
t1.piacontact (STUDY_SEGMENT)
270.0 (VARIABLE_ORDER)
Weiterleitung der Anfrage (LABEL_DE)
0=nein|1=ja (VALUE_LABELS_DE)
T_PIACONTACT (TABLE_NAME)
t1.piacrm_request_fw_yn (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PIA|PIAOPD|PIACONTACT (HIERARCHY)
Code List
forwarding of the request
CL Item
no (0)
CL Item
yes (1)
Item
forwarding of the request: project coordination
integer
piacrm_request_fw_pc (VAR_NAMES)
forwarding of the request: project coordination (LABEL)
integer (DATA_TYPE)
0=no|1=yes (VALUE_LABELS)
missing_table_3040 (MISSING_LIST_TABLE)
t1.piacontact (STUDY_SEGMENT)
280.0 (VARIABLE_ORDER)
Weiterleitung der Anfrage: Projektkoordination (LABEL_DE)
0=nein|1=ja (VALUE_LABELS_DE)
T_PIACONTACT (TABLE_NAME)
t1.piacrm_request_fw_pc (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PIA|PIAOPD|PIACONTACT (HIERARCHY)
Code List
forwarding of the request: project coordination
CL Item
no (0)
CL Item
yes (1)
piacrm_request_fw_pc_date
Item
date of forwarding of the request: project coordination
datetime
piacrm_request_fw_pc_date (VAR_NAMES)
date of forwarding of the request: project coordination (LABEL)
datetime (DATA_TYPE)
missing_table_3040 (MISSING_LIST_TABLE)
t1.piacontact (STUDY_SEGMENT)
290.0 (VARIABLE_ORDER)
Datum der Weiterleitung der Anfrage: Projektkoordination (LABEL_DE)
T_PIACONTACT (TABLE_NAME)
t1.piacrm_request_fw_pc_date (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PIA|PIAOPD|PIACONTACT (HIERARCHY)
Item
forwarding of the request: HZI
integer
piacrm_request_fw_hzi (VAR_NAMES)
forwarding of the request: HZI (LABEL)
integer (DATA_TYPE)
0=no|1=yes (VALUE_LABELS)
missing_table_3040 (MISSING_LIST_TABLE)
t1.piacontact (STUDY_SEGMENT)
300.0 (VARIABLE_ORDER)
Weiterleitung der Anfrage: HZI (LABEL_DE)
0=nein|1=ja (VALUE_LABELS_DE)
T_PIACONTACT (TABLE_NAME)
t1.piacrm_request_fw_hzi (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PIA|PIAOPD|PIACONTACT (HIERARCHY)
Code List
forwarding of the request: HZI
CL Item
no (0)
CL Item
yes (1)
piacrm_request_fw_hzi_date
Item
date of forwarding of the request: HZI
datetime
piacrm_request_fw_hzi_date (VAR_NAMES)
date of forwarding of the request: HZI (LABEL)
datetime (DATA_TYPE)
missing_table_3040 (MISSING_LIST_TABLE)
t1.piacontact (STUDY_SEGMENT)
310.0 (VARIABLE_ORDER)
Datum der Weiterleitung der Anfrage: HZI (LABEL_DE)
T_PIACONTACT (TABLE_NAME)
t1.piacrm_request_fw_hzi_date (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PIA|PIAOPD|PIACONTACT (HIERARCHY)
Item
forwarding of the request: participant management
integer
piacrm_request_fw_pbm (VAR_NAMES)
forwarding of the request: participant management (LABEL)
integer (DATA_TYPE)
0=no|1=yes (VALUE_LABELS)
missing_table_3040 (MISSING_LIST_TABLE)
t1.piacontact (STUDY_SEGMENT)
320.0 (VARIABLE_ORDER)
Weiterleitung der Anfrage: Probandenmanagement (LABEL_DE)
0=nein|1=ja (VALUE_LABELS_DE)
T_PIACONTACT (TABLE_NAME)
t1.piacrm_request_fw_pbm (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PIA|PIAOPD|PIACONTACT (HIERARCHY)
Code List
forwarding of the request: participant management
CL Item
no (0)
CL Item
yes (1)
piacrm_request_fw_pbm_date
Item
date of forwarding of the request: participant management
datetime
piacrm_request_fw_pbm_date (VAR_NAMES)
date of forwarding of the request: participant management (LABEL)
datetime (DATA_TYPE)
missing_table_3040 (MISSING_LIST_TABLE)
t1.piacontact (STUDY_SEGMENT)
330.0 (VARIABLE_ORDER)
Datum der Weiterleitung der Anfrage: Probandenmanagement (LABEL_DE)
T_PIACONTACT (TABLE_NAME)
t1.piacrm_request_fw_pbm_date (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PIA|PIAOPD|PIACONTACT (HIERARCHY)
Item
Contact made?
integer
piacrm_contact_yn (VAR_NAMES)
Contact made? (LABEL)
integer (DATA_TYPE)
0=no|1=yes|2=not required (VALUE_LABELS)
missing_table_3040 (MISSING_LIST_TABLE)
t1.piacontact (STUDY_SEGMENT)
340.0 (VARIABLE_ORDER)
Kontaktaufnahme erfolgt? (LABEL_DE)
0=nein|1=ja|2=nicht erforderlich (VALUE_LABELS_DE)
T_PIACONTACT (TABLE_NAME)
t1.piacrm_contact_yn (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PIA|PIAOPD|PIACONTACT (HIERARCHY)
Code List
Contact made?
CL Item
no (0)
CL Item
yes (1)
CL Item
not required (2)
piacrm_contact_date
Item
date of contact
datetime
piacrm_contact_date (VAR_NAMES)
date of contact (LABEL)
datetime (DATA_TYPE)
missing_table_3040 (MISSING_LIST_TABLE)
t1.piacontact (STUDY_SEGMENT)
350.0 (VARIABLE_ORDER)
Datum der Kontaktaufnahme (LABEL_DE)
T_PIACONTACT (TABLE_NAME)
t1.piacrm_contact_date (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PIA|PIAOPD|PIACONTACT (HIERARCHY)
Item
type of contact
integer
piacrm_contact_type (VAR_NAMES)
type of contact (LABEL)
integer (DATA_TYPE)
0=E-Mail|1=Phone (VALUE_LABELS)
missing_table_3040 (MISSING_LIST_TABLE)
t1.piacontact (STUDY_SEGMENT)
360.0 (VARIABLE_ORDER)
Art der Kontaktaufnahme (LABEL_DE)
0=E-Mail|1=Telefon (VALUE_LABELS_DE)
T_PIACONTACT (TABLE_NAME)
t1.piacrm_contact_type (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PIA|PIAOPD|PIACONTACT (HIERARCHY)
Code List
type of contact
CL Item
E-Mail (0)
CL Item
Phone (1)
piacrm_response_date
Item
Date of response (clarification)
datetime
piacrm_response_date (VAR_NAMES)
Date of response (clarification) (LABEL)
datetime (DATA_TYPE)
missing_table_3039 (MISSING_LIST_TABLE)
t1.piacontact (STUDY_SEGMENT)
370.0 (VARIABLE_ORDER)
Datum der Antwort (Klärung) (LABEL_DE)
T_PIACONTACT (TABLE_NAME)
t1.piacrm_response_date (UNIQUE_NAME)
TREND (SOURCE)
SHIPTrend-1 (DCE)
TREND|TREND1|PIA|PIAOPD|PIACONTACT (HIERARCHY)