{"title":"Attendance Concern Report","exportedDatetime":"2023-05-24 09:58:45","report":{"reportClass":"Student_Report_EnrolledStudents","title":"Attendance Concern Report","scopes":[{"baseEntityType":1,"referenceDateRange":{"periodType":"ACADEMIC_YEAR","periodOffset":0,"periodCount":1},"filters":[{"fieldClass":"StudentAttendance_RollCallField_StatisticalPresent","fieldParams":{"dateRange":{"periodType":"ACADEMIC_YEAR","periodOffset":0,"periodCount":1}},"conditionClass":"Report_Condition_Statistic_StatisticalValueLessThanOrEqual","conditionParams":{"operand":90},"filterGroupIndex":0,"transformationClass":"Report_Transformation_Self"}]}],"groupings":[],"postGroupingFilters":[],"columns":[{"fieldClass":"Student_Field_Name","fieldParams":[],"transformationClass":"Report_Transformation_Self","targetType":"BASE_MODELS","targetIndex":null,"customLabel":null,"formatterClass":"Field_Formatter_Person_LastNameFirstName","identifier":"column3551","summaryRowFormulaClass":null,"conditionalFormatters":[]},{"fieldClass":"AcademicLevel_Field_ByStudent","fieldParams":{"referenceDateRange":{"periodType":"ACADEMIC_YEAR","periodOffset":0,"periodCount":1}},"transformationClass":"Report_Transformation_Self","targetType":"BASE_MODELS","targetIndex":null,"customLabel":"","formatterClass":"Field_Formatter_Base","identifier":"column3559","summaryRowFormulaClass":null,"conditionalFormatters":[]},{"fieldClass":"RegistrationForm_Field_ByStudent","fieldParams":{"referenceDateRange":{"periodType":"ACADEMIC_YEAR","periodOffset":0,"periodCount":1}},"transformationClass":"Report_Transformation_Self","targetType":"BASE_MODELS","targetIndex":null,"customLabel":"","formatterClass":"Field_Formatter_Base","identifier":"column3557","summaryRowFormulaClass":null,"conditionalFormatters":[]},{"fieldClass":"RegistrationForm_Field_TutorsByStudent","fieldParams":{"referenceDateRange":{"periodType":"ACADEMIC_YEAR","periodOffset":0,"periodCount":1}},"transformationClass":"Report_Transformation_Self","targetType":"BASE_MODELS","targetIndex":null,"customLabel":"","formatterClass":"Field_Formatter_Base","identifier":"column3558","summaryRowFormulaClass":null,"conditionalFormatters":[]},{"fieldClass":"Intervention_Field_ByStudent","fieldParams":{"referenceDateRange":{"periodType":"ACADEMIC_YEAR","periodOffset":0,"periodCount":1}},"transformationClass":"Report_Transformation_Self","targetType":"BASE_MODELS","targetIndex":null,"customLabel":"","formatterClass":"Field_Formatter_Base","identifier":"column3560","summaryRowFormulaClass":null,"conditionalFormatters":[]},{"fieldClass":"StudentAttendance_RollCallField_StatisticalPresent","fieldParams":{"dateRange":{"periodType":"CALENDAR_WEEK","periodOffset":-1,"periodCount":1}},"transformationClass":"Report_Transformation_Self","targetType":"BASE_MODELS","targetIndex":null,"customLabel":"No. of sessions present last week","formatterClass":"Field_Formatter_Statistic_Numerator","identifier":"column3552","summaryRowFormulaClass":"Report_SummaryRow_Formula_Average","conditionalFormatters":[]},{"fieldClass":"StudentAttendance_RollCallField_StatisticalPresent","fieldParams":{"dateRange":{"periodType":"CALENDAR_WEEK","periodOffset":0,"periodCount":1}},"transformationClass":"Report_Transformation_Self","targetType":"BASE_MODELS","targetIndex":null,"customLabel":"No. of sessions present this week","formatterClass":"Field_Formatter_Statistic_Numerator","identifier":"column3553","summaryRowFormulaClass":"Report_SummaryRow_Formula_Average","conditionalFormatters":[]},{"fieldClass":"Field_AdvancedCalculation","fieldParams":{"dataType":"int","formula":"={{ column3553 }}-{{ column3552 }}"},"transformationClass":"Report_Transformation_Self","targetType":"BASE_MODELS","targetIndex":null,"customLabel":"Last week comparison","formatterClass":"Field_Formatter_Numeric_0dp","identifier":"column3562","summaryRowFormulaClass":"Report_SummaryRow_Formula_Average","conditionalFormatters":[{"conditionClass":"Report_Condition_LessThan","conditionParams":{"operand":0},"color":"light_grape_purple"},{"conditionClass":"Report_Condition_GreaterThan","conditionParams":{"operand":0},"color":"light_basil_green"}]},{"fieldClass":"StudentAttendance_RollCallField_StatisticalPresent","fieldParams":{"dateRange":{"periodType":"ACADEMIC_YEAR","periodOffset":0,"periodCount":1}},"transformationClass":"Report_Transformation_Self","targetType":"BASE_MODELS","targetIndex":null,"customLabel":"Attendance this academic year","formatterClass":"Field_Formatter_Statistic_FormattedValue","identifier":"column3554","summaryRowFormulaClass":"Report_SummaryRow_Formula_Average","conditionalFormatters":[]},{"fieldClass":"StudentAttendance_RollCallField_StatisticalAbsent","fieldParams":{"dateRange":{"periodType":"ACADEMIC_YEAR","periodOffset":0,"periodCount":1}},"transformationClass":"Report_Transformation_Self","targetType":"BASE_MODELS","targetIndex":null,"customLabel":"No. of sessions missed ","formatterClass":"Field_Formatter_Statistic_Numerator","identifier":"column3555","summaryRowFormulaClass":"Report_SummaryRow_Formula_Average","conditionalFormatters":[]},{"fieldClass":"Field_AdvancedCalculation","fieldParams":{"dataType":"float","formula":"={{ column3555 }}\/2"},"transformationClass":"Report_Transformation_Self","targetType":"BASE_MODELS","targetIndex":null,"customLabel":"No. of days missed this academic year (All Absence)","formatterClass":"Field_Formatter_Numeric_2dp","identifier":"column3563","summaryRowFormulaClass":"Report_SummaryRow_Formula_Average","conditionalFormatters":[]},{"fieldClass":"StudentAttendance_RollCallField_StatisticalUnauthorizedAbsent","fieldParams":{"dateRange":{"periodType":"ACADEMIC_YEAR","periodOffset":0,"periodCount":1}},"transformationClass":"Report_Transformation_Self","targetType":"BASE_MODELS","targetIndex":null,"customLabel":"Session of unauthorised absence this year","formatterClass":"Field_Formatter_Statistic_Numerator","identifier":"column3556","summaryRowFormulaClass":"Report_SummaryRow_Formula_Average","conditionalFormatters":[]},{"fieldClass":"Field_AdvancedCalculation","fieldParams":{"dataType":"float","formula":"={{ column3556 }}\/2"},"transformationClass":"Report_Transformation_Self","targetType":"BASE_MODELS","targetIndex":null,"customLabel":"No. of Days missed this academic year due to unauthorised absence","formatterClass":"Field_Formatter_Numeric_2dp","identifier":"column3564","summaryRowFormulaClass":"Report_SummaryRow_Formula_Average","conditionalFormatters":[]},{"fieldClass":"StudentAttendance_RollCallField_CustomNumeratorDenominatorStatistic","fieldParams":{"numeratorSpecificMarks":{"collection":[{"objectTypeId":150,"code":"NO_REASON"},{"objectTypeId":150,"code":"DUAL_REGISTRATION"},{"objectTypeId":150,"code":"FAMILY_HOLIDAY_AGREED"},{"objectTypeId":150,"code":"EXTENDED_FAMILY_HOLIDAY_NOT_AGREED"},{"objectTypeId":150,"code":"UK_DFE__I01"},{"objectTypeId":150,"code":"ILLNESS"},{"objectTypeId":150,"code":"UK_DFE__COVID19_ILL_CONFIRMED_C19"},{"objectTypeId":150,"code":"INTERVIEW"},{"objectTypeId":150,"code":"LATE_AFTER_REGISTER_CLOSES"},{"objectTypeId":150,"code":"LATE"},{"objectTypeId":150,"code":"MEDICAL_DENTAL_APPOINTMENT"},{"objectTypeId":150,"code":"OTHER_AUTHORISED_ABSENCE"},{"objectTypeId":150,"code":"PRESENT_AM"},{"objectTypeId":150,"code":"PRESENT_PM"},{"objectTypeId":150,"code":"RELIGIOUS_OBSERVANCE"},{"objectTypeId":150,"code":"SPORTING_ACTIVITY_APPROVED"},{"objectTypeId":150,"code":"STUDY_LEAVE"},{"objectTypeId":150,"code":"TRAVELLER_ABSENCE"},{"objectTypeId":150,"code":"UNAUTHORISED_ABSENT"},{"objectTypeId":150,"code":"WORK_EXPERIENCE"}]},"denominatorSpecificMarks":{"collection":[{"objectTypeId":150,"code":"NO_REASON"},{"objectTypeId":150,"code":"DUAL_REGISTRATION"},{"objectTypeId":150,"code":"EDUCATIONAL_TRIP"},{"objectTypeId":150,"code":"FAMILY_HOLIDAY_AGREED"},{"objectTypeId":150,"code":"EXTENDED_FAMILY_HOLIDAY_NOT_AGREED"},{"objectTypeId":150,"code":"UK_DFE__I01"},{"objectTypeId":150,"code":"ILLNESS"},{"objectTypeId":150,"code":"UK_DFE__COVID19_ILL_CONFIRMED_C19"},{"objectTypeId":150,"code":"INTERVIEW"},{"objectTypeId":150,"code":"LATE_AFTER_REGISTER_CLOSES"},{"objectTypeId":150,"code":"LATE"},{"objectTypeId":150,"code":"MEDICAL_DENTAL_APPOINTMENT"},{"objectTypeId":150,"code":"OTHER_AUTHORISED_ABSENCE"},{"objectTypeId":150,"code":"PRESENT_AM"},{"objectTypeId":150,"code":"PRESENT_PM"},{"objectTypeId":150,"code":"RELIGIOUS_OBSERVANCE"},{"objectTypeId":150,"code":"SPORTING_ACTIVITY_APPROVED"},{"objectTypeId":150,"code":"STUDY_LEAVE"},{"objectTypeId":150,"code":"TRAVELLER_ABSENCE"},{"objectTypeId":150,"code":"UNAUTHORISED_ABSENT"},{"objectTypeId":150,"code":"WORK_EXPERIENCE"}]},"dateRange":{"periodType":"ACADEMIC_YEAR","periodOffset":0,"periodCount":1}},"transformationClass":"Report_Transformation_Self","targetType":"BASE_MODELS","targetIndex":null,"customLabel":"","formatterClass":"Field_Formatter_Statistic_Numerator","identifier":"column3561","summaryRowFormulaClass":"Report_SummaryRow_Formula_Average","conditionalFormatters":[]},{"fieldClass":"Field_AdvancedCalculation","fieldParams":{"dataType":"string","formula":"=IF(IF({{ column3562 }}<1,\"1\",\"0\")+IF({{ column3553 }}<10,\"1\",\"0\")+IF({{ column3554 }}<90,\"1\",\"0\")=3,\"Concern\",\"Monitoring\")"},"transformationClass":"Report_Transformation_Self","targetType":"BASE_MODELS","targetIndex":null,"customLabel":"Concern?","formatterClass":"Field_Formatter_Base","identifier":"column3565","summaryRowFormulaClass":null,"conditionalFormatters":[]}],"orderings":[{"fieldClass":"RegistrationForm_Field_ByStudent","fieldParams":{"referenceDateRange":{"periodType":"ACADEMIC_YEAR","periodOffset":0,"periodCount":1}},"direction":"ASC","targetType":"BASE_MODELS","targetIndex":null,"transformationClass":"Report_Transformation_Self"}],"collations":[]}}