Skip to end of banner
Go to start of banner

Database Table Definitions

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Version History

« Previous Version 4 Next »

Tip!

Use "ctrl + F" to search for a specific database table. 

Table NameDescriptionFunctional Domain
AAM_LAYOUTS

ACC_LOGINSESSIONLogin sessions for Adonis Control Center
AIS_TMMASTER
Adonis Integration Service
AUDIT_MRL_MEMBERSSee table name below for description.  AUDIT_<tableName>Audit table
AUDIT_PW001OLEDOCSSee table name below for description.  AUDIT_<tableName>Audit table
AUDIT_PW001P01See table name below for description.  AUDIT_<tableName>Audit table
AUDIT_PW001P03See table name below for description.  AUDIT_<tableName>Audit table
AUDIT_PW001P03ASee table name below for description.  AUDIT_<tableName>Audit table
AUDIT_PW001P03TCSee table name below for description.  AUDIT_<tableName>Audit table
AUDIT_PW001P04See table name below for description.  AUDIT_<tableName>Audit table
AUDIT_PW001P05See table name below for description.  AUDIT_<tableName>Audit table
AUDIT_PW001P06See table name below for description.  AUDIT_<tableName>Audit table
AUDIT_PW001P0CSee table name below for description.  AUDIT_<tableName>Audit table
AUDIT_PW001P0MSee table name below for description.  AUDIT_<tableName>Audit table
AUDIT_PW001P0PSee table name below for description.  AUDIT_<tableName>Audit table
AUDIT_PW001P0YSee table name below for description.  AUDIT_<tableName>Audit table
AUDIT_PW001P1RSee table name below for description.  AUDIT_<tableName>Audit table
AUDIT_PW001PAYSee table name below for description.  AUDIT_<tableName>Audit table
AUDIT_PW001PYHSee table name below for description.  AUDIT_<tableName>Audit table
AUDIT_PW001U01See table name below for description.  AUDIT_<tableName>Audit table
AUDIT_PW001U02See table name below for description.  AUDIT_<tableName>Audit table
AUDIT_PWCCMCHANGECREWLISTSee table name below for description.  AUDIT_<tableName>Audit table
AUDIT_PWCCMCHANGEPOSPROMLISTSee table name below for description.  AUDIT_<tableName>Audit table
AUDIT_PWCCMFLIGHTARRANGEMENTSSee table name below for description.  AUDIT_<tableName>Audit table
AUDIT_PWLEAVEACCPROPSee table name below for description.  AUDIT_<tableName>Audit table
AUDIT_PWORGSee table name below for description.  AUDIT_<tableName>Audit table
AUDIT_PWORGCMPSee table name below for description.  AUDIT_<tableName>Audit table
AUDIT_PWORGCMP_NETS_ACCOUNTSSee table name below for description.  AUDIT_<tableName>Audit table
AUDIT_PWORGDEPSee table name below for description.  AUDIT_<tableName>Audit table
AUDIT_PWORGPOSSee table name below for description.  AUDIT_<tableName>Audit table
AUDIT_PWORGRATSee table name below for description.  AUDIT_<tableName>Audit table
AUDIT_PWORGVESSee table name below for description.  AUDIT_<tableName>Audit table
AUDIT_PWPSC000See table name below for description.  AUDIT_<tableName>Audit table
AUDIT_PWPSC000_RATESSee table name below for description.  AUDIT_<tableName>Audit table
AUDIT_PWPSC001See table name below for description.  AUDIT_<tableName>Audit table
AUDIT_PWPSC001_RATESSee table name below for description.  AUDIT_<tableName>Audit table
AUDIT_PWROT_ACTIVE_SHIFTSee table name below for description.  AUDIT_<tableName>Audit table
AUDIT_PWROT_SHIFT_ACTIVITIESSee table name below for description.  AUDIT_<tableName>Audit table
AUDIT_PWSECURITY_FIELD_RIGHTSSee table name below for description.  AUDIT_<tableName>Audit table
AUDIT_PWSECURITY_GCT_RIGHTSSee table name below for description.  AUDIT_<tableName>Audit table
AUDIT_PWSECURITY_ORGANISATION_RIGHTSSee table name below for description.  AUDIT_<tableName>Audit table
AUDIT_PWSECURITY_PAYSCALE_RIGHTSSee table name below for description.  AUDIT_<tableName>Audit table
AUDIT_PWSECURITY_REPORT_RIGHTSSee table name below for description.  AUDIT_<tableName>Audit table
AUDIT_PWSECURITY_ROUTINE_RIGHTSSee table name below for description.  AUDIT_<tableName>Audit table
AUDIT_PWSECURITY_USERSSee table name below for description.  AUDIT_<tableName>Audit table
AUDIT_PYASC001See table name below for description.  AUDIT_<tableName>Audit table
AUDIT_WEB_CP_TIMECARDSee table name below for description.  AUDIT_<tableName>Audit table
D2D_ASSIGN_STATUSDay-2-Day Assignment statusesAPP > Day to Day module
D2D_ASSIGNMENTDay-2-Day assignmentsAPP > Day to Day module
D2D_CATEGORY_GROUPSDay-2-Day categoriesAPP > Day to Day module
D2D_CATEGORY_PINDay-2-Day pins in categoriesAPP > Day to Day module
D2D_CATEGORY_TYPESDay-2-Day category typeAPP > Day to Day module
D2D_CUSTOM_FILTERDay-2-Day custom filter with regexAPP > Day to Day module
D2D_DEF_NATGROUPDay-2-Day groups per nationalitiesAPP > Day to Day module
D2D_DEF_SEASONDay-2-Day season definitionsAPP > Day to Day module
D2D_FIXED_CREW_RANKSDay-2-Day ranks for categoriesAPP > Day to Day module
D2D_FORECASTDay-2-Day forecastAPP > Day to Day module
D2D_P03HISTORICALDay-2-Day retrospective for assignmentsAPP > Day to Day module
D2D_PAX_CREWREQDay-2-Day crew required by pax rangeAPP > Day to Day module
D2D_PAXMIXDay-2-Day age ranges definitionAPP > Day to Day module
D2D_PAXSEGDay-2-Day segment definitionAPP > Day to Day module
D2D_PAXTTYPEDay-2-Day ticket type definitionAPP > Day to Day module
D2D_RANK_CATEGORYDay-2-Day rank and department definition for categoryAPP > Day to Day module
D2D_WEIGHT_PAXMIXDay-2-Day weight for age rangesAPP > Day to Day module
D2D_WEIGHT_PAXNATDay-2-Day weight for nationalityAPP > Day to Day module
D2D_WEIGHT_PAXSEGDay-2-Day weight for segmentAPP > Day to Day module
D2D_WEIGHT_PAXTTYPEDay-2-Day weight for ticket typeAPP > Day to Day module
MRL_InstructionsCSB_Instructionsfor CrewStation Bill
MRL_MembersCSB_Preffered assignementfor CrewStation Bill
MRL_PREF_ASSIGNMENTCSB_Preffered_Assignementsfor CrewStation Bill
MRL_Req_CertificationCSB_Station_required certificatesfor CrewStation Bill
MRL_Req_InstructionsCSB_Station_Instructionsfor CrewStation Bill
MRL_Req_MedicalCSB_Station_required_medicalfor CrewStation Bill
MRL_TemplateCSB_Muster_templatefor CrewStation Bill
MRL_TPL_STATIONSCSB_Muster_ template _stationsfor CrewStation Bill
MRLS_DUTIESCSB_Station_Dutiesfor CrewStation Bill
MRLS_SAFETY_LEVELSCSB_Safety_Levelsfor CrewStation Bill
MRLS_SEC_ASSIGNMENTCSB_Secondary_Assignmentsfor CrewStation Bill
MRLS_STATION_HEADERCSB_Station_Headersfor CrewStation Bill
PROJECT_ABSENCEObsoleteAPP > Project timesheet module
PROJECT_ABSENCE_TYPEObsoleteAPP > Project timesheet module
PROJECT_EXPENSEObsoleteAPP > Project timesheet module
PROJECT_EXPENSE_TYPEObsoleteAPP > Project timesheet module
PROJECT_LOCATIONObsoleteAPP > Project timesheet module
PROJECT_PERIODSObsoleteAPP > Project timesheet module
PROJECT_REGISTRATIONObsoleteAPP > Project timesheet module
PROJECT_TASK_TYPEObsoleteAPP > Project timesheet module
PROJECT_TIMESHEETObsoleteAPP > Project timesheet module
PW_CREW_ACCESS_LEVELpin reference for Orgstructure access codesAccess Level module
PW_CREW_ACCESS_LEVEL_DETAILSBlocked flag for pinAccess Level module
PW_CREWCARDplastic cards info
PW_CREWCARD_CABINACCESSplastic cards info
PW_INTERFACEHR_P01

