Database Table Definitions

Table Name

Description

Functional Domain

AAM_LAYOUTS

ACC_LOGINSESSION

Login sessions for Adonis Control Center

AIS_TMMASTER

Adonis Integration Service

AUDIT_MRL_MEMBERS

See table name below for description.  AUDIT_<tableName>

Audit table

AUDIT_PW001OLEDOCS

See table name below for description.  AUDIT_<tableName>

Audit table

AUDIT_PW001P01

See table name below for description.  AUDIT_<tableName>

Audit table

AUDIT_PW001P03

See table name below for description.  AUDIT_<tableName>

Audit table

AUDIT_PW001P03A

See table name below for description.  AUDIT_<tableName>

Audit table

AUDIT_PW001P03TC

See table name below for description.  AUDIT_<tableName>

Audit table

AUDIT_PW001P04

See table name below for description.  AUDIT_<tableName>

Audit table

AUDIT_PW001P05

See table name below for description.  AUDIT_<tableName>

Audit table

AUDIT_PW001P06

See table name below for description.  AUDIT_<tableName>

Audit table

AUDIT_PW001P0C

See table name below for description.  AUDIT_<tableName>

Audit table

AUDIT_PW001P0M

See table name below for description.  AUDIT_<tableName>

Audit table

AUDIT_PW001P0P

See table name below for description.  AUDIT_<tableName>

Audit table

AUDIT_PW001P0Y

See table name below for description.  AUDIT_<tableName>

Audit table

AUDIT_PW001P1R

See table name below for description.  AUDIT_<tableName>

Audit table

AUDIT_PW001PAY

See table name below for description.  AUDIT_<tableName>

Audit table

AUDIT_PW001PYH

See table name below for description.  AUDIT_<tableName>

Audit table

AUDIT_PW001U01

See table name below for description.  AUDIT_<tableName>

Audit table

AUDIT_PW001U02

See table name below for description.  AUDIT_<tableName>

Audit table

AUDIT_PWCCMCHANGECREWLIST

See table name below for description.  AUDIT_<tableName>

Audit table

AUDIT_PWCCMCHANGEPOSPROMLIST

See table name below for description.  AUDIT_<tableName>

Audit table

AUDIT_PWCCMFLIGHTARRANGEMENTS

See table name below for description.  AUDIT_<tableName>

Audit table

AUDIT_PWLEAVEACCPROP

See table name below for description.  AUDIT_<tableName>

Audit table

AUDIT_PWORG

See table name below for description.  AUDIT_<tableName>

Audit table

AUDIT_PWORGCMP

See table name below for description.  AUDIT_<tableName>

Audit table

AUDIT_PWORGCMP_NETS_ACCOUNTS

See table name below for description.  AUDIT_<tableName>

Audit table

AUDIT_PWORGDEP

See table name below for description.  AUDIT_<tableName>

Audit table

AUDIT_PWORGPOS

See table name below for description.  AUDIT_<tableName>

Audit table

AUDIT_PWORGRAT

See table name below for description.  AUDIT_<tableName>

Audit table

AUDIT_PWORGVES

See table name below for description.  AUDIT_<tableName>

Audit table

AUDIT_PWPSC000

See table name below for description.  AUDIT_<tableName>

Audit table

AUDIT_PWPSC000_RATES

See table name below for description.  AUDIT_<tableName>

Audit table

AUDIT_PWPSC001

See table name below for description.  AUDIT_<tableName>

Audit table

AUDIT_PWPSC001_RATES

See table name below for description.  AUDIT_<tableName>

Audit table

AUDIT_PWROT_ACTIVE_SHIFT

See table name below for description.  AUDIT_<tableName>

Audit table

AUDIT_PWROT_SHIFT_ACTIVITIES

See table name below for description.  AUDIT_<tableName>

Audit table

AUDIT_PWSECURITY_FIELD_RIGHTS

See table name below for description.  AUDIT_<tableName>

Audit table

AUDIT_PWSECURITY_GCT_RIGHTS

See table name below for description.  AUDIT_<tableName>

Audit table

AUDIT_PWSECURITY_ORGANISATION_RIGHTS

See table name below for description.  AUDIT_<tableName>

Audit table

AUDIT_PWSECURITY_PAYSCALE_RIGHTS

See table name below for description.  AUDIT_<tableName>

Audit table

AUDIT_PWSECURITY_REPORT_RIGHTS

See table name below for description.  AUDIT_<tableName>

Audit table

AUDIT_PWSECURITY_ROUTINE_RIGHTS

See table name below for description.  AUDIT_<tableName>

Audit table

AUDIT_PWSECURITY_USERS

See table name below for description.  AUDIT_<tableName>

Audit table

AUDIT_PYASC001

See table name below for description.  AUDIT_<tableName>

Audit table

AUDIT_WEB_CP_TIMECARD

See table name below for description.  AUDIT_<tableName>

Audit table

D2D_ASSIGN_STATUS

Day-2-Day Assignment statuses

APP > Day to Day module

D2D_ASSIGNMENT

Day-2-Day assignments

APP > Day to Day module

D2D_CATEGORY_GROUPS

Day-2-Day categories

APP > Day to Day module

D2D_CATEGORY_PIN

Day-2-Day pins in categories

APP > Day to Day module

D2D_CATEGORY_TYPES

Day-2-Day category type

APP > Day to Day module

D2D_CUSTOM_FILTER

Day-2-Day custom filter with regex

APP > Day to Day module

D2D_DEF_NATGROUP

Day-2-Day groups per nationalities

APP > Day to Day module

D2D_DEF_SEASON

Day-2-Day season definitions

APP > Day to Day module

D2D_FIXED_CREW_RANKS

Day-2-Day ranks for categories

APP > Day to Day module

D2D_FORECAST

Day-2-Day forecast

APP > Day to Day module

D2D_P03HISTORICAL

Day-2-Day retrospective for assignments

APP > Day to Day module

