APM-6478

ACC: not possible to define access for multiple General Codes

Bug

Missing options in right-click menu when used for General Codes access setup

APM-6190

Enhance Search User function in Control Center

Change Request

We now provide the possibility to perform an extended search of a user based on any available fields.

• Switch to the Users tab, click Search & switch to Extended mode

Open

• Use the search criteria, and defining the name of any available field. Using expressions such as like %value% you may benefit from using mask search

• Grouping, sorting, and limiting group values are also available.

APM-6147

Сollapsible groups in the Crew list view selection window

Change Request

When starting the application but the last open crew list is no more available for your account you are able to select any other available crew list to be uploaded. It has been offered as a simple list. Now we display it according to the Crew List View groups as setup in General Codes for a more user-friendly selection.

APM-5967

Access rights not working for the newly created users

Bug

Possible issues with access rights granted for crew list views and/or Onboard module users.

APM-5792

921'Select Crew' routine affects the ability to undo confirm for on/off-signers and un/confirm promotions

Bug

If access for routine 921 Select Crew was set to 'N' - users were not able to Undo Confirm for on/off-signing and Confirm/Undo Confirm for promotions

APM-5654

AV error when trying to run Update Payroll Info in the Activity data group

Bug

AV error when clicking Update Payroll Info.

APM-4520

It is possible to close activity with DateTo less than DateFrom

Bug

We now prevent the possibility to Terminate a person setting the date, which is earlier than the Date From of his current activity. Action will be cancelled for the user to perform proper manipulations.

APM-6229

Default Period setup for Expiry and Date to does not work for Competence

Bug

When adding a document the general code settings for calculating the default Expiry Date / Date To were not applied

APM-6633

Seniority calculation issue in Contracts Datagroup

Bug

Wrong calculation of the Seniority when Global Option Activities calculating seniority is set & the Contract start date is earlier than the Payroll Seniority start date

APM-6406

Spelling mistake in Contracts datagroup > Initial

Bug

Misprint for Contract Description field name for Initial

APM-6219

System shows info message about the field that is mandatory for another contract type

Bug

Incorrect warning raised due to wrongly applied validation of mandatory fields

APM-6569

Bug in Customized Fields

Bug

SQL error when a lookup field is defined for a datagroup

APM-5478

No possibility to hide the "Delete" button in the Medical Insurance datagroup.

Change Request

We provided separate routines in Adonis Control Centre for the Delete button in all available modules & datagroups. Their default state is None, please check the upgrade log to learn the number of corresponding routines & set access accordingly

APM-6469

Possible to delete a Postcode used in the system

Bug

It was possible to remove a zip code record, even if it had already been used for some details in the other module / datagroup. Now the pre-validation is performed & a user will be notified with the list of places where this code is used.

APM-6420

Changes to Finnish Personal ID validation

Change Request

We modified validation rules for Finnish Personal ID to comply with the newest standards:

• encoding letter after date of birth ddmmyy for persons born in 2000s is now valid for B, C, D, E, F

• encoding letter after date of birth ddmmyy for persons born in the 20th century is now valid for Y, X, W, V, U

APM-6335

Changes for the field POSTPLACE.PW001P01

Bug

Database changes to support Unicode symbols

APM-6166

Email address validation in Personal Details / Telecommunication

Bug

When adding telecommunication record we now provide validation for input value to be a valid email and phone number to only allow valid symbols input.

APM-4508

Re-name city or zip code in pwpost creates duplicates with replication

Bug

We performed database modification for PWPOST table, changing the PK from the composite to the simple artificial. This allows resolving the issue when modifying a value (part of composite PK field) resulting in duplicating it into a new record when replicating to the other sites.

APM-5688

Need to add a verification to the Capacity field in the Gene Codes -> Cabin.

Bug

We implemented the new validation for Cabin general code properties. Now if the Capacity property is decreased, but there already exists an exceeding number of assignments – a warning informs you to avoid possible mistakes.

APM-6225

Activities created by Common Entry are not the same as created from Activities Datagroup

Bug

To provide compatibility with APP Roster Planning the Common Entry > Create Activities now populate the Vessel ID to pw001p03.VESSEL database field.

APM-5643

AV error appears when Start Date of Subcontract < Start Date of Contract

Bug

Implemented validation for possible date overlaps when creating a new contract/subcontract record.

APM-6401

Can not provide 'Read-only' access for Course Scheduler/Drills

