TL Reports

Employee Assignment List Report

Overview

This report shows a list of all employee assignments in the application and can be viewed as a detailed report.

A screenshot of the Employee Assignment List Report feature is available here. Image shown as reference material; position and names for labels, fields and buttons are subject to parameter, rendering control configuration and installed revision.

Users access the report from within the menu through this navigation path: Payroll Management ► Report ► TL Reports ► Employee Assignment List Report

Filters

The following table lists and describes all filter for the Employee Assignment List Report, in their default order. Note that some filters depend on system parameters and rendering control to be visible and/or editable to users. Filter names are subject to change through language label configuration.

Fields	Description
Start Date	Employee assignment start date filter.
Employee	Filter criterion for employee name.
Employee Position	Filtering on employee position ID or employee position name.
Work Location	It allows users to filter by the employee's work location
Situation Code Combination	Situation codes combination for the employee.
Salary Group	It allows users to select salary group from the drop down list.
Salary Classification	Employee salaray classification.
Salary Step	It allows users to select salary step from the drop down list.
Group By District	It allows users to group the report by dictrict.
Group Individual Institutions	It allows users to group the report by individual institutions.
Group By Institution Type	It allows users to select institution type from the drop down list.

Visible Fields

A sample of the Employee Assignment List Report output is available here.The following table lists and describes all visible fields for the Employee Assignment List Report, in their default order. Note that some fields depend on System Parameters and rendering control configuration to be visible and/or editable by users. Field names are subject to change through language label configuration.

Field	Description
Filter By	The filter criteria describing how the given report has been filtered based on the user’s preferences.
Group By	The criteria describing how the report has been grouped based on the user’s preferences.
Work Location	Information about work location of the employee.
District	Information about district, where the employee works.
Employee ID	Id of the employee.
Employee Name	Name of the employee.
Date of Birth	Date of birth of the employee.
Employee Position	Position of employee.
Situation Code Combination	Situation code combination information of the employee.
Hire Date	Hire date of the employee.
Base Salary	Monthly salary amount of the employee.

Buttons
The following table describes actions associated to the depicted button image. Note that some images are associated with several buttons, used for more than one purpose within the Employee Assignment List Report.

Button Image	Description
	This button allows users to generate the report as PDF.
	This button allows users to generate the report as MS Excel.
	This button allows users to generate the report as MS Excel (XLSX format).
	This button allows users to generate the report as HTML.
	This button allows users to generate the report as MS Word.

Employee List Report

Overview

The Employee List Report is designed to generate a list of employees with the ability to request data in various combinations for statistical purposes.

A screenshot of the Employee List Report feature is available here. Image shown as reference material; position and names for labels, fields and buttons are subject to parameter, rendering control configuration and installed revision.

Users access the report from within the menu through this navigation path: Payroll Management ► Report ► TL Reports ► Employee List Report

Filters

The following table lists and describes all filter for the Employee List Report, in their default order. Note that some filters depend on system parameters and rendering control to be visible and/or editable to users. Filter names are subject to change through language label configuration.

Fields	Description
Employee	Lookup filter criterion for the employee id.
Group Individual Institutions	It allows users to group the report by individual institutions.
Group By Institution Type	It allows users to group the report by institution type.

Visible Fields

A sample of the Employee List Report By District output is available here.The following table lists and describes all visible fields for the Employee List Report, in their default order. Note that some fields depend on System Parameters and rendering control configuration to be visible and/or editable by users. Field names are subject to change through language label configuration.

Field	Description
Filter By	The filter criteria describing how the given report has been filtered based on the user’s preferences.
Group By	The criteria describing how the report has been grouped based on the user’s preferences.
Employee Applicationid	Application id of the employee.
Employee Name	Name of the employee.
District	Disctric information for the employee.
Location	Information about work location of the employee.
Division	Information about the division related to the work location.

Button Image	Description
	This button allows users to generate the report as PDF.
	This button allows users to generate the report as MS Excel.
	This button allows users to generate the report as MS Excel (XLSX format).
	This button allows users to generate the report as HTML.
	This button allows users to generate the report as MS Word.

Employee With Leave Report

Overview

This report displays the leave taken by the employee for a specific period (the number of days and the amount while on leave). It provides different filter option to generate a very specific report.

A screenshot of the Employee With Leave Report is available here. Image shown as reference material; position and names for labels, fields and buttons are subject to the installed revision, System Parameters and Rendering Control configuration.