D2D_PAX_CREWREQ

Day-2-Day crew required by pax range

APP > Day to Day module

D2D_PAXMIX

Day-2-Day age ranges definition

APP > Day to Day module

D2D_PAXSEG

Day-2-Day segment definition

APP > Day to Day module

D2D_PAXTTYPE

Day-2-Day ticket type definition

APP > Day to Day module

D2D_RANK_CATEGORY

Day-2-Day rank and department definition for category

APP > Day to Day module

D2D_WEIGHT_PAXMIX

Day-2-Day weight for age ranges

APP > Day to Day module

D2D_WEIGHT_PAXNAT

Day-2-Day weight for nationality

APP > Day to Day module

D2D_WEIGHT_PAXSEG

Day-2-Day weight for segment

APP > Day to Day module

D2D_WEIGHT_PAXTTYPE

Day-2-Day weight for ticket type

APP > Day to Day module

MRL_Instructions

CSB_Instructions

for CrewStation Bill

MRL_Members

CSB_Preffered assignement

for CrewStation Bill

MRL_PREF_ASSIGNMENT

CSB_Preffered_Assignements

for CrewStation Bill

MRL_Req_Certification

CSB_Station_required certificates

for CrewStation Bill

MRL_Req_Instructions

CSB_Station_Instructions

for CrewStation Bill

MRL_Req_Medical

CSB_Station_required_medical

for CrewStation Bill

MRL_Template

CSB_Muster_template

for CrewStation Bill

MRL_TPL_STATIONS

CSB_Muster_ template _stations

for CrewStation Bill

MRLS_DUTIES

CSB_Station_Duties

for CrewStation Bill

MRLS_SAFETY_LEVELS

CSB_Safety_Levels

for CrewStation Bill

MRLS_SEC_ASSIGNMENT

CSB_Secondary_Assignments

for CrewStation Bill

MRLS_STATION_HEADER

CSB_Station_Headers

for CrewStation Bill

PROJECT_ABSENCE

Obsolete

APP > Project timesheet module

PROJECT_ABSENCE_TYPE

Obsolete

APP > Project timesheet module

PROJECT_EXPENSE

Obsolete

APP > Project timesheet module

PROJECT_EXPENSE_TYPE

Obsolete

APP > Project timesheet module

PROJECT_LOCATION

Obsolete

APP > Project timesheet module

PROJECT_PERIODS

Obsolete

APP > Project timesheet module

PROJECT_REGISTRATION

Obsolete

APP > Project timesheet module

PROJECT_TASK_TYPE

Obsolete

APP > Project timesheet module

PROJECT_TIMESHEET

Obsolete

APP > Project timesheet module

PW_CREW_ACCESS_LEVEL

pin reference for Orgstructure access codes

Access Level module

PW_CREW_ACCESS_LEVEL_DETAILS

Blocked flag for pin

Access Level module

PW_CREWCARD

plastic cards info

PW_CREWCARD_CABINACCESS

plastic cards info

PW_INTERFACEHR_P01

PW001BFNOTES

PW001BKP

BackPay

Payroll

PW001C000_XREF

General codes cross-reference

PW001C00CP

PW001C01

Customized datagroup definition

PW001C02

Ranks

General Codes

PW001C03

Departments

General Codes

PW001C04

Marital Status

General Codes

PW001C05

Color

General Codes

PW001C06

Competences

General Codes

PW001C06R

Competeces replacement

General Codes

PW001C07

Family Relation codes

General Codes

PW001C08

Lifeboats

General Codes

PW001C09OLD

Obsolete

General Codes

PW001C0A

Customized datagroup column definition

General Codes

PW001C10

Firestation

General Codes

PW001C100

Travel Admins

General Codes

PW001C101

Cost Center

General Codes

PW001C102

Calendars

General Codes

PW001C102_HOLIDAYS

Calendar holidays

General Codes

PW001C103

Costs

General Codes

PW001C104

Plan Type 

General Codes

PW001C105

Plan 

General Codes

PW001C106

Employment status

General Codes

PW001C107

Custom exports

General Codes

PW001C108

Appraisals view

General Codes

PW001C109

Replication Route

General Codes

PW001C109_VES

Replication Route views

General Codes

PW001C11

Adonis Query - Selection Fields

General Codes

PW001C110

Replication Routines View

General Codes

PW001C111

IBAN Countries

General Codes

PW001C112

Interfaces

General Codes

PW001C113

Clearing System identification

General Codes

PW001C114

Annual Summary code definition headers

General Codes

PW001C115

Regulatory

General Codes

PW001C116

Cancellation Reasons 

General Codes

PW001C117

Entrycode categories

Payroll

PW001C118

Levels of Urgency

General Codes

PW001C119

Start Page datasource

General Codes

PW001C12

Activity codes

General Codes

PW001C120

Access Level

General Codes

PW001C12A

Leave Factors of Leave Days accumulators for Activity codes

General Codes

PW001C13

Appraisal marks

General Codes

PW001C14

Appraisal questions

General Codes

PW001C15

Currencies

General Codes

PW001C15E

Currencies historical

General Codes

PW001C16

Activity views

General Codes

PW001C17

Competence views

General Codes

PW001C18

Travel views

General Codes

PW001C19

Activities category

General Codes

PW001C20

Manning agent code

General Codes

PW001C21

Union code

General Codes

PW001C22

Person Cost Groups

General Codes

PW001C23

Travel Documents

General Codes

PW001C24

Medical codes

General Codes

PW001C25

Allotment codes

General Codes

PW001C26

Banks

General Codes

PW001C27

Leave Days accumulators

General Codes

PW001C28

Customized fields

General Codes

PW001C29

Vessel Type

General Codes

PW001C30

Engine type

General Codes

PW001C31

Radio type

General Codes

PW001C32

Contract type

General Codes

PW001C33

Person Category

General Codes

PW001C34

Vessel register

General Codes

PW001C35

Vessel cost group

General Codes

PW001C36

