(1 OR 2 OR 6) AND 3 AND 4 AND 5 AND 7 AND 8EnrollmentrxRx__Enrollment_Opportunity__c.Date_Active__c| # | Field | Operator | Value |
|---|---|---|---|
| 1 | EnrollmentrxRx__Enrollment_Opportunity__c.Primary_HS_Grad_Year__c | equals | 2023 |
| 2 | FK_Contact.HS_Grad_Year__c | equals | 2023 |
| 3 | EnrollmentrxRx__Enrollment_Opportunity__c.EnrollmentrxRx__Admissions_Status__c | equals | Admit,Confirmed |
| 4 | FK_Contact.Housing_Postcard_Date__c | equals | |
| 5 | FK_Contact.Housing_Application_Date__c | equals | |
| 6 | FK_Contact.Active_Application_HS_Grad_Year__c | equals | 2023 |
| 7 | FK_Contact.Housing_Residence_Hall__c | equals | |
| 8 | FK_Contact.Cancel_Student_Date__c | notEqual | |
CUST_NAMEFK_NAMEEnrollmentrxRx__Enrollment_Opportunity__c.EnrollmentrxRx__Applicant_First_Name__cFK_CNTC_EMAILFK_CREATEDEnrollmentrxRx__Enrollment_Opportunity__c.EnrollmentrxRx__Admissions_Status__cFK_Contact.Date_Admit__cFK_CNTC_ADDR1_LINE1FK_CNTC_ADDR1_CITYFK_CNTC_ADDR1_LINE2FK_CNTC_ADDR1_ZIPFK_Contact.OtherZipCode__cFK_CNTC_ADDR1_STATEFK_CREATED_DATEFK_CNTC_IDFK_Contact.Housing_Application_Date__cFK_Contact.Housing_Postcard_Date__cFK_Contact.Counselor_Postcard_Date__cFK_Contact.Viewbook_Date__cFK_Contact.Decision_Letter_Date__cEnrollmentrxRx__Enrollment_Opportunity__c.Date_Admit__cFK_Contact.Active_Application_HS_Grad_Year__cEnrollmentrxRx__Enrollment_Opportunity__c.Primary_HS_Grad_Year__cFK_Contact.HS_Grad_Year__cEnrollmentrxRx__Enrollment_Opportunity__c.Mobile_Phone__cFK_CNTC_PHONE3