PW001BFNOTES

PW001BKPBackPayPayroll
PW001C000_XREFGeneral codes cross-reference
PW001C00CP

PW001C01Customized datagroup definition
PW001C02RanksGeneral Codes
PW001C03DepartmentsGeneral Codes
PW001C04Marital StatusGeneral Codes
PW001C05ColorGeneral Codes
PW001C06CompetencesGeneral Codes
PW001C06RCompeteces replacementGeneral Codes
PW001C07Family Relation codesGeneral Codes
PW001C08LifeboatsGeneral Codes
PW001C09OLDObsoleteGeneral Codes
PW001C0ACustomized datagroup column definitionGeneral Codes
PW001C10FirestationGeneral Codes
PW001C100Travel AdminsGeneral Codes
PW001C101Cost CenterGeneral Codes
PW001C102CalendarsGeneral Codes
PW001C102_HOLIDAYSCalendar holidaysGeneral Codes
PW001C103CostsGeneral Codes
PW001C104Plan Type General Codes
PW001C105Plan General Codes
PW001C106Employment statusGeneral Codes
PW001C107Custom exportsGeneral Codes
PW001C108Appraisals viewGeneral Codes
PW001C109Replication RouteGeneral Codes
PW001C109_VESReplication Route viewsGeneral Codes
PW001C11Adonis Query - Selection FieldsGeneral Codes
PW001C110Replication Routines ViewGeneral Codes
PW001C111IBAN CountriesGeneral Codes
PW001C112InterfacesGeneral Codes
PW001C113Clearing System identificationGeneral Codes
PW001C114Annual Summary code definition headersGeneral Codes
PW001C115RegulatoryGeneral Codes
PW001C116Cancellation Reasons General Codes
PW001C117Entrycode categoriesPayroll
PW001C118Levels of UrgencyGeneral Codes
PW001C119Start Page datasourceGeneral Codes
PW001C12Activity codesGeneral Codes
PW001C120Access LevelGeneral Codes
PW001C12ALeave Factors of Leave Days accumulators for Activity codesGeneral Codes
PW001C13Appraisal marksGeneral Codes
PW001C14Appraisal questionsGeneral Codes
PW001C15CurrenciesGeneral Codes
PW001C15ECurrencies historicalGeneral Codes
PW001C16Activity viewsGeneral Codes
PW001C17Competence viewsGeneral Codes
PW001C18Travel viewsGeneral Codes
PW001C19Activities categoryGeneral Codes
PW001C20Manning agent codeGeneral Codes
PW001C21Union codeGeneral Codes
PW001C22Person Cost GroupsGeneral Codes
PW001C23Travel DocumentsGeneral Codes
PW001C24Medical codesGeneral Codes
PW001C25Allotment codesGeneral Codes
PW001C26BanksGeneral Codes
PW001C27Leave Days accumulatorsGeneral Codes
PW001C28Customized fieldsGeneral Codes
PW001C29Vessel TypeGeneral Codes
PW001C30Engine typeGeneral Codes
PW001C31Radio typeGeneral Codes
PW001C32Contract typeGeneral Codes
PW001C33Person CategoryGeneral Codes
PW001C34Vessel registerGeneral Codes
PW001C35Vessel cost groupGeneral Codes
PW001C36Rotation plansGeneral Codes
PW001C36PRotation shift periodsGeneral Codes
PW001C36SRotation shift defintionGeneral Codes
PW001C36STRotation shift time periodsGeneral Codes
PW001C36TRotation time periodsGeneral Codes
PW001C37Appraisals input viewsGeneral Codes
PW001C38Payroll statusGeneral Codes
PW001C39Payroll typeGeneral Codes
PW001C40Crew poolGeneral Codes
PW001C41Appraisals test siteGeneral Codes
PW001C42ProjectGeneral Codes
PW001C43Person cost placeGeneral Codes
PW001C44Vessel locationGeneral Codes
PW001C45OLE doc typesGeneral Codes
PW001C46Pension fund classGeneral Codes
PW001C47Port typesGeneral Codes
PW001C48AirportsGeneral Codes
PW001C49Holiday groupsGeneral Codes
PW001C50Not in useGeneral Codes
PW001C51Not in useGeneral Codes
PW001C52CabinGeneral Codes
PW001C53Vessel activityGeneral Codes
PW001C54Vessel categoryGeneral Codes
PW001C55Deactivation reasonGeneral Codes
PW001C56Rank catergoryGeneral Codes
PW001C57Requisition typeGeneral Codes
PW001C58Terms of paymentGeneral Codes
PW001C59VAT ratesGeneral Codes
PW001C60Requisition typeGeneral Codes
PW001C61Timecard WorktypesGeneral Codes
PW001C62Body affected codes for medical insuranceGeneral Codes
PW001C63Status codes for medical insuranceGeneral Codes
PW001C64Incident type codes for medical insuranceGeneral Codes
PW001C65Classification codes for medical insuranceGeneral Codes
PW001C66Candidates status codes for medical insuranceGeneral Codes
PW001C67Family viewsGeneral Codes
PW001C68Medical viewsGeneral Codes
PW001C69Medical Insurance viewsGeneral Codes
PW001C70Requisition codesGeneral Codes
PW001C71Customized report groupsGeneral Codes
PW001C72Customized topics viewsGeneral Codes
PW001C73Contact typesGeneral Codes
PW001C74Dynamic Positioning systemGeneral Codes
PW001C75OLE doc viewsGeneral Codes
PW001C76Club codes for medical insuranceGeneral Codes
PW001C77Incident views for medical insuranceGeneral Codes
PW001C78Crew List viewsGeneral Codes
PW001C79Embarking/Diseambarking reasonsGeneral Codes
PW001C80Rotation Plan codesGeneral Codes
PW001C81Rotation Plan viewsGeneral Codes
PW001C82ReligionGeneral Codes
PW001C83Customized Fiields viewsGeneral Codes
PW001C84Crew Effects codesGeneral Codes
PW001C85Crew Effects viewsGeneral Codes
PW001C86MeasurementsGeneral Codes
PW001C87Position Seniority category
PW001C88Data mining codes
PW001C89Data mining views
PW001C90Airlines
PW001C91Claim codes for medical insurance
PW001C92Legal Statгs for medical insurance
PW001C94Vessel Size
PW001C95Muster Roll Teams
PW001C96Crew List view groups
PW001C97Lifeboats/Rafts Position
PW001C98Muster Roll Safety Levels
PW001C99Cabin Allocation Watch
PW001C123Personal Rates Codes (Contracts Datagroup)
PW001DOCLINKKeywords for documents
PW001DUVDynamic selections
PW001MEMOSQL Statements for merge
PW001OLEDOCSOLE Documents
PW001OLEDOCS_BKMARKSBookmarks for Merge documents
PW001OLEKEYWORDSKeywords for OLE documents
PW001P01Personal Details
PW001P01_EDAG_Arbeidsforhold

