--- reportDefinition: ! description: "Compensation Report" tags: "" predefined: false parameters: ! pageSize: "LETTER" pageOrientation: "PORTRAIT" outputFormat: "CSV" templateName: "Compensation Report" suppressDetail: false queryParameters: null title: "Compensation Report" entity: "org.ssdt_ohio.usps.model.position.Compensation" properties: ! - ! description: "Last Name" type: "java.lang.String" propertyName: "lastName" propertyPath: "position.employee.name" entityName: "Name" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "Last Name" alignment: "LEFT" controlHeaderOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "position.employee.name.lastName" dataSourcePath: path: ! [] currentPath: ! - "position" - "employee" - "name" columnOrder: 1 suppressRepeating: false - ! description: "First Name" type: "java.lang.String" propertyName: "firstName" propertyPath: "position.employee.name" entityName: "Name" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "First Name" alignment: "LEFT" controlHeaderOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "position.employee.name.firstName" dataSourcePath: path: ! [] currentPath: ! - "position" - "employee" - "name" columnOrder: 2 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: null columnTitle: "Position Description" alignment: "LEFT" controlHeaderOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "position.positionDescription" dataSourcePath: path: ! [] currentPath: ! - "position" columnOrder: 3 suppressRepeating: false - ! description: "Type" type: "org.ssdt_ohio.usps.model.constants.CompensationType" propertyName: "type" propertyPath: null entityName: "Compensation" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "Type" alignment: "LEFT" controlHeaderOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "type" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 4 suppressRepeating: false - ! description: "Job Status" type: "org.ssdt_ohio.usps.model.constants.JobStatus" propertyName: "jobStatus" propertyPath: "position" entityName: "Position" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "Job Status" alignment: "LEFT" controlHeaderOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "position.jobStatus" dataSourcePath: path: ! [] currentPath: ! - "position" columnOrder: 5 suppressRepeating: false - ! description: "American Indian Alaska Native" type: "java.lang.Boolean" propertyName: "americanIndianAlaskaNative" propertyPath: "position.employee.race" entityName: "Race" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "American Indian Alaska Native" alignment: "LEFT" controlHeaderOnly: false detailHeaderOnly: false width: 10 relativePropertyName: "position.employee.race.americanIndianAlaskaNative" dataSourcePath: path: ! [] currentPath: ! - "position" - "employee" - "race" columnOrder: 6 suppressRepeating: false - ! description: "Asian" type: "java.lang.Boolean" propertyName: "asian" propertyPath: "position.employee.race" entityName: "Race" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "Asian" alignment: "LEFT" controlHeaderOnly: false detailHeaderOnly: false width: 6 relativePropertyName: "position.employee.race.asian" dataSourcePath: path: ! [] currentPath: ! - "position" - "employee" - "race" columnOrder: 7 suppressRepeating: false - ! description: "Black" type: "java.lang.Boolean" propertyName: "black" propertyPath: "position.employee.race" entityName: "Race" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "Black" alignment: "LEFT" controlHeaderOnly: false detailHeaderOnly: false width: 6 relativePropertyName: "position.employee.race.black" dataSourcePath: path: ! [] currentPath: ! - "position" - "employee" - "race" columnOrder: 8 suppressRepeating: false - ! description: "Hispanic Latino Option" type: "org.ssdt_ohio.usps.model.constants.HispanicLatinoOptions" propertyName: "hispanicLatinoOption" propertyPath: "position.employee.race" entityName: "Race" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "Hispanic Latino Option" alignment: "LEFT" controlHeaderOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "position.employee.race.hispanicLatinoOption" dataSourcePath: path: ! [] currentPath: ! - "position" - "employee" - "race" columnOrder: 9 suppressRepeating: false - ! description: "Native Hawaiian Pacific Islander" type: "java.lang.Boolean" propertyName: "nativeHawaiianPacificIslander" propertyPath: "position.employee.race" entityName: "Race" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "Native Hawaiian Pacific Islander" alignment: "LEFT" controlHeaderOnly: false detailHeaderOnly: false width: 10 relativePropertyName: "position.employee.race.nativeHawaiianPacificIslander" dataSourcePath: path: ! [] currentPath: ! - "position" - "employee" - "race" columnOrder: 10 suppressRepeating: false - ! description: "White" type: "java.lang.Boolean" propertyName: "white" propertyPath: "position.employee.race" entityName: "Race" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "White" alignment: "LEFT" controlHeaderOnly: false detailHeaderOnly: false width: 6 relativePropertyName: "position.employee.race.white" dataSourcePath: path: ! [] currentPath: ! - "position" - "employee" - "race" columnOrder: 11 suppressRepeating: false - ! description: "Hours In Day" type: "java.math.BigDecimal" propertyName: "hoursInDay" propertyPath: null entityName: "Compensation" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: "Sum" baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "Hours In Day" alignment: "RIGHT" controlHeaderOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "hoursInDay" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 12 suppressRepeating: false - ! propertyName: "gender" reportableProperty: ! description: "Gender" type: "java.lang.String" propertyName: "customFields.gender.value" propertyPath: "position.employee" entityName: "Employee" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: null label: null columnTitle: "Gender" alignment: "LEFT" controlHeaderOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "position.employee.customFields.gender.value" dataSourcePath: path: ! [] currentPath: ! - "position" - "employee" columnOrder: 0 suppressRepeating: false baseClassProperty: false columnOrder: 13 function: null suppressed: false sortOrder: 0 alignment: "LEFT" pageBreak: false ascending: true controlBreak: false columnTitle: "Gender" controlHeaderOnly: false detailHeaderOnly: false suppressRepeating: false entityName: "Employee" width: 0 format: null description: "Gender" name: "position.employee.customFields.gender.value" type: "java.lang.String" - ! description: "Code" type: "java.lang.String" propertyName: "code" propertyPath: "position.payGroup" entityName: "PayGroup" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Code" alignment: "LEFT" controlHeaderOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "position.payGroup.code" dataSourcePath: path: ! [] currentPath: ! - "position" - "payGroup" columnOrder: 14 suppressRepeating: false - ! description: "Description" type: "java.lang.String" propertyName: "description" propertyPath: "position.payGroup" entityName: "PayGroup" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Description" alignment: "LEFT" controlHeaderOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "position.payGroup.description" dataSourcePath: path: ! [] currentPath: ! - "position" - "payGroup" columnOrder: 15 suppressRepeating: false querySpecification: specification: "position.employee.deleted.eq 'false'\ntype.ne 'Non-Contract'\n\ position.jobStatus.oneOf (['Active'])\nposition.payGroup.code.oneOf ([param(\"\ position.PayGroup.code\")])"