Bug

Read access was not applied to the module’s Scheduler / Drills views

APM-5505

"Nearest airport" is not picked up/saved

Bug

When creating a flight booking (Griffin Marine interface) the Nearest Airport of the course provider (as in the Contacts module) is now picked up by default

APM-6658

Activity Datagroup Overview - Confirm Action should handle existing promotion in Snap to crew change form

Change Request

We re-factored the functionality of Confirm activity with regard to multi-module interactions. Confirm action now doesn’t simply process the next activity but verifies if a planned activity of the correct type exists first. Then it is re-used for Confirm action, instead of creating a mixed set of activities.

Before executing the Confirm action, a specific popup is raised describing the actions to be performed & activities to be involved.

APM-6554

Promotion record isn't removed after promoted_from activity was confirmed Sign On in Activities datagroup

Bug

Various issues for activity/promotion reference handling. Found & fixed during internal testing

PM-6069

Customize button settings are cleared when closing Analytical Module

Bug

Customization options are now moved to the separate Layout tab on the ribbon.

Fixed the issue that customized settings were always reset to default after the module’s reopening.

APM-6620

Empty rotation shift modified after Confirm Crew Change

Bug

For customers using partial replication, there may appear a situation, where a person is assigned to a shift on the Main site, but this info is not replicated to satellite(s). If some “neighbor” shift is confirmed on Satellite & their dates are overlapped – the shift under partial replication is considered as empty & is truncated. This leads to inconsistency in the data relation shift/activity/crew change for the Main site / Satellite. We now control such situations & provide specific handling for shift assignment that is performed by the Main site.

APM-5679

Incorrect operation of the button 'Cancel'

Bug

For the Griffin Marine travel interface Cancel was not changing the booking status for records with Flights_Req and Approved statuses

APM-5113

Reschedule function in Crew Change does not work

Bug

For the OnSigning tab we limited the Re-schedule functionality to only operate with the same vessel as the current one for the selected crew change record

APM-6604

Crew List Picture size options menu is missing at the ribbon

Bug

Added the possibility to select Crew List picture size to the ribbon menu.

APM-6394

Not possible to load the application when Standard View is disabled.

Bug

The list of available views was not available on the application start if the default Standard view was disabled.

APM-6103

Crew can't be created with Finnish ID validity check

Bug

When validation for Finnish ID was set, and the birthdate field was set as mandatory – it was not possible to Create Person as the birthdate was calculated automatically & not considered as being input

APM-5795

AV error when using grouping to assign crew in Rotation

Bug

AV when using search in Find Form & the field grouping was applied, then expanded

APM-6030

Travel module Griffin Marine - Add Position column to all grids

Change Request

For the Griffin Marine travel interface we added the Position column to show in all available grids.

APM-6536

Optimize memory usage in the Email Reports module

Change Request

Various errors when generating payslips for a number of the crew using Email Report due to unsecured multi-threads

APM-6636

Norwegian tax calculation for year 2023

Change Request

We prepared the new Tax Tables file for proper calculation of the Norwegian taxes for the year 2023. Please contact our Service Desk to get the file PWSN2023.DEF & instructions on how to upload it. Please note that the upgrade of the Adonis Personnel Manager is NOT necessary for proper processing.

APM-6410

Indication for changed A-melding settings and Reported/Cancelled A-melding reports

Change Request

For A-Melding we provided the possibility to flag if EDAG historical settings were changed.

The date flag is set up for the records only for Normal A-melding, Payroll only A-melding, and the A-melding correction, but not for the Arbeidsforhold only or A-melding to be reset.
The flags can be removed:

• when a new A-melding for Normal or Payroll only is sent.

• manually with Reset Info Status in the pop-menu.

PM-6492

Payroll fields for contract datagroup don't work in payroll scripts

Bug

Fields for various datagroup values returned only 0 in payroll scripts.

APM-5732

Not possible to open script Revision

Bug

It was not possible to open Revision Pane to view the modifications history

APM-6638

Tree View functionality: to add standard filtering

Change Request

We added a standard Find filter to tree views used in General Codes, Organization Structure, Open Client window, and Course Scheduler.

APM-3425

Check if Allotment Priority is in usage on attempt of removal

Change Request

We provided validation that will not allow you to delete an Allotment priority if it is already in use in payroll.

APM-5640

Have the possibility to clean up selection in drop-down list in Global option

Change Request

