--- reportDefinition: ! description: "PayrollItem Report" tags: null predefined: false parameters: ! pageSize: "LETTER" pageOrientation: "PORTRAIT" outputFormat: "XLSX" templateName: "OAPSE Report" suppressDetail: false showOptions: false sortProperties: ! - ! propertyName: "employee.name.lastName" label: "Last Name" ascending: true controlBreak: false pageBreak: false - propertyName: "employee.name.firstName" label: "First Name" ascending: true controlBreak: false pageBreak: false queryParameters: ! {} title: "OAPSE Report" querySpecification: specification: "employee.deleted.eq 'false'\nconfiguration.code.oneOf ([param(\"\ code\",\"\",\"Pay Item Code\")])" querySpecParameters: ! [] entity: "org.ssdt_ohio.usps.model.payrollitem.PayrollItem" properties: ! - ! description: "Number" type: "java.lang.String" propertyName: "number" propertyPath: "employee" entityName: "Employee" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Number" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "employee.number" dataSourcePath: path: ! [] currentPath: ! - "employee" columnOrder: 1 suppressRepeating: false - ! description: "Last Name" type: "java.lang.String" propertyName: "lastName" propertyPath: "employee.name" entityName: "Name" sortOrder: 1 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: "employee.name.lastName" dataSourcePath: path: ! [] currentPath: ! - "employee" - "name" columnOrder: 2 suppressRepeating: false - ! description: "First Name" type: "java.lang.String" propertyName: "firstName" propertyPath: "employee.name" entityName: "Name" sortOrder: 2 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: "employee.name.firstName" dataSourcePath: path: ! [] currentPath: ! - "employee" - "name" columnOrder: 3 suppressRepeating: false - ! description: "SSN" type: "java.lang.String" propertyName: "ssn" propertyPath: "employee" entityName: "Employee" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "SSN" columnTitle: "SSN" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "employee.ssn" dataSourcePath: path: ! [] currentPath: ! - "employee" columnOrder: 4 suppressRepeating: false - ! description: "Code" type: "java.lang.String" propertyName: "code" propertyPath: "configuration" entityName: "PayrollItemConfiguration" sortOrder: 0 controlBreak: false suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "Code" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "configuration.code" dataSourcePath: path: ! [] currentPath: ! - "configuration" columnOrder: 5 suppressRepeating: false - ! description: "Name" type: "java.lang.String" propertyName: "name" propertyPath: "configuration" entityName: "PayrollItemConfiguration" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "Name" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "configuration.name" dataSourcePath: path: ! [] currentPath: ! - "configuration" columnOrder: 6 suppressRepeating: true - ! description: "YTD Gross" type: "java.math.BigDecimal" propertyName: "ytdGross" propertyPath: "employee" entityName: "Employee" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "CURRENCY" source: "METHOD" label: "YTD Gross" columnTitle: "YTD Gross" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "employee.ytdGross" dataSourcePath: path: ! [] currentPath: ! - "employee" columnOrder: 7 suppressRepeating: false - ! propertyName: "primaryEmail" reportableProperty: ! description: "Primary Email" type: "java.lang.String" propertyName: "customFields.primaryEmail.value" propertyPath: "employee" entityName: "Employee" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: null label: null columnTitle: "Primary Email" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "employee.customFields.primaryEmail.value" dataSourcePath: path: ! [] currentPath: ! - "employee" columnOrder: 0 suppressRepeating: false alignment: "LEFT" baseClassProperty: false function: null columnOrder: 8 suppressed: false columnTitle: "Primary Email" sortOrder: 0 controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false controlBreak: false pageBreak: false ascending: true suppressRepeating: false entityName: "Employee" width: 0 format: null description: "Primary Email" name: "employee.customFields.primaryEmail.value" type: "java.lang.String" - ! 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 alignment: "LEFT" baseClassProperty: false function: null columnOrder: 9 suppressed: false columnTitle: "Home Phone" sortOrder: 0 controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false controlBreak: false pageBreak: false ascending: true suppressRepeating: false entityName: "Employee" width: 0 format: null description: "Home Phone" name: "position.employee.customFields.homePhone.value" type: "java.lang.String" - ! description: "Street1" type: "java.lang.String" propertyName: "street1" propertyPath: "employee.address" entityName: "Address" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Street1" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "employee.address.street1" dataSourcePath: path: ! [] currentPath: ! - "employee" - "address" columnOrder: 10 suppressRepeating: false - ! description: "Street2" type: "java.lang.String" propertyName: "street2" propertyPath: "employee.address" entityName: "Address" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Street2" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "employee.address.street2" dataSourcePath: path: ! [] currentPath: ! - "employee" - "address" columnOrder: 11 suppressRepeating: false - ! description: "City" type: "java.lang.String" propertyName: "city" propertyPath: "employee.address" entityName: "Address" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "City" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "employee.address.city" dataSourcePath: path: ! [] currentPath: ! - "employee" - "address" columnOrder: 12 suppressRepeating: false - ! description: "State" type: "java.lang.String" propertyName: "state" propertyPath: "employee.address" entityName: "Address" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "State" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "employee.address.state" dataSourcePath: path: ! [] currentPath: ! - "employee" - "address" columnOrder: 13 suppressRepeating: false - ! description: "Postal Code" type: "java.lang.String" propertyName: "postalCode" propertyPath: "employee.address" entityName: "Address" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Postal Code" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "employee.address.postalCode" dataSourcePath: path: ! [] currentPath: ! - "employee" - "address" columnOrder: 14 suppressRepeating: false