APP-4248

Close button is missing

Bug

The Roster Persons Assignments dialog layout is changed. Fixed the visibility of the missing Close button.

APP-4633

Roster Module - Headers are not locked

Bug

Time line and Positions list are locked to make sure they are visible while scrolling.

APP-4685

Migrate DevExpress MVC to Devextreme: Roster Module

Task

The Roster Planning module is migrated to DevExtreme components.

APP-4686

Give possibility to order Work Types

Change Request

Sorting is added to Work Types. It allows organizing work types based on the sort numbers specified in the Work Types setup. This enhancement provides a more structured approach to managing time registrations efficiently.

APP-5126

APP - Rename birthday field to “Birth Details"

Change Request

The Birthdate name field is changed to Birth Details in My Profile:

APP-5339

Cabin Allocation - After Deallocation option doesn't work

Bug

In the Cabin Allocation module, deallocation assumes selecting a bunk status that will be shown after the actual deallocation of a crew. As a result, the cabin status is set according to the defined option:

Please note if For Cleaning is selected as the bunk status for deallocation, then it’s possible to define the number of days that the bunk status will last (limited to only 1-3 days; default to 1 day).

APP-5343

Cabin Allocation - Mismatch between activity and allocation date

Bug

The Cabin Allocation module fix was applied to correctly read activites date/time. By default, the system uses the start time 00:00 and end time 23:59.

APP-5760

Issues with violations in Roster Planning Module

Bug

Added the violation check enhancements to the Roster Planning module:

• The Show/Hide Violations button is added to the Roster Assignments scheduler.

• The Show/Hide Violations button state is stored in the browser cookies.

• The violations are calculated the same way for all views (TAA as well).
  
  

APP-5790

Migrate Scheduler to DevExtreme Roster -> Planning -> View

Subtask

In the Roster Planning module, the main scheduler is migrated to the DevExtreme:

APP-5791

Migrate Scheduler to DevExtreme Roster -> Planning -> Assignment

Task

In the Roster Planning module, the Assignment Scheduler is migrated to the DevExtreme.

APP-5925

Issues with rates on Travel Expenses

Bug

In the Travel Expenses module, the system picks up rates based on the defined payroll period. The period is fetched based on the dates in Organization > Payroll > Period.

APP-5956

Create Evaluation report

Task

Created the Evaluation report:

The report is generated based on predefined options:

APP-6019

Hide zero totals setting doesn't work

Bug

The timesheet totals are calculated taking into account the Hide zero totals work type option.

APP-6020

Create AUS_CU_EnclosedDocument & AUS_R_EnclosedDocument Endpoints

Task

Created the AUS_CU_EnclosedDocument and AUS_R_EnclosedDocument endpoints.

APP-6021

Create v1/AUS_CU_Activities

Task

The v1/AUS_CU_Activities method is created within the frame of the Adonis Upload Service. The method imports current, planned, and historical activities not linked to the vessels, companies, or organizations registered in Adonis Personal Manager.

APP-6188

Include ConfirmedSignOn in AUS_CU_ActivitiesRotationLink

Task

The AUS_CU_ActivitiesRotationLink is extended with the ConfirmedSignOn parameter.

APP-6270

Create a sharable link and add an API Key validation for the users outside the APP

Task

Implemented the shareable waiting room that can be accessed by using an API key:

APP-6377

Birthdate and email fields are wrong

Bug

Applied a fix to correctly display the birthdate in the user details dialog in Adonis Administrator Portal:

APP-6525

Change the method name from ASA_R_VM to ASA_R_VMCrewlist

Task

The ASA_R_VM method name is changed to ASA_R_VMCrewlist.

APP-6960

System stops responding when opening Overtime > Transactions > Configuration.

Bug

The Personnel Manager Web Service was implemented. It will be utilized by the APM to interact with API methods and house pre-existing logic similar to that of the AIWS service.

APP-6868

APP doesn't send additional fields (Vessel, Department, Position) to Moodle

Bug

Improved the display of the Vessel, Department and Position values in Moodle reports for both vessel-specific (when crew works on Vessel) and employee-specific (when crew works at Office) enrollments.

Vessel-specific enrollment:

• Institution contains a vessel name where a crew has the Current or Planned activity.

• Department specifies the Department and Position names fetched based on crew’s Current or Planned activity.

Employee-specific enrollment:

• Institution displays crew’s Client fetched from Personal Details.

• Department displays crew’s Rank fetched from Personal Details.

