Show if | ||
---|---|---|
| ||
To read more about our different types of releases (main release, intermediate release), click me!
Page Properties | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Note | ||
---|---|---|
| ||
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.
Release Highlights
New Layout
In APP release 2021.20 we present significant improvements to the Personel Portal interface.
For better navigation, we've added a toolbar at the top of the screen and a hamburger menu with all available modules.
You may find more details about the new layouts via the link below:
Personal Details
New in 2021.20 is the conversion of Personal Details into 'My Profile', containing the employee details, and 'My Documents', listing all the documents held by the employee.
The new layout is more intuitive for a mobile platform as we removed the desktop application look and feel like using grids.
Mobile layout:
Resolved Jira Issues
General Changes
Fixed javascript issue for 'List of Emails' dialogue at the 'Users with incorrect emails' page.
The administrator portal moved to a new layout.
Fixed error with drill duration setup in Administrator portal - TAA Settings - Custom Setting.
Implemented new NAV Crewchange API methods in the frame of Adonis Integration Web Service.
NAV_CallingPortCreate
NAV_CallingPortRead
NAV_CallingPortUpdate
NAV_CallingPortDelete
Implemented full and partial search by Name and Position at the Co-Workers Timesheets - Time Lists By Timesheet.
Implemented modifications to prevent the 'Invalid bt dates' timesheet issue.
Fixed issue with leave days calculation that was related to the specific decimal separator characters
Modified MCA reports. The Voyage number fetched from Vessel Period Name, and the Voyage dates fetched from Vessel Period Start and End dates.
The column WEB_CP_MCA_TRANSACTIONTYPES.ISSHIPCHECK removed as redundant. Fixed error creating new transaction type.
Implemented modifications to Web Service that allow freeing the 'TimeReg Request Queue' and placing the gangway action/registration to a Pending List in case of errors inserting duplicated gangway action.
Added search bar to a Country list at the Travel Expense - Accommodation tab.
Added contents to the NAV methods under Adonis Integration Web Service:
- NAV_CallingPortCreate;
- NAV_CallingPortRead;
- NAV_CallingPortUpdate;
- NAV_CallingPortDelete.
Improved search functionality for Electronic Signing documents. The system allows full and partial search by “Name", "Datetime", and "Description" parameters.
Adjusted template to avoid floating of registered timeblocks on the grid.
Fixed issue with displaying a limit warning message for Travel Expense in a case when limits are not set up.
Modified Muster list scheduler functionality. The higher safety level and will cover the safety IDs from lower safety levels.
The WEB_CP_ACCOUNT table divided into WEB_CP_ACCOUNT_CREW and WEB_CP_ACCOUNT_EMPLOYEE tables. Crew and Employee accounts are stored separately.
Implemented License Server setup at the APP Administrator Panel
API
Applied fix for DG_PersonalInformationRead and DG_PersonalInformationUpdate methods
Due to the Personal Details module re-build, the list of API methods used in this module was modified. Changes affected API calls named like “DG_“ . The full list of API calls can be viewed in Swagger.
The Talos_PersonalDetails_CRUD methods extended with "CV_FileBase64": "string" parameter.
Upgrade set will add document code TALOS_CV into PW001C45, this allows Talos_PersonalDetails_Create and Talos_PersonalDetails_Update method to create and/or modify the CV with proper code.
CONTENTHUB_CHANGELOG_DOCS method modified to return documents with PW001OLEDOCS.CATEGORY=NULL
Implemented URL format validation for the CONTEBTHUB_REPLACE method. When the user enters the URL make sure that the URL starts with 'HTTP'.
CONTENTHUB_CHANGELOG_DOCS modified to return all documents for a PIN, linked to an activity which modified in a given period.
Extended Adonis Web Service methods DG_PersonalInformation, DG_PersonalInformationUpdate, DG_PersonDetails, DG_PersonDetailsSave with new parameters:
- "SHOESIZE": "string";
- "SHIRTBLOUSESIZE": "string";
- "PANTSKIRTSIZE": "string".
Implemented API methods for Talos integration.
Crew Station Bill
Crew Station Bill - Setup 'Revisions'. A new title applied for the safety plans list.
Modified allocation rules for Crew Station Bill. The system checks the dates of the onboard activity and not allows allocation of outside crew member's activity dates. Allocation allowed till the estimated end date.
Zone field excluded from mandatory validation in the Station Header setup.
The Duty dropdown at the Stations setup modified to display code + description.
Implemented column ordering functionality and Column Chooser storage for Cards Handed Out and Preferred Assignment pages.
Framework
Implemented script to switch General Codes automatically to My Documents.
The new layout implemented for Adonis Personal Portal.
Travel Expense
Fixed vessel filtering for Travel Expense selection 'Show all documents approved by this level' filter option.
Added new options for Co-Workers Travel expense that allows seeing all documents that were approved by level:
- Waiting for approval documents;
- Show documents approved by me;
- Show all documents approved by this level.
Time and Attendance, Nonconformity
Modified Audit report dialogue controls.
Fixed issue with displaying and creating the Roster Planning locations.
Extended functionality of the Timecard option 'Approver / Coordinator must add comments to edit/delete time registration'. Implemented the possibility to input comments for new time registration whether it will overlap existing time registration or not.
Personal Details
The Personal Details module UI changed according to a new APP design. The Personal Details module is divided into 'My Profile and 'My Documents'. The API calls were changed accordingly.
Database Modifications
New and Modified Tables
Table
Field Name
Field Type
Description
WEB_CP_ELEMENTS
NAVIGATION
NVARCHAR(100) NULL
Added Column
ICON
NVARCHAR(100) NULL
Added Column
SHOW_IN_CREW_MENU
BIT NOT NULL DEFAULT(1)
Added Column
SHOW_IN_EMPLOYEE_MENU
BIT NOT NULL DEFAULT(1)
Added Column
MENU_ORDER
INT NULL
Added Column
WEB_CP_ACCOUNT_CREW
PIN
INT NOT NULL (PK)
New table
VARCHAR(100) NULL
PASSWORD
NVARCHAR(33) NOT NULL
Resolved Jira Issues
General Changes
Key | Summary | Type | Release Notes |
---|---|---|---|
APP-3646 | Extra word 'pin' in warning message once adding new employee in AEP | Bug | Modified warning message if the Email of the employee is missing or not valid at the Administrator - Add Employee Portal Users page. |
APP-3573 | Password expiry date issues for Admin/Crew/Employee. | Bug | Added fix to update password expiry date changes on the user's list right after changes were applied. |
APP-1530 | Entered server/database name is dropped after connection test | Bug | Fixed issue when entered server/database name was dropped after connection test in the Administrator Portal. |
APP-3532 | Admin Portal ->Access Control: the error appears when a role for usergroup is defined but no user group exists | Bug | Added validation to prevent saving Role(s) without User Group and excluding all Role from the existing User Group. |
APP-3221 | Read Access for Roster Planning | Bug | Implemented 'Read' access rights for the Roster Planning module. |
APP-3861 | API request MCA_ReOpenCurrentStatement drop DB records in WEB_CP_MCA_HEADER | Bug | Modified MCA_ReOpenCurrentStatement to return a correct error message when trying to re-open an already opened statement. |
APP-3731 | Add filter button to the CAM crew list | Change Request | Added filter button for crew members list in the Cabin Allocation scheduler. |
APP-3565 | Make Cabin allocation crew list more similar to crew station bill | Change Request | Modified design of the Cabin Allocation module similar to Crew Station Bill module. |
APP-3559 | Conflict notifications not displayed on the Tile | Bug | Fixed notifications about the allocation mismatch on the Allocation Tile. |
APP-3500 | Missing option to use daily view in cabin allocation scheduler | Change Request | Implemented daily view on the Allocation scheduler. |
APP-3863 | Not possible to add time registration | Change Request | Fixed issue with manual adding time registration on Co-Workers Timesheets - By Timesheets page. |
APP-3983 | CSB_Safety_Card report doesn't work without Zones | Bug | Added possibility to generate the CSB_Safety_Card report without Zones linked to a Station Headers. |
APP-3440 | Safety ID’s column disappeared from the CSB scheduler | Bug | Added fix for 'Show Safety ID’s with missing assignment' in the Crew Station Bill scheduler. |
APP-3836 | Convert MVC Flight Details | Change Request | The Convert MVC Flight Details module UI converted to DevExtreme components. |
APP-3817 | Convert MVC TAA Periods page to devextreme | Change Request | Time and Attendance Periods page UI moved to DevExtreme. |
APP-3779 | The silent installation feature is not works | Bug | Applied fixed for a silent installation. |
APP-3581 | ADD HTTPS support on the server-side | Change Request | Added HTTPS support on the server-side for the TimeClock application |
APP-3480 | Zip and Upload APP files to Azure using REST API | Bug | This is fixed now |
APP-3184 | The installer should modify sections in the web config | Bug | The installation set will check if there is web site HTTP/HTTPS binding and comment/uncomment endpoints in the Web.config file. |
APP-2849 | Modify installation set to work with Azure (Adonis Cloud) | Change Request | The installation set was modified to work with Azure (Adonis Cloud) |
APP-3828 | Disable save button in My Profile - General details | Bug | Applied change to activate the 'Save' button after modifications in My Profile General Details dialogues. |
APP-3823 | The NULL parameter is displayed in the empty Address field | Bug | Applied fix to exclude NULL value in the empty address field in My Profile. |
APP-3812 | Delete profile picture button always active at the Profile picture dialogue | Bug | Modified control behaviour for My Profile - Profile Picture dialogue. The 'Delete Profile Picture' button will be active only if a photo exists. |
APP-3810 | The Save button is always active in Customized views. | Bug | Applied changes to activate the 'Save' button after modifications for Customized Views in My Profile. |
APP-3808 | Use field Names instead of Codes in My Profile | Bug | Excluded abbreviations in field names in My Profile General Details and Next of Kin tiles. The Name will be displayed instead of Code. |
APP-3789 | Add confirmation message after adding scan to a document | Bug | Implemented the confirmation toast message that appears once the attachment was added to My Documents. |
APP-2777 | MLC Rule D (weekly work/rest hours limitations) violation is not working for 69 hours rest | Bug | Applied fix for MCL Rule D - when a crew member has less than 70 rest hours in any 7 days |
APP-2776 | MLC Rule D (about weekly work and rest hours limitations) violation is not properly processed for some work and rest consequences. | Bug | This is fixed now |
APP-3825 | Add hint for long document name | Bug | Added hint with the full name of a document type in My Documents. |
APP-3931 | My Documents issues | Bug | Fixed issues with displaying the document details in My Documents. Modified validations for enclosed documents. |
APP-3830 | Review My Documents Cards | Bug | Applied changes for My Documents cards UI. The codes a replaced with descriptions. The long text truncated, a full description will be shown in the hint pop-up. |
APP-3811 | Add confirmation dialogue when removing the attachment in My Documents | Bug | Added confirmation dialogue when removing the attachment in My Documents. |
APP-3540 | Display document description instead of CODE | Bug | Modified document cards title in My Documents to display the code description. |
APP-3539 | My Documents alignment issue | Bug | Applied fix for documents alignment on the My Documents page. |
APP-3497 | The vessel name appears as Department in the report dialogue. | Bug | Applied fix for the 'Department' selection in the report dialogue for WorkExtraOvertime and WorkAndRestCompilation reports. |
APP-3672 | Text is not fully displayed | Bug | Extended position name filed in the Roster Planning scheduler. |
APP-1539 | Move the button 'Toggle Watch Keeper(s)' to the header of the grid | Bug | The 'Toggle watch keeper' button moved to a header of the grid. The button enables one after crew members(s) tagged. |
APP-3902 | Exclude special characters from allowed symbols in the login form | Bug | Special characters are excluded from allowed symbols in the Crew Portal login form |
APP-3840 | The new tile design does not fit the mobile layout | Bug | Applied new tile design for mobile layout. |
APP-4027 | Talos update method doesn't insert CV file if person already exist | Bug | The Talos_PersonalDetails_Update method was modified to insert a CV file for an existing person. |
APP-4009 | Error message when opening CoA | Bug | Fixed opening the Chain of Approval page and nodes loading. |
APP-4013 | Optimize Co-Workers document grid | Bug | Improved performance for the Travel Expense module. |
APP-3894 | Slow Travel Expense Approval | Bug | Optimized performance on processing and loading Travel Expense documents. |
APP-3917 | Optimize Co-Workers document grid | Bug | The API method TE_CoWorkersTimesheet extended with ‘States’ and ‘Year’ properties to increase performance. |
APP-3926 | Wrong error message after forgot password action | Bug | Added fix for the First Time Login functionality in the Employee Portal. |
APP-3875 | Change CC Definition page name to Service Levels | Bug | Change CC Definition page name changed to Service Levels. |
APP-3871 | A saved scan is linked to a different code, no matter set up | Bug | Modified system to pickup document type from APP settings instead of the APM default setting. If the document type is not defined in the APP settings, the system will use the APM defaults. |
APP-3865 | Personal details: Certificate is saved with the wrong Date From | Bug | Applied fix for My Documents to save correct Date From. |
APP-3405 | Confirmed shifts are shown as Assigned (not confirmed) | Bug | Fixed issue that after violation check is enabled, confirmed violated shifts were shown as Assigned, but not Confirmed |
APP-3297 | Not possible to upload scans/create documents in the Enclosed Documents datagroup | Bug | Implemented the possibility to upload scans/create documents in Enclosed Documents datagroup. |
APP-3849 | Wrong hints for postcode and place | Bug | Modified hint names for Post place and Postcode fields in My Profile - General Details. |
APP-3839 | Not all special characters are accepted for the employee password. | Bug | Modified the list of special characters allowed for the Employee password. Supported special characters for the Employee password: ! " # $ % & ' ( ) * + , - . / : ; < = > ? @ [ |
APP-3824 | Server Error page appeared after session timeout | Bug | Fixed session timeout for TimeAndAttendance controller. |
APP-3822 | TAA Periods: move methods to the web service | Change Request | TAA_Period methods are moved under Web Service. |
APP-3821 | TAA Periods: Copy From/To | Change Request | Time and Attendance Periods: Copy From / Copy To functionality moved to DevExtreme components. |
APP-3820 | TAA Periods: Automatic period creation | Change Request | Time and Attendance Periods: Automatic period creation dialog moved to DevExtreme |
APP-3819 | TAA Periods: Convert Add/Edit/Delete popups | Change Request | Time and Attendance Periods: Add/Edit/Delete dialogues moved to DevExtreme |
APP-3818 | TAA Periods: Convert Grid | Change Request | Time and Attendance Periods grid UI moved to DevExtreme. |
APP-3798 | Timesheet drop to missing state | Bug | Fixed issue when timesheet was dropped to a Missing state in the case when not all days were approved. |
APP-3767 | The Team members list missing for TAA - Co-Workers - Per Date grid | Bug | Fixed the Team members list for TAA - Co-Workers - Per Date grid. |
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. |
APP-3792 | User cannot log in to the employee portal | Bug | Applied extra space trim functionality to an email in user accounts. |
APP-3788 | Migrate to DevExtreme Roster Module - Configuration - Assign Watch | Change Request | Roster Module - Configuration - Assign Watch page moved to Devextreme. |
APP-3014 | Cabin Allocation - Changed sea-service period is not reflected in the module | Bug | Modified Cabin Allocation Module to truncate the allocation end date according to activity end date change. |
APP-3471 | Column definition not applied for my documents | Bug | Modified tile information for enclosed documents. Added preview for jpeg attachment. Field labels were removed.
|
APP-3578 | Missing Help button icon in mobile layout | Bug | Applied fix for Help icon path in the menu for mobile layout. |
APP-3589 | Missing labels for measurements | Bug | Added indication for measurement for Height and Weight fields in My Profile. |
APP-3735 | NAV_CallingPortDelete returns an unexpected error | Bug | Optimized performance of NAV_CallingPortDelete method under Adonis Integration Web Service. |
APP-3757 | Talos Integration - Title incorrectly flagged as mandatory | Bug | Modified Talos_PersonalDetails API method to accept the Title parameter as an empty string. |
APP-3748 | Convert MVC Timezones page to devextreme | Change Request | Time Zones page UI moved to DevExtreme. |
APP-3713 | General Configuration: link client-side to the server methods | Change Request | Created client-side functionality to гpdate General Configuration |
APP-3711 | General Configuration: Merge Log Tab to Devextreme. (UI) | Change Request | Applied DevExtreme components for General Configuration: Log Tab. |
APP-3709 | General Configuration: Merge WebServices Tab to Devextreme. (UI) | Change Request | Applied DevExtreme components for General Configuration: Web Services Tab. |
APP-3708 | General Configuration: Merge SQL server setting Tab to Devextreme. (UI) | Change Request | Applied DevExtreme components for General Configuration: SQL Server Tab. |
APP-3707 | General Configuration: Merge Mails Tab to Devextreme. (UI) | Change Request | Applied DevExtreme components for General Configuration: Email Server Tab. |
APP-3706 | General Configuration: Merge Organization List to Devextreme. (UI) | Change Request | Applied DevExtreme components for General Configuration: Organization List. |
APP-3700 | The WorkExtraOvertime report loading issue | Bug | Fixed issue with an extra blank page in WorkExtraOvertime report |
APP-3696 | The document is added as DocType: “CERT” but it is inserted in APM (enclosed document) as the Main passport | Bug | Applied fix for DG_EnclosedDocSave method to pick up correct DOCTYPE parameter. |
APP-3293 | Redundant step in setting up first-time login password for AEP | Bug | Reviewed first-time login functionality for the Employee portal. Made changes to avoid redundant credentials change after first-time login. |
APP-3689 | Employee Password Issue | Bug | Applied fix for password change functionality during first-time login to an Employee portal. |
APP-3680 | Convert MVC modules to devextreme: General Configuration | Change Request | General Configuration UI converted to DevExtreme components. |
APP-3601 | Roster module - Wrong list of available crew | Bug | Added EED validation for assigning crew members in the Roster Planning module. |
APP-3602 | Roster module - Assignment is not working properly | Bug | Fixed issue related to Roster Planning assignments. Added validation for EED in the case when crew member assigned with planned activity. Applied fix for an assignment to a number of days. |
APP-3645 | The W&R Compilation report error: The server supports a maximum of 2100 parameters. | Bug | Modified Worc&Rest_Compilation report to allow more than 2100 parameters. |
APP-3592 | Colours are not saved (main release) | Bug | Fixed issue saving the Hair and Eye color that are set for two options in APM - General Codes |
APP-3584 | The issue with personal details methods (main release) | Bug | Applied fix for AIWS methods: DG_TravelViews, DG_CompetenceViews, DG_MedicalViews methods return the correct results. |
APP-3583 | Tiles Design | Change Request | New tiles design applied in Administrator, Crew, and Employee portal. |
APP-3572 | Onboard drills: change timecard setup UI | Change Request | Applied modifications for Onboard Drills module:
|
APP-3569 | DG_EnclosedDocViews is not returning any document | Bug | Applied fix for DG_EnclosedDocViews method to return documents. |
APP-3019 | Wrong calculation of "Hours of rest in any 7 day" | Bug | Fixed calculation of “Hours of rest in any 7 days“ in the reports for activities registered one by one. |
APP-3566 | Electronic Signing: UI Card improvements | Change Request | Implemented UI improvements for Electronic Signing cards. |
APP-3562 | Add Firewall Rules for Azure SQL databases | Change Request | Add Firewall Rules for Azure SQL databases. The IP address or IP address range that will have access to the SQL Server in Azure, can be specified during the installation of Crew Portal on the Azure. |
APP-3560 | Scaling option when uploading a profile picture | Change Request | Implemented scaling functionality when uploading a profile picture. |
APP-3541 | Errors during upgrade from 2021.20.5.1. to 2021.30.1.1. | Bug | Fix for installation upgrade script. |
APP-3537 | Mixed naming in "New Postcode / Postplace" in 'next of kin' | Bug | Applied fix for post place and postcode fields labels. |
APP-3495 | E-Sign documents failed due to unrecognized Guid format | Bug | Created script to re-create a GUID for the Electronic Signing document where GUID=NULL |
APP-3498 | E-signing document is not displayed properly (main release) | Bug | Added memory clean procedure after each ESign document was created. |
APP-3492 | APP Stored Files Type changes | Change Request | Implemented functionality to convert images to a PDF. |
APP-3476 | Enclosed documents: Change the labels in the cards | Change Request | Changed Enclosed Documents cards design. |
APP-3475 | Read Only Entries | Should be able to preview the details even though the file is read-only | Change Request | The system allows previewing the document details and attached files in Read-only mode. |
APP-3474 | No preview of attachment when added in 'My Documents' (Integrate with PDF files) | Change Request | Implemented the possibility to display a preview of a PDF attachment on the My Documents page. |
APP-3473 | Bug Fixes / Changes - My Documents | Bug | Implemented new cards design for My Documents. Added possibility to preview the document with read-only access. Added possibility to display the pdf file shortcut on the document card. |
APP-3436 | APP 'My Documents': Need buttons to show that attachments have been added. | Change Request | Modified Add/Edit document dialogue to display two buttons: ‘Remove Attachment’ and ‘View’. |
APP-3254 | Review Onboard Drills | Change Request | Applied fix for the scenario scheduling functionality. Implemented extra validation that forbids saving drills without assigned station headers. |
APP-3202 | License Service: Move UrlPath for APP - License service integration to DB settings. | Change Request | License Server URL hardcoded in the system. |
APP-2274 | For the "Missed" documents field "Comment" field is always empty. | Bug | The ‘Comment' field is hidden for 'Cancelled/Missing timesheets’ in Time and Attendance module - Past Due and Rejected page. |
APP-2101 | Currency cannot be set per company in TE set up | Bug | Implemented the ‘Use employee currency’ option for Travel Expense documents:
|
APP-2020 | MLC 2006 Rule B violation by watch-keeper show not_watch-keeper violation message on the Registration Details page. | Bug | Fixed issue with displaying violation by the rule '10 hours in 3 rest periods that greater than 1 hour' for watchkeepers. |
APP-1969 | Some rule violations hint messages are not shown for multi-violations on the registration details page. | Bug | Extended the hint messages for violations on the Non-conforming Events page. |
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 |
|
PASSWORD
NUMORGID |
VARCHAR(100) NULL
INT NOT NULL |
|
|
CREATETIME
DATETIME NOT NULL
CREATEDBY
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
Page Properties Report cql label = "app-rn"