snprcEHRModules/snprc_ehr/resources/queries/study/SndBodyTemperatureSource.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
SELECT
    v.LSID as _key,
    v.SubjectId as participantid,
    v.date,
    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
UNION
SELECT
    v.LSID as _key,
    v.SubjectId as participantid,
    v.date,
    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