Software	Version	Release Date	Download Link	Latest Patch

Important

1) From release 2021.10 Internet Explorer (IE) is not supported.

2) Before the upgrade, records from the repl_Task table with ID's 3000-4999 that are not related to WEB_CP tables should be deleted manually (see APP-3082 in APP 2021.10 release notes)

Adonis Personnel Portal Compatibility Matrix

APP Version	APM Version*
2020.60.x	2020.10.x
2021.10.x	2020.10.x

* APM version numbers are minimum required to be compatible with the APP version.

Resolved Jira Issues

General Changes

Key	Summary	Type	Release Notes
APP-3778	The WorkExtraOvertime report picks up the wrong positions.	Bug	Modified selection query for Work Extra Overtime report. Applied filtering by the department according to the chain of approval.

Database Modifications

New and Modified Tables

Table	FieldName	FieldType	Description
WEB_CP_CC_SERVICE_LEVELS	SEQNO	INT NOT NULL PK	New table
	NUMORGID	INT NOT NULL
	CODE	NVARCHAR(10) NOT NULL
	NAME	NVARCHAR(30) NOT NULL
	MAXPAX	INT NOT NULL DEFAULT 0
	COLOR	INT NOT NULL DEFAULT 0
	SORTNR	INT NULL DEFAULT 0
	IS_PASSIVE	BIT NULL DEFAULT 0
WEB_CP_CC_SERVICE_LEVELS_CATEGORIES	SEQNO	INT NOT NULL PK	New table
	NAME	VARCHAR(30) NULL
	SORTNR	INT NOT NULL DEFAULT 0
	IS_PASSIVE	BIT
WEB_CP_CC_SERVICE_LEVEL_PERIOD	SEQUENCENO	INT NOT NULL PK	New table
	NUMORGID	INT NOT NULL
	NAME	NVARCHAR(50)
	PERIOD_FROM	DATETIME
	PERIOD_TO	DATETIME
WEB_CP_CC_SERVICE_LEVEL_PERIOD_DETAILS	SERVICE_LEVEL	INT NOT NULL PK	New table
	SERVICE_LEVEL_CATEGORY	INT NOT NULL PK
	SERVICE_LEVEL_PERIOD	INT NOT NULL PK
	POSITION	INT NOT NULL PK
	NUMORGID	INT NOT NULL PK
WEB_CP_CC_POSITIONS_REQUIREMENTS	SERVICE_LEVEL	INT NOT NULL PK	New table
	SERVICE_LEVEL_CATEGORY	INT NOT NULL PK
	SERVICE_LEVEL_PERIOD	INT NOT NULL PK
	POSITION	INT NOT NULL PK
	NUMBER_OF_CREW	INT NULL
	NUMORGID	INT NOT NULL PK
WEB_CP_CC_ROUTES	SEQNO	INT NOT NULL PK	New table
	CODE	NVARCHAR(10)
	NAME	NVARCHAR(30)
WEB_CP_CC_TRIPS	SEQNO	INT NOT NULL PK	New table
	NAME	NVARCHAR(30) NOT NULL
	ROUTE_SEQNO	INT NOT NULL
	PREVIOUS_TRIP_SEQNO	INT NOT NULL
	SRVLV_CATEGORY	INT NOT NULL
WEB_CP_CC_CALLING_PORTS	SEQNO	INT NOT NULL PK	New table
	TRIP_SEQNO	INT NOT NULL
	PORT_CODE	VARCHAR(10) NOT NULL
	DEP_TIME	TIME NOT NULL
	DEP_DAYS	INT NOT NULL
	ARR_TIME	TIME NOT NULL
	ARR_DAYS	INT NOT NULL
	IS_PREFERRED	BIT NULL DEFAULT 0
	PREVIOUS_SAILING_SEQNO	INT NOT NULL
WEB_CP_CC_ROUTES_PLANNED	SEQNO	INT NOT NULL PK	New table
	NUMORGID	INT NOT NULL
	ROUTE_SEQNO	INT NOT NULL
	DATEFROM	DATETIME NOT NULL
	DATETO	DATETIME NOT NULL
	COLOR	INT NOT NULL DEFAULT 0
WEB_CP_CC_ROUTE_TRIP_SAIL_SRVLVL	SEQNO	INT NOT NULL PK	New table
	ROUTE_PLANNED_SEQNO	INT NOT NULL
	SAILING_SEQNO	INT NOT NULL
	SERVICE_LEVEL_SEQNO	INT NOT NULL
	DATE	DATETIME NOT NULL
WEB_CP_CC_CHANGECREWLIST	SEQNO	INT NOT NULL PK	New table
	CALLING_PORT_SEQNO	INT NOT NULL
	DATEOFCHANGE	DATETIME NOT NULL
	PIN	INT NOT NULL
	IS_SIGNOFF	BIT NULL DEFAULT 0
	IS_CONFIRMED	BIT NULL DEFAULT 0
	CURRENTACT	INT NULL
	NEXTACT	INT NULL
D2D_FIXED_CREW	SEQNO	INT NOT NULL PK	New table
	PIN	INT NOT NULL
	RANK	VARCHAR(10) NOT NULL
D2D_CREW_PLANNED	SEQNO	INT NOT NULL PK	New table
	NUMORGID	INT NOT NULL
	PIN	INT NOT NULL
	TRIP_SEQNO	INT NULL
	SAILING_SEQNO	INT NULL
	DATEFROM	DATETIME NOT NULL
	DATETO	DATETIME NOT NULL
D2D_CREW_LINKED_SAILINGS	SEQNO	INT NOT NULL PK	New table
	SEQNO_CREW_PLANNED	INT NOT NULL
	NUMORGID	INT NOT NULL
	SAILING_SEQNO	INT NULL
	DATEFROM	DATETIME NOT NULL
	DATETO	DATETIME NOT NULL
WEB_CP_CC_TRIPS_PLANNED	SEQNO	INT NOT NULL PK	New table
	NUMORGID	INT NOT NULL
	ROUTE_PLANNED_SEQNO	INT NOT NULL
	TRIP_SEQNO	INT NOT NULL
	DATEFROM	DATETIME NOT NULL
	DATETO	DATETIME NOT NULL
	ARRIVAL_PORT_CODE	VARCHAR(10) NULL
	ARRIVAL_PORT_SEQNO	INT NULL
	DEPARTURE_PORT_CODE	NVARCHAR(10) NULL
	DEPARTURE_PORT_SEQNO	INT NULL
WEB_CP_CC_SAILINGS_PLANNED	SEQNO	INT NOT NULL PK	New table
	NUMORGID	INT NOT NULL
	TRIP_PLANNED_SEQNO	INT NOT NULL
	CALLING_PORT_SEQNO	INT NOT NULL
	DATEFROM	DATETIME NOT NULL
	DATETO	DATETIME NOT NULL
	DEPARTURE_PORT_SEQNO	VARCHAR(10) NOT NULL
	ARRIVAL_PORT_CODE	VARCHAR(10) NOT NULL
	ARRIVAL_PORT_SEQNO	INT NULL
	DEPARTURE_PORT	INT NULL
	ARRIVAL_PORT	INT NULL
	IS_PREFERRED	BIT NOT NULL DEFAULT 0

Other Versions

APP 2022.10