Users access Employee With Leave Report from within the menu through this navigation path: Payroll Management ► Reports ► TL Reports ► Employee With Leave Report.

Filters

The following table lists and describes all filter fields for the Employee With Leave Report in their default order. Note that some fields depends on System Parameters and Rendering Control configuration to be visible and/or editable by users. Field names are subject to change through language label configuration.

Field	Description
Fiscal Year	Lists the fiscal year and allows users to select as a filter. The current fiscal year is set as default value.
Pay Code	Lists pay codes.
Pay Period	Lists the pay period.
Comment	Allows users to add a custom comment to the generated report.
Group Individual Institutions	By default, it is marked as checked. Users can uncheck it to select the value of group by institution type as a filter.
Group By Institution Type	It lists the institutions and allows to select as a filter. If group by institution is checked, then this field becomes inactive.
Institution	It allows users to select one or multiple institutions.

Visible Fields

A sample of the report is available here.The following table lists and describes all visible fields for the Employee With Leave Report, in their default order. Note that some fields depend on filters selection and the language of the report depends on the configuration of the system.

Field	Description
General Organization Name	Name of the country on the top of the report.
Report Title	The title of the report appears on the report.
Report Date	It indicates the date of the report generation.
Report Time	It indicates the time of the report generation.
User	Identifier of the user who generates the report.
Environment	The environment name.
Period	The pay period.
Work Location	The work location of the employee.
Employee ID	The employee unique identity number.
Employee First Name	The employee first name.
Employee Last Name	The employee last name.
Status	The employement status. The possible values are: P-PERMANENT T-TEMPORARY A-A MEMBER OF GOVERNMENT F-FDTL N-PNTL NP-NATIONAL PARLIAMENT PA-POLITICAL APPOINTMENTS S-STUDYING ABROAD
Payment Type	The Payment types. The possible values are: Cash Cheque Direct Deposit
Leave Days	The number of days.
Leave Amount	The calculated leave amount.
Base Salary	Total base salary amount.
Subsidy	The subsidy amount.
Overtime	The total overtime.
Gross Pay	The calculated gross pay amount.
Deductions	The deduction amount.
Net Pay	The total net payment amount.

Buttons

The following table describes actions associated with the depicted button image. Note that some images are associated with several buttons, used for more than one purpose within the Employee With Leave Report feature.

Button Image	Description
	This button allows users to generate the report in the pdf format.
	This button allows users to generate the report in the Excel format.
	This button allows users to generate the report in the Excel format.
	This button allows users to generate the report in ODS format.
	This button allows users to generate the report in RTF format.
	This button allows the users to generate the report in MS Word format.
	This button allows users to generate the report in ODT format.
	This button allows users to generate the report as HTML.

Payment By District Graph Report

Overview

It is a graphical report related to payment methods. The report displays information on number of employees paid by cash and direct deposit for each district, the percentage of employees paid by cash and direct deposit by district and the overall percentage paid by cash and direct deposit.

A screenshot of the Payment By District Graph Report feature is available here. Image shown as reference material; position and names for labels, fields and buttons are subject to parameter, rendering control configuration and installed revision.

Users access the report from within the menu through this navigation path: Payroll Management ► Report ► TL Reports ► Payment By District Graph Report

Filters

The following table lists and describes all filter for the Payment By District Graph Report, in their default order. Note that some filters depend on system parameters and rendering control to be visible and/or editable to users. Filter names are subject to change through language label configuration.

Field	Description
Fiscal Year	Drop down filter criterion for the fiscal year. This is a mandatory filter with default value set to the current fiscal year.
Pay Code	Pay code description filter criterion.
Pay Period	Drop down filter criterion (allows to select payperiod).
Comments	Any comments to add in the output report.

Visible Fields

A sample of the Payment By District Graph Report output is available here.The following table lists and describes all visible fields for the Payment By District Graph Report, in their default order. Note that some fields depend on System Parameters and rendering control configuration to be visible and/or editable by users. Field names are subject to change through language label configuration.

