...
https://adonishr.atlassian.net/l/cp/DbHWCqi5
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 | ||
Location | 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 |
.