Provided the possibility to clean/remove the values selected in dropdowns under the Basket tab for Default Document Type When Distribute.

APM-6516

Check new CrewLink version

Change Request

We updated the application with the possibility to function with a new service URL.

APM-5845

The title is not in front of the field "User Name" in CrewLink settings

Bug

Fixed layout issue

APM-4273

Need to extend validation for 'Allottee Priority' field in Org. Structure

Bug

Provided validation for possible invalid input of values in Allottee Priority

APM-6606

Scanned Documents print to PDF missing one document

Bug

Scanned Documents printing could skip printing of some pages when printed

APM-3830

Nationality in Requirements Profile

Change Request

The module now provides you with the possibility to setup requirements per nationality. This could be useful when a certain medical / travel document is required for certain nationality.

• Switch the setup to Nationality mode

• Select Travel / Medical section to define the list of specific documents that are required by specific nationalities only

• Tag the document & define which nationalities do NOT require (exceptionally) this document

• Do not forget to click Apply so that your settings become active. If not applied, the requirements will not be saved and/or taken to consideration

---------------

We extended Requirements > By Position > Flags with the section Except of Nationality, similar to By Nationality view. It enables to setup validation for a Certificate of Competence (CoC) per position by nationality against the vessel flag. This will cover requirements validation e.g. when a Dutch captain requires Master CoC when sailing on a Dutch (NL flag) vessel, but additionally requires Cyprus endorsement when sailing on a Cyprus (CY flag) vessel.

Defining the certain list of nationalities to be excluded from validation, others will be automatically considered to have the CoC in question as required. So for the NL Master endorsement, you can set NL under Except of Nationality to exclude Dutch captains from this requirement even if set.

APM-6111

Default email address for CC field

Change Request

It is now possible to define email sender to be shown via the CC field, additionally to existing approaches via TO and BCC.

APM-6374

Not enough SMTP password field length. Long password becames truncated

Bug

User interface input for SMTP password trimmed input value, although database allowed to store 32 symbols

APM-6136

Error in adding Replace Competences in General Codes

Bug

Maximum recursion exhausted SQL error when defining multiple levels of replaced competencies.

APM-6157

Change label for field Aarlsonn Payscale Rate in Org. Structure

Change Request

Improved label naming under Company > Reports > Norsk Innrapportering > FNO.

APM-5477

Spelling mistake in the "Vessel location"

Bug

Wrong spelling under menu element.

APM-6688

Changes in the Interface of the Competence Enrollment profile

Bug

Redesigned the section Options & its selective content for Competence > Enrollment Profile.

APM-6542

Move CrewLink embedded window to Microsoft Edge WebView2

Bug

Provided compatibility of the embedded CrewLink window with the Microsoft Edge browser.

APM-6654

“Aarslonn” is not fetched correctly if a person is paid based on personal rate 1

Bug

We modified the calculation of Aarslonn value: Personal Rate 1 is multiplied by 12 to show the yearly value. If no Personal Rate 1 is defined, then the rate value from Organisation Structure > Reports > Norsk Innrapportering > FNO > Aarslonn Payscale Rate is used

APM-6657

Make TAA_ApprovedTimeSheetsPerDayAndRank method available in APM

Change Request

The webservice method of APP Time & Attendance TAA_ApprovedTimeSheetsPerDayAndRank is now available for use under Payroll > Payscales > Overtime > Transactions.

APM-6642

Danske bank payment files are rejected for transfers outside Denmark, Sweden and Norway

Bug

Impossible to send bank payments for employees outside Denmark, Sweden, and Norway due to new requirements for XML payment file

APM-6626

'Course Date From date'

Change Request

We improved the set of options that can be defined for Competence > Enrollment Profile > Competence Valid To date.

APM-6618

Set new Competence's 'Valid To' date"

Change Request

We improved the set of options that can be defined for Competence > Enrollment Profile > Competence Valid To date.

APM-6617

Change Expiry Condition Moodle Interface

Change Request

We improved the set of options that can be defined for Competence > Enrollment Profile > Competence Expiry Condition.

APM-6615

To add sorting in the list of Contracts

Change Request

We added the possibility for custom sorting & filtering for the contracts

APM-6595

National Competence (Endorsement) Requirements Activation: Client functionality

Change Request

Subtask for client-side modifications when performing Activate for Competence > By Position > Flag > Except Of Nationality

APM-6594