APP-6903

Need to split the statuses in the Evaluation form

Change request

Creating a new evaluation workflow assumes the following 4 stages by default:

• Created

• Submitted

• Approved

• Dismissed

APP-6917

2024.20 - APP-6847 - Verification doesn't work issue

Merge

The WEB_CP_TIMECARD_DAILY_CORRECTION table was modified:

• The 'PIN', 'IS_RECORD_DELETED', and 'REJECTED_BY_USER' columns were removed.

• Added new column 'OPERATION_TYPE' VARCHAR(1) with possible values I/U/D (insert/update/delete).

• Added new column 'CHECKED_BY_USER' bit that means 0 - the record is not checked or postponed; 1 - checked/processed.

• The 'VERIFIED_BY_USER' column now means 1 - verified; 0 - rejected (value is valid when 'CHECKED_BY_USER' = 1).

The time cards correction logic changes:

1. The approver/coordinator adds a new record to the timesheet.

2. The system adds it to WEB_CP_TIMECARD and WEB_CP_TIMECARD_DAILY_CORRECTION:

• If the crew member Verify it - do nothing.

• If the crew member Rejects it - delete the record from WEB_CP_TIMECARD.

APP-6919

2024.20 - APP-5832 - PTS10 Different presentation

Merge

In the Roster Person Timesheets view and the Person by Timesheet report, the time blocks are marked with the Position and Location abbreviations.

APP-6925

2024.20 - APP-6916 - The filter is reset in the Personal Timesheet view in the Roster issue

Merge

Applied a fix to the Filter by functionality in the Roster Planning - Person Timesheet view. The selected filtering option is stored for the current session.

APP-6926

2024.20 - APP-4326 - PTS43 Settings are not saved issue

Merge

The Time and Attendance and Roster Planning modules user options are stored as selected.

Time and Attendance:

• Hide manually modified

• Show/hide violations

Roster Planning:

• Show/hide violations

APP-6927

2024.20 - APP-6381 - A terminated crew member can access the Crew Portal issue

Merge

A crew member is not able to access Employee or Crew Portal if his/her contract is terminated.

Note: A crew member can still log in to the Employee/Crew Portal if the termination date = today.

APP-6936

2024.20 - APP-6897 - Missing the Team members filtering in TAA/Co-Workers module issue

Merge

The Team Members selection is added to the Co-Workers Timesheets - Per Date view.

APP-6938

2024.20 - APP-6896 - Total hours rounding is incorrect issue

Merge

In the Co-Workers Timesheets schedulers, applied a fix to display timesheet totals considering the payscale setup.

APP-6940

2024.20 - APP-6928 - Coordinator/Manager name is shown instead of the Reliever issue

Merge

The reliever's name is displayed whenever any daily approval is performed.

APP-6941

2024.20 - APP-6890 - Slow performance printing 'Record of hours of rest' report issue

Added the performance improvements of the Work & Rest and Work & Rest International reports.

APP-6950

APP-6949 API Keys for ChatGPT

Merge

The GNL_APMCrewListViews method has been transferred to the AUS service, now it supports API Keys.

APP-6954

2024.20 - APP-6742 - IMO Report Generation for the shipmate companion

Merge

The IMO_CrewList report is implemented for the Shipmate Companion module. The report displays the crew onboard the vessel for the selected date and port.

APP-6962

2024.20 - APP-6956 - The time registration dates are not correct in the Edit dialog issue

Merge

Fixed the Time in / Time out values In the Edit Time Registration dialog.

APP-6970

AUS_CU_ActivitiesRotationLink: created activities are linked to vessel instead of position

Merge

The AUS_CU_ActivitiesRotationLink is modified to link the activity to a proper position.

APP-6986

2024.20 - APP-6982 - Verification still doesn't work issue

Merge

Applied fix for the time block confirmation of the ‘split time registration’ scenario.

APP-6992

2024.20 - APP-6732 - Implement an MFA authentication page to be used when login (user-id/password) is successful, and MFA is enabled in the portal issue

Merge

The Multi-factor Authentication page has been implemented for the Adonis mobile application. Users can now utilize MFA while logging in to the Employee portal by using their email and password.

APP-7001

Can't confirm record after it was updated

Bug

The issue has been fixed. Confirming time block is successful.

APP-7002

Confirm shifts markup

Bug

The Roster Planning -> Confirm Shift dialog grid enhancements. The From Date, and To Date columns are expanded to display the whole date.