Rotation plans

General Codes

PW001C36P

Rotation shift periods

General Codes

PW001C36S

Rotation shift defintion

General Codes

PW001C36ST

Rotation shift time periods

General Codes

PW001C36T

Rotation time periods

General Codes

PW001C37

Appraisals input views

General Codes

PW001C38

Payroll status

General Codes

PW001C39

Payroll type

General Codes

PW001C40

Crew pool

General Codes

PW001C41

Appraisals test site

General Codes

PW001C42

Project

General Codes

PW001C43

Person cost place

General Codes

PW001C44

Vessel location

General Codes

PW001C45

OLE doc types

General Codes

PW001C46

Pension fund class

General Codes

PW001C47

Port types

General Codes

PW001C48

Airports

General Codes

PW001C49

Holiday groups

General Codes

PW001C50

Not in use

General Codes

PW001C51

Not in use

General Codes

PW001C52

Cabin

General Codes

PW001C53

Vessel activity

General Codes

PW001C54

Vessel category

General Codes

PW001C55

Deactivation reason

General Codes

PW001C56

Rank catergory

General Codes

PW001C57

Requisition type

General Codes

PW001C58

Terms of payment

General Codes

PW001C59

VAT rates

General Codes

PW001C60

Requisition type

General Codes

PW001C61

Timecard Worktypes

General Codes

PW001C62

Body affected codes for medical insurance

General Codes

PW001C63

Status codes for medical insurance

General Codes

PW001C64

Incident type codes for medical insurance

General Codes

PW001C65

Classification codes for medical insurance

General Codes

PW001C66

Candidates status codes for medical insurance

General Codes

PW001C67

Family views

General Codes

PW001C68

Medical views

General Codes

PW001C69

Medical Insurance views

General Codes

PW001C70

Requisition codes

General Codes

PW001C71

Customized report groups

General Codes

PW001C72

Customized topics views

General Codes

PW001C73

Contact types

General Codes

PW001C74

Dynamic Positioning system

General Codes

PW001C75

OLE doc views

General Codes

PW001C76

Club codes for medical insurance

General Codes

PW001C77

Incident views for medical insurance

General Codes

PW001C78

Crew List views

General Codes

PW001C79

Embarking/Diseambarking reasons

General Codes

PW001C80

Rotation Plan codes

General Codes

PW001C81

Rotation Plan views

General Codes

PW001C82

Religion

General Codes

PW001C83

Customized Fiields views

General Codes

PW001C84

Crew Effects codes

General Codes

PW001C85

Crew Effects views

General Codes

PW001C86

Measurements

General Codes

PW001C87

Position Seniority category

PW001C88

Data mining codes

PW001C89

Data mining views

PW001C90

Airlines

PW001C91

Claim codes for medical insurance

PW001C92

Legal Statгs for medical insurance

PW001C94

Vessel Size

PW001C95

Muster Roll Teams

PW001C96

Crew List view groups

PW001C97

Lifeboats/Rafts Position

PW001C98

Muster Roll Safety Levels

PW001C99

Cabin Allocation Watch

PW001C123

Personal Rates Codes (Contracts Datagroup)

PW001DOCLINK

Keywords for documents

PW001DUV

Dynamic selections

PW001MEMO

SQL Statements for merge

PW001OLEDOCS

OLE Documents

PW001OLEDOCS_BKMARKS

Bookmarks for Merge documents

PW001OLEKEYWORDS

Keywords for OLE documents

PW001P01

Personal Details

PW001P01_EDAG_Arbeidsforhold

PW001P01_EDAG_permisjon

PW001P01_LEAVEACC_LINK

Leave Accumulators M-M link table

PW001P01_NO_RPT

PW001P01_REPL_ROUTE

Person's replication routes

PW001P01_XREF

Person's cross-references

PW001P01BANKACCHIST

Personal history on bank account details

PW001P01BASKET

Documents in Basket

PW001P01HIST

<not in use>

PW001P01OLE

Person & OLE relation

PW001P01PICT

Person's link for picture from OLE documents

PW001P01SFAM

Familiy members that are defined in PW001P01 so that they can be signed on to a vessel as a normal seafarer

PW001P01SN

Person's Sticky Notes

PW001P01TRAVEL

Travel information for the person

PW001P02

Customized datagroup values

PW001P03

Activities

PW001P03A

Activity leave accumulators reference

PW001P03REQUEST

Activity Requests

PW001P03TC

Activity timecards

PW001P03W

PW001P04

Appraisals records

PW001P05

Competence documents

PW001P06

NOK

PW001P06SSN

Identification numbers for NOK

PW001P07

Medical documents

PW001P08

Travel Documents

PW001P09

Alltotments

PW001P0C

Personal payroll accumulators

PW001P0K

<not in use>

PW001P0L

Life Insurance

PW001P0M

Appraisals marks

PW001P0N

Personal notes

PW001P0P

Rank, Employment & Payscale

PW001P0R

Personal relations between persons

PW001P0S_PAYSCALECODE

PW001P0T

telecommunication details

PW001P0TT

telecommunication types

PW001P0U

Customized fields values

PW001P0V

Personal vessel-specific info

PW001P0W

<not in use> Wage information. ( Not used any more, Payscale used instead)

PW001P0Y

Person's payroll info

PW001P0Y_BK_OLDBANKCODE

PW001P0Y_HIST

Person's payroll info history

PW001P0Y_USW4

PW001P0YTAXCARD

PW001P10

Person's documents

PW001P11

Medical insurance incidents

PW001P11C

Medical Insurance claims

PW001P11OLD

PW001P11V

Medical Insurance vouchers

PW001P11VOLD

PW001P15

Crew Effects

PW001P16

PW001P16B

PW001P20

Contracts Datagroup

PW001P20R

Personal Rates (Contracts Datagroup)

PW001P20U

Contracts Customized Fields

PW001P1POLD

PW001P1R

Personal Rates

PW001P2P

Provident Fund

