Title: SQL Statements  
Owner: Halvard Meijer
Creator: Halvard Meijer May 28, 2021
Last Changed by: Daria Chebotaieva Jun 20, 2023
Tiny Link: (useful for email) https://rippleops.atlassian.net/wiki/x/9YGkBAE
Export As: Word · PDF  
Hierarchy
Children (10)
    Page: Insert same rate lines into all Payscale Tables
    Page: Create a back-up of a selected table
    Page: CSB APP - Members
    Page: Update missing Description on Transportation Entry Code
    Page: Find people without department in the booking request
    Page: Insert Rank Name to Rank Code Xref (Crewlink Interface)
    Page: Requirement Profile Insert Statement
    Page: Script for updating "blank/null" activitiy payscale code and payscale table fetched from current contracts payscale code and payscale table.
    Page: Script for updating/inserting Xref for Vessels to the same value as the vessel name where interface code='CREWLINK'
    Page: Script for updating/inserting XREF for Rank CODES to the same value as the Rank CODE or NAME where interface code='CREWLINK'
Labels
Global Labels (1)
Permissions
Content restrictions:
  • Only users in group allstaff can edit this content. (set by Sigrid Kviteberg at Dec 01, 2022 14:03)
  • Only Daria Chebotaieva can edit this content. (set by Daria Chebotaieva at Nov 21, 2022 13:07)
  • Only Sigrid Kviteberg can edit this content. (set by Daria Chebotaieva at Nov 21, 2022 13:07)
  • Only Natalya Miroshnychenko can edit this content. (set by Daria Chebotaieva at Nov 21, 2022 13:07)