Meeting Title: ABC Database Update and Issues Discussion Date: 2025-12-17 Meeting participants: Amber Lin, Mustafa Raja
WEBVTT
1 00:05:06.710 ⇒ 00:05:07.940 Mustafa Raja: Oh, sorry.
2 00:05:09.900 ⇒ 00:05:10.870 Amber Lin: Hi there!
3 00:05:11.620 ⇒ 00:05:14.280 Mustafa Raja: Hey, how are you? I’m sorry for coming late.
4 00:05:14.420 ⇒ 00:05:20.420 Amber Lin: No, I think you… I knew you guys were busy and stressed.
5 00:05:20.820 ⇒ 00:05:28.160 Amber Lin: So, understandable. I just want to be able to send out an update and know, what you guys are doing.
6 00:05:29.030 ⇒ 00:05:35.570 Mustafa Raja: Okay, yeah, let me, let me share what I have so far.
7 00:05:36.880 ⇒ 00:05:38.610 Mustafa Raja: So I can share my screen…
8 00:05:46.360 ⇒ 00:05:47.370 Mustafa Raja: Okay.
9 00:05:47.520 ⇒ 00:05:52.129 Mustafa Raja: Okay, so, so far, most of it, what is… what it looks like is,
10 00:05:52.500 ⇒ 00:05:55.500 Mustafa Raja: Some outdated data that we have in…
11 00:05:57.320 ⇒ 00:05:59.830 Mustafa Raja: In database, and then some of it…
12 00:06:00.140 ⇒ 00:06:06.090 Mustafa Raja: It’s unable to properly reference some of the services.
13 00:06:07.720 ⇒ 00:06:20.959 Mustafa Raja: And then there’s this sales… sales lead thing, but we have only 3 roles in the database, that is crew, technician, and inspector. Would you have any context on this sales lead?
14 00:06:21.430 ⇒ 00:06:23.040 Amber Lin: Wha- can you show me a question?
15 00:06:23.040 ⇒ 00:06:25.570 Mustafa Raja: Yeah, yeah, I can. Let me…
16 00:06:25.940 ⇒ 00:06:35.379 Mustafa Raja: Search it up, sales lead, yeah. Yeah, so they say, if I have a sales, commercial sales lead in this, who should I…
17 00:06:36.100 ⇒ 00:06:44.760 Amber Lin: Actually, here, this is a good opportunity, can you start a comment? So, when they say a lead, they just mean a potential customer.
18 00:06:45.170 ⇒ 00:06:56.390 Amber Lin: So there’s a… so what they’re asking is, hey, I have a potential commercial customer in San Marcos. Who can I put it on for…
19 00:06:56.510 ⇒ 00:07:01.790 Amber Lin: like, sales. Sales meaning an inspector, so that we can give them an estimate.
20 00:07:02.380 ⇒ 00:07:03.669 Mustafa Raja: Okay, so the solutions major…
21 00:07:03.670 ⇒ 00:07:06.350 Amber Lin: It says, like, I have a… I have a customer.
22 00:07:06.350 ⇒ 00:07:09.010 Mustafa Raja: Okay, so we just need to look for inspectors, then.
23 00:07:09.010 ⇒ 00:07:10.100 Amber Lin: Yeah.
24 00:07:11.560 ⇒ 00:07:12.400 Mustafa Raja: Okay.
25 00:07:13.580 ⇒ 00:07:19.249 Mustafa Raja: Okay, I’ll, I’ll look into that in that context, and see if it does its job or not.
26 00:07:20.680 ⇒ 00:07:23.230 Mustafa Raja: And then apart from that.
27 00:07:25.230 ⇒ 00:07:30.169 Mustafa Raja: Yeah, so for HVAC in Austin, we just have no assignments.
28 00:07:31.290 ⇒ 00:07:36.349 Amber Lin: This is for tech? Oh, is this for inspectors?
29 00:07:37.990 ⇒ 00:07:42.489 Mustafa Raja: Yeah, this is in this table, yeah, this assignments table.
30 00:07:45.500 ⇒ 00:07:51.090 Mustafa Raja: we just don’t have any person assigned, for HVAC in Austin, you know?
31 00:07:52.110 ⇒ 00:07:56.400 Amber Lin: Oh, can you check our service areas?
32 00:07:56.560 ⇒ 00:07:58.900 Amber Lin: Do we service that?
33 00:07:59.280 ⇒ 00:08:01.190 Amber Lin: I think we do.
34 00:08:03.800 ⇒ 00:08:06.419 Amber Lin: So, let’s say Austin…
35 00:08:07.030 ⇒ 00:08:16.550 Mustafa Raja: Well, we can do that. Let me actually do something… Branch would be Austin…
36 00:08:19.060 ⇒ 00:08:22.069 Mustafa Raja: London is from 1… Okay.
37 00:08:23.910 ⇒ 00:08:24.510 Mustafa Raja: Dang.
38 00:08:24.820 ⇒ 00:08:25.680 Mustafa Raja: Yikes.
39 00:08:25.680 ⇒ 00:08:27.430 Amber Lin: Maybe HVAC?
40 00:08:28.610 ⇒ 00:08:35.330 Mustafa Raja: And then… Education… It shouldn’t be less than 130.
41 00:08:40.909 ⇒ 00:08:44.399 Mustafa Raja: Okay, and then service should be HVAC.
42 00:08:44.600 ⇒ 00:08:45.320 Amber Lin: Yeah.
43 00:08:46.830 ⇒ 00:08:50.840 Mustafa Raja: So there’s… benchmark…
44 00:08:54.660 ⇒ 00:08:56.500 Amber Lin: Okay, it looks like… oh.
45 00:08:56.500 ⇒ 00:08:59.020 Mustafa Raja: We do have some yes and some nos.
46 00:08:59.020 ⇒ 00:08:59.800 Amber Lin: Okay.
47 00:09:00.350 ⇒ 00:09:01.270 Amber Lin: So…
48 00:09:01.270 ⇒ 00:09:04.850 Mustafa Raja: I don’t have anyone in assignments table, is the…
49 00:09:04.850 ⇒ 00:09:07.989 Amber Lin: Do we have any mechanical inspectors?
50 00:09:09.540 ⇒ 00:09:11.639 Mustafa Raja: Mechanical inspectors.
51 00:09:13.100 ⇒ 00:09:16.369 Mustafa Raja: I mean… We do have inspectors.
52 00:09:21.610 ⇒ 00:09:33.479 Mustafa Raja: Wait, let me say this… And then let me also see what the service would be. 52 and 53.
53 00:09:34.420 ⇒ 00:09:44.390 Mustafa Raja: So, if I were to go… In assignments… 152…
54 00:09:46.810 ⇒ 00:09:55.549 Mustafa Raja: Yeah, you see, so for this service, I’m, so for… so in assignments, what I am filtering on is the service ID is HVAC, right?
55 00:09:55.730 ⇒ 00:09:59.030 Amber Lin: We know that from here, it’s residential HVAC.
56 00:09:59.110 ⇒ 00:10:10.720 Mustafa Raja: And then, we, we just saw that from location ID 1236, It’s all… it’s all awesome.
57 00:10:11.950 ⇒ 00:10:12.899 Amber Lin: Can I…
58 00:10:12.900 ⇒ 00:10:13.370 Mustafa Raja: Thanks for having a.
59 00:10:13.370 ⇒ 00:10:23.479 Amber Lin: We, like, what we have for mechanical, I’m thinking, did we ever actually label them as HVAC, or we just said they were mechanical?
60 00:10:24.790 ⇒ 00:10:30.599 Mustafa Raja: I can try that. How would I be looking into that over here, though?
61 00:10:35.900 ⇒ 00:10:41.589 Mustafa Raja: Because, in the roles, it’s just, technicians, and then inspectors.
62 00:10:42.860 ⇒ 00:10:43.570 Amber Lin: Do they have.
63 00:10:46.060 ⇒ 00:10:50.820 Mustafa Raja: Let me see if these people do not have… let me see, let me see… departments…
64 00:10:52.730 ⇒ 00:10:55.420 Mustafa Raja: Okay, I do see departments.
65 00:10:57.030 ⇒ 00:11:01.659 Mustafa Raja: But then I would… I would need a view… Better view for this.
66 00:11:06.270 ⇒ 00:11:09.570 Amber Lin: I’m asking Andy, who are the inspectors in mechanical.
67 00:11:09.840 ⇒ 00:11:11.819 Amber Lin: Let’s see how it responds.
68 00:11:16.570 ⇒ 00:11:21.739 Amber Lin: Well, what’s the correct answer to that question, by the way?
69 00:11:22.460 ⇒ 00:11:24.369 Mustafa Raja: So, DC…
70 00:11:28.830 ⇒ 00:11:32.239 Mustafa Raja: Yeah, they just say that it’s not giving anything for HVAC.
71 00:11:34.830 ⇒ 00:11:45.360 Amber Lin: Oh, so we will need to look into the inspector sheet, I believe? Yeah, I have, like, right here, I have the mechanical inspectors, that’s what Andy returned, but…
72 00:11:45.570 ⇒ 00:11:51.920 Amber Lin: I really want to know how we labeled things in the database.
73 00:11:52.130 ⇒ 00:11:52.930 Amber Lin: Like, do we…
74 00:11:52.930 ⇒ 00:11:55.210 Mustafa Raja: So, Andy did return that just now.
75 00:11:57.210 ⇒ 00:11:59.950 Mustafa Raja: Those are the HVAC ones?
76 00:12:00.430 ⇒ 00:12:05.959 Amber Lin: No, no, just general mechanical. I don’t even know if we ever labeled it.
77 00:12:07.350 ⇒ 00:12:11.900 Mustafa Raja: Okay, it could just be that, because, there’s a lot of data…
78 00:12:12.330 ⇒ 00:12:14.920 Mustafa Raja: That’s just not there, you know?
79 00:12:16.400 ⇒ 00:12:18.970 Mustafa Raja: Yeah.
80 00:12:20.760 ⇒ 00:12:28.740 Mustafa Raja: So this is the, update, generally. One or two of these were… You know,
81 00:12:29.390 ⇒ 00:12:30.309 Mustafa Raja: What’s it called?
82 00:12:30.310 ⇒ 00:12:31.099 Amber Lin: Yeah, let me…
83 00:12:31.100 ⇒ 00:12:33.620 Mustafa Raja: Central doc, and that is just not updated.
84 00:12:34.040 ⇒ 00:12:46.079 Amber Lin: Yeah, we have a lot of incomplete data issues we have, especially on the zip codes, because it’s, like, they never… we didn’t get all of it all at once, so now we’re facing a lot of issues of…
85 00:12:46.140 ⇒ 00:12:55.090 Amber Lin: Oh, this isn’t there, that isn’t there. I thought we added this, we… I don’t think we added that one. So, trying to see…
86 00:13:01.370 ⇒ 00:13:06.410 Amber Lin: Mechanical… Alright.
87 00:13:23.030 ⇒ 00:13:26.999 Amber Lin: Did we ever even add mechanical inspectors?
88 00:13:29.580 ⇒ 00:13:31.960 Mustafa Raja: Yeah, I wouldn’t have context on that, though.
89 00:13:32.330 ⇒ 00:13:36.619 Amber Lin: Yeah, I understand. I’m just trying to figure out if we need to add it.
90 00:13:36.620 ⇒ 00:13:37.560 Mustafa Raja: or not.
91 00:13:37.870 ⇒ 00:13:42.109 Mustafa Raja: Yeah, I think… oh, so all of the mechanical ones, right? So, yeah.
92 00:13:42.110 ⇒ 00:13:47.780 Amber Lin: Yeah, like, we have some, but it looks so incomplete, because Annie only gave me…
93 00:13:47.880 ⇒ 00:13:52.350 Amber Lin: Very brief responses based on who is…
94 00:13:53.380 ⇒ 00:14:02.340 Amber Lin: like, who is actually there, so let me check HVAC…
95 00:14:24.020 ⇒ 00:14:31.850 Amber Lin: Okay, we have dispatch, CSRs… Seals…
96 00:14:36.440 ⇒ 00:14:38.030 Amber Lin: Yeah, loud.
97 00:14:43.370 ⇒ 00:14:44.700 Amber Lin: Cool.
98 00:14:44.940 ⇒ 00:14:55.159 Amber Lin: Since that’s the case, I think the key issue we want to confirm now is the completeness of the database.
99 00:14:55.310 ⇒ 00:15:02.029 Amber Lin: of… do we actually have inspectors and technicians, right? I think we have most.
100 00:15:02.030 ⇒ 00:15:05.109 Mustafa Raja: Yeah, that is one point, and the other one is.
101 00:15:05.550 ⇒ 00:15:22.500 Mustafa Raja: that, yeah, we need to, you know, let, actually, the database and Andy, both. Both of them know that the sales lead is, is just, we need to return the inspector, and then, we do have issues when Andy,
102 00:15:22.640 ⇒ 00:15:31.569 Mustafa Raja: not actually handy, but the DB tool, is not able to, correctly refer to the services.
103 00:15:31.670 ⇒ 00:15:49.870 Mustafa Raja: For example, sometimes when we need commercial pest, it will just do a fuzzy match on commercial, and everything that is, you know, related with commercial services would come up, and not just the pest ones.
104 00:15:50.080 ⇒ 00:15:56.169 Mustafa Raja: So this is just the… just the nitty-gritty that we need to look into.
105 00:15:57.030 ⇒ 00:15:57.960 Amber Lin: I see.
106 00:15:58.520 ⇒ 00:16:01.220 Mustafa Raja: Overall, the structure looks pretty good.
107 00:16:01.820 ⇒ 00:16:03.920 Mustafa Raja: Just some improvements.
108 00:16:04.410 ⇒ 00:16:05.289 Mustafa Raja: In it.
109 00:16:06.110 ⇒ 00:16:07.810 Mustafa Raja: I’ll do a… I’ll do a…
110 00:16:07.810 ⇒ 00:16:16.760 Amber Lin: by pretty good. Are we close… what area are we better on right now, compared to, say, when we started today or started yesterday?
111 00:16:19.410 ⇒ 00:16:22.220 Mustafa Raja: Pretty good, as in,
112 00:16:23.700 ⇒ 00:16:35.970 Mustafa Raja: As in, the majority of the requests, you would see is, you know, no assignments, no assignments, and stuff like that needs to be updated.
113 00:16:36.170 ⇒ 00:16:37.550 Mustafa Raja: And stuff like that.
114 00:16:37.960 ⇒ 00:16:48.679 Mustafa Raja: The thing that… the other thing apart from that that bothers it much is it’s very rare, I think I only saw 2 wrong queries ever.
115 00:16:48.930 ⇒ 00:16:51.900 Mustafa Raja: Okay. And the other thing, apart from that is…
116 00:16:54.320 ⇒ 00:17:06.279 Amber Lin: Okay, so would you say that the main thing is that we’re actually missing a lot of the assignments, that our AI tool is okay, but we’re missing a lot of things?
117 00:17:07.910 ⇒ 00:17:13.779 Mustafa Raja: We are missing a lot of things, and we need better way to, you know,
118 00:17:14.970 ⇒ 00:17:18.310 Mustafa Raja: Fetch the services. The names of the services.
119 00:17:18.319 ⇒ 00:17:30.689 Amber Lin: I see. Okay, so that is sort of like the question that Bo asks, right? Or similar to, oh, I want to… I have a sales lead, who should I put it on? The way people ask things…
120 00:17:32.010 ⇒ 00:17:33.390 Amber Lin: Issue? Okay.
121 00:17:44.700 ⇒ 00:17:50.079 Mustafa Raja: I think, Sam and I were discussing it, and I think, we might, you know…
122 00:17:51.880 ⇒ 00:18:01.729 Mustafa Raja: let the DB tool know what services we have right now, so it could select them better. But, we haven’t made a decision on that. We are going to meet…
123 00:18:02.830 ⇒ 00:18:07.880 Mustafa Raja: have this, when I have a summary of the issues.
124 00:18:08.030 ⇒ 00:18:09.840 Mustafa Raja: And we’ll look into that then.
125 00:18:10.880 ⇒ 00:18:18.100 Amber Lin: I see, okay. How would we know what’s already in our database and what’s not?
126 00:18:18.240 ⇒ 00:18:19.640 Amber Lin: Like, can I…
127 00:18:19.940 ⇒ 00:18:36.710 Amber Lin: could… would you be able to tell me, like, how many inspectors we have in… under each service, or how many, services doesn’t have inspectors or technicians, like… like HVAC that we looked at?
128 00:18:37.510 ⇒ 00:18:39.380 Mustafa Raja: One other thing,
129 00:18:39.640 ⇒ 00:18:48.289 Mustafa Raja: So, yeah, for those two things, I guess I could craft some queries and run those to get you some numbers.
130 00:18:49.370 ⇒ 00:18:53.729 Mustafa Raja: Apart from that, there is one other issue that I saw.
131 00:18:55.480 ⇒ 00:19:02.540 Mustafa Raja: So, so you’d see in this server… actually, let me get… get rid of this.
132 00:19:03.970 ⇒ 00:19:13.409 Mustafa Raja: Okay, so you would see here that in the services table, with the service, we have a role assigned to the service, right? And what this role is, is just,
133 00:19:14.460 ⇒ 00:19:16.019 Mustafa Raja: I think it’s an inspector.
134 00:19:16.440 ⇒ 00:19:17.730 Mustafa Raja: And sometimes…
135 00:19:18.720 ⇒ 00:19:31.750 Mustafa Raja: When the role is here assigned to the services inspector, they would… the CSRs would ask the opposite role. For example, they could ask for inspector for HVAC.
136 00:19:32.320 ⇒ 00:19:37.110 Amber Lin: But this is related to technicians. Why do we have a role ID?
137 00:19:37.110 ⇒ 00:19:39.029 Mustafa Raja: I assume you might not know.
138 00:19:39.030 ⇒ 00:19:40.019 Amber Lin: I don’t know.
139 00:19:41.450 ⇒ 00:19:49.130 Mustafa Raja: Yeah, I didn’t have a context on that, but this role ID is just, you know,
140 00:19:50.020 ⇒ 00:20:03.580 Mustafa Raja: So, what is assigned… so what… so technician is assigned to? So, in this case, what’s it called? Inspectors are assigned to this service. But does that mean that we cannot assign,
141 00:20:04.250 ⇒ 00:20:05.870 Mustafa Raja: Technicians to this?
142 00:20:08.070 ⇒ 00:20:18.629 Amber Lin: I think the reason that this became like this was because the inspector services was much more… maybe it’s much more deep?
143 00:20:18.740 ⇒ 00:20:20.499 Amber Lin: Tailed… oh, here.
144 00:20:20.610 ⇒ 00:20:32.679 Amber Lin: So, when we assign technicians, there are, like, A, B, C, like, different levels of technicians that can cover different things, and I think they have…
145 00:20:34.180 ⇒ 00:20:36.010 Amber Lin: You know what, I don’t know.
146 00:20:36.280 ⇒ 00:20:38.920 Amber Lin: Like, the service name is the same.
147 00:20:40.370 ⇒ 00:20:44.049 Amber Lin: And I don’t know why we have a role ID.
148 00:20:45.590 ⇒ 00:21:02.090 Mustafa Raja: Because, let me… because there was one instance where they were asking the opposite role, but I saw that here we have assigned, a certain role that was not that role. So, but I have forgotten what it was.
149 00:21:02.800 ⇒ 00:21:06.839 Mustafa Raja: Requested services have… yeah, so this one. So what is this, actually?
150 00:21:08.080 ⇒ 00:21:09.389 Amber Lin: Can I see her question?
151 00:21:10.110 ⇒ 00:21:15.900 Mustafa Raja: This is pest? Yeah, yeah, so… so this is, what pest technician, right?
152 00:21:16.070 ⇒ 00:21:17.669 Amber Lin: Okay. This technician.
153 00:21:20.530 ⇒ 00:21:25.150 Mustafa Raja: Let’s… let’s look into… Database…
154 00:21:27.490 ⇒ 00:21:40.870 Amber Lin: So, is that a use case of this question? Is she saying that this place only has… Like… inspectors?
155 00:21:40.870 ⇒ 00:21:44.560 Mustafa Raja: So, so, so, role ID to maintenance inspector.
156 00:21:44.760 ⇒ 00:21:49.869 Mustafa Raja: And then… but this role ID suggests, oh, these are only technicians.
157 00:21:50.740 ⇒ 00:21:54.960 Mustafa Raja: Oh, sorry, these are only inspectors, and they are asking for technicians.
158 00:21:55.260 ⇒ 00:21:56.400 Amber Lin: Yeah.
159 00:21:58.390 ⇒ 00:21:59.280 Amber Lin: What is…
160 00:21:59.280 ⇒ 00:21:59.840 Mustafa Raja: See?
161 00:22:02.080 ⇒ 00:22:03.750 Amber Lin: Yeah, I think that’s her point.
162 00:22:03.750 ⇒ 00:22:11.800 Mustafa Raja: I haven’t… I haven’t dug deeper into this, by… by that I mean if this is absolute or not.
163 00:22:12.910 ⇒ 00:22:16.869 Mustafa Raja: Meaning if in the, assignments.
164 00:22:17.100 ⇒ 00:22:27.789 Mustafa Raja: this matters or not, because I don’t know if the same service could be assigned both… both the technicians and the inspectors.
165 00:22:29.140 ⇒ 00:22:30.790 Mustafa Raja: Does that make sense? I haven’t.
166 00:22:30.790 ⇒ 00:22:44.519 Amber Lin: Yeah, yeah, you’re… I understand what you’re asking. I’m also not 100% clear, but it seems like, based on Kenny’s question, that sometimes they’re… like, we shouldn’t have returned technicians, because there is no technicians there.
167 00:22:46.650 ⇒ 00:22:51.610 Amber Lin: It returns, inspe- it returns, yeah, it returns.
168 00:22:51.610 ⇒ 00:22:55.369 Mustafa Raja: what’s it called? Technicians only, but they are asking for…
169 00:23:00.290 ⇒ 00:23:02.050 Mustafa Raja: Yeah, these are inspectors.
170 00:23:02.740 ⇒ 00:23:12.380 Amber Lin: No, the… some of them are, like, the sea rodent and stuff, they are technicians, I just don’t know if they cover… they actually cover…
171 00:23:12.870 ⇒ 00:23:16.930 Amber Lin: That area, I am com- I am… Confused.
172 00:23:20.520 ⇒ 00:23:21.639 Mustafa Raja: Let me query that.
173 00:23:26.830 ⇒ 00:23:28.379 Mustafa Raja: Thank you, Suhiro.
174 00:23:29.630 ⇒ 00:23:30.709 Mustafa Raja: Let me push the button.
175 00:23:34.920 ⇒ 00:23:45.200 Amber Lin: I also have to hop in 5 minutes to call the client. Is there anything else you want me to ask them? They’re the mechanical folks.
176 00:23:46.860 ⇒ 00:23:50.240 Mustafa Raja: I don’t have any questions right now.
177 00:23:50.500 ⇒ 00:23:54.320 Mustafa Raja: I’ll just meet with, Sam and see, you know.
178 00:23:54.940 ⇒ 00:23:56.919 Mustafa Raja: What the next steps should be.
179 00:23:59.800 ⇒ 00:24:05.799 Mustafa Raja: Once I… once I deliver this summary. Yeah, I’m just trying to see if the assignments have any of the technicians.
180 00:24:06.070 ⇒ 00:24:08.439 Mustafa Raja: For these roles…
181 00:24:08.710 ⇒ 00:24:15.710 Mustafa Raja: Okay, so pest isn’t just this. Pest also includes sea rodent and this and that, right?
182 00:24:18.570 ⇒ 00:24:25.409 Mustafa Raja: Okay… Yeah, we should have some tags, though, then.
183 00:24:25.720 ⇒ 00:24:26.650 Mustafa Raja: Because…
184 00:24:29.790 ⇒ 00:24:35.900 Amber Lin: Could you just filter by serve, let’s see…
185 00:24:36.210 ⇒ 00:24:43.550 Amber Lin: The ones that have… technicians, so I can read through what service names there are.
186 00:24:47.080 ⇒ 00:24:51.400 Amber Lin: I get the services, but… Where role ID is one, I guess.
187 00:24:58.900 ⇒ 00:25:08.550 Amber Lin: Cool. Yeah, see, I think it’s much more specific on technicians. It’s, like, A termite, B termite, rodent, mosquito.
188 00:25:09.120 ⇒ 00:25:11.479 Amber Lin: I guess much more specific.
189 00:25:12.110 ⇒ 00:25:14.500 Amber Lin: Like, we could add…
190 00:25:14.810 ⇒ 00:25:23.589 Amber Lin: We could add an alias or department to say, hey, these are all residential pests,
191 00:25:24.820 ⇒ 00:25:28.459 Amber Lin: Okay, there’s something else we can… we need to clean up as well.
192 00:25:30.160 ⇒ 00:25:34.049 Amber Lin: Okay, let me write… write that down.
193 00:25:34.960 ⇒ 00:25:36.010 Amber Lin: One sec.
194 00:26:24.300 ⇒ 00:26:29.110 Amber Lin: Great. That’s all. Let me list down the top causes.
195 00:26:29.640 ⇒ 00:26:34.570 Amber Lin: And then you can… you can feel free to make comments and…
196 00:26:34.790 ⇒ 00:26:43.489 Amber Lin: Suggestions. So, I’ll say that our top cause is, one, missing certain assignments.
197 00:26:45.740 ⇒ 00:26:48.320 Mustafa Raja: Yeah, we were missing certain assignments, and then…
198 00:26:48.320 ⇒ 00:26:48.910 Amber Lin: Yeah.
199 00:26:48.910 ⇒ 00:26:49.960 Mustafa Raja: Sometime.
200 00:27:08.050 ⇒ 00:27:16.400 Amber Lin: Missing certain assignments need to assess… I’m gonna need two… We should…
201 00:27:23.960 ⇒ 00:27:28.359 Mustafa Raja: We are missing certain assignments, and certain… there are certain things, like…
202 00:27:29.070 ⇒ 00:27:31.200 Mustafa Raja: Yeah, do we have commercial inspectors?
203 00:27:31.200 ⇒ 00:27:31.879 Amber Lin: Of course we do, right?
204 00:27:31.880 ⇒ 00:27:32.550 Mustafa Raja: Right.
205 00:27:32.790 ⇒ 00:27:39.889 Mustafa Raja: Yeah, like, this person, I think they have moved from PEST to somewhere else, to commercial or something.
206 00:27:41.000 ⇒ 00:27:46.290 Mustafa Raja: Then there was one other… this Travis Hall, they have also moved from here.
207 00:27:47.570 ⇒ 00:27:54.830 Mustafa Raja: But in their database, obviously they’re still showing up here. So we need to update. So we have some things like that.
208 00:27:57.100 ⇒ 00:27:58.429 Amber Lin: Gotcha.
209 00:27:58.750 ⇒ 00:28:00.290 Mustafa Raja: from DHOO, and then…
210 00:28:00.290 ⇒ 00:28:02.570 Amber Lin: Ask me in a way, yes.
211 00:28:03.150 ⇒ 00:28:04.530 Amber Lin: Collected.
212 00:28:05.200 ⇒ 00:28:06.900 Amber Lin: Yeah.
213 00:28:07.070 ⇒ 00:28:09.700 Amber Lin: BB Field Names.
214 00:28:32.260 ⇒ 00:28:34.140 Mustafa Raja: put, edition.
215 00:28:34.340 ⇒ 00:28:36.649 Mustafa Raja: I couldn’t also find assignments.
216 00:28:38.780 ⇒ 00:28:39.990 Mustafa Raja: In Austin.
217 00:28:40.170 ⇒ 00:28:41.249 Amber Lin: Which, which one?
218 00:28:41.850 ⇒ 00:28:43.630 Mustafa Raja: the aeration.
219 00:28:43.980 ⇒ 00:28:44.660 Mustafa Raja: Okay.
220 00:28:44.830 ⇒ 00:28:47.850 Mustafa Raja: Aeration should be lawn.
221 00:28:48.300 ⇒ 00:28:51.860 Amber Lin: Is that… is that in lawn?
222 00:28:52.730 ⇒ 00:28:56.320 Mustafa Raja: Let me, let me see… So his name…
223 00:29:20.640 ⇒ 00:29:21.580 Mustafa Raja: Thanks.
224 00:29:28.470 ⇒ 00:29:30.959 Mustafa Raja: And then in Austin.
225 00:29:33.210 ⇒ 00:29:36.610 Mustafa Raja: Austin right… Austin.
226 00:29:38.060 ⇒ 00:29:38.960 Mustafa Raja: So…
227 00:29:51.230 ⇒ 00:29:55.000 Mustafa Raja: Yeah, so for… So, for this…
228 00:29:55.790 ⇒ 00:29:58.830 Mustafa Raja: So this is the name of the service, right?
229 00:29:58.830 ⇒ 00:29:59.920 Amber Lin: Oh, okay, yeah.
230 00:30:00.200 ⇒ 00:30:01.500 Mustafa Raja: Or is it something else?
231 00:30:02.120 ⇒ 00:30:03.150 Amber Lin: No, that’s right.
232 00:30:03.700 ⇒ 00:30:06.319 Mustafa Raja: Okay, so for this,
233 00:30:06.630 ⇒ 00:30:13.810 Mustafa Raja: when I, you know, filter with location. With our filter, we do have some assignments somewhere.
234 00:30:14.140 ⇒ 00:30:15.820 Amber Lin: But not for that location.
235 00:30:15.820 ⇒ 00:30:17.820 Mustafa Raja: But not for Austin.
236 00:30:17.820 ⇒ 00:30:25.180 Amber Lin: Okay, I will have to jump. I’m gonna write this down. Feel free to add in… add in as a comment. I need to hop to a client’s call.
237 00:30:25.670 ⇒ 00:30:26.420 Mustafa Raja: Okay.
238 00:30:26.420 ⇒ 00:30:28.390 Amber Lin: Yeah, appreciate it. Bye!