APP-7007

2024.20 - APP-6965 - Timesheets for signing not showing issue

Merge

The Electronic Signing workflow has been enhanced by rearranging the sequence of steps.

APP-7010

2024.20 - APP-7004 - Roster Assign All -> Timeout should be subtracted by 1 second issue

Merge

Implemented a fix to accurately store assignments with the correct timeout when utilizing the Assign all empty function in the Person Timesheet view.

APP-7012

ASA_CU_DPLog: Fix the Error Msg from the response

Bug

The error message ‘044’ for the ASA_CU_DPLog method was modified to display the ExternalID

APP-7013

ASA_CU_DPLog: Taskcodes were not stored in the database tables

Bug

In the ASA_CU_DPLog request, User can utilize multiple task codes separated by commas. This method is designed to distinguish and store each task code individually.

APP-7014

ASA_R_VM: Change the categories of the CrewCategory

Task

The ASA_R_VMCrewlist method retrieves four crew categories from General Codes - Rank.

APP-7015

Rejected Gratuities document is not show in the Portal

Change request

The Gratuities module has been enhanced with the Reversed tab listing all records reverted from APM.

APP-7027

2024.20 - APP-6999 - ContentHub integration processes all records in PW001OLEDOCS issue

Merge

The SQL selection of the AIWS/CONTENTHUB_CHANGELOG_DOCS method is improved to ignore the picture files from PW001P01PICT.

APP-7028

2024.20 - APP-6984 - AIWS: DG_PersonDetailsPicture methods aren't writing CATEGORY issue

Merge

The DG_PersonDetailsPictureCreate and DG_PersonDetailsPictureUpdate methods are modified to populate the CATEGORY ='P' in PW001OLEDOCS.

APP-7029

Improve style to Roster -> AssignWatch scheduler

Sub-task

The Roster Planning -> Assign Watch page layout enhancements. The row height was decreased to display planning information more compactly. Applied the fix for multiple slots assignments.

APP-7032

2024.20 - APP-7018 - The Violation comment not displayed on the TAA schedulers issue

Merge

Applied a fix to display a violation comment in the Co-Workers Per Date and By Timesheet views.

APP-7040

2024.20 - APP-7035 - V1/V2/V3 CU_Person: Remove from checking the P01 table in validating the ExternalPIN issue

Merge

The V1/V2/V3 CU_Person methods validations were modified to use only PW001P01_XREF table.

APP-7042

2024.20 - APP-7038 - Competence/Travel/Medical: Remove from checking the P01 table in validating the ExternalPIN issue

Merge

The ExternalPIN parameter validations were modified to check only the PW001P01_XREF table. The PW001P01 references were removed from the condition.
The following AUS APIs were modified:

• CU_Travel

• CU_Medical

• CU_Competence

• CU_Activities

APP-7044

2024.20 - APP-7037 - AIWS_CU_NOK: Remove from checking the P01 table in validating the ExternalPIN issue

Merge

The AIWS_CU_NOK method validations are modified to use only PW001P00_XREF.

APP-7048

2024.20 - APP-6996 - IMO Crew List returns blank page if there's no data issue

Merge

The IMO_CrewList report is modified to display all the crew onboard the vessel on the selected date. The sign-on and sign-off crew are presented on separate pages.

APP-7049

2024.20 - APP-6994 - Shipmate Companion scheduler performance issue

Merge

Performance enhancements of the Shipmate Companion scheduler.

APP-7060

2024.20 - APP-7031 - Not possible to Submit a Timesheet on sign off day issue

Merge

The system identifies the SignOff (disembarkation) date based on the Estimated End Date value of the current activity. Therefore, the Timesheets are available for Submission both for coordinators and subordinates on sign-off day and later.

APP-7061

2024.20 - APP-7051 - Eckero Timesheet report issues issue

Merge

Modification of the Eckero_Timesheet report:

• Activities section. The ‘Work’ and ‘Rest’ days are calculated accurately in case of position change.

• The compensation hardcoded text value was updated to 'On Duty (weekday, abroad)', and 'On Duty (weekend, abroad)'.

APP-7068

2024.20 - APP-7065 - Gratuities Document not created for some dates issue

Merge

The Gratuities module workflow enhancements. Only one gratuity document per date per voyage (route) is allowed. Forbid to modify the Submitted and Approved document.

APP-7079

2024.20 - APP-7076 - Esign: duplicated timesheets are generated for esign issue

Merge

