1 |
patient |
P_Data_source
pDataSource
|
Data source marker
|
ordinal
/ choice_radio |
0 = mnds, 1 = b, 2 = bExtra |
2000 |
3000
|
no
|
|
2 |
mndsb34 |
SES_DS_status
sesDsStatus
|
|
integer
|
|
|
|
|
3000
|
no
|
|
3 |
patient |
__P_kp_PatientID
pKpPatientid
|
DB primary key
|
integer
|
1
|
0
|
|
2000 |
3000
|
yes
|
5
|
4 |
mndsb34 |
SNNFU_Import
SNNFU_Import
|
Import marker
|
text
/ text_field |
|
|
|
2007 |
3000
|
no
|
|
5 |
patient |
P_Neo_Dataset
pNeoDataset
|
Describes dataset ("mnds", "asp", "fu1", etc.)
|
text
/ choice_radio |
|
|
|
2000 |
3000
|
no
|
|
6 |
patient |
P_SNNID
pSnnid
|
SNN-ID (leave empty if new dataset!)
|
text
/ text_field |
|
|
|
2000 |
3000
|
yes
|
10
|
7 |
patient |
P_MNDS_type
pMndsType
|
MNDS type
|
ordinal
/ choice_radio |
1
|
4
|
|
2000 |
2016
|
no
|
|
8 |
patient |
P_Informed_consent
pInformedConsent
|
Informed consent given
|
ordinal
/ choice_radio |
1
|
4
|
|
2015 |
3000
|
yes
|
15
|
9 |
patient |
P_Date_of_birth
pDateOfBirth
|
Date of birth
|
date
|
0
|
0
|
|
2000 |
3000
|
yes
|
20
|
10 |
patient |
P_Month_of_birth
pMonthOfBirth
|
Month of birth
|
integer
|
1
|
12
|
|
2000 |
3000
|
yes
|
20
|
11 |
patient |
P_Center_Nr
pCenterNr
|
Preset center nr
|
text
/ text_field |
|
|
|
2000 |
3000
|
yes
|
22
|
12 |
patient |
P_Register
pRegister
|
Register
|
ordinal
/ choice_radio |
1 = mnds, 2 = asp, 3 = mndsb34, 4 = orchid |
2000 |
3000
|
yes
|
22
|
13 |
patient |
P_Center_Nr_anonym
pCenterNrAnonym
|
Encrypted center number
|
integer
|
1
|
15
|
|
2000 |
3000
|
yes
|
23
|
14 |
patient |
P_Outcome_study
pOutcomeStudy
|
Study group selector
|
boolean
| 0 = no, 1 = yes |
2000 |
3000
|
no
|
|
15 |
patient |
P_Year_of_birth
pYearOfBirth
|
Year of birth
|
integer
|
2000
|
2030
|
|
2000 |
3000
|
yes
|
25
|
16 |
patient |
P_MNDS_exclude
pMndsExclude
|
Exclude from overnight evaluation
|
boolean
| 0 = no, 1 = yes |
2000 |
3000
|
yes
|
32
|
17 |
patient |
P_Asp_Exclude
pAspExclude
|
Exclude from evaluation
|
boolean
| 0 = no, 1 = yes |
2011 |
3000
|
no
|
|
18 |
patient |
P_Patient_no
pPatientNo
|
Patient number
|
text
/ text_field |
|
|
|
2000 |
3000
|
yes
|
35
|
19 |
patient |
P_Ahv_Number
pAhvNumber
|
AHV Number (Orchid registry only)
|
regex
/ text_field |
|
|
999.9999.9999.99 |
2019 |
3000
|
no
|
|
20 |
patient |
P_Day_of_admission
pDayOfAdmission
|
Day of admission
|
integer
|
1
|
365
|
999 |
2000 |
3000
|
yes
|
50
|
21 |
patient |
P_Place_of_birth
pPlaceOfBirth
|
Place of birth
|
text
/ text_field |
|
|
|
2000 |
3000
|
yes
|
51
|
22 |
patient |
P_Time_of_birth
pTimeOfBirth
|
Time at birth (only ASP)
|
time
|
0
|
23
|
|
2012 |
3000
|
yes
|
52
|
23 |
patient |
P_Birth_location
pBirthLocation
|
Birth location
|
ordinal
/ choice_radio |
1 = inborn, 2 = outborn |
2001 |
3000
|
yes
|
55
|
24 |
patient |
P_Study
pStudy
|
RCT study coding
|
ordinal
/ choice_radio |
1 = epo, 2 = albino, 3 = copca, 4 = music |
2000 |
3000
|
yes
|
56
|
25 |
patient |
P_FUx_Location
pFuxLocation
|
|
text
/ choice_select |
|
|
|
|
3000
|
no
|
|
26 |
patient |
P_GA_weeks
pGaWeeks
|
Weeks of gestation
|
integer
|
22
|
42
|
|
2000 |
3000
|
yes
|
60
|
27 |
patient |
P_GA_days
pGaDays
|
Days after weeks
|
integer
|
0
|
6
|
|
2000 |
3000
|
yes
|
65
|
28 |
patient |
P_Birth_weight
pBirthWeight
|
Birth weight in g
|
integer
|
100
|
8000
|
|
2000 |
3000
|
yes
|
70
|
29 |
patient |
P_Sex
pSex
|
Sex
|
ordinal
/ choice_radio |
1
|
2
|
9 |
2000 |
3000
|
yes
|
71
|
30 |
patient |
P_Died_in_del
pDiedInDel
|
|
ordinal
/ choice_radio |
|
|
|
|
3000
|
no
|
|
31 |
patient |
P_Number_of_infants
pNumberOfInfants
|
Number of infants in this birth
|
integer
|
1
|
6
|
|
2000 |
3000
|
yes
|
75
|
32 |
patient |
P_Rank
pRank
|
Order of births
|
text
/ text_field |
|
|
|
2000 |
3000
|
yes
|
80
|
33 |
patient |
P_Hospital_ID
pHospitalId
|
Preset hospital ID
|
text
/ choice_select |
|
|
|
2000 |
3000
|
yes
|
81
|
34 |
patient |
P_Identifier_mother
pIdentifierMother
|
ID text/number for mother dataset (not in use)
|
text
/ text_field |
|
|
|
2020 |
3000
|
no
|
|
35 |
patient |
P_FU1_location
pFu1Location
|
Location of follow-up 1
|
text
/ text_field |
|
|
|
2000 |
3000
|
yes
|
85
|
36 |
patient |
P_FU2_location
pFu2Location
|
Location of follow-up 2
|
text
/ text_field |
|
|
|
2000 |
3000
|
yes
|
90
|
37 |
patient |
P_FU5_location
pFu5Location
|
Location of follow-up 5
|
text
/ text_field |
|
|
|
2000 |
3000
|
yes
|
95
|
38 |
patient |
P_FU1_performed
pFu1Performed
|
Follow-up 1 has taken place
|
boolean
| 0 = no, 1 = yes |
2000 |
3000
|
yes
|
100
|
39 |
patient |
P_FU2_performed
pFu2Performed
|
Follow-up 2 has taken place
|
boolean
| 0 = no, 1 = yes |
2000 |
3000
|
yes
|
105
|
40 |
patient |
P_FU5_performed
pFu5Performed
|
Follow-up 5 has taken place
|
boolean
| 0 = no, 1 = yes |
2000 |
3000
|
yes
|
110
|
41 |
patient |
P_SDQ_performed
pSdqPerformed
|
SDQ has taken place
|
boolean
| 0 = no, 1 = yes |
2000 |
3000
|
no
|
|
42 |
patient |
P_FUp_performed
pFupPerformed
|
Parental form filled in
|
boolean
| 0 = no, 1 = yes |
2000 |
3000
|
no
|
|
43 |
patient |
F_FU1_status
pFu1Status
|
Recruitment status
|
text
/ text_field |
|
|
|
2000 |
3000
|
no
|
|
44 |
patient |
F_FU2_status
pFu2Status
|
Recruitment status
|
text
/ text_field |
|
|
|
2000 |
3000
|
no
|
|
45 |
patient |
F_FU5_status
pFu5Status
|
Recruitment status
|
text
/ text_field |
|
|
|
2000 |
3000
|
no
|
|
46 |
patient |
P_Bw_Zscore
pBwZscore
|
Birth weight z-score (Voigt 2006)
|
decimal
|
-6
|
6
|
|
2000 |
3000
|
yes
|
115
|
47 |
patient |
P_SGA
pSga
|
Birth weight < 10th percentile (Voigt 2006)
|
boolean
| 0 = no, 1 = yes |
2000 |
3000
|
yes
|
115
|
48 |
mndsb34 |
SES_Education_mother
sesEducationMother
|
Highest education mother
|
text
/ choice_select |
|
|
unknown |
2000 |
3000
|
no
|
|
49 |
patient |
P_Died
pDied
|
Child died at any time
|
boolean
| 0 = no, 1 = yes |
2000 |
3000
|
yes
|
116
|
50 |
mndsb34 |
SES_Score_mother
sesScoreMother
|
SES Score of mother
|
integer
|
1
|
6
|
9 |
2000 |
3000
|
no
|
|
51 |
mndsb34 |
SES_Occupation_father
sesOccupationFather
|
Current occupation father
|
text
/ text_field |
|
|
unknown |
2000 |
3000
|
no
|
|
52 |
mndsb34 |
SES_Score_father
sesScoreFather
|
SES Score of father
|
integer
|
1
|
6
|
9 |
2000 |
3000
|
no
|
|
53 |
patient |
SES_Score_total
sesScoreTotal
|
Total of all available SES scores
|
integer
|
2
|
12
|
|
2000 |
3000
|
yes
|
139
|
54 |
mndsb34 |
M_Chorioamnionitis
mChorioamnionitis
|
Chorioamnionitis
|
ordinal
/ choice_radio |
0
|
3
|
9 |
2012 |
3000
|
yes
|
150
|
55 |
mndsb34 |
M_MHypertension
mMhypertension
|
Maternal hypertension
|
ordinal
/ choice_radio |
0
|
2
|
9 |
2012 |
3000
|
yes
|
155
|
56 |
mndsb34 |
M_Prenatal_steroids
mPrenatalSteroids
|
Prenatal steroids
|
ordinal
/ choice_radio |
0
|
3
|
1 |
2000 |
3000
|
yes
|
160
|
57 |
mndsb34 |
M_Sectio
mSectio
|
Caesarean section
|
boolean
/ choice_radio |
0 = no, 1 = yes |
2000 |
3000
|
yes
|
225
|
58 |
mndsb34 |
M_Cov_mother
mCovMother
|
Sars-CoV-2 infection of mother
|
ordinal
/ choice_radio |
0 = not tested, 1 = negative, 2 = positive |
2020 |
2024
|
no
|
|
59 |
mndsb34 |
M_Cov_mother_assay
mCovMotherAssay
|
Assay used for Sars-CoV-2 diagnosis of mother
|
ordinal
/ choice_radio |
1 = PCR, 2 = serum, 3 = antigen |
2020 |
2024
|
no
|
|
60 |
mndsb34 |
M_Cov_child
mCovChild
|
Sars-CoV-2 infection of child
|
ordinal
/ choice_radio |
0 = not tested, 1 = negative, 2 = positive |
2020 |
2024
|
no
|
|
61 |
mndsb34 |
M_Cov_child_assay
mCovChildAssay
|
Assay used for Sars-CoV-2 diagnosis of child
|
ordinal
/ choice_radio |
1 = PCR, 2 = serum, 3 = antigen |
2020 |
2024
|
no
|
|
62 |
mndsb34 |
M_Length
mLength
|
Length at birth
|
decimal
|
15
|
70
|
99 |
2017 |
3000
|
yes
|
230
|
63 |
mndsb34 |
M_Head_circ
mHeadCirc
|
Head circumference in cm
|
decimal
|
10
|
50
|
99 |
2000 |
3000
|
yes
|
235
|
64 |
mndsb34 |
M_Temp_admission
mTempAdmission
|
Body temperature at admission
|
decimal
|
30
|
42
|
99 |
2017 |
3000
|
yes
|
240
|
65 |
mndsb34 |
M_Bdefect
mBdefect
|
Congenital malformation
|
ordinal
/ choice_radio |
1 = none or minor, 2 = major |
2000 |
3000
|
yes
|
245
|
66 |
mndsb34 |
M_Bdefect_specific
mBdefectSpecific
|
Specifiy congenital malformation
|
text
/ text_field |
|
|
|
2000 |
3000
|
yes
|
250
|
67 |
mndsb34 |
M_Died_in_del
mDiedInDel
|
Has child died in delivery room
|
boolean
/ choice_radio |
1 = yes, 2 = no |
2000 |
3000
|
yes
|
255
|
68 |
mndsb34 |
B34_Hypoglycemia
b34Hypoglycemia
|
Hypoglycemia
|
boolean
/ choice_radio |
0 = no, 1 = yes |
2018 |
3000
|
yes
|
263
|
69 |
mndsb34 |
B34_Hypoglycemia_low
b34HypoglycemiaLow
|
Hypoglycemia low
|
boolean
/ choice_radio |
0 = no, 1 = yes |
2018 |
3000
|
yes
|
264
|
70 |
mndsb34 |
M_Pneumothorax
mPneumothorax
|
Pneumothorax
|
boolean
/ choice_radio |
1 = absent, 2 = present |
2007 |
3000
|
yes
|
265
|
71 |
mndsb34 |
M_Sepsis
mSepsis
|
Sepsis (incl. Meningitis)
|
ordinal
/ choice_radio |
1 = absent, 2 = culture-negative, 3 = proven |
2000 |
3000
|
yes
|
315
|
72 |
mndsb34 |
M_Sepsis_day_1
mSepsisDay1
|
Day of onset Episode 1
|
integer
|
1
|
730
|
999 |
2000 |
3000
|
yes
|
320
|
73 |
mndsb34 |
M_Sepsis_culture_result_1
mSepsisCultureResult1
|
Culture result Episode 1
|
text
/ text_field |
|
|
unknown |
2000 |
3000
|
yes
|
325
|
74 |
mndsb34 |
M_Surfactant
mSurfactant
|
Surfactant treatment
|
boolean
/ choice_radio |
1 = not given, 2 = given |
2000 |
3000
|
yes
|
369
|
75 |
mndsb34 |
M_Oxy_days
mOxyDays
|
Days of O2
|
integer
|
0
|
365
|
999 |
2009 |
3000
|
yes
|
380
|
76 |
mndsb34 |
M_Vent_days
mVentDays
|
Days of mechanical ventilation
|
integer
|
0
|
365
|
999 |
2000 |
3000
|
yes
|
381
|
77 |
mndsb34 |
M_CPAP_days
mCpapDays
|
Days of CPAP
|
integer
|
0
|
365
|
999 |
2000 |
3000
|
yes
|
382
|
78 |
mndsb34 |
M_HighFlow_days
mHighflowDays
|
Days of High-flow
|
integer
|
0
|
365
|
999 |
2017 |
3000
|
yes
|
383
|
79 |
mndsb34 |
M_Final_diagnosis_US
mFinalDiagnosisUs
|
Final diagnosis cerebral US
|
ordinal
/ choice_radio |
1 = normal, 2 = abnormal, 3 = not done |
2000 |
3000
|
yes
|
485
|
80 |
mndsb34 |
M_Haemorrhage
mHaemorrhage
|
Brain haemorrhage
|
ordinal
/ choice_radio |
0
|
4
|
|
2000 |
3000
|
yes
|
490
|
81 |
mndsb34 |
M_Leucomalacia
mLeucomalacia
|
Leucomalacia
|
ordinal
/ choice_radio |
0 = none, 1 = echogenic, 2 = cystic |
2000 |
3000
|
yes
|
500
|
82 |
mndsb34 |
M_US_other
mUsOther
|
Other US abnormality
|
boolean
/ choice_radio |
0 = no, 1 = yes |
2008 |
3000
|
yes
|
505
|
83 |
mndsb34 |
M_AB_first24h
mABFirst24h
|
Antibiotica in first 24h
|
boolean
/ choice_radio |
0 = no, 1 = yes |
2020 |
3000
|
yes
|
507
|
84 |
mndsb34 |
M_Day_of_death
mDayOfDeath
|
Day of death
|
integer
|
0
|
730
|
999 |
2000 |
3000
|
yes
|
515
|
85 |
mndsb34 |
M_Day_of_discharge
mDayOfDischarge
|
Day of discharge
|
integer
|
1
|
730
|
999 |
2000 |
3000
|
yes
|
545
|
86 |
mndsb34 |
M_Discharge_to
mDischargeTo
|
Discharged home or other hospital
|
ordinal
/ choice_radio |
1 = home, 2 = other hospital, 3 = died |
2000 |
3000
|
yes
|
546
|
87 |
mndsb34 |
M_Discharge_specific
mDischargeSpecific
|
Specify hospital if necessary
|
text
/ text_field |
|
|
|
2000 |
3000
|
yes
|
547
|
88 |
mndsb34 |
M_Home_discharge_day
mHomeDischargeDay
|
Day of discharge home
|
integer
|
1
|
730
|
999 |
2000 |
3000
|
yes
|
580
|
89 |
mndsb34 |
M_Home_weight
mHomeWeight
|
Weight at final discharge in g
|
integer
|
500
|
9000
|
9999 |
2006 |
3000
|
yes
|
585
|
90 |
mndsb34 |
M_Home_length
mHomeLength
|
Length at discharge home
|
decimal
|
15
|
70
|
99 |
2017 |
3000
|
yes
|
590
|
91 |
mndsb34 |
M_Home_head_circ
mHomeHeadCirc
|
Head circumference in cm
|
decimal
|
10
|
50
|
99 |
2006 |
3000
|
yes
|
595
|
92 |
mndsb34 |
M_Home_feeding
mHomeFeeding
|
Enteral feeding at discharge home
|
ordinal
/ choice_radio |
1
|
4
|
9 |
2000 |
2019
|
yes
|
600
|
93 |
mndsb34 |
M_Home_nutrition
mHomeNutrition
|
Predominant feeding at discharge home
|
ordinal
/ choice_radio |
1
|
7
|
9 |
2020 |
3000
|
yes
|
601
|
94 |
mndsb34 |
B34_Discharge_reason
b34DischargeReason
|
Reason for discharge
|
ordinal
/ choice_radio |
1
|
5
|
9 |
2018 |
3000
|
yes
|
605
|
95 |
mndsb34 |
M_Comments
mComments
|
Comment
|
text
/ text_area |
|
|
|
2000 |
3000
|
yes
|
615
|
96 |
patient |
P_DS_duplicate
pDsDuplicate
|
Original kP
|
integer
|
|
|
|
2000 |
3000
|
yes
|
615
|
97 |
mndsb34 |
M_OA_code_sg
mOaCodeSg
|
SG OA (ONLY UNIT 33 ST. GALLEN)
|
text
/ text_field |
|
|
|
2006 |
3000
|
no
|
|
98 |
patient |
P_DS_lockdate
pDsLockdate
|
|
date
|
|
|
|
|
3000
|
no
|
|
99 |
mndsb34 |
B34_AB_first24h
b34ABFirst24h
|
Antibiotica in first 24h
|
boolean
| 0 = no, 1 = yes |
2018 |
2019
|
yes
|
5420
|
100 |
mndsb34 |
B34_Last_Reason_Stay
b34LastReasonStay
|
Last reason stay
|
ordinal
/ choice_radio |
1
|
7
|
9 |
2018 |
3000
|
yes
|
5425
|
101 |
mndsb34 |
B34_Last_Reason_Stay_specific
b34LastReasonStaySpecific
|
|
text
/ text_field |
|
|
unknown |
2018 |
3000
|
yes
|
5430
|
102 |
mndsb34 |
B34_Last_Reason_Stay_day
b34LastReasonStayDay
|
Day of last reason for stay
|
integer
|
1
|
365
|
999 |
2018 |
3000
|
yes
|
5435
|
103 |
mndsb34 |
B34_Home_feeding_tube
b34HomeFeedingTube
|
Home with stomach tube
|
boolean
/ choice_radio |
0 = no, 1 = yes |
2018 |
3000
|
yes
|
5452
|
104 |
mndsb34 |
M_Email
mEmail
|
|
text
/ email |
|
|
|
|
3000
|
no
|
|
105 |
mndsb34 |
M_Error_report
mErrorReport
|
|
text
/ text_area |
|
|
|
|
3000
|
no
|
|
106 |
mndsb34 |
M_Missing_ignore
mMissingIgnore
|
|
ordinal
/ choice_radio |
|
|
|
|
3000
|
no
|
|
107 |
mndsb34 |
M_Errorlist_ignore
mErrorlistIgnore
|
|
integer
/ choice_radio |
|
|
|
|
3000
|
no
|
|