Field	Description
Filter By	The filter criteria describing how the given report has been filtered based on the user’s preferences.
Sort By	The criteria describing how the report has been sorted based on the user’s preferences.
Period	Pay period for the Payment By District Graph Report.
District	Information about distric for that payment made.
Employee Count Direct Deposit District	Information about count of direct deposits for the district to the employee.
Employee Count Cash District	Information about count cash deposit for the district to the employee.
Percentage Direct Deposit District	Calculated field shows the percentage of direct deposit district made to the employee.
Percentage Cash District	Calculated field shows the percentage of cash district made to the employee.
Percentage Overall Direct Deposit	Calculated field shows the percentage of overall direct deposit made to the employee.
Percentage overall Cash	Calculated field shows the percentage of overall direct cash made to the employee.

Button Image	Description
	This button allows users to generate the report as PDF.
	This button allows users to generate the report as MS Excel.
	This button allows users to generate the report as MS Excel (XLSX format).
	This button allows users to generate the report as RTF.
	This button allows users to generate the report as MS Word.

Payroll Information Report

Overview

This report includes the payroll information related to Basic Salary, Overtime and other Cost Items Per Period, and the total deductions, per Employee and per Ministry.

Navigation

Payroll Management ► Report ► TL Reports ► Payroll Information Report

Payroll Information Report Screen Fields

Fields	Description
Fiscal Year	Current Fiscal Year
Pay Code	Pay Code Id
Pay Period	Pay Period Number
Payment Type	Payment Type: Cash, Cheque or Direct Deposit.
Comment	Optional parameter
Group By Institution Type	Depends. The user will be able to select a value from the drop-down list only if attribute Group By Individual Organization Unit? is false.

Quarterly Salary Report By District

Overview

This report is a customized report for Timor Leste. It displays for each quarter and each month the count of employee and the total amount of gross salary per district or per institution and district.

A screenshot of the Quarterly Salary Report By District feature is available here. Image shown as reference material; position and names for labels, fields and buttons are subject to parameter, rendering control configuration and installed revision.

Users access the report from within the menu through this navigation path: Payroll Management ► Report ► TL Reports ► Quarterly Salary Report By District

Filters

The following table lists and describes all filter for the Quarterly Salary Report By District, in their default order. Note that some filters depend on system parameters and rendering control to be visible and/or editable to users. Filter names are subject to change through language label configuration.

Field	Description
Fiscal Year	Drop down filter criterion for the fiscal year. This is a mandatory filter with default value set to the current fiscal year.
Quarter	Dropdown filter criterion for quarter.
Type Of Report	Drop down filter criterion for report type. Available options are: By District By Ministry and District
Comment	Any comment to add in the output report.

Visible Fields

A sample of the Quarterly Salary Report By District output is available here. The following table lists and describes all visible fields for the Quarterly Salary Report By District, in their default order. Note that some fields depend on System Parameters and rendering control configuration to be visible and/or editable by users. Field names are subject to change through language label configuration.

Field	Description
Filter By	The filter criteria describing how the given report has been filtered based on the user’s preferences.
Sort By	The criteria describing how the report has been sort by based on the user’s preferences.
Quarter	Shows quarter selected for this report.
District	Information about district for that salary made.
Period	Information about period for that salary made.
Total Employees	Information about payment made to number of employee.
US Dollars	Information about salary made in US dollars.

Button Image	Description
	This button allows users to generate the report as PDF.
	This button allows users to generate the report as MS Excel.
	This button allows users to generate the report as MS Excel (XLSX format).
	This button allows users to generate the report as RTF.
	This button allows users to generate the report as MS Word.

Salaries By Staffing Profile Report

Overview

It includes the payroll information related to basic salary, overtime, other cost items per period, the total deductions and gross and net salary, for a specific pay period.

A screenshot of the Salaries By Staffing Profile Report feature is available here. Image shown as reference material; position and names for labels, fields and buttons are subject to parameter, rendering control configuration and installed revision.

Users access the report from within the menu through this navigation path: Payroll Management ► Report ► TL Reports ► Salaries By Staffing Profile Report

Filters

The following table lists and describes all filter for the Salaries By Staffing Profile Report, in their default order. Note that some filters depend on system parameters and rendering control to be visible and/or editable to users. Filter names are subject to change through language label configuration.

Field	Description
Report Type	Dropdown filter criterion for report type. Available options are: Summary Detail Detail by District
Fiscal Year	Drop down filter criterion for the fiscal year. This is a mandatory filter with default value set to the current fiscal year.
Pay Code	Pay code description filter criterion.
Pay Period	Drop down filter criterion (allows to select payperiod).
Payment Type	Dropdown filter criterion for payment type. Available options are: Cash Cheque Direct Deposits
Comment	Allows users to add a custom comment to the generated report.
Group Individual Institutions	Allow users to group the report by individual institutions.
Group By Institution Type	Allow users to select institution type from the drop down list.

