Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Show if
groupconfluence-administrators

415203329415203329APP 20Create APP Patch Notes

To read more about our different types of releases (main release, intermediate release), click me!

Page Properties


Software

Version

Release Date

Download Link

Latest Patch

Adonis Personnel Portal

2022.30

24  

Download here

Child pages (Children Display)
first1


...

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

2022.30. x

APM 2020.10.x and newer version

Image Removed


...

Key

SummaryT

Issue Type

Release notes

APP-2907

APP to read settings from APM/misses its own

BugImage Removed

Bug

Implemented the page to define a maximum file size for attachments in the Administrator Portal - Configuration - General - General tab. Max file size for APP documents is limited by 5 Mb.

APP-3084

Issue with email validation

BugImage Removed

Bug

Extended email validation in the Employee portal login form

APP-3144

Can't select default currency

BugImage Removed

Bug

Fixed an issue to display a currency code with option NULL to be displayed as the default currency in the Trave Expense & WDA setup - MOdule Module Options page.

APP-3347

WDA mobile layout overlaps

BugImage Removed

Bug

Modified mobile layout for Working Day Accounting module. Applied a fix for displaying the user icon and module name on the header.

APP-3549

Missing Submit button for crew/subordinates

Project RequestImage Removed

Change Request

Implemented a possibility for a subordinate to submit his timesheets before the period ends if the corresponding option is enabled in the Administrator portal. The ‘Submit’ button is located in the TAA - My Timesheets - Current view scheduler.

APP-3691

Access rights for Enclosed documents are confusing and not working properly

BugImage Removed

Bug

Modified Personal Document preview functionality.

  1. The attachment/scan file can be previewed even if the document is in ‘read only’ mode.

  2. The scan can be opened by clicking on the tile icon.

  3. The context menu button "SCAN ADD/UPDATE" was renamed to "SCAN DETAILS/EDIT".

APP-3701

Roster module - Wrong info in audits

BugImage Removed

Bug

Modified the functionality which provides Roster Module Audits. Applied fix to return correct values to:

  • Changed by field;

  • PIN;

  • Location name.

APP-37663765

APP-3765 CSB: Checklist report doesn't work properly

Merge CodeImage Removed

Bug

Modified Crew Station Bill Checklist report.

APP-3770

Roster module - System is hanging

BugImage Removed

Bug

Improved performance in the Roster Planning scheduler.

APP-3804

Migrate Crew Evaluation Module to APP

EpicImage Removed

APP-3845

Evaluation form tile in APP

TaskImage Removed

Change Request

Implemented access rights and tiles for the Evaluation module in the Administrator and Crew portal.

APP-4183

Implementation of MFA

EpicImage Removed

APP-4239

TE - Subordinates batch issues

BugImage Removed

Change Request

We have added support for Multi-factor Authentication (MFA) for Adonis users. The new authentication method will require users to provide additional verification using their email, SMS, or Google Authenticator application.

APP-4239

TE - Subordinates batch issues

Bug

Implemented a validation for duplicated employees ina batch to the Travel Expense chain of approval.

APP-45983036

APP-3036 Need a Timesheet property for Approved Per Day method to identify if the person has left the ship for a period of at least 3 hours on a Sunday or holiday

Merge CodeImage Removed

Bug

Implemented the new property ‘NrThreeHoursOnShorePeriod’ for the TAA_ApprovedTimeSheetsPerDay method. The parameter returns the number of every 3-hour work intervals registered during the ETA/ETD of the Crew Change (while the vessel was in the port). The ‘NrThreeHoursOnShorePeriod’ parameter is calculated only for Sundays and Public Holidays.

APP-45993834

APP-3834 Need a new method to transfer timesheet by work code and rank daily

Merge CodeImage Removed

Bug

Implemented the TAA_ApprovedTimeSheetsPerDayAndRank method that returns Overtime hours and Totals grouped by work type and Rank Abbreviation from the Roster Planning module.

APP-46023485

APP-3485 DFDS_CSB_Overview report migration to APP

Merge CodeImage Removed

Bug

The DFDS_CSB_Overview report migrated to APP

APP-4653

Totals column modifications in the Roster Timesheet dialog

Change requestImage Removed

Change Request

