--- reportDefinition: ! description: "HistoricalPayAmount Report" tags: null predefined: false parameters: ! pageSize: "LETTER" pageOrientation: "PORTRAIT" outputFormat: "PDF" templateName: "DetailReport" suppressDetail: false showOptions: false sortProperties: ! - ! propertyName: "historicalPositionPay.employeePay.name.fullName" label: "Full Name" ascending: true controlBreak: false pageBreak: false - propertyName: "historicalPositionPay.employeePay.payroll.payDate" label: "Pay Date" ascending: true controlBreak: false pageBreak: false queryParameters: ! {} title: "DetailReport" querySpecification: specification: "historicalPositionPay.employeePay.employeeNumber.eq param(\"employeeNumber\"\ )\nspecificAccountsCharged.amountCharged.gt '0.00'\nhistoricalPositionPay.employeePay.payroll.payDate.between\ \ param(\"payDateStart\"),param(\"payDateEnd\")\nspecificAccountsCharged.fund.eq\ \ param(\"fund\")\nspecificAccountsCharged.function.eq param(\"function\")\n\ specificAccountsCharged.object.eq param(\"object\")\nspecificAccountsCharged.scc.eq\ \ param(\"scc\")\nspecificAccountsCharged.subject.eq param(\"subject\")\nspecificAccountsCharged.operationalUnit.eq\ \ param(\"opu\")\nspecificAccountsCharged.instructionalLevel.eq param(\"il\"\ )" querySpecParameters: ! [] entity: "org.ssdt_ohio.usps.model.payroll.HistoricalPayAmount" properties: ! - ! description: "Employee Number" type: "java.lang.String" propertyName: "employeeNumber" propertyPath: "historicalPositionPay.employeePay" entityName: "HistoricalEmployeePay" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Employee Number" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "historicalPositionPay.employeePay.employeeNumber" dataSourcePath: path: ! [] currentPath: ! - "historicalPositionPay" - "employeePay" columnOrder: 1 suppressRepeating: false permission: null - ! description: "Full Name" type: "java.lang.String" propertyName: "fullName" propertyPath: "historicalPositionPay.employeePay.name" entityName: "Name" sortOrder: 1 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "METHOD" label: "" columnTitle: "Full Name" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "historicalPositionPay.employeePay.name.fullName" dataSourcePath: path: ! [] currentPath: ! - "historicalPositionPay" - "employeePay" - "name" columnOrder: 2 suppressRepeating: false permission: null - ! description: "Pay Date" type: "java.util.Calendar" propertyName: "payDate" propertyPath: "historicalPositionPay.employeePay.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: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 11 relativePropertyName: "historicalPositionPay.employeePay.payroll.payDate" dataSourcePath: path: ! [] currentPath: ! - "historicalPositionPay" - "employeePay" - "payroll" columnOrder: 3 suppressRepeating: false permission: null - ! description: "Position Number" type: "java.lang.Integer" propertyName: "positionNumber" propertyPath: "historicalPositionPay" entityName: "HistoricalPositionPay" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Position Number" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "historicalPositionPay.positionNumber" dataSourcePath: path: ! [] currentPath: ! - "historicalPositionPay" columnOrder: 4 suppressRepeating: false permission: null - ! description: "Account Type" type: "org.ssdt_ohio.usps.model.constants.PayrollAccountType" propertyName: "accountType" propertyPath: "specificAccountsCharged" entityName: "HistoricalPayAccount" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "Account Type" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "accountType" dataSourcePath: path: ! - "specificAccountsCharged" currentPath: ! [] columnOrder: 5 suppressRepeating: false permission: null - ! description: "Amount Charged" type: "java.math.BigDecimal" propertyName: "amountCharged" propertyPath: "specificAccountsCharged" entityName: "HistoricalPayAccount" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "CURRENCY" source: "FIELD" label: "" columnTitle: "Amount Charged" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "amountCharged" dataSourcePath: path: ! - "specificAccountsCharged" currentPath: ! [] columnOrder: 6 suppressRepeating: false permission: null - ! description: "Employer Distribution" type: "java.lang.Boolean" propertyName: "employerDistribution" propertyPath: "specificAccountsCharged" entityName: "HistoricalPayAccount" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "Employer Distribution" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 15 relativePropertyName: "employerDistribution" dataSourcePath: path: ! - "specificAccountsCharged" currentPath: ! [] columnOrder: 7 suppressRepeating: false permission: null - ! description: "Expenditure Account" type: "java.lang.String" propertyName: "expenditureAccount" propertyPath: "specificAccountsCharged" entityName: "HistoricalPayAccount" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Expenditure Account" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 33 relativePropertyName: "expenditureAccount" dataSourcePath: path: ! - "specificAccountsCharged" currentPath: ! [] columnOrder: 8 suppressRepeating: false permission: null - ! description: "Fund" type: "java.lang.String" propertyName: "fund" propertyPath: "specificAccountsCharged" entityName: "HistoricalPayAccount" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "METHOD" label: "Fund" columnTitle: "Fund" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 3 relativePropertyName: "fund" dataSourcePath: path: ! - "specificAccountsCharged" currentPath: ! [] columnOrder: 9 suppressRepeating: false permission: null - ! description: "Func" type: "java.lang.String" propertyName: "function" propertyPath: "specificAccountsCharged" entityName: "HistoricalPayAccount" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "METHOD" label: "Func" columnTitle: "Func" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 3 relativePropertyName: "function" dataSourcePath: path: ! - "specificAccountsCharged" currentPath: ! [] columnOrder: 10 suppressRepeating: false permission: null - ! description: "Obj" type: "java.lang.String" propertyName: "object" propertyPath: "specificAccountsCharged" entityName: "HistoricalPayAccount" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "METHOD" label: "Obj" columnTitle: "Obj" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 4 relativePropertyName: "object" dataSourcePath: path: ! - "specificAccountsCharged" currentPath: ! [] columnOrder: 11 suppressRepeating: false permission: null - ! description: "SCC" type: "java.lang.String" propertyName: "scc" propertyPath: "specificAccountsCharged" entityName: "HistoricalPayAccount" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "METHOD" label: "SCC" columnTitle: "SCC" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 4 relativePropertyName: "scc" dataSourcePath: path: ! - "specificAccountsCharged" currentPath: ! [] columnOrder: 12 suppressRepeating: false permission: null - ! description: "Subject" type: "java.lang.String" propertyName: "subject" propertyPath: "specificAccountsCharged" entityName: "HistoricalPayAccount" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "METHOD" label: "Subject" columnTitle: "Subject" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 6 relativePropertyName: "subject" dataSourcePath: path: ! - "specificAccountsCharged" currentPath: ! [] columnOrder: 13 suppressRepeating: false permission: null - ! description: "OPU" type: "java.lang.String" propertyName: "operationalUnit" propertyPath: "specificAccountsCharged" entityName: "HistoricalPayAccount" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "METHOD" label: "OPU" columnTitle: "OPU" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 3 relativePropertyName: "operationalUnit" dataSourcePath: path: ! - "specificAccountsCharged" currentPath: ! [] columnOrder: 14 suppressRepeating: false permission: null - ! description: "IL" type: "java.lang.String" propertyName: "instructionalLevel" propertyPath: "specificAccountsCharged" entityName: "HistoricalPayAccount" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "METHOD" label: "IL" columnTitle: "IL" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 2 relativePropertyName: "instructionalLevel" dataSourcePath: path: ! - "specificAccountsCharged" currentPath: ! [] columnOrder: 15 suppressRepeating: false permission: null