The system verifies the usage of the Use Daily Approval Workflow setting and restricts the generation of documents to be e-signed if not all days are approved. The TAA_TimesheetValidate method validates the possibility of moving a document to a subsequent stage.

APP-7093

2024.20 - APP-7085 - Signed/verified timesheets are not available for Reliever for Approval issue

Merge

The reliever has access to the Electronic Signing page and all documents that belong to the corresponding manager.

APP-7105

ASA_R_DPLog: Send only 1 valid and the most updated DP Log certificate

Task

The ASA_R_DPLog method returns the most recent and updated certificate. This is accomplished by comparing the dates from, dates to, and expiry dates of crew members' certificates.

APP-7106

2024.20 - APP-7087 - Approver/Coordinator is not able to modify the document when approving it issue

Merge

Added the possibility to modify Evaluation documents by the approver/coordinator. Extended access rights are required to forbid the modification of the Evaluation document after the approval.

APP-7107

ASA_R_DPLog: the API is not picking up persons according to requested VesselIMO

Bug

ASA_R_DPLog has been enhanced to retrieve crew members based on the specified VesselIMO.

APP-7109

ASA_R_DPLog: Include the P03.DATETO and PositionName in the return

Task

The ASA_R_DPLog method is extended with the P03.DATETO as SignOff and PositionName in the response.

APP-7113

2024.20 - APP-7082 - Time to load Crew Change and pop up is displayed (Shipmate companion) issue

Merge

Applied the Shipmate Companion performance improvements.

APP-7116

2024.20 - APP-7086 - Signature is missing after signing issue

Merge

The electronic signature size validation was enhanced with a minimum area of 70X30 px. Rejecting verified documents is now possible for approvers.

APP-7116

2024.20 - APP-7099 - Verification still doesn't work issue

Merge

The timecards correction verification logic was modified: all actions (Insert, Update, and Delete) are stored in WEB_CP_TIMECARD as they are, and WEB_CP_TIMECARD_DAILY_CORRECTION contains only the original state of time registrations.

APP-7146

2024.20 - APP-7135 - W&R Int report failed issue

Merge

Applied a fix to load the company logo into the Work & Rest International report. The general mechanism for catching errors is improved.

APP-7154

2024.20 - APP-7108 - Eckero_Timesheet report returns a parameter parse error issue

Merge

Applied a fix to the Eckero_timesheet report to avoid errors.

APP-7165

2024.20 - APP-7143 - Unable to login after upgrade to 2024.10.5.1 issue

Merge

Enhanced the functionality to prevent errors that might occur in the Finnish regional setting.

APP-7176

2024.20 - APP-7175 - API_KEY_SCOPES trigger error during upgrade from 2024.10.7.1 to 2024.10.8.1 issue.

Merge

The validation and SQL script are extended to create the WEB_CP_API_KEY_SCOPES table.

APP-7193

2024.20 - APP-7164 - Repeat Evaluation is not working issue

Merge

In the Evaluation module, Evaluator can generate a new evaluation document for a crew member that already has approved documents.

APP-7197

Added currency code for Allowance-Abroad

Sub-task

The Currency column is added to Settings → Rates tab → Allowance tab → Abroad tab → Countries Allowance Rates.

APP-7220

v1/AIWS_CU_Person: Make Gender and Nationality fields non-mandatory

Bug

The Gender and Nationality fields are not mandatory for the v1/AIWS_CU_Person method.

APP-7221

v1/AIWS_CU_Competence: Make DateTo (Expiry Date) field non-mandatory

Bug

The Date To (Expiry Date) field is not mandatory for the v1/AIWS_CU_Competence method.

APP-7234

2024.20 - APP-7228 - PDF is generated for signing, but TS status is still Submitted issue

Merge

Fixed the approval for signing timesheets in batch. The system does not generate a PDF file for a timesheet document in case of an error during the Approve for Signing process.

APP-7243

2024.20 - APP-7216 - Can't view some of the Gratuity documents issue

Merge

Applied modification to prevent errors when opening the Gratuity details views: My Documents, Waiting for Approval, Rejected, and Cancelled.

APP-7244

2024.20 - APP-7110 - IMO Crew List report dialog change issue

Merge

The IMO Crew List report dialog is changed. From now on, the Port of arrival/departure and Last port of call fields are free input text field

APP-7245

2024.20 - APP-7072 - WDA - system creates Travel activities for onboard promotions issue

Merge

