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.
Compatible
Compatible with APM 2019.50 or higher*
*Requires cross reference table; PW001P01_XREF
Location
After installing the plug-in the plug in is available in the following location
Tools > Export > DA Payroll Statistics
User Interface
Houskeeping
Interface:
The DA_Payroll Statistics plug ins uses the following interfae 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
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 |
|
| DA Union Code | Use the company XREF tab and interface DA_STAT to link the DA Union Code to the company |
|
| Adress | Company address in Organization unit |
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 | 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. |
|
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. 
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_SEASERVICE | XREF Code identifying the seaservice |
| XREF | Interface name. |
| DAYSAHEAD | Number of days the interface should "look ahead" to identify crew members that are planned to go onboard. |
| STARTDATE | Possible 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.
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>
This update statement will force the system to import all information from Apollo.