Added the new 'Total Work' column to the Roster Timesheet dialog. Added a possibility to show/hide all total columns.

APP-4672

JS files structure

TaskImage Removed

Change Request

Made JavaScript files refactoring and place all variables on the top of the file to keep a better file structure.

APP-4687

Person displayed as S/On and S/Off on the Sailings tab when deleted from the Scheduler

BugImage Removed

Bug

Applied fix to calculate the correct number of S/On and S/Off crew. Crew members removed from the scheduler will not display on the S/On and S/Off tabs of the Crew Change scheduler.

APP-4688

Timesheet Periods modification enhancements

BugImage Removed

Bug

Modified the behavior of the control buttons in the Administrator Portal - Time and Attendance - Periods setup page. The system does not allow to modify or delete a period if a timesheet(s) is linked to it.

APP-4689

In mobile mode for WDA broken tabs 'Transportation', 'Accommodation', 'Other', 'Per Diem', 'Advance'

Merge CodeImage Removed

Bug

Applied fix for the navigation in the WDA module between the document tabs and in the menu.

APP-4692APP-3213 to 2022.30(CSB: 3213

CSB: Several crew on the same Safety ID)

Merge CodeImage Removed

Bug

Implemented a possibility to assign a crew member on several Safety IDs. Overlapped assignments will be truncated accordingly.

APP-4704

In mobile mode for WDA ->Travel Scans grid is not load

BugImage Removed

Bug

Applied fix for WDA mobile version to load files attached to a document.

APP-4705

Overview shows not existing documents

BugImage Removed

Bug

Modified the selection for the Time and Attendance notification tiles. The timesheet documents that are not linked to an activity (WEB_CP_TIMESHEETS.ONBOARD_ACTIVITY IS NULL) are excluded from the notifications.

APP-4707

Migrate grids to server side operation for WorkDaysAccount module 2022.30

Merge CodeImage Removed

Change Request

The WDA module migrated to server-side operations

APP-4710

Cannot save a Travel Scan without an attachement

BugImage Removed

Bug

Added a warning message when the user tries to save a Travel Scan record in the Travel expense document without an attachment.

APP-4712

The list of PINs truncated in the toast message of the ONB Drills module

BugImage Removed

Bug

Modified the information message in the Onboard Drills module when adding a batch of drill participants.

APP-4716

Meal deduction should always be done based on the rate that is applicable for that day

BugImage Removed

Bug

Applied fix for meal rates calculation in the Travel Expense module

APP-4717

WEB_CP_TRAVEL_RATE_PERIOD delete trigger is wrong

BugImage Removed

Bug

Modified delete trigger for WEB_CP_TRAVEL_RATE_PERIOD database table

APP-4722

Configuration screen on Admin portal

TaskImage Removed

Change Request

Implemented the Multifactor Authentication tab in the Administrator Portal - Configuration - General. Here the administrator can enable the Multifactor Authentication.
On the login page, there are three types of authentication methods:

  • Email authentication.

  • Google Authenticator app.

  • SMS-based authentication;

APP-4727

Required Crew summarized for all Service Levels

BugImage Removed

Bug

Improved calculation of Required Crew totals in the D2D Roster Planning to consider the Service Level and Category linked to a particular trip. The Required Crew total value includes crew members in all departments.

APP-4735

The MCA attachment returns an error for a historical document

BugImage Removed

Bug

Fixed an error opening the attached file for a historical Master Cash document

APP-47384719

Not all time blocks are displayed in the Roster Assignments report

Merge CodeImage Removed

Bug

Applied fix for total hours calculation in the Roster Assignments report. The total hours are calculated for all time blocks regardless of the location selected in the report dialog.

APP-47404736

Wrong time block indication in the Roster Timesheets report

Merge CodeImage Removed

Bug

Modified the Roster Timesheets report layout to display the Position and Location abbreviations in one line. The Abbreviations will be truncated for small time blocks.

APP-47424718

APP-4718 The null value cannot be assigned to a member with type System.Decimal which is a non-nullable value type

Merge CodeImage Removed

Bug

Added extra validation of the Travel Expense exchange rate. In the case when PW001C15E.EXCHANGE_RATE=NULL system will use a default value of '1'.

APP-47434243

APP-4243 TO DESTINATION field issue

Merge CodeImage Removed

