Where Does the Data Come From on the PDE-4062 Detail Report
Name | Description |
---|---|
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. |