trigger CreateAdmissionRecord on School__c (after insert, after update) 
{
        Student_Trigger__c TT = Student_Trigger__c.getvalues(UserInfo.getProfileId());
        set<id> triggerIds = trigger.newMap.keyset();
        List <Admission__c> Project = [select id, Name,Deal__r.Student__r.Name from Admission__c where id in :triggerIds];
        List <Admission__c> newadmissions = new List<Admission__c>() ;
    	
        for(School__c scool : [Select id,Name,Type__c,Status__c,Manager__c,  Class__r.Name, Class__c,Unit__c,New_Flag__c from School__c where id in :triggerIds])
        {
		// the below line is to active or de active the trigger in production from CUSTOM SETTINGS
                if((TT.Active__c == TRUE) 
                &&
				// While INSERTING or UPDATE the school record, a New Admission record to be created based 
				// on the below condition[if Type__c = New and Status__c = changed]
               (scool.Type__c == 'New') 
                && 
                (scool.Status__c == 'Changed')
            	{
				// the below string tries to check for duplicate names and avoid creating duplicate records. 
                string Name = scool.Name + ' - ' + scool.Class__r.Name;
                    List <Admission__c> ProjectList = [select id, Name,Deal__r.Class__r.Name from Admission__c where Name =: Name];
                    if (ProjectList.size() > 0)
                    {
                      if(!ProjectList.isEmpty())
						insert newadmissions;
                    }
                    else{
                    newadmissions.add(new Admission__c
                                  (
                                      Name = scool.Name + ' - ' + scool.Class__r.Name, 
                                      OwnerId = scool.Manager__c,
                                      Status__c = 'Project Not Started',
                                      Unit__c = scool.Unit__c,
                                      New_Unit__c = scool.New_Flag__c  
                                  )
                                 );
            }
        }
    
        insert newadmissions;
    }
}