Bug

Modified the TE_Transportation method to return a correct value for TO_DESTINATION

APP-4744

The employee portal Timesheets module tile not aligned for mobile layout

BugImage Removed

Bug

Modified mobile layout to fix tile alignment in the Employee Portal.

APP-4745Add APP-4737 to APP 2022.30 (4737

Changes for the method VL_CrewPlannedTimeCards)

Merge CodeImage Removed

Bug

The VL_CrewPlannedTimeCards method was modified to return: Position Numorgid, TimeIn, and TimeOut of the time registration.

APP-4746

Handle minimal values for the TE and WDA rates

BugImage Removed

Bug

Modified the controls to correctly display decimal values in the Travel Expense and WDA rates setup.

APP-4747

Fileds overlaps in the TE settings Abroad Allowances

BugImage Removed

Bug

Applied layout changes to display the information message without causing the overlapping of Allowance and Tax-Free rates in the Administrator POrtal - TE & WDA rates page.

APP-4751

Roster module - Forward/Back date switch doesn't work properly

BugImage Removed

Bug

Applied a fix for a date switcher in the Roster Timesheets scheduler

APP-4752

D2D Roster adjust planning in sailing mode

BugImage Removed

Bug

Applied fix to calculate the correct number of S/On and S/Off crew in the D2D Roster Planning by Sailings view. Crew members removed from the scheduler will not display on the S/On and S/Off tabs of the Crew Change scheduler.

APP-47534728

APP-4728 TE - Can't generate My Travel Expenses report

Merge CodeImage Removed

Bug

APP-4760

Two time blocks are combined into one in the Roster Timesheet report

Merge CodeImage Removed

Bug

Added fix for the Roster by Timesheets report to display the time blocks separately on different locations and positions.

APP-4762

Font size in the Roster Timesheet report

Merge CodeImage Removed

Bug

To display a minimum of three symbols in the Roster Timesheet report the font size for small time blocks will be reduced.

APP-4764

Scaling doesn't work for the TAA - SchedulerView

BugImage Removed

Bug

Applied fix for the scale change functionality in the Time And Attendance module - Registration Details dialog

APP-4765

Font size in the Roster Assignments report

Merge CodeImage Removed

Bug

To display a minimum of three symbols in the Roster by Assignment report the font size for small time blocks will be reduced.

APP-4769

Next Of Kin error

BugImage Removed

Bug

Applied fix for adding the new Next of Kin record into the system.

APP-4770

Automatically set currency rate option is always ON

BugImage Removed

Bug

Fixed 'Automatically set currency rate' option in the Administrator Portal - TE&WDA Module Settings

APP-4775

Error message on opening the TE module

BugImage Removed

Bug

Added extra validation of the Travel Expense exchange rate. In the case when PW001C15E.EXCHANGE_RATE=NULL system will use a default value of '1'.

APP-4776

Error message opening the CoA setup

BugImage Removed

Bug

Fixed javascript issues on opening the Chain of Approval setup

APP-4778

The Roster Timesheet report display the time block abbr in two lines

BugImage Removed

Bug

Modified time block length evaluation to avoid displaying abbreviation text in lines.

APP-4779

The Drill worktype combined with another work block in the Roster Timesheet report

BugImage Removed

Bug

Applied fix for displaying drill in the Roster Timesheet report

APP-4782

Roster module - Roster assign person not possible when using filter

BugImage Removed

Bug

Applied fix for a Roster Planning module scheduler, to load crew members for assignment with an applied filter in the search field.

APP-4783

Roster Assignments report layout issue

BugImage Removed

Bug

Modified the Roster Assignments report layout, and fixed the gapst between the table line.

APP-4784

Roster by Timesheets dialog missing the OK button

BugImage Removed

Bug

Modified Roster Timesheet dialog, added the OK button to a PINs selection

APP-4785

The Roster Assignment report needs to show abbreviation only

BugImage Removed

Bug

Removed redundant validations in the Roster Assignments report. Abbreviation only will be displayed for position and location on the time block.

APP-4789

The Roster Assignments report link is in the old format

BugImage Removed

Bug

Modified the API method which generates a Roster Assignments report from GET to POST.

APP-4790

The drop-down list appears behind the Roster Timesheet report dialog.

