| Routines for COMPLEAT STATS Reports workflow | ||||||||
| Safe Harbors business unit | ||||||||
| Run Date: 17-May-2024 13:20 | ||||||||
| Communications process | ||||||||
| Routine Name | Description | |||||||
| TAR-Remove Old TAR Remarks | For TAR bookings, old 5H-TARAIR- and 5Y#TKTD- are removed so they are NOT resused | |||||||
| Communications-Address Override *Safe Harbors* | 68223-Override address for main street in 07JF | |||||||
| Air Segment FLIFO Details Parse (Apollo) | Operational code share carrier is NOT added correctly through XML, this displays the RTSVC, adds to a property and is then used in the AirSegment (Amadeus) parse routine. It will then display FLIFO for each segment. This is used to populate stops, meals etc | |||||||
| Communications-Email to Agent Only* | If the agency is in the data list, they want the itinerary sent to the agent only | |||||||
| Concur Agent Email Override on Header *Safe Harbors* | 67673 - If agent W1 (Concur), sets from email address and overrides agent email address in agency header address on invoice/itinerary documents. | |||||||
| Update Email with BCC *Safe Harbors* | 55503 - update email address "INVOICE@SAFEHARBORS.COM" with BCC | |||||||
| Communications-Add Ticket Request *Safe Harbors* | 49800-Add INV if a booking has been ticketed. Add ITIN if a booking has not been ticketed. | |||||||
| Communications-TktNbr for Segments From Booking Builder Rmks | Adds TK- remarks with ticket number which will append to the segments on the email | |||||||
| Communications-Prepare For Separate Emails | This routine changes the ticket request if the "SEPARATE" modifier is found in the PNR | |||||||
| Communications-Trip Start Add Remark* | If the agency wants ALL their PNRs using Trip Start module. This will add the required remark if missing T/USE TRIP START | |||||||
| Air Segment Capture Flight Distance (Apollo) | Use LM remark to capture flight distance between two cities, as Apollo does not populate that info in the airSegment | |||||||
| Humanitarian Agent Email Override *Safe Harbors* | 50451/65670/67142 - Add agent email to override if BR12 and if 5H-EMAIL OK is not on PNR | |||||||
| Communications-Add Email To PNR | Certain accounts need an email address added when an invoice is to be issued. Takes the "E" category remark and adds this email address for invoicing | |||||||
| Communications-Add Email from Z Remark *Safe Harbors* | 52506-Add email specified in Z/ remark to MT. | |||||||
| Populate PQR Response (Sabre) | This routine will populate issue *PQR and store the value in the property routine PQRResponse, which will be used later in the QC/Ticketing/Email process | |||||||
| Send Invoice or Itinerary After Split Ticketing | After split ticketing, this will now cycle through and do a email for the split tickets | |||||||
| Communications-Build Email Address List | Builds the email address list from either remarks or GDS Email field /KB | |||||||
| Communications-Check for multiple LOGO remarks *Safe Harbors* | 74918 - if more than one 5H-LOGO-x value exists, error & email Christy 75322-remove duplicate or LOGO-M | |||||||
| Communication-Schedule to Send Survey Email | Will take the survey info from the SSS table for agency and schedule to send survey as applicable. | |||||||
| Communications-Evaluate For Pre-Build Error | Does some checks prior to running the communication routine. If any errors, will stop the email | |||||||
| Communications-Remove Old Seat Remarks | If Compleat added seat remarks stating nothing available and NOW the agent created one with a seat number, it removes the NO SEAT AVAILABLE remark. | |||||||
| Hotel Adoption Email Send *Safe Harbors* | 65811-Send email to traveler re hotel not being in the booking. | |||||||
| RMK-Paid Seat Exists Remark *Safe Harbors* | 78222-If paid seat exists, add a remark PAID SEAT IS NON-REFUNDABLE | |||||||
| Send Qatar Insurance Notification *Safe Harbors* | 79829 - if any arrival into Qatar as a destination city, notify Traveller that insurance is mandatory | |||||||
| Add NWSHP To Header *Safe Harbors* | 73223 - If Senegal2021 appears in the UD7, add ACCOUNTING CODE NWSHP to Header | |||||||
| Communications-Add AccField To Header/Footer | This routine uses the self-service site list Acct Field to Email Header/Footer. It converts a reporting field and create a T/RMK- to a remark. The content of any T/RMK- will be added to the header of the email. | |||||||
| Communications-Add Canada eTA/Dual PSPT info to Header | 56218-added notice about dual passports//51859 - as of 15MAR16 Canada requires eTA for many Nationalities. Adding eTA remark for itinerary with destination to or transit through Canada *attached to agencies who have requested this feature to be turned on | |||||||
| Communications-Add Trip Summary* | If the agency is in the list, they want the trip summary appended to all their reservations | |||||||
| Communications-Add Visa Requirement to Header *Safe Harbors* | 79246 -Add CIBT URL for visa info into header. | |||||||
| Hotel Address MK Segments (Worldspan) | 54472-MK hotel segments do not have the address populated. This routine fills it in for the parse routine | |||||||
| Communications-Add Attestation Form Link *Safe Harbors* | 75462-Add attestation form link for inbound US flights. | |||||||
| Communications-Send CIBT Visa Email *Safe Harbors* | 63879/72948/77885/79246. -Send email to traveler with CIBT Visa information. | |||||||
| Communications-Send Insurance Notification *Safe Harbors* | 59643 - Send an insurance notification to passenger if customer DK begins with 12 or 00 and the PNRs were created in 2A1F and/or 08QF. Do not run routine if 5H-INS-DECLINED on PNR. | |||||||
| Communications-Toll Free Number Set *Safe Harbors* | 73457-Set toll free number based on SSS list Toll-Free number for Safe Harbors | |||||||
| COVID19 Vendor Policy Schedule and Append | Include vendor COVID19 policy in the email or send the policy 24 hours before departure. | |||||||
| Communications-Add 5H-PAID IN FULL *Safe Harbors* | 57052. Adds 5H-PAID IN FULL if 5H-T#TKTOVR remark is on pnr and fop in 5- is cash or check. | |||||||
| Add UD23 Content to Email Header *Safe Harbors* | 61479 - Added UD23 Content to Email Header if/when the reason code in UD23 matched UD23 Reason Code List | |||||||
| Communications-Populate AA Domestic Available Class Info (Sabre/Apollo) | Populate Available Class in flight segment for AA domestic segments. This will be used later to determine if the class of service is First or Business class. | |||||||
| Hotel HOD 168978 Notification *Safe Harbors* | 76388 - if HOD 168978 (JW Marriott Marquis Hotel Dubai) booked, send email notification to hotelprepay@safeharbors.com, as hotel doesn't accept US cc | |||||||
| Listen360 Survey *Safe Harbors* | 59787-Send survey by calling the listen360 webservice | |||||||
| RMK-PSPT Add Precheck/Redress Itin Remark *Safe Harbors* | 57130 - if Traveller has a Precheck or a Known Traveller number on the pnr, add an itinerary remark that will show on the Email. | |||||||
| Send Hotel Booked Notifcation to Agent *Safe Harbors* | 55570/77428 - If pnr has hotel segment, this routine sends an email notification to emilie.howley@messagebird.com; chesarae.maxwell@messagebird.com for DK 0172580000. and for DK0172520000, sends email notification to abrown@ctsi-usa.com | |||||||
| Simplesat Survey *Safe Harbors* | 72736-Send survey by calling the simplesat.io webservice | |||||||
| SSR DOCS Fail *Safe Harbors* | Fail ticketed HK Air bookings that are missing SSR DOCS. A notification will also be sent to the agent. | |||||||
| Communications-Populate Seats | 75577-In case seats doesn't get populated correct in the XML, this will do it. | |||||||
| Communications-Confirmation/Invoice | This routine builds the confirmation/invoice | |||||||
| Communications-FOP Check Notification *Safe Harbors* | 73036 - send Email to Agency if FOP is Check | |||||||
| Communications-Reorder Attachments | This reorders the attachments on the Main Email so the invoice is first then the itinerary | |||||||
| Schedule for Calendar ICS Email | Schedule to send Calendar ICS email to the traveler. | |||||||
| Retention Segment* | Captures the travel date and the last segment date used to calculate a retention segment to keep the PNR live. | |||||||
| Communications-Export To Travel Applications | For agencies that are using the Trip Start product, this will export the itinerary to Travel App, such as TripIt or TripCase if the passenger has registered to have the itinerary forwarded to the travel app. | |||||||
| File Finishing process | ||||||||
| Routine Name | Description | |||||||
| NON BSP Accounting-Build V Lines from Concur | Build V line for Concur basic bookings using fare remarks added by Concur | |||||||
| NON BSP Accounting-Build V Lines from nuTravel* | Build V line from ResX (nuTravel)/Certify | |||||||
| Seat-Fix Preference Remark* | Corrects the seat preference remark if it is an incorrect format. It also adds a COMPLEAT remark so that center seats are not chosen if combined with a premium seat remark | |||||||
| NON BSP Accounting-Build V Lines Stored Fare* | Takes the amounts from stored fare and builds "V" lines for Compleat to use in building the accounting lines for Epay bookings. | |||||||
| Email Address-Move Agent to Bottom of List (Amadeus/Sabre/Apollo/Gal) | #40131-Rescue services take the first email listed as the travellers. If the agent lists their's first, it's incorrect. If this is found, will move agent's to the bottom | |||||||
| NON BSP Accounting Line-Build V Line for EMD (Sabre/Amadeus)* | Add EMD accounting line in Sabre/Amadeus | |||||||
| Passport Expiry Notification* | This routine checks passport expiry date in P remarks and existing TSA/APIS SSRs. If it is expiring within 3 months of final return date, an email notification is sent to agent. NOTE: agency can extend the check to more than 3 months...list exists. | |||||||
| Pre-Ticketing-Booking Status NOT Confirmed | If a segment status has been changed to NO or if there is any HX segment, adds error remark. EPAY AIR SEGMENT STATUS IS NO SEGMENT STATUS IS HX | |||||||
| RMK-Prepay Hotel Booking Itinerary Remarks and Notification *Safe Harbors* | 55683-Add hotel prepay itinerary remarks and send an email to hotelprepay@safeharbors.com *** Attached to File Finishing b/c only runs in Ticketing Workflow *** | |||||||
| Segment Cancel by Concur *Safe Harbors* | 70971-For a booking that has not been ticketed yet, if a segment has been cancelled, fail bookings and email support. | |||||||
| Concur Booking WN Missing Ticket Number *Safe Harbors* | 49910-Send an email if ticket number does not exist for WN booking. | |||||||
| NON BSP Accounting-Adjust RMV for AC Adcollect | If an AC adcollect, it MAY be eligible for commission. If so, appends the commission amount to the RMV line | |||||||
| PPT Remarks Add from SSRs | If TSA SSR's aren't present for all airlines, this PSPT routine will take the info from an already created SSR and add the Compleat RMP PPT remark. Remaining SSR's will add correctly from RMP PPT remark. | |||||||
| Queue to FlightStats *Safe Harbors* | 66792-Queue all bookings to flightstats 1P3F Q460. If there is no TVLR or UD30, booking gets qeuued to Q501 | |||||||
| Seats-Add IGNORE Remark | If booking class is always paid seating, adds an S remark to IGNORE flight seat selection. Also, if any flights have an equipment change, adds IGNORE remark *MUST HAVE SEAT MODULE ENABLED | |||||||
| PSPT PPT Remark Fix *Safe Harbors* | #48711-Sureware that builds their profiles, can't format the P#PPT remark correctly. We'll take what they enter and fix it so ti can run with our routines | |||||||
| PSPT Expiry Check and Add SSR* | This routine captures the "P" PPT remark with passport info and adds an APIS SSR for international travel. Or a TSA SSR if travel is domestic USA or transborder. Also adds Known Traveler/Redress number from P remark. | |||||||
| Hotel Cancel Remarks Remove (Apollo) | #49189-if there are duplicate auto-generated cancellation remarks, they are removed from the Apollo PNR | |||||||
| Hotel Offline Notification *Safe Harbors* | 57912-If hotel contains OFFLINE HOTEL, document and send email. | |||||||
| Meal Request | Requests meals from Category M Remark line. | |||||||
| TSA Traveler Requirements | TSA requires the airline to submit passenger info in an SSR. If missing 4 days before departure, a notification email is sent to agent. NOTE: Runs after PSPT Expiry Check And Add SSR. | |||||||
| Foid SSR Add if Missing | Specific airlines require an FOID SSR (Form of ID field) on the PNR. Routine runs for international pnrs, if Agency requests. Also runs for Amadeus agencies for airlines PD and KC. 73554 - added TK for Five Star | |||||||
| NON BSP/ARC Accounting Line* | Creates Non-BSP/ARC accounting lines for air and tour vendors | |||||||
| PSPT Check Redress/Known Traveller ssr for Country code (Sabre) | 77231 - per Sabre SAN 16382 Industry mandsates that Redress Number & Known Traveller Number DOCO ssrs must include the country code, as of 28JUL22 | |||||||
| TAR Check-Main Approver Same as Traveller and Format | If the MAIN approver is the same as traveller, an error is added. If the Y#A- remarks are in an invalid format, an error is added | |||||||
| Waitlist Processed Remark Add | Compleat doesn't add a remark stating that it will be processed by the waitlist module. This routine adds a remark to let the agent know. | |||||||
| Append rloc to YK Segment (Sabre) | Add rloc to YK segment if missing and it can be found in a remark or other segment in the booking. | |||||||
| TRAMS Domestic/Transborder/International Field | #27079 Add RM*IN Descriptor to non-BSP MS lines and for BSP files | |||||||
| Air Check for Points *Safe Harbors* | 53253 - if all flights on single airline, check SSS to see if should prompt to use points. If so, email sent to Agent and Q# remarks added, advising appropriate fee. Override: 5DO NOT USE POINTS | |||||||
| Hotel Check for Points *Safe Harbors* | 53253 - Check SSS to see if should prompt to use Marriott points. If so, email sent to Agent and Q# remarks added, advising appropriate fee. Override: 5H#DO NOT USE POINTS | |||||||
| Service Fee (Apollo) *Safe Harbors* | 52076-This routine adds the service fee from remarks for Apollo bookings. | |||||||
| Southwest (WN) Fake Ticket Number *Safe Harbors* | 50876. Adds mandatory error if fake ticket number 222222222 is in MS accounting line. | |||||||
| Commission-Do Not Add for International *Safe Harbors* | 48571-Do not add commission for international booking. | |||||||
| Pricing Fields Create and Adjust Exchange (Sabre) | Add FP line for each PQR. If no FP line is required, the override is 5F#FPLINE OK or 5H-FPLINE OK | |||||||
| Segments Organize in Right Order (Apollo/Sabre) | When ticketing in Sabre, there will be an error if the segments are out of order. This routine puts them in order. In Apollo, the HL segment must be at the end of the PNR. | |||||||
| AC Net Markup *Safe Harbors* | 83941-For all 08QF UA bookings, if the markup is more than 25%, fail the booking. 84445-Updated markup check for AC | |||||||
| Add SSR/OSI with Age or DOB | 68851-CTA requires SSR/OSI with child's age in order to ensure children under 14 are seated near their parent. Runs for Amadeus/Apollo/Sabre Canadian agencies for all airlines. | |||||||
| Add UD23 Content to Email Header *Safe Harbors* | 61479 - Added UD23 Content to Email Header if/when the reason code in UD23 matched UD23 Reason Code List | |||||||
| Add UD38 With Htl Rate Code Booked *Safe Harbors* | 70377 - If hotel segment booked with rate code, add 5.S*UD38 (RATE CODE) for tracking purposes. | |||||||
| Booking.com Hotel Loyalty Notification *Safe Harbors* | 67826-Send a notification to the traveler if BOOKINGCOM¤DIRECT CONNECT is found in the hotel segment. Also add segment associated itinerary remarks: Your hotel is confirmed with Booking.com. Please provide hotel loyalty/rewards numbers directly to the hotel at check in. All changes need to be made directly with Safe Harbors Business Travel. Fail booking.com with ZZ vendor code Also add UD63 | |||||||
| Business Class Approval UD13 *Safe Harbors* | 82509 - Brookings PNR's require approval (UD13) if business class is booked. DK0173910050 | |||||||
| CETAS Approver Remarks Update *Safe Harbors* | 47204 - if Y# approver remarks missing, will check D# remarks for approver email, and add. | |||||||
| Check Pax Over 18 *Safe Harbors | 78950 - if single-pax booking, and pax is not at least 18 years old, add error *** is in File Finishing, so runs after the PSPT routines *** | |||||||
| DL Promo OSI Add *Safe Harbors* | 76142-Add OSI DL SPRING22/FIRST NAME-LAST NAME for all DL bookings between Mar 1 - Apr 30, 202 traveling between Mar 1 - Sep 30, 2022. 77022 - update OSI DL SUMMER22/FIRST NAME-LAST NAME Travel 01JUN-31OCT Ticketing: 01JUN-31JUL DL: P,A,G Virgin: W,S,H,K AF: W,A,S | |||||||
| Fail Booking with Seat HRQ Status *Safe Harbors* | 51642-Fail booking with HRQ seat status. | |||||||
| Federal Government Fare FOP Check *Safe Harbors* | 59946/77509-Check FOP to make sure the credit card number is correct | |||||||
| HHL Phone OSI | Finds the hotel phone number in the description pages of the hotel segment and adds it as an OSI to the airline. | |||||||
| HX Segment Add *Safe Harbors* | 61434-Add HX segment to 5H- remark in this format 5H-XLD SEG <today>-<Airline><FlightNum><ClassOfServ><deptDateddmmm><dptCity><ArrCity> | |||||||
| International Air PNR Sign Off *Safe Harbors* | 47203/57034/61022/62320/62748/64205/75714/76269 - If any International air segments, booking will not pass QC, unless there is an override of INTL OK DDMMM (yesterday or today's date) | |||||||
| Online Booking-Innfinity Seat Remark Add (Sabre) | Adds seat itinerary remarks based on seat info remarks added by the Innfinity booking engine. Format: XX SEAT INFO ... | |||||||
| Passenger Email OSI For DL Sked Change *Safe Harbors* | 57592-Add OSI with traveler's email to be used for DL sked change. | |||||||
| Pricing Fields (Worldspan) | This routine adjusts the pricing on the PNR if any information is incorrect | |||||||
| Pricing Fields Create and Adjust (Apollo)* | This routine adjusts the pricing on the PNR if any information is incorrect | |||||||
| Pricing Fields Create and Adjust (Sabre) Multi* | This routine adjusts the pricing line on the PNR based on each PQ for multiple PQs bookings. If FP is not required, override is 5F#FARE OK or 5H-FPLINE OK. To bypass commission only, 5F#COMM OK is used. | |||||||
| Pricing Fields Create and Adjust (Sabre)* | This routine adjusts the pricing line on the PNR based on each PQ for single PQ bookings. If FP is not required, override is 5F#FARE OK or 5H-FPLINE OK. To bypass commission only, 5F#COMM OK is used. | |||||||
| PSPT Missing or Expired Notification for Intl Travel *Safe Harbors* | 74805-If passport ssr is missing for an international booking, send an email to the traveler. 77801 - if passport expires early, send notification | |||||||
| Remove Magnatech remark *Safe Harbors* | 69152. Remove all Magnatech remarks from the pnr matching V‡2- or V‡3- , example: V‡2-DL LNLH‡08QF and send email notification to compleat@safeharbors.com so they can update Sabre profile | |||||||
| Seat Selection Request Remark Missing* | If the agency uses Compleat seat selection, if the seat preference remark is missing, add error: COMPLEAT-SEAT PREFS/ IS MISSING | |||||||
| TAR Check-Ticketing Deadline Override Check | Check ticketing deadline override. If it is earlier than today, fail the booking. | |||||||
| TAR Check-UDIDs Fields for TAR Missing and Length | If customer requires, this will check if any UDID fields for the TAR are missing, if so, will stop the process and add error | |||||||
| Travel Description Add to UD99 *Safe Harbors* | 57182-Add Travel Description to UD99 | |||||||
| TSA Compare P With SSR *Safe Harbors* | 75925-If SSR info does not match the P# remark, fail booking. | |||||||
| UA/AC Ghana/Nigeria FOP Check *Safe Harbors* | 83941-For all 08QF UA/AC bookings to Nigeria or Ghana, credit card cannot be used as FOP Error: CANNOT USE CC FOR NIGERIA/GHANA TKTS ON UNITED | |||||||
| Add Email and Mobile in OSI/SSR Field* | This routine adds CTCE/CTCM OSI or SSR (GDS dependent) with passenger mobile phone and email address to PNR when HK air is present regardless of carrier to be used as emergency contact information. | |||||||
| Pricing Fields Create And Adjust EMD (Sabre) | Add EMD FP line in Sabre so that seats are purchased at time of ticket issuance during W# command. | |||||||
| PSPT SSR Info Mismatch *Safe Harbors* | 78398-If the P# info does not match the SSR info, fail the booking with the error: PASSPORT INFO IN P# DOSE NOTM ATCH SSR. UPDATE P# OR REMOVE SSR | |||||||
| Service Fee (Sabre) *Safe Harbors* | 47202-This routine adds the service fee from remarks for Sabre bookings. | |||||||
| Accounting Line-Check Limo Type Code *Safe Harbors* | 50687 - Check if correct Type Code for LIMO are add to accounting line. If type code is not TT3 then add a mandatory remark | |||||||
| Remove Ticket Issued Remark for EMD *Safe Harbors* | 56510-Remove ticket has been issued remark if there is EMD in the FP line and ticket has already been issued. | |||||||
| Accounting Line Add Car/Hotel *Safe Harbors* | 47203 - Adds an accounting line for car/hotel only bookings for back office commission track purposes. | |||||||
| Concur Queue Cancelled Bookings To Ticketing *Safe Harbors* | 77103-If booking was previously cancelled, and it was requeued with live segments again, the routine will remove the remark and queue to Ticketing. The system will look for this remark CB/CXL/PAX REQ CXL RESERVATION*2022-06-21 | |||||||
| Humanitarian OSI Required *Safe Harbors* | 74157/75576. An OSI is required for all air pnrs with humanitarian fare. EG. 3OSI BA HUMN freeflow | |||||||
| Qatar (QR) POC Violation *Safe Harbors* | 78146-For Qatar bookings, look for this wording in the SSR. POSSIBLE POC VIOLATION DETECTED ADM MAY BE APPLICABLE If found, fail the booking with the error THIS BOOKING IS SUBJ TO DEBIT MEMO-CONTCT TKTING and send an email to ticketing@safeharbors.com | |||||||
| Check PQR for Tour Code *Safe Harbors* | 57657 - if a PQR exists, validated on a carrier with a tour code in the 5A# remarks but missing from the FP line, Compleat will add a Q# reminder | |||||||
| Net Merchant Fee Accounting Check *Safe Harbors* | 58253-Edit: handling from this task no longer reflected in routine 70468 - routine revised to validate *PU against UD58 | |||||||
| Remove Old MS Accounting *Safe Harbors* | 48468-Remove old MS accounting lines | |||||||
| Compare FP and PQ *Safe Harbors* | 49929 - Compare the number of FP line with the number of PQ. If they don't match, booknig wil fail. | |||||||
| Plating Carrier to Hahn Air (HR) *Safe Harbors* | 60287-Update SIlver Airways (3M) to plate on HR 76728 - Adjusted for Air Senegal (HC) to add error Q#(Date/Time)/VALIDATE HC ON HAHN - AHR | |||||||
| Add UD18 for Cabin Class *Safe Harbors* | 70005/capture the highest class of service in the PNR and add to UD18. Not per segment. | |||||||
| Airlines and Payment Restrictions* | Checks to see if any airline in the PNR has FOP payment restrictions. if criteria met, will add error <<carrier>> DOES NOT ACCEPT <<card type>> CARD IN <<country>> Override: 5H-AIRLINE CC OK | |||||||
| Check All HK Air Has PQ *Safe Harbors* | 55434 - fail pnr if any HK Air Segments are not in a PQ Error: Q#DATE/TIME/NOT ALL SEGS IN PQS. UPDATE OR ADD 5H-AIR SEG OK Override: 5H-AIR SEG OK | |||||||
| FPLine Count Check *Safe Harbors* | 49158-If there are more FP lines than PQ, fail the booking. | |||||||
| Update Commission to 0 After Hours *Safe Harbors* | 65380-Update booking with 0% commission after hours if it is missing. | |||||||
| Fourteen Day Fare Tracking *Safe Harbors* | 54463-Add 14 day fare tracking to UD34 | |||||||
| Child TSA For LHG *Safe Harbors* | 78429-If Child TSA SSR is missing for LH,SN,OS,LX, fail the booking. | |||||||
| Delta Winter Incentive OSI Add *Safe Harbors* | 83483-For DL bookings made between Jan 24-Mar 22, 2024, and traveling between Jan 24-May21, add SI DL WINTER24/AGENT FIRST NAME-LAST NAME if agent didn't enter it. | |||||||
| Form Of Payment Check Based on PQ *Safe Harbors* | 55900-Fail booking based on FOP specified in PQ. | |||||||
| Missing Segment or Passenger in Stored Fare *Safe Harbors* | 66700-If a passenger or HK segment is missing in a PQ, fail the booking. | |||||||
| Commission Missing-Add Reminder* | If the agency doesn't want Compleat to add generic commission, it will add a reminder to PLS VERIFY COMMISSION ON PNR | |||||||
| Fail Booking If Child SSR Missing *Safe Harbors* | 82222-Fail all bookings if CHLD SSR is missing. | |||||||
| Ministry Fare Ticket Designator and Endorsement Check *Safe Harbors* | 76917-For 08QF or W5VK, if carrier is LH/SN/OS/UA/LX and IHUM15 is used, but ticket designator is missing, fail with the error Q#VERIFY IF MINISTRY FARE IS STORED Q#IF FARE CORRECT, ADD OVERRIDE 5H-HUM FARE VALID Override: 5H-HUM FARE VALID | |||||||
| Refund Accounting Commission Check *Safe Harbors* | 48464 - Add error if positive value for commission on refund accounting | |||||||
| SY & WN Accounting Commission Check *Safe Harbors* | 72278 - Check for commission in any accounting lines with SYSYSY or WN vendor and error back to agent to correct | |||||||
| Unused Ticket Check Override *Safe Harbors* | 48797 - check T remarks vs validating carriers to see if existing credit should have been used. | |||||||
| Offline Approval Required for Non Executive *Safe Harbors* | 49560/52008/52255/54522/56279/56603/62091/63463-Approval Required For Non Executive Management for specific customers | |||||||
| Full Fare Low Fare-Remove Blank/Duplicate *Safe Harbors* | 54819-Remove blank or duplicate FF/LF/FJ for Safe Harbors | |||||||
| Full Fare Low Fare-Populate Preferences | This routine will populate UseFF, UseLF, and UseFJ property routines, which will be used later to determine if FF/LF/FJ would need to be added. | |||||||
| Online Booking-Add LF For Split Ticketing *Safe Harbors* | 50751-Concur adds one LF for split tickets. This routine removes it, sets the UseLF as true and adds LFs for splits | |||||||
| Full Fare Low Fare-Calculate FF for Amtrak *Safe Harbors* | 49318-Use booked fare as FF for Amtrak | |||||||
| Full Fare Low Fare-Calculate FF for NK/F9 *Safe Harbors* | 48373-Calculate FF for NK/F9 using FQ command. | |||||||
| Full Fare Low Fare-Add to PNR NEW** | Calculates the Full Fare and the Low Fare on the itinerary and adds it. | |||||||
| Email Address Missing or Incorrect Format* | Checks the email addresses on the PNR to make sure they are in the correct format and also ensures one is there. If missing, fail pnr with the error: MISSING EMAIL ADDRESS ON THE PNR | |||||||
| Full Fare Low Fare-Add to PNR* | Calculates the Full Fare and the Low Fare on the itinerary and adds it. | |||||||
| Check UD24/UD25 on Net Fares *Safe Harbors* | 69326 - if fare stored with PMIS, PJCB, or IHUM15, pnr must have UD24 and UD25. If missing, add error: NN WAIVER/FAVOR UDIDS FOR XXXX | |||||||
| Commission Values Add to 5R# *Safe Harbors* | 65552-Add commission amounts and tour code to 5R# remarks. | |||||||
| International Booking Reminder and UD34 Add *Safe Harbors* | 50360-Add reminder CK IF SNAP OR COMM IS BEST DEAL for international bookings. If there is commission, UD34 COMM will be added. | |||||||
| PQ Amount Check *Safe Harbors* | 61995-Check current fare to see if it matches the amount in PQ | |||||||
| UDID Check For *FJ FT *Safe Harbors* | 56551 - if the FJ code is FT, certain Udids are required on the pnr. Routine adds an error of any of these are missing | |||||||
| Undiscounted Fare to UD14 *Safe Harbors* | 61517-Add original fare without savings to UD14 for Johns Hopkins. 68802 - extending to all Customers, and adding an Itinerarary remark stating the amount saved | |||||||
| Ancillary MS Accounting Missing *Safe Harbors* | 69147-Check MS for each EMD accounting line. Fail if it *TT, *CF, *FF, *LF, *FJ is missing from EMD accounting. | |||||||
| Add Endorsement Info to UD36 *Safe Harbors* | 59957 - Added Ticket type (NR / R / RP / NP) to UD36*MSXXX for Online Bookings for Split Tickets | |||||||
| Check TRAMS MS Line Association *Safe Harbors* | #55617- This routine checks the 5.S*MS lines to see if they are incorrectly associated to fee or insurance segment. If they are, mandatory error is added. | |||||||
| CETAS Validate Approver/Traveler Remarks* | Checks TAR bookings and verify the approver/traveler email remarks on the PNR and makes sure they are in the correct format, otherwise adds error | |||||||
| Retention Segment* | Captures the travel date and the last segment date used to calculate a retention segment to keep the PNR live. | |||||||
| Add BCC Email if Credit Card Used *Safe Harbors* | 58688 - If any PNR has AX card as the PNR.FOP or as the credit card guarantee, please add BCC email of ACCOUNTING@SAFEHARBORS.COM 65715/simple email to accounting@safeharbors.com when corporate visa used ending in 92125. | |||||||
| Remove Duplicate Email *Safe Harbors* | 58436 - removed duplicate email info if not contain #TVLR | |||||||
| Split Ticketing Remarks To Accounting (Sabre) | Since Sabre is the only one that allows MORE than 1 ticket on the same invoice, this will take the prewritten 5H-T#TKTx- remarks and build as MS remarks | |||||||
| TAR Add-Air Total Remark | A 5H-TARAIR remark needs to be added to the PNR prior to TAR issue. It will add if simple otherwise will require agent intervention | |||||||
| Full Fare Low Fare Check *Safe Harbors* | 48373- Check for existence of LF and verify FJ. *** Must run after "Split Ticketing Remarks to Accounting (Sabre)" **** | |||||||
| TAR-Update TAW Line *Safe Harbors* | 79447 - update TAW line for all CETAS Customers to CETAS APPVL REQ | |||||||
| Get Values From Database process | ||||||||
| Routine Name | Description | |||||||
| Schedule 08QF/NV3I Created Booking to Run in Pcc *Safe Harbors* | 54652/58432/65670-Schedule 08QF/NV3I Created Booking to run in 08QF/NV3I | |||||||
| Accounting History *HAC (Sabre) | Issue *HAC information in Sabre and store the result in the property routine AccHistory*HAC (Sabre) to be used later in QC. | |||||||
| Ancilliary Items *AE (Sabre) | Contains the *AE information for Sabre and adds to property routine AncillaryItems to be used later in QC/Ticketing | |||||||
| Clean PNR of Old Remarks During QC/Ticketing *Safe Harbors* | 49279-When the PNR is sent to UCQM in QC, it will remove any old remarks it previously added. | |||||||
| Correct/Add Agent Sine Override Remark *Safe Harbors* | 74306. Remove space in 5.S*SA remark. Also adds 5.S*SAAV if agent in pcc I425 has forgotten to add his. | |||||||
| Populate PQR Response (Sabre) | This routine will populate issue *PQR and store the value in the property routine PQRResponse, which will be used later in the QC/Ticketing/Email process | |||||||
| Check if RescueLine PNR | If during office hours and this has the OTH for rescue line, will remove the OTH into history so it is NOT incorrectly identified | |||||||
| Get Queue and Email From Database | Retrieve the agent's information, including name, return queue, email address, phone number. | |||||||
| Check Email from Valid PCC *Safe Harbors* | 74938 - Error Gordian/Joy pnrs if they are queued to a Safe Harbors Email Queue or vice versa | |||||||
| Check for ARNK As Last Segment | This routine will check to see whether or not the last air segment in the PNR is an "ARNK", and if so, delete it and 'ER' the PNR. | |||||||
| Add Native RecordLocator For Passive Segments (Apollo) | Apollo doesn't append the rloc in the ACKN field. If Compleat can find it on the PNR, it will append it. | |||||||
| BranchName Property Set *Safe Harbors* | 55241-calls the BranchName Set routine to set the branch name used in various routines | |||||||
| Itinerary Remarks process | ||||||||
| Routine Name | Description | |||||||
| Language Remarks Check | Validate the itinerary remarks against the language remark override. If they don't match, stops itinerary rmks processing | |||||||
| RMK-Airline Phone Number and Record Locator | Adds the toll free number for the airline in their departure city and their rloc | |||||||
| RMK-Paid Seat Exists Remark *Safe Harbors* | 78222-If paid seat exists, add a remark PAID SEAT IS NON-REFUNDABLE | |||||||
| RMK-Cell Phone Use Illegal While Driving | For car bookings in certain provinces/states, a remark - Cell Phone Use Is Illegal While Driving will be added. | |||||||
| RMK-Check In Times | Adds the advance check in time remarks for domestic, transborder and international | |||||||
| RMK-Check In Documentation* | Adds documentation itinerary remarks based on the destination | |||||||
| RMK-ETicket ID Required | Compleat will add itinerary remarks that photo ID is required for check in | |||||||
| RMK-Passport Pages South Africa | Adds itinerary remarks to alert passenger that if travelling to South Africa, customs requires you to have TWO blank pages in your passport. Now also adding itinerary remarks to alert passenger of new documentation required for children under 18. | |||||||
| RMK-Prince Rupert Checkin | Prince Rupert has unique checkin instructions. This routine adds these remarks: AS THE AIRPORT IS ON AN ISLAND, YOU MUST TAKE A FERRY TO THE CITY OF PRINCE RUPERT. TRAVELLERS ABOARD SCHEDULED AIRLINES ARE TRANSFERRED BY BUS AND FERRY TO DOWNTOWN PRINCE RUPERT AS PART OF THEIR TICKET COST. PLEASE CONTACT PRINCE RUPERT AIRPORT SHUTTLE OFFICE AT 250-622-2222 FOR SHUTTLE DEPARTURE AND ARRIVAL DETAILS. | |||||||
| RMK-Ryan Air Checkin | States they MUST have boarding pass before they get to airport. | |||||||
| RMK-Baggage Allowance Link* | Adds a link to baggage allowance | |||||||
| RMK-Check In Carry On Restrictions | Moves the restrictions for carry on into the PNR | |||||||
| RMK-Europe Security Portable Devices | Adds remarks on flights from Europe that electronic devices may be checked at security and to make sure they are fully charged | |||||||
| RMK-Travel Advisory* | Adds itinerary remark with applicable government advisory website URL. Only applies if citizenship identified as Canadian or USA. If no citizenship determined on PNR, uses agency country and only links to Canadian & USA government sites. | |||||||
| RMK-Add Kenya Visa Remarks | Add Kenya Electronic Visa requirements as itinerary remarks. | |||||||
| RMK-Car Driver Age Surcharge | Adds itin rmk to customer that CAR driver's age may be a surcharge | |||||||
| RMK-Car Hotel Price in Home Currency | Adds a remark converting the price into local currency | |||||||
| RMK-Car Location May Not Have Debit | Adds itin rmk to customer that CAR location may not have debit | |||||||
| RMK-Travel to Canada Documentation Alert | This remark links to Canadian Government's website and the admissability requirements. ASTA has advised that if we do not alert our customers of this law, it could lead to a claim of breach of fiduciary duty against the agency. | |||||||
| RMK-USA Preclearance | If this city offers USA preclearance, an itinerary remark is added | |||||||
| RMK-Agent Remark | Adds remark to pnr with the name of the agent that made the booking. | |||||||
| RMK-Airport Fees | Certain airports charge either a departure or arrival fee that is NOT collected on ticket. This adds itinerary remark for these airports. | |||||||
| RMK-Non Refundable | If agent has added RMA remarks with change penalties, those are used to add the non ref remarks. Otherwise, AC domestic/trans non ref remarks are added for those agencies in list; NONBSP trans/international remarks are added and for other carriers, the non ref remarks are added based on stored fare endorsement. | |||||||
| RMK-Add Non-Refundable Airline Imposed Fee Remark (Worldspan/Apollo) | If validating carrier is LH/LX/OS/SN then added a Q remark to remind agent that a 16EUR non-refundable fee applies and add an itinerary remark to notify travellers. | |||||||
| RMK-Airline Basic Economy/Restrictive Fare* | This routine will add itinerary remarks to reflect the fare rules for basic economy fare for different airlines (i.e.DL E class, AA B class, etc.) Agency also has the option to send an email to agent or traveler regarding restrictive fare booked. **List of restrictive classes is found in Knowledge Base** | |||||||
| RMK-Non Refundable (EXCLUDE AC Domestic/Trans) | These remarks go on ALL carriers excluding Westjet and Air Canada Domestic & Transborder. | |||||||
| RMK-Non Refundable INCLUDE ALL CARRIERS | These remarks go on all Carriers EXCEPT AC & WS. NOTE: Westjet nonref routine runs prior to this one therefore remarks will already exist on pnr. | |||||||
| RMK-Nonref WestJet | Handles All non-refundable/change fee remarks for WS itineraries. | |||||||
| RMK-E Ticket Valid on Issuing Carrier | Compleat will add itinerary remarks stating that ticket is valid on issuing airline only | |||||||
| RMK-One Way for International | If this is an INTERNATIONAL one way journey, adds an itinerary rmk warning to the customer that they need proper documentation. | |||||||
| RMK-Seat Remark Add for Passive Concur PNRS | Concur (Cliqbook) adds seat selection for passive air segments in RM CB/SEAT remarks. This routine takes the seat selection from those remarks and adds it as a segment selected itinerary remark. | |||||||
| RMK-Booking Builder Fix Seat Assignment | Booking Builder adds all seat numbers into one remark. This breaks them into separate segment associated itinerary remarks. | |||||||
| RMK-Air Canada Flight Notification Sign Up | This remark advises pax that they should go to the AC flight notification page to sign up to receive email notifications of flight cancellations or delays. | |||||||
| RMK-AC Rouge Inflight Entertainment | 44124-AC Rouge inflight entertainment requires AC Rouge App | |||||||
| RMK-Propeller Plane | Adds an itinerary remark that the flight is a propeller plane | |||||||
| RMK-Car Mileage Charge | If CAR segment is NOT unlimited mileage, adds itin rmk to remind customer that there is a mileage charge | |||||||
| RMK-Delta Medallion Upgrade | 2912-If sees DL booked in O/R class. Adds itinerary remark that DL upgrade confirmed | |||||||
| RMK-Car/Hotel Credit Card Name | Adds itin rmk to customer that CAR and/or HOTEL requires a credit card in the name of the guest | |||||||
| RMK-Hotel Credit Card Deposit | #45038-if Deposit guarantee has been applied to a hotel reservation, will add an itinerary remark to the segment | |||||||
| RMK-Amtrak Cancel Policy | #40595-Adds Amtrak Cancel policy in itinerary remarks. Adds for both passive and live space. | |||||||
| RMK-Wheel Chair Has Been Requested | A segment remark is added if an SSR with wheel chair request in on pnr. | |||||||
| RMK-Add CDC Attestation Link for PNRs With Air *Safe Harbors* | 75462-If PNR has international air to USA, add remark stating "Attestation Form (Recommend to print and complete BEFORE arriving to airport for departure to USA". Link is https://www.cdc.gov/quarantine/pdf/combined-passenger-attestation-p.pdf | |||||||
| RMK-Rescue Line (Run Order End) | This routine pulls rescue line remarks from the self-service site and adds as the last itin remarks | |||||||
| Online Booking Checks process | ||||||||
| Routine Name | Description | |||||||
| Online Booking-Delay Ticketing *Safe Harbors* | 61408-Delay online booking ticketing by 15min. | |||||||
| Online Booking-Delay Processing for Concur (Amadeus/Sabre/Apollo) | Processing is delayed to prevent simults when carrier NK/PD/F9 is booked. | |||||||
| Online Booking Check-Skip Checks* | Checks the Self Service Site tables "Online Booking - Online Bookings Checks Skip" (By Agency and By Account) and applies fraud checks as noted on the SSS table. Override remark to bypass any of the SSS settings is ONLINE OK. | |||||||
| Online Booking Check if AA Canceled *Safe Harbors* | 57422. AA has been cancelling flight segments instead of changing status to HX. This routine will queue pnr to Q7 for review by their agent team if any AA cancelled flights are found. | |||||||
| Online Booking Check-Depart or Arrive Agency Country Only | If an online booking, any agency with this routine turned on requires the booking to come from their country only | |||||||
| Online Booking Check-Destination* | There are certain destinations that are suspect. This adds error so it won't ticket. Booking must be agent claimed in order to proceed through check. | |||||||
| Online Booking Check-Freemail Account | If online booking NOT departing agency home country with a freemail domain account (yahoo, hotmail, gmail, email, myway) in the PNR, adds mandatory error. Booking must be agent claimed in order to proceed through check. | |||||||
| Online Booking Check-International Minimum Reservation | Checks the Self Service Site table "Online Booking - International Minimum Reservation Allowance" which allows agency to set a min number of hours (i.e. 72) that booking must be made prior to departure. If within this window, an auto-ticketing delay can be entered (i.e. 4 hours) so that agency can review PNR prior to auto ticketing occurring. Override remark is INTERNATIONAL OK | |||||||
| Online Booking Check-Outside Office Hours | Some agencies ONLY want their online bookings ticketed inside office hours. | |||||||
| Online Booking Check-Send Error Email | If any of the booking checks stop the booking, this routine will send the error email to the customer and the agency | |||||||
| Online Bookings process | ||||||||
| Routine Name | Description | |||||||
| Online Booking-Set Concur Offline Approvals As Online Bkg *Safe Harbors* | 49567-If outside of office hours, the booking will treat the concur offline approval bookign as a concur and autoticket. | |||||||
| Online Booking-Onhold Ticket | On hold ticket does not need to be ticketed/invoiced | |||||||
| Online Booking-Append rloc for Passive Segments (Concur/Certify) | Concur/Certify doesn't add the rloc to the segment if passive. It will be taken from the remarks and segments added back for Amadeus/Apollo/Sabre. | |||||||
| Online Booking-Remove ITIN Remark | Some Booking engines add RMT ITIN. This is removed so the reservation can be processed | |||||||
| Online Booking-Check for HX Segments | Fail online booking that have HX segments | |||||||
| Online Booking-Additional Concur Air/Rail Ticketing/Invoicing Required* | If additional air segments are added after initial invoicing or ticketing, it will be scheduled to be ticketed. | |||||||
| Online Booking-Build Pricing* | This routine will deal with stored fares. It would either combined or split stored fares. Only runs in Amadeus/Sabre/Apollo for KDS, Concur, Resx, eTravel, Gethere, Cytric, Serko | |||||||
| Online Booking-Comment To Agent Concur *Safe Harbors* | 48641/54723/55337/62701-If a 5H-CB/PAX remark is on pnr, then mandatory error is added: SEE SPECIAL REQUEST IN P5H ONCE WORKED, ADD 5H-RQST WORKED and online booking is not ticketed. Email is sent to esupport@safeharbors.com and bcc to cyoung@safeharbors.com | |||||||
| Online Booking-No Segment to Ticket *Safe Harbors* | 57811-If a booking has no air segment, but there is a PQ, bookings will get queued. | |||||||
| Online Booking-Finish For Ticketing* | This routine checks if an online booking, if so, handles Seats and queues to ticketing. | |||||||
| Online Booking-Pre Check For Errors | If carrier is 8O/H3/JB and space is not passive, error is added and ticketing stopped as must be paid via MCO. Override is TKT WAS ISSUED for invoicing. | |||||||
| Online Booking-Remove Old Accounting Line for Void *Safe Harbors* | 82519-Remove all old accounting lines for void Concur bookings. Concur will add this remark for void. 5H-CB/VOID/TICKET 0068064484482 FOR | |||||||
| Online Booking-Seat Remarks Fix | Updates seat remarks added by OBE's to correct Compleat format (i.e. YOUR SEAT IS 2A is converted to SEAT 2A) | |||||||
| Online Booking-Fix Reporting Fields (Amadeus/Apollo/Sabre) | Run only for Travcom online bookings. Concur adds full fare/low fare/fare savings fields as TRAMS formats. This converts them to the correct format for other accounting systems (i.e. Travcom) | |||||||
| Online Booking-Add TAR Start Remark | If this agency prefers to add TAR START to trigger TAR, they will need it auto appended for Online Bookings since there isn't agent intervention. | |||||||
| Online Booking-Remove Empty UDIDs *Safe Harbors* | #47203-Concur adds empty UDIDs. This routine will check if there is anything after the UD number, if not, it's removed | |||||||
| Pre-Ticketing Checks process | ||||||||
| Routine Name | Description | |||||||
| TAR-Remove Old TAR Remarks | For TAR bookings, old 5H-TARAIR- and 5Y#TKTD- are removed so they are NOT resused | |||||||
| Pre-Ticketing-Fail Invoicing for F9 Epay if Payment Not Received (Sabre) | 54529. Fail invoicing if Epay payment not received by Frontier Airlines. | |||||||
| Pre-Ticketing Accounting Line Check *Safe Harbors* | 53656-Fail Concur bookings if it does not have any accounting lines. | |||||||
| Fail All Exchange Bookings *Safe Harbors* | 48701-Fail all exchange bookings being queued for ticketing | |||||||
| Ticketing-Using RMT/INV with HK Segments *Safe Harbors* | #50644-If the PNR has 5H-T#INV and TAW contains ETKT, a warning is sent to the agent. | |||||||
| Pre-Ticketing Fail NDC Booking *Safe Harbors* | 79412-Fail all unticketed NDC bookings to Q102 | |||||||
| Pre-Ticketing-Check for Old Q Errors (Sabre) | If processing was interrupted (simults or runtime), the Q#TKT ERR and Q#INV ERR remarks will not have been registered in the COMPLEAT database. This means they will not automatically be removed and will remain on pnr. This routine removes these old remarks before ticketing routines run. | |||||||
| Pre-Ticketing-Check if Accounting Linked (Sabre) | If any of the linked OTH/TUR segment has been removed, this routine will fail ticketing/invoicing. | |||||||
| Pre-Ticketing-Form of Payment Missing | Checks the PNR to see if the form of payment is missing | |||||||
| Pre-Ticketing-Missing Ticketable Segments* | If they sent through with a TKT request, makes sure there is Air or Rail segments. It also checks to see if there is accounting line in Sabre. | |||||||
| Pre-Ticketing-Stored Fare Missing* | Adds error if the stored fare is missing or incorrect for ticketing, | |||||||
| Pre-Ticketing-Ticket Request Remark Check | Checks the PNR for errors just prior to ticketing | |||||||
| Epay Accounting and FOP Check *Safe Harbors* | 54301/55577/56135/56629/59912/65411/66102- - if total for Epay carrier in the SSR does not match the total in the relevant accounting lines, an error will be added and pnr will fail QC. Will also add error if FOP rejected by Epay Carrier in SSR. Override to bypass is 5H-EPAY CARRIER ON TICKET in case epay is being issued on an e-ticket with another carrier. | |||||||
| Stop Ticketing If Already Ticketed for Rescheduled at 4pm *Safe Harbors* | 81234-If ticket has already been issued before 4pm for bookings that had been previously scheduled to be ticketed again at 4pm. Halt ticketing. | |||||||
| Pre-Ticketing-Document Issued Remark Exists | Checks the PNR for errors just prior to ticketing | |||||||
| Pre-Ticketing-Add Error And Queue | This is run at the end. It takes all the RMQ remarks and adds them into an email and document PNR with Q remarks | |||||||
| Pre-Ticketing-Remove CAR/HOTEL Update Itin Remark | Remove this ITIN UPDATED FOR ACCOUNTING remark. Since it will be resent to accounting now that it's going through ticketing/invoicing | |||||||
| Quality Checks process | ||||||||
| Routine Name | Description | |||||||
| Update Segment Status (Amadeus/Sabre/Apollo/Galileo) | This updates KK segments to avoid errors at end transaction for Amadeus, Sabre, or Apollo air/hotel/car segments. | |||||||
| Add Airline Name Override To Passive Files | If fake carrier code beginning with X/Y/Z is used (i.e. YY, XX, ZZ, etc), Compleat will try and determine the CORRECT airline and add the passive airline override field A/YY IS <<airline name>> | |||||||
| Airline Auto Upgrade Stored Fare Restore (Sabre) | For Sabre bookings where th itinerary has changed due to auto airline upgrades resulting in ITIN CHG, the system will attempt to reprice the PQ. Agent reminder: PQ REFRESHED DUE TO PQ ITIN CHG | |||||||
| Branch Number Add *Safe Harbors* | 59346/71036/72870/73929 - If Creation Office ID = 08QF and DK begins with 00/12, then add/update rmk 5.S*BR12. If DK begins with 01/11/15/25/28/29, add or update rmk 5.S*BR1. **Skip routine if agent sine is from WV8J/W5VK as Gordian releases ownership to 08QF for some contracts** | |||||||
| Communications-Trip Start Add Remark* | If the agency wants ALL their PNRs using Trip Start module. This will add the required remark if missing T/USE TRIP START | |||||||
| BR12 Ministry Handling *Safe Harbors* | 65670-This routine adds certain elements based on 5.S*BR12 being present which indicates it's a Humanitarian/Ministry PNR. Elements added as 5H-LOGO-M | |||||||
| Concur Customer Number Update *Safe Harbors* | 53390-If Compleat sees CLIQMEETINGID-86850847 and DK is 0161860000, it will update DK to 0172470000 | |||||||
| Booking.com Hotel Segment Update *Safe Harbors* | 68366-Update booking.com passive segment. | |||||||
| Booking.com/Passive Hotel Segment Vendor Code Check *Safe Harbors* | 72911-Check Sabre CSL chains 7B, 7E, 7G, or 7H for 5.S*MSVC remark. 78864 - expand to all Passive Hotel segments | |||||||
| Customer Number Check *Safe Harbors* | 47203 - if DK does not match 5.S*AN adds mandatory error: DK DOES NOT MATCH 5.S*AN. PLS FIX AND REQUEUE | |||||||
| Populate PQR Response (Sabre) | This routine will populate issue *PQR and store the value in the property routine PQRResponse, which will be used later in the QC/Ticketing/Email process | |||||||
| Delete MS Line Before Invoicing *Safe Harbors* | 79523-Delete MS line referencing deleted segment before invoicing. | |||||||
| UATP Card Update *Safe Harbors* | 72444/82027-For bookings that do not have WN, and a UATP card is used specificed in 5Z#WN UATP-, this will change the FOP to the BTA card specified in 5Z#BTA- 82027. For customer San Manual, adds 5Y#COMPLEAT UPDATED FOP. This is used in routine SNM Ghost Card Verification *Safe Harbors* *** Must run before Credit Card Validation *Safe Harbors* *** | |||||||
| Credit Card Validation *Safe Harbors* | 63797-Fail booking if credit card is wrong based on the SSS list Credit Card Check (Multi/Reverse) | |||||||
| Get TravelScreen Info Car/Hotel (Apollo/Amadeus) | Captures the travelscreen information for the car and hotel and puts them in a property | |||||||
| Potential Fraud Booking Fail *Safe Harbors* | 65731-Fail all potentially fraudulent booking that are booked within 2 weeks of travel, DK0199990000 and international travel. | |||||||
| Remove PNEG From PQ *Safe Harbors* | 81624-Remove PNEG from PQ | |||||||
| Airline Add in A# Remarks for Southwest/Harbor Air | With these two airlines, Harbour Air/Southwest, you may not want to use their two character code for passive segment. This routine will look for XA passive air segment, and add the airline code/name to the A/ remark, which will be used in by the email process for airline carrier translation. The routine will add A/XA IS WN for Southwest Airlines A/H3 IS HARBOUR AIR for Harbour Air | |||||||
| Concur Queue Cancelled Bookings Cleanup *Safe Harbors* | 77103-If booking was previously cancelled, and it was requeued with live segments again, the routine remove existing ticket issued remarks, old PQ, FP lines. The system will look for this remark CB/CXL/PAX REQ CXL RESERVATION*2022-06-21 | |||||||
| Ticket Request Remark Add *Safe Harbors* | #47203. Adds the correct T remark to pnr based on itinerary. EG. If pnr contains all passive segments, 5H-T#INVB is added. | |||||||
| UDID Check for Duplicates *Safe Harbors* | 72388 - if multiples of a single Udid are found, that are identical, Compleat will remove the duplicates. | |||||||
| Remove TLG18 Pricing *Safe Harbors* | 80904-Remove TLG18 snap code if there is no ticket designator. | |||||||
| Add Car Direct Bill No To Billing Number Field BN *Safe Harbors* | 82914- Add Direct number to billing number field (BN) | |||||||
| Check Valid Stored Fare (Sabre) | Fail a pnr if there is an invalid PQ in the booking. | |||||||
| Name Field And Car BR Add *Safe Harbors* | 50903. Adds name field with contents of UDIDS. And also adds BR to car segments with contents of UDIDS. | |||||||
| Car Corporate Discount Number (CD-) Validation* | Checks all CAR segments. If CD exists, check for matching CD in category "C" remark list. If it does not appear in the remark list, check to see if the CAR segment contains any remark's CD. *Depends on internal lists to determine if error/reminder should be added. Override: Sabre - 5C#YVR 23FEB OK Amadeus - RMC/YVR 23FEB OK Apollo - @:5C/ YVR 23FEB OK Galileo - NP.C*YVR 23FEB OK | |||||||
| Car Rate Code (RC-) Validation* | Checks all CAR segments. If RC- exists, check for matching ID in category "C" remark list. If it does not appear in the remark list, check to see if the CAR segment contains any remark's RC-. Error Remark: MISSING RC-<<car comany>> <<rate code>> FOR CAR SEG X Override: 5C#<<location>> <<date>> OK | |||||||
| Car Special Instructions (SI-) Validation* | Checks all CAR segments. If SI exists, check for matching SI in category "C" remark list. If it does not appear in the remark list, check to see if the CAR segment contains any remark's SI. | |||||||
| Car Vendor Billing Information (BR-) Validation* (Amadeus/Sabre) | Checks all CAR segments. If BR exists, check for matching BR in category "C" remark list. If it does not appear in the remark list, check to see if the CAR segment contains any remark's BR. Only runs for Sabre and specific Amadeus agencies | |||||||
| Hotel Corporate Discount Number (CD-) Validation* | Checks all HTL segments. If CD exists, check for matching CD in category "H" remark list. If it does not appear in the remark list, check to see if the HTL segment contains any remark's CD. | |||||||
| Hotel Frequent Guest Number (FG-) Validation* | Checks all HTL segments. If FG- Not exists, check for matching . If it appears in the remark list, it's added to the hotel segment. If agent is only set to have reminder added, this will be added. MISSING FG- FOR HTL SEG X | |||||||
| Hotel Special Instructions (SI-) Validation* | Checks all HOTEL segments. If SI exists, check for matching SI in category "H" remark list. If it does not appear in the remark list, check to see if the HOTEL segment contains any remark's SI. | |||||||
| Add Car Vessel Name to BR Field *Safe Harbors* | 77673 Interlake would like to add the vessel name on National/Enterprise car direct bill invoice. take the information in the UD7 and put it in the BR- field of the car rental segment. DK2800200000. | |||||||
| Add CD to Car Segment *Safe Harbors* | #47203. If car segment does not have a CD, this routine adds one of Safe Harbors: ET XZBZ066 ZL XZBZ066 ZE 0317491 ZD T655600 ZI V007600 NOTE: must run before Car/Hotel Update Segment. | |||||||
| Car Add Direct Bill SI | Checks self service site's list QC Check -> Car Direct Bill SI to see if the customer has direct billing with car company. If it does, an SI is added to the car segment using the wording from the self service site. | |||||||
| Car Identification Number (ID-) Validation* | Checks all CAR segments. If ID exists, check for matching ID in category "C" remark list. If it does not appear in the remark list, check to see if the CAR segment contains any remark's ID. | |||||||
| Car/Hotel Add Agent's Hilton Rewards to SI- *Safe Harbors* | 74529 - add Agent's Hilton Rewards ID to the SI field of any hotels in the Hilton chain. | |||||||
| Hotel Add Direct Bill SI | Checks self service site table's list QC Checks -> Hotel Add Direct Bill SI to see if customer has direct billing with hotel. If it does, an SI is added to the hotel segment using the wording from the self service site. | |||||||
| Hotel Identification Number (ID-) Validation* | Checks all HTL segments. If ID exists, check for matching ID in category "H" remark list. If it does not appear in the remark list, check to see if the HTL segment contains any remark's ID. Error remarks: MISSING HI ID-23232323 FOR HTL SEG X SHOULD USE HI ID-2323232 FOR HTL SEG X Override: 5H#<<location>> <<date>> OK | |||||||
| Car Direct Bill Validation *Safe Harbors* | 60083-Add direct bill in this format CM1/CD-XVC4289/ID-D4G8RKR/GCAR16765376 | |||||||
| Hotel Fairmont Add SI- *Safe Harbors* | #77427 - Safe Harbors Add SI-FA109181 to YR/FA/SL (global) and SB/PU (North America only). Do not add if SI- already exists | |||||||
| Car/Hotel Update Segment | This takes the fields that are missing from the car/hotel and adds it to the segment (i.e ID,FT,SI-,CD- etc.) Errors added depend on the GDS response while updating the car/hotel segment: UN TO ADD <<data>> TO <<type>> SEG x Example: UN TO ADD CD121212 TO CAR SEG 3 UN TO ADD <<data>> TO <<type>> SEG xx THE RATE CAME BACK 0.00 WHEN DOING UPDATE UN TO ADD <data>> TO <<type>> SEG xx THE RATE IS HIGHER THAN WHATS BOOKED UN TO ADD <<data>> TO <<type>> SEG xx RATE CODE CHANGED AFTER APPENDING FQTV Sabre specific for hotel segment update: UN TO ADD <<data>> TO <<type>> SEG xx RECEIVED OX STATUS FROM HOTEL VNDR If GDS responds with an error while attempting to modify htl/car segment: SEE NEXT LINE FOR ERROR RESPONSE FROM VNDR <<vendorErrorResponse>> | |||||||
| Commission-Prepare For Commission Routines | Sets the validating carrier and selected stored fare properties. | |||||||
| Commission-Prepare For Commission Routines NEW * | Sets the validating carrier and selected stored fare properties. | |||||||
| UD7 Update From DP *Safe Harbors* | 53931-Add UD6 based on DP for accounts starting with 28 | |||||||
| Air Contract Remark Update *Safe Harbors* | 76562,77500-Update 5A# remark to include all alliance members to use the same TC. | |||||||
| Air Contract Check-Adjust A# for DL TLG17 Fares *Safe Harbors* disabled | 71699 - check A#DL- remarks. If doesn't include -SN, add -SNTLG17. If includes -TC, add -OS with TC code. If DL stored fare not priced with TLG17, add Error: MUST PRICE DL WITH TLG17 PRIVATE FARE CODE. Exclude 08QF bookings. *** Must run before Air Contract Check routines ***. | |||||||
| Air Contract Check-Adjust A# for UA TLG18 Fares *Safe Harbors* | 68779/69052/69402 - check A#UA- remarks. If doesn't include -SN, add -SNTLG18. If includes -TC, add -OS with TC code. If UA stored fare not priced with TLG18, add Error: MUST PRICE UA WITH TLG18 PRIVATE FARE CODE. Exclude 08QF bookings. *** Must run before Air Contract Check routines ***. | |||||||
| Add Email Address to UD30 *Safe Harbors* | 51993/69042 - If PE line contain email address with "TVLR", check if email already add to UD30. If not then, add email address to UD30. NOTE: must run before UDID Missing or Duplicated routine. | |||||||
| CC Holder Cannot Be First FOP *Safe Harbors* | 48638 - Card Holder cannot be the first FOP in the FOP field | |||||||
| Air Contract Check | If the customer has a negotiated air contract or a tour number needs to be added in the pricing, this information is taken from "A" remarks and added to the pricing information | |||||||
| Air Contract Check NEW | If the customer has a negotiated air contract or a tour number needs to be added in the pricing, this information is taken from "A" remarks and added to the pricing information | |||||||
| Address Lines Minimum 3* | Agency requires a minimum of 3 address lines. | |||||||
| Air Segment Status Code Check | If any air segments is found with an invalid status code UC,UL,PN, fail booking with the error STATUS CODE INVALID FOR AIR SEG X. Override A/PN OK | |||||||
| BA Seat OSI Add *Safe Harbors* | 54188-Add DTID.US9265AA to BA bookings. | |||||||
| Car Confirmation Number (CF-) Validation* | Checks all CAR segments for absence of confirmation number. Error Remark: CHECK CF- IN CAR SEG X Override all car segments: Sabre - 5C#CAR OK Amadeus - RMC/CAR OK Galileo - NP.C*CAR OK Override particular segment: Sabre - 5C#YVR 23FEB OK Amadeus - RMC/YVR 23FEB OK Apollo - @:5C/ YVR 23FEB OK Galileo - NP.C*YVR 23FEB OK | |||||||
| Car Dropoff City-Next Depart City Check* | Checks that the Car Dropoff City matches the next Air Segment's City. CAR SEG X DROP LOC. DOESNT MATCH NXT SEG DEPART ADD 5C#<<dropoff location>> <<date>> OK ..IF CAR CITY IS OK. Override Example: Sabre - 5C#YVR 23FEB OK Amadeus - RMC/YVR 23FEB OK Galileo - NP.C*YVR 23FEB OK " | |||||||
| Car Dropoff Date/Time-Next Air Depart Date Check* | Checks that the Car Dropoff Date matches the Next Air Segment's departure date. CAR SEG X DROP DATE DOESNT MATCH NXT AIR ADD 5C#<<location>> <<date>> OK ..IF CAR DATES ARE OK. If connecting more than 4 hours from next flight: CAR SEG X DROP TIME NOT WITHIN 4 HRS OF NXT AIR Override: 5C#<<location>> <<date>> OK Override example: Sabre - 5C#YVR 23FEB OK Amadeus - RMC/YVR 23FEB OK Galileo - NP.C*YVR 23FEB OK | |||||||
| Car Passenger Name Doesn't Match NM-* | Will send an email with the override required if the passenger Name doesn't match the NM- in the car segment. Will also add mandatory Q error. CAR NAME IN NM- DOESNT MATCH PNR. ADD OVERRIDE 5C#CAR <<location>> OK IF CORRECT. Override: 5C#CAR <<location>> OK | |||||||
| Car Pickup City-Prev Arrival City Check* | Checks that the Car Pickup City matches the previous Segment's City. Error: CAR SEG X PICKUP LOC. DOESNT MATCH PREV SEG ARRIVAL ADD 5C#<<pickup location>> <<date>> OK ..IF CAR CITY IS OK. Override 5C#<<pickup location>> <<date>> OK | |||||||
| Car Pickup Date/Time-Prev Air Arrival Date Check* | Checks that the Car Pickup Date matches the previous Air Segment's arrival date. CAR SEG X PICKUP DATE DOESNT MATCH PREV AIR ADD 5C#<<location>> <<date>> OK ..IF CAR DATES ARE OK. CAR SEG X PICKUP TIME NOT WITHIN 4 HRS OF PREV AIR Override: 5C#<<location>> <<date>> OK | |||||||
| Car Rate Missing or Zero | Checks all CAR segments for the rate. Adds error remark if rate is 0.00 or missing. Error Remark: CAR RATE IS MISSING OR ZERO FOR SEG X Override: 5C#<<location>> <<date>> OK | |||||||
| Car Special Equipment (SQ-) Validation* | Checks all CAR segments. If a spcl equip code exists in a "C" remark (SQ-xxxx). Checks to make sure all the car segments are using that code. If not adds error. Error Remark: MISSING OR INCORRECT SQ- FOR CAR SEG X Override: 5C#<<location>> <<date>> | |||||||
| Car Status Shows Not Confirmed* | if the car status does NOT show confirmed, adds error to the agent. Error Remark: CAR STATUS CODE SHOWS NOT CONFIRMED SEG X Override: C/CAR OK or C/<<pickuplocationcode> <<date>> OK | |||||||
| Car UC/IX Status After Update *Safe Harbors* | 76949-If car segment came back with UC/IX status, fail the booking. | |||||||
| Car Vehicle Type (VT-) Validation* | Look for C/VT-<<type>> remark and compare it with car segment vehicle type. If it doesn't match, fail the booking with the error PREFERRED VEHICLE TYPE IS <<type>> FOR SEG X Override: C/<<pickup location>> <<pickup date>> OK | |||||||
| Car/Hotel NEVER BOOK Error* | If a NEVER BOOK ON remark is found in the PNR, it validates to make sure these suppliers have not been chosen. If any have, an error is added Error Remark: DOES NOT WANT TO BE BOOKED WITH <<car company/hotel chain>>. PLS CHG Car Override: 5C#<<location>> <<date>> Hotel Override: 5H#<<location>> <<date>> | |||||||
| Child Travel Authority Needed | For international bookings, if a child travelling with only one parent, a notorized letter is required. Agent reminder: IF CHILD IS TRVLG W/ONE PARENT THEY WILL NEED NOTORIZED AUTH LETTER FROM OTHER PARENT | |||||||
| Commission-Calculation OLD | Verifies commission maintained in our generic commission list and updates commission or adds remark on the PNR with the correct amount. *Agencies responsible in notifying Compleat desk if any generic commission level changes | |||||||
| Commission-Calculation* | Verifies commission maintained in our generic commission list and updates commission or adds remark on the PNR with the correct amount. *Agencies responsible in notifying Compleat desk if any generic commission level changes | |||||||
| Concur Check for No Profile *Safe Harbors* | 65836. This routine sends email notification if the Concur pnr is missing a CLIQUSER or CB/GUEST remark. | |||||||
| Credit Card Expiration Check | Check TAW lines in unticketed PNRs. If credit cards expires before the ticketing date, fail the booking. Error: CC EXPIRES BEFORE TICKET DATE Override: CC OK | |||||||
| Delivery Address Missing | If no delivery address is on the PNR, adds error remark. | |||||||
| DIC AA Exchange Email *Safe Harbors* | 77280-Send email to the below emails for all new non-exchange Dialysis AA bookings. cyoung@safeharbors.com mwaldsmith@safeharbors.com tmahkovec@safeharbors.com | |||||||
| Duplicate Accounting Fields (TRAMS) | If more than one MS with the same number: DUPLICATE RM*MS NUMBERS. PLS FIX If more than one *OA: MORE THAN ONE <<GDSremarkType>>OA ACCOUNTING FIELD Sabre example: MORE THAN ONE 5.S*OA ACCOUNTING FIELD If more than one *SA: MORE THAN ONE <<GDSremarkType>>SA ACCOUNTING FIELD Sabre example: MORE THAN ONE 5.S*SA ACCOUNTING FIELD | |||||||
| First Name Missing | The FULL FIRST NAME is required on the ticket; not just the initial for international travel. If initial found, adds error remark: MISSING FIRST NAME IN NAME FIELD | |||||||
| Fix Incorrect Email Remarks | Some remarks contain "MAIL TO:" in them added by booking engines. This removes this invalid text. | |||||||
| FOP Override For Service Fee Reminder *Safe Harbors* | 73363. If there is a FOP override for service fee remark, a reminder is added: SERVICE FEE FOP OVERRIDE IN F# | |||||||
| Form of Payment Missing or TOO Many | All GDS: If there is no form of payment on the pnr, this error is added: MISSING FORM OF PAYMENT Amadeus: If there are passenger associated FOP’s but there isn’t one for each pax this error is added: MISSING FORM OF PAYMENT FOR A PSGR Sabre: If there are multiple 5- on the pnr this error is added: TOO MANY FORM OF PAYMENT FIELDS | |||||||
| FQTV Number Error | For agent bookings, if FQTV number comes back with invalid status (i.e. UN, PN, NO, etc), adds error remark Q/FQTV NUMBER IS SHOWING XX STATUS. PLS FIX. Override: F/FQTV OK | |||||||
| FQTV-Check Airline Partnerships* | Checks a database to see if the airlines on the PNR have partnerships with any FF numbers on file. If so, either adds to the PNR or adds remark | |||||||
| GP Field Check If Missing | This routine checks the self service site table Group Fields to see if a 5.S*GP is required. If customer is in table, and GP is missing or incorrect on pnr, a mandatory error is added. | |||||||
| Hotel Address Field Exists Check (Sabre/Apollo/Worldspan/Galileo) | Checks that All Hotel Segments have an address field for non Amadeus bookings. Error Remark: HOTEL SEG MUST INCLUDE HOTEL ADDRESS Override: 5H#<<locaiton>> <<date>> OK | |||||||
| Hotel Blacklist Check | Checks self service site table Hotel Blacklist against hotels on pnr. If any blacklisted hotels were booked, agent reminder is added to pnr and agent email notification is sent. Error Remark: FYI.HTL <<hotel name>> IS BLACKLISTED | |||||||
| Hotel Checkin-Prev Air Arrival Date Check* | Checks Hotel Seg and its previous Air Segment, unless ARNK or another Hotel Segment is encountered first. If dates do not match, an error is added. HTL SEG X DATE DOESNT MATCH PREV AIR SEG ADD 5H#<<location>> <<date>> OK..IF HTL CITY IS OK. PREV AIR SEG ARRIVE AFTER MIDNIGHT AND BEFORE 4AM PLS CHECK HOTEL SEG X CHECK IN DATE ADD 5H#<<location>> <<date>> OK..IF HTL DATES ARE OK. Override: 5H#<<location>> <<date>> OK | |||||||
| Hotel Checkout-Next Air Depart Date Check* | Checks each Hotel Segment and its next Air Segment, unless ARNK or another Hotel Segment is encountered first. If dates do not match an error is added. Error Remark: HTL SEG X DATE DOESNT MATCH NXT AIR SEG ADD 5H#<<location>> <<date>> OK..IF HTL DATES ARE OK. Override: 5H#<<location>> <<date>> OK | |||||||
| Hotel City-Next Air Departure City Check* | Unless separated by ARNK or Hotel Segment, check each Hotel Segment for the next Air Segment with a city code that does not match the city code of the Hotel Segment. HTL SEG X DOESNT MATCH NXT AIR DEPART CTY ADD 5H#<<location>> <<date>> OK..IF HTL CITY IS OK. Override: 5H#<<location>> <<date>> OK | |||||||
| Hotel City-Prev Air Arrival City Check* | Unless separated by ARNK or Hotel Segment, check each Hotel Segment for a previous Air Segment with a city code that does not match the city code of the Hotel Segment. Error Remark: HTL SEG X DOESNT MATCH PREV AIR DEPART CTY ADD 5H#<<location>> <<date>> OK..IF HTL CITY IS OK. Override 5H#<<location>> <<date>> OK | |||||||
| Hotel Confirmation Number (CF-) Validation* | Checks all HOTEL segments for absence of confirmation number. Error Remark: CHECK CF IN HTL SEG X Override: 5H#<<location>> <<date>> OK | |||||||
| Hotel Date-Next Hotel Date Check* | Checks that the next Hotel Segment after each Hotel Segment (If a next Hotel Segment Exists) matches the Date (Checkin->Checkout). Error Remark: HTL SEG X CHECKOUT DOES NOT MATCH NEXT HOTEL CHECKIN ADD 5H#<<location>> <<date>> OK..IF HTL DATES ARE OK. Override: 5H#<<location>> <<date>> OK | |||||||
| Hotel Rate Verification* | If it finds an H remark specifying hotel property and negotiated rate and rate wasn’t booked: USE CORP RATE OF <<negHotelRate>> FOR HTL SEG X If it finds an H remark specifying rate code (RC), and it’s available: NEG RATE FOR CODE <<rate code>> AVAILABLE HTL SEG X If rate code is not available: RATE CODE <<rate code> NOT AVAIL HTL PROPERTY <<hotel chain>> <<hotel property code>> | |||||||
| Hotel Status Not Showing Confirmed* | If a non passive hotel segment does not have one of these status codes, fail the booking. Error Remark: HTL STATUS CODE NOT CONFIRMED SEG X Override: Sabre – 5H#HOTEL OK Amadeus - RMH/HOTEL OK Apollo - @:5H/HOTEL OK Galileo - NP.H*HOTEL OK | |||||||
| LH Involuntary Change Check Endorsement | LH requires a specific reason for involuntary change in the endorsement. An endorsement such as "SKED CHG" is not acceptable. Compleat adds this reminder: POSSIBLE LH SKD CHG PNR. CHK ENDORSE EMAIL HAS BEEN SENT TO YOU W/DETAILS And sends email notification to agent with more detail | |||||||
| More Than 1 Employee On A Flight* | If there is MORE than the set number of employees from the same company on a single flight as set in the SSS, adds error and emails agent. NOTE: Agency must add entry to self service site table "More than 1 Passenger on a Flight" NOTE: some Agencies also send "Passengers on a Plane" info through to Booking Builder | |||||||
| Multiple Passport Check *Safe Harbors* | 62844-Fail bookings with multiple passport info. | |||||||
| Origin Doesn't Match Final Destination | Checks to see if the first departure city matches the last arrival city provided it is not a one-way trip. If the cities DO NOT match, it adds a warning remark | |||||||
| OTH/TOR Line Not Attached To Accounting Line (Sabre) | If the OTH/TOR line is not referenced to an accounting line, adds error remark: OTH/TOR LINE IS NOT ATTACHED TO ACC LINE | |||||||
| Passive Segment Status Incorrect (Amadeus/Apollo/Sabre) | If passive segments stored with the WRONG segment status (Amadeus PK, Sabre GK unless group PNR or Apollo BK) for invoicing purposes only, it adds a mandatory error: USE SEGMENT STATUS <<incorrectStatusCode>> IF BSP/ARC TICKET | |||||||
| PCC 08QF Check *Safe Harbors* | 70020/error if a PNR is in 08QF and either was not created in 08QF or not released to 08QF | |||||||
| Phone Numbers Missing* | If customer contact fields are missing adds error remark. Override is "PHONE OK". | |||||||
| Pre-Ticketing-More Than 10 Passengers *Safe Harbors* | If a non ARC booking with more than 10 passengers is queued to auto ticketing, fail with error: MORE THAN 10 PAX NOT ALLOWED QUEUE PNR TO 90 FOR REVIEW | |||||||
| Remove Duplicate 5.S*OA *Safe Harbors* | 84651- remove duplicate S*OA remarks | |||||||
| Required Email Address and Cell Phone *Safe Harbors* | 49214-Must enter email and cell phone for these accounts 017058|017111|017076|017092|017092 | |||||||
| Seat Not Booked or Confirmed | If seats not confirmed, adds error remark | |||||||
| Seat Selection Reminder AC/UA Codeshare | If the flight is an AC code shared flight operated by United, the agent needs to phone United to do seat selection. This routine adds a reminder remark. Agent Reminder: CALL UA 800-521-0810 FOR AC SEAT SELECTION | |||||||
| Southwest Tour Code to OSI *Safe Harbors* | Added Southwest tour code to OSI for all WN bookings, HK or YK. | |||||||
| Ticket Date is Past | If ticket request is past date, will add error remark | |||||||
| Ticket Request Field Missing | If the ticketing time limit field is missing, adds error | |||||||
| Ticketing Date After Last Date To Purchase | If a ticketing date after the last date to purchase, add a reminder: LAST DATE TO PURCHASE BEFORE TICKETING DATE | |||||||
| Ticketing Elements Check (Worldspan) | if more than 1 stored fare, 5-ER, 5-IT and 5-CM values need to be stored in a ticketing record. This will error the PNR if they exist | |||||||
| UD57 Required Based on Days to Departure *Safe Harbors* | 70668/71950/73253-UD57 (2 character code) required if departure is within # days. Checks list for customer number and number of days. Custom handling for DK 0153030000 validates UD57 is 7C, 7R, or 7U. Adds UD57 7A if outside 7 days. | |||||||
| UDID Missing Or Duplicated | Checks the self service site table "UDID Number Missing" for the required parameters. Adds error if missing or incorrect. Also checks for duplicate UDID fields. | |||||||
| Unused Ticket Against FOP or UDID *Safe Harbors* | 60544-Check Unused Ticket Against FOP or UDID | |||||||
| VIP Add Remark *Safe Harbors* | #50405-from an FTP upload, will check DK and name. If they are present, then add 5.S*UD5 VIP | |||||||
| Check if Passive Segment Carrier Code Added | If passive carrier code in segment is XI,ZZ,YY etc., checks to make sure there is a category "A" remark to translate into the carrier code. Sends agent email and PNR fails processing. | |||||||
| Check Change of Airport* | For those cities with multiple airports, will add a reminder if the traveller is travelling into one and departing another airport. Agent Reminder: ARRIVES <<ArrivalAirportCode>> / DEPARTS <<DepartureAirportCode>>..CHK IF CORRECT | |||||||
| Commission-Various Airlines Tzell/Generic *Safe Harbors* | 75643-Safe Harbors TZELL commission from the various airlines | |||||||
| Department Code Missing or Duplicated | Checks the self service site table "Department Code Missing" for the required parameters. Adds error if missing or incorrect. Also checks for duplicate DP fields. | |||||||
| Name Field Missing | Checks the self service site table "ID (Name) Field Missing" for the required parameters. Adds error if missing or incorrect. | |||||||
| Purchase Order Number Missing or Duplicated | Checks the self service site table "Purchase Order Missing" for the required parameters. Adds error if missing or incorrect. Also checks for duplicate PO fields. | |||||||
| Air Canada Upgrade | Sends email to agent to remind them to perform Air Canada upgrade based on U type remarks added to PNR by Consultant (Note: see Knowledge base article 185 in IssueTrak for details) | |||||||
| Air Segment Confirmation Check | If the airline rloc is missing on any BSP/ARC HK segment, add an agent reminder Reminder: MISSING CONFIRMATION NUMBER IN S1 | |||||||
| Commission-Alaska Airlines (AS) Domestic *Safe Harbors* | 69961,75667-AS commission for Safe Harbors | |||||||
| Commission-China Eastern Airline (MU) *Canada/US* | Generic China Eastern (MU) commission for Canada and US agents. | |||||||
| Commission-DL Domestic *Safe Harbors* | 63073/69053-DL Domestic commission | |||||||
| Commission-DL/AF/AZ/VS/AM/KL AC404, 479, 512, 787 *USA* | 77235-Adds DL/KL/AZ/AF/VS/AM commission to applicable pnrs. with AC404, AC479, AC512,AC787 | |||||||
| Commission-Ethiopian Airlines (ET) *Safe Harbors* | 65552-Add Ethioipian Airlines commission for Safe Harbors | |||||||
| Commission-Jet Blue (B6) *Safe Harbors* | 81246 - Domestic and International commission for Jet Blue | |||||||
| Credit Card Number Suppress on Invoice (Sabre) | If the credit card number has not been suppressed, it will update number | |||||||
| Credit Card Required in SSR for Epay | Add credit card in the SSR for epay carriers NK, JB, F9, MO if it is missing. | |||||||
| PSPT Check if Existing SSRs Match Passengers* | Validates all the SSR DOCS and checks to make sure the passengers associated to the SSR matches the name. This error would only be made by manually added SSR DOCS. Error Remark: SSR DOCS PAX ASSOC DOESNT MATCH NAME PAX Override: 5P#TSA OK | |||||||
| Commission-AA/BA/IB/JL/AY Transoceanic 2023 *Safe Harbors* | 81770-Adds applicable commission according to contract rules for AA/BA/IB/JL/AY/EI. | |||||||
| Hotel Guarantee Check | Checks to see if a guarantee has been applied to a non passive hotel, if not, adds a reminder. Agent Reminder: NO HTL GTEE FOR HTL SEG X | |||||||
| Account Number Missing or Invalid* | If the account number is missing or invalid an error remark is added Error Remark: MISSING ACCOUNT NUMBER | |||||||
| Medical Insurance to Cuba Remark Missing | All travelers now require medical insurance to travel to Cuba. If no insurance segment on pnr, then a mandatory error is added. Agent can override with remark: RMI/INS NO 5R#INS NO @:5R/INS NO | |||||||
| Add UD55 if No Hotel Booked *Safe Harbors* | 69639 - add UD55 HX to all pnrs without an overnight stay, which have either same-day return, or one-way flight, or one day car rental ** must run before IRO UD53 and UD54 Validation *Safe Harbors* | |||||||
| Check if Any International Segment *Safe Harbors* | 53664/63303/70324-Checks if any International segment on PNR (excluds CA & mX). If int'l segment and validating carrier is DL/KL/KQ/AF/BA/OS/LX/AC/AZ/UA/LH/AA/IB/S, fail ticketing and email to agent if during operating hours. Only runs if 5.S*UD64 NGO is present. Override is 5T#FARE CHECKED. | |||||||
| Add AA IT to OSI *Safe Harbours* | Finds IT number in A# for any AA HK segments incl codeshare and add IT to OSI field | |||||||
| Air Canada Rouge Notification | Will add an agent reminder that when an Air Canada Rouge flight is booked. Reminder: AC ROUGE FLTS BOOKED ENSURE CLIENT AWARE | |||||||
| Billing Address Missing | If no address is on the PNR, adds error remark: BILLING/DELIVERY ADDRESS MISSING For Canadian agencies, all processing will stop if address is missing, as there is no way for the system to determine taxes for service fee without the address info. Override: ADDRESS OK | |||||||
| Booking.com Send Notification *Safe Harbors* | 72911-Send notification to compleat@safeharbors.com every time a booking with 7B gets booked. | |||||||
| Car Policy Check* | Will validate against values on the self-service site's list QC Checks -> Car Policy Check to see if the approved vendor, car size, or acceptable rate amount is used. | |||||||
| Check For CLIQCID If CLIQUSER Remark On PNR *Safe Harbors* | 69148/76319-If 5.CLIQUSER- remark is present, there must be a 5.Z*CLIQCID- remark. Mandatory fail if missing and stop ticketing for online bookings. | |||||||
| Check if Corporate DK Used *Safe Harbors* | 60929 - If VI4807xxxxxxxxx885923 is use, an error remark to be added "MUST USE CORP DK FOR PFSCM" | |||||||
| Check Name On PQR *Safe Harbors* | 68964,79382-Check name in pnr matches name in PQR, unless MCO is used. Add error if mismatch. Error: EXCHANGE TICKET DOES NOT MATCH PASSENGER NAME CHANGE OK WAIVER CODE *CODE* Override: 5H-NAME CHANGE OK WAIVER CODE <<CODE>> | |||||||
| Check UD53 for Car Size *Safe Harbors* | 49423/57333-Checks SSS to see permitted car types for customer. If different car size was booked, mandatory error is added. Agent must add 5.S*UD53 with YP, YG, CP or CG in order to get QC pass. | |||||||
| Churned PNR Check | Will check the PNR to see if any citypair has been churned MORE than once. If so, will send a notification to the agent and any additional configured CC email addresses | |||||||
| Clean Orphaned TRAMS Remarks (Amadeus/Apollo)* | #41298-From Trams agencies, if there are any remarks that do not have a master remark number, they are removed. | |||||||
| Compare Original Ticket PCC with Current PCC *Safe Harbors* | 76811-Compare original ticket issuing pcc with current PCC and if they do not match, fail the booking. | |||||||
| Delta/American Bag Transfer Reminder | DL/AA do not have an interline agreement. This routine will check for connecting flights between AA/DL and, if so, will add itinerary remark and agent reminder that pax will have to transfer own bags. Reminder: FYI..DL/AA ON SAME LEG. MUST TRANSFER OWN BAGS Itinerary Remark:YOU MUST TRANSFER YOUR OWN BAGS BETWEEN AMERICAN AND DELTA | |||||||
| DK less than 10 digits *Safe Harbors* | 54386 - Email agent and implementation@safeharbors.com if DK is not 10 digits | |||||||
| Duplicate PNR Check | Checks for duplicate PNRs and returns an email. Uses SSS settings | |||||||
| Error PNR's with Check or Cash FOP *Safe Harbors* | 63887 - Error any PNR with Check or Cash as FOP. Error is "MERCHANT REQUEST REQUIRED FOR {CASH|CHECK} FOP / ADD 5H-FOP CHECK- REMARK WHEN COMPLETED". Override is 5H-FOP CHECK-(FREEFORM)" | |||||||
| EU Banned Airline List *Safe Harbors* | 60947- add error if any airline on the EU Banned list is found in pnr. 74019 - updated list to Self Service Console for Agency to maintain | |||||||
| Fail DK 0173410000 unless Exchange *Safe Harbors* | 70907 - Fail any pnr for DK 0173410000 unless it is an exchange. Error: TBI NO LONGER A CLIENT. REFER TO ASHLEY KIEN AT TBI Override: 5H-TBI OK | |||||||
| Fail O2 Air Bookings *Safe Harbors* | 67863-Fail all bookings that contain O2 segments with "O2 IS AN AIR TAXI SERVICE-DO NOT BOOK" **Also on for TravelQuest** | |||||||
| Fraud Check *Safe Harbors* | 76972-Check SSS list Fraud Check Criteria and determine if booking has failed fraud check. Q#POSSIBLE FRAUD-CHECK PASSPORT-OVERRIDE 5H-NOT FRAUD Override (Sabre) 5H-NOT FRAUD (Worldspan) 5.ZNOT FRAUD | |||||||
| Hotel HOD 168978 Notification *Safe Harbors* | 76388 - if HOD 168978 (JW Marriott Marquis Hotel Dubai) booked, send email notification to hotelprepay@safeharbors.com, as hotel doesn't accept US cc | |||||||
| Hotel Policy Check* | Will validate against values on the self-service site's list QC Checks -> Hotel Policy Check to see if the approved vendor, preferred hotel property, or acceptable rate amount is used. | |||||||
| Hotel Prepay Queue *Safe Harbors* | 57974 - Queue bookings with prepay hotel to Q360 for specific customer numbers | |||||||
| MaxMind Fraud Check *Safe Harbors* | 68936-Call webservice to Maxmind to determine if it is a fraud booking. | |||||||
| NDC Fare Check Notification *Safe Harbors* | 84404-all AA (no OA space) that is NOT an exchange to send an email to ndc@safeharbors.com one time. We only want to generate one email per PNR please. We will need an override of 5H-DO NOT BOOK NDC subject: CHECK NDC FARES <PNR.RECORDLOCATOR> Body: check NDC fares for pnr <pnr.recordlocator> | |||||||
| Online Booking - VPay Hotel Cancellation Check *Safe Harbors* | 71167 - if 5H-SVP\*\d{2} DEPLOYMENTID \d{2,} DEPLOYED and no active hotel exists in an Online booking, email cyoung@safeharbors.com | |||||||
| Porter Airlines Passive Segments (Sabre) | If using code "PD" in Sabre with passive segments, it could result in a debit memo. The agent and administrators will be notified to update the PNR | |||||||
| PSPT Known/Redress Passive Booking Reminder | If PPT remarks exist for known traveller or they have a redress number, will remind the agent on a passive booking to give to the airline | |||||||
| Qantas Business Rewards Number Add/Validate | If the PNR has QF air segments, check the Self-service table for a Qantas Business Rewards number then validate if it's been added in SSR. If not, add correct number or error to agent if incorrect. NOTE: Currently only programmed for Galileo/Amadeus/Sabre; Tramada agencies should be able to add these to the customer profile in the CRS text area | |||||||
| Queue NDC Opt-In AA Booking to Q110 *Safe Harbors* | 79412-Queue all bookings with 5F#NDC-OPTED IN bookings to Q110 for agent to check NDC fares. | |||||||
| Send Profile Move Error Email *Safe Harbors* | 48866 - If it an online booking and contain Profile Move Error remarks, generate a simple email to ESUPPORT@SAFEHARBORS.COM and add REMARK 5X#PROFILE EML SENT | |||||||
| TAR Close - Add NO TAR Reminder *Safe Harbors* | 67730 - if CLOSE TAR remark is found, add reminder to Agent to add 5Y#NO TAR-(reason) if auth is not required | |||||||
| Verify Customer Number *Safe Harbors* | 49532-Check if DK entered as 000000000 or S*AN entered as S*AN000000000. If then add an error remarks "DK 000000000 IS NOT VALID. PLS UPDATE" | |||||||
| Net Fare Check For Price Up *Safe Harbors* | 47839-This routine checks if *PU (price up) is missing when stored fare is a net. If missing, mandatory error is added: NN PU IN PQ. IF NO MARKUP ADD 5H-NO PRICEUP | |||||||
| GIVE.com Email Domain Error *Safe Harbors* | 79707-Any email address that ends in GIVEMAIL.COM in the PE field or in the CTCE field needs to halt ticketing and error. | |||||||
| Hotel Prepaid *Safe Harbors* | 51101-Send email to different email safe harbor addresses depending on time of day for hotel prepay. Additional tasks: 51718 / 53043 / 59984 / 60509 / 61358 | |||||||
| Queueing process | ||||||||
| Routine Name | Description | |||||||
| BA Passive Future Queue And Reminder *Safe Harbors* | 72188-Routine will future queue to the agent 24 hours before departure and send an email for BA passive bookings. 79129-Added HA 82377-Added AA | |||||||
| Concur Ancillary Items Need Issuing *Safe Harbors* | 56510-Send a notification to esupport@safehabors.com if ancillary services exist. | |||||||
| NON BSP-Remove RMV Lines | To update PNRs so they use the new logic to buidl accounting for ALL existing RMV lines, older PNRs will need their RMV lines removed | |||||||
| Queue Hotel Booking to Q360 *Safe Harbors* | 55683-Queue hotel bookings for certain account to Q360. | |||||||
| Queue PNRS From Apollo Accounts *Safe Harbors* | #53893-All PNRs queued for QC with customer number beginning with 28 are queued to 1P3F/445, DK beginning with 99 or 15 are queued to 446. DK beginning with 29 goes to 447. | |||||||
| Queue PNRs not Passed QC *Safe Harbors* | #47203-all PNRs not passed will be queued to 1P3F/450 | |||||||
| Remove StoredFare Temp Remarks | Temp remarks are built to use when refreshing the stored fare. These contain commission, snap code etc. | |||||||
| Concur Exchange Ticketing Queue *Safe Harbors* | 54292-Check to see if it is a Concur booking and if it needs to be exchanged. | |||||||
| Concur Exchange Queue To Magnatech *Safe Harbors* | 62458-Queue booking to Magntech Q305 for Concur exchange bookings. | |||||||
| Concur Southwest Exchange Queue *Safe Harbors* | 57575-Drop Concur WN exchange to queue 304 and add a reminder | |||||||
| Car/Hotel Update Accounting Schedule* | Schedule pnr to issue DIT in Sabre, BT in Amadeus, HBDIDJD in Apollo, or EZNI command in Worldspan off queue if car/hotel segment has been added,updated, or cancelled. | |||||||
| Concur Approval Q92 Remove *Safe Harbors* | 60612-Remove booking from Q92 after ticketing | |||||||
| Concur Queue PNR *Safe Harbors* | #48371-if contains CLIQID, the PNR needs to be queued to 200 for TMC Messaging and TripIt 75467-For Gordian, if BLK accounting exists, do not queue to Concur. An email will be send to manually store PQ using PU format. 78884-Knorr bookings get qeuued to Q220 | |||||||
| NDC Pnr Capture | 79412-Send XML for NDC bookings. | |||||||
| Add Priority Remarks After Compleat Processing (Amadeus/Apollo) | Add priority remarks for Amadeus/Apollo bookings after processing | |||||||
| Queue From Agent Queue Properties | Takes the information added in the QFlag List and either queues to the agent or just ends the PNR | |||||||
| Queue to Risk Management Company | Queues PNRs to Risk Management Company based on SSS table list Misc -> Queue To Risk Management Settings. | |||||||
| Queue Place - Grasp | Will queue place the PNR for Data Push to Grasp | |||||||
| Reports process | ||||||||
| Routine Name | Description | |||||||
| Ticketing process | ||||||||
| Routine Name | Description | |||||||
| PCC 08QF Check *Safe Harbors* | 70020/error if a PNR is in 08QF and either was not created in 08QF or not released to 08QF | |||||||
| Ticketing - Apollo | Main routine for Auto-ticketing | |||||||
| Ticketing - Sabre | Main routine for Auto-ticketing in Sabre. | |||||||
| Ticketing-Remove Old Fee Type Accounting *Safe Harbors* | 77781-Remove old MS TT accounting line for service fee. | |||||||
| TAR Airline Immediate Ticketing Schedule for Approval | Runs only for TAR bookings. If the carrier requires ticketing within 30 minutes, the booking will have just been ticketed. This will now schedule for approval like an ePay | |||||||
| Retention Segment* | Captures the travel date and the last segment date used to calculate a retention segment to keep the PNR live. | |||||||
| Passed QC Override Remove | Will remove the QC override if it exists after it's gone through ticketing or invoice/email. That way any future modifications to the PNR will not be overidden with a previous authorization | |||||||
| Ticketing-Schedule for Email | Schedule the Communications workflow | |||||||
| Web Check In Email process | ||||||||
| Routine Name | Description | |||||||
| Web Check In-Check If Unsubscribe | This process goes to the database to see if this customer Unsubscribed from the web check in emails. If so, process stops | |||||||
| Web Check In-Skip For Branch *Safe Harbors* | 73319-Anything not BR 1, 5, 6,7, 10, 11 or 19 will not have any web checkin email. | |||||||
| Web Check In-Add Email To PNR/Profile* | Will see if an email address can be matched from the PNR and added to the profile | |||||||
| Web Check In-Remove EMAIL CHECKIN Remark | If customer is in the "Web Check-In Email Unsubscribe" table on the self-service site, ensures the EMAIL CHECKIN remark is removed | |||||||
| Web Check In Email | Sends an email for the air leg and schedules the next airleg for checkin | |||||||