National Competence (Endorsement) Requirements Activation: DB functionlity

Change Request

Subtask for database changes to update proper tables when setting up Competence > By Position > Flags > Except of Nationality

APM-6589

Field TYPE (DESCRIPTION) missing for the Transportation expense

Bug

Fixed situation when the Description field for the method TE_Transportation is not fetched to APM while transferring Travel Expenses.

APM-6578

Advance List by Currency does not process the payments correctly to both BNP Paribas and Rabobank

Bug

We extended the Advance Payment list report with the possibility to generate payment files even if more than one bank details are defined for payment in the same currency. It can now generate a separate payment file in ISO20022 format for possible payments for BNP Paribas.

APM-5102

Adonis Query - Organization field refers to Contract type

Bug

Implemented solution to display in Adonis Query criteria selection for Organization P10 "Companies List" and for Payroll Vessel P248 "Vessel List"

APM-5733

Need to include "DNP" activity to Logisoft export

Bug

Implemented the optional possibility to limit activities for the content to be processed in Payment Schedule export.

APM-6551

National Competence (Endorsement) Requirements Evaluation: DB function

Change Request

Subtask for creating the new database function
adt_GetRequiredCompetence - returns a list of the required competence documents
Parameters:
PositionId (int) – to define NumOrgID of the position
Nationality (varchar 2) – to define nationality 2-symbols code

APM-6249

Sick wizard doesn't work properly

Bug

Activities’ evaluation was performed wrong when sick activity was generated and inserted in the middle of current seaservice

APM-6520

Mismatching the rank and payscale info between records in Crew Change -> Sign On/Off and sea-service activity after changes in Rotation module

Bug

When updating Rank on activity using Update Payroll Information, it was not added to Crew Change

APM-6529

When rank is updated on activity via "Update Payroll Information", it is not added to Crew Change

Bug

When updating Rank on activity using Update Payroll Information, it was not added to Crew Change

APM-6533

APM startup procedure, copy application to temp local directory

Bug

We improved the startup process of the application if installed on the Azure environment, by modifying the approach of working with file packing/unpacking.

APM-6489

Disable payscale code field in CrewChange if the option "Fetch payscale by position/rank" is turned on the payscale table level

Bug

When the option Fetch payscale code by position rank is set for a payscale table, then the code is disabled for user in this module

APM-6488

Update rank in CrewChange-> Signing On/Off if p03.rank was changed manually via Activities datagroup

Bug

After the confirmation of the Sign On in the Crew Change module the record receives the payscale code from the activity, even if the different one has been defined upon confirmation.

APM-6507

Requirements Profile Module- Nationality Requirements Setup: access rights

Change Request

We provided handling of access rights for Requirements By Nationality by the existing routine 802 Requirements Profile in Adonis Control Centre

APM-6504

Extend the database function dbo.ad_FeildAmount to handle further Entryfield4..Entryfield9

Bug

Added function ad_FieldValue to return the value of a payroll entry.
Parameters:
iSEQNO (int) – to define the sequence number of the entry in pw001pay / pw001pyh
iPFIELDNO (varchar 3) – to define the field as used in payroll (Lxx where xx is the numeric value)
iTYPE (vachar 1) – to define C for current period value, H for historical

APM-6499

One or more errors occurred error when running e-mailed payslip

Bug

Various errors when generating payslips for a number of the crew using Email Report due to unsecured multi-threads

APM-6494

Possibility to show the vessel project on a selected dimension (Dim3..12) other than the Dim5 (In V2022.30)

Bug

For the accounting voucher setup we provided the possibility to define Vessel Project for any DimX value, not only for Dim5 earlier.

APM-6491

Contracts created by the system during upgrade from 2021.50.13 to 2022.20.3

Bug

During the upgrade, the system converted the current contract information to the newly implemented contract data group structure. This conversion is redundant for those who are not planning to use this functionality.
We have removed the conversion from the upgrade procedure.

APM-6493

APM Confirm Activity Form (Module 3003) applying updates to Shift Activity dates but leaving the linked to rotation shift unchanged.

Bug

Implemented functionality modifications providing update to Rotation Module shifts and processing of Crew Change records in case if Linked Seaservice Activity Dates were changed by the "Confirm Activity" Form (Module 3003)

APM-6474

Nationality Requirements Evaluation: DB function

Change Request