BugImage Removed

Bug

Modified the Roster Timehsheet report dialog to display the drop-down allways on top.

APP-47914780

APP-4780 Roster module - Hours are doubled

Merge CodeImage Removed

Bug

Roster total calculations are modified to handle a promotion/position change.

APP-47924786

APP-4786 The rest hours are not excluded from the Roster Timehseet totals

Merge CodeImage Removed

Bug

Extended an SQL statement for the Roster Planning module totals table.

APP-4794

Roster Timesheet report doesn't displaye timeblocks without abbreviations

BugImage Removed

Bug

Applied fix for the Roster Timesheet report to display empty time blocks in the case when;

  • Location ABBR = NULL and Position ABBR = empty String.

  • Location ABBR = empty String and Position ABBR = empty String.

APP-4799

Add PsExec utility to installation set

BugImage Removed

Bug

The CAB file required for the APP silent upgrade was added to the PsExec utility.

APP-4801

No indication of existing attachment in the Enclosed Document details

BugImage Removed

Bug

Added action buttons to the Enclosed Document details dialog.

APP-4803

FK error when deleting Trip with linked crew in D2D

BugImage Removed

Bug

Extended the delete validation in the Crew Change module to return a correct warning message when trying to delete the trip in use.

APP-4804

Wrong error message trying to assign a crew meber without Rank to D2D scheduler

BugImage Removed

Bug

Forbid to assign a crew member without a rank to a D2D Roster Planning.

APP-4805

A Position not linked to a Department appears in the D2D Roster Planning

BugImage Removed

Bug

A position that is not linked to a department will not display in the D2D Roster Planning scheduler.

APP-48124806

APP-4806 One day activity causes an error opening Roster Timehseets dialog

Merge CodeImage Removed

Bug

Applied changes to process the one-day activity timesheets in the Roster Planning module.

APP-48134768

APP-4768 Roster Planning cannot generate a timesheet if EED is NULL

Merge CodeImage Removed

Bug

Modified Roster Timesheets to generate a timesheet when the Estimated End Date (Sign Off date) of the activity is NULL.

APP-48194817

APP-4817 Wrong dates format in Comments

Merge CodeImage Removed

Bug

Applied fix for a comment field date format in the Trave Expense document to be picked up according to browser settings.

APP-4826

Travel Expense module ignores "passive" setting on Currency

BugImage Removed

Bug

Applied a fix to exclude the currency with a 'Passive' state from the list in the Travel Expense document.

APP-48334832

APP-4832 Include Night time to the TAA_GetTimecard method

Merge CodeImage Removed

Bug

The TAA_Timecard method extended with new properties:

  • TAA_Timecard.Timecard.IsWeekEnd;

  • TAA_Timecard.Timecard.MorningIntervalHours;

  • TAA_Timecard.Timecard.EveningIntervalHours;

  • TAA_Timecard.Timecard.NightIntervalHours.
    .

The intervals are picked up from the Payscale Table / Code setting.

APP-4835

Cannot delete a shift from teh Roster Watch Configuration

BugImage Removed

Bug

Fixed an issue with deleting a shift in the Roster Watch Configuration page.

APP-4836

Changes in the Interface of Login Page

TaskImage Removed

APP-4837

Change in the login(When using Google App)

TaskImage Removed

APP-4838

4834

Total KM is not visible in travel expense > transportation > type = own car

Merge CodeImage Removed

Bug

Improved the Transportation layout for the Own Car travel type in the Travel Expense module. The Total Km field appears once the number of passengers is filled in.

APP-48394816

APP-4816 Travel types are missing in WDA TE record

Merge CodeImage Removed

Bug

Implemented a possibility to use Domestic country rates for WDA documents.
The system will calculate allowance as domestic for the country selected as Domestic Country in the Travel Expense & WDA settings - Module Options.

APP-4847

The buttons are too close to each other in the My Timesheets - Current view page

BugImage Removed

Bug

Modified layout to avoid overlapping buttons in the My Timesheets - Current view.

APP-48514846

APP -4846 APP is is not reachable when using Roster Planning module

Merge CodeImage Removed

Bug

Added additional validation for the Roster Planning scheduler to handle a TAA_ROUNDING ='0' value from the user settings.

APP-4860