PW001PAI

Payroll Additional Info

PW001PAI_BK_OLDBANKCODE

PW001PAY

List of payroll transaction for current period

PW001PAY_BANKRECEIPT

PW001POSDOC

Position Required Documents

PW001POSDOC_FLAG

Position Required Documents by Flag

PW001POSDOC_LINK

PW001POSDOC_PRINCIPAL

Position Required Documents by Principal

PW001POSDOC_VESSEL

Position Required Documents by Principal

PW001POSDOC_VSLTYPE

Position Required Documents by vessel Type

PW001PROMHIST

Promotion history

PW001PROMRANKDOC

Documents for promotion

PW001PT6

Telecommunication for Next of Kin

PW001PYH

Payroll transactions historical

PW001PYM

Payroll Message

PW001RID

Report Input values from the latest time the report was run

PW001U0X

Customized datagroup(s)

PWACMACCOUNT

Onboard Accounting Module - Accounts

PWACMANALYTICS

Onboard Accounting Module - Account Analyical Data

PWACMBALANCE

Onboard Accounting Module - Accounts Balance

PWACMOPERATION

Onboard Accounting Module - Account Accounting Operations

PWACMPERIOD

Onboard Accounting Module - Accounting Periodes

PWACMTRANSACTIONLOG

Onboard Accounting Module - Trabnsactions

PWAIRPORT

Airport records

PWAIRPORTCONTACTS

Airportcontacts records

PWAIRPORTDOCS

Airportdocs records

PWAPMCREWMAPPING

Apmcrewmapping records

PWAPMCREWMAPPINGLOG

Apmcrewmappinglog records

PWBFBOOKNO

Bfbookno records

PWBFCONDITION_CHANGED

PWBUDGET_VSL_NAT_DETAILS

Budget Module by Vessel Nationality -Details

PWBUDGET_VSL_NAT_HEADER

Budget Module by Vessel Nationality -Headers

PWCCMACTDEF

Activity Information for Crew Change

PWCCMAGENTARRANGEMENTS

Agent arrangements

Crew change module

PWCCMAIRSEGMENTS

Flight segments

Crew change module

PWCCMCHANGECREWLIST

list of crew in Calling Port crewchanges

Crew change module

PWCCMCHANGEPLNPOSLIST

Crew Change Module - SignOn - Position List

Crew change module

PWCCMCHANGEPOSPROMLIST

list of crew in Calling Port promotion records

Crew change module

PWCCMFLIGHTARRANGEMENTS

Flight bookings

Crew change module

pwccmflightbooklog

Flight bookings log

Crew change module

PWCCMFLIGHTBOOKSTATUSLOG

Log of booking statuses

Crew change module

PWCITY

Cities in post register

PWCMPHOLIDAYS

Holidays setup on Company level

PWCMPPAY

Payroll settings on Company level

PWCONTINENT

Continents in post register

PWCOUNCIL

Concil Information

PWCOUNTRY

Countries in post register

PWCOUNTRYPROP

PWCOUNTY

Counties & states in post register

PWCREWLINKREFERENCES

References for ATPI Crewlink

PWCREWLINKREFERENCESDATA

PWCTCCCT

Contact type codes

PWCTCCMP

Company contact information

PWCTCPCM

Personal telecom details for Contact persons

PWCTCPER

Contact persons

PWCTCTLC

Telecom details for Contact of Companies

PWDBUPGRADE

PWDBVERSION

Log of database version upgrades

PWDEFDIR

PWDSC001

<not  in use> Accumulator Description set (not in use)

PWDSC002

<not  in use> Accumulator Description tests (not in use)

PWEDAGCODE

PWEDAGCombinationDEF

PWEDAGDEF

Defenitions EDAG codes for EDAG functionality

PWEDAGReporter

PWEDAGYRKESKODE

PWEUREKABUGREPORTLOG

PWEXPORT_SETTINGS

User settings for various export tools

PWFIELDOPTIONS

PWIMPORTBOOKINGLOG

PWIMPORTWRLOG

PWINDKOMSTCODE

PWINTERFACESENDRECVDLOG

PWINTERFACETASK

PWINTERFACETRACKCHANGES

PWINVOICE

Invoices

PWINVOICELINE

Invoicelines

PWLANGUAGE

PWLEAVEACCPROP

Setting for Leave Accumulators

PWLMSTRACKCHANGES

PWLOG_PAYROLL_EXEC

Payroll execution log

PWLOG_PAYROLL_REPORTS

Log for Payroll reports generation

PWLOGEDAG

PWLOGEXPORTIMPORT

Log of Export / import tools

PWLOGINNTEKTSMELDING

PWLOGINSESSION

Log of operational sessions of APM users

PWMODULES

APM Modules (not in use)

PWORG

Organization structure tree

PWORG_ACCESS_LEVEL

Access Level setup on Organization structure level

PWORG_XREF

Cross references for Org.structure

PWORGCMP

Company level properties for Org.structure

PWORGCMP_ALLOTMENT

Company allotment settings for Org.structure

PWORGCMP_ALLOTMENT_DETAILS

Company allotment setting details for Org.structure

PWORGCMP_COMPENSATION

Compensation settings for Udligninsgskontorer export on company level

PWORGCMP_DAN_PENSION

Company settings for Dannish pension reporting

PWORGCMP_DAN_VOLPENSION

Company settings for voluntary Dannish pension reporting

PWORGCMP_FNO_ADDITIONAL_WAGES

Settings of FNO Export

PWORGCMP_FNO_AVTALEFESTET_PENSJON

Settings of FNO Export

PWORGCMP_FNO_HOURLY_WAGES

Settings of FNO Export

PWORGCMP_LEAVEACC_LINK

Organization Company Leave Accumlators link table

PWORGCMP_NETS_ACCOUNTS

Company net accounts properties for Org Structure

PWORGCMP_PFA_CORPENSION

Company PFA Export settings for Org Structure 

