Meeting Title: Sunstone Project Pre-Check-In Prep Date: 2026-05-12 Meeting participants: Robert Tseng, Jess Riegel, Jake Sandler
WEBVTT
1 00:00:22.870 ⇒ 00:00:24.000 Jake Sandler: Hey, Robert.
2 00:00:24.910 ⇒ 00:00:26.860 Robert Tseng: And Jake. Morning, Chas.
3 00:00:27.310 ⇒ 00:00:31.519 Robert Tseng: Oh yeah, no, note-taking is fine. I also have this meeting recorded, if that’s okay.
4 00:00:31.820 ⇒ 00:00:36.970 Jake Sandler: Cool, yeah, for sure. Yeah, it just automatically dropped that comment in now, just so you know.
5 00:00:37.200 ⇒ 00:00:42.580 Robert Tseng: Oh, great. Okay, yeah, I mean, by default, we are recording as well, so… Yeah.
6 00:00:42.830 ⇒ 00:00:47.560 Jake Sandler: Nice how’s it going? How was your weekend?
7 00:00:48.220 ⇒ 00:00:51.410 Robert Tseng: Good. I…
8 00:00:51.660 ⇒ 00:01:03.589 Robert Tseng: Ugh, kind of a blur. Well, actually, not good. By default, I said good. My, my, my wife’s, had a family member pass away, so…
9 00:01:03.910 ⇒ 00:01:05.450 Jake Sandler: I’m sorry to hear that.
10 00:01:05.459 ⇒ 00:01:09.729 Robert Tseng: Yeah, so we are actually gonna go, go to,
11 00:01:09.839 ⇒ 00:01:18.399 Robert Tseng: over their family in Hong Kong, doing funerals, so I’ll be out of country for, like, 10 days, but… I mean, I’ll still be working, I just…
12 00:01:18.739 ⇒ 00:01:23.259 Robert Tseng: yeah, I just need a… like, next… next weekend, I’ll be… I’ll be out for 10 days.
13 00:01:23.740 ⇒ 00:01:25.859 Jake Sandler: That’s tough.
14 00:01:26.330 ⇒ 00:01:29.750 Jake Sandler: Yeah. Sending the best to you guys, and your wife, and her family.
15 00:01:30.000 ⇒ 00:01:31.550 Robert Tseng: Thanks. Yeah.
16 00:01:32.460 ⇒ 00:01:36.449 Robert Tseng: But yeah, I mean, other than that, yeah, just…
17 00:01:36.740 ⇒ 00:01:43.760 Robert Tseng: Things are busy, I feel like, yeah, got a good start, like, past couple days, really got to…
18 00:01:44.660 ⇒ 00:01:56.750 Robert Tseng: soak up all of the… the things that you shared with me on… about Sunstone. So, yeah, and I know that you wanted to schedule this call to do, like, a pre… pre-check-in prep, so wanted to kind of give you a
19 00:01:56.750 ⇒ 00:02:04.779 Robert Tseng: a glimpse of what I’ve… what I’ve put together, and then maybe kind of just kind of brainstorm with you how you… how we… how you think we should, approach, approach that call.
20 00:02:05.120 ⇒ 00:02:09.279 Jake Sandler: Perfect. Yeah, I’d love to see… Yeah, I think that’s great. I just wanted to check in with you, just because…
21 00:02:10.250 ⇒ 00:02:26.089 Jake Sandler: things always move fast with Sunstone, a lot going on, but I think we’re good to go. It’s gonna be a more tactical group, so I think, like, we’ll do some table setting at the outset, you know, maybe I’ll have you, you know, I’ll have you introduce the team, the team can say hi, and then, like, a quick…
22 00:02:26.580 ⇒ 00:02:36.809 Jake Sandler: sort of 3 minutes on your guys’ background, I think just to, like, for this team, just to, like, get a sense for your capabilities and the kind of work you’ve done in the healthcare space. I think it’s great when you talk about
23 00:02:36.990 ⇒ 00:02:46.510 Jake Sandler: the MIDI project, and then the specialty clinic, the Northeast Specialty Clinic, I think that, like, helps people realize, okay, you guys have done versions of this before.
24 00:02:46.740 ⇒ 00:02:50.370 Jake Sandler: And then I think we can just go into…
25 00:02:50.870 ⇒ 00:02:55.110 Jake Sandler: what your, like, open questions are, and getting, like, pretty tactical pretty quickly.
26 00:02:55.540 ⇒ 00:03:03.530 Robert Tseng: Yeah, I saw there’s quite a few stakeholders on that call, so I think it’s less about, like, doing, like, one-on-one interviews, it’s more just kind of
27 00:03:03.650 ⇒ 00:03:07.409 Robert Tseng: Like, kind of giving them the roadmap of what to expect, and then…
28 00:03:07.590 ⇒ 00:03:23.230 Robert Tseng: I mean, I think I’ve seen some of these names pop up in your docs, so then maybe we can figure out, like, who we need to schedule out in the next couple weeks, for… for maybe additional interviews. Does that sound about right?
29 00:03:23.660 ⇒ 00:03:29.410 Jake Sandler: Yeah, absolutely. And so these four… these four people represent, hopefully, there might be a fifth, but, like.
30 00:03:30.220 ⇒ 00:03:47.000 Jake Sandler: the people who know where all of the data is. So, like, they each sort of have a piece where they have the primary knowledge and access to. Yeah. And so, in part, I think when we talk to them today, you could have, like, each person, maybe, like, we can go through and be like, hey, like, ECTA,
31 00:03:47.040 ⇒ 00:04:02.650 Jake Sandler: like, wanting to walk through, like, the systems that you are the owner of, the data that you have, like, primary access to. Celia, like, what do you have access to that no one else does? Kim, Lindsay, so I think that’ll help give you guys a sense of all the systems being used and where it’s stored, and I’m sure there’s going to be some overlap.
32 00:04:02.770 ⇒ 00:04:04.670 Jake Sandler: But it will be helpful…
33 00:04:04.910 ⇒ 00:04:14.370 Jake Sandler: I think, to hear it, and so then you guys can… I’ll give you guys, hopefully, a map of, like, when you run into an issue. Like, okay, that’s probably Lindsey’s thing, we should go talk to her.
34 00:04:15.680 ⇒ 00:04:17.439 Robert Tseng: Sure, okay, that sounds good.
35 00:04:18.029 ⇒ 00:04:26.959 Robert Tseng: And then I think good transition to kind of what I have put together. So, yeah, I think there’s a couple things I want to call out. So…
36 00:04:27.120 ⇒ 00:04:34.159 Robert Tseng: I don’t think we’re gonna get to all of it on the call, but I just wanna… all these… these are the… it’s kind of like the starter… starter pack that we typically put together, so…
37 00:04:34.160 ⇒ 00:04:50.919 Robert Tseng: Kind of on one side, I’m already starting to kind of, like, write out, like, in what I would consider to be, like, the executive-facing memo. I think this is high-level enough, good to kind of send out as a pre-read to people. This is kind of just, like, I’ll continue to update this with our understanding of, like, what’s…
38 00:04:51.010 ⇒ 00:04:55.570 Robert Tseng: Of what we’re observing, and trying to keep people focused on what we’re trying to do.
39 00:04:55.570 ⇒ 00:05:20.510 Robert Tseng: Then there’s kind of a version that’s more directed to you, where, like, kind of on a weekly basis, I’ll share with you updates, things that we’re finding, these are more tactical, and wanting you to kind of help us get unblocked. And then this is… the rest is just kind of, like, stuff that I share for my team as we’re putting together tickets in our system, and then, I mean, I was assuming that on a weekly check-in we would have a deck, so this is really just, like, kind of stuff… guidance for… for… for Greg to…
40 00:05:20.620 ⇒ 00:05:39.590 Robert Tseng: kind of helped me put together a deck. So, just wanted to let you know that there’s, like, four… typically, at least, like, you know what I mean, like, four levels of communication that, like, I… I mean, we can always trim it down if you feel like a lot of this is unnecessary, but, that kind of helps me frame, like, I have… I have something to say to whoever I’m… whoever I’m talking to.
41 00:05:40.120 ⇒ 00:05:52.989 Robert Tseng: And then from a documentation perspective, like, this is kind of just, like, the typical workbook that we put together. So I’ve already kind of, like, started this, like, road mapping. This is just kind of more high level, and we’ll clean it up a bit more.
42 00:05:52.990 ⇒ 00:06:02.239 Robert Tseng: But this is kind of just pulled straight out of our tickets into kind of how we think about the phases. These are, like, open-ended questions. I’ll try to answer them, and I’ve already kind of, like, filled
43 00:06:02.240 ⇒ 00:06:10.189 Robert Tseng: in some of the details that I’ve, like, looked into. But I’d probably, like, assign out some of these to the stakeholders once I understand who
44 00:06:10.210 ⇒ 00:06:12.109 Robert Tseng: Who should be answering what?
45 00:06:12.360 ⇒ 00:06:17.650 Robert Tseng: Yeah, this is really just kind of, once again, a more detailed version of the project roadmap.
46 00:06:17.820 ⇒ 00:06:31.050 Robert Tseng: kind of like a readiness checklist. Yeah, I mean, this is kind of typical, like, when we’re… when we’re cleared with a certain phase, then I want to make sure that you sign off that, like, everything is… is clear from that, so we can move on to the next one.
47 00:06:32.070 ⇒ 00:06:48.080 Robert Tseng: And, yeah, I mean, I’ll share all of this with you, and then kind of just already started to put together some, like, kind of templates for, like, what we need to be working towards. These are… these deliverables are by no means done, they’re just, like, kind of at least something for us to work backwards from. So…
48 00:06:48.080 ⇒ 00:06:59.970 Robert Tseng: Yeah, I think from just, like, a project manager perspective, these are all the things that we kind of have in place. So, yeah, I mean, I guess I’ll, like, once again, I’ll share all this.
49 00:06:59.970 ⇒ 00:07:12.370 Robert Tseng: with you shortly, and yeah, I mean, I’m just kind of curious, from what you’ve observed, from what we put together, what do you think would be helpful to walk through with the team, on the first day?
50 00:07:13.350 ⇒ 00:07:17.000 Jake Sandler: Yeah, this is great. I mean, honestly, I think…
51 00:07:18.260 ⇒ 00:07:19.920 Jake Sandler: Can you go to the SME update?
52 00:07:20.060 ⇒ 00:07:22.279 Jake Sandler: Yeah. I think the exec mem looks great.
53 00:07:25.850 ⇒ 00:07:31.669 Jake Sandler: Keep going down… Yeah, to the second page…
54 00:07:34.970 ⇒ 00:07:36.910 Jake Sandler: And then the… can you go to the domain?
55 00:07:37.910 ⇒ 00:07:47.369 Robert Tseng: Oh, this is really just, like… I… actually, I went in and took screenshots from the videos, and I’m, like, starting to write, like, tactical notes to the team of, like, where I feel like there are…
56 00:07:48.020 ⇒ 00:07:51.829 Robert Tseng: Yeah, so there’s probably a lot of noise for you to look at.
57 00:07:51.830 ⇒ 00:07:56.369 Jake Sandler: Yeah. And then, yeah, if you go back to the spreadsheets, I think, like, I mean…
58 00:07:56.700 ⇒ 00:08:03.860 Jake Sandler: in projects… you’ve run more projects like this than me, so I sort of defer, but, like, with this kind of team that’s gonna be the more tactical…
59 00:08:04.130 ⇒ 00:08:14.759 Jake Sandler: I do think, like, giving some, like, line of sight to sort of how you’re approaching it and how you operate is helpful, because I think it builds trust, like, okay, this team is comprehensive, like, they got a good plan, they have all these processes.
60 00:08:14.970 ⇒ 00:08:18.799 Jake Sandler: We can sort of relax and just answer the questions when they come up.
61 00:08:18.800 ⇒ 00:08:20.849 Robert Tseng: That’s what I want them to feel like, yeah.
62 00:08:20.850 ⇒ 00:08:26.549 Jake Sandler: Yeah, so I think this is all great in terms of building that trust, and so I think I kind of…
63 00:08:28.020 ⇒ 00:08:30.799 Jake Sandler: Defer to you, and maybe you’ll, like.
64 00:08:31.280 ⇒ 00:08:42.560 Jake Sandler: do first half, see how the team reacts, and then go deeper if you think it’s necessary or not. I mean, I don’t know if you, like, kind of do it that way. And then I think getting into some of the questions, like, once we sort of go through some of this.
65 00:08:43.250 ⇒ 00:08:46.840 Jake Sandler: And if there’s, like, key questions in that list you have…
66 00:08:47.190 ⇒ 00:08:56.399 Jake Sandler: Like, and you think we have time, it could be useful to, like, start getting some of your, like, major questions answered from… that, like, folks in the room could help answer.
67 00:08:57.270 ⇒ 00:08:57.810 Robert Tseng: Great.
68 00:08:58.020 ⇒ 00:09:17.250 Robert Tseng: Okay, yeah, I feel like I’m really just gonna do the intro, probably stay on the first couple tabs and make sure this is all kind of, like, cleaned up, and then I’ll probably pick a few questions from each of these sections, just to kind of kick us off, and then, obviously a lot of this could be answered async, so I won’t take most of the time to answer those… to ask those questions.
69 00:09:18.230 ⇒ 00:09:24.899 Robert Tseng: Do you think… do you do pre-reads? Is this helpful to kind of send out? I mean, I can run it by you first, like, I think this would at least, you know, kind of.
70 00:09:24.900 ⇒ 00:09:36.210 Jake Sandler: Yeah, I think, I think you can send it out. You don’t need to run it by me. I think it’s close enough, you know, solid. Will folks definitely read it? Maybe not, but I think it’s, like, good to give them a shot at it, and, like, they can reference it back if they want to.
71 00:09:36.490 ⇒ 00:09:38.030 Robert Tseng: Okay, great.
72 00:09:38.030 ⇒ 00:09:41.409 Jake Sandler: So yeah, you can, like, give them comment… commenter access, and just…
73 00:09:41.410 ⇒ 00:09:41.880 Robert Tseng: Yeah.
74 00:09:41.880 ⇒ 00:09:47.260 Jake Sandler: Maybe say, hey, if there’s anything you see that seems, like, off-base, why don’t you just drop in a comment?
75 00:09:47.690 ⇒ 00:09:48.270 Robert Tseng: Okay.
76 00:09:48.970 ⇒ 00:09:49.690 Robert Tseng: Cool.
77 00:09:50.040 ⇒ 00:09:51.259 Robert Tseng: That sounds good.
78 00:09:52.200 ⇒ 00:09:57.789 Robert Tseng: Yeah, I mean, I… are there, like, any…
79 00:09:58.520 ⇒ 00:10:14.250 Robert Tseng: obviously, I don’t know the relationship. When there’s more folks in the room, sometimes I want to just, like, tread lightly around, like, don’t want to feel like I’m stepping on people’s toes, or, like, accidentally say something to somebody that was actually meant to be somewhere. Like, some of those internal politics, anything that I should be aware of.
80 00:10:14.690 ⇒ 00:10:22.660 Jake Sandler: I don’t think so. I think you’ll probably feel, like, from ECTA, the most amount of…
81 00:10:24.070 ⇒ 00:10:38.810 Jake Sandler: angst, and it’s, I think, mostly because, sort of, she’s been holding a lot of this, and has, like, seen consultants come and go, and has had to, sort of, like, try to do the best based on her ability, and with, sort of, like, an imperfect system.
82 00:10:39.430 ⇒ 00:10:47.699 Jake Sandler: Kim Malley is more junior, I think she’ll probably be more passive, but happy to answer questions. She’s pretty helpful. Lindsay’s…
83 00:10:48.280 ⇒ 00:10:55.340 Jake Sandler: also a bit more junior, like, but will be pretty helpful, and is, like, pretty good at her role. She’s… Lindsey’s, like, an HR…
84 00:10:55.960 ⇒ 00:10:56.660 Robert Tseng: Okay.
85 00:10:56.960 ⇒ 00:11:08.100 Jake Sandler: generalist, but then also, like, sort of moonlights as, like, data help in various ways. So she’s kind of one of those, like, catch-all people in an org that just, like, has a lot of institutional knowledge that’s useful.
86 00:11:08.480 ⇒ 00:11:12.739 Jake Sandler: And then Celia’s been at the company
87 00:11:13.180 ⇒ 00:11:28.659 Jake Sandler: for the longest. So, in terms of, like, if you have a sort of historical questions. She’s not a data person, but she sort of is almost like the general manager of the clinic, is a good way to think about her. And so she has, like, a lot of understanding of
88 00:11:29.920 ⇒ 00:11:43.469 Jake Sandler: how the clinic operates. And so, if there’s questions of, like, how things are done and how that relates to how data is captured between her and Ekta, like, they should be able to give you, like, a lot of clarity. In terms of, like, political sensitivity.
89 00:11:44.480 ⇒ 00:11:56.219 Jake Sandler: I think… I don’t think you’ll… there’s much beyond the, like, okay, is this consultant gonna be helpful, or not? Just sort of the normal skepticism, but I don’t think it’s overly heightened, more than the sort of what we’ve talked about.
90 00:11:56.750 ⇒ 00:11:57.390 Robert Tseng: Okay.
91 00:11:58.510 ⇒ 00:12:00.810 Robert Tseng: Cool, I mean, I can work with that.
92 00:12:01.380 ⇒ 00:12:12.920 Jake Sandler: And yeah, if anything comes up, you know, I’ll be there, and I can, you know, step in, and, you know, now I’m, like, becoming more integrated into the executive team, so it’ll be, like, my role to help.
93 00:12:13.480 ⇒ 00:12:18.730 Jake Sandler: shepherd the conversation if stuff gets sticky, which I don’t really anticipate in this one.
94 00:12:19.100 ⇒ 00:12:19.620 Robert Tseng: Great.
95 00:12:20.990 ⇒ 00:12:22.130 Jake Sandler: Okay.
96 00:12:22.530 ⇒ 00:12:29.729 Jake Sandler: Yeah, so this looks great, I’m excited. I think the other thing I’ll just note, which I’m sure is normal for you guys, is, like.
97 00:12:30.670 ⇒ 00:12:32.920 Jake Sandler: When they see that there’s…
98 00:12:33.370 ⇒ 00:12:48.449 Jake Sandler: skilled people are gonna be helping, they might start dumping all sorts of issues, which isn’t such a bad thing, right, for your knowledge, but, like, we’ll just, you know, partner on, like, sorting through and be like, okay, what’s in scope, what’s out of scope, and, like, what are we parking lot, and how are we gonna… Right.
99 00:12:48.450 ⇒ 00:12:54.189 Jake Sandler: sort of sift through, so I wouldn’t be surprised if, like, more issues arose that I haven’t even have heard of.
100 00:12:54.190 ⇒ 00:12:56.070 Jake Sandler: So… which could be…
101 00:12:56.160 ⇒ 00:13:00.270 Jake Sandler: Good, you know, it’s frankly not such a bad outcome to, like, get an inventory of all the stuff.
102 00:13:00.650 ⇒ 00:13:01.620 Robert Tseng: Yeah, totally.
103 00:13:03.440 ⇒ 00:13:08.270 Jake Sandler: From your standpoint, like, what makes these kinds of kickoffs go well? What would you…
104 00:13:08.390 ⇒ 00:13:13.929 Jake Sandler: Any other, you know, any steers or coaching you’d give to me to help make sure this goes smoothly?
105 00:13:14.420 ⇒ 00:13:25.819 Robert Tseng: Yeah, I mean, I think, first… first impression is so important, just wanted to make it look like that we’re kind of buttoned up and have… have, like, a line of sight to the end. So, I think even just kind of, you know.
106 00:13:25.830 ⇒ 00:13:37.370 Robert Tseng: not just, like, sequencing out, like, what we’re going to do, but even showing them glimpses of, like, what we’re going to get to, so that’s why I kind of put together some of those, like, maybe end… I kind of… the working backwards approach.
107 00:13:37.370 ⇒ 00:13:52.929 Robert Tseng: And then, like, also wanting them to feel like, you know, this is… we’re really driving this project, just want them to be helpful in answering questions, and we’ll kind of put the story together. I mean, sometimes, like, I mean, a lot of the time, that’s the way that we do it, but sometimes people want to keep
108 00:13:53.240 ⇒ 00:14:11.139 Robert Tseng: like, if there is already an existing owner, like, I think that can get a little bit tense if they’re like, oh no, we’re already managing this initiative. But it sounds like this is quite net new, or, like, it’s, like, building from the ground up, so I don’t feel like I anticipate that in this situation. But yeah, I think that
109 00:14:11.620 ⇒ 00:14:27.950 Robert Tseng: That isn’t just our approach on day one. We can adjust if people feel like, you know, we’re too… like, yeah, if this is too rigid for what people want. So, I just tend to prefer to be more heavy-handed with,
110 00:14:28.010 ⇒ 00:14:32.499 Robert Tseng: Kind of process to start, and then, like, we can kind of lay off of it if it’s…
111 00:14:32.830 ⇒ 00:14:35.070 Robert Tseng: If it’s more… I think process is helpful, yeah.
112 00:14:35.070 ⇒ 00:14:46.130 Jake Sandler: I think it would be helpful. I think the thing, as you were talking, what thing came up, like, and you have it in here, we’ve talked about it, just to, like, something that would be important to highlight is that this won’t disrupt
113 00:14:46.370 ⇒ 00:14:47.770 Jake Sandler: the real time…
114 00:14:48.100 ⇒ 00:15:06.590 Jake Sandler: other projects, I think that’ll just, like, I think for Redacta in particular is, like, trying to figure that out. I think if you just give the… give her and the team confidence, this is a parallel thing that shouldn’t disrupt any, like, migration, but long-term could be helpful, without getting into, like.
115 00:15:06.970 ⇒ 00:15:12.699 Jake Sandler: too much of that. I mean, I think this could help us a lot with, you know, figuring out that piece later.
116 00:15:12.920 ⇒ 00:15:18.490 Jake Sandler: I think that’ll be help. That’ll be… good, just, like, reassurance for the team.
117 00:15:19.110 ⇒ 00:15:19.730 Robert Tseng: Okay.
118 00:15:20.530 ⇒ 00:15:21.580 Robert Tseng: I’ll note it.
119 00:15:22.760 ⇒ 00:15:31.570 Jake Sandler: Cool, then I just sent over a couple items, neither of them are mission critical, but it’s just more context for use. Like, I forwarded you an email chain.
120 00:15:31.570 ⇒ 00:15:34.729 Robert Tseng: Yeah, I saw this.
121 00:15:35.250 ⇒ 00:15:41.210 Jake Sandler: And this is… this is, like, a new project that Sunstone’s engaging in, and so I imagine…
122 00:15:41.820 ⇒ 00:15:52.490 Jake Sandler: again, I’m probably speaking out of my, depth, but, like, this would just be, like, a few fields and, like, another table connected to a patient ID, like, it doesn’t seem like it’s…
123 00:15:53.000 ⇒ 00:16:01.029 Jake Sandler: overly complicated, but it’s being tracked and, like, developed sort of in this manual way for now, and this is something we’d want to, like, over time.
124 00:16:01.520 ⇒ 00:16:13.079 Jake Sandler: No, like, it’s like, if we’re choosing this person for a case study, if, like, you hit a checkbox, yes, then we would want to add, like, a couple of these fields connected to their record, is how I’m sort of seeing it.
125 00:16:14.670 ⇒ 00:16:15.310 Robert Tseng: Got it.
126 00:16:15.560 ⇒ 00:16:30.919 Robert Tseng: You had passed me this… I think this was a handoff from Dave previously. I guess this is his first task out of the design. Did he actually build this out, or like, do you… I mean, do we have, like, access… I mean, what infrastructure do we already…
127 00:16:30.990 ⇒ 00:16:45.420 Robert Tseng: I know we have… you haven’t given us access to the tools yet, but I’m talking about, like, is there a Git repo somewhere, or, like, is the data… is… I mean, even… even that Google Drive that you shared with me of, like,
128 00:16:45.900 ⇒ 00:16:55.159 Robert Tseng: I think, like, trial data that just live there? Did it… did it actually, like, land in some sort of, like, source database?
129 00:16:55.910 ⇒ 00:16:59.080 Jake Sandler: Yeah. It is not… yeah, there’s no…
130 00:16:59.730 ⇒ 00:17:08.510 Jake Sandler: Git repo, to my knowledge, there’s no, like, landing zone for the data, so the, like, end state of it is…
131 00:17:09.140 ⇒ 00:17:16.580 Jake Sandler: lives in the systems that you need to generate reports from, or if it’s been submitted to a sponsor, then we have it in some court-assorted version of a PDF.
132 00:17:16.920 ⇒ 00:17:24.140 Jake Sandler: So we’re maybe CSV, but it’s just, like, scattered across different forms and formats and locations.
133 00:17:24.250 ⇒ 00:17:31.739 Jake Sandler: And it’s not, like, as we know, it’s, like, not unified, yeah, so there’s no landing place. So this was, yeah, this was the day they’ve handed off.
134 00:17:33.080 ⇒ 00:17:44.139 Jake Sandler: like, basically, and then I had to, like, let him go at this point, as you know, and so it was like, he was… this was gonna be the first thing we reviewed, but I never even got to the point, because it was, like, impossible to schedule with him, where he, like, walked me through…
135 00:17:44.170 ⇒ 00:17:53.590 Jake Sandler: how he built this and, like, exactly what he was thinking. So I actually don’t know what I was thinking. So you probably understand this much better than I do by looking at it, hopefully.
136 00:17:53.590 ⇒ 00:17:54.060 Robert Tseng: Yeah.
137 00:17:54.060 ⇒ 00:17:56.230 Jake Sandler: Or maybe it’s not useful, which is, you know…
138 00:17:56.450 ⇒ 00:17:58.749 Jake Sandler: Fine. Unfortunate, but would be fine.
139 00:17:59.450 ⇒ 00:18:05.929 Robert Tseng: No, yeah, no, I understand the primitives, like, of kind of, like, how he was thinking backwards from here. Yeah, I mean, I think,
140 00:18:06.170 ⇒ 00:18:24.970 Robert Tseng: typically, I would not do the fact tables first, like, I would just make sure all the dimensions are pretty clear, but, like, yeah, I mean, patients, like, demographic, document media. So this is, like, his approach was he took… he went with, like, a very narrow patient table, and then he wanted to just have other… other tables to, like, kind of join in and enrich.
141 00:18:24.970 ⇒ 00:18:35.389 Robert Tseng: It’s like what you would consider a star schema. I, I frankly think that we could just do one… one flat, like, long… one… one… it’s called a, you know, OBT approach, like, one big flat table.
142 00:18:35.390 ⇒ 00:18:44.769 Robert Tseng: that has, like, patient with all the enrichment. It’s just simpler, it’s just, like, a single place, and then if we need to, like, divide it up more, then we can, because… but until, like, we really know
143 00:18:45.340 ⇒ 00:18:52.370 Robert Tseng: How, like… I mean, based off of the conversation we had with Jim last time, it was like.
144 00:18:52.630 ⇒ 00:18:57.539 Robert Tseng: Yeah, the goal by the end of 8 weeks is to be able to take trial, like.
145 00:18:57.650 ⇒ 00:19:12.529 Robert Tseng: trial data, be able to get that all into a master patient set, and then be able to pass that to, like, to sponsors. So, I mean, I think just for… if that’s, like, the main use case we’re driving towards, I just… I don’t even know if we really need that many
146 00:19:12.710 ⇒ 00:19:15.809 Robert Tseng: tables to start with. So, anyway, I think that’s… that’s kind of my.
147 00:19:15.810 ⇒ 00:19:16.410 Jake Sandler: I mean, I…
148 00:19:16.410 ⇒ 00:19:17.520 Robert Tseng: There’s thoughts on it, yeah.
149 00:19:17.520 ⇒ 00:19:35.210 Jake Sandler: my simple brain, that… I love the idea of that, because, like, I can… then it can be exported easily to something like a CSV, then I can go to the town on, like, just pulling out different views and whatever. So that seems, like, would be great. I think the… I think… I’m curious what you guys… your opinion will be of, like.
150 00:19:36.460 ⇒ 00:19:46.660 Jake Sandler: sponsor 1 versus sponsor 5, if there’s, like, very distinct data fields between them. Like, those are just, like, distinct columns, and… Yeah.
151 00:19:46.660 ⇒ 00:20:01.699 Robert Tseng: That’s kind of where you have, like, fact tables that are kind of more, like, the variations on top of it, typically. So, yeah, I would probably, like, kind of… like, the dimensional tables should stay the same, like, that should, like, never change. That should be the master.
152 00:20:01.700 ⇒ 00:20:12.329 Robert Tseng: table, and then, like, obviously different sponsors will pull out… well, they’re not going to want everything from the master dimension table, and so we would just create variations from there, so…
153 00:20:12.430 ⇒ 00:20:17.070 Robert Tseng: That’s kind of how I would approach it. But, yeah.
154 00:20:17.450 ⇒ 00:20:18.150 Jake Sandler: Cool.
155 00:20:18.710 ⇒ 00:20:21.410 Jake Sandler: Yeah, sounds… sounds reasonable and good to me.
156 00:20:22.240 ⇒ 00:20:22.840 Robert Tseng: Okay.
157 00:20:22.940 ⇒ 00:20:33.379 Robert Tseng: Cool, so I’m gonna send out this pre-read, I’ll just write a message, send it to the… I guess that channel’s just you, us. Do you want me to send it via email, or…
158 00:20:34.420 ⇒ 00:20:36.250 Jake Sandler: Yeah, why don’t you just send it via email?
159 00:20:36.250 ⇒ 00:20:36.770 Robert Tseng: Okay.
160 00:20:37.170 ⇒ 00:20:47.250 Jake Sandler: just be like, hey, you know, Robert here, leader from, you know, leading from Brain 4, is looking forward to meeting with you, etc. Here’s the… some pre-reads, no need to read it, but in case, you know, something like that.
161 00:20:47.590 ⇒ 00:20:51.330 Jake Sandler: Yeah. And then you can just send it to the… whoever’s on the invite.
162 00:20:51.330 ⇒ 00:20:52.399 Robert Tseng: On the invite, yeah.
163 00:20:54.050 ⇒ 00:21:03.599 Jake Sandler: Sounds good. Okay. Well, great. I’m gonna be in a meeting right up to right before, so I’ll just be jumping in, right at 2, I think it is, right? And I’ll see you guys there.
164 00:21:04.130 ⇒ 00:21:05.329 Robert Tseng: Okay, sounds good.
165 00:21:05.330 ⇒ 00:21:05.909 Jake Sandler: Thanks, Robert.
166 00:21:05.910 ⇒ 00:21:07.670 Jess Riegel: Thanks. Bye.