Limit the Gratuities % by the 100

BugImage Removed

Bug

Added percentage limit by 100% for the Gratuities document dialog. Added scrolling step to increase or decrease the percentage by 1%.

APP-48684708

APP-4708 Calculate Violations option state to be saved

Merge CodeImage Removed

Bug

Fixed issue with saving the 'Calculate Violations' option state in the My Timesheets - Current page.

APP-48694861

APP-4861 Roster module - Rows are not in line/messed up

Merge CodeImage Removed

Bug

Modified markup to avoid rows overlappings in the Roster Planning scheduler and Roster Timesheet dialog.

APP-4870

eSigning Module - Need endpoint to withdraw a document

Change requestImage Removed

Change Request

Implemented the WithdrawDocument method for the Electronic Signing module. The method checks the current state of a document and allows the originator to withdraw the pending signing documents. Not possible to withdraw confirmed and rejected documents.

APP-4871

The error appears when updating to v.2022.30.0.78

BugImage Removed

Modified triggers to fix the APP upgrade error.

APP-4875

WDA mobile mode- need to adjust filter for states

BugImage Removed

Bug

Applied fix for WDA documents filtering by the state name in the mobile layout.

APP-4876

Filtering and sorting in WDA grids (mobile mode) gives error

BugImage Removed

Bug

Applied a fix for filtering and sorting in the WDA module mobile version.

APP-48804879

APP-4879 Gratuities Module sign on/off day rules should not apply to non sea-service activities

Merge CodeImage Removed

Bug

Excluded non seaservice activities from using the sign on/off rules.

APP-4885

W&R International report should show all approvers

BugImage Removed

Bug

The Work&Rest International report was modified to display the Approvers nodes, not only Subordinates.

APP-49004892

Roster Planning totals ignore 30 min registration

Merge CodeImage Removed

Bug

Modified total calculation in the Roster Planning scheduler. Totals are calculated every 30 minutes. The scheduled time blocks 'S' parameter is no longer available.

APP-49024890

APP-4890 The Save button in Certificates should be inactive until a change has been done

Merge CodeImage Removed

Bug

Modified 'Save' button behavior for My Documents. The 'Save' button activates only after changes are made.

APP-4904

APM-6650

Snap to Crew Change suggests the port call with ETA/ETD outside of the target date

Merge CodeImage Removed

Bug

Modified NAV_CallingPortCreate method to create a calling port without a time portion in the DATEFROM and DATETO.

APP-4907

NAV_CalingPortRead method returns an 'Object reference....' error

BugImage Removed

Bug

Applied fix for NAV_CalingPortRead method to return a list of calling ports by vessel.

APP-4909

Evaluation form, the view/edit page

Sub-taskImage Removed

Change Request

Implemented Evaluation module Overview page.

APP-4910

Enclosed documents edit dialog behavior

BugImage Removed

Bug

Modified the behavior of the Add / Update Attachment dialog of the Enclosed Document. Applied fix for page re-loading.

APP-49124883

APP-4883 The Work and Rest report is not showing the correct value for Watchkeeper

Merge CodeImage Removed

Bug

Applied fix for watchkeeper indication in the WorkAndRest report.

APP-4913

The Total Gratuities value is not calculated in the dialog

BugImage Removed

Bug

Applied fix to the Gratuities % calculation in the Create Document dialog.

APP-49194915

APP-4915 GNL_ResetPassword method doesn't work

Merge CodeImage Removed

Bug

Applied fix for the GNL_ResetPassword method

APP-4920

Changing password in my profile

BugImage Removed

Bug

Removed the page reloading after password change in the Adonis mobile application.

APP-4929

Trim the space in the email as user is unable to login

BugImage Removed

Bug

Applied extra space trim functionality to an email in user accounts.

APP-4930

Travel Expense documents oveirview page throws an error

BugImage Removed

Bug

Applied fix for the Overview grid sorting in the Travel Expense module

APP-49324925

APP-4925 CSB - Not possible to add Safety ID

Merge CodeImage Removed

Bug

The redundant ‘POSITION’ column was removed from mapping.

APP-49334924

APP-4924 Roster module - No rounding in Roster reports

Merge CodeImage Removed

Bug

Applied 30 min rounding for Roster Assignments and Roster by Timesheet reports

