--- reportDefinition: ! description: "Compensation Report" tags: "" predefined: false parameters: ! pageSize: "LETTER" pageOrientation: "PORTRAIT" outputFormat: "CSV" templateName: "American Fidelity Demographic Report" suppressDetail: false showOptions: false sortProperties: ! - ! propertyName: "position.employee.number" label: "Number" ascending: true controlBreak: false pageBreak: false queryParameters: ! {} title: "American Fidelity Demographic Report" querySpecification: specification: "position.employee.lastPaidDate.ge param(\"payDate\")\narchived.eq\ \ 'false'\ncontractObligation.gt '0.00'\nposition.employee.number.notNull() " querySpecParameters: ! [] 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 controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "position.employee.name.lastName" dataSourcePath: path: ! [] currentPath: ! - "position" - "employee" - "name" columnOrder: 1 suppressRepeating: false permission: null - ! 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 controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "position.employee.name.firstName" dataSourcePath: path: ! [] currentPath: ! - "position" - "employee" - "name" columnOrder: 2 suppressRepeating: false permission: null - ! 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 controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "position.positionDescription" dataSourcePath: path: ! [] currentPath: ! - "position" columnOrder: 3 suppressRepeating: false permission: null - ! description: "Number" type: "java.lang.String" propertyName: "number" propertyPath: "position.employee" entityName: "Employee" sortOrder: 1 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "Number" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "position.employee.number" dataSourcePath: path: ! [] currentPath: ! - "position" - "employee" columnOrder: 4 suppressRepeating: true permission: null - ! description: "Pay Unit" type: "org.ssdt_ohio.usps.model.constants.DailyOrHourlyOptions" propertyName: "payUnit" 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: "Pay Unit" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "payUnit" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 5 suppressRepeating: false permission: null - ! description: "Hire Date" type: "java.util.Calendar" propertyName: "hireDate" propertyPath: "position" entityName: "Position" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "CALENDAR" source: "FIELD" label: null columnTitle: "Hire Date" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 11 relativePropertyName: "position.hireDate" dataSourcePath: path: ! [] currentPath: ! - "position" columnOrder: 6 suppressRepeating: false permission: null - ! propertyName: "homePhone" reportableProperty: ! description: "Home Phone" type: "java.lang.String" propertyName: "customFields.homePhone.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: "Home Phone" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "position.employee.customFields.homePhone.value" dataSourcePath: path: ! [] currentPath: ! - "position" - "employee" columnOrder: 0 suppressRepeating: false permission: null columnTitle: "Home Phone" ascending: true columnOrder: 7 sortOrder: 0 function: null suppressed: false baseClassProperty: false controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false controlBreak: false pageBreak: false alignment: "LEFT" suppressRepeating: false entityName: "Employee" width: 0 format: null description: "Home Phone" name: "position.employee.customFields.homePhone.value" type: "java.lang.String" permission: null - ! description: "SSN" type: "java.lang.String" propertyName: "ssn" propertyPath: "position.employee" entityName: "Employee" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "SSN" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "position.employee.ssn" dataSourcePath: path: ! [] currentPath: ! - "position" - "employee" columnOrder: 8 suppressRepeating: false permission: null - ! description: "Hire Date" type: "java.util.Calendar" propertyName: "hireDate" propertyPath: "position.employee" entityName: "Employee" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "CALENDAR" source: "FIELD" label: null columnTitle: "Hire Date" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 11 relativePropertyName: "position.employee.hireDate" dataSourcePath: path: ! [] currentPath: ! - "position" - "employee" columnOrder: 9 suppressRepeating: false permission: null - ! description: "Birth Date" type: "java.util.Calendar" propertyName: "birthDate" propertyPath: "position.employee" entityName: "Employee" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "CALENDAR" source: "FIELD" label: null columnTitle: "Birth Date" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 11 relativePropertyName: "position.employee.birthDate" dataSourcePath: path: ! [] currentPath: ! - "position" - "employee" columnOrder: 10 suppressRepeating: false permission: null - ! 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 controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "position.employee.customFields.gender.value" dataSourcePath: path: ! [] currentPath: ! - "position" - "employee" columnOrder: 0 suppressRepeating: false permission: null columnTitle: "Gender" ascending: true columnOrder: 11 sortOrder: 0 function: null suppressed: false baseClassProperty: false controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false controlBreak: false pageBreak: false alignment: "LEFT" suppressRepeating: false entityName: "Employee" width: 0 format: null description: "Gender" name: "position.employee.customFields.gender.value" type: "java.lang.String" permission: null - ! description: "Street1" type: "java.lang.String" propertyName: "street1" propertyPath: "position.employee.address" entityName: "Address" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "Street1" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "position.employee.address.street1" dataSourcePath: path: ! [] currentPath: ! - "position" - "employee" - "address" columnOrder: 12 suppressRepeating: false permission: null - ! description: "City" type: "java.lang.String" propertyName: "city" propertyPath: "position.employee.address" entityName: "Address" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "City" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "position.employee.address.city" dataSourcePath: path: ! [] currentPath: ! - "position" - "employee" - "address" columnOrder: 13 suppressRepeating: false permission: null - ! description: "State" type: "java.lang.String" propertyName: "state" propertyPath: "position.employee.address" entityName: "Address" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "State" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "position.employee.address.state" dataSourcePath: path: ! [] currentPath: ! - "position" - "employee" - "address" columnOrder: 14 suppressRepeating: false permission: null - ! description: "Postal Code" type: "java.lang.String" propertyName: "postalCode" propertyPath: "position.employee.address" entityName: "Address" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "Postal Code" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "position.employee.address.postalCode" dataSourcePath: path: ! [] currentPath: ! - "position" - "employee" - "address" columnOrder: 15 suppressRepeating: false permission: null - ! description: "Contract Obligation" type: "java.math.BigDecimal" propertyName: "contractObligation" propertyPath: null entityName: "ContractCompensation" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "CURRENCY" source: "FIELD" label: "" columnTitle: "Contract Obligation" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "contractObligation" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 16 suppressRepeating: false permission: null - ! description: "Pays Paid" type: "java.lang.Integer" propertyName: "paysPaid" propertyPath: "compensationAmounts" entityName: "CompensationAmounts" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: "Sum" baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "Pays Paid" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "compensationAmounts.paysPaid" dataSourcePath: path: ! [] currentPath: ! - "compensationAmounts" columnOrder: 17 suppressRepeating: false permission: null - ! description: "Start Date" type: "java.util.Calendar" propertyName: "startDate" propertyPath: "dateRange" entityName: "DateRange" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "CALENDAR" source: "FIELD" label: null columnTitle: "Start Date" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 11 relativePropertyName: "dateRange.startDate" dataSourcePath: path: ! [] currentPath: ! - "dateRange" columnOrder: 18 suppressRepeating: false permission: null