Visible Fields

A sample of the Staffing Profile Report output is available here. The following table lists and describes all visible fields for the Salaries By Staffing Profile Report, in their default order. Note that some fields depend on System Parameters and rendering control configuration to be visible and/or editable by users. Field names are subject to change through language label configuration.

Field	Description
Filter By	The filter criteria describing how the given report has been filtered based on the user’s preferences.
Group By	The criteria describing how the report has been grouped based on the user’s preferences.
Period	Period for this report.
Employees Count	This is the total number of employees with the specific grouping.
Basic Salary	Amount of basic salary made to the employees.
Subsidy	Amount of subsidy made to the employees.
Overtime	Amount of overtime made to the employees.
Gross Pay	This is a calculated Value, presents the total gross pay made to the employees.
Deductions	Amount of deduction deducted from gross salary.
Net Pay	This is a calculated value, presents gross pay less deductions.

Button Image	Description
	This button allows users to generate the report as PDF.
	This button allows users to generate the report as MS Excel.
	This button allows users to generate the report as MS Excel (XLSX format).
	This button allows users to generate the report as RTF.
	This button allows users to generate the report as MS Word.

Staff Movement Detail Report

Overview

It includes information about staff movement by Ministry and/or Division for each month between two pay periods, such as how many employees were hired during the month for permanent, temporary and totals for all salary scale groups, how many ended and the total number of employees at the beginning of the month.

A screenshot of the Staff Movement Detail Report feature is available here.Image shown as reference material; position and names for labels, fields and buttons are subject to parameter, rendering control configuration and installed revision.

Users access Staff Movement Detail Report from within the menu through this navigation path: Payroll Management ► Report ► TL Reports ► Staff Movement Detail Report

Filters

The following table lists and describes all filters for the Staff Movement Detail Report, in their default order. Note that some filters depend on system parameters and rendering control to be visible and/or editable to users. Filter names are subject to change through language label configuration.

Fields	Descriptions
Fiscal Year	Users select a fiscal year to filter report. The default value for this filter is the current fiscal year.
Pay Code	Users can select a pay code as filter criterion.
Pay Period From	Users define a range of the pay periods to be taken into account, this is the lower limit of the range.
Pay Period To	Users define a range of the pay periods to be taken into account, this is the upper limit of the range.
Group By Institution Type	Allows to select an institution type from the drop-down list to group the results.

Visible Fields

A sample of the Staff Movement Detail Report output is available here.The following table lists and describes all visible fields for the Staff Movement Detail Report, in their default order. Note that some fields depend on System Parameters and rendering control configuration to be visible and/or editable by users. Field names are subject to change through language label configuration.

Field	Description
Filter By	The filter criteria describing how the given report has been filtered based on the user’s preferences.
Group By	The criteria describing how the report has been grouped based on the user’s preferences.
Report Date	Indicates date of report generation. This value is automatically generated by system.
Report Time	Indicates time of report generation. This value is automatically generated by system.
User	User who generated the report.
Period	The period selected for this report.
Permanent - Start	Number of the permanent employees that started working during this period.
Permanent - Hired	Number of permanent employees hired during this period.
Permanent - Ended	Number of permanent employees whose assignment ended during this period.
Permanent - Total	Total number of permanent employees moved during this period.
Temporary - Start	Number of the temporary employees that started working during this period.
Temporary - Hired	Number of temporary employees hired during this period.
Temporary - Ended	Number of temporary employees whose assignment ended during this period.
Temporary - Total	Total number of temporary employees moved during this period.
All Employees - Start	Number of the permanent and temporary employees that started working during this period.
All Employees - Hired	Number of permanent and temporary employees hired during this period.
All Employees - Ended	Number of permanent and temporary employees whose assignment ended during this period.
All Employees - Total	Total number of permanent and temporary employees moved during this period.

Buttons

The following table describes actions associated to the depicted button image. Note that some images are associated with several buttons, used for more than one purpose within the Staff Movement Detail Report.

Button Image	Description
	This button allows users to generate the report as PDF.
	This button allows users to generate the report as MS Excel.
	This button allows users to generate the report as MS Excel (XLSX format of excel).
	This button allows users to generate the report as RTF.
	This button allows users to generate the report as MS Word.
	This button allows users to generate the report as HTML.