The WDA module recognizes promotion/position change and creates corresponding travel activity once the document is approved. In the case of crew promotion (Activity A->Activity B), the system disables the Arriving at home section for Activity A, and Departure from home for Activity B.

APP-7248

2024.20 - APP-7238 - GetPersonalAssignmentTotalTable loads very long time issue

Merge

Applied the performance improvements of the RST_GetPersonalAssignmentTotalTable method.

APP-7252

The Evaluation form is not working properly

Bug

The Evaluation form was not available after setting it up. The issue is fixed.

APP-7254

ASA_R_DPLog: Include the activityID and the historical activities in the return

Task

The following changes are in place:

• Added DAYSGAP field (i.e. 180) for the frame of the returned activities

• Sending planned, current, and historical activities of a person with a valid DP_Log certificate

• Included ActivityID in the request

ASA_R_DPLog is working and calling persons within DaysGap defined.

APP-7255

ASA_CU_DPLog: Make the SignOff non-mandatory and include the ActivityID in the request

Task

The EndDate parameter of the ASA_CU_DPLog is no longer mandatory.

APP-7258

The submitted Evaluation form does not appear on the Status Evaluation form

Bug

In the Evaluation module, the Status of Evaluation view displays the record for a crew that sent the Evaluation form (Subordinate submitted the filled Evaluation, then Coordinator submitted the filled Evaluation).

APP-7260

MFA authenticator allows to reset the phone number issue

Merge

The system doesn’t allow changing phone numbers in case they are available in PW001P0T for a user and inWEB_CP_ADMIN.TELEPHONE for an administrator.

APP-7271

TS uncreated no matter registrations and approved days issue

Merge

The RECREATE action button is added to the My Timesheets and Co_workwers Timesheets views. It allows crew members or coordinators to create missing timesheets.

APP-7276

Timecard audit opening failed

Bug

In the Time and Attendance module, right-clicking a timeblock and selecting Audit resulted in an error. The error is fixed.

APP-7286

Time to load Crew Change (Shipmate companion module) issue

Merge

The Shipmate Companion module perfomance and response time have been significally improved.

APP-7287

The 'Bad request' error adding time registration. issue

Merge

Resolved the issue on data type values in the timezones list.

APP-7294

Adding the counter to display the number of crew onboard (Shipmate Companion Module)

Change Request

The Shipmate Companion module was extended with the number of crew currently onboard:

APP-7296

Highlighting documents that are set to expire (Shipmate Companion Module)

Task

The Shipmate Companion module has been enhanced to show expired travel and medical documents required for a crew member. The document codes should be shared for the Shipmate Companion module in the APM General Codes setup.

APP-7303

ASA_CU_DPLog: User ActivityID as a unique identificator

Bug

The Activity ID parameter is now mandatory for the ASA_CU_DPLog method and represents the activity sequence number (PW001P03.SEQUENCENO).

APP-7307

ASA_R_VMCrewlist: Added new fields

Task

The ASA_R_VMCrewlist method is extended with extra parameters:

• DaysGap returns all activities for a defined number of days preceding the current date.

• Interface is a standard interface validation.

APP-7311

DPLog interface validation issue

Bug

Changed the interface parameter validation error message for the ASA DPLog method.

APP-7322

Not picking the new interface from C112 table

Bug

The ASA_VMCrewList method is modified to accept all interfaces stored in PW001C112.

APP-7348

The Monthly Timesheet does not work issue

Merge

The Monthly Timesheet report has been improved by incorporating additional validations to prevent errors.

APP-7362

The information in the Timecards line -> Timesheet state window is empty

Merge

Fixed the Timesheet state popup layout:

APP-7380

Signed TS still shows status Pending signing issue

Merge

The issue is fixed. The signed timesheets display the correct status Verified/Approved according to settings.

APP-7388

Double timesheets issue issue

Merge

The issue has been fixed. The system forbits:

• adding a time registration on the date that comes after the estimated end date of person’s current activity:
  
  

•  confirming the timeblock in Roster Planning when the estimated end date of the sea-service activity is in the past.

APP-7390

The currency is not saved on the Transportation page.

Bug

In the Travel Expenses module, if the Transportation type is set to Other transportation with the “-” type, the following fields are then hidden: Amount, Currency code and Rate.

Module settings:

APP-7393

Rest is not visible under Timesheet > Per date issue

Merge

Fixed the issue on displaying the Rest time registrations in the Time and Attendance module based on the selected/deseleted Display registered Rest option, accordingly.

