Where Does the Data Come From on the PDE-4062 Detail Report

Days in Session

Total number of days in membership for the building and calendar from reg_calendar.

Aggregate Days Attendance

Count of membership days (from att_stu_day_memb) – sum of absence values (from att_stu_day_totals) for the student

Membership (Resident)

Student's sum of membership values where the View Type = prompted View Type and attendance_date is in the range specified by the Dates prompt and the student's reg_entry_with record where Residency program value (Administration > Registration Setup > Setup > Program Setup where Program has state_code_equiv= 'RESIDENT') is equal to a regtb_residency where state_code_equiv = 'A'

Membership (Non-Resident)

Student's sum of membership values where the View Type = prompted View Type and attendance_date is in the range specified by the Dates prompt and the student's reg_entry_with record where Residency program value (Administration > Registration Setup > Setup > Program Setup where Program has state_code_equiv= 'RESIDENT') is a regtb_residency where state_code_equiv != 'A' (does not equal Active)

Total Membership

Sum of Resident and Non-Resident Membership

Residence Code

Student's Residency program value for the range specified  by the Dates prompt and reg_entry_with record.  Use the programs_value for the Program with reg_program_column.state_code_equiv = 'RESIDENT'

Average Daily Membership

Total Membership / Days in Session.