Understanding German Public Sector Reporting
German Public Sector enables you to generate reports using BI Publisher for Oracle (BI Publisher) on the following employee data:
Workforce statistic
Child allowance
Workforce Statistic
Workforce Statistic ascertains data about the structure of the number of public service employees in Germany. It is conducted on the 30th of June each year in form of a census.
In German Public Sector, the Workforce Statistic report displays workforce data of an employee and the information comes from several source systems: HCM, German Public Sector, and Payroll.
Child Allowance
Similar to Workforce Statistic, German Public Sector provides reporting on employees’ child allowance information, as required by 4 Steuerstatistiken (StStatG), using the same reporting framework. The data that is available in the child allowance report includes:
(for beneficiaries) Number of children with allowance payments, marital status, country of residence, and zip code of residence.
(for children) Sequence number and age as of the period’s end date.
The setup and viewing pages for the child allowance report are labeled family allowance in the application.
See Also
Prior to running these reports, the report administrator needs to perform these setup tasks:
Enter additional information to be used in the report.
Set up the mapping of source and target report data.
This is for business data (source) that is more customer-specific and not recognized by the system.
Specify report parameters.
See Also
The system provides a component where the report administrator runs these reports and makes necessary edits. These reports can be run in three ways:
Generate report results which are stored in the database, no report file is created. The administrator can view and make changes to the results.
Generate report files using BI Publisher based on report results that already exist in the database.
Generate both report results and report files.
After the report is run, the administrator can view and edit the results from an employee’s perspective. The system also generates error files for each report run that had issues (for example, missing mapping). Once the administrator fixes all issues addressed in the error file, he or she can rerun the report to make sure that all data is corrected and displayed properly.
To made edits to a report file, the administrator can save it to a local machine, make changes, and upload it to the database. In addition to save and upload, the administrator can also perform these actions on a report or error file: view its source on a browser, generate an ASCII file, launch it in PDF, XLS or RTF format, and remove it from the database.
These reports are available for edits and viewing by employee on the German Public Sector page of the Job Data component.
See Also