adt_GetRequiredTravel - returns a list of the required travel documents
Parameters:
CompanyID (int) – to define NumOrgID of the company
Nationality (varchar 2) – to define nationality 2-symbols code

adt_GetRequiredMedical - returns a list of the required medical documents
Parameters:
CompanyID (int) – to define NumOrgID of the company
Nationality (varchar 2) – to define nationality 2-symbols code

adt_HasRequiredTravel - returns unique sequence of the required travel document for a person
Parameters:
Code (varchar 10) – to define the travel document’s code that would be evaluated
Pin (int) – to define a person whose documents should be checked
Date (datetime) – to define the date for document validity evaluation

adt_HasRequiredMedical - returns a unique sequence of the required medical document for a person
Parameters:
Code (varchar 10) – to define the travel document’s code that would be evaluated
Pin (int) – to define a person whose documents should be checked
Date (datetime) – to define the date for document validity evaluation

APM-6470

Create baseline during period closing when leave paid by vessel location

Change Request

For mode Split Auto-Entry By Vessel Location it is now possible to view & define the baseline for each location. User can set the value that will be used as the starting point of leave days for any Location to be used later.

APM-5850

Add a column to the Enclosed Documents view to show information from Email logging

Bug

We now provide the complete information log for sending emails. When the Crew List > Email Reports is used, we also provide a log on the enclosed document's Distribute action.

APM-6412

Add column for pin's payroll entries grid to display who last changed it and when

Bug

For the payroll entries grid, we added fields to show the last modification date & user name for who performed the change.

APM-6334

 IR7-Taxisnet export: change the logic for Income outside Republic field

Bug

To follow the requirements on Income Outside Republic fields we added EC311 value to epr7m3t0r2c1 & epr7m6t0r1c9 for non-CY crew

APM-6434

Seniority counter general code

Change Request

A new general code Seniority Counter is created under the Payroll section. It provides a user the possibility to setup rules for Seniority calculation when the Contracts datagroup is in use.

APM-6364

 Error message in the Export to IR7-Taxisnet

Bug

Invalid Column Name when refreshing the setup screen

APM-6413

It’s not possible to change the Start/End date of the shift from the Shift Details tab

Bug

Users with None access to routine 509 Can Change Timeblock Dates was able to modify shift start/end

APM-6367

Maintain historical EDAG settings (Per period)

Bug

Database changes so that for the closed payroll period all current E-Dag settings will be stored as per the period in use

APM-6427

Leave paid entry by vessel location

Change Request

As the general improvement for payroll by Vessel Location, it is now possible to view Earned Leave days & select if they should be processed for generating the payroll Leave Paid entry

APM-6425

Activity data-group change for Leave paid activity (Vessel location)

Change Request

We improved function dbo.ad_Temp_SeaService_By_Location so that it doesn’t only collect the earned activities by vessel location, but also takes to count Leave Paid activities (with the same Location & Payscale) deducting corresponding leave earnings.

APM-6419

Payscale Table by Payscale code or Rank

Change Request

The creation of a new contract is improved with the automatic assignment of a payscale, based on his Rank linked under Payscales > Payscale Code > Ranks. If there are several possible assignments, datagroup will offer you the full list for selection

APM-6417

Contract Datagroup needs the possibility to copy information from previous contracts (if exist), (by default the last contract)

Change Request

When creating a new contract it is now possible to copy details from any of the previous contracts, also defining what data you’d like to be copied.

APM-6416

Functionality to select columns in contract overview (contract tree)

Change Request

We added the possibility to customize the appearance of the fields that exist in the datagroup details. Unnecessary fields can now be easily set non-visible by setting the checkbox flag to OFF. You can switch them back to ON when necessary. This is user-related personalization, so your setup will not affect other users of the datagroup.

APM-6211

Update Flight Inbox according to the statuses returned by the Reverse Integration

Change Request

Implemented the possibility to operate with the interface in the Flight Inbox module

APM-5970

Handle leave paid entry/activity by vessel location

Change Request

We improved function dbo.ad_Temp_SeaService_By_Location so that it doesn’t only collect the earned activities by vessel location, but also takes to count Leave Paid activities (with the same Location & Payscale) deducting corresponding leave earnings.

APM-5863

System Freeze in analytical view on the vessel's side

Bug

This is fixed now

APM-5844

Crew Link - add Nationality to Add Crew form in Crew Change > Flight Booking

Change Request

Added the possibility to view crew member’s Nationality to the booking form.

