Description
The DA-Payroll statistics is implemented as an APM plugin. How to install the plug in see section Houskeeping below. The following requirements are implemented.
| View file | ||||
|---|---|---|---|---|
|
| View file | ||||
|---|---|---|---|---|
|
Compatible
Compatible with APM 2019.50 or higher*
*Requires cross reference table; PW001P01_XREF
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
|
Location
After installing the plug-in the plug in is available in the following location
Tools > Export > DA Payroll Statistics
User Interface
HouskeepingHousekeeping
InterfaceXREF Interfaces used:
The DA_Payroll Statistics plug ins uses the following interfae interface definitions:
| Interface Code | Description |
|---|---|
| DA_STAT | General interface |
| DA_0200 | DA Statistics Terms of employment PTYPE 0200 |
| DA_0351 | DA Statistics job positions PTYPE 0351 |
DA_0400 | DA Statistics Job Status PTYPE 0400 |
| DA_0620 | DA_Statistics Holiday supplement PTYPE 0620 |
To define the interface goto:
Setup > General Codes > Interfaces
Vessels configuration
DA Payroll Statistics is only reported when serving on DIS (Dansk Internationl Ship register) in the vessel set-up organization structure select DIS.
Configuration settings for Reporter Setup Row type 1:
| DA Property | Adonis | |
|---|---|---|
| Reporter CVR Number | Company number | Setup > Organization Structure > Select Company used in the reporting
|
| Reporters Name (INAVN) | Company Name | |
Reporters Address (IADR)( Reporters Post Code (IPOST) | Company Address |
|
Configuration settings for Person Information Record (Row Type 3)
| DA Property | Adonis Field | |
|---|---|---|
| CVR Number | Persons client company number | |
| DA Union Code | Use the company XREF tab and interface DA_STAT to link the DA Union Code to the company |
|
| CPR-Number | Person ID | |
| ITYPE | See description below | |
| MKODE | See description below |
ITYPE and MKODE configuration
| ITYPE | Description | MKODE(Value) | Adonis Reference |
|---|---|---|---|
| 0200 | Terms of Employment | 4 = Company employed Seafarers with a contract for an indefinite duration. This also applies to trainees. 5 = Temporary/Contract employed | Identified by the contract type on payscale table. Interface code DA_0200 in the contract type XREF identifies the correct MKcode to use.
|
| 0351 | Job Position | Indicate the three-digit code for the seafarer’s job position corresponding to the code you report to Udligningskontoret. Visit the Danish Shipping website to find the complete list of valid codes. |
|
| 0400 | Job Status | 1 = Trainee/apprentice 3 = Officer’s rank 9 = Private/ordinary seafarers Ordinary seafarers without managerial status. The date at which the seafarer has received the job status in question must be indicated in the date field. | See setup of 0351 |
| 0620 | Holiday supplement (%) (Employees who have paid holiday days) | For employees who have paid holiday days, indicate the percentage that is used for calculating the holiday supplement. This comprises at least 1% of the entitled holiday pay, but there may be local agreements regarding higher percentages. The percentage is to be indicated as whole 1/100 percentages. Thus 1% of special holiday supplement is reported as the number 100. |
|
Configuration Settings for Wage Row (Row Type 4)
| DA Property | Adonis | |
|---|---|---|
| CVR-Number (SENR) | Company* Number | Setup > Organization Structure > Select Company used in the reporting
|
| DA-UNION (DAK) | Use the company* XREF tab and interface DA_STAT to link the DA Union Code to the company | |
| Employee number (MNR) | persons nationality + PIN number | |
| CPR-Number | Persons Personal ID | |
| Data Type (ILTYPE) | What kind of information is reported. | |
| Units(ENHEDER) | Number of units for the relevant ILTYPE. Mandatory for ILTypes marked with Days | |
| Amount(BELØP) | Amount for the relevant ILTYPE. Mandatory for ILTypes marked with ØRØ under the column Beløp in the guide | |
| P-Number (PNR) | Persons payment currency + vessels IMO number |
D
Download the Plug-In
http://download.adonis.no/files/upgrade/PersonnelManager/Plugins/Replicator/APL/
UpdatePack_APL_2020.01.10.1.cab
Installing the plugin
See : Installing and distributing the Replicator plug-in
Plugin Parameters
A plug-in will request certain parameters like authentication details, server url, names etc. These parameters are different from plug-in to plugin, before scheduling the plug-in the administrator need to set the correct parameters.
- In the right Panel of the replicator manager expand the plug-in and select plugin parameters
In the right-hand screen select the site and add the parameters manually. 
Plugin specific parameters for the Apollo Interface
Below you find the plugin specific parameters, note the parameters are case sensitive.
Parameter
Description
CLIENTID
Authentication parameter (ADONIS_Crew)
CLIENTSECRET
Authentication parameter (Contact Apollo)
COMPANYCODE
Authentication parameter (Contact Apollo)
DATABASE
Adonis Database
SERVER_NAME
Database Server
Leave blank after synchronizing both systems. .
Parameter used during the initializing or if a full download is needed
1 - reload all data from APOLLO
yyyy-mm-dd (e.g. 2019-01-15) - reload all modification given after a particular date. Use this after restoring APM and repopulate the database with the lates Apollo information.
Cross reference (XREF) Setup
In Adonis the functionality exist to link all general code and levels in the organization structure to a 3rd part code. Before starting the plugin the Administrator need to add Apollo XREF codes.
In the general codes > Interfaces
Create the a new interface Apollo, Add this to the Plugin parameter XREF.
This is used by the plugin to determine which XREF codes to use.
The following XREF Codes are used:
General Codes: Color, Ranks, Competences, Travel Documents
Organization Structure: Company, Vessel
Monitoring Surveillance
Status last execution.
To retrieve the latest interface execution status, open the replicator monitor
In the left pane select the Apollo interface plugin in the status menu. It is located directly below the Adonis Replicator status. In the right pane you will find the status of the last execution.
Execution Log:
In the directory where the Apollo plug in is installed you find the log file containing the status of the last 4 weeks of execution.
Open the file aplint.log using notepad, and you find the latest entries at the bottom of the log file.
Reset the replication
Run the following SQL
UPDATE PWINTERFACETASK
SET LastImport= NULL
WHERE TASK='APOLLO_TASK' and SiteNr=<site# of active site>
ILTYPE and configuration
Annual Summary Code Definition Header
To identify which entry code and field is used by the DA Statistics you need to define National Code DA_STAT and the AS Codes.
New AS National Code
To be able to add the ILTYPES as AS Codes you need to define a new National Code named DA_STAT.
Goto General Codes > Payroll > Annual Summary Definition Header
and add the code DA_STAT
Annual Code Setup
Goto Setup > Tables > Payroll > AS Codes
Select the national code DA_STAT and define the AS Codes as defined by the DA Payroll statics information. See links in above.
In addition to the standard codes you add two more codes CENTS and DAYS these are used to identify if the entrycode/field contains an amount or an unit.
see screenshot below
Define entry code and field to be exported
In the entyr code maintenance screen select the entry code that need to be included in the reporting and select the field containing the units, amounts and link them to correct AS Code, ILTYPE.
As code 1 is reserved for the ILTYPE and AS Code 2 is used to identify if it is an amount or unit, days.
Download the Plug-In APM_Plugin_DaPayrollStat_2020.x.x.x
http://download.adonis.no/files/upgrade/PersonnelManager/Plugins/DaPayrollStat/
Installing the plugin
After downloading the plugin on the server APM is installed execute the file, the installation set will prompt you for the APM location. After adding or selecting the correct location hit install.
The plug will be installed below the given location in directory labeled PLUGIN
On start-up APM will detect the plugin and make it available in menu Tools>Export > DA Payroll Statistics
Access Rights
The plugin is also detected by the Adonis Control Center, once detected the administrator can give user groups access to the interface.
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
|