PW001P01_EDAG_permisjon

PW001P01_LEAVEACC_LINKLeave Accumulators M-M link table
PW001P01_NO_RPT

PW001P01_REPL_ROUTEPerson's replication routes
PW001P01_XREFPerson's cross-references
PW001P01BANKACCHISTPersonal history on bank account details
PW001P01BASKETDocuments in Basket
PW001P01HIST<not in use>
PW001P01OLEPerson & OLE relation
PW001P01PICTPerson's link for picture from OLE documents
PW001P01SFAMFamiliy members that are defined in PW001P01 so that they can be signed on to a vessel as a normal seafarer
PW001P01SNPerson's Sticky Notes
PW001P01TRAVELTravel information for the person
PW001P02Customized datagroup values
PW001P03Activities
PW001P03AActivity leave accumulators reference
PW001P03REQUESTActivity Requests
PW001P03TCActivity timecards
PW001P03W

PW001P04Appraisals records
PW001P05Competence documents
PW001P06NOK
PW001P06SSNIdentification numbers for NOK
PW001P07Medical documents
PW001P08Travel Documents
PW001P09Alltotments
PW001P0CPersonal payroll accumulators
PW001P0K<not in use>
PW001P0LLife Insurance
PW001P0MAppraisals marks
PW001P0NPersonal notes
PW001P0PRank, Employment & Payscale
PW001P0RPersonal relations between persons
PW001P0S_PAYSCALECODE

