BAM Parent Reminder Email List 5-28

Filters

Filter Logic: 1 AND (2 OR 3) AND (4 OR 5 OR 8) AND 6 AND 7 AND 9 AND 10 AND 11 AND 12

Standard Date Filter
Field: EnrollmentrxRx__Enrollment_Opportunity__c.Date_Active__c
Duration: CUSTOM
Start: -
End: -

#	Field	Operator	Value
1	`EnrollmentrxRx__Enrollment_Opportunity__c.EnrollmentrxRx__Admissions_Status__c`	equals	`Admit,Confirmed,Registered`
2	`EnrollmentrxRx__Enrollment_Opportunity__c.Reporting_Student_Type__c`	equals	`Undergraduate`
3	`EnrollmentrxRx__Enrollment_Opportunity__c.Student_Type__c`	equals	`Undergraduate`
4	`EnrollmentrxRx__Enrollment_Opportunity__c.Primary_HS_Grad_Year__c`	equals	`2024`
5	`FK_Contact.HS_Grad_Year__c`	equals	`2024`
6	`FK_Contact.Cancel_Student_Date__c`	equals
7	`FK_Contact.BAM_Date__c`	equals
8	`FK_Contact.Active_Application_HS_Grad_Year__c`	equals	`2024`
9	`FK_Contact.Active_Application_Admit_Type__c`	notEqual	`Transfer`
10	`EnrollmentrxRx__Enrollment_Opportunity__c.Reporting_Student_Classification__c`	notEqual	`Concurrent`
11	`EnrollmentrxRx__Enrollment_Opportunity__c.Reporting_Term__c`	notEqual	`Spring 2025,Spring 2024,Fall 2023`
12	`EnrollmentrxRx__Enrollment_Opportunity__c.Date_Admit__c`	greaterThan	`2024-02-05`

FK_CNTC_ID
CUST_NAME
FK_Contact.Family_Email__c
FK_NAME
EnrollmentrxRx__Enrollment_Opportunity__c.EnrollmentrxRx__Applicant_First_Name__c
EnrollmentrxRx__Enrollment_Opportunity__c.EnrollmentrxRx__Email_Address__c
EnrollmentrxRx__Enrollment_Opportunity__c.EnrollmentrxRx__Admissions_Status__c
EnrollmentrxRx__Enrollment_Opportunity__c.Reporting_Student_Classification__c
EnrollmentrxRx__Enrollment_Opportunity__c.Reporting_Student_Type__c
EnrollmentrxRx__Enrollment_Opportunity__c.Date_Admit__c
FK_Contact.Decision_Letter_Date__c
EnrollmentrxRx__Enrollment_Opportunity__c.Primary_HS_Grad_Year__c
FK_Contact.HS_Grad_Year__c
EnrollmentrxRx__Enrollment_Opportunity__c.Reporting_Term__c
EnrollmentrxRx__Enrollment_Opportunity__c.Term__c
FK_Contact.Active_Application_Term__c
FK_CNTC_ADDR1_STREET
FK_CNTC_ADDR1_LINE1
FK_CNTC_ADDR1_LINE2
FK_CNTC_ADDR1_CITY
FK_CNTC_ADDR1_STATE
FK_CNTC_ADDR1_ZIP
FK_CNTC_PHONE3
EnrollmentrxRx__Enrollment_Opportunity__c.Mobile_Phone__c
FK_Contact.BAM_Postcard_Date__c
FK_Contact.Pre_Registration_Date__c
FK_Contact.BAM_Date__c