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.
Resolved Jira Issues
Resolved Issues
Key | Summary | TypeT | Release Notesnotes |
---|---|---|---|
APP-3778The WorkExtraOvertime report picks up the wrong positions4254 | Work Types are not filtered by the Org.Unit in the TAA Settings. | Bug | Modified selection query for Work Extra Overtime report. Applied filtering by the department according to the chain of approvalApplied grouping for TAA Settings - Work Types page to display work types linked to a selected Organization Unit. |
APP-3936 | WDA option "Create outbound and inbound travels" doesn't save | Bug | Fix the possibility to save the WDA option "Create outbound and inbound travels" in the Administrator portal. |
APP-2528 | Method to import hours per Vessel Project | Bug | |
APP-4085 | VL_CrewPlannedTimeCards should fetch a person whether or not the activity is current or planned | Bug | Expired activities are included in the time block selections for VL_CrewPlannedTimeCards method. |
APP-4429 | Cabin Allocation->Bank Overview page - the buttons don't work | Bug | |
APP-4043 | Add filter option for all cabin properties | Change Request | The cabin filter was extended with new parameters. The cabin filter includes options: Cabin Type, Location, Gender, Position, Capacity, and Telephone. |
APP-3307 | Duplicated allocations created after Reallocation to another cabin | Bug | Fixed issue with duplicated allocations after crew member was reallocated to another cabin. |
APP-3017 | Cabin Allocation - More options for cabins filter for a better overview | Change Request | The cabin filter was extended with new parameters. The cabin filter includes options: Cabin Type, Location, Gender, Position, Capacity, and Telephone. |
APP-4055 | Reorder tabs on the Calling Ports page | Change Request | |
APP-4054 | Route Definition: Copy date/time parameters | Change Request | Implemented functionality to copy date/time parameters from the last calling port of the previous trip. |
APP-4053 | Assign safety levels filtering | Change Request | |
APP-4052 | Sign in and sign-on (crew change) | Change Request | Applied changes for Signing On and Signing Off confirmation on the Crew Change Calling Ports page. The Sign-On and Sign-Off times will be set automatically once the crew member is added to the On Signing or Off Signing tab. |
APP-4051 | Hide fields on the Details view | Change Request | |
APP-4050 | Crew change tiles filtering | Change Request | Improve the crew change card filtering. Added possibility to display cards within a defined period (date and time). |
APP-4049 | Performance of the Planning view | Change Request | Improved performance on the Crew Change Planning page. |
APP-3951 | Route default safety level | Change Request | Added possibility to define a default safety level under the Route Definition page during the planning. It can be overwritten on the Service Level Assignments page. |
APP-4039 | Evacuation plan method in the repository class | Change Request | Implemented the CSB - Evacuation plan API methods in the frame of Adonis Web Service. |
APP-4038 | Evacuation plan Web method | Change Request | Implemented API methods for the Crew Station Bill - evacuation Plan:
|
APP-4037 | Create UI for Evacuation plan | Change Request | Implemented UI for the Evacuation Plan in the Crew Station Bill setup |
APP-4036 | Update Db table WEB_CP_CSB_STATIONS to store Evacuation plan information | Change Request | To store the Evacuation plan information the database table WEB_CP_CSB_STATIONS extended with fields: EVACUATION_CABINS_COUNT, EVACUATION_CARD_ATTACHED, EVACUATION_SOURCE_NAME, EVACUATION_DOCNO. |
APP-3946 | Migrate DFDS_SafetyCrew_Onboard_with_STCW to APP | Change Request | |
APP-3597 | Title for safety id missing in muster list in CSB APP | Change Request | Applied changes in the Crew Station Bill scheduler. The column Safety IDs extended to pick up and display the Default Position and Title name from the Safety ID setup. |
APP-3586 | CSB- Muster List is working too slow | Bug | Improved performance for Crew Station Bill - Muster List page |
APP-3212 | CSB: Evacuation plan is missing | Bug | Implemented a possibility to attach an Evacuation Plan to a Station in the Crew Station Bill - Safety Plan setup. |
APP-3208 | CSB APP Assign stations | Change Request | |
APP-3207 | APP CSB Secondary assignments | Change Request | The assignment name is populated to a Station Header type column in the case when it is Secondary and/or Rescue. |
APP-3942 | D2D: Activities colouring | Change Request | |
APP-4369 | Remove mandatory fields in the Scenario/Drill scheduling | Bug | Modified Scenario scheduling setup. The Coordinator Position, Coordinator Name, and Deck fields are not mandatory. |
APP-4164 | Country Zip list is empty if Country not saved on the General Details page | Bug | |
APP-4153 | Wrong date format at the Personal Details Birthdate | Bug | Modified date format in the General Details - Birthdate field. |
APP-4118 | The 'null' value displayed in the My Profile General Details | Bug | Applied modifications for the General Details page to avoid displaying the ‘null’ value stored in the database. |
APP-4083 | Travel documents non-nullable value type | Bug | Added extra validations for travel documents. |
APP-3784 | The loading issue in the Work & Rest report | Bug | Improved performance of the Work & Rest report. |
APP-3666 | E-sign report generated for a wrong PIN | Bug | Improved Electronic Signing to generate MyTimesheet and Co-Workers Timesheet reports for a proper pin. |
APP-4428 | Roster: summary to display | Change Request | |
APP-4426 | Roster: Include planned time option should impact on a summary only | Change Request | |
APP-4414 | The context menu action in the Roster Planning scheduler doesn't work | Bug | Fixed access rights for the Roster Planning popups. |
APP-4375 | Time does not fit in a cell in the Assign Person window | Bug | Modified the position of the 'Legend' button in the Roster Planning - Onboard Hours Consumption dialog. |
APP-4377 | The error message when changing a time block with an assigned crew member | Bug | Added extra validation to avoid creating planning assignments that overlapped in time. |
APP-4387 | Hours calculation box enhancements | Bug | |
APP-4385 | The Hours calculation Box should display work types. | Bug | |
APP-4384 | Add the 'Persons Assignment' button to a context menu in the roster Planning scheduler | Bug | Added the 'Persons Assignment' button to a context menu in the Roster Planning scheduler. |
APP-4382 | Registrations marked as Rest are counted in the roster totals. | Bug | Time registrations marked as 'isRest' are excluded from the calculations in the Roster Planning totals. |
APP-4377 | The error message when changing a time block with an assigned crew member | Bug | Added extra validation to avoid creating planning assignments that overlapped in time. |
APP-4374 | Server Error when opening Roster Planning -> Planning | Bug | Fixed issue opening Roster Planning module |
APP-4351 | Time blocks have different colours in the Roster planning dialogues | Bug | Applied a similar colour scheme for displaying time blocks in the Roster Planning scheduler, Persons Assignments dialogue, and Onboard Hours Consumption dialogue. |
APP-4346 | Incorrect error message when deleting the assigned watch in the Roster Planning | Bug | |
APP-4341 | Too many decimals in the Watch Total hours | Bug | Fixed decimal format for the Roster Planning Setup - Watch Total hours. |
APP-4237 | Add a new legend item for custom shifts in the Roster Planning module | Bug | |
APP-4308 | Roster Planning: Total shifts vs persons planned table displays truncated information | Bug | Decreased the font size in the Roster Planning: Total shifts vs person overview. |
APP-4297 | Rows alignment on the Roster planning scheduler | Bug | Applied markup fix for the Roster Planning scheduler. |
APP-4331 | Forbid to create overlapped dates Watch | Bug | Forbid to create Watch overlapped by dates. |
APP-4318 | Missing scrolling in the Assign Persons dialogue | Bug | |
APP-4304 | An error appears while opening the Roster Planning module | Bug | Applied fix for Roster Planning access rights. |
APP-4294 | Forbid creating overlapped planning assignments | Bug | |
APP-4157 | Roster module - Violation check doesn't work properly | Bug | Modified Roster Planning violation check. Applied fix to display correct violated rules description for watchkeepers. |
APP-4060 | Employee Selection | Bug | Extended the Roster Planning employee section:
3. Implemented the "Onboard hour consumption" dialog, which opened by clicking on the ‘i' button near the crew member’s name. |
APP-4157 | Roster module - Violation check doesn't work properly | Bug | Modified Roster Planning violation check. Applied fix to display correct violated rules description for watchkeepers. |
APP-4132 | Roster Planning: Total shifts vs persons planned Interval from the scheduler | Change Request | Added flexibility improvement for total shifts to pick up intervals from the scheduler: 60 min, 30 min, 15 min. |
APP-3557 | Missing validation for overlapping planning | Bug | Implemented validation for overlapped and duplicated assignments in the Roster Planning module. |
APP-3426 | Roster reports: options to hide details/Gantt | Change Request | Added the possibility to print only details or Gantt in the Roster reports: Roster by Position and Roser by Crew member. The checkboxes are available in the report dialogue. Only Gantt grid option: Only details option: |
APP-4355 | MyTeams page is in Read-Only access | Bug | Applied fix for My Team access rights. |
APP-3995 | TAA Worktypes: Convert Add/Edit/Delete popups | Change Request | |
APP-3993 | Convert MVC TAA Worktype page to devextreme | Change Request | The Time and Attendance: Work Types page converted to DevExtreme components. API methods moved under WebService. |
APP-3852 | Space is missing in timein and timeout | Bug | |
APP-3805 | The passive state for the Chain node doesn't work | Bug | Improved 'isPassive' functionality for the Chain of Approval. Added additional filtration. |
APP-4367 | TE: filter by User Group does not work for Transportation, Accommodation and Various codes | Bug | |
APP-4044 | TE Module Options page: merge to DevExtreme | Change Request | The Travel Expense & WDA - Module Options page in the Administrator portal migrated to DevExtreme. |
APP-4030 | Travel Expense document lists class refactoring | Change Request | Made refactoring of the Travel Expense module. |
APP-3831 | Adjust letter case | Bug | Modified the name of the 'My Travel Expenses' tile to display the first letter in upper case. |
APP-3189 | Restrict or Forbid to send empty travel expense form | Change Request | |
APP-3868 | Display airport Code+Name in the My Flights grid | Bug | Modified the My Flights module to display more information about the airport: airport code + airport name. |
APP-2624 | To display a message that Travel expenses exist on the attempt to disable Travel reason for Travel expense | Bug | |
APP-4302 | Configuration -> Adonis Web Service- Test | Bug | Fixed WSDL generation. |
APP-4431 | Moodle: Token is not generated error | Change Request | Modified the Moodle authentication functionality. |
APP-4399 | Incorrect Per Diem rates if WDA TE record touches different months | Bug | Fixed WDA per diem currency calculations. |
APP-4258 | Possibility to use Company currency for calculation of Travel Expenses | Bug | |
APP-4357 | FL_Dynamics_Update response with SQL error message | Bug | FL_Dynamics_Update response with SQL error message in a case when PIN number not found in PW001P01. |
APP-4316 | Onboard drills - Can't create scenarios | Bug | Removed the validation for the Stations in the Scenario edit dialog. |
APP-4339 | Password changes do not work for the Employee Portal via Personal Details | Bug | Fixed issue with Employee password change via the My Profile - Change Credentials page. |
APP-4353 | The new documents linked to the passive chain | Bug | Modified document workflow to link a timesheet to a correct (non-passive) chain. |
APP-4354 | The currency code on Accommodation expenses is reset to default for Domestic travel | Bug | Fixed the issue when the Currency code was reset to a default value on Accommodation expenses created for the Domestic travel. |
APP-4314 | Incorrect message during changing the date in the Roster module -> Assign Watch -> Watch Properties window | Bug | Modified warning messages for the Roster Planning Watch Properties page |
APP-4303 | The 'Search' field does not work | Bug | Fixed issue with the disappearing of the 'Search' field on the Roster Planning scheduler. Applied changes to accept copy/paste. |
APP-4329 | Assign a person on the not confirmed shift | Bug | |
APP-4317 | VL_CrewPlannedTimeCards method problems | Bug | Modified VL_CrewPlannedTimeCards method to return timecards linked to expired and planned activities. |
APP-4322 | Need to change the position of the warning message | Bug | Modified the error message positioning on the Roster Planning scheduler. |
APP-4296 | Incorrect message during adding shift in the Roster module | Bug | Modified the error message when assigning a shift that will overlap the existing time registration. |
APP-4305 | Not possible to add a new Shift via the context menu | Bug | |
APP-4300 | Сhange the colour scheme for Roster/Planning for Popups | Bug | A new colour scheme was applied for the Roster Planning scheduler and pop-ups. |
APP-4299 | Incorrect message during Remove All Blocks in the Roster module | Bug | Modified the error message when trying to delete blocks without selected records. |
APP-4138 | Remove Xref codes for PIN, Ranks and LegalEntity Parameters | Bug | Modified FL_Dynamics API calls. The Xref relations were removed for the PIN, Rank, and LegalEntity parameters. |
APP-3937 | D2D Planning validations | Bug | Implemented validation to avoid creating any data in case of any error message. |
APP-3918 | Total S/On and S/Off values are not calculate on the Trip tile | Bug | Implemented functionality that provides instant refresh of CrewSignOn / CrewSignOff values in the Trip tile. |
APP-4256 | Can't approve Timesheet | Bug | Modified timecard selection in the Work&Rest_International report. |
APP-4290 | Assign Watch page missing scroll | Bug | Added scrolling to the Roster Planning - Configuration - Assign Watch page. |
APP-4285 | The onboard hours consumption screen is blank | Bug | |
APP-4287 | Roster Enhancements. Box calculating the actual working hours, OT, and hours rostered issues | Bug | Modified the rostered hours calculation, the manually added shifts are not included in the rostered total. |
APP-4271 | Create a description of the privacy policy function | Change Request | The private policy description document added to the Confluence |
APP-3843 | Customized fields not displayed properly | Bug | Applied layout modifications for the My Profile - Customized fields. |
APP-4255 | Enclosed documents can't be open/loaded | Bug | Optimised enclosed document selection. |
APP-4236 | "Exception of type 'System.OutOfMemoryException' was thrown." for Electronic Signing | Bug | Applied modifications for Electronic Signing functionality. Migrate GetTimesheetDocuments selection to dapper. |
APP-4240 | Add Tile to the Privacy policy from User Profile | Change Request | |
APP-4233 | Exception is thrown trying to change the password for Administrator | Bug | Applied fix for changing administrator password. |
APP-4201 | Read-only access doesn't work | Bug | |
APP-4191 | Not possible to see payslips & any enclosed documents in APP > My Documents | Bug | Applied improvements for a function that generates a thumbnail for enclosed documents locked with a password. |
APP-4222 | Roster Enhancements. Box calculating the actual working hours, OT, and hours rostered | Change Request | |
APP-4221 | Roster Enhancements. Extra column Hrs/Onb | Change Request | Added extra columns for Confirmed and Rostered hours (Conf hrs. / Rost hrs). Total of the hours worked and planned when onboard, counting from the real sign-on date to the real sign-off date. |
APP-4193 | Employees' onboard hour consumption screen | Bug | Implemented employees' onboard hour consumption screen. The dialog gives a more detailed graphical overview of the hours worked and planned for the whole sea service period. |
APP-4001 | Identifying manually added shifts | Bug | Added new database column WEB_CP_ROSTER_WATCH_TIME_ASSIGNED.IS_CUSTOM to identify the manually added shifts. |
APP-4000 | Identifying timecard records created in the roster planning module | Bug | Added new column WEB_CP_TIMECARD.ROSTER_ID to identify timecard records created in the Roster Planning module. |
APP-3999 | Naming - Introduce the term 'shifts' | Bug | Name change introduces the term 'Shift' in the Roster Planning module configuration of the watch and in the planning phases. |
APP-4192 | Scaling issue in the Roster Planning scheduler | Bug | Applied fix for navigation by date in the Roster Planning scheduler and Person Assignment dialog. |
APP-4029 | Add fields for employee portal external URL and friendly name | Bug | Added possibility to set up the URL used for the first-time login and password reset emails. The field 'APP URL in the Email:' is located under the Administrator Portal - General - Email server. |
APP-4160 | Remove the PlannedOverTime parameter | Change Request | The 'PlannedOverTime' parameter was removed from the response of the VL_CrewPlannedTimeCards method. |
APP-4142 | CSB: Wrong list of Not Assigned Crew | Bug | Applied fix for Crew Station Bill crew members selection. Crew members with not a sea-service activity are excluded from the 'Not assigned' list. |
APP-4147 | CSB: Assignment doesn't work | Bug | Modified the activity check function to pick up the correct sign-off date in the Crew Station Bill Muster List scheduler. |
APP-4139 | "The method or operation is not implemented." error message after upgrade | Bug | Applied fix for API methods related to a Crew Change module and connection string initialization for APM ChangeCrewList. |
APP-4148 | Remove the reset password button | Bug | |
APP-4143 | VL_CrewPlannedTimeCards shouldn't pick only persons who are signed on for the hours to be exported | Bug | The expired end date is excluded from the activity selection in the VL_CrewPlannedTimeCards method. |
APP-4114 | Server Error when selecting Crew Change -> Service Level Assignments | Bug | Fixed error opening Crew Change - Service Level Assignments page. |
APP-4137 | Jumping from one user to another, the user can log into Moodle | Bug | |
APP-4136 | Moodle: If emails are equal but have different upper and lower cases, then the login fails. | Bug | |
APP-4135 | If the email is empty in Adonis, then the login fails | Bug | |
APP-4129 | Issues with logging in to APP due to the duplicate e-mail | Bug | Modified sources to pick up Email for the Employee account from PW001P0T instead of WEB_CP_ACCOUNT_EMLOYEE |
APP-4117 | Ugrade issue (web_cp_message_employee_pin is null) | Bug | Applied fix for foreign keys related to sending messages functionality. |
APP-4053 | Assign safety levels filtering | Bug | Improved Trips filtering popup on the Crew Change Service Assignments page. |
APP-4112 | DB isn't upgraded during APP silent upgrade | Bug | Applied fix for APP database upgrade via silent mode. |
APP-4119 | Moodle Test Environment failed Seachefs (Response status code does not indicate success: 400 (Bad Request)) | Bug | Applied fix for secured (HTTPS) connection to the Moodle interface. |
APP-4054 | Route Definition: Copy date/time parameters | Bug | Modified the ‘Route Violations’ dialogue for the Crew Change module: Route Definition setup and Route Planning page. |
APP-4086 | The wrong information is shown in the authorized for signing line on the Timesheet | Bug | Fixed information displayed in 'authorized for signing' in the Work&Rest report for multiple levels of the Chain of Approval |
APP-4105 | AdExec utility should popup AD_UPGRADE password input | Bug | Modified installation set to display the 'Database Login' dialog for a manual upgrade in case of AD_UPGRADE password mismatch. |
APP-4052 | Sign in and sign on (crew change) | Bug | |
APP-4050 | Crew change tiles filtering | Bug | Improve the crew change card filtering. Added possibility to display cards within a defined period (date and time). |
APP-4055 | Reorder tabs on the Calling Ports page | Bug | |
APP-4068 | Cannot allocate signing-on person to a cabin | Bug | Applied fix for allocation functionality from the ‘Signing On crew members’ and ‘Not allocated crew members’ tabs. |
APP-4067 | The EED is not picked up as Sign Off date for a crew members card in CAM | Bug | Fixed issue with EED picked up as Sign Off date for a crew member card in the Cabin Allocation Module for the ‘Not Allocated Crew’ and ‘Signing On Crew’ tabs. |
APP-3951 | Route default safety level | Bug | Added possibility to define a default safety level under the Route Definition page during the planning. It can be overwritten on the Service Level Assignments page. |
APP-3307 | Duplicated allocations created after Reallocation to another cabin | Bug | Fixed issue with duplicated allocations after crew member was reallocated to another cabin. |
APP-4087 | Create FL_Dynamics Create and Update methods | Bug | Implemented FL_Dynamics Create and Update methods in the frame of Adonis Integration Web Service |
APP-4047 | Route definition warning signs | Bug | |
APP-4051 | Hide fields on the Details view | Bug | The fields: Birth, Contact, Airport, and Travel time are removed from the Crew Change module Calling Ports - Details tab. |
APP-4085 | VL_CrewPlannedTimeCards should fetch a person whether or not the activity is current or planned | Bug | Expired activities are included into the time blocks selections for VL_CrewPlannedTimeCards method. |
APP-4080 | Pending signing documents are not displayed for a subordinate. | Bug | Added improvements for ‘Approve for signing’ functionality when sending documents in a batch. |
APP-3940 | APP upgrade doesn't work by replication | Bug | Fixed issue with the silent upgrade of APP via Adonis Replicator. |
APP-4024 | Meal deduction should always be done based on the rate that is applicable for that day | Bug | Applied changes for Meal deduction in the Travel Expense module. |
APP-4056 | Issues with sending messages in APP | Bug | Applied foreign keys modifications for WEB_CP_MESSAGE and WEB_CP_MESSAGE_FOLDER database tables |
APP-3567 | nboard Drill functionality creates an overlap | Bug | Applied fix for inserting 'Drill' time registration via Onboard Drills and Scenarios module. |
APP-4057 | Work and rest hour report issue | Bug | Applied fix for Work and Rest Compilation report to display a correct number of crew members. |
APP-3597 | Title for safety id missing in muster list in CSB APP | Bug | Added tile for Safety ID details in the Crew Station Bill - Muster List page. |
APP-3997 | TAA Worktypes: move methods to the web service | Change Request | The API methods related to Time and Attendance: Work Types functionality are moved under WebService |
APP-3996 | TAA Worktypes: Copy From/To | Change Request | Implemented Copy From / Copy To functionality for Time and Attendance Work Types. |
APP-3994 | TAA Worktypes: Convert Grid | Change Request | |
APP-3987 | Access rights for Moodle module | Change Request | Implemented access rights for Moodle platform. |
APP-3984 | PHP To MSSQL driver | Change Request | Installed the PHP driver to provide an MS SQL server connection. |
APP-3980 | Create Moodle Test Environment at Azure | Change Request | Created test environment for Moodle interface at Azure |
APP-3979 | Moodle Integration | Change Request | Integration with Moodle, a 3-rd party learning/training system |
APP-3968 | Add configuration UI to the APP: Moodle Url | Change Request | Moodle configuration tab implemented in the Administrator Portal - Configuration - General. |
APP-3966 | Login to Moodle without Html Form | Change Request | Implemented login to Moodle without HTML Form. The user will be authorized in the Moodel directly from the Crew and Employee portal. |
APP-3965 | Configure Moodle for External Database Authentication | Change Request | Configured Moodle for External Database Authentication |
APP-3842 | Rename Outlay Types to Various | Change Request | |
APP-3761 | Implement Moodle authentication | Change Request | Implemented Moodle authentication from the Adonis Portal. |
APP-3715 | E-signing document is not displayed properly, and cannot sign | Bug | Improved performance and modified Electronic Signing Timesheets functionality. |
APP-3429 | Rename 'Birthdate' to 'Birth Details' | Change Request | The Birth Details dialogue name changed. |
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
Page Properties Report cql label = "app-rn"