--- reportDefinition: ! description: "HistoricalPayrollItem Report" tags: null predefined: false parameters: ! pageSize: "LETTER" pageOrientation: "PORTRAIT" outputFormat: "PDF" templateName: "Child Support" suppressDetail: false showOptions: false sortProperties: ! - ! propertyName: "code" label: "Code" ascending: true controlBreak: true pageBreak: false - propertyName: "type" label: "Type" ascending: true controlBreak: false pageBreak: false - propertyName: "payrollItem.employee.name.nameWithMiddleInitial" label: "Name With Middle Initial" ascending: true controlBreak: true pageBreak: false - propertyName: "historicalEmployeePay.payroll.payDate" label: "Pay Date" ascending: true controlBreak: false pageBreak: false queryParameters: ! {} title: "Child Support" querySpecification: specification: "historicalEmployeePay.payroll.payDate.between param(\"payDate\"\ ,\"\",\"Start Pay Date\"),param(\"endPayDate\",\"\",\"End Pay Date\")\ntype.eq\ \ 'ChildSupport'" querySpecParameters: ! [] entity: "org.ssdt_ohio.usps.model.payroll.HistoricalPayrollItem" properties: ! - ! description: "Code" type: "java.lang.String" propertyName: "code" propertyPath: null entityName: "HistoricalPayrollItem" sortOrder: 1 controlBreak: true suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Code" alignment: "CENTER" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "code" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 1 suppressRepeating: false - ! description: "Name With Middle Initial" type: "java.lang.String" propertyName: "nameWithMiddleInitial" propertyPath: "payrollItem.employee.name" entityName: "Name" sortOrder: 2 controlBreak: true suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "METHOD" label: "" columnTitle: "Name" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 32 relativePropertyName: "payrollItem.employee.name.nameWithMiddleInitial" dataSourcePath: path: ! [] currentPath: ! - "payrollItem" - "employee" - "name" columnOrder: 2 suppressRepeating: false - ! description: "SSN" type: "java.lang.String" propertyName: "ssn" propertyPath: "payrollItem.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: "CENTER" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 18 relativePropertyName: "payrollItem.employee.ssn" dataSourcePath: path: ! [] currentPath: ! - "payrollItem" - "employee" columnOrder: 3 suppressRepeating: false - ! description: "Sets Case Number" type: "java.lang.Long" propertyName: "setsCaseNumber" propertyPath: "payrollItem" entityName: "ChildSupportItem" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Sets Case Number" alignment: "CENTER" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 18 relativePropertyName: "payrollItem.setsCaseNumber" dataSourcePath: path: ! [] currentPath: ! - "payrollItem" columnOrder: 4 suppressRepeating: false - ! description: "Fips Code" type: "java.lang.Long" propertyName: "fipsCode" propertyPath: "payrollItem" entityName: "ChildSupportItem" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Fips Code" alignment: "CENTER" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 18 relativePropertyName: "payrollItem.fipsCode" dataSourcePath: path: ! [] currentPath: ! - "payrollItem" columnOrder: 5 suppressRepeating: false - ! description: "Order Number" type: "java.lang.String" propertyName: "orderNumber" propertyPath: "payrollItem" entityName: "ChildSupportItem" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "Order Number" alignment: "CENTER" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 18 relativePropertyName: "payrollItem.orderNumber" dataSourcePath: path: ! [] currentPath: ! - "payrollItem" columnOrder: 6 suppressRepeating: false - ! description: "Old Case Number" type: "java.lang.String" propertyName: "oldCaseNumber" propertyPath: "payrollItem" entityName: "ChildSupportItem" sortOrder: 0 controlBreak: false suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "Old Case Number" alignment: "CENTER" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 18 relativePropertyName: "payrollItem.oldCaseNumber" dataSourcePath: path: ! [] currentPath: ! - "payrollItem" columnOrder: 7 suppressRepeating: false - ! description: "Amount" type: "java.math.BigDecimal" propertyName: "amount" propertyPath: null entityName: "HistoricalPayrollItem" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: "Sum" baseClassProperty: false format: "CURRENCY" source: "FIELD" label: "" columnTitle: "EMP Amount" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 18 relativePropertyName: "amount" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 8 suppressRepeating: false - ! description: "Pay Date" type: "java.util.Calendar" propertyName: "payDate" propertyPath: "historicalEmployeePay.payroll" entityName: "AbstractPayroll" sortOrder: 2 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: "CALENDAR" source: "FIELD" label: "" columnTitle: "Pay Date" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 16 relativePropertyName: "historicalEmployeePay.payroll.payDate" dataSourcePath: path: ! [] currentPath: ! - "historicalEmployeePay" - "payroll" columnOrder: 9 suppressRepeating: false - ! description: "Type" type: "org.ssdt_ohio.usps.model.constants.PayrollItemType" propertyName: "type" propertyPath: null entityName: "HistoricalPayrollItem" sortOrder: 1 controlBreak: false suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Type" alignment: "LEFT" controlHeaderOnly: true controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "type" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 10 suppressRepeating: false