Nightly UG - POISE Layout

Folder: Josh's Reports | Scope: organization | Modified: 2024-11-05T21:55:54.000Z | Id: 00O5x000007qvrsEAA

Filters

Filter Logic: 1 AND 2 AND 3 AND 4 AND (5 OR (6 AND 7))

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

#	Field	Operator	Value
1	`EnrollmentrxRx__Enrollment_Opportunity__c.Student_Type__c`	equals	`Undergraduate`
2	`EnrollmentrxRx__Enrollment_Opportunity__c.Term__c`	equals	`Fall 2025,Spring 2025,1st Summer 2025,2nd Summer 2025`
3	`CUST_LAST_UPDATE`	greaterOrEqual	`YESTERDAY`
4	`EnrollmentrxRx__Enrollment_Opportunity__c.Admissions_Substatus__c`	equals	`Conditionally Accepted,Exempt/Not First-Time,Program Review,Unconditionally Accepted,Withdrew`
5	`EnrollmentrxRx__Enrollment_Opportunity__c.Concurrently_Enrolled__c`	equals	`No`
6	`EnrollmentrxRx__Enrollment_Opportunity__c.Concurrently_Enrolled__c`	equals	`Concurrent H.S. Junior,Concurrent H.S. Senior,Dual-Enrolled`
7	`EnrollmentrxRx__Enrollment_Opportunity__c.Term__c`	equals	`Spring 2025,Fall 2025`

Columns