APM-5599

Contract/Subcontract overlapping dates validation

Change Request

Implemented validation for possible date overlaps when creating a new contract/subcontract record.

Table

Field name

Field Type

PW001P03

Leave_Deducted_VesselLocation

Varchar(10)

AUDIT_PW001P03

Leave_Deducted_VesselLocation

Varchar(10)

PW001C125

SEQUENCENO

CODE

NAME

ALTERNATIVE

GROUPNO

CODETYPE

AGGREGATEDBY

CONTRACTSENBY

CONTRACTSENSTARTBY

ACTIVITYSENBY

ACTIVITYTYPEINCLUDED

ACTIVITYCODESEXCLUDED

ACTIVITYCODESINCLUDED

PAYROLLCALCFIELDIDENTIFYSENIORITY

PAYSCALERATECHAR

OPTIONS

CREATED

CREATEDBY

LASTCHANGED

CHANGEDBY

UPDATEFLAGS

repl_ModifiedDate

repl_ModifiedBySite

repl_GMTModifiedDate

Int

Varchar(10)

Varchar(100)

Varchar(10)

Int

Varchar(1)

Varchar(1)

Int

Int

Int

Varchar (max)

Varchar (max)

Varchar (max)

Int

Varchar(1)

Varchar(30)

Datetime

Varchar(6)

Datetime

Varchar(6)

Varchar(125)

Datetime

Int

Datetime

RP_NAT_REQDOC_TRAVEL

DOCUMENT

repl_ModifiedDate

repl_ModifiedBySite

repl_GMTModifiedDate

Varchar(10)

Datetime

Int

Datetime

RP_NAT_EXCLUDED_TRAVEL

DOCUMENT

NATIONALITY

repl_ModifiedDate

repl_ModifiedBySite

repl_GMTModifiedDate

Varchar(10)

Varchar(2)

Datetime

Int

Datetime

RP_NAT_REQDOC_MEDICAL

DOCUMENT

repl_ModifiedDate

repl_ModifiedBySite

repl_GMTModifiedDate

Varchar(10)

Datetime

Int

Datetime

RP_NAT_EXCLUDED_MEDICAL

DOCUMENT

NATIONALITY

repl_ModifiedDate

repl_ModifiedBySite

repl_GMTModifiedDate

Varchar(10)

Varchar(2)

Datetime

Int

Datetime

Activities_by_Location_baseline

CREATEDFROM

Varchar(1)

PW001P01

IFIRSTNAME

ILASTNAME

POSTPLACE

APOSTPLACE

AADDRESS1

AADDRESS2

AADDRESS3

Varchar(100)

Varchar(100)

Nvarchar(100)

Nvarchar(100)

Nvarchar(160)

Nvarchar(160)

Nvarchar(160)

AUDIT_PW001P01

IFIRSTNAME

ILASTNAME

POSTPLACE

APOSTPLACE

AADDRESS1

AADDRESS2

AADDRESS3

Varchar(100)

Varchar(100)

Nvarchar(100)

Nvarchar(100)

Nvarchar(160)

Nvarchar(160)

Nvarchar(160)

PWLOGEDAG

DefChangedDateAfterSent

PayrollPeriod

Datetime

Int

PW001POSDOC_EXCLUDED_NAT

POSITION

DOCUMENT

NATIONALITY

repl_ModifiedDate

repl_ModifiedBySite

repl_GMTModifiedDate

CREATEDBY

CREATETIME

CHANGEDBY

CHANGETIME

Varchar(10)

Varchar(10)

Varchar(2)

Datetime

Int

Datetime

Varchar(32)

Datetime

Varchar(16)

Datetime

PWORGPRC_EXCLUDED_NAT

NUMORGID

REQGROUP

DOCUMENT

NATIONALITY

repl_ModifiedDate

repl_ModifiedBySite

repl_GMTModifiedDate

CREATEDBY

CREATETIME

CHANGEDBY

CHANGETIME

Int

Int

Varchar(10)

Varchar(2)

Datetime

Int

Datetime

Varchar(32)

Datetime

Varchar(16)

Datetime

PWROT_ACTIVESHIFT_ASSIGNEDBYMAINSITE

SEQUENCENO

repl_ModifiedDate

repl_ModifiedBySite

repl_GMTModifiedDate

Int

Datetime

Int

Datetime

PWPOST

NAME

SEQNO

Nvarchar(100)

Bigint