PW001P0Ttelecommunication details
PW001P0TTtelecommunication types
PW001P0UCustomized fields values
PW001P0VPersonal vessel-specific info
PW001P0W<not in use> Wage information. ( Not used any more, Payscale used instead)
PW001P0YPerson's payroll info
PW001P0Y_BK_OLDBANKCODE

PW001P0Y_HISTPerson's payroll info history
PW001P0Y_USW4

PW001P0YTAXCARD

PW001P10Person's documents
PW001P11Medical insurance incidents
PW001P11CMedical Insurance claims
PW001P11OLD

PW001P11VMedical Insurance vouchers
PW001P11VOLD

PW001P15Crew Effects
PW001P16

PW001P16B

PW001P20Contracts Datagroup
PW001P20RPersonal Rates (Contracts Datagroup)
PW001P20UContracts Customized Fields
PW001P1POLD

PW001P1RPersonal Rates
PW001P2PProvident Fund
PW001PAIPayroll Additional Info
PW001PAI_BK_OLDBANKCODE

PW001PAYList of payroll transaction for current period
PW001PAY_BANKRECEIPT

PW001POSDOCPosition Required Documents
PW001POSDOC_FLAGPosition Required Documents by Flag
PW001POSDOC_LINK

PW001POSDOC_PRINCIPALPosition Required Documents by Principal
PW001POSDOC_VESSELPosition Required Documents by Principal
PW001POSDOC_VSLTYPEPosition Required Documents by vessel Type
PW001PROMHISTPromotion history
PW001PROMRANKDOCDocuments for promotion
PW001PT6Telecommunication for Next of Kin
PW001PYHPayroll transactions historical
PW001PYMPayroll Message
PW001RIDReport Input values from the latest time the report was run
PW001U0XCustomized datagroup(s)
PWACMACCOUNTOnboard Accounting Module - Accounts
PWACMANALYTICSOnboard Accounting Module - Account Analyical Data
PWACMBALANCEOnboard Accounting Module - Accounts Balance
PWACMOPERATIONOnboard Accounting Module - Account Accounting Operations
PWACMPERIODOnboard Accounting Module - Accounting Periodes
PWACMTRANSACTIONLOGOnboard Accounting Module - Trabnsactions
PWAIRPORTAirport records
PWAIRPORTCONTACTSAirportcontacts records
PWAIRPORTDOCSAirportdocs records
PWAPMCREWMAPPINGApmcrewmapping records
PWAPMCREWMAPPINGLOGApmcrewmappinglog records
PWBFBOOKNOBfbookno records
PWBFCONDITION_CHANGED

PWBUDGET_VSL_NAT_DETAILSBudget Module by Vessel Nationality -Details
PWBUDGET_VSL_NAT_HEADERBudget Module by Vessel Nationality -Headers
PWCCMACTDEFActivity Information for Crew Change
PWCCMAGENTARRANGEMENTSAgent arrangementsCrew change module
PWCCMAIRSEGMENTSFlight segmentsCrew change module
PWCCMCHANGECREWLISTlist of crew in Calling Port crewchangesCrew change module
PWCCMCHANGEPLNPOSLISTCrew Change Module - SignOn - Position ListCrew change module
PWCCMCHANGEPOSPROMLISTlist of crew in Calling Port promotion recordsCrew change module
PWCCMFLIGHTARRANGEMENTSFlight bookingsCrew change module
pwccmflightbooklogFlight bookings logCrew change module
PWCCMFLIGHTBOOKSTATUSLOGLog of booking statusesCrew change module
PWCITYCities in post register
PWCMPHOLIDAYSHolidays setup on Company level
PWCMPPAYPayroll settings on Company level
PWCONTINENTContinents in post register
PWCOUNCILConcil Information
PWCOUNTRYCountries in post register
PWCOUNTRYPROP

PWCOUNTYCounties & states in post register
PWCREWLINKREFERENCESReferences for ATPI Crewlink
PWCREWLINKREFERENCESDATA