APP-49344921

APP-4921 TS lost the node after Submission by the Coordinator

Merge CodeImage Removed

Bug

Applied a fix to reload the selection of the timesheet documents on the workflow page.

APP-49504945

APP-4945 Gratuity documents are not created because of an issue in Department Group settings

Merge CodeImage Removed

Bug

Modified crew selection for Gratuities Settings - Department Group page.

APP-49593503

APP-3503 VL - Gratuity Module and LS Retail integration (merge branch)

Merge CodeImage Removed

Bug

Implemented Gratuity documents import from LS Retail. The Gratuities Web Service link setup is located in the Administrator Portal - Web Services tab.

APP-4961

Method TAA_ApprovedTimeSheetsPerDayAndRank does not provide data by work code

BugImage Removed

Bug

Extended the TAA_ApprovedTimeSheetsPerDayAndRank method with new property ‘TimeSheetDays.Hours.WorkedTotalByRank’ to receive the daily hours in each work code and rank.

APP-4966

The tile TC Subordinate shows an incorrect value

BugImage Removed

Bug

Excluded ‘Pending Signing' documents from the 'Time clock user documents’ notification on the Co-Workers Timesheets tile.

APP-49764967

APP-4967 E_Signing shows all documents as Rejected

Merge CodeImage Removed

Bug

Added the SQL script to fix ESign documents during the migration to the new Electronic Signing Service structure.

APP-4982

Onboard Drills - Scenario setup is not saved

BugImage Removed

Bug

Applied fix for the Onboard Drills and Scenarios scheduling workflow.

APP-49834974

APP-4974 Administrator can't change the password

Merge CodeImage Removed

Bug

Modified workflow for the administrator password reset.

APP-49954962

APP-4962 Activity leave balance is not correct when the activity is updated by Gangway

Merge CodeImage Removed

Bug

Modified Leave Pay Factor calculation in the gangway system. The system calculates the leaved days considering the Exclude Sign On and Sign Off payscale options.

APP-50074956

Update gratuity grid

Merge CodeImage Removed

Bug

Following modifications applied in the Gratuity document page:

  1. Two new columns with one common header, ‘Position Shares’, identifying Whole and Partial shares.

  2. New column for shares based on sign-on/ off rules.

  3. Added Edit and Undo buttons to edit the shares for the person.

  4. New column identifying if the share is modified.

  5. New column name “Gratuity.”

  6. New colmn “Shares entitled”.

  7. Totals for the new columns counting the number of persons with:

  • Position Shares Whole (sum);

  • Position Shares Partial (count);

  • Sign on/off Shares (sum);

  • Shares entitled(sum);

  • Gratuity (sum).

APP-50084957

Calculating and collecting Position Shares based on time card registrations.

Merge CodeImage Removed

Bug

Implemented Gratuities share calculation based on time cards. The rule is that a person receives the shares based on the position giving the highest number of shares that day. The position/payscale rates retrieved from the activity are the basis of the calculation.

APP-50115009

APP-5009 TS not available for signature

Merge CodeImage Removed

Bug

Applied fix to revert the document sent for signing if the error in the Electronic Signing Service occurs.

APP-50285027

APP-5027 Need to transfer the Gratuity Document Date to payroll entries

Merge CodeImage Removed

Bug

The API methods GM_GetGratuityByEmployee and GM_GetGratuityById were extended with the ‘GratuitiesDate’ parameter.

APP-50395036

APP-5036 WDA_Accumulators method returns timeout error

Merge CodeImage Removed

Bug

Extended timeout for method WDA_Accumulators method.

APP-50575056

APP-5056 Currency is missing if re-open TE record

Merge CodeImage Removed

Bug

Applied fix for currency value in the Travel Expenses

...

Database Modifications

...

New and Modified Tables


Table

 

FieldName

 

FieldType

 

Description

 

WEB_CP_

TRAVEL

ADMIN_

BILLS

KEYS

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

 

 

New table

 

SEQNO

INT

 

 

ACCOUNT_SEQNO

INT

 

 

VERIFICATION_METHOD

INT

 

 

PRIVATE_KEY

varchar(250)

 

 

EXPIRY_DATE

DATETIME NULL

 

 

 

 

 

WEB_CP_ACCOUNT_EMPLOYEE_KEYS

