Versions Compared

Version Old Version 4 New Version Current
Changes made by

Erick Meijer

yuriy.biryukov

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Page Properties

Description

DA Payroll Statistics

Latest Version

2022.1.0.5

Release Date

Download Path

Download

Type

APM Plugin

Description

The DA

-

Payroll statistics is implemented as an APM

plugin. How

plug-in. For how to install the plug-in see the section

Houskeeping

Housekeeping below.   The following requirements are implemented.  

View file
nameSTANDARD FOR ELECTRONIC STATISTICS REPORTING DIS Wage statistics.pdf

height150

View file
nameWAGE STATISTICS DIS Guidelines for Danish Shipowners.pdf

height150

Table of Contents
minLevel1
maxLevel7
excludeContents


Compatible

Compatible with APM 2019.50 or higher*

*Requires cross reference table; 

PW001P01_XREF Panel
titleOn this Page
Table of ContentsmaxLevel3indentOn this page

Houskeeping

Interface

PW001C000_XREF, and PWORG_XREF

Location 

After installing the plug-in the plug-in is available in the following location

Tools > Export > DA Payroll Statistics

User Interface

Functionality

After setting up the plug-in as described in 'Housekeeping' section below, you start the plug-in.  

In the plug-in you add the last information needed in the Reporter section of export file; Supplier Identification, System Number and the date of the export.  

Image Added

Main Selection

Image Added

In the main form of the plugin you select

  • the year or month to report,

  • the Reporting Company

  • DA_STAT National Code

  • In the field ‘Vessel Org.' you can select the organization that contains the DIS vessels and select the vessel that need to be included in the reporting. Note that selection of vessels is not mandatory, if none selected, the system will report everyone employed by the selected Company.

Note

Once you have made the main selection, hit the Refresh button to populate the person and payroll tab. 

Export

You can then select the persons or use 'Tag All' and create the export file.

Image Added 

*see housekeeping below

Housekeeping

XREF Interfaces used: 


The DA_Payroll Statistics plug

ins

-in 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

go to:

Setup > General Codes > Interfaces

Image Removed

Reporter Setup Row type 1:

Image Added

Vessels configuration

To add 'DIS Dansk International'  open General Codes → Vessel → Register

Image Added


DA Payroll Statistics is only reported when serving on DIS (Dansk International Ship register) in the vessel set-up organization structure select DIS.

Image Added



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

Image Removed
Image Added

Reporters Name (INAVN)

Company Name


Reporters Address (IADR)

(DA Union CodeUse the company XREF tab and interface DA_STAT to link the DA Union Code to the company

Image Removed

Adress Company address in Organization unit

Reporters Post Code (IPOST)

Company Address

Image Removed

Image Added


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

Image Removed
Image Added

CPR-Number

Person ID

ITYPE


IPTYPE

See description below 


MKODE

See description below


IPTYPE and MKODE configuration

ITYPE


IPTYPE

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. 

Contract Type on Payscale Table. If Payscale Table Contract type is empty - then use Contract Type from Personal details.

Interface code DA_0200 in the contract type XREF identifies the correct MKcode to use. 

Image Removed
Image Added

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.

Image Removed

Image Modified

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.

Image Modified

ADF

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. 
Image Removed

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

XREF_SEASERVICEXREF Code identifying the seaserviceXREFInterface name.DAYSAHEADNumber of days the interface should "look ahead" to identify crew members that are planned to go onboard.  STARTDATEPossible to give  particular start date from which the system should select crew members.  Should only be used to synchronize both systems during the initialization phase. 
Leave blank after  synchronizing both systems. .  RESETDATE

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.

Image Removed

  

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 

Screen shot from Resco interfaceImage Removed

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.   

Image Removed

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>

This update statement will force the system to import all information from Apollo. 


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

Image Added

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



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

Image Added


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

Image Added

Define entry code and field to be exported

In the entry 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. 

Image Added

As code 1 is reserved for the ILTYPE and AS Code 2 is used to identify if it is an amount or unit, days.  

More details on the setup of Entry Codes can be found here Payroll setup for DA reporting (Danish Payroll Statistics)

Yearly maintenance

The AS Codes and Entry Codes settings for DA Statistics reporting need to be transferred manually after each year closure:

  1. Go to Plugin > Setup

  2. Transfer Definition

  3. Select the correct years and Transfer

Image Added

Download & Install the plugin

Download

http://download.adonis.no/files/upgrade/PersonnelManager/Plugins/DaPayrollStat/

Installing the plugin

After downloading the plug-in on the server where 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-in will be installed below the given location in directory labeled PLUGIN

On start-up APM will detect the plug-in and make it available in menu Tools>Export > DA Payroll Statistics


Access Rights

The plug-in is also detected by the Adonis Control Center, once detected the administrator can give user groups access to the interface. 

Image Added




Panel
titleRelated Pages
Filter by label (Content by label)
showSpacefalse
cqllabel
in ("replicator","plugin","oracle","resco")
= "apm-plugin" and space = currentSpace ( )