PWORGCMP_PFA_MPLEAVE

Company PFA Export settings for Org Structure 

PWORGCMP_PFA_PENSION

Company PFA Export settings for Org Structure 

PWORGCMP_PFA_VOLPENSION

Company PFA Export settings for Org Structure 

PWORGCMP_TRAVEL_EXPENSES

Company Settings for Travel Expense processing

PWORGCMP_TRAVEL_EXPENSES_DETAILS

Transaction details for Travel Expense processing

PWORGCMPBALANCES

Company filter of available balance actions for Payroll - Payment tab

PWORGCON

Concern info

PWORGCTC

Company contacts from Contacts module

PWORGDEP

Department level properties for Org.structure

PWORGGCD

General codes fields availability setup on Company level

PWORGOBJ

OLE documents setup on Company level

PWORGPOS

Position level properties for Org.structure

PWORGPOS_SAFETY_LVL_MANNING

Positions safety manning setup

PWORGPRC

Activated requirements from Position Requirements Profile per Org.level

PWORGPRS

Sea-service requirements for positions

PWORGPSC

Organization payscales

PWORGRAT

Organization rates

PWORGRTD

Required Travel documents per organization

PWORGTEL

Telecom info on Organization level

PWORGVES

Vessel level properties for Org.structure

PWORGVES_Deck

Deck settings for vessel

PWORGVES_Manning

Crew Manning settings for vessel

PWORGVES_Manning_Psn

Position Manning settings for vessel

PWORGVES_PAYSCALE

Availability for payscales setup on Vessel level

PWORGVES_Stations

Rescue Stations setup on vessel level

PWORGVES_VOYAGE

Vessel Voyages

PWORGVES_Zone

Rescue Zones setup on vessel level

PWORGVESACT

Calling Ports per vessel

PWORGVESCAB

Vessel cabin allocation

PWORGVESCABOLE

OLE documents for cabin allocation

PWORGVESFS

Firestations setup on vessel level

PWORGVESFSOLE

OLE documents for fire stations

PWORGVESLB

Lifeboats & rafts setup on vessel level

PWORGVESLBOLE

OLE documents for lifeboats

PWORGVESOPH

Vessel owner/principal history

PWORGVIR

Virtual organization properties for Org.structure

PWPLANNERDATA

Planner Module - Data

PWPLANNERRES

Planner Module - Resources

PWPLANNERTODO

Planner Module - ToDo items

PWPLNTURN

Not In use

PWPLUGINS

Plugins List

PWPORT

Ports module records

PWPORTCONTACTS

Port contacts

PWPORTDOCS

Port documents

PWPORTREP

List of reports required in that port

PWPORTRTD

Travel documents required per calling port

PWPOST

zip codes register

PWPRJ_CERTIFICATES

Project Required Certificates

PWPRJ_MEDICALCERT

Project Required Medical Documents

PWPRJ_POSITION_REQ

Project Positiion Requirements

PWPRJ_POSITIONS

Project Required Positions

PWPRJ_TRAVELDOCS

Project Required Travel Documents

PWPROJP01

Links between persons and projects

PWPROJVES

Vessel Projects

PWPSC_RATES_COLUMNS

Payscale rates columns setup

PWPSC_RATES_LINES

Payscale rates lines setup

PWPSC000

Payscale Table general properties

PWPSC000_LEAVEACC_LINK

Payscale Table Leave accumulator properties

PWPSC000_RATES

Payscale Table rates setup

PWPSC000_TAA

Payscale Table setup for Time & Attendance module

PWPSC000APPRAISAL

Payscale Table appraisals setup

PWPSC000HOURS

PWPSC000INTERVAL

PWPSC000TIME

PWPSC000WORKTYPEMAP

PWPSC001

Payscale Code general properties

PWPSC001_LEAVEACC_LINK

Payscale Code Leave accumulator properties

PWPSC001_RATES

Payscale Code rates setup

PWPSC001_TAA

Payscale Code setup for Time & Attendance module

PWPSC001HOURS

PWPSC001INTERVAL

PWPSC001RANK

PWPSC001TIME

PWRefusionReportInput

PWRGM_EMAIL_REPORT_TASK_PINS

Pins affected by active Email Report tasks

PWRGM_EMAIL_REPORT_TASKS

Active Email Report tasks

PWRGM_EMAIL_REPORTS

Definition of Email Reports

PWRGREPORTS

Reports from Report Generator module, properties & .fr files

PWRIMREQD

Requisition details

PWRIMREQM

Requisition

PWRIMREQQLF

PWRIMREQSD

PWROT_ACTIVE_SHIFT

Rotation plan maitenance data -actual shifts

PWROT_DETAILS

Rotation plan Details

PWROT_HDR_VSLS

Rotation Header vessels

PWROT_HEADERS

Rotation Headers - (Rotation Plans list)

PWROT_POS_COMMENTS

Rotation plan position comemnts

PWROT_POS_ROT_SHIFT

Rotation plan position shifts definition

PWROT_SHIFT_ACTIVITIES

Links between Rotation plan actual shifts & activities

PWROUTEPORT

Port in sailing route

PWSAILINGPLAN

A vessels sailing plan

PWSALEITEM

Saleitems for invoicing

PWSCRIPTS

Payroll scripts

PWSCRIPTS_HISTORY

Payroll scripts history of modifications

PWSEAROUTE

A sea route

PWSECURITY_DOCS

PWSECURITY_FIELD_GROUPS

Access Rights for fields groups setup

Adonis Control Centre 

PWSECURITY_FIELD_RIGHTS

Access Rights for fields setup

Adonis Control Centre 

PWSECURITY_FIELDS

Fields list under access control

Adonis Control Centre 

PWSECURITY_GCT_RIGHTS

Access Rights for general code setup

Adonis Control Centre 

PWSECURITY_LEVELS

Orgunits under access control

Adonis Control Centre 

PWSECURITY_ORGANISATION_RIGHTS

