--- reportDefinition: ! description: "City tax report that can be used for W2's. Must make Dec the \"current\"\ \ period before running to get accurate information fo the CY" tags: "Reports Group" predefined: false parameters: ! pageSize: "LETTER" pageOrientation: "LANDSCAPE" outputFormat: "PDF" templateName: "CITY TAX REPORT " suppressDetail: false showOptions: false sortProperties: ! [] queryParameters: ! {} title: "CITY TAX REPORT " querySpecification: specification: "configuration.code.oneOf ([param(\"codes\")])" querySpecParameters: ! [] entity: "org.ssdt_ohio.usps.model.payrollitem.PayrollItem" properties: ! - ! 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" suppressRepeating: false columnOrder: 1 - ! description: "Last Name" type: "java.lang.String" propertyName: "lastName" propertyPath: "employee.name" entityName: "Name" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Last Name" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "employee.name.lastName" dataSourcePath: path: ! [] currentPath: ! - "employee" - "name" suppressRepeating: false columnOrder: 2 - ! description: "First Name" type: "java.lang.String" propertyName: "firstName" propertyPath: "employee.name" entityName: "Name" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "First Name" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "employee.name.firstName" dataSourcePath: path: ! [] currentPath: ! - "employee" - "name" suppressRepeating: false columnOrder: 3 - ! description: "Middle Name" type: "java.lang.String" propertyName: "middleName" propertyPath: "employee.name" entityName: "Name" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Middle Name" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "employee.name.middleName" dataSourcePath: path: ! [] currentPath: ! - "employee" - "name" suppressRepeating: false columnOrder: 4 - ! 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" suppressRepeating: false columnOrder: 5 - ! 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" suppressRepeating: false columnOrder: 6 - ! 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" suppressRepeating: false columnOrder: 7 - ! description: "Province" type: "java.lang.String" propertyName: "province" 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: "Province" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "employee.address.province" dataSourcePath: path: ! [] currentPath: ! - "employee" - "address" suppressRepeating: false columnOrder: 8 - ! 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" suppressRepeating: false columnOrder: 9 - ! propertyName: "homePhone" reportableProperty: ! description: "Home Phone" type: "java.lang.String" propertyName: "customFields.homePhone.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: "Home Phone" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "employee.customFields.homePhone.value" dataSourcePath: path: ! [] currentPath: ! - "employee" suppressRepeating: false columnOrder: 0 baseClassProperty: false detailHeaderOnly: false controlBreak: false pageBreak: false ascending: true alignment: "LEFT" columnTitle: "Home Phone" controlHeaderOnly: false controlFooterOnly: false suppressRepeating: false columnOrder: 10 function: null sortOrder: 0 suppressed: false entityName: "Employee" format: null width: 0 description: "Home Phone" name: "employee.customFields.homePhone.value" type: "java.lang.String" - ! description: "Code" type: "java.lang.String" propertyName: "code" propertyPath: null entityName: "PayrollItem" sortOrder: 1 controlBreak: true suppressed: false pageBreak: true ascending: true function: null baseClassProperty: false format: null source: "METHOD" label: "" columnTitle: "Code" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "code" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 11 - ! description: "YTD Applicable Gross" type: "java.math.BigDecimal" propertyName: "ytdApplicableGross" propertyPath: null entityName: "PayrollItem" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: "Sum" baseClassProperty: false format: "CURRENCY" source: "METHOD" label: "YTD Applicable Gross" columnTitle: "YTD Applicable Gross" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "ytdApplicableGross" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 12 - ! description: "YTD Withholding" type: "java.math.BigDecimal" propertyName: "ytdWithholding" propertyPath: null entityName: "PayrollItem" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: "Sum" baseClassProperty: false format: "CURRENCY" source: "METHOD" label: "YTD Withholding" columnTitle: "YTD Withholding" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "ytdWithholding" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 13