--- reportDefinition: ! description: "PayrollAccount Report" tags: null predefined: false parameters: ! pageSize: "LETTER" pageOrientation: "LANDSCAPE" outputFormat: "PDF" templateName: "Payroll Acct Report for Employer Distribution" suppressDetail: false showOptions: false sortProperties: ! - ! propertyName: "payrollAccounts.position.employee.name.fullName" label: "Full Name" ascending: true controlBreak: true pageBreak: false - propertyName: "payrollAccounts.position.number" label: "Position Number" ascending: true controlBreak: false pageBreak: false - propertyName: "expenditureAccount.fund" label: "Fund" ascending: true controlBreak: false pageBreak: false - propertyName: "expenditureAccount.function" label: "Function" ascending: true controlBreak: false pageBreak: false - propertyName: "expenditureAccount.object" label: "Object" ascending: true controlBreak: false pageBreak: false - propertyName: "expenditureAccount.scc" label: "Scc" ascending: true controlBreak: false pageBreak: false - propertyName: "expenditureAccount.subject" label: "Subject" ascending: true controlBreak: false pageBreak: false - propertyName: "expenditureAccount.operationalUnit" label: "Operational Unit" ascending: true controlBreak: false pageBreak: false - propertyName: "expenditureAccount.instructionalLevel" label: "Instructional Level" ascending: true controlBreak: false pageBreak: false - propertyName: "expenditureAccount.job" label: "Job" ascending: true controlBreak: false pageBreak: false - propertyName: "rateType" label: "Rate Type" ascending: true controlBreak: false pageBreak: false - propertyName: "status" label: "Status" ascending: true controlBreak: false pageBreak: false queryParameters: ! {} title: "Payroll Acct Report for Employer Distribution" querySpecification: specification: "expenditureAccount.fund.like param(\"fund\")\nexpenditureAccount.function.like\ \ param(\"function\")\nexpenditureAccount.object.like param(\"object\")\nexpenditureAccount.scc.like\ \ param(\"SCC\")\nexpenditureAccount.subject.like param(\"subject\")\nexpenditureAccount.operationalUnit.like\ \ param(\"operationalUnit\")\nexpenditureAccount.instructionalLevel.like param(\"\ instructionalLevel\")\nexpenditureAccount.job.like param(\"job\")\nemployerDistribution.eq\ \ param(\"empDist\",\"\",\"Employer Distribution True/False\")" querySpecParameters: ! [] entity: "org.ssdt_ohio.usps.model.payrollaccount.PayrollAccount" properties: ! - ! description: "Full Name" type: "java.lang.String" propertyName: "fullName" propertyPath: "payrollAccounts.position.employee.name" entityName: "Name" sortOrder: 1 controlBreak: true suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "METHOD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "payrollAccounts.position.employee.name.fullName" dataSourcePath: path: ! [] currentPath: ! - "payrollAccounts" - "position" - "employee" - "name" suppressRepeating: false columnOrder: 1 permission: null - ! description: "Position Number" type: "java.lang.Integer" propertyName: "number" propertyPath: "payrollAccounts.position" entityName: "Position" sortOrder: 2 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "NONE" source: "FIELD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "payrollAccounts.position.number" dataSourcePath: path: ! [] currentPath: ! - "payrollAccounts" - "position" suppressRepeating: false columnOrder: 2 permission: null - ! description: "Fund" type: "java.lang.String" propertyName: "fund" propertyPath: "expenditureAccount" entityName: "UsasExpenditureAccount" sortOrder: 3 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "METHOD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "expenditureAccount.fund" dataSourcePath: path: ! [] currentPath: ! - "expenditureAccount" suppressRepeating: false columnOrder: 3 permission: null - ! description: "Function" type: "java.lang.String" propertyName: "function" propertyPath: "expenditureAccount" entityName: "UsasExpenditureAccount" sortOrder: 4 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "METHOD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "expenditureAccount.function" dataSourcePath: path: ! [] currentPath: ! - "expenditureAccount" suppressRepeating: false columnOrder: 4 permission: null - ! description: "Object" type: "java.lang.String" propertyName: "object" propertyPath: "expenditureAccount" entityName: "UsasExpenditureAccount" sortOrder: 5 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "METHOD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "expenditureAccount.object" dataSourcePath: path: ! [] currentPath: ! - "expenditureAccount" suppressRepeating: false columnOrder: 5 permission: null - ! description: "Scc" type: "java.lang.String" propertyName: "scc" propertyPath: "expenditureAccount" entityName: "UsasExpenditureAccount" sortOrder: 6 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "METHOD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "expenditureAccount.scc" dataSourcePath: path: ! [] currentPath: ! - "expenditureAccount" suppressRepeating: false columnOrder: 6 permission: null - ! description: "Subject" type: "java.lang.String" propertyName: "subject" propertyPath: "expenditureAccount" entityName: "UsasExpenditureAccount" sortOrder: 7 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "METHOD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "expenditureAccount.subject" dataSourcePath: path: ! [] currentPath: ! - "expenditureAccount" suppressRepeating: false columnOrder: 7 permission: null - ! description: "Operational Unit" type: "java.lang.String" propertyName: "operationalUnit" propertyPath: "expenditureAccount" entityName: "UsasExpenditureAccount" sortOrder: 8 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "METHOD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "expenditureAccount.operationalUnit" dataSourcePath: path: ! [] currentPath: ! - "expenditureAccount" suppressRepeating: false columnOrder: 8 permission: null - ! description: "Instructional Level" type: "java.lang.String" propertyName: "instructionalLevel" propertyPath: "expenditureAccount" entityName: "UsasExpenditureAccount" sortOrder: 9 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "METHOD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "expenditureAccount.instructionalLevel" dataSourcePath: path: ! [] currentPath: ! - "expenditureAccount" suppressRepeating: false columnOrder: 9 permission: null - ! description: "Job" type: "java.lang.String" propertyName: "job" propertyPath: "expenditureAccount" entityName: "UsasExpenditureAccount" sortOrder: 10 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "METHOD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "expenditureAccount.job" dataSourcePath: path: ! [] currentPath: ! - "expenditureAccount" suppressRepeating: false columnOrder: 10 permission: null - ! description: "Rate Type" type: "org.ssdt_ohio.usps.model.constants.RateType" propertyName: "rateType" propertyPath: null entityName: "PayrollAccount" sortOrder: 11 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "rateType" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 11 permission: null - ! description: "Rate" type: "java.math.BigDecimal" propertyName: "chargeAmountOrPercent" propertyPath: null entityName: "PayrollAccount" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "DEFAULT" source: "FIELD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "chargeAmountOrPercent" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 12 permission: null - ! description: "Status" type: "org.ssdt_ohio.usps.model.constants.PayrollAccountStatus" propertyName: "status" propertyPath: null entityName: "PayrollAccount" sortOrder: 12 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "status" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 13 permission: null - ! description: "Employer Distribution" type: "java.lang.Boolean" propertyName: "employerDistribution" propertyPath: null entityName: "PayrollAccount" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Employer Distribution" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 15 relativePropertyName: "employerDistribution" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 14 permission: null - ! description: "Start Date" type: "java.util.Calendar" propertyName: "startDate" propertyPath: "startStop" 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: "startStop.startDate" dataSourcePath: path: ! [] currentPath: ! - "startStop" suppressRepeating: false columnOrder: 15 permission: null - ! description: "Stop Date" type: "java.util.Calendar" propertyName: "stopDate" propertyPath: "startStop" entityName: "DateRange" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "CALENDAR" source: "FIELD" label: null columnTitle: "Stop Date" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 11 relativePropertyName: "startStop.stopDate" dataSourcePath: path: ! [] currentPath: ! - "startStop" suppressRepeating: false columnOrder: 16 permission: null