APP 2022.20
To read more about our different types of releases (main release, intermediate release), click me!
Software | Version | Release Date | Download Link | Latest Patch |
---|---|---|---|---|
Adonis Personnel Portal | 2022.20 | Oct 24, 2022 |
Important
1) From release 2021.10 Internet Explorer (IE) is not supported.
2) Before the upgrade, records from the repl_Task table with IDs 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 | Compatible APM Version |
2020.60.x, 2021.10. x, 2021.20. x, 2021.30. x, 2021.40. x, 2022.10. x, 2022.20. x | APM 2020.10.x and newer version |
Key | Summary | T | Release notes |
---|---|---|---|
APP-4372 | APP Organization tree | Change Request | The list of organizations in the Admin Portal - Configurations modified to be displayed as a tree structure. |
APP-4342 | Invalid date format in the Edit Portal User dialog | Bug | Fixed issue with displaying and saving the 'Password Expiry Date' in the Administrator Portal - Manage Users - Edit Portal User dialog. |
APP-3841 | Not possible to define the currency rate | Bug | Implemented a possibility to add a currency exchange rate in the Administrator Portal - Configuration - Travel Expense & WDA - Currencies page. |
APP-2988 | Forbid delete travel reasons linked to travel documents | Bug | Modified the alert message when deleting the Accommodation, Various expenses which already in use. |
APP-4430 | FK constraint trying to give full access to a new Role | Bug | Implemented a possibility to pick up mandatory fields for Travel documents and Certificates in the General Codes in APM. |
APP-4510 | Web Service method DG_PersonalInformationRead doesn't return an email | Bug | Modified the DG_PersonalInformationRead API method to return an Email. |
APP-3362 | TAA_ApprovedTimeSheets method refactoring | Change Request | Improved and refactored the TAA_ApprovedTimeSheets method. |
APP-4376 | Search doesn't find persons by pin in the Cabin Allocation module | Bug | Modified search field functionality for Crew Station Bill and Cabin Allocation Module. The Search field allows full and partial searches by PIN, Name, Position, and Date. |
APP-4466 | Change the result message after allocation in the CAM module | Bug | Modified the result message after auto-allocation in the Cabin Allocation module. The list of auto-allocated PINs will be displayed separated by a comma. |
APP-4352 | Need to add Unknown, Non-binary genders in the Cabin Allocation module, Next of Kin | Change Request | Gender (Sex) input now provides four types: Male, Female, Non-binary, and Undefined. |
APP-4531 | Missing filtering in the Audit grid | Bug | Implemented filtering options for the Audit module. |
APP-4187 | Invalid by dates timesheet processed for electronic signing | Bug | Forbid to approve for signing the time sheets invalid by dates. Modified a warning dialog to display a Document ID of the corrupted document. |
APP-3769 | Missing notifications on the Co-Workers Timesheets tile | Bug | Review the tile notifications for the Time and Attendance module |
APP-4465 | CrewChang Service Levels don't load for various pages. | Bug | Fixed an issue with loading the Service Levels list on the Crew Change Requirement page. |
APP-4432 | The ‘Request Entry Too Large’ error message scheduling new Route | Bug | The duration of the Route during planning is limited to three years. |
APP-4669 | The image preview error for CSB Evacuation plan | Bug | Fixed an issue with opening the evacuation plan preview in the Crew Station Bill - Safety Plan setup |
APP-4584 | Assignments for persons with planned activities are not shown in CSB | Bug | Applied fix for Crew Station Bill module to display crew members with planned activities on the scheduler. |
APP-4559 | CSB: Module is not operational performance wise | Bug | Improved performance for Crew Station Bill module on loading the Not assigned crew and Signing On crew list views. |
APP-3923 | CSB: No indication about changed/deleted activity | Bug | Implemented a possibility for the Crew Statin Bill module to align the assignments to activity dates if the activity was changed, or delete the assignment if it is out of the activity dates. |
APP-3586 | CSB- Muster List is working too slow | Bug | Improved performance for Crew Station Bill module on loading the Not assigned crew and Signing On crew list views. |
APP-3484 | DFDS_CSB_Evacuation card report migration to APP | Change Request | The Crew Station Bill Evacuation card report migrated to APP |
APP-3213 | CSB: Several crew members on the same Safety ID | Bug | Implemented a possibility to assign a crew member on several Safety IDs. Overlapped assignments will be truncated accordingly. |
APP-4518 | Reduce the width of the columns on the D2D Roster Planning | Bug | The column width on a D2D Roster Planning scheduler is reduced to display 24h in one view. |
APP-4517 | Change a warning message in D2D Roster Planning | Bug | The warning message for duplicated assignments was extended with PIN+Name and assigned trip date. |
APP-3913 | D2D: Remove activity based on D2D assignment | Bug | Implemented functionality to create and modify planned onboard activities via D2D Roster Planning assignments. |
APP-4578 | The Description is not updated after the document signing. | Bug | Fixed an issue with updating a description of the Electronic Signing documents. |
APP-4577 | The Modified date is not updated when the document is rejected by the API call | Bug | Modified the RejectDocument API method to update the modified date of the document |
APP-4562 | ES API - remove SequenceNo from the response. | Change Request | The Sequenceno was removed for the Electronic Signing Service methods responses. |
APP-4560 | Rostered hours are included in Gratuity calculations | Bug | Rostered hours (not confirmed) in the Roster Planning module are excluded from the Gratuities calculations. |
APP-3188 | The error message "Nullable object must have a value." was raised after Gratuity Submission | Bug | Changed the error message when submitting the gratuities with Share = 0. |
APP-4481 | Report upgrade utility doesn't work | Bug | Applied fix for a report upgrade utility. The reports will be automatically updated during the APP upgrade. |
APP-4463 | The error calling .NET DLL method on installation | Bug | Fixed the error calling .NET DLL method during the APP installation |
APP-3750 | Silent APP upgrade in the case when IIS is located on a different computer than Replicator Service | Change Request | Modified the installation set of the APP to perform the silent upgrade for the cases when Replicator is installed on one server, but IIS is on another server. |
APP-4490 | The date/time is not displayed in the 'Previous ETA' field | Bug | Applied fix to display the 'Previous ETA' in the Crew Change module details. |
APP-4530 | The document attachment can not be deleted. | Bug | Fixed issue with deleting the attached file from the My Documents. |
APP-4529 | "My Documents" is missing field length validation | Bug | Modified a warning message on the My Documents page when the entered characters in the fields Document Number, Issued By, and Issued Where are greater than 50 symbols. |
APP-4523 | Mandatory fields are not fetched for the Travel and Competence documents. | Bug | Implemented a possibility to pick up mandatory fields for Travel documents and Certificates in the General Codes in APM. |
APP-3424 | Drill coordinator by Position | Change Request | The system allows setting a coordinator's position only for drills and scenarios. If the position only is defined, any crew member in this position can confirm the drill or scenario. |
APP-2961 | Onboard drills module - Warnings are not displayed and not removed properly | Bug | Mandatory fields were removed from the Scenario and Drill scheduling dialog. The system allows to schedule a Scenario/Drill without defining a coordinator. |
APP-4498 | Enclosed Document is not displayed on the page | Bug | Applied fix for javascript error on opening the Enclosed Documents page. |
APP-4497 | Cannot create a document due to Uncaught Error | Bug | Applied fix for javascript error on opening the My Documents page. |
APP-4455 | My Documents - DateTime format | Bug | Fixed DateTime format displayed in the My Documents tiles. |
APP-4272 | My Documents page contains two hidden tiles | Bug | Fixed CSS styles for the My Documents page. |
APP-4165 | Duplicated key value error adding a profile picture | Bug | Fixed the error message when uploading a profile picture into the database. |
APP-4693 | Roster Planning Person assignment popup UI broken | Bug | Fixed Persons Assignment dialog opening in the Roster Planning module |
APP-4649 | Violation check not working for not confirmed time blocks | Bug | Implemented violation check for confirmed and planned time blocks in the Roster Planning module. |
APP-4638 | Add average hours calculation to the Roster Timesheet dialog | Bug | Added average hour calculation into the Roster Timesheet dialog. |
APP-4639 | Return the Position abbr in the Persons Assignments dialog. | Bug | The position abbreviation is used for the shift indication in the Roster Planning module - Persons Assignments dialog. |
APP-4641 | Add Position abbr / Location abbr into the Roster Assignments report | Bug | Position and Location abbreviations are displayed on a shift in the Roster Assignments report. |
APP-4636 | The Roster Watch setup page doesn't open | Bug | Applied fix for the Roster Watch page opening. |
APP-4603 | Rows are overlapped in the Roster Timesheets scheduler | Bug | Fixed issue with overlapped rows in the Roster Timesheet dialog. |
APP-4617 | The Finnish time format is not supported in the Roster Planning module | Bug | Applied a fix for displaying the Finnish time format in the Roster Planning module. |
APP-4625 | Add an extra column for the abbreviation in the Roster by Timesheet report | Change Request | Added new column ABBR into the WEB_CP_ROSTER_LOCATION database table. The Location is used in the reports to indicate a shift location. |
APP-4624 | A summary listing the actual working hours like start-end location position in the Roster by Timesheet report | Change Request | Implemented the Summary section in the Roster by Timesheets report. Functionality is hidden! |
APP-4609 | Roster by Timesheets report to display a Position | Bug | The Roster by Timesheets report layout was modified to display the work blocks with Location abbreviation and Position code. |
APP-4612 | Error message on deleting assignment from the D2D Roster Planning | Bug | Fixed an issue with removing the assignment in the D2D roster Planning module for a crew member with a single quote in the name. |
APP-4605 | Confirm button in right-click menu in the Roster module is always disabled | Bug | The Roster Planning module migrated to a server-side operations |
APP-4588 | The Roster Timesheet report doesn't display the Total Work hours | Bug | Modified the data source of work hours calculations in the Roster by timesheets report. |
APP-4589 | OT is not calculated on the Roster Planning Timesheets dialog | Bug | Applied a fix for the overtime calculations in the Roster Timesheets dialog. |
APP-4570 | Possible to access the timesheet per person directly from the Roster screen. | Change Request | Implemented a possibility to open the person timesheets dialog in three ways:
|
APP-4557 | Not possible Assign shift by ‘Single Shift' | Bug | Applied a fix for a crew member assignment on a single shift in the Roster Planning module. |
APP-4556 | In the Roster module violation should check "not confirmed" and "confirmed" time blocks instead of only "confirmed" | Bug | Implemented violation check for confirmed and planned time blocks in the Roster Planning module. |
APP-4400 | The filter 'By Chain' in the Persons Assignments dialog shows no correct result. | Bug | Improved the filter option 'Person by' in the Roster Planning module - Persons Assignment dialog. |
APP-4442 | Cannot modify a shift with an assigned crew member in the Roster Planning. | Bug | Roster Planning module improvements. If the user changes a person shift, then the system will change only the person shift. |
APP-4419 | The Confirmed/Rostered columns are not fetched the manually added time/blocks | Bug | Modified the hour's calculations in the Persons Assignment dialog. The work types with the ‘isWork’ option are calculated in the totals. The manually added hours are included in the calculation of the total. |
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-4550 | ES document shows the comment as NULL | Bug | Modified approval for signing workflow to avoid displaying empty comments as a ‘null’ value. |
APP-4514 | It is possible to change timesheet periods set up for current/historical dates | Bug | Forbid to modify a timesheet period for current and historical dates in the case when a timesheet exists inside this period. |
APP-4458 | Spelling mistake in the warning message for a Time Registration | Bug | Modified warning message text when the registration Time in equals to a Time out. |
APP-3289 | Timecards Line and Batch Input Time Registrations pages. Switch scale issue | Bug | Fixed an issue with scaling in the Time and Attendance - Timecards line and Batch input time registrations page. |
APP-4677 | Forbid to delete Accommodation and Various linked to a TE document | Bug | Modified the alert message when deleting the Accommodation, Various expenses which already in use. |
APP-4412 | The TE limits are picked up from the previous period. | Bug | Applied fix for Travel Expenses Rates to pick up limits according to the rate period setup |
APP-3376 | The system does not show Rejected TEs under the 'Show all documents approved by this level' view | Bug | Applied fix to display Rejected documents under 'Show all documents approved by this level' view in the Co-Workers Travel Expenses module. |
APP-3180 | If a crewmember changes the date, the currency automatically jumps back to the default setting | Bug | Provided a fix for an issue when the currency changed to default after the travel expense record was updated. |
APP-4573 | The Privacy Policy page is not adapted for mobile layout | Bug | Implemented a mobile layout for a Privacy Policy page. The dialog will be displayed on full screen |
APP-4539 | Hamburger menu items alignment issues | Bug | Applied row alignment in the list of modules in the menu. |
APP-4535 | The Menu items are in the wrong order | Bug | Modified the module items ordering in the menu for the Crew and Employee Portal\ |
APP-4488 | APP - The menu has a maximum width that is not wide enough for big screens | Bug | Applied responsive width to the APP header layout to fit different screen resolutions. |
APP-3158 | Option to accept the privacy policy | Change Request | Implemented a mobile layout for a Privacy Policy page. The dialog will be displayed on full screen. |
APP-4634 | In the mobile mode for WDA broken tabs 'Transportation', 'Accommodation', 'Other', 'Per Diem', 'Advance' | Bug | Applied a fix for the navigation in the WDA module between the document tabs and in the menu. |
APP-4563 | The attached picture truncated in the preview dialog for TE & WDA document | Bug | Added scrolling area for scan preview dialog in the Trave Expense documents on the mobile layout |
APP-4418 | The check box indicator is not updated after modifications | Bug | Fixed issue with updating the 'Has rates' indicator after the period rate was added or removed for an organization in the Administrator Portal - travel Expense & WDA settings - Rates. |
APP-4676 | Cannot add new Approver note to a Multiple chains | Bug | Applied fix for adding a new node to a multiple chain level. |
APP-4670 | The notification tile doesn't show the correct value for TE | Bug | Modified the query that selects a number of documents for the Travel Expense notification tile. |
APP-4637 | Error in delete trigger for WEB_CP_DR_DRILL table | Bug | Applied fix for delete trigger in the WEB_CP_DR_DRILL table |
APP-4582 | CSB Safety Card report: secondary assignments are duplicated | Bug | Modified CSB_Safety_Cards report query to exclude duplicated records. |
APP-4610 | Roster by Positions report to display the positions | Bug | Roster Assignments report modified to display Position abbreviation / Location abbreviation. The time headed simplified, and the ‘00’ and ‘24’ hours marks were removed from the grid. |
APP-4608 | Registration that covers several days is not displayed in the Roster Timesheets. | Bug | A time registration that covers a few days is marked with an arrow icon. It shows that a time registration starts a day before and/or continues the next day. Applied for Roster Planning scheduler, Persons Assignment dialog, and Roster Timesheets dialog. |
APP-3941 | VL ALARMLISTA report not migrated to APP | Bug | Migrated the VL ALARMLISTA report into the APP |
APP-4596 | Change days calculation | Bug | The days onboard calculation was changed in the Roster Planning - Timesheets dialog. Days = SignOff - SignOn |
APP-4583 | Lock the header and footer on the Persons Assignment dialog | Bug | Improved a layout for the Roster Planning - Persons Assignment dialog. The header and the footer of the Persons Assignment dialog are locked to make the controls visible. The only scrollable areas are a person list and a scheduler. |
APP-4585 | Create a report for the Roster planning module based on the screen of Persons Assignment | Bug | Implemented Roster Assignments report. The report describes crew assignments on a daily basis. |
APP-4581 | Add parameters to CAB file of the APP installation set | Change Request | Added parameters to a CAB file of the installation set with embedded parameters: Server Name, Remote User Login, and Remote User Password. Each CAB file will have its own PROGRAMCODE. It means that for Replicator each APP update CAB file looks like a new application. The PsExec utility is included in the CAB file. |
APP-4572 | VL_CrewPlannedTimeCards returns empty array | Change Request | Improved VL_CrewPlannedTimeCards method to return planned timecards. |
APP-4571 | Create a report with a similar layout Timesheet and access from timesheet and Roster planning | Change Request | Modified the data source of work hours calculations in the Roster by timesheets report. |
APP-4565 | Timesheets enhancements | Change Request | Applied modifications for the Timesheets module in the Employee portal:
|
APP-4564 | TE document control buttons are overlapped on the mobile version | Bug | Modified Travel Expense module mobile layout to display the control buttons in the correct style. |
APP-4555 | Restore update script | Change Request | Modified the upgrade script:
|
APP-4527 | Extend Esign information | Change Request | The SendDocumentToSign API method is extended with two parameters: Abbreviation and Description. These values will be displayed on the documents tile in the Electronic Signing module.
|
APP-4524 | DG_EnclosedDocumentsRead returns an error on specific PDF file | Bug | Fixed the error message raised after the system tried to convert the PDF file into a thumbnail on the My Documents page. The system will generate a PDF logo as a thumbnail for the attached PDF file, which can’t be converted to a picture due to any reason. The attached pdf file can still be opened in the document details view dialog. |
APP-4519 | Add the 'Timesheets' tile to the employee portal and implement access rights | Change Request | Applied row alignment in the list of modules in the menu. |
APP-4515 | A new module in the employee portal to display submitted, approved, and processed time sheets. | Change Request | Implemented the Timesheets module in the Employee Portal to display Submitted, Approved, and Processed time sheets. |
APP-4508 | A crew member cannot assign himself as a coordinator in the Onboard Drill module | Bug | Modified crew members selection in the Onboard Drills module. A user can assign himself as a drill/scenario coordinator. |
APP-4507 | Need a link to Adonis HR Help Center | Change Request | Added a link to an Adonis HR 'Help Center' for Administrator, Crew, and Employee portal. |
APP-4489 | TE report issue: Value cannot be null. | Bug | Fixed the issue generating the My_TravelExpense report |
APP-4491 | ServiceLevelAssignments page broken | Bug | Fixed issue opening the Crew Change - Service Level Assignments page. |
APP-4485 | Mismatch in the tabs 'Not Allocated Crew' and 'Signing On Crew' in CAM and CSB | Bug | Modified the logic of the 'Not Allocated' and 'Signing On' crew members lists for the Cabin Allocation and Crew Station Bill modules. |
APP-4484 | Dates format generic solution for Devextreme controls | Change Request | Implemented a generic solution of a date/time format in the APP. |
APP-3786 | Dates format is not consistent and not read from settings | Bug | Applied changes related to a date format setup, corresponding option removed from the Administrator portal. The date format will be picked up from the browser regional setting. |
APP-4008 | CAM and CSB auto-allocation in the CC module | Bug | Improved the auto-allocation functionality in the Cabin Allocation module and Crew Station Bill module. |
APP-4467 | APP-4457 Rows alignment is bad in Roster Scheduler | Bug | Applied modifications to avoid row shifting in the Roster Planning scheduler. |
APP-4464 | CSB: Last day is not covered on the graphic | Bug | Applied fix for the Crew Station Bill and Cabin Allocation schedulers layout to display the correct assignment End Date according to a Sign-Off date of the activity. |
APP-4462 | Delete table WEB_CP_ACCOUNT | Change Request | The WEB_CP_ACCOUNT table, triggers, and replication tasks were removed from the database. |
APP-4456 | Apply Lithuanian characters changes in APP | Change Request | Applied changes to handle the Lithuanian characters. The column type changed from VARCHAR to NVARCHAR for database columns:
|
APP-4451 | APP extend services configuration | Bug | The General Settings in the Administrator portal are extended with the Electronic Signing service link and Adonis_Esign_API password setup.
|
APP-4450 | E-signing functionality enhancement - Swagger | Change Request | The API methods related to Electronic Signing functionality are added to the Swagger under the Web Services. |
APP-4449 | E-signing functionality enhancement - ES Module | Change Request | Modified Electronic Signing module according to API changes. The UI and workflow were not changed. |
APP-4448 | E-signing functionality enhancement - API Methods | Change Request | Created five basic methods for the Electronic Signing functionality that 3rd party can use:
|
APP-4447 | E-signing functionality enhancement - Timesheet | Change Request | The Electronic Signing module was modified to work with 3-rd party applications. There are three categories for the documents: Pending (to be signed), Signed, and Rejected. |
APP-4445 | Add abbreviation to the Worktypes | Change Request | Added abbreviation field for the work types properties in the Administrator Portal - Time and Attendance Settings - Work Types. |
APP-4438 | Errors during upgrade from 2021.40.13.1 to 2022.10.1.1 | Bug | Modified the SQL upgrade script:
|
APP-4436 | Dates format inconsistent in Travel Expense | Bug | Modified the date formatting on the server-side for the Travel Expense documents. |
APP-4371 | Extend the method with a picture field (BASE64) | Bug | The FL_Dynamics_create and FL_Dynamics_Update methods are extended with the 'EmployeePictureBase64' filed. This gives a possibility to upload the employee's picture. |
APP-4344 | Can't submit TS | Bug | Modified date interval checking for Submit and Approve timesheets. The system picks up approved days in the frame of the Onboard activity. |
APP-4387 | Hours calculation box enhancements | Bug | Extended the hours calculation box in the Roster Planning module. All the time blocks are included: confirmed, planned, and manually added. |
APP-4386 | Rearrange the total hours values in the Persons Assignment dialog | Bug | Applied font size fix for the Persons Assignment dialog. The total hour's box will be refreshed after re-opening the Persons Assignment dialog. |
APP-4385 | The Hours calculation Box should display work types. | Bug | The Roster Planning module - Persons Assignment dialog is extended to display the totals for each scheduled work type. |
APP-4260 | Move and improve the position category define to D2D Roster Planning | Change Request | Implemented D2D Roster Planning module Setup page. The Setup page allows defining the activity code and position category. |
APP-4247 | Login failed for user ADPW if the password contains a semicolon | Bug | Extended the ADPW password to contain special characters. |
APP-4242 | Wrong trips planned lead to incorrect displaying in D2D Roster Planning | Bug | Improved trip planning procedure in the Crew Change module. |
APP-3799 | Make Timesheets available in Employee Portal | Change Request | Implemented a possibility to display Timesheets in the Employee |
Database Modifications
New and Modified Tables
Table | FieldName | FieldType | Description |
WEB_CP_TRAVEL_BILLS | ADDRESS1 | nvarchar(80) | Change field type |
WEB_CP_TRAVEL_BILLS | ADDRESS2 | nvarchar(80) | Change field type |
WEB_CP_TRAVEL_BILLS | ADDRESS3 | nvarchar(80) | Change field type |
WEB_CP_TRAVEL_SPECIFICATION | T2_PASSENGERS_NAMES | nvarchar(80) | Change field type |
PWTALOSWAITINGROOM | Firstname | nvarchar(80) | Change field type |
PWTALOSWAITINGROOM | Lastname | nvarchar(80) | Change field type |
WEB_CP_ACCOUNT | Drop table | ||
WEB_CP_WORKTYPES | ABBREVIATION | varchar(10) | Add column |
WEB_CP_USER_SETTINGS | WORKTYPES_TO_EXCLUDE | varchar(1000) | Add column |
WEB_CP_CC_CREW_LINKED_SAILINGS | Rename from D2D_CREW_LINKED_SAILINGS | ||
WEB_CP_CC_CREW_PLANNED | Rename from D2D_CREW_PLANNED | ||
WEB_CP_ESIGN | Recreate table | ||
SEQUENCENO | INT | ||
SEQUENCENO_DOC | INT | ||
EMPLOYEE | VARCHAR(100) | ||
STATUS | INT | ||
STATUS_NAME | VARCHAR(8) | ||
WEB_CP_ESIGN_DOCUMENT | SIGNED_DATE | DATETIME | Add column |
WEB_CP_TIMESHEETS_ESIGN | New table | ||
DOCUMENT_ID | INT | ||
SEQUENCENO_EDOC | INT | ||
PIN | INT | ||
WEB_CP_POLICY | IS_ENABLED | BIT | New column |
WEB_CP_POLICY | SEQUENCENO | Drop column | |
WEB_CP_POLICY | NUMORGID | INT | New column |
WEB_CP_TIMESHEETS | WORK_HRS | DECIMAL(19, 2) | New column |
WEB_CP_TIMESHEETS | REST_HRS | DECIMAL(19, 2) | New column |
WEB_CP_TIMESHEETS | OVERTIME_HRS | DECIMAL(19, 2) | New column |
WEB_CP_ESIGN | ABBREVIATION | NVARCHAR(10) | New column |
WEB_CP_ESIGN | DESCRIPTION | NVARCHAR(50) | New column |
WEB_CP_REPORT_SETTINGS | DEFAULT_FOR_TIMESHEETS | BIT | New column |
WEB_CP_CC_ACTIVITY_CODE | New table | ||
SEQUENCENO | INT | ||
CODE | VARCHAR(10) | ||
VESSEL | INT | ||
WEB_CP_CC_POSITIONS | Recreate table | ||
POSITION | INT | ||
VESSEL | INT | ||
WEB_CP_CC_FIXED_CREW | New table | ||
SEQUENCENO | INT | ||
PIN | INT | ||
POSITION | INT | ||
D2D_FIXED_CREW | Drop table | ||
WEB_CP_USER_SETTINGS | TAA_SHOW_PENDING | BIT | New column |
WEB_CP_ROSTER_LOCATION | ABBR | NVARCHAR(10) | New column |
WEB_CP_DR_STATION_HEADERS | STATION_HEADER_SEQUENCENO | INT | New column |