Hello. Hi, everyone. I am Sanjay Gupta. I welcome you on Sanjay Gupta Tech School. So this is day five of Salesforce Learning Bootcamp. And before starting, I just want to confirm whether my voice is audible. Okay. Thank you for confirmation. So I saw two questions in the beginning of the chat. So first one is related to feed and history tracking. So, Mary, I will be sharing them. So not today. In the next session, I will be explaining. So you can just refer the Excel sheet, like those topics which are left, they will be covered, but in different session. So in today's session, I will be covering about lookup and master detail field, roll up summary field, and we'll learn how we can create junction object and what is the purpose. And yes, first video is hidden. So it is due to YouTube guidelines. So like, I will do something about that. Maybe I will rerecord and we'll upload that as per the guidelines. Okay. So we are on time. So let's start this Bootcamp's day five session. So as every day, I ask you to know about your instructor. So this is me helping students, freshers, and professionals to ram their career in Salesforce ecosystem. Now, seven virtual learning best practices. So you just need to focus on live sessions. You need to take proper notes for future reference. You can write down doubts and you can ask them in Q&A part of the session. So I can see many people asking doubts in between the session. So I would suggest to ask all the questions at the end of the session. Don't miss any session because most of the topics are connected. Then practice each session along with the exercises. So if you follow the exercise sheet, so I'm regularly updating exercises and you can follow that so that you can practice. And if you see any doubt during practice, so I can see a few folks are asking questions in the comment section after the session. So you can also ask and keep doing everything which is listed here so that you can build a strong foundation for a successful career. Okay, so like initially I will be explaining the topic and then we'll take Q&As. And you can subscribe, follow and share like all the channels and spread the word so that everybody can learn Salesforce free. So in today's session, we will be discussing about the relationship fields. So there are two types of relationship available. We have one-to-many relationship and many-to-many relationship. So basically till now, what we have done, we have created objects separately. So we created student object, we created instructor object. And under student object, we created some records and under instructor object, we created some records. Now, today I will let you know like how you can link two objects or you can say two records together. So first of all, we will be discussing about one-to-many relationship. So if we talk about one-to-many relationship, so one-to-many relationship means one record can have many related records. So here you need to understand it like your one record will be on parent side, parent mean master record. And that record will be having some child records. So we can do this through two different ways. One is lookup and one is master detail. So first of all, I'm going to show you what relationship is with the help of standard objects. So if I take you to the orb, so here inside the orb, if I open our sales application, so I'm going to open sales application in new tab. So here under the sales application, you can see we have two tabs. One is account and one is contact. So account tab is related to account object and contact tab is related to contact object. Now if I go to contacts and if I open any contact and here you can see every time we are viewing details. So these details are related to account record. Now if I go to related, so here you will see the related records under the objects which are related to account object. So account object is having contact, opportunities, cases, these objects are related to account. So you can consider like account is on one side and contact opportunities and cases are on many side. So we can say one account can have many contacts, many opportunities, many cases related, right? So if I click on new button here, so I will be creating a contact. So here you can see I just need to fill the information and account name is populated by default here. It means this contact will be related to this account automatically, right? So I am creating test contact here and clicking on save. So you can see a test contact is created here. So right now this account record is having two related contacts, right? And this phone number is populated through this account. So this account is provided by Salesforce by default. So these records are provided by Salesforce. I have not created these. So these records are having pre-populated data which is managed by Salesforce internally and it is available for practice purpose publicly, right? So here you can see we have two related contacts, right? Now if I go to contacts and if I try to create new contact, so here I will see this field. So this can be lookup or master detail. It means whenever you are trying to create new contact, so you can link it with any account, right? So I am creating test con 2 and I am going to link it with Burlington textile and saving it, right? So if I go to this account, now I will see three contacts related, right? And if I open any contact and go to details, so here I will see the account name which is related to this. And if I hover, so I will see this layout. So this is basically our compact layout that we discussed yesterday. And these are related records which are related to account. So these are other child objects which are related to this account object. So this way basically relationship is managed, right? So we have one parent record which is having many child records, okay? Now we can create this relationship using lookup and master detail. So we have two different type of relationship fields available and both have different features. So I hope with this you understood like how we can link two objects if they are standard object. Now we will try to do this with custom. So what I am going to do, first I am going to implement lookup relationship. So now you need to understand what lookup relationship is. So it creates a relationship that links one object to another object. The relationship field allows user to click on a lookup icon to select a value from a pop-up list. So this I showed you like when I created contact record. So there I was using a lookup icon and if I clicked so it was showing me account records from which I selected one account record. So the other is the source of the value in the list, right? And this lookup relationship is loosely coupled relationship. It means if you delete your parent record or your like one record which is on one side. So your many side records won't be deleted automatically. So that's why it is loosely coupled relationship, right? Now if you want to see like the field which is already there, it is lookup or master detail. So how we can do that? So I can see one question in the chat. So if I go to contact object, so under this contact object, if I go to fields and relationships. So here you will be able to see what type of field account is where we are populating the values. So you can see it is of type lookup. Lookup to account. So if field is already created, so based on this data type, you can easily identify whether it is lookup or master detail. And yes, Mary, we can add lookup and master detail on standard objects as well. So these are already created. If I want to create new lookup or master details. So here you can see this lookup relationship is available, right? Now I'm going to show you this with custom objects. So I have a requirement for this. If you go to our exercise sheet. So here we need to create a lookup field on student and it should be related to class. So if I take you here, so we need to create this field actually lookup. We need to create lookup field to class. So first of all, we need to create this object. This object is also not created in our org. So if I go here and search for the object class, so it is not available. So first I'm going to create this object. So label will be class, plural label classes. Then I'm leaving it as is. So in previous sessions, someone asked me when to use text. So we already used auto number. This time we are going to use text, right? So auto number won't be there. So a field will be created whose type will be text and its label will be class name. And we need to create a tab. So I'm just checking this checkbox and clicking on save. So now I need to create a tab for this. So I'm selecting tab style and clicking on next, leaving it as is next. Now it is asking me to place this tab on particular application. So I'm going to select the application which we created. So you can see we have two applications. One is standard navigation and one is console navigation. So I'm going to add this class tab on both the applications. And I'm clicking on save. So this way my object is created. If I go here and refresh the page, so along with student and instructors, you will see this class tab as well. So here you can see third tab is available. And if I try to create new record, so you won't see any auto number field. Here class name field is available, which is required. So one field is created automatically of type text because we just selected text instead of auto number. So this way I hope you understood both the data types. Those are available whenever we create objects, right? Now we need to create more fields. So I'm going to create course duration. So course duration will be of type text. So under fields and relationships, I am creating this field. So new from data type, I'm going to select text. Then next. So field label will be course duration length. I'm writing as 100 and clicking on next visible to all the profiles and next. And save. So this way this course duration field is created. It is a custom field. So these two fields are created. Now I need to create one more field that is fees and it will be of type currency. So I'm creating this one as well. And then I will show you how we can create mass, sorry, lookup field. So here I'm going to select currency and here I'm going to fill the details. So fees clicking on next. So it should be visible to all the profiles clicking on next and clicking on save. So this way you can see course duration and fees. All these fields are created. So highlighting it as green, right? Now I'm going to create this lookup field on student. So one more thing that you need to remember, like whenever you want to create lookup or master detail field. So these fields you need to create on the child object, right? And they will look up to parent. So here in our case, what we can say student will be a child where we will be creating lookup field and it will look up to class. It will be parent, right? On parent side, you will see related list. So this is important to know, right? So on parent side, you will see related list and lookup field you need to create on the child side. That is student. Okay. So one class can have many students. This is the idea. So here I'm going to search for student object clicking on fields and relationships. Now clicking on new. And here you can see I have this lookup relationship field. So it says creates a relationship that link this object to another object. The relationship field allow user to click a lookup icon to select a value from a pop-up list. The other object is the source of the values in the list. So I selected lookup relationship clicking on next. Now from here I need to select the object class. So here it is. So this will be our parent object. So here you can see it is saying select the other object to which this object is related. So this is important. This object will always be parent. So sometimes whenever we start implementing lookup or master detail relationship. So people do mistake here. So always remember lookup field will be created on the child side. And while creating this lookup, we need to select the parent object. This is important to understand. Now I'm just clicking on next. And here you can see field label is already populated. If you want to change it, you can. Now here we have few more things. Child relationship name. So the child relationship name is an internal reference. And is used for integration purposes. Be careful when changing the child relationship name as it may affect existing integrations. So basically when we'll be learning about development, then we'll be using this child relationship name. So right now I'm leaving it as is and focusing on other things. So here we have a checkbox which is showing required. So if you want to make this lookup field required, you can check this checkbox. By default it is optional. Then this is also important. What to do if the lookup record is deleted? So if your parent record is deleted, so what you want to do with this lookup field? So first option says clear the value of this field. You cannot choose this option if you make this field required. So if you make it required, you cannot choose this option. In that case, don't allow deletion of lookup record. That's part of a lookup relationship. So if it is required, then you won't be able to delete the parent record. But if you uncheck, then you will be able to delete and the lookup field will be clear. It won't be related to any parent record. So this is the explanation about this. Now I'm moving ahead, clicking on next. Visible to all the profiles, clicking on next. Now here on page layout, like you can see, we have three page layouts. So we have experienced fresher and student layout on student object. So on which layout you want to place this newly created field. So I'm going to place it on all the layouts. Now here you can see numbers like step number six. This is additional, which is available on lookup field creation. It is for related list label. It is for related list label. So I showed you related list at the time of contact record. So if you open any contact record and go to related, so here you see the related list label. So this label, what should be the label of this related list that you can type here, right? So on class record, you will be having a related list named as students. If you want to change it, you can. And later on also you can change this label. So I'm just clicking on save. So this way here you will see a lookup field is created. So I'm just searching for that. Yeah, here it is. Lookup to class, right? And here in the bracket or parenthesis class word is written. So it is representing parent object and the student will be child because on this object we just created this field. Now let's create some records. So I'm refreshing it. So first I'm going to create some class records and then we'll be creating some related students. So I'm clicking on new and creating class. So first class name is, for example, Salesforce admin course duration, two months fees, for example, 10,000 and I'm clicking on save. So this is my first class, right? Now I'm going to create one more class. Salesforce tab duration four months and fee suppose 20,000 and saving it. So this way these two records are created. Here they are visible. If you go to all list view, so from here you can add fields as well. So we can add course duration. We can add fees and save, right? And here you can see the details. If you want to pin this, you can click here.  You will see all list view. So we have this pin. So whatever list view you pin, you will see that only. So here we have two classes. Now if I open this and go to related, so here you will see student related list. But right now we have zero related student. Okay. Now we have two options to relate students with this record. First, we can create new student records from here only. And if you have created a student record already, you can link them as well with this class. Or if you want to create new students from students tab, so that is also possible. So we'll do all three things. So first time creating student record from this related list. And here we need to select record type then next. And here you can see this class lookup is available, which is having Salesforce admin class pre-populated. And here I can just type the name of student, right? So admin one name of the student, right? And I'm just clicking on save. So validation rule is working. Please populate entrance score. Here I'm entering 80 and clicking on save. So this way you can see a student record is created. Its ID is 007 and it is related to this class. Okay. If I want to open this student record, I can just click on this and it will be opened. And here you will see the parent record information, right? If you want to open the class record, you can just click and it will be opened. If you go to related list, you will see your related student record. Now if you hover on this, you will see the compact layout that we created yesterday, right? So this is your compact layout. So this is the another use of compact layout whenever you hover any record. So it shows. And if you see here, in this compact layout, you are not able to see anything. You just can see the name of the class because compact layout is not configured here, right? So this way we can relate student records. Now if you want to relate existing student records, so if I open this 001. So here you will see that field. So here it is class. If you click, so this is lookup icon. Here if you try to search, we can see both classes. So I'm linking it to Salesforce admin and clicking on save. Now if I go to Salesforce admin class and go to related list so I can see two students here. So this is actually one to many relationship. So class record is on one side and student records are many side. Now if I go to students and try to create new record from here. So I'm labeling it as admin to score. I'm entering as 30 and here I need to fill the class. So one more student record is created and it will be linked to Salesforce admin class. So here you can see three records are related. So this way this lookup relationship basically works. So I can see a few questions. So one question is what if student 007 is in both classes. So in that case you need to create lookup for both. And sorry, it is not possible because if we open this 007. So here you can populate any one class. Right. If you want to relate this record with multiple classes. So for that we will be using many to many relationship through junction object. So there is one more question how to identify which is primary and which is child. So this I already told you. So primary or parent will be where you see related list and wherever you see lookup or master detail field that will be on child side. Okay. So this way I hope you understood the functioning of lookup relationship. Now let's discuss about master detail relationship. So it is little bit different with lookup relationship. So it also creates a special type of parent child relationship between two objects. One is known as child or detail where we create master detail relationship field. And another one is known as parent or master. Right. Now lookup field was optional. Lookup field was optional. So what we can do like if I delete the parent record, if I take you here, if I delete this one, if I delete this class. So all three records will still exist.  That's why this is lookup. Sorry. When you will be practicing, so just try to delete this class record. You will realize in case of lookup relationship, these related records won't be deleted. And if you open any of these record, there, this class field will be blank. Right. But in case of master detail relationship, this field is required on all detail records.  Then ownership and sharing of all of a detailed record is determined by the master record. Right. So owner like who the user who is the owner of parent record that user will be owner of the child record. And if we can access the parent record, then we can also access the child record. Right. Sharing applies. Whatever sharing is available for parent record, it goes with child as well. Then if you're, if the user delete some master record, then all detail records are deleted. And one can create roll up summary field on the master records so that detail record can be summarized. So this feature is available with a master detail record master detail field only. It is not available with lookup. And it is tightly coupled because if you delete parent, so all child will be deleted. So let's try to create this. So what I'm going to do under student. So same relationship I will be using child will be student and parent will be class. And I will try to create a master detail field. Right. So I'm just clicking on new. And I'm selecting master detail relationship. And here also you can see all the description is written. So anytime if you forget about master detail relationship, you can go through with these points. And I'm clicking on next. So there is a question like what is loosely coupled? So loosely coupled means if you delete parent record, so your child record won't be deleted. So they are connected, but but loosely like if parent is deleted child won't be affected. And in case of tightly coupled, if you delete parent, so child record will get deleted automatically. Okay. So now I'm trying to create master detail field on student object and it will be related to class. So class will be on parent side. So right now if I use these names class, so it will be duplicates. I'm adding one into it. And here we have different things sharing settings. So we have two options read only and read write. So you can select the access level from here. So you can go through with this statement as per the requirement we can select. And as I told you this master detail field will be read only like once you select a parent, then it is difficult or it won't you won't be able to modify the parent record. On child side, if you want to change the parent record, so we have this checkbox allow reparenting. So if you check this checkbox, then you will be able to change the parent record for that child record. Right. Otherwise you won't be able to. Okay. So these are some features which are available with master detail field. So I'm just clicking on next. And here you can see all the checkboxes are by default checked because this field is required. You need to populate value. So it should be accessible by all the profiles. And it should be visible on the layout as well. So you can see all the checkboxes are checked. You cannot control these. And next. Then here you can see a related list will be created. But now if I hit save, so you will see an error message. Right. I am trying to create master detail field and I got this error. So quickly review this error so that we understand the problem. So you cannot create a master detail relationship on an existing custom object if records already exist. So this is important. If you have records already available. So there may be possibilities like in some of the fields, like after creation of this master detail field. Those existing records will not be having any parent selected. Let me show you how if I go to students and if I go to all list view and from here if I select a field that we created as lookup. So here you can see this lookup is filled for three records. For rest it is blank. But in case of master detail, what will happen? We have these seven records. So for these existing record master detail field will be created, but that field won't be having any value. And as master detail field is required, so we cannot do so. So if your object is having existing records, you won't be able to create this field. So we have two solutions now. First create master detail field whenever there is no record created. And if there is already records created, so what you can do? You can first create a lookup relationship, then populate the lookup field with data in all records and then change the relationship type to master detail. So this we can do right now. So this way you will understand like if you have a lookup relationship, so how you can convert that lookup relationship into master detail relationship, right? So I hope you understood the requirement. Like if you have existing records on particular object, so in that case, you cannot create master detail relationship field. So you need to convert or you need to first create a lookup field, then you can convert that lookup field into master detail. So we already have created this lookup field, so what I need to do? I just need to fill all these records. So these four records should also have a parent, then only we will be able to convert this lookup into master detail, right? If I don't fill, then I won't be able to do that. So let me show you that as well. If I go here and open this lookup field, if I try to edit, so I won't see... Okay, this change field type option is available if I select master detail relationship from here and click on next and save. So you can see again it is showing the error. Why so? Because on these four records, we don't have any parent record populated. So what I'm going to do one by one, I'm opening these records and I'm going to populate the class. So for these four records, I'm going to populate classes. So I'm going to populate classes Salesforce DAV and I'm going to arrange these so that we can see the details. Okay, so we have Salesforce admin, Salesforce DAV. So these three are pending and I'm pinning this list view so that I can see this every time. So from here, I'm selecting Salesforce DAV, saving it. Again, I'm opening this number four and I'm selecting parent record, saving it. And for this number zero five, I'm going to select a parent record and saving it. So if I go here, so Salesforce admin is having three students, Salesforce DAV is having four students. And if I go to students, here you can see each and every record is having parent record populated. Now, if I try to convert my lookup relationship into master detail relationship, so I will be able to do so. So again, I'm clicking on change field type, clicking on master detail relationship, next. And from here, I'm clicking on save. So you can see our lookup is converted into master detail. So if you see this field, so here, you will be able to see the master detail is available data type, right? And as this is converted into master detail, if I open any student record, so here, if I select it so you can see we have an error message, right? We are not able to change it because now it is master detail. So if you want to change it, so you need to check that checkbox allow reparenting. And if I try to create new student without populating class, I won't be able to do. So you can see here, asterisk is available. So when you will be doing the practice, so do one thing, whenever you will be creating a lookup field. So try to create a record without populating that lookup field. So you will be able to save the record, you won't see this asterisk. But in case of master detail, you will see this, right? So this way, I hope you understood how we can create master detail relationship field. So we have two ways to create it. One, like if you don't have any record, then you can create it directly. If you have record, existing record on particular object. So first create lookup, then a populate lookup field for each of the record, and then you can convert that lookup into master detail, okay? So then we have roll up summary field. So if you have created a master detail field, so for master detail relationship, you can apply roll up summary. So it is a read only field that displays the sum, minimum or maximum value of a field in a related list. This field also can count all records available in related list, and roll up summary field is always created on parent. So if you go to this exercise, so this first and second point I demoed you. Third also I demoed like how to create lookup field. Here child is student and parent is class. Then I converted this lookup into master detail. So you need to create one more, this one. Create a lookup field on instructor object related to class, right? And we need to create these roll up summary fields. So I am going to create this one, total students. I am going to create this one, total students. Rest you can do as per your practice, right? So what we need to do, this time we need to search parent object. That is class. So I am going to open it and under fields and relationship, I just need to click on new and here I will find this roll up summary field, data type. So it is a read only field that displays the sum, minimum or maximum value of a field in a related list or the record count of all record listed in a related list, right? So here I am clicking on next. So we just need to calculate total students, right? So this is the label and API name. Then I am clicking on next. So from here we need to select which object to summarize. So I am selecting student. Then I just need to count. If you want to calculate some min or max, so in this case, you will be able to select the field, right? So as per our exercise, you will be calculating highest entrance score. So what you will do, you will be selecting max and entrance score. So automatically on parent record, all the child records will be checked and whose entrance score is the maximum that value will be populated on parent record in the field that we are creating right now. So I am just going to count. We can apply filter criteria like you want to include all the fields or only selected fields. So here you can apply criteria like age greater than 30 like this, okay? So this way you can apply the conditions. But I am including all the records as of now. Then clicking on next and visible. You can see it is read only by default. Clicking on next and save. So here you can see this roll up summary field is created and we created it on the parent side. So what we need to do, we need to open the parent record. So I am going to classes, opening Salesforce admin and refreshing the page. So this field will be available on this parent record page. So you can see it is having total students as number is three. If we go to Related List, we can see three records are related. If I go to another class Salesforce, so here total students are four. If I go to Related List, records are four. And if I try to edit, so I won't be able to edit this roll up summary field, right? So this way you will be able to create roll up summary on parent side. Okay, so I can see some questions in the chat. So let me take those. So can lookup be converted into master details? So I already demoed it. And can you not converse? Yeah, so Mary's asking, can we convert master detail into lookup? So that we'll do later on. So right now I just created roll up summary on parent in master detail. So we can convert master detail into lookup as well. So I will show you that as well. Can you delete empty records and add master detail relationship after? Yes, this is also right. So if you can delete your existing records, there is no problem in deleting. Then you can just delete all the records and then you can directly create master detail relationship field. Can you fill class values from list view itself, right? Yes, Sunita, we can do. If interviewer ask for type of relationship, we will mention only two. Yes, so we have external lookup relationship as well that is used for integration purpose. But mainly we have these two. Then how to, we have self lookup relationship as well. So what you can do in FAQ, I just provided a document. So I just updated it for previous FAQ. Here you can see we have these two links. So there is consideration for relationships. So you can go through and another is for many to many. So you can just view these are Salesforce official documents which are publicly available. So you can just view and read information from here. Then next is how to identify when to use lookup or master detail.   Then roll up summary is available with master detail. So if you need roll up summary calculations, then go for master detail. Then if you want to apply sharing rules of parent to child, then go for master detail. So this way you can identify. Then if child as records, can we create relationship? Ramya, I didn't get your question. Can you please elaborate? Then we can create relationship on child record only. Sai Krishna, yes, we can create relationship on child. And on parent side, we will be having related list only. Is there a way to change filter logic as or in roll up summary field? Yes. So if I added this, so we can just added the filter logic. So if I select this, let me select this. So here we are not having the option to change this and yes. So it will be and we cannot change it. So next question, if we do max score, then it will show max score, but can we show the name of the student with max score? No. That feature is not available with this roll up summary. Then, okay, Rishabh is asking, please reply should I learn visual force? Yes, you can, but in many, like 99 projects won't use visual force. But if you want to know the language, you can. So what we can do if there are n number of records are there for converting lookup to master detail. So like in real time scenarios, it won't be the case initially when you are building the project. So at that time, it is decided whether to have lookup or master detail, right? What is the difference between if we create lookup relationship with required and MDR? Shubham, can you please elaborate your question? To create master detail relation, can we create when master is custom object? Yes, we did that. So our both objects were custom, right? But in case of standard, I think on standard, we cannot create relationship for parents. So let me just check it. So if you go to account, fields and relationships, new lookup relationship next. So let me search for class. Yeah, I think we can do. Yes. So I would suggest go with this document here. All the considerations are available. So you will get all those answers with this document. Harsh is asking, can we create it on standard object? Yes, we can. So again, there is asking how many lookup we can create for objects. So like it is suggested, you can create two master detail and any number of lookup relationship. So let me just open this document for you. So here you will find those answers. So here you can see it is written each custom object can have up to two master detail relationship and many lookup relationships. So this way you can see everything is available here. If you go through this document, you will find all the specific information. And this is public document, which is provided by Salesforce. And it is available in our FAQ document. Could you provide an example on hierarchical relationship? So basically, hierarchical relationship is available with account and other objects. So if I go here, so if you see here, this is basically hierarchical relationship. So account hierarchy we have and like it goes with same object. So if I open this account and go to details. So here I can select parent account and right now it is recently. Let me view one more. So I'm opening another one moving to details. And here I'm populating parent account as this and I'm saving it. So now you will see hierarchical relationship. So this is parent and this is child for this. So this is basically account hierarchy that you can create and it is standard. So Mary is asking, can you make roll up with pick list or check box? No, basically this roll up is for records. You can count record. You can find out max min or some through numeric or currency fields only. How many roll up summary can be created so that you can check. I don't remember exactly. Please explain cross object formula fields. Yeah. Rekha this cross object formula field we will be discussing when I will be explaining end to end project. So I have planned a project you can see in the Excel sheet. So when we will be discussing about that project, so there are some more features will be available. So we will discuss it there. Roll up summary can be of max min, average and total. Yes, Pankas, you are right. Master detail relationship can be created only on custom object can be created on standard object as well. So I think yes, let's try it out. So if I go to opportunity fields and relationships and if I click on new. Yeah, so I think you are right. Like we cannot create master detail relationship on standard object. So it should be somewhere written in this document. So if you read this master detail relationship, so here you will find this. Yeah. So here it is standard objects can't be on the detail side of a custom object in a master detail relationship. Right. So I already told you everything. Every information is available here. You can go through. Okay. Now, let's understand next thing. Okay. Before converting master detail into lookup, let's see these relationships and schema builder. So we gone through schema builder earlier. So one feature we didn't explore. So if I open schema builder now, so here you will be able to see the relationships. So here we have two object student and instructor. Right. And we need to select class as well. Okay. So if I have it. So right now you can see. So student and class are sharing master detail relationship. So it is showing master detail relationship from student to class. So student is on child and class is on parent. And if you see this diagram carefully, here you see three lines. Right. And here you see one line. So it is one too many. Right. And here is the legend which is showing colorful lines. So red is for master detail and blue will be for lookup relationship. Right. So what you can do when you will be completing this exercise, so you can just go and check your schema builder because you will be creating two lookups between student and class and between instructor and class. And just try to create all these roll up summary fields and other things. Here we need to create a formula field and average of entrance code. So for this, what you can do, you need to divide total entrance code with total student. To calculate the average. Right. So these two roll up summary fields, you can reference in your formula so that you can have average entrance code. Then you need to convert lookup into master detail. Then create roll up summary. Then convert master detail into lookup so that we are going to do right now. So we will be converting. Okay. This we already did convert lookup into master detail. So first we need to populate value in lookup field of each record. And if you want to convert master detail into lookup. So what we need to do if you have created roll up summary field on parent object, so you just need to delete those roll up summary fields from parent object. And when you delete your field, so it goes to recycle bin, so you need to delete it from there as well. And then only you will be able to convert your master detail relationship into lookup. So let me do that. So I'm moving to class subject and here I am selecting fields and relationship. So here I have this roll up summary field. So I'm going to delete it. It is deleted. Now if you see this deleted fields, so here you will find that deleted field. Okay. So Salesforce starts to hard delete these fields after 15 days. The hard delete process permanently removes all metadata and system data for the field. It is kept the 15 day grace period and immediately sets the field to ready for the hard delete process and delete if available restores the field. Right. So if you and delete. So it will be restored. Right. But what we need to do, we need to delete it again. So you can see it is restored. So if you delete again, it will go to deleted fields. And now you just need to click on this erase so that it will be deleted permanently. So now it is asking. Yes, I want to permanently delete the custom field. So you can just click on delete and it is deleted. Now you need to go to your child object that is student.  So what you need to do added this and you need to click on change field type. Right. And from here you can select lookup relationship. Right. And click on next and save. So this way your master detail field will be converted into lookup field automatically. Right. So I hope you understood everything how to create lookup, how to create master detail, how to convert lookup into master detail and how to convert master detail into lookup. And along with that we created roll up summary field as well. Let me pick some more questions. So what is the difference between account and contact relationship? So difference means it is a lookup relationship and it is standard relationship which is created by Salesforce. What is the need to delete from Recyclebin also? Because if you don't delete from Recyclebin and if you converted your master detail into lookup and after two days let's say if you restore that field, so it won't be restored because relationship is not master detail. It is now lookup. That's why. So Mary is asking where can we reach the bin? So it is here, deleted fields. If you go to deleted fields, so you will find your deleted field. So lookup relationship between account and contact. So this is lookup relationship, but it is a special type of relationship. So here few features are available of master detail as well. So you just need to study it. It is a special relationship. It is created by Salesforce as a standard relationship. So I'm not understanding what exactly you want to know. Anand. And if you have any other question you can just mention in the chat anyone if you want to ask. So I had one more topic many to many relationship. So this I'm going to explain now quickly. So in case of many to many relationship, what we need to do, we need to create new object and that object will be known as junction object. So basically what will happen that junction object will be having two master detail field available. So it will be looking up to two objects so that it can have data for two objects in many to many form. So let's first create it. And then I will show you how it is many to many. And this is the requirement. So I'm going to create a object STD class and it will be having master detail to class and master detail to student. So from object manager, I'm creating this. And here I'm going to pick auto number. So SC for student and class and then 0000. And starting number will be one. I'm going to create a tab for this. Selecting a tab style. Next default on next. And I'm going to place it on two applications. And save it. Now I'm going to create two master detail fields here. So one will be for student and another will be for class. So first I'm going to create for student. Next. Next. Next and save. Now I'm going to create one more. That will look up to class. So one more master detail field I'm trying to create. And it will look up to class. Clicking on next. And save. So this way two relationships are created here.  So you can see now you cannot create one more master detail because we already created two. You cannot create this type of field because this object already has two master detail relationships. So this validates like we can create at max two master detail relationship on one object. Now if I go to the UI and refresh the page so I will be having that junction object. So now what I can do if I try to create a new record. So what we can do we can select a student. So someone asked me like if one student is related to two classes. So how we can identify that. So we can identify that through this junction object. So from here I'm selecting Salesforce DAV. So this S01 is related to this class. Saving it. So one record is created. Now I'm going to create one more record. Selecting the same student and different class. Saving it right. And here I'm going to update this list view so that I can show you the details of student as well as class. And I'm pinning it. So you can see these are auto numbers. Here student information is available and here class information is available. Now if I create one more student five and relating it to Salesforce DAV. So you can see one student like 0001 this is one student which is having two different classes. One to many. And one class is having like Salesforce DAV is having two different students. So that's why it is many to many. So one student can have many classes and one class can have many students. So this way you can manage your many to many relationship. And we have master detail relationship. So it means if I delete any student record suppose I deleted as 0001. So if that students two entries are available here so both will be deleted automatically. Right. And if I delete Salesforce DAV or Salesforce admin class so it's all entries will be deleted from here automatically. So this way we manage many to many relationship and this is basically known as junction object which is having two master detail relationship. Okay. So this was the last topic for today's session. Now I'm going to take some more questions. So can we create junction object with three master detail? No. We can have only two. I already showed you. So how you are identifying classes master I can make class as child and student as master. Yeah. So this depends on the requirement. So asset this depend depends on the requirement. So when you will be working on the project. So architect will tell you which will be the parent object and which will be the child you won't be deciding at your own. Right. So architect will discuss with a client like what is the actual business requirement and according to that we identify. Shubham. I already explained many to many relationship through junction object. Yes. We cannot create master detail on standard object. I already explained this. We cannot create junction object with three master detail. We can only create two. Right now I created a junction object junction object is a special object which will be having two master detail relationship that is basically known as junction. So if you see here this STD classes junction object which is having information of student as well as class. So junction means which is brisk between two objects. So one is student one is class and it is having records for both so that we can have relationship like which student is related to which class if one student is related to more than one classes so we can have records here implemented. And if you go if you go to the student record so here you will see in the related list as well. So the student is having these two junction records. If you open this so it will show you like the student is related to which class. Right. So this way you can open the information. Yeah. The example is correct and next question is many to many objects means both object must be a master object in master object we need child object so we need to create junction object. Yes. Right. What will it show in class field on detail tab of student nothing. So here when we are talking about this junction so student and class are related here only if I open this student so there can be different class. So this you need to select accordingly because here also we have look up to class so this is one to many relationship and this is many to many so you need to work smartly here if you have many to many relationships then in that case you won't be having one to many relationship but if you have both then data will be incorrect. So thank you everyone those who are appreciating my efforts. One question is what does it mean field to aggregate and roll up summary. So field to aggregate means for example on parent record if you want to count how many child records are there so that is meaning to aggregate. So like sorry that that is particularly for counting. Now if you want to calculate some so let's say we have entrance score we want to calculate some of all the entrance scores which are populated on student records. So like field to aggregate means which field you want to calculate as some right so they can be more than one numeric or currency field so you need to select one so that it can be summarized. So plan is asking if suppose we have two object of one child if one object is deleted you cannot delete object if it is referenced somewhere. Yes Mary your example is correct sir how many types of object two or three. Nilesh can you explain can you elaborate your question a little bit more. So so Ramya is asking which objects have junction relationship so right now I created a custom but some standard objects are also having junction so if you go to opportunities so if you open any opportunity record so here you will find some junction object so here if you go to related so here you can see this is contact role so this is basically junction here we need to add contact as well as account so this this can be working as junction so this we will be discussing later on like when we'll be utilizing all the standard objects for different requirements so maybe there you will see yeah there is standard junction object so I will show you later on so right now like you won't be able to understand because we need to understand this platform more than you can understand the standard junction so I will show you that later on yes Rekha we can have more than one junction object in a single project one more good question while conversion of lookup to master if you have 15k records in a particular object how to fill the lookup field so that we can do with the help of data loader so we need to use data loader or data import with art so through that we will be or maybe you can use some automation tool so we can use we can use flow or we can use trigger right so or we can have schedule jobs so we have automations through that we can do so in Salesforce we have two types of objects standard type of object and this junction is not a type of object junction is spatial object which is having two master detail relationship so junction can be of standard type it can be of custom yeah workbench is also an option to a mass update the records okay so if you have more questions you can ask I think I try to answer all the questions still after the session if you have questions so you can mention them in the comment section and do practice this session because it is important to understand so I created lots of exercises for you so just practice so that you understand yeah so the good question so it will take the property or security of primary object the first master detail that you created yes we can create roll-up summary by using trigger so in case of lookup relationship if you want to summarize child data so we can do that with the help of triggers so if you guys have any more questions you can ask otherwise I can wrap the session here and I hope you are liking this bootcamp so please continue attending the sessions and doing practice because I am providing you day wise exercise so that you can implement those and after completion of all the admin related concept we will be doing one hand end-to-end project together so I will be implementing it in my system and together you will be implementing in your system and whatever question answers you will be having so we will be discussing them as well so this way like admin is easy but in-depth knowledge is required so I am trying to give you that in-depth knowledge so that you can understand all the concepts properly thank you Mary yeah I am taking medicines so I will take care thank you everyone so we'll see you tomorrow with new topics