Access Rights for Orgunits setup

Adonis Control Centre 

PWSECURITY_PAYSCALE_RIGHTS

Access Rights for Payscales setup

Adonis Control Centre 

PWSECURITY_PLUGINS_RIGHTS

Access Rights for Plugins setup

Adonis Control Centre 

PWSECURITY_REPORT_GROUPS

Access Rights for Reports groups setup

Adonis Control Centre 

PWSECURITY_REPORT_RIGHTS

Access Rights for Reports setup

Adonis Control Centre 

PWSECURITY_REPORTS

Reports list under security control

Adonis Control Centre 

PWSECURITY_ROUTINE_GROUPS

Access Rights for security routines groups setup

Adonis Control Centre 

PWSECURITY_ROUTINE_RIGHTS

Access Rights for security routines setup

Adonis Control Centre 

PWSECURITY_ROUTINES

Routines list under security control

Adonis Control Centre 

PWSECURITY_USERS

Users list under access control

Adonis Control Centre 

PWSEQ

Sequence counter control

PWSETTINGS

Global Settings

PWTELEPAYDIR

PWTEXT

Customer defined text for Organization units. Used to set text on Rates tabs on Company and Concern.

PWTRAVELEXPENSES

PWTRAVELPACK

Travel packs

PWTRAVELPACKAGENTS

Agents (from contact register) linked to travel packs

PWTRN_COURSE_SCHEDULES

Definition of schedules for Course Scheduler module

PWTRN_COURSE_SCHEDULES_BOAT_FROM

Course Module Vessels

PWTRN_COURSE_SCHEDULES_OLEDOCS

Course Module - Certificates Scans

PWTRN_COURSES

Definition of cources for Course Scheduler module

PWTRN_CRS_SCHEDULE_P01

List of enrolled participants on coure for Course Scheduler module

PWTRN_CRSTYPES_C06

Definition of certificates for Course Scheduler module

PWTRN_INSTRUCTORS

List of assigned instructors to drills for Course Scheduler module

PWTRN_SCHEDULEP01_P05

List of issued cerificates for Course Scheduler module

PWTRN_SUPPLIERS

Defenition of suppliers and vessels(drills) for Course Scheduler module

PWUSERCSLLAYOUT

Crew List Layouts

PWUSERLASTVALUE

Stores the last values used by each user in inputforms, etc.

PWUSERSETTINGS

User Options

PWVESCOSTPLACE

Vessel Cost Place

PWPSC000HOURMAP

PWWIZARD

Wizards

PWWIZFIELD

Wizard fields

PWWIZLASTVAL

Last input values used in the wizard

PWWIZPAGE

Wizard Page

PY001ACC

Accounts for accounting

PY001ASI

Annual Summary information for per

PYASC001

Annual Summary Code information for an Entry Code

PYASCDEF

Annual Summary Code definition

PYETY001

Entrycode properties

PYETY001_COMMENTS

Entrycode comments

PYETY001ADP

Entry Code settings for ADP Export

PYETY001INPUTFIELDS

EntryCode input fields

PYETY001RSM

PYETY001TXT

Entry Code text

repl_Channel

Channel properties

Replication properties

repl_Channel_Log

Channels log

Replication properties

repl_Channel_Task_Log

Task log

Replication properties

REPL_CUSTOMIZED_TOPICS

Replication properties

repl_Deleted

Replication properties

REPL_DELETED_LOG

Replication properties

repl_DirectionType

Direction Type setup

Replication properties

repl_DirectionType_Channel

Channel setup

Replication properties

repl_DirectionType_Task

Direction Type tasks

Replication properties

repl_Files

Replication properties

repl_Programs

Applications which are updated via Replicator

Replication properties

repl_ProgramState

Update results of programs via Replicator on each site

Replication properties

repl_RowId

Replication properties

repl_Schedule

Replication properties

repl_Site

List of all sites 

Replication properties

repl_Task

List of replication tasks

Replication properties

repl_TaskType

Replication task types

Replication properties

repl_UpdateParameters

Parameters which are used for program update process via Replicator

Replication properties

REPL_VERSION

Log of Replicator version upgrades

SPM_FIELDS

Start Page Module - List of Fields

SPM_FRAMES

Start Page Module - List of Frames

SPM_TILES

Start Page Module - List of Tiles

SPM_TILES_USER

Start Page Module - User settings

VRP_DOC_PRINCIPAL_LINK

Requiremenst Profile - principal Link

VRP_DOC_PRNCIPAL

Requiremenst Profile - principals

VRP_DOC_VESSEL

Requiremenst Profile - vessels 

VRP_DOC_VESSEL_LINK

Requiremenst Profile - vessel link

VRP_DOC_VESSELTYPE

Requiremenst Profile - vessel types

VRP_DOC_VESSELTYPE_LINK

Requiremenst Profile - vessel type link

VRP_EXP_PRINCIPAL_LINK

Requiremenst Profile - experience principal link

VRP_EXP_PRNCIPAL

Requiremenst Profile - experience principals

VRP_REQ_DOCUMENT

Requiremenst Profile - required documents

VRP_REQ_DOCUMENT_LVLQTY

required levels qty

VRP_REQ_EXPERIENCE

Requiremenst Profile - Experience

WEB_CP_ACCOMMODATION

Accomodation

APP > Travel Expense module

WEB_CP_ACCOMMODATION_TYPE

Accomodation type

APP > Travel Expense module

WEB_CP_ACCOUNT_EMPLOYEE

Users

APP

WEB_CP_ACCOUNT_STATUS

Account statuses 

APP

WEB_CP_ADMIN

Admins

APP

WEB_CP_ALLOWANCE_RATE

Allowance rate

APP > Travel Expense module

WEB_CP_API_LOGIN

API logins 

APP

WEB_CP_BATCH_ACCESS_POSITION

Batch access for TAA

APP > Time and Attendance module

WEB_CP_COA_APPROVER_VESSELS

Approver vessels

