--- reportDefinition: ! description: "Lists activity dates for substitutes and who they subbed for" tags: "Attendance" predefined: false parameters: ! pageSize: "LETTER" pageOrientation: "LANDSCAPE" outputFormat: "PDF" templateName: "Attendance Journal Report" suppressDetail: false showOptions: false sortProperties: ! - ! propertyName: "employee.number" label: "Number" ascending: true controlBreak: false pageBreak: false - propertyName: "employee.name.fullName" label: "Full Name" ascending: true controlBreak: true pageBreak: false - propertyName: "activityDate" label: "Activity Date" ascending: true controlBreak: false pageBreak: false queryParameters: ! {} title: "Attendance Journal Report" querySpecification: specification: "activityDate.between param(\"startDate\",\"\"),param(\"endDate\"\ ,\"\")\nposition.appointmentType.oneOf ([param(\"apptType\",'',\"Appointment\ \ Type (Certificated, Classified)\")])\nposition.payGroup.code.oneOf ([param(\"\ code\",'',\"Pay Group Code(s)\")])\nposition.positionDescription.oneOf ([param(\"\ positionDescription\",'',\"Position Description(s)\")])\ncategory.eq param(\"\ category\",\"Substituting\",\"Category\")\nemployee.name.lastName.oneOf ([param(\"\ lastName\",'',\"Subs Last Name(s)\")])\nemployee.name.firstName.oneOf ([param(\"\ firstName\",'',\"Subs First Name(s)\")])" querySpecParameters: ! [] entity: "org.ssdt_ohio.usps.model.attendancejournal.AttendanceJournal" properties: ! - ! description: "Number" type: "java.lang.String" propertyName: "number" propertyPath: "employee" entityName: "Employee" sortOrder: 1 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: null columnTitle: "Substitute's Name" alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 24 relativePropertyName: "employee.name.fullName" dataSourcePath: path: ! [] currentPath: ! - "employee" - "name" columnOrder: 2 suppressRepeating: true - ! description: "Activity Date" type: "java.util.Calendar" propertyName: "activityDate" propertyPath: null entityName: "AttendanceJournal" sortOrder: 2 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "CALENDAR" source: "FIELD" label: null columnTitle: null alignment: "CENTER" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 15 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: 11 relativePropertyName: "position.number" dataSourcePath: path: ! [] currentPath: ! - "position" columnOrder: 4 suppressRepeating: false - ! description: "Position Description" type: "java.lang.String" propertyName: "positionDescription" propertyPath: "position" entityName: "Position" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Position Description" alignment: "CENTER" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 22 relativePropertyName: "position.positionDescription" dataSourcePath: path: ! [] currentPath: ! - "position" columnOrder: 5 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: 6 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: null 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: 7 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: 8 suppressRepeating: false - ! description: "Category" type: "org.ssdt_ohio.usps.model.constants.AttendanceItemCategory" propertyName: "category" 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: "category" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 9 suppressRepeating: false - ! description: "Type" type: "org.ssdt_ohio.usps.model.constants.AttendanceJournalType" propertyName: "type" propertyPath: null entityName: "AttendanceJournal" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Type" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "type" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 10 suppressRepeating: false - ! description: "Full Name" type: "java.lang.String" propertyName: "fullName" propertyPath: "substituteFor.name" entityName: "Name" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "METHOD" label: "" columnTitle: "Substitute For" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 22 relativePropertyName: "substituteFor.name.fullName" dataSourcePath: path: ! [] currentPath: ! - "substituteFor" - "name" columnOrder: 11 suppressRepeating: false