--- reportDefinition: ! description: "Absence or Attendance Report similar to Classic ABS101. Sort by Employee\ \ Name. Subtotals by Category and includes column for Leave Balances." tags: null predefined: false parameters: ! pageSize: "LETTER" pageOrientation: "PORTRAIT" outputFormat: "PDF" templateName: "Absence-Attendance Report" suppressDetail: false showOptions: false queryParameters: ! {} title: "Absence-Attendance Report" querySpecification: specification: "activityDate.between param(\"startDate\",\"f\"),param(\"endDate\"\ ,\"l\")\nemployee.number.like param(\"employee.number\",\"\",\"Employee Number\"\ )\nposition.jobStatus.oneOf ([param(\"jobStatus\",'',\"Job Status (Active, Inactive,\ \ Deceased, Terminated)\")])\nposition.appointmentType.oneOf ([param(\"apptType\"\ ,'',\"Appointment Type (Certificated, Classified)\")])\ntype.oneOf ([param(\"\ type\",'Absence',\"Type (Attendance, Absence)\")])" querySpecParameters: ! [] entity: "org.ssdt_ohio.usps.model.attendancejournal.AttendanceJournal" properties: ! - ! description: "Number" type: "java.lang.String" propertyName: "number" propertyPath: "employee" entityName: "Employee" sortOrder: 2 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "employee.number" dataSourcePath: path: ! [] currentPath: ! - "employee" columnOrder: 1 suppressRepeating: true - ! description: "Full Name" type: "java.lang.String" propertyName: "fullName" propertyPath: "employee.name" entityName: "Name" sortOrder: 1 controlBreak: true suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "METHOD" label: "" columnTitle: "Name" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 30 relativePropertyName: "employee.name.fullName" dataSourcePath: path: ! [] currentPath: ! - "employee" - "name" columnOrder: 2 suppressRepeating: false - ! description: "Activity Date" type: "java.util.Calendar" propertyName: "activityDate" propertyPath: null entityName: "AttendanceJournal" sortOrder: 4 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "CALENDAR" source: "FIELD" label: null columnTitle: null alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 13 relativePropertyName: "activityDate" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 3 suppressRepeating: false - ! description: "Position Number" type: "java.lang.Integer" propertyName: "number" propertyPath: "position" entityName: "Position" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "NONE" source: "FIELD" label: null columnTitle: null alignment: "CENTER" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 5 relativePropertyName: "position.number" dataSourcePath: path: ! [] currentPath: ! - "position" columnOrder: 4 suppressRepeating: false - ! description: "Day Of Week" type: "java.lang.String" propertyName: "dayOfWeek" propertyPath: null entityName: "AttendanceJournal" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "METHOD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "dayOfWeek" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 5 suppressRepeating: false - ! description: "Length" type: "java.math.BigDecimal" propertyName: "length" propertyPath: null entityName: "AttendanceJournal" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: "Sum" baseClassProperty: false format: null source: "FIELD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "length" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 6 suppressRepeating: false - ! description: "Unit" type: "org.ssdt_ohio.usps.model.constants.AttendanceItemUnit" propertyName: "unit" propertyPath: null entityName: "AttendanceJournal" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "unit" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 7 suppressRepeating: false - ! description: "Category" type: "org.ssdt_ohio.usps.model.constants.AttendanceItemCategory" propertyName: "category" propertyPath: null entityName: "AttendanceJournal" sortOrder: 3 controlBreak: true suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "category" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 8 suppressRepeating: false - ! description: "Balance" type: "java.math.BigDecimal" propertyName: "balance" propertyPath: "leaveTransaction.leave" entityName: "Leave" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "DEFAULT" source: "METHOD" label: "" columnTitle: "Balance" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "leaveTransaction.leave.balance" dataSourcePath: path: ! [] currentPath: ! - "leaveTransaction" - "leave" columnOrder: 9 suppressRepeating: true