Go ahead and get the meeting Called the order Todd Williams here John Caldwell president Kathy Peterson here Renee Davis here Roger Lane here Ken Peterson here Nelson Tipton here West Lowry here Kevin Bowman here Francie Jeff Jason Elkins Heather McIntyre is here Here Next item is approval of the previous months minutes for January 27th 2020 There any questions comments? If not, is there a motion to adopt or approve Motion to have a second motion in a second further discussion Hearing none all those in favor say aye Opposed thank you the water status report So today the flow of the same-ranked Creek at the landscape at 8 a.m. was 2023 CFS with an historical average of 15 CFS for this date For all price reservoir by rockers there is at 6387 feet which equals 13,400 acre feet so down approximately 2,760 acre feet from four and we're currently releasing 20 CFS from Union reservoir each item is at 23.58 feet which equals about 9,000 So and we're really seeing 5 CFS roughly Call on same-ranked Creek is Union reservoir had been numbered 19,671 with a priority date of 10 6 1902 So Union still in priority, so we'll run a little bit of water We've got some icing issues But other now we're back kind of running Taking all that we can The call on the main stem of the South Platte River is Burlington ditch have been numbered 22,239 With a priority date of 11 21 1910 Currently no call affecting district 5 local storage at the end of January It's approximately 71 percent of average and then Snowpack West will go into more detail on the snowpack under water supply update Of a Colorado's roughly 118% South Platte is 129% and same-bran is between Any questions All right, thank you Next item public invited to be heard or special presentations Public that would like to be heard today Okay, I brought an article this is the science journal research article that's been in the news lately about the Colorado River There was one on KU and C KNUC had it a couple other places that this is the the science magazine American Association of Advancement of Science. It's actually a research paper And so I was going to ask that All of you get a copy? I brought some of this Yes And so yeah, that's more understandable But this has got all the great. Well, thank you Okay, and you said there's no special presentations Okay, that's item five items six. Is there any agenda revisions or submission of documents? Yes, I have one for the legislative update I know I would like to give you legislation To look at that board that this bill is one sense We can handle it This is actually House Bill 20-1164, so we'll talk about that in the legislation. Okay, thank you. One sentence, but it's a page one. Next item is the development activity, it looks like. Wes, you got your hands full. Yeah, so there's a number of development activities in front of the board today. We have five different ones requiring board action. We can be able to do them separately or all together, whichever you want. Well, they all take recommendations, right? So I wondered if we could do them one by one and do a recommendation on each. That's good. And then we can just work our way through and then we can maybe talk if there's any major comments. We can talk one by one. I got kind of a comment all over the long run. We can go through them one by one and start. So the first one in front of the board is Sugar Mill Annexation. This is 17.44 acre parcel located in South Gray Rest from your right in West Bees County on the road. There are no historical water rights burdened to the annexation. The four of the Sugar Mill annexation is presently in compliance with the raw water requirement policy. At this time, we'll be at time of final flat with satisfaction of the 52.32 acre foot deficit. Additionally, I understand that the proposal for this annexation would be to put in approximately 112 paired homes. So. 112. Paired homes. What is that? Duplex. Yeah, it's probably going to be like your duplex or something like that. What is there now on that piece of land? Right now, I don't think there's anything this way that's being annexed. I drove out through this morning and I was really curious because it's a... I was trying to figure out exactly where this 17 acres is because basically it's one of the great western holding ponds. I mean, it's cattails. So I was just, well... I mean, again, this is out of our bailiwick, but it just was kind of strange to me that unless they're going to... Yeah, between wetlands and between... I'm sure they know what they're doing, but I was just curious to speak to what's there now. It's a wetland. There's trailers and nothing else. There's a lot of storage out there, too. That's just on the east. There's a kind of a quonset thing that's just east on the east side of this. I was amazed how many residences there are down there along Great Western and south of Great Western. I didn't realize how many people were out there. I don't know anything about the annexation. I know about the Great Western. I'm going to develop myself here. But, again, that was just curious to me. Which doesn't even do with our role. I think they're planning to bring up Platt, DRC, and probably Watermore in the very near future. So we do have a little bit more detailed information, but certainly they would have to comply with whatever... Oh, of course, of course. Yeah, it's probably... What we've found is most of the lands that have yet been developed are that way for a reason. Is there not the easiest to develop? So this sounds like... Could be. So on this one, we won't know until later probably what they do in terms of cash and lure.  So it's all going to be cash and lure, Mackintosh, or something along the way. That's not a story. I would not be summarized if it's cash and lure. Okay. And then, I guess with regards to the water supply demand analysis that was done, I assume this was included. I mean, all these were included within that. And I guess what I'd be curious if there was big land use changes from what was modeled in water supply and demand in relation to what's actually coming in. So I don't know what this was, this plan land use was. I didn't have to write that down. As I recall, it's the same land use that was prescribed to what we did in our analysis. So it's probably similar. It's okay. So all the land use we used in the water supply demand, based on the vision long mark approach, would have to be the same land use, unless they apply for land use variance, which has had several lessons. And if I remember it with the vision long mark, the only big question was they had some that were pretty flexible. Yeah, they were flexible. So how that was modeled in relation to what actually we see in it being an excision. You may not know a lot of that. Yeah, some of these come through. They have an ambition used to know that it can be a number of things that realize what actually happens. And we've known that would not be realized or understood until the point. But I guess it does follow.  It's not. Okay. All right. Good question. Were you the one who was out there? I said, I'll call you out early on. Joe Bell, is there a homeless encampment out there? There's one right there somewhere. And I was wondering if it's still there. Oh, I didn't drive. I basically was, I was right. I was just driving along Great Western Drive. Okay. And there's actually a road. It's pretty interesting. There's a road that takes up Great Western and goes down to this, it's not a quonset, but this storage unit that's just, it's off of County line. It's kind of an interesting mix of stuff out there. So I had a question, Marcia. Where is the, in terms of the second development setback from St. Rain, where is that still in discussion or is that part of regulation? Where does that discussion at? It is part of regulation that there is a 150-foot setback for any development. There is, well, it's stretchy, but it's essentially a checklist of things that you would have to satisfy in terms of benefit to the city or benefit to the environment if anyone wants to apply for a variance to that setback. So it's regulated, it's in code, and the default is 150 feet. On each side from the tree line. So it's pretty far. Okay. Any other questions or comments? Otherwise we need a recommendation. All these take recommendations, right? That's correct. To counsel for approval. We're going to see it here. What's that? Oh, there we go. Urban. Urban. It was always on the move there right now. Wouldn't just wouldn't come up. Somewhere in the United States. Can you see it? It is there. Oh, I see. I forgot I left the refrigerator. I left the refrigerator right there. Oh, the updates. Yeah, unfortunately the computer's on tape, but at the same time we're trying to use it. Yeah, so here, if I'm allowed to hold it. Yeah, so this is where the cat-tails are and here's the river. And actually, I guess this straight line is actually, there's a berm that goes, there's berms here. So, I guess it's not really a wetlands and I guess I'm assuming they're going to have to do some fill where I, I don't know, it's just curious. It's really an interesting spot to develop. That's what it is. It's all lined up. I'm sure you have to do that. Well, it actually though, the lines I was going to say the lines back there, yeah. But this, that obviously captured Okay, I'll move the report to the city council. Okay, we have a motion to recommend this to the city council. Is there a second? Second. Motion is second for their discussion. Hearing none, all those in favor say aye. Aye. Opposed? All right, thank you. So the next one is the Highlands subdivision final plan. The Highlands subdivision final plan is a 52.89 acre parcel located north of the State Highway 119 west of Boad County Road 1. All the historic water rights are transferred to time of annexation. The Highlands subdivision final plan will be in compliance with the city's raw water requirement policy upon satisfaction of the 37.122 acre per deficit at time of final plan approval. So this was part of the level of annexation. The proposal there is for 42 single family detached units, 10 three-story condos kind of an entry level and 67 town homes which are classifying as luxury town homes. We're expecting for this one, the owner's been, or the developer's been acquiring non-historic water rights for some time. He's been working for the city for their inclusionary housing efforts. And so we'll be probably getting non-historic for this. You mean McIntosh or? McIntosh and maybe some oligarchy. Any questions on this? If not, we need a recommendation for approval to the city council on this item as well. I move that we send a recommendation for approval to the city council. Motion, do we have a second? Second. Motion and a second for further discussion. Hearing none, all those in favor say aye. Aye. Opposed? Thank you. The next item is the Mountain Brook subdivision filing one final plan. So the Mountain Brook subdivision filing number one final plan is a 38.05 acre parcel located in south of Rawneers Road in western 4th 95th street. Again, historical water rights were transferred at time of annexation. It will be in compliance with the city's rural water requirement policy upon satisfaction of the 12.563 big foot deficit at time of final cloud approval. So the proposal here is for 92 senior family owns and then eight duplexes. The duplexes will be through the habitat for each committee. And this is the same developer that's developing the prior one that was described and they too plan to use non-historic water rights. That's another affordable house. It's going to be a component of that throughout the entire humanity. So will there be, I know we passed the change to the ordinance or whatever where this could. So to the extent that it affects it again, that would be included. So they're still. And that would come into play with the amount they pay for cash. So it has to be a percentage. On this particular one, the 92 single family owns is greater than the amount. You have to have a greater than whatever the percentage. But with these eight duplexes it didn't trigger that. But I wanted to identify specifically that there was four duplexes that were going to be with the habitat for humanity. Got you, thank you. Any questions on this? If not, we need a recommendation to council. We have a motion for recommending this for approval. The councils are second. Motion is second. Further discussion? All those in favor say aye. Opposed? Thank you. So next one is Mountbrook subdivision filing number two. So right next door to the last one we just talked about also. So Mountbrook subdivision filing number two is the final flat at 28.13 acres. The district historic water rates are transferred to time annexation. This final flat will be interplaced with the all our requirement policy of unsatisfaction of the 9.93 interplated deficit. On this particular flat they're proposing 18 single family detached 120 multi family condos or apartments and 29 town halls. They're describing as a multi year build out so this is going to take a while to fully develop this one. But again the same developer as the prior two plans to use non-historic for the bulk of their satisfaction. So is this curious what they brought through two filings rather than one? I think some of it has to do with the ownership. When this annexed HMS annexation came through there was multiple owners who were part of that annexation. I think there was some of that involved with the different ownership. Yeah, I think there was other reasons I'm not sure what they were. Any other questions? If not is there a recommendation to council for approval? How's the move? Is there a motion? Is there a second? Second. Is there a second for the discussion? Who seconded that because I got a tie on that one. Roger. Roger. You got a vote? Yeah. All right. So no further discussion? All those in favor say aye. Aye. Opposed? Okay. Here we got river set annexation. So the river set annexation is a 7.24 acre parcel located north of Roger's early beast of Sunset Street. No historic water rates per unit for river set annexation. For river set annexation is compliance with the raw water requirement policy at time of annexation and will be at time of final plat approval with satisfaction of the 21.72 acre-foot deficit. So this one is a proposed mixed use employment zoning is what it was given. They're thinking up to 32 live work units in commercial retail but those can be fleshed out when they bring to their flat. Okay. What's the address again on location? It's 18 South Sunset Street 18 South Sunset. It's the northwest corner. Yeah the north, actually the northeast corner of Sunset and so across from Balt Colorado materials so that's an interesting so it's currently a county enclave right? Essentially Essentially there's another piece of it's not yet annexed on the east or the west side of because I noticed on the work that it says Roger Road and I was curious if that was still because it was in the county versus Boston because it's I mean I think it was being Boston now but it says so I was just curious what that was about. Yeah suffice it to say the parcel is correctly north of Colorado materials Yeah it'll be Boston once again. But I was just curious the reason that it's Roger's on the paperwork is because it's still as far as the county is concerned it's Roger's but it's but it is north of Roger's Correct. Well no it's well I'm confused. So Lawson's construction Yeah Lawson's parking is concrete. So Lawson actually owns a lot to the north so this is a piece not owned by Lawson but it's directly adjacent to the county.  Yeah but it's roughly that rectangle there in the northeast corner I'm kidding It's got their development now It's really easy to do this Have you noticed that most of them have just started? But what they're talking about I think it really will create an anchor on that corner that will help facilitate because that whole area from on Boston is going to get over time is going to get redeveloped and by having an anchor there it seems like it just facilitates getting that stuff done I think we'll see probably this year land annexed to the west of Sunset Street so I will probably be coming. Any further questions? Could I just add that's a payoff for doing some of the resilient St. Brain work because I think part of the alleviation of flooding in that area is part of what spurred the development. I'd make a motion to forward to City Council. We have a motion. Is there a second? Second. Motion on a second. Is there a further discussion? Hearing none, all those in favor say aye. Aye. Opposed? Hearing the home stretch here, West Range Filing Number 3 So we're lost to the 6th. West Range Filing Number 3 Final 5 is 29.228 for Marshall located south of Nelson Road, east of North 75th Street. West Range Filing Number 3, final plaque or any compliance with the city's rollout of policy upon satisfaction of a 50.980 conflict deficit approval. So this one is a development that's going to be developed by Markel Holmes planning 143 single family detached residents and on this one they're planning to pay cash and leave. So that will be a good jump into our cash and leave. Any questions on this one? If not, we need a motion for recommendation recommending it for approval to Council. Motion is there a second? Motion on a second. Further discussion? Hearing none, all those in favor say aye. Opposed? If I had them all it's about 885 acre feet between non-historical cash and leave for these 6. So just to keep tallies of how much additional either non-historical. It sounds like the majority is non-historic but quite a bit of it's cash and leave. If we receive the cash and leave payment that's about $500,000 and we need about $3 million but we already know that some of them are going to be non-historic. So yeah, it's another development that we brought through in January for Agilish filing 3. They also plan to be bringing a check-in tomorrow. That will be about a little over $100,000. Comments are good. I'm going to touch your head now with the total number of housing units that we have down here. Close to 1,000? Yeah, it's close to 1,000. Okay, that's close to 1,000. That's a lot. That's a lot. I have to know how many of them are affordable or detainable. I don't know that or Mount Brooklyn. The rest of the L.C. would be worse. Not enough but it would be worse. That'd be 8. It's a city along Mount East Creek, Water District, Rapkow County, Water Authority and United Water IGA for Water Exchange Agreement. Yeah, I'll go ahead and be that one. So as you indicated, short-term water supply exchange agreement we've considered IGA to work with those water districts. As the board may recall, LOMI have been entering for about plus a year now. So the only thing that has changed from year to year is just the year and the actual dates there. So everything's kind of kept the same. The basis of the exchange agreement is water for water. So mainly East Cherry Creek and Arapahoe will use their decree for the consumable water to help meet long months. The ditch loss component of our union reservoir changed to create a sudden significant 222. And the reason it's a benefit to us is that the ditch loss is owed in July and August. And when it gets really hot, we have to get the ditch loss component down to the union ditch headgate, lower lathe of the ditch headgate, and the beech of the ditch headgate. And there's typically a dry up in July and August right around that lower lathe, and the beech is below that. So East Cherry Creek and Arapahoe have their water rights that are actually measured, and they're coming below that dry up. So it's really helpful for us. And they don't have to pay a lot of ditch loss since they have it coming down there. And so then the benefit to them is that Longmont has for the decree for consumable water rights that will help meet their winter return flow obligations to be from November 1st to October 31st. So like I said, it's water for water. And then to both parties, it's been working out well for the last five years, and we'll continue to do that each year. You got a couple of questions there, any other questions? It's so mentioned, social water supply claim that that's what they're gonna use for being able to use Longmont's water. What does Longmont have to do with it? Are you guys allowed for your decree to use their water as a source? So they have to get state engineers' office approval. And then we can use our pool that can consume a water rights the same as them to meet. Because they're decreed for augmentation, replacement, et cetera, et cetera. So as long as it's approved by the state, then it's allowed by both parties. I just wanted to give some supply for you. So they have to get the approval East Cherry Creek Routal United from the state engineers' office. We as Longmont do not, since we are decreed to either replace them. Oh, I see, okay. Follow me. Yep, last item. So they had in here that they can't provide water, any subject political entity or for any use within an urbanized area defined in chapter 14.09. Is that for the tri-cities? With the Longmont municipal code? Both for the water supply reviews on the tri-cities area. As well as any water in the wild against industry. Yeah, okay. And you also saw in there, we have that new paragraph we've added recently for you that it mentions is no, none of this water can be used for water gas. We have it stated right in there now. All right, that was all I had. Was there any? I'm just curious on the ditch losses. I mean, is there any thought of lining the ditch or reducing the losses? So it's a little bit different with these tickets for turnflow and ditch loss. So anyway, as part of the, so when we, when City of Longmont did the change case, so they're not injured, then the water rights that were removed from the ditch is sold union, lower late them and issue. So they're not injured. The other shareholders remaining in those ditches were required that would go through the court process to make sure that they're not impacted. So that's why we have to get the ditch loss to their hanging. So typically what that ditch loss will do is stay in the ditch for, so none of the other remaining shareholders are injured. They don't have to pay any additional on top of what they already have to deliver and follow me since we took the water rights out of that ditch. Okay. I hope I did it. I think I kind of understand. Yeah. It's really been for struggle. Tish Lutz hasn't heard prior to 1986. Okay. With the water rights, that pertains to the water rights that City of Longmont changed. And that's typical for most of the change cases that we do. All right. So the remaining shareholders are not impacted by the change decree in any way. So they're not harmed in any way. Okay. Any other questions? Is there, is the amounts that we exchange every year turn out to be pretty, similar, pretty consistent? What I was thinking of, we exchanged on our end 600, but they only do 300. Is there any adjustment or, how does it work? So how that work faces with John is, is we don't know when we do the exchange agreement now, what exactly the court obligations are gonna be for until we, our field period is done June 30th. So of each year. So we have to have that done into the state by the first week of July. We have to figure out how much was stored in our city of Longmont's account in union reservoir. And then we calculate the place of obligations with the digital. So that's why we put a match number in our 600 acre feet. So once that's calculated, then we know what that number is. And then that's the number they need. And then we have to say Longmont matches that. So it can't exceed, but it can go anywhere between there. And it varies each year on how much we store it. And we were down almost 5,000 acre feet this year in union. And a good portion of that, 85% of the city of Longmont's share of that. But the amount that they provide is the exact amount that Longmont provides, regardless of whatever it is. Okay. They do their part first, and then we match it. We match it. Because there's in July and August and ours is November. Right. So it's equal amount. Water, water. Okay. Of course I would do it because of Longmont, if there's a dry up, and I've said this each year, is we can meet it, the dish loss, we can meet it, but we have to, typically we have to slug it in order to get it all the way down 30 something miles. And then you have the trans cost, sometimes it increases when it gets dry. So we kind of don't have to, as long as we have this exchange agreement, we don't have to. Well, the other benefit you get is you can meet it with that form during the winter, primarily. So if you had to slug it, you'd probably be able to access our unions. The levels are good, lower too, right? Yes. And before this exchange agreement, we were slugging it when it was dry. In some years, we have rainstorms and we don't have to dry up, and it varies from year to year, but typically it's a, it seems like regardless, this is in Longmont's best interest. Yeah, yeah. It's over the long, yeah. Okay. Is there any other questions, comments? Otherwise, they want a recommendation from the Waterborne Council on it. Most likely, I didn't indicate it, but most likely, we'll be going to City Council on March 31st, unless it gets bumped in any way that it'd be here, but for now it's March the last meeting in March. Okay. Is there a motion to make a recommendation to Council for approval of the Intergovernmental Agreement? I would move to make a recommendation for approval of this Intergovernmental Agreement. Okay. The motion is there a second? Second. Motion is second. Further discussion? Hearing none, all those in favor say aye. Opposed? Okay. Thanks, Nelson. Yeah, thank you. Appreciate it. All right. Wes gets to give the good news after a large play up date. So just to kind of follow up with some of the information Nelson in the board, included in the packet is monthly information from a number of sources. The first being the USDA is calling on the WaterSupply Outlook Report. I put that report out each month. Because of this month us being a week later we're pulling a week away from getting the new report. However, suffice it to say, in their February 1st report, they reported that the snowpack in the South Platte River Basin was above normal at 119%. They saw precipitation in January was 79% of average and that brought the water year to date at 99%. Reservoir storage at the end of December was 111% of average compared with 104% last year. So to summarize, we were in better shape than we were in the past. So that was good news. As we move forward a couple pages in your packet, looking at the reservoir storage end of January, a little more specific, we had at least select reservoirs about 838,000 acre feet in storage compared to the year prior, which was about 773,000 acre feet in storage. But an average of 750,000. So the South Platte looks good in terms of storage. Moving forward a couple pages, we as always pay closest attention to the forecast for the same rate for the lions. Again, the expectation for both April through July and the April through September is that we have a greater chance than average of exceeding our stream flow forecast for those periods. So let's keep evolving as we move forward depending most predominantly on the snowback. But as of February 1st, we were expected to have a greater chance than not of having average snowback. The next couple graphs, the South Platte River Basin History, that's for the NRCS. It was reported as a February 19th, a percent of average of around 127% for the South Platte, which was good to see. On the next graph, the upper Colorado was showing at 114%. So both of which were above average. And as you see from either of these graphs, you can see, you pay attention mostly to that. Kind of like last year was indicative of most of them, one good snow in February or March makes a big difference because those are usually so wet. So hopefully we get one or two of those and that'll put us over the hump. So we'll read back that updated information next month. The last page just has the northern waters snow watch information that showed the same thing, everything running above average. This particular one shows that Colvin Lake was significantly above the prior data. So we had good wet snows down low. But we're also, by having those early snows that we see in February and November, that was good because those are the snows that get snowed on top of ice in and out late. So I don't want to jinx it, but right now things look good. Yeah, not good.  Okay. Any questions for Wes on the water status report? Right, great, thank you. 9B is the monthly legislative report, Ken? Yeah, I just wanted to, wanted to update you on two bills. House bill 1097, which was that bill for the interconnected systems. The water rate has been changed to be used in the interconnected system. It died in the House Ag Committee, the post-war was indebted, so that one was died. And Senate Bill 20-153, which was, which we were opposing, to set up a water fee for water projects. It basically required us to have a pretty healthy water rate increase. So long months, customers would have been paying for something else's water project. That was postponed in the Senate Ag Committee. They postponed it indefinitely, so those two bills are done. I did hand out today a copy of the bill. House Bill 1164, it's really just one sentence. Actually, the title of the bill is a bill for an act concerning an exemption of housing authority from certain fees imposed by Water Conservancy District. And so, in the sentence that operative sense is giving an exemption from Water Conservancy District fees, this sentence proposed that in addition, all property of whatever kind or nature owned by housing authority with the Water Conservancy District is exempt from any tap fee or develop an impact fee imposed by the Water Conservancy District. So, we don't have a whole lot of information from the other Water Conservancy Act called Northern. The last I talked to them, their board had not taken a position, but I don't know if they took a, did they take a position? I had a position just before. Okay, so I don't have any of the Water Conservancy District's reactions to it yet. I don't think they would be opposed to it. We're just, it has not, it is, no, excuse me, it is on the House, it's in the second reading on the House, so it's starting to move a little tiny bit. I'd hoped I could just make that for the Water Conservancy District. I guess we're probably leaning towards opposing it for a simple reason that in the language I couldn't find even really a definition of tap-fee or develop an impact fee, it's, it's, if you just read the language, you would presume that that means treated water. The only Water Conservancy District I'm aware of in the state provides treated waters to the Ute and the Water Conservancy District called by Palisade Grand Junction area. And this may be coming out, something going on over there, but I'm not sure I've heard from them their thoughts on it. But I would, I would have preferred to have it defined. And also, it starts to make me uncomfortable whenever you start giving stuff away free by statute. I think it could be, I'd definitely go to positive it's out of city, should provide it free. But once you start this, it's kind of an effort. So I don't know if the board is prepared to take a position yet, because I, of course, I don't have a lot of, but I wanted to highlight it to you and just let you, let you consider it and see if you have an opinion. One way or the other, if not, I'll certainly continue to track it and I can bring back more information next month. Thoughts on that? Do we just monitor? Which one are the people? The people I'm trying to reach out to, you know? So yes, Mechler, so Janice Rich is from Mesa County, which is the Conservancy District. So that's where I suspect that's going from. Karen Becker is here, Boulder. Actually, she represents Boulder, Clark Street, Gilbert, I think she's from Boulder. And Rachel Zenzinger is from Jefferson County. And I don't think it's, I don't suspect it's as much there as she was Janice Rich's because she's from, I don't know if she's ever in Mesa. No, she's, Janice Rich is a Republican from Mesa County. So it's got a little bipartisan support. Karen Becker is Democrat from Boulder. House Districts is from Boulder, but she's from, Rachel is from Jefferson. She's one who responds to it. So it does have both a Senate and a House. And that's really about all I can have here. Unfortunately, I can't give you a strong recognition on the other, the other staff is, I guess, initially opposed to it just because it's pretty. I'm concerned that the tap fee should be defined. I would hate for it to be read like the assessment. You know, the water level is an assessment on CBT units. Everybody pays an equal share divided by I mean, there are 10,000 units. Should somebody say, well, that's an impact fee. That's a tap fee. And of course, more than water, it doesn't want any water. So they don't do tap fees that trouble me what somebody could say that really means. And or for me, it's also that then you start taking it. That's step one. So it sounds like staff's suggesting that we pose as any thoughts on that. So from my perspective with tap fees, development fee, system development charges, assuming that's what they mean. Those are really important that growth pays for growth. And the part that I'm curious about what makes it a housing authority? Some developers say, well, we got a housing authority so we don't have to pay fees in. And you're right. If it's just a treated water conservancy district, doesn't seem to affect us. But I don't, I don't like it. I don't like the precedent. I don't like the precedent, no. I think growth really should pay for growth. I think housing authority is probably otherwise defined in the state statute that it's not defined. It's titled 37, which is water. And it's not defined here. Right. So I agree with you. Again, I believe when I read it, I believe I know what housing authority means. Sure. So do you want to make a motion on that? I don't know that it doesn't seem to apply to us right now, but I'd be comfortable if we wanted to have a motion to oppose this, to recommend that we oppose this. Any other thoughts? It's fine, Lane. Yeah. So what do you guys want to make a motion? And move that we oppose housing for bill 20-1164. Second. Second. So motion a second. Further discussion? Hearing none, all those in favor say aye. Aye. Opposed? Okay. Thank you. Can anything else on that? Thank you. Yeah, I just want to have a decision, Mr. Schmidt. Okay. I see, which is the Windy Gap Permit Project. Yeah, I don't have a whole lot to report. It'll seem like not a lot going on in the Windy Gap Permit Project, but actually there is quite a bit. Almost, there's a legal for all the attorneys for all the cities have been working pretty hard on starting to develop an allotment contract. And we're struggling with the legal committee, struggling with we have a login contract and a operations contract. Do we bring them together? And it's much more complicated than it sounds. And that's fine. We've had two all day sessions and we'll have one more, we've got another one scheduled coming up. So working really hard on that. So hopefully, hopefully in the next month or two, we'll start to see some good progress on that and we'll be able to come before you talk about that. Not a lot of progress on it. Well, no progress since last month we were reported. On the federal case it was reassigned to a different judge because of a backlog on the district court. So it wouldn't surprise me that that's a number of months for the new justice team. Crack the case open and find out what it's about. So nothing on that. On the state water rights case, continuing to have a good conversation, there's still two remaining objectives to continue to have good relations with them but aren't there yet. So I thought it was hoped it would have been done by maybe this month but it looks like it's still a little ways out but that's still annoying. The contractor is, matter of work, getting project proposals together, all the different equipment, determining their methods and meetings and working with the technical staff on that. So that's coming forward so hopefully that's all ready. So right now it's about all we have in the court. Any questions? Okay, thank you, Ken. Item 10 is items from the board, review of major project listings and items currently scheduled for future board meetings. We'll review cash and loo again in March. So next month, is that right? Yeah, and hopefully we'll be able to publish works of natural resource staff, we'll be able to report both on union reservoir and mud rock efforts and then we're expecting to have boards at the report available for you guys to review next month too. Great, sounds good. Any questions on that? Next item is informational items and water board correspondence. I handed out that, sounds like maybe the same report that you had brought. Just the research behind that. Oh good. Press readers. Yeah, I just gave the executive the high level. Yeah, start reading his first. Mine has all the charts and data. That's great. Anyway, I think this just came out, I heard about it just a few days ago so I think it's pretty hot off the presses. Sounds like in general they're talking about hotter temperatures, which part of the result of that is less snowpack and less kind of reflection from the snowpack, which means more maybe heat absorbed and more kind of issues with the remaining snowpack and the water supply. So they're talking, I think in this they're saying every Celsius degree increase means potentially a decrease in supply, river flows by nine percent. So that's pretty scary. I guess the other thing and I guess the one other piece I wanted to maybe relay from my end is so the city for Collins did a climate change analysis in how it would impact their system, including CBT yields. So the Northern District, I went up and we spent about three hours going over that. In general, what I understand is coming is they're saying it'd likely be hotter but there's, and it alluded to it in this report, there isn't really a consensus as to what will happen to precept. It's kind of, I think there may be more variability but they're not sure it's gonna be necessarily less precipitation or more precipitation. That's a little uncertain with the studies today, but there may be more variability. I guess in my mind, big picture is, I know it may have impacts on the windy yet firming project in terms of lower yields and what that means in the Colorado, the flip side of that is you're gonna have more variability. You better have some storage to capture the water and the wet years when you do have supplies to carry over into maybe the more variability in terms of the dry years. So that was just something I wanted to kind of relay and that study that for Collins did, if anybody has interest I can, I think I got a link to the study, I can send that to you guys, but they get pretty deep involved in the modeling of their system and how it would react to higher temperature and more or less precipitation and what that means to the kind of vulnerability or reliability of their system. That's what they were trying to look at and then look at their water policies in relation to that. So anyway, just a couple of thoughts there. I didn't know, I know we went past public and I didn't be heard, but if you wanna, are you going to say that? Well, yeah, I think the key is that everybody thinks that this is a precipitation issue and of course it matters if it's rain or snow, but it isn't just that, that the bare earth because of the higher level of evaporation and transpiration means that you can have as good or even better precip, but end up with less yield because of those losses and that's what's really, this article is saying is going to vary negatively affect the Colorado River, which of course then means that the water right that supposedly might exist at some point in time for windy gap exists in much, much less points in time. Well, once again, it'd be kind of that variability of I think the last few years have shown you may have some good years where you can come, but you may have some bad years too. So the yield may go down, but you're still gonna have some years if you have a good year. Another thing that I guess I've alluded to and they alluded to it at the end of this article is in 2026 is when the current operating guidelines for the Colorado River expire. So they're supposed to before the end of the year start renegotiating five years in advance new rules and that's gonna be key to this whole deal too is how we've got drought contingency plans, but all that is kind of the stop gap until these new operating guidelines come into effect. Cause that's gonna impact the upper base and lower base and kind of relationship in some of the allocation of the water. So there's a lot of variables right now. Anyway, this just kind of highlights a few of those that are common climate as well as kind of administratively. So anyway, thank you for bringing that. I appreciate that. Yeah, so if we can make some copies, I think it's good background information cause you can go to the charts and see what they're talking about in the press release. I appreciate that. I didn't feel like making all the stuff and say so. That's fine. If you could do that, maybe Wes and Ken for the next meeting, that would be a lot of appreciate seeing kind of stuff behind there. Any questions, comments on? Thank you, appreciate it. Anything else from the water board as far as correspondence? Item 12, 12A. So we'll consider Cache and Lou in March. We talked about, we'll have the annual water board report in March as well. Yeah, go ahead. Just drill, we don't have it down though. Reminder of the water board, we've got this spring water users meeting is April 7th in Greeley and it's open now. If you just go to the field, either a call or sign for yourself. That has where she can sign yet. It's in Greeley. And then also, I want to try to get you updated each month on the climate emergency and what the Climate Action Tax Force is doing. So right now they're focusing on renewals, transportation, and energy use. So they haven't launched their water committee yet. All of that effort's coming up. However, on March 3rd, City staff is going to be doing their monthly update to City Council. So that package should be coming out probably tomorrow. Maybe Wednesday. But as soon as that packet comes out, we'll just email you a copy of the packet so you kind of see where it is and where it's out. And I don't know, Marsh, if there's anything else you wanted to, you probably know better than I do. Well, I do know some stuff for the renewables committee. We have several essentially complete recommendations that have been suspended already. I don't know, they don't go past me for the other two committees yet, but the middle of last week, each committee was supposed to submit at least one. So that's kind of where we are in terms of how much volume that we can expect. Anyway, let's show that after this. Okay. Right now, I'm just following the features that I have. Okay, thank you, Ken. For that, that's all we've got on the agenda today. Anything else? Otherwise, I'll adjourn the meeting. Thank you. Yes. Thank you. Good job.