APP > Chain of Approval

WEB_CP_COA_CHAIN

Chain

APP > Chain of Approval

WEB_CP_COA_Tree

CoA tree

APP > Chain of Approval

WEB_CP_COA_Tree_Approvers_Nodes

Approvers nodes

APP > Chain of Approval

WEB_CP_COA_Tree_Nodes

Tree nodes

APP > Chain of Approval

WEB_CP_COA2_NODE_DETAILS

Node details

APP > Chain of Approval

WEB_CP_COA2_TREE

CoA tree

APP > Chain of Approval

WEB_CP_COUNTRY_ALLOWANCE

Country allowance

APP > Travel Expense module

WEB_CP_DBVERSION

Versions

APP

WEB_CP_DOCUMENT_TYPE

Document types

APP > Chain of Approval

WEB_CP_DOCUMENTS

Documents

APP > Chain of Approval

WEB_CP_ELEMENTS

Elements

APP > Access Rights

WEB_CP_EMAIL_SERVER

SMTP server settings

APP

WEB_CP_ESIGN

Documents description

APP > Electronic signing module

WEB_CP_ESIGN_CERTIFICATE

Adonis X509Certificate

APP > Electronic signing module

WEB_CP_ESIGN_DOCUMENT

Documents

APP > Electronic signing module

WEB_CP_GANGWAY_ACTIONS

Actions

APP > Gangway Web Service

WEB_CP_GANGWAY_REGISTRY

Registrations

APP > Gangway Web Service

WEB_CP_LAYOUT_SETTINGS

Layout customization

APP

WEB_CP_LOCATIONS

Panel PC location

APP > Time and Attendance module

WEB_CP_MESSAGE

Messages

APP > Messages

WEB_CP_MESSAGE_FOLDER

Inbox / outbox message indication

APP > Messages

WEB_CP_MESSAGE_FOLDER_PROFILE

Folder names for messages

APP > Messages

WEB_CP_MODULES_USERTYPES

Elements definition for module types

APP > Access Rights

WEB_CP_NOTIFICATION_EMAILS

Emails

APP > Notification Service

WEB_CP_NOTIFICATION_TASKS

Tasks

APP > Notification Service

WEB_CP_NOTIFICATION_TASKS_LOG

Log

APP > Notification Service

WEB_CP_ORGANIZATION_RANKS

Define ranks for Usergroup

APP > Access Rights

WEB_CP_PAYROLL_OUTLAY_TYPE

Configuration outlay type

APP > Travel Expense module

WEB_CP_RELIEVER

Relivers

APP > Time and Attendance module

WEB_CP_REPORT_MODULES

Obsolete table

APP > Reports

WEB_CP_REPORT_SETTINGS

Settings

APP > Reports

WEB_CP_REPORT_USERGROUPS

Usergroups

APP > Reports

WEB_CP_REPORTS_MODULES

Modules

APP > Reports

WEB_CP_ROLE_ACCESS

Role access

APP > Access Rights

WEB_CP_ROLES

Roles

APP > Access Rights

WEB_CP_ROSTER_LOCATION

Locations

APP > Roster Planning module

WEB_CP_ROSTER_POSITION

Positions

APP > Roster Planning module

WEB_CP_ROSTER_WATCH

Watch

APP > Roster Planning module

WEB_CP_ROSTER_WATCH_ASSIGNED

Assigned for watch

APP > Roster Planning module

WEB_CP_ROSTER_WATCH_TIME

Watch time

APP > Roster Planning module

WEB_CP_ROSTER_WATCH_TIME_ASSIGNED

Assigned for watch time

APP > Roster Planning module

WEB_CP_SETTELMENT_SUMMARY

Settelment summary

APP > Travel Expense module

WEB_CP_SETTINGS2

Settings

APP

WEB_CP_SETTLEMENT_TYPE

Settelment type

APP > Travel Expense module

WEB_CP_SUBTEAM

Subteam

APP > Time and Attendance module

WEB_CP_SUBTEAM_MEMBERS

Subteam members

APP > Time and Attendance module

WEB_CP_TAA_MODULES

TAA modules

APP > Time and Attendance module

WEB_CP_TE_SETTINGS

TE settings

APP > Travel Expense module

WEB_CP_TIMECARD

Time registrations

APP > Time and Attendance module

WEB_CP_TIMECARD_ACCEPT_VIOL

Accept violations

APP > Time and Attendance module

WEB_CP_TIMECARD_BATCH_TEMPLATE

Batch template

APP > Time and Attendance module

WEB_CP_TIMECARD_BATCH_TEMPLATE_DEFINITION

Batch template definition

APP > Time and Attendance module

WEB_CP_TIMECARD_DAILY_DETAILS

Timecars daily details

APP > Time and Attendance module

WEB_CP_TIMECARD_PENDING

Pending time registrations

APP > Time and Attendance module

WEB_CP_TIMECLOCK_SETTINGS

Timeclock settings

APP > Time and Attendance module

WEB_CP_TIMECLOCKS

Timeclock communications

APP > Time and Attendance module

WEB_CP_TIMESHEET_PLAN_DETAILS

Plan Details

APP > Time and Attendance module

WEB_CP_TIMESHEET_PLANS

Timesheet plans

APP > Time and Attendance module

WEB_CP_TIMESHEETS

Timesheets

APP > Time and Attendance module

WEB_CP_TIMESHEETS_PERIOD

Timesheet period

APP > Time and Attendance module

WEB_CP_TIMEZONES

Timezones

APP

WEB_CP_TIMREG_ENTRIES

Entries

APP > Time and Attendance module

WEB_CP_TIMREG_TEMPL

Template for time registration

APP > Time and Attendance module

WEB_CP_TIMREG_TEMPL_ENTRIES

Entries in template

APP > Time and Attendance module

WEB_CP_TRANSPORTATION_TYPE

Transportation type

APP > Travel Expense module

WEB_CP_TRAVEL_ACTIVITIES