Drop

New 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

 

SEQNO

INT

 

 

ACCOUNT_SEQNO

INT

 

 

VERIFICATION_METHOD

INT

 

 

PRIVATE_KEY

varchar(250)

 

 

EXPIRY_DATE

DATETIME NULL

 

 

 

 

 

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

ACCOUNT_CREW_KEYS

 

 

New table

 

 

SEQNO

INT

 

 

ACCOUNT_SEQNO

INT

 

 

VERIFICATION_METHOD

INT

 

 

PRIVATE_KEY

VARCHAR(250)

 

 

EXPIRY_DATE

DATETIME

 

 

 

 

 

 

 

 

 

WEB_CP_ADMIN

TELEPHONE

VARCHAR (50)

Add column

WEB_CP_ESIGN

STATUS_NAME

NVARCHAR(10)

Add column

WEB_CP_GRATUITYPOS

ETAG

VARCHAR (50)

Add column

WEB_CP_GRATUITYPOS

ENTRY_NO

INT

Add column

WEB_CP_GRATUITYPOS

CURRENCY

VARCHAR (3)

Add column

 

 

 

 

WEB_CP_EVAL_DOCUMENTS

 

 

New table

 

DOCUMENT_ID

INT

 

 

PIN

INT

 

 

TEMPLATE_CODE

VARCHAR(10)

 

 

EVALUETION_FORM_CODE

VARCHAR(10)

 

 

ISDELETED

bit

 

 

STATUS

NVARCHAR(10)

 

 

DATETIME

DATE

 

 

DESCRIPTION

VARCHAR(100)

 

 

 

 

 

WEB_CP_EVAL_QUESTIONS

 

 

 

New table

 

SEQNO

INT

 

 

CODE

VARCHAR(10)

 

 

NAME

NVARCHAR(100)

 

 

DESCRIPTION

NVARCHAR(100)

 

 

WEIGHT

INT

 

 

TYPE

INT

 

 

ANSWERSTRUCTURE

INT

 

 

 

 

 

WEB_CP_EVAL_SECTIONS

 

 

New table

 

 

SEQNO

INT

 

 

CODE

VARCHAR(10)

 

 

NAME

NVARCHAR(50)

 

 

DESCRIPTION

NVARCHAR(1000)

 

 

 

 

 

WEB_CP_EVAL_SECTION_QUEST

 

 

New table

 

 

SEQNO

INT

 

 

QUESTION

INT

 

 

SECTION

INT

 

 

TEMPLATE

INT

 

 

 

 

 

WEB_CP_EVAL_TEMPLATES

 

 

New table

 

 

SEQNO

INT

 

 

CODE

VARCHAR(10)

 

 

NAME

NVARCHAR(50)

 

 

DESCRIPTION

NVARCHAR(100)

 

 

 

 

 

WEB_CP_EVAL_ANSWER_STRUCTURE

 

 

New table

 

 

SEQNO

INT

 

 

CODE

VARCHAR(10)

 

 

DESCRIPTION

NVARCHAR(100)

 

 

NAME

NVARCHAR(50)

 

 

 

 

 

WEB_CP_EVAL_ANSWER_STRUCTURE_ITEM

 

 

New table

 

 

SEQNO

INT

 

 

ANSWERID

INT

 

 

CODE

VARCHAR(10)

 

 

DESCRIPTION

NVARCHAR(100)

 

 

WEIGHT

INT

 

 

PASSIVE

BIT

 

 

 

 

 

WEB_CP_EVAL_ANSWERS

 

 

New table

 

 

SEQUENCENO

INT

 

 

PIN

INT

 

 

DOCUMENT_ID

INT

 

 

SECTION_CODE

VARCHAR(10)

 

 

QUESTION_CODE

VARCHAR(10)

 

 

TEMPLATE_CODE

VARCHAR(10)

 

 

COMMENT_EVALUATEE

NVARCHAR(MAX)

 

 

COMMENT_EVALUATOR

NVARCHAR(MAX)

 

 

ANSWER_EVALUATOR

NVARCHAR(MAX)

 

 

ANSWER_EVALUATEE

NVARCHAR(MAX)

 




...

Other Versions 

...

Page Properties Report
cqllabel = "app-rn"