1 |
patient |
dataSource
pDataSource
|
Data source marker
|
ordinal
/ choice_radio |
0 = mnds, 1 = b, 2 = bExtra |
2000 |
3000
|
no
|
|
2 |
patient |
pKpPatientid
pKpPatientid
|
DB primary key
|
integer
|
1
|
0
|
|
2000 |
3000
|
yes
|
5
|
3 |
patient |
pNeoDataset
pNeoDataset
|
Describes dataset ("mnds", "asp", "fu1", etc.)
|
text
/ choice_radio |
|
|
|
2000 |
3000
|
no
|
|
4 |
patient |
pSnnid
pSnnid
|
SNN-ID (leave empty if new dataset!)
|
text
/ text_field |
|
|
|
2000 |
3000
|
yes
|
10
|
5 |
patient |
pMndsType
pMndsType
|
MNDS type
|
ordinal
/ choice_radio |
1
|
4
|
|
2000 |
2016
|
no
|
|
6 |
patient |
pInformedConsent
pInformedConsent
|
Informed consent given
|
ordinal
/ choice_radio |
1
|
4
|
|
2015 |
3000
|
yes
|
15
|
7 |
patient |
pDateOfBirth
pDateOfBirth
|
Date of birth
|
date
|
0
|
0
|
|
2000 |
3000
|
yes
|
20
|
8 |
patient |
month
pMonthOfBirth
|
Month of birth
|
integer
|
1
|
12
|
|
2000 |
3000
|
yes
|
20
|
9 |
patient |
center
pCenterNr
|
Preset center nr
|
text
/ text_field |
|
|
|
2000 |
3000
|
yes
|
22
|
10 |
patient |
pRegister
pRegister
|
Register
|
ordinal
/ choice_radio |
1 = mnds, 2 = asp, 3 = mndsb34, 4 = orchid |
2000 |
3000
|
yes
|
22
|
11 |
patient |
pCenterNrAnonym
pCenterNrAnonym
|
Encrypted center number
|
integer
|
1
|
15
|
|
2000 |
3000
|
yes
|
23
|
12 |
patient |
pOutcomeStudy
pOutcomeStudy
|
Study group selector
|
boolean
| 0 = no, 1 = yes |
2000 |
3000
|
no
|
|
13 |
patient |
year
pYearOfBirth
|
Year of birth
|
integer
|
2000
|
2030
|
|
2000 |
3000
|
yes
|
25
|
14 |
patient |
pMndsExclude
pMndsExclude
|
Exclude from overnight evaluation
|
boolean
| 0 = no, 1 = yes |
2000 |
3000
|
yes
|
32
|
15 |
patient |
pAspExclude
pAspExclude
|
Exclude from evaluation
|
boolean
| 0 = no, 1 = yes |
2011 |
3000
|
no
|
|
16 |
patient |
pPatientNo
pPatientNo
|
Patient number
|
text
/ text_field |
|
|
|
2000 |
3000
|
yes
|
35
|
17 |
patient |
pAhvNumber
pAhvNumber
|
AHV Number (Orchid registry only)
|
regex
/ text_field |
|
|
999.9999.9999.99 |
2019 |
3000
|
no
|
|
18 |
patient |
pDayOfAdmission
pDayOfAdmission
|
Day of admission
|
integer
|
1
|
365
|
999 |
2000 |
3000
|
yes
|
50
|
19 |
patient |
pPlaceOfBirth
pPlaceOfBirth
|
Place of birth
|
text
/ text_field |
|
|
|
2000 |
3000
|
yes
|
51
|
20 |
patient |
pTimeOfBirth
pTimeOfBirth
|
Time at birth (only ASP)
|
time
|
0
|
23
|
|
2012 |
3000
|
yes
|
52
|
21 |
patient |
birthLocation
pBirthLocation
|
Birth location
|
ordinal
/ choice_radio |
1 = inborn, 2 = outborn |
2001 |
3000
|
yes
|
55
|
22 |
patient |
pStudy
pStudy
|
RCT study coding
|
ordinal
/ choice_radio |
1 = epo, 2 = albino, 3 = copca, 4 = music |
2000 |
3000
|
yes
|
56
|
23 |
patient |
pFuxLocation
pFuxLocation
|
|
text
/ choice_select |
|
|
|
|
3000
|
no
|
|
24 |
patient |
gaW
pGaWeeks
|
Weeks of gestation
|
integer
|
22
|
42
|
|
2000 |
3000
|
yes
|
60
|
25 |
patient |
gaD
pGaDays
|
Days after weeks
|
integer
|
0
|
6
|
|
2000 |
3000
|
yes
|
65
|
26 |
patient |
bw
pBirthWeight
|
Birth weight in g
|
integer
|
100
|
8000
|
|
2000 |
3000
|
yes
|
70
|
27 |
patient |
sex
pSex
|
Sex
|
ordinal
/ choice_radio |
1
|
2
|
9 |
2000 |
3000
|
yes
|
71
|
28 |
patient |
pDiedInDel
pDiedInDel
|
|
ordinal
/ choice_radio |
|
|
|
|
3000
|
no
|
|
29 |
patient |
numberInfants
pNumberOfInfants
|
Number of infants in this birth
|
integer
|
1
|
6
|
|
2000 |
3000
|
yes
|
75
|
30 |
patient |
pRank
pRank
|
Order of births
|
text
/ text_field |
|
|
|
2000 |
3000
|
yes
|
80
|
31 |
patient |
pHospitalId
pHospitalId
|
Preset hospital ID
|
text
/ choice_select |
|
|
|
2000 |
3000
|
yes
|
81
|
32 |
patient |
pIdentifierMother
pIdentifierMother
|
ID text/number for mother dataset (not in use)
|
text
/ text_field |
|
|
|
2020 |
3000
|
no
|
|
33 |
patient |
fu1loc
pFu1Location
|
Location of follow-up 1
|
text
/ text_field |
|
|
|
2000 |
3000
|
yes
|
85
|
34 |
patient |
fu2loc
pFu2Location
|
Location of follow-up 2
|
text
/ text_field |
|
|
|
2000 |
3000
|
yes
|
90
|
35 |
patient |
fu5loc
pFu5Location
|
Location of follow-up 5
|
text
/ text_field |
|
|
|
2000 |
3000
|
yes
|
95
|
36 |
patient |
fu1p
pFu1Performed
|
Follow-up 1 has taken place
|
boolean
| 0 = no, 1 = yes |
2000 |
3000
|
yes
|
100
|
37 |
patient |
fu2p
pFu2Performed
|
Follow-up 2 has taken place
|
boolean
| 0 = no, 1 = yes |
2000 |
3000
|
yes
|
105
|
38 |
patient |
pSdqPerformed
pSdqPerformed
|
SDQ has taken place
|
boolean
| 0 = no, 1 = yes |
2000 |
3000
|
no
|
|
39 |
patient |
fu5p
pFu5Performed
|
Follow-up 5 has taken place
|
boolean
| 0 = no, 1 = yes |
2000 |
3000
|
yes
|
110
|
40 |
patient |
pFupPerformed
pFupPerformed
|
Parental form filled in
|
boolean
| 0 = no, 1 = yes |
2000 |
3000
|
no
|
|
41 |
patient |
pFu1Status
pFu1Status
|
Recruitment status
|
text
/ text_field |
|
|
|
2000 |
3000
|
no
|
|
42 |
patient |
pFu2Status
pFu2Status
|
Recruitment status
|
text
/ text_field |
|
|
|
2000 |
3000
|
no
|
|
43 |
patient |
pFu5Status
pFu5Status
|
Recruitment status
|
text
/ text_field |
|
|
|
2000 |
3000
|
no
|
|
44 |
patient |
sga
pSga
|
Birth weight < 10th percentile (Voigt 2006)
|
boolean
| 0 = no, 1 = yes |
2000 |
3000
|
yes
|
115
|
45 |
patient |
bwz
pBwZscore
|
Birth weight z-score (Voigt 2006)
|
decimal
|
-6
|
6
|
|
2000 |
3000
|
yes
|
115
|
46 |
patient |
died
pDied
|
Child died at any time
|
boolean
| 0 = no, 1 = yes |
2000 |
3000
|
yes
|
116
|
47 |
patient |
ses
sesScoreTotal
|
Total of all available SES scores
|
integer
|
2
|
12
|
|
2000 |
3000
|
yes
|
139
|
48 |
patient |
duplicate
pDsDuplicate
|
Original kP
|
integer
|
|
|
|
2000 |
3000
|
yes
|
615
|
49 |
patient |
pDsLockdate
pDsLockdate
|
|
date
|
|
|
|
|
3000
|
no
|
|
50 |
sdq |
sdqKpId
sdqKpId
|
|
integer
|
0
|
0
|
|
|
3000
|
no
|
|
51 |
sdq |
sdqOwner
sdqOwner
|
|
text
/ text_field |
|
|
|
|
3000
|
no
|
|
52 |
sdq |
sdq1Considerate
sdq1Considerate
|
|
integer
/ choice_radio |
0
|
2
|
9 |
|
3000
|
yes
|
5210
|
53 |
sdq |
sdq2Restless
sdq2Restless
|
|
integer
/ choice_radio |
0
|
2
|
9 |
|
3000
|
yes
|
5215
|
54 |
sdq |
sdq3Sickness
sdq3Sickness
|
|
integer
/ choice_radio |
0
|
2
|
9 |
|
3000
|
yes
|
5220
|
55 |
sdq |
sdq4Shares
sdq4Shares
|
|
integer
/ choice_radio |
0
|
2
|
9 |
|
3000
|
yes
|
5225
|
56 |
sdq |
sdq5Tantrums
sdq5Tantrums
|
|
integer
/ choice_radio |
0
|
2
|
9 |
|
3000
|
yes
|
5230
|
57 |
sdq |
sdq6Solitary
sdq6Solitary
|
|
integer
/ choice_radio |
0
|
2
|
9 |
|
3000
|
yes
|
5235
|
58 |
sdq |
sdq7Obedient
sdq7Obedient
|
|
integer
/ choice_radio |
0
|
2
|
9 |
|
3000
|
yes
|
5240
|
59 |
sdq |
sdq8Worries
sdq8Worries
|
|
integer
/ choice_radio |
0
|
2
|
9 |
|
3000
|
yes
|
5245
|
60 |
sdq |
sdq9Helpful
sdq9Helpful
|
|
decimal
/ choice_radio |
0
|
2
|
9 |
|
3000
|
yes
|
5250
|
61 |
sdq |
sdq10Fidgeting
sdq10Fidgeting
|
|
integer
/ choice_radio |
0
|
2
|
9 |
|
3000
|
yes
|
5255
|
62 |
sdq |
sdq11Friend
sdq11Friend
|
|
integer
/ choice_radio |
0
|
2
|
9 |
|
3000
|
yes
|
5260
|
63 |
sdq |
sdq12Fights
sdq12Fights
|
|
integer
/ choice_radio |
0
|
2
|
9 |
|
3000
|
yes
|
5265
|
64 |
sdq |
sdq13Unhappy
sdq13Unhappy
|
|
integer
/ choice_radio |
0
|
2
|
9 |
|
3000
|
yes
|
5270
|
65 |
sdq |
sdq14Liked
sdq14Liked
|
|
integer
/ choice_radio |
0
|
2
|
9 |
|
3000
|
yes
|
5275
|
66 |
sdq |
sdq15Distracted
sdq15Distracted
|
|
integer
/ choice_radio |
0
|
2
|
9 |
|
3000
|
yes
|
5280
|
67 |
sdq |
sdq16Nervous
sdq16Nervous
|
|
integer
/ choice_radio |
0
|
2
|
9 |
|
3000
|
yes
|
5285
|
68 |
sdq |
sdq17Kind
sdq17Kind
|
|
integer
/ choice_radio |
0
|
2
|
9 |
|
3000
|
yes
|
5290
|
69 |
sdq |
sdq18Lies
sdq18Lies
|
|
integer
/ choice_radio |
0
|
2
|
9 |
|
3000
|
yes
|
5295
|
70 |
sdq |
sdq19Bullied
sdq19Bullied
|
|
integer
/ choice_radio |
0
|
2
|
9 |
|
3000
|
yes
|
5300
|
71 |
sdq |
sdq20Volunteers
sdq20Volunteers
|
|
integer
/ choice_radio |
0
|
2
|
9 |
|
3000
|
yes
|
5305
|
72 |
sdq |
sdq21Thinks
sdq21Thinks
|
|
integer
/ choice_radio |
0
|
2
|
9 |
|
3000
|
yes
|
5310
|
73 |
sdq |
sdq22Steals
sdq22Steals
|
|
integer
/ choice_radio |
0
|
2
|
9 |
|
3000
|
yes
|
5315
|
74 |
sdq |
sdq23Adults
sdq23Adults
|
|
integer
/ choice_radio |
0
|
2
|
9 |
|
3000
|
yes
|
5320
|
75 |
sdq |
sdq24Fears
sdq24Fears
|
|
integer
/ choice_radio |
0
|
2
|
9 |
|
3000
|
yes
|
5325
|
76 |
sdq |
sdq25Attention
sdq25Attention
|
|
integer
/ choice_radio |
0
|
2
|
9 |
|
3000
|
yes
|
5330
|
77 |
sdq |
sdqDate
sdqDate
|
|
date
|
0
|
2
|
9 |
|
3000
|
yes
|
5335
|
78 |
sdq |
sdqAge
sdqAge
|
Corrected age at SDQ
|
decimal
|
0
|
80
|
|
|
3000
|
yes
|
5336
|
79 |
sdq |
sdqCompletedBy
sdqCompletedBy
|
|
integer
/ choice_radio |
0
|
2
|
|
|
3000
|
yes
|
5340
|
80 |
sdq |
sdqCompletedBySpecific
sdqCompletedBySpecific
|
|
text
/ text_field |
|
|
|
|
3000
|
yes
|
5341
|
81 |
sdq |
sdqCompletedBy
sdqTotalScore
|
SDQ Total scale
|
integer
|
0
|
10
|
|
|
3000
|
yes
|
5341
|
82 |
sdq |
sdqCompletedBy
sdqProsocialBehaviourScale
|
SDQ Prosocial behavior scale
|
integer
|
0
|
10
|
|
|
3000
|
yes
|
5341
|
83 |
sdq |
sdqCompletedBy
sdqEmotionalSymptomsScale
|
SDQ Emotional symptoms scale
|
integer
|
0
|
10
|
|
|
3000
|
yes
|
5341
|
84 |
sdq |
sdqCompletedBy
sdqConductProblemsScale
|
SDQ Conduct problems scale
|
integer
|
0
|
10
|
|
|
3000
|
yes
|
5341
|
85 |
sdq |
sdqCompletedBy
sdqHyperactivityScale
|
SDQ Hyperactivity scale
|
integer
|
0
|
10
|
|
|
3000
|
yes
|
5341
|
86 |
sdq |
sdqCompletedBy
sdqPeerProblemsScale
|
SDQ Peer problems scale
|
integer
|
0
|
10
|
|
|
3000
|
yes
|
5341
|
87 |
sdq |
sdqDsStatus
sdqDsStatus
|
|
decimal
|
0
|
0
|
|
|
3000
|
no
|
|
88 |
sdq |
sdqErrors
sdqErrors
|
|
integer
|
0
|
0
|
|
|
3000
|
no
|
|
89 |
sdq |
sdqErrorReport
sdqErrorReport
|
|
text
/ text_field |
|
|
|
|
3000
|
no
|
|
90 |
sdq |
sdqErrorlistIgnore
sdqErrorlistIgnore
|
|
decimal
|
0
|
0
|
|
|
3000
|
no
|
|
91 |
sdq |
sdqDsGenerated
sdqDsGenerated
|
|
date
|
0
|
0
|
|
|
3000
|
no
|
|
92 |
sdq |
sdqLastChange
sdqLastChange
|
|
date
|
0
|
0
|
|
|
3000
|
no
|
|
93 |
sdq |
sdqId
sdqId
|
|
text
/ text_field |
|
|
|
|
3000
|
no
|
|
94 |
sdq |
sdqComments
sdqComments
|
|
text
/ text_area |
|
|
|
|
3000
|
yes
|
5385
|
95 |
sdq |
sdqEmail
sdqEmail
|
|
text
/ text_field |
|
|
|
|
3000
|
yes
|
5390
|
96 |
sdq |
sdqDsLockdate
sdqDsLockdate
|
|
date
|
0
|
0
|
|
|
3000
|
no
|
|
97 |
sdq |
sdqKfPatientid
sdqKfPatientid
|
|
integer
|
0
|
0
|
|
|
3000
|
no
|
|