APP-7408

Work and Rest Report Error "The incoming report has too many parameters" issue

Merge

Enhanced the reporting functionality to effectively manage requests with PIN ranges exceeding 2100. The following reports have been impacted:

• WorkAndRest v.2024.20.3

• MonthlyTimesheet v.2024.20.3

• WorkAndRestInternational v.2024.20.1

APP-7412

Roster by Timesheet report is not working

Bug

Fixed the Roster by Timesheet report generation.

APP-7418

Previous evaluation is not shown under Create Evaluation issue

Merge

In the Evaluation module, on the One-time evaluation tab (Co-Workers Evaluations → Create Evaluation page), added new columns:

• Previous Evaluation Initialized displays the date when the previous document was created.

• Previous Evaluation Approved displays the date when the previous document was approved.

APP-7419

Pins with historical sea-service activity crossing drill's date can't be added as a participant issue

Merge

Added enhancements to the Onboard Drills and Scenarios module. Crew members, with the Historical sea-service activities that cross the drill’s date, will be suggested for participation. Crew members will be available on the Schedule and Execute pages.

APP-7420

Roster Assignments report is not working

Bug

The Roster Assignments report generation has been fixed.

APP-7421

Roster By Crew Members report is not working

Bug

Fixed the Roster By Crew Members report generation.

APP-7422

Roster By Positions report is not working

Bug

Fixed the Roster by Positions report generation.

APP-7429

Wrong date in the Add Time registration dialog

Bug

In the Time and Attendance module, the system picked up the wrong date when adding a time registration.

APP-7433

'Bad Request' error in Assignments popup form

Bug

Fixed the bad request error while assigning crew to the shifts in the Roster Planning module.

APP-7435

Work And Rest International Lithuanian report loading issues

Bug

The issue has been resolved for the Work&Rest-based report to now accurately retrieve the necessary data:

• Work and RestInternational Lithuanian

• Work and RestInternational Lithuanian V2

• Monthly Timesheet

APP-7464

The person is not assigned on the shift via Person-> Assign functionality

Bug

In the Roster Planning module, fixed the issue on assigning crew too the shifts in the Roster Planning module.

APP-7494

Wrong Node after re-creating TS issue

Merge

Implemented a fix for the recreate Subordinates' timesheet document functionality at the Coordinator/Approver level.

APP-7499

[FE] Add/Edit time registration popup is not appeared after clicking Edit item on Overview by timesheets page

Bug

In the Time and Attandance module, fixed the Edit popup.

APP-7507

The assigned shift disappears when the Worktype is changed in the TaA -> Overview

Bug

In case a worktype is marked as Hide in Manual, it is then excluded from the Add Time Registration list:

In case the Display registered Rest option is deselected, all rest timeblocks (IsRest only) are hidden on the timecard even if it’s possible to register them.

Table

FieldName   

FieldType

Description

WEB_CP_TIMECARD_DAILY_CORRECTION 

OPERATION_TYPE 

VARCHAR(1) 

Add column 

WEB_CP_TIMECARD_DAILY_CORRECTION 

CHECKED_BY_USER 

bit 

Add column 

WEB_CP_TIMECARD_DAILY_CORRECTION 

IS_RECORD_DELETED 

Drop column 

WEB_CP_TIMECARD_DAILY_CORRECTION 

REJECTED_BY_USER 

Drop column 

WEB_CP_WORKTYPES 

SORT 

INT 

Add column 

WEB_CP_TRAVEL_BILLS 

ADDRESS1 

NVARCHAR(160) 

Change field type 

WEB_CP_TRAVEL_BILLS 

ADDRESS2 

NVARCHAR(160) 

Change field type 

WEB_CP_TRAVEL_BILLS 

ADDRESS3 

NVARCHAR(160) 

Change field type 

WEB_CP_API_KEY_SCOPES 

New table 

API_GUID 

UNIQUEIDENTIFIER 

SCOPE 

VARCHAR(128) 

WEB_CP_COUNTRY_ALLOWANCE 

CURRENCY 

VARCHAR(10) 

Add column 

WEB_CP_EVAL_DOCUMENTS 

CREATEDBY 

INT 

Add column 

PW_DP_RECORD 

ENDDATE 

DATETIME 

Change field type 

WEB_CP_TIMECLOCK_RFID 

New table 

SEQUENCENO 

INT 

PIN 

INT 

NUMORGID 

INT 

RFID 

VARCHAR(200)