CUST_NAME
FK_Contact.hed__Social_Security_Number__c
FK_NAME
EnrollmentrxRx__Enrollment_Opportunity__c.EnrollmentrxRx__Applicant_First_Name__c
FK_MIDDLE_NAME
FK_SUFFIX
FK_Contact.Previous_Last_Names__c
FK_CNTC_BIRTHDATE
FK_Contact.Ethnicity_New__c
FK_Contact.OtherCountry__c
FK_Contact.hed__Gender__c
FK_CNTC_PHONE4
FK_Contact.hed__WorkPhone__c
FK_CNTC_PHONE3
FK_CNTC_ADDR1_LINE1
FK_CNTC_ADDR1_LINE2
FK_Contact.OtherCity__c
FK_Contact.OtherState__c
FK_Contact.OtherZipCode__c
FK_CNTC_ADDR1_COUNTRY
FK_Contact.Family_Contact__c
FK_Contact.Family_Name__c
FK_Contact.Family_Street_1__c
FK_Contact.Family_Street_2__c
FK_Contact.Family_City__c
FK_Contact.Family_State__c
FK_Contact.Family_Zip__c
FK_Contact.Family_Country__c
FK_CNTC_EMAIL
EnrollmentrxRx__Enrollment_Opportunity__c.County_of_Residence__c
EnrollmentrxRx__Enrollment_Opportunity__c.State_of_Residence__c
EnrollmentrxRx__Enrollment_Opportunity__c.State_of_Current_Living_Residence__c
EnrollmentrxRx__Enrollment_Opportunity__c.Contiguous_County__c
EnrollmentrxRx__Enrollment_Opportunity__c.Undocumented_Student__c
EnrollmentrxRx__Enrollment_Opportunity__c.Billing_Code__c
EnrollmentrxRx__Enrollment_Opportunity__c.Residence_Code__c
EnrollmentrxRx__Enrollment_Opportunity__c.Account_Number__c
EnrollmentrxRx__Enrollment_Opportunity__c.Immunization_Code__c
EnrollmentrxRx__Enrollment_Opportunity__c.Student_Classification__c
EnrollmentrxRx__Enrollment_Opportunity__c.Admissions_Substatus__c
EnrollmentrxRx__Enrollment_Opportunity__c.Original_Entrance_Term_Display__c
EnrollmentrxRx__Enrollment_Opportunity__c.Matriculation_Term__c
EnrollmentrxRx__Enrollment_Opportunity__c.Degree_Intent__c
EnrollmentrxRx__Enrollment_Opportunity__c.Program__c
EnrollmentrxRx__Enrollment_Opportunity__c.Classification__c
EnrollmentrxRx__Enrollment_Opportunity__c.High_School_Diploma_Type__c
EnrollmentrxRx__Enrollment_Opportunity__c.Primary_High_School_CEEB__c
EnrollmentrxRx__Enrollment_Opportunity__c.Primary_HS_Rank__c
EnrollmentrxRx__Enrollment_Opportunity__c.Primary_HS_Size__c
EnrollmentrxRx__Enrollment_Opportunity__c.Primary_HS_Grad_Year__c
EnrollmentrxRx__Enrollment_Opportunity__c.Primary_HS_GPA__c
EnrollmentrxRx__Enrollment_Opportunity__c.Primary_HS_GPA_Scale__c
EnrollmentrxRx__Enrollment_Opportunity__c.GED_Score__c
EnrollmentrxRx__Enrollment_Opportunity__c.High_School_Algebra__c
EnrollmentrxRx__Enrollment_Opportunity__c.ACT_Superscore__c
EnrollmentrxRx__Enrollment_Opportunity__c.ACT_Math_Superscore__c
EnrollmentrxRx__Enrollment_Opportunity__c.ACT_English_Superscore__c
EnrollmentrxRx__Enrollment_Opportunity__c.ACT_Reading_Superscore__c
EnrollmentrxRx__Enrollment_Opportunity__c.ACT_Science_Superscore__c
EnrollmentrxRx__Enrollment_Opportunity__c.SAT_Math__c
EnrollmentrxRx__Enrollment_Opportunity__c.SAT_Reading_Writing__c
EnrollmentrxRx__Enrollment_Opportunity__c.Assett_Elementary_Algebra_Score__c
EnrollmentrxRx__Enrollment_Opportunity__c.Assett_Intermediate_Algebra_Score__c
EnrollmentrxRx__Enrollment_Opportunity__c.Assett_Numeric_Score__c
EnrollmentrxRx__Enrollment_Opportunity__c.Assett_Reading_Score__c
EnrollmentrxRx__Enrollment_Opportunity__c.Assett_Writing_Score__c
EnrollmentrxRx__Enrollment_Opportunity__c.Compass_Algebra_Score__c
EnrollmentrxRx__Enrollment_Opportunity__c.Compass_Reading_Score__c
EnrollmentrxRx__Enrollment_Opportunity__c.Compass_Writing_Score__c
EnrollmentrxRx__Enrollment_Opportunity__c.Accuplacer_Algebra_Score__c
EnrollmentrxRx__Enrollment_Opportunity__c.Accuplacer_Reading_Score__c
EnrollmentrxRx__Enrollment_Opportunity__c.Accuplacer_Writing_Score__c
EnrollmentrxRx__Enrollment_Opportunity__c.NG_Accuplacer_Algebra_Score__c
EnrollmentrxRx__Enrollment_Opportunity__c.NG_Accuplacer_Reading_Score__c
EnrollmentrxRx__Enrollment_Opportunity__c.NG_Accuplacer_Writing_Score__c
EnrollmentrxRx__Enrollment_Opportunity__c.Concurrently_Enrolled__c
EnrollmentrxRx__Enrollment_Opportunity__c.Term__c
EnrollmentrxRx__Enrollment_Opportunity__c.Total_Transfer_Hours__c
EnrollmentrxRx__Enrollment_Opportunity__c.Primary_College_CEEB__c
EnrollmentrxRx__Enrollment_Opportunity__c.Technical_College__c
EnrollmentrxRx__Enrollment_Opportunity__c.Probation__c
EnrollmentrxRx__Enrollment_Opportunity__c.Admission_Hold__c
EnrollmentrxRx__Enrollment_Opportunity__c.Roger_Phillips_ACT__c
EnrollmentrxRx__Enrollment_Opportunity__c.Date_Confirmed__c
FK_Contact.BAM_Date__c
EnrollmentrxRx__Enrollment_Opportunity__c.Advising_Placement__c
EnrollmentrxRx__Enrollment_Opportunity__c.Advising_GPA__c
EnrollmentrxRx__Enrollment_Opportunity__c.First_Generation__c

Raw JSON

Download JSON