Travel activities

APP > Travel Expense module

WEB_CP_TRAVEL_BILLS

TE documents

APP > Travel Expense module

WEB_CP_TRAVEL_DEDACTIONS

Travel dedactions

APP > Travel Expense module

WEB_CP_TRAVEL_EXPENSE_SCANS

Expense scans

APP > Travel Expense module

WEB_CP_TRAVEL_OUTLAY

Travel outlay

APP > Travel Expense module

WEB_CP_TRAVEL_RATE_PERIOD

Travel reate period

APP > Travel Expense module

WEB_CP_TRAVEL_REASON

Travel reason

APP > Travel Expense module

WEB_CP_TRAVEL_SPECIFICATION

Travel specification

APP > Travel Expense module

WEB_CP_USER_SETTINGS

User settings

APP

WEB_CP_USERGROUP

Usergroups

APP > Access Rights

WEB_CP_USERGROUP_ORGANIZATION_INHERITANCE

Organization inheritance

APP > Access Rights

WEB_CP_USERGROUP_POSITION

Usergroup positions

APP > Access Rights

WEB_CP_USERGROUP_ROLE

Usergroup roles

APP > Access Rights

WEB_CP_WATCHKEEPERS

Watchkeepers

APP > Time and Attendance module

WEB_CP_WDA_EXPENSE

Expenses 

APP > Work Days Accounting module

WEB_CP_WORKFLOW

Document states and steps

APP > Chain of Approval

WEB_CP_ESIGN

Electronic Signin

APP > ESign

WEB_CP_ESIGN_CERTIFICATE

Electronic Signin

APP > ESign

WEB_CP_ESIGN_DOCUMENT

Electronic Signin

APP > ESign

WEB_CP_ESIGN_SIGNATURE

Electronic Signin

APP > ESign

WEB_CP_ACCOUNT_CREW

Users ( Crew Portal)

APP

WEB_CP_WORKTYPES

Worktypes

APP > Time and Attendance module

WEB_CP_TIMESHEETS_ESIGN

Electronic Signin

APP> ESign

WEB_CP_ACCOUNT_STATUS

Status (ACTIVE ,PASSIVE, BLOCKED)

APP

WEB_CP_EVAL_ANSWERS

 SELECTED_ANSWER

 Drop column

 WEB_CP_EVAL_ANSWERS

 COMMENT_EVALUATEE

 NVARCHAR(MAX)

 Add column

 WEB_CP_EVAL_ANSWERS

 COMMENT_EVALUATOR

 NVARCHAR(MAX)

 Add column

 WEB_CP_EVAL_RULE

 New table

 WEB_CP_EVAL_RULE

 TEMPLATE_SEQNO

 Drop column

 WEB_CP_EVAL_RULE

 TEMPLATE_CODE

 varchar(10)

 Add column

WEB_CP_EVAL_RULE_RANKS

New table

WEB_CP_EVAL_DOCUMENTS

DATETIME

DATETIME

Change field type

WEB_CP_EVAL_RULE

WORKFLOWDEF_ID

INT

Add column

WEB_CP_EVAL_WORKFLOW_DEFINITION

New table

WEB_CP_EVAL_WORKFLOWSTAGES

New table

WEB_CP_EVAL_WORKFLOW

 New table

 WEB_CP_ACTIVITIES_PRIORITY

 New table

 WEB_CP_EVAL_WORKFLOW_DEFINITION

 CODE

VARCHAR(10)

Change field type

 WEB_CP_EVAL_WORKFLOWSTAGES

 CODE

VARCHAR(10)

Change field type

WEB_CP_EVAL_WORKFLOWSTAGES

EVALUATOR_TIMELINE_TEXT

NVARCHAR(MAX)

New column

WEB_CP_EVAL_WORKFLOWSTAGES

EVALUAEE_TIMELINE_TEXT

NVARCHAR(MAX)

New column

WEB_CP_EVAL_WORKFLOWSTAGES

IS_READONLY_EVALUAEE

BIT

New column

WEB_CP_EVAL_WORKFLOWSTAGES

IS_SUBMIT_EVALUAEE

BIT

New column

WEB_CP_EVAL_WORKFLOWSTAGES

IS_SHOW_COMMENT

BIT

New column

WEB_CP_GRATUITY_SIGONOFF_RULE_ACTIVATION

DEFAULT_SON

Drop column

WEB_CP_GRATUITY_SIGONOFF_RULE_ACTIVATION

DEFAULT_SOF

Drop column

WEB_CP_EVAL_WORKFLOWSTAGES

STAGE_STEP

INT

Change field type

WEB_CP_EVAL_SECTIONS

WEIGHT

INT

New column

WEB_CP_EVAL_WORKFLOWSTAGES

AR_EVALAUEE_EVALUAEE

VARCHAR(10)

New column

WEB_CP_EVAL_WORKFLOWSTAGES

AR_EVALUAEE_EVALAUTOR

VARCHAR(10)

New column

WEB_CP_EVAL_WORKFLOWSTAGES

AR_EVALAUTOR_EVALUAEE

VARCHAR(10)

New column

WEB_CP_EVAL_WORKFLOWSTAGES

AR_EVALAUTOR_EVALAUTOR

VARCHAR(10)

New column

WEB_CP_GRATUITYPOS

ETAG

VARCHAR(100)

Change field type

WEB_CP_REPORT_SETTINGS

DEFAULT_FOR_ROSTER

bit

New column

WEB_CP_EVAL_DOCUMENTS

STATUS

NVARCHAR(255)

New column

WEB_CP_EVAL_DOCUMENTS

DATETIME

DATETIME

New column

WEB_CP_EVAL_WORKFLOWSTAGES

IS_ALLOW_REJECT

BIT

New column

WEB_CP_EVAL_WORKFLOW

CREATION_DATE

DATETIME

New column

WEB_CP_EVAL_WORKFLOW

ANSWERS_JSON

NVARCHAR(MAX)

New column