PWCTCCCTContact type codes
PWCTCCMPCompany contact information
PWCTCPCMPersonal telecom details for Contact persons
PWCTCPERContact persons
PWCTCTLCTelecom details for Contact of Companies
PWDBUPGRADE

PWDBVERSIONLog 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

PWEDAGDEFDefenitions EDAG codes for EDAG functionality
PWEDAGReporter

PWEDAGYRKESKODE

PWEUREKABUGREPORTLOG

PWEXPORT_SETTINGSUser settings for various export tools
PWFIELDOPTIONS

PWIMPORTBOOKINGLOG

PWIMPORTWRLOG

PWINDKOMSTCODE

PWINTERFACESENDRECVDLOG

PWINTERFACETASK

PWINTERFACETRACKCHANGES

PWINVOICEInvoices
PWINVOICELINEInvoicelines
PWLANGUAGE

PWLEAVEACCPROPSetting for Leave Accumulators
PWLMSTRACKCHANGES

PWLOG_PAYROLL_EXECPayroll execution log
PWLOG_PAYROLL_REPORTSLog for Payroll reports generation
PWLOGEDAG

PWLOGEXPORTIMPORTLog of Export / import tools
PWLOGINNTEKTSMELDING

PWLOGINSESSIONLog of operational sessions of APM users
PWMODULESAPM Modules (not in use)
PWORGOrganization structure tree
PWORG_ACCESS_LEVELAccess Level setup on Organization structure level
PWORG_XREFCross references for Org.structure
PWORGCMPCompany level properties for Org.structure
PWORGCMP_ALLOTMENTCompany allotment settings for Org.structure
PWORGCMP_ALLOTMENT_DETAILSCompany allotment setting details for Org.structure
PWORGCMP_COMPENSATIONCompensation settings for Udligninsgskontorer export on company level
PWORGCMP_DAN_PENSIONCompany settings for Dannish pension reporting
PWORGCMP_DAN_VOLPENSIONCompany settings for voluntary Dannish pension reporting
PWORGCMP_FNO_ADDITIONAL_WAGESSettings of FNO Export
PWORGCMP_FNO_AVTALEFESTET_PENSJONSettings of FNO Export
PWORGCMP_FNO_HOURLY_WAGESSettings of FNO Export
PWORGCMP_LEAVEACC_LINKOrganization Company Leave Accumlators link table
PWORGCMP_NETS_ACCOUNTSCompany net accounts properties for Org Structure
PWORGCMP_PFA_CORPENSIONCompany PFA Export settings for Org Structure 
PWORGCMP_PFA_MPLEAVECompany PFA Export settings for Org Structure 
PWORGCMP_PFA_PENSIONCompany PFA Export settings for Org Structure 
PWORGCMP_PFA_VOLPENSIONCompany PFA Export settings for Org Structure 
PWORGCMP_TRAVEL_EXPENSESCompany Settings for Travel Expense processing
PWORGCMP_TRAVEL_EXPENSES_DETAILSTransaction details for Travel Expense processing
PWORGCMPBALANCESCompany filter of available balance actions for Payroll - Payment tab
PWORGCONConcern info
PWORGCTCCompany contacts from Contacts module
PWORGDEPDepartment level properties for Org.structure
PWORGGCDGeneral codes fields availability setup on Company level
PWORGOBJOLE documents setup on Company level
PWORGPOSPosition level properties for Org.structure
PWORGPOS_SAFETY_LVL_MANNINGPositions safety manning setup
PWORGPRCActivated requirements from Position Requirements Profile per Org.level
PWORGPRSSea-service requirements for positions
PWORGPSCOrganization payscales
PWORGRATOrganization rates
PWORGRTDRequired Travel documents per organization
PWORGTELTelecom info on Organization level
PWORGVESVessel level properties for Org.structure
PWORGVES_DeckDeck settings for vessel
PWORGVES_ManningCrew Manning settings for vessel
PWORGVES_Manning_PsnPosition Manning settings for vessel
PWORGVES_PAYSCALEAvailability for payscales setup on Vessel level
PWORGVES_StationsRescue Stations setup on vessel level
PWORGVES_VOYAGEVessel Voyages
PWORGVES_ZoneRescue Zones setup on vessel level
PWORGVESACTCalling Ports per vessel
PWORGVESCABVessel cabin allocation
PWORGVESCABOLEOLE documents for cabin allocation
PWORGVESFSFirestations setup on vessel level
PWORGVESFSOLEOLE documents for fire stations
PWORGVESLBLifeboats & rafts setup on vessel level
PWORGVESLBOLEOLE documents for lifeboats
PWORGVESOPHVessel owner/principal history
PWORGVIRVirtual organization properties for Org.structure
PWPLANNERDATAPlanner Module - Data
PWPLANNERRESPlanner Module - Resources
PWPLANNERTODOPlanner Module - ToDo items
PWPLNTURNNot In use
PWPLUGINSPlugins List
PWPORTPorts module records
PWPORTCONTACTSPort contacts
PWPORTDOCSPort documents
PWPORTREPList of reports required in that port
PWPORTRTDTravel documents required per calling port
PWPOSTzip codes register
PWPRJ_CERTIFICATESProject Required Certificates
PWPRJ_MEDICALCERTProject Required Medical Documents
PWPRJ_POSITION_REQProject Positiion Requirements
PWPRJ_POSITIONSProject Required Positions
PWPRJ_TRAVELDOCSProject Required Travel Documents
PWPROJP01Links between persons and projects
PWPROJVESVessel Projects
PWPSC_RATES_COLUMNSPayscale rates columns setup
PWPSC_RATES_LINESPayscale rates lines setup
PWPSC000Payscale Table general properties
PWPSC000_LEAVEACC_LINKPayscale Table Leave accumulator properties
PWPSC000_RATESPayscale Table rates setup
PWPSC000_TAAPayscale Table setup for Time & Attendance module
PWPSC000APPRAISALPayscale Table appraisals setup
PWPSC000HOURS

