snprcEHRModules/snprc_ehr/resources/queries/study/SndVitalsSource.sql at acdff87ecb8519fe5b7ff00da362aae1446fda3f · LabKey/snprcEHRModules · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
SELECT
    v.LSID as _key,
    v.SubjectId as participantid,
    v.date,
    v.HR as heartRate,
    v.RR as respRate,
    v.temp,
    null as taskid,
    null as requestid,
    null as performedby,
    null as description,
    null as remark,
    p.ReferenceId as project,
    v.QcState,
    v.SequenceNum,
    v.ObjectId,
    v.EventDataId,
    v.EventId,
    v.SuperPkgId,
    v.ObjectURI,
    v.Container,
    v.ParentEventDataId,
    v.SortOrder,
    v.USDACode,
    v.LSID,
    e.CreatedBy,
    e.Created,
    e.ModifiedBy,
    e.Modified

FROM SND.Categories.Vitals as v
         INNER JOIN SND.Events as e on v.EventId = e.EventId
         INNER JOIN SND.Projects as p on e.ParentObjectId = p.objectId

UNION
SELECT
    v.LSID as _key,
    v.SubjectId as participantid,
    v.date,
    NULL as heartRate,
    NULL as respRate,
    v.temp,
    null as taskid,
    null as requestid,
    null as performedby,
    null as description,
    null as remark,
    p.ReferenceId as project,
    v.QcState,
    v.SequenceNum,
    v.ObjectId,
    v.EventDataId,
    v.EventId,
    v.SuperPkgId,
    v.ObjectURI,
    v.Container,
    v.ParentEventDataId,
    v.SortOrder,
    v.USDACode,
    v.LSID,
    e.CreatedBy,
    e.Created,
    e.ModifiedBy,
    e.Modified
FROM SND.Categories."Vitals Temperature" as v
         INNER JOIN SND.Events as e on v.EventId = e.EventId
         INNER JOIN SND.Projects as p on e.ParentObjectId = p.objectId