PWPSC000INTERVAL

PWPSC000TIME

PWPSC000WORKTYPEMAP

PWPSC001Payscale Code general properties
PWPSC001_LEAVEACC_LINKPayscale Code Leave accumulator properties
PWPSC001_RATESPayscale Code rates setup
PWPSC001_TAAPayscale Code setup for Time & Attendance module
PWPSC001HOURS

PWPSC001INTERVAL

PWPSC001RANK

PWPSC001TIME

PWRefusionReportInput

PWRGM_EMAIL_REPORT_TASK_PINSPins affected by active Email Report tasks
PWRGM_EMAIL_REPORT_TASKSActive Email Report tasks
PWRGM_EMAIL_REPORTSDefinition of Email Reports
PWRGREPORTSReports from Report Generator module, properties & .fr files
PWRIMREQDRequisition details
PWRIMREQMRequisition
PWRIMREQQLF

PWRIMREQSD

PWROT_ACTIVE_SHIFTRotation plan maitenance data -actual shifts
PWROT_DETAILSRotation plan Details
PWROT_HDR_VSLSRotation Header vessels
PWROT_HEADERSRotation Headers - (Rotation Plans list)
PWROT_POS_COMMENTSRotation plan position comemnts
PWROT_POS_ROT_SHIFTRotation plan position shifts definition
PWROT_SHIFT_ACTIVITIESLinks between Rotation plan actual shifts & activities
PWROUTEPORTPort in sailing route
PWSAILINGPLANA vessels sailing plan
PWSALEITEMSaleitems for invoicing
PWSCRIPTSPayroll scripts
PWSCRIPTS_HISTORYPayroll scripts history of modifications
PWSEAROUTEA sea route
PWSECURITY_DOCS

PWSECURITY_FIELD_GROUPSAccess Rights for fields groups setupAdonis Control Centre 
PWSECURITY_FIELD_RIGHTSAccess Rights for fields setupAdonis Control Centre 
PWSECURITY_FIELDSFields list under access controlAdonis Control Centre 
PWSECURITY_GCT_RIGHTSAccess Rights for general code setupAdonis Control Centre 
PWSECURITY_LEVELSOrgunits under access controlAdonis Control Centre 
PWSECURITY_ORGANISATION_RIGHTSAccess Rights for Orgunits setupAdonis Control Centre 
PWSECURITY_PAYSCALE_RIGHTSAccess Rights for Payscales setupAdonis Control Centre 
PWSECURITY_PLUGINS_RIGHTSAccess Rights for Plugins setupAdonis Control Centre 
PWSECURITY_REPORT_GROUPSAccess Rights for Reports groups setupAdonis Control Centre 
PWSECURITY_REPORT_RIGHTSAccess Rights for Reports setupAdonis Control Centre 
PWSECURITY_REPORTSReports list under security controlAdonis Control Centre 
PWSECURITY_ROUTINE_GROUPSAccess Rights for security routines groups setupAdonis Control Centre 
PWSECURITY_ROUTINE_RIGHTSAccess Rights for security routines setupAdonis Control Centre 
PWSECURITY_ROUTINESRoutines list under security controlAdonis Control Centre 
PWSECURITY_USERSUsers list under access controlAdonis Control Centre 
PWSEQSequence counter control
PWSETTINGSGlobal Settings
PWTELEPAYDIR

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

PWTRAVELPACKTravel packs
PWTRAVELPACKAGENTSAgents (from contact register) linked to travel packs
PWTRN_COURSE_SCHEDULESDefinition of schedules for Course Scheduler module
PWTRN_COURSE_SCHEDULES_BOAT_FROMCourse Module Vessels
PWTRN_COURSE_SCHEDULES_OLEDOCSCourse Module - Certificates Scans
PWTRN_COURSESDefinition of cources for Course Scheduler module
PWTRN_CRS_SCHEDULE_P01List of enrolled participants on coure for Course Scheduler module
PWTRN_CRSTYPES_C06Definition of certificates for Course Scheduler module
PWTRN_INSTRUCTORSList of assigned instructors to drills for Course Scheduler module
PWTRN_SCHEDULEP01_P05List of issued cerificates for Course Scheduler module
PWTRN_SUPPLIERSDefenition of suppliers and vessels(drills) for Course Scheduler module
PWUSERCSLLAYOUTCrew List Layouts
PWUSERLASTVALUEStores the last values used by each user in inputforms, etc.
PWUSERSETTINGSUser Options
PWVESCOSTPLACEVessel Cost PlacePWPSC000HOURMAP
PWWIZARDWizards
PWWIZFIELDWizard fields
PWWIZLASTVALLast input values used in the wizard
PWWIZPAGEWizard Page
PY001ACCAccounts for accounting
PY001ASIAnnual Summary information for per
PYASC001Annual Summary Code information for an Entry Code
PYASCDEFAnnual Summary Code definition
PYETY001Entrycode properties
PYETY001_COMMENTSEntrycode comments
PYETY001ADPEntry Code settings for ADP Export
PYETY001INPUTFIELDSEntryCode input fields
PYETY001RSM

PYETY001TXTEntry Code text
repl_ChannelChannel propertiesReplication properties
repl_Channel_LogChannels logReplication properties
repl_Channel_Task_LogTask logReplication properties
REPL_CUSTOMIZED_TOPICS
Replication properties
repl_Deleted
Replication properties
REPL_DELETED_LOG
Replication properties
repl_DirectionTypeDirection Type setupReplication properties
repl_DirectionType_ChannelChannel setupReplication properties
repl_DirectionType_TaskDirection Type tasksReplication properties
repl_Files
Replication properties
repl_ProgramsApplications which are updated via ReplicatorReplication properties
repl_ProgramStateUpdate results of programs via Replicator on each siteReplication properties
repl_RowId
Replication properties
repl_Schedule
Replication properties
repl_SiteList of all sites Replication properties
repl_TaskList of replication tasksReplication properties
repl_TaskTypeReplication task typesReplication properties
repl_UpdateParametersParameters which are used for program update process via ReplicatorReplication properties
REPL_VERSIONLog of Replicator version upgrades
SPM_FIELDSStart Page Module - List of Fields
SPM_FRAMESStart Page Module - List of Frames
SPM_TILESStart Page Module - List of Tiles
SPM_TILES_USERStart Page Module - User settings
VRP_DOC_PRINCIPAL_LINKRequiremenst Profile - principal Link
VRP_DOC_PRNCIPALRequiremenst Profile - principals
VRP_DOC_VESSELRequiremenst Profile - vessels 
VRP_DOC_VESSEL_LINKRequiremenst Profile - vessel link
VRP_DOC_VESSELTYPERequiremenst Profile - vessel types
VRP_DOC_VESSELTYPE_LINKRequiremenst Profile - vessel type link
VRP_EXP_PRINCIPAL_LINKRequiremenst Profile - experience principal link
VRP_EXP_PRNCIPALRequiremenst Profile - experience principals
VRP_REQ_DOCUMENTRequiremenst Profile - required documents
VRP_REQ_DOCUMENT_LVLQTYrequired levels qty
VRP_REQ_EXPERIENCERequiremenst Profile - Experience
WEB_CP_ACCOMMODATIONAccomodationAPP > Travel Expense module
WEB_CP_ACCOMMODATION_TYPEAccomodation typeAPP > Travel Expense module
WEB_CP_ACCOUNTUsersAPP
WEB_CP_ACCOUNT_STATUSAccount statuses APP
WEB_CP_ADMINAdminsAPP
WEB_CP_ALLOWANCE_RATEAllowance rateAPP > Travel Expense module
WEB_CP_API_LOGINAPI logins APP
WEB_CP_BATCH_ACCESS_POSITIONBatch access for TAAAPP > Time and Attendance module
WEB_CP_COA_APPROVER_VESSELSApprover vesselsAPP > Chain of Approval
WEB_CP_COA_CHAINChainAPP > Chain of Approval
WEB_CP_COA_TreeCoA treeAPP > Chain of Approval
WEB_CP_COA_Tree_Approvers_NodesApprovers nodesAPP > Chain of Approval
WEB_CP_COA_Tree_NodesTree nodesAPP > Chain of Approval
WEB_CP_COA2_NODE_DETAILSNode detailsAPP > Chain of Approval
WEB_CP_COA2_TREECoA treeAPP > Chain of Approval
WEB_CP_COUNTRY_ALLOWANCECountry allowanceAPP > Travel Expense module
WEB_CP_DBVERSIONVersionsAPP
WEB_CP_DOCUMENT_TYPEDocument typesAPP > Chain of Approval
WEB_CP_DOCUMENTSDocumentsAPP > Chain of Approval
WEB_CP_ELEMENTSElementsAPP > Access Rights
WEB_CP_EMAIL_SERVERSMTP server settingsAPP
WEB_CP_ESIGNDocuments descriptionAPP > Electronic signing module
WEB_CP_ESIGN_CERTIFICATEAdonis X509CertificateAPP > Electronic signing module
WEB_CP_ESIGN_DOCUMENTDocumentsAPP > Electronic signing module
WEB_CP_GANGWAY_ACTIONSActionsAPP > Gangway Web Service
WEB_CP_GANGWAY_REGISTRYRegistrationsAPP > Gangway Web Service
WEB_CP_LAYOUT_SETTINGSLayout customizationAPP
WEB_CP_LOCATIONSPanel PC locationAPP > Time and Attendance module
WEB_CP_MESSAGEMessagesAPP > Messages
WEB_CP_MESSAGE_FOLDERInbox / outbox message indicationAPP > Messages
WEB_CP_MESSAGE_FOLDER_PROFILEFolder names for messagesAPP > Messages
WEB_CP_MODULES_USERTYPESElements definition for module typesAPP > Access Rights
WEB_CP_NOTIFICATION_EMAILSEmailsAPP > Notification Service
WEB_CP_NOTIFICATION_TASKSTasksAPP > Notification Service
WEB_CP_NOTIFICATION_TASKS_LOGLogAPP > Notification Service
WEB_CP_ORGANIZATION_RANKSDefine ranks for UsergroupAPP > Access Rights
WEB_CP_PAYROLL_OUTLAY_TYPEConfiguration outlay typeAPP > Travel Expense module
WEB_CP_RELIEVERReliversAPP > Time and Attendance module
WEB_CP_REPORT_MODULESObsolete tableAPP > Reports
WEB_CP_REPORT_SETTINGSSettingsAPP > Reports
WEB_CP_REPORT_USERGROUPSUsergroupsAPP > Reports
WEB_CP_REPORTS_MODULESModulesAPP > Reports
WEB_CP_ROLE_ACCESSRole accessAPP > Access Rights
WEB_CP_ROLESRolesAPP > Access Rights
WEB_CP_ROSTER_LOCATIONLocationsAPP > Roster Planning module
WEB_CP_ROSTER_POSITIONPositionsAPP > Roster Planning module
WEB_CP_ROSTER_WATCHWatchAPP > Roster Planning module
WEB_CP_ROSTER_WATCH_ASSIGNEDAssigned for watchAPP > Roster Planning module
WEB_CP_ROSTER_WATCH_TIMEWatch timeAPP > Roster Planning module
WEB_CP_ROSTER_WATCH_TIME_ASSIGNEDAssigned for watch timeAPP > Roster Planning module
WEB_CP_SETTELMENT_SUMMARYSettelment summaryAPP > Travel Expense module
WEB_CP_SETTINGS2SettingsAPP
WEB_CP_SETTLEMENT_TYPESettelment typeAPP > Travel Expense module
WEB_CP_SUBTEAMSubteamAPP > Time and Attendance module
WEB_CP_SUBTEAM_MEMBERSSubteam membersAPP > Time and Attendance module
WEB_CP_TAA_MODULESTAA modulesAPP > Time and Attendance module
WEB_CP_TE_SETTINGSTE settingsAPP > Travel Expense module
WEB_CP_TIMECARDTime registrationsAPP > Time and Attendance module
WEB_CP_TIMECARD_ACCEPT_VIOLAccept violationsAPP > Time and Attendance module
WEB_CP_TIMECARD_BATCH_TEMPLATEBatch templateAPP > Time and Attendance module
WEB_CP_TIMECARD_BATCH_TEMPLATE_DEFINITIONBatch template definitionAPP > Time and Attendance module
WEB_CP_TIMECARD_DAILY_DETAILSTimecars daily detailsAPP > Time and Attendance module
WEB_CP_TIMECARD_PENDINGPending time registrationsAPP > Time and Attendance module
WEB_CP_TIMECLOCK_SETTINGSTimeclock settingsAPP > Time and Attendance module
WEB_CP_TIMECLOCKSTimeclock communicationsAPP > Time and Attendance module
WEB_CP_TIMESHEET_PLAN_DETAILSPlan DetailsAPP > Time and Attendance module
WEB_CP_TIMESHEET_PLANSTimesheet plansAPP > Time and Attendance module
WEB_CP_TIMESHEETSTimesheetsAPP > Time and Attendance module
WEB_CP_TIMESHEETS_PERIODTimesheet periodAPP > Time and Attendance module
WEB_CP_TIMEZONESTimezonesAPP
WEB_CP_TIMREG_ENTRIESEntriesAPP > Time and Attendance module
WEB_CP_TIMREG_TEMPLTemplate for time registrationAPP > Time and Attendance module
WEB_CP_TIMREG_TEMPL_ENTRIESEntries in templateAPP > Time and Attendance module
WEB_CP_TRANSPORTATION_TYPETransportation typeAPP > Travel Expense module
WEB_CP_TRAVEL_ACTIVITIESTravel activitiesAPP > Travel Expense module
WEB_CP_TRAVEL_BILLSTE documentsAPP > Travel Expense module
WEB_CP_TRAVEL_DEDACTIONSTravel dedactionsAPP > Travel Expense module
WEB_CP_TRAVEL_EXPENSE_SCANSExpense scansAPP > Travel Expense module
WEB_CP_TRAVEL_OUTLAYTravel outlayAPP > Travel Expense module
WEB_CP_TRAVEL_RATE_PERIODTravel reate periodAPP > Travel Expense module
WEB_CP_TRAVEL_REASONTravel reasonAPP > Travel Expense module
WEB_CP_TRAVEL_SPECIFICATIONTravel specificationAPP > Travel Expense module
WEB_CP_USER_SETTINGSUser settingsAPP
WEB_CP_USERGROUPUsergroupsAPP > Access Rights
WEB_CP_USERGROUP_ORGANIZATION_INHERITANCEOrganization inheritanceAPP > Access Rights
WEB_CP_USERGROUP_POSITIONUsergroup positionsAPP > Access Rights
WEB_CP_USERGROUP_ROLEUsergroup rolesAPP > Access Rights
WEB_CP_WATCHKEEPERSWatchkeepersAPP > Time and Attendance module
WEB_CP_WDA_EXPENSEExpenses APP > Work Days Accounting module
WEB_CP_WORKFLOWDocument states and stepsAPP > Chain of Approval
WEB_CP_WORKTYPESWorktypesAPP > Time and Attendance module

.

  • No labels