Oracle Hospitality Cruise Shipboard Property Management System Data .

ETable NameCommentsECATable stores Shore Excursion variable cost setting in Bookable TourECCTable stores Tour custom comment setupECOTable stores Shore Excursion cost (Table Not Being Reference within SPMS modules)EDTTable stores Emergency DutyEFCTable stores Shore Excursion fixed costEFFTable stores Crew effects informationEFTTable stores Malaysian Manifest transfer interface purposes (NOT USED as IFC does not exist)EONETable stores EONE incoming messageEONEERREOne table that store the error response from eOne for those eoneout messageEONEOUTEone Outgoing MessageEONEWSStore the eOne employer number which need to request picture from WS, this is use only when the FMSWS is offlineEPLANThis table store the eone emergency plan history, this table is only for display purpose, all field is directlymap from the eone XML.EPOTable stores Shore Excursion booked tour informationEPWTable stores Shore Excursion waitlisted booking informationESCTable stores Shore Excursion variable cost setting in tour templateESETable stores Shore Excursion Bookable tour settingESGTable stores Shore Excursion multiple groups per tour assignmentESLTable stores Shore Excursion tour package linkingESPTable stores Shore Excursion package settingESTTable stores Shore Excursion Tour template settingESVTable stores Shore Excursion tour vendor linkingETLTable stores Tour Tickets Language templates setupEVATTable stores the VAT Department split setup for tourEVEAPRTable stores Event approvals.EVEAPR NOTETable stores Declined Request note.EVEBOOKTable stores all the details of the event booked.EVEGRPTable stores the links between the booked events and group/passenger account IDsEVEITBTable stores all the request Event items/amenities for the eventEVEITB NOTETable stores Event items note.

EVEITMTable stores all the required Event items/amenities for the eventEVEITPTable holds the price for corresponding itemsEVELOCTable stores all Event function rooms used for eventsEVELOC IMGThis table holds the event location imagesEVELOC LIMITTable stores minimun and maximum guests for each location setup typeEVENOTETable holds the events noteEVEPKGTable hold a collection of items that are sold together for a fixed price or to make it easier to add to anevent.EVEPKGITMTable contains event package items.EVLTable stores itinerary setup for the event.EVTTable stores all Events setup detailEXJTable stores Currency Exchange posting history

FTable NameCommentsFAMTable stores Micros Family Group (data copied via IFC Advances Micros)FCCMSMSGSTable stores CMS-SPMS Synchronization MessageFCRTable Not Being Reference within SPMS modulesFCTTable stores Safety Drill Survival Craft command positionFGLTable holds the assigned values for a specific Fidelio Account and GL field; Displayed on the Credit Deptsetup in FC AdminFLXTable stores Comment Card flex field setupFPLTable stores Foreign Port List for IFC ENOAD

GTable NameCommentsGCDPTable stores Gift Card Eligible Department in SPMS DepartmentGCDTTable stores Gift Card master record (Like to GCDT ACC ID UXP A ID)GCELTable stores Gift Card Eligibility setup itemsGCRCTable stores Gift Card Eligible in Micros Revenue CenterGCTTable stores Guest Categories and Package Plans information, each per guestGCTPTable stores Gift Card Template setup detailGENTable stores General Assembly TrackingGFTTable Not Being Reference within SPMS modulesGHITable stores Guest Reservation history detail (generated upon guest check out)GHXTable stores Passengers past history from different fleet (for FMS Project)GHX ADDRESSTable stores Direct Mapping of FMS Guest Address HistoryGHX BOOKINGS DETAILSTable stores Direct Mapping of FMS Guest Bookings HistoryGHX COMPLAINTSTable stores Direct Mapping of FMS Guest Complaint HistoryGHX IDENTIFICATIONTable stores Direct Mapping of FMS Guest Identifications HistoryGHX MICROS ITEMTable stores Direct Mapping of FMS Guest Micros Item HistoryGHX PASSENGERTable stores Direct Mapping of FMS Guest HistoryGHX PORTSTable stores Direct Mapping of FMS Guest Ports HistoryGHX POSTINGSTable stores Direct Mapping of FMS Guest Postings HistoryGHX REQUESTSTable stores Direct Mapping of FMS Guest Request HistoryGHX TRANSACTIONSTable stores Direct Mapping of FMS Guest Transactions HistoryGLFTable holds generated GL filesGLGTable stores Gangway activity log detailGLVTable holds the acceptable values for each general ledger field - GL Account Value(upon PAR - General - Unlimited GL Y)

HTable NameCommentsHAPTable stores the home airport informationHASTable stores Housekeeping task assignmentHBATable stores the roll over amounts per voyage for Hotel Bar Service Charge calculationsHBBTable stores Service Charge Manual AdjustmentsHBDTable stores Hotel Bar Service Charge Department ListHBETable stores Hotel Bar Service Charge EntitlementHBGTable stores Service Charge percentage breakdown of the remaining balance (gross net) for servicecharge collectedHBMTable stores Hotel Bar Service Charge Mid Cruise TotalHBOTable stores Service Charge overridden default service charge pointHBPTable stores Hotel Bar Service Charge ParameterHBSTable stores Hotel Bar Cruise SegmentsHBTTable stores HAL Hotel Bar Service Charge TotalHCLTable stores Cabin or Location linked to Housekeeping SectionHCTTable stores Housekeeping cleaning task by cleaning statusHDTTable stores Harbour Definition for Universal APISHISTable stores Guest reservation history (data generated by Shore Side. Data Not Being Display withinSPMS modules)HKSTable stores Housekeeping section recordsHOLTable stores holiday date that linked between Payroll and Time Attendance(data generated by Shore Side. Data Not Being Display within SPMS modules)HPOTable stores Service Charge points per position and its validityHSATable stores Homeland Security Agency for Universal APISHSCTable stores main Housekeeping sectionsHSTTable stores Homeland Security Country for Universal APIS

ITable NameCommentsIFDTable stores Instructor for Drill DefinitionIMAGESTable stores all images and icons used by FMSIMPSETTable stores all the data import file structure setupINVTable stores Portuguese Tax Invoice Control tableIPCTable stores Interface Paycode setupIPMATable stores the In Port manning assignments to crew members at each port/tenderIPMCTable stores the minimum In Port Manning Compliance setup at each port or tenderIPMSTable stores the scheduled crew members for IPM duties for each cruise dateITMTable stores missing item in Amenity setup (Table Not Being Reference within SPMS modules)

KTable NameCommentsKEYTable stores Portuguese Private Key, Biggest KEY ID will be the Active KeyKPQTable stores 3rd Party App Ticket printing queue, the printer mapping to KPQ SOURCE is store inTYP KPQ

LTable NameCommentsLAUTable stores QCI customized layout for user access informationLAYTable stores QCI customized layout recordsLBOTable stores Payroll Longevity Bonus based on Seniority LevelLEGTable stores RES Online overland and overnight tour infoLELTable stores POS Discount Eligible setup detailsLFDTable stores Location for Drill DefinitionLGVTFROMSPMSTable stores Payroll Longevity Info from CMSLJKTable stores Life jacket setup tie with cabinLLGTable stores Logical LEG recordsLOCTable stores Location setup info under Itinerary SetupLOETable stores location exceptions info in Itinerary Location setupLOGTable stores System Activity logLOOKUPTable stores various categories used for setupLOPTable stores Child locator recordsLTPTable stores POS Discount Template setup detailsLYTTable stores loyalty discount rate detail

MTable NameCommentsMAJTable stores Micros Major Group (data copied via IFC Advances Micros)MAPTable stores ResOnline mapping dataMDATable stores Minor Disembarkation AuthorizationMDKTable stores Emergency Station DeckMFZTable stores Emergency Station FireZoneMGDTable stores Minor Guardian InformationMIBTable stores Micros bill imageMICTable stores Micros Item Posting RestrictionMIMTable stores Micros Menu Items (data copied via IFC Advances Micros)MITTable stores Maintenance items setupMLCTable stores all previously held safety numbers by each crew memberMLSTable stores the scheduled planning for safety functions assigned to expected crew membersMOBTable stores Mobile Device synchronization informationMPQTable stores the work order print queue (print via IFC Print Work Order)MSDTable stores Emergency station sideMSETable stores Muster station drill error info (Remark: Not available for data input; View from Muster Stationsetup)MSGTable stores Guest Message InfoMSQTable stores FCUI Message Queue, this is store the interface message for PBX, ITV, Dining, instead ofsending via TCP, we store in the DB, depend on PARMSTTable stores Muster station list and their detailsMUSTERLOGTable stores Mustering LogMWATable stores Maintenance work order for worker assignmentMWITable stores Maintenance work order items assignedMWLTable stores Maintenance activity logMWPTable stores Maintenance Work Order Additional ImageMWRTable stores Maintenance work order requestMWWTable stores workers setup for Maintenance workplace

NTable NameCommentsNDTTable stores ENOAD update Notice detailNFPTable stores Connected Foreign Port To Observing Country recordsNFUTable stores the notification from Vision Online Door Lock System

OTable NameCommentsODITable stores Operational department extensionOLOTable stores Statistic Viewer for OLAP ViewerOPGTable stores all Crew's Operational groupOPOTable stores all Crew's Operation positionORGTable stores all Muster List Plan which includes safety department, safety position, safety number etc.

PTable NameCommentsPAATable stores Crew approval records to deduct onboard charges from payrollPARTable stores all SPMS system parameterPASTable stores summary of HBT posted into PayrollPATTable stores Payroll's pay allotments (BANKS, TAX AGENCIES, ETC.)PAYTable stores all Crew members pay details holding all calculated pay recordsPAYANDDEDTable stores Pay Addition And Deduction Info from CMSPAYDEDCATTable stores CMS Paycode CategoryPAYPOINTTable stores PayPoint reconciliation reportPAYROLLSEAWIRETable stores Payroll SEAWIRE info from CMSPAYROLLSEAWIREDETAILSTable stores Payroll SEAWIRE details from CMSPBXLOGTable Not Being Reference within SPMS modulesPBXTRKTable Not Being Reference within SPMS modulesPCDTable stores Panama Canal ADR file creation detailPCOTable stores Panama Canal Port List for IFC ENOADPCPTable stores Panama Canal ADR setup detailsPCYTable stores Payroll Company informationPDATable stores Passenger Debarkation Assistant detailsPDFTable stores Shore Excursion E-Invoices PDF filesPDTTable stores Gratuity Pool Distribution (Table Not Being Reference within SPMS modules)PEDTable stores Pin Entry Device IP used by which application and workstationPERSONTable stores Payroll person detail from DGS CMSPERSONEVENTSTable stores PERSONEVENTS from CMSPERSONPENSIONPLANTable stores Pension PlanPERSONPPDETAILSTable stores Pension Plan Optional ContributionPERSONPPOPTOUTTable stores Pension Plan Opt-OutPERSONWIRECURTable stores PERSONWIRECUR from CMSPETTable stores Personnel EventPGDTable holds summarized Payroll GL Interface amounts for purpose of multiple export file formatPGETable holds customize Payroll GL Interface export format

PGIDTable stores Pregenerate Random numberPGLTable stores Payroll General Ledger creation summaryPLGTable stores paging system logs for Paging InterfacePNRTable stores Non Refundable Credit department setupPOATable stores details items that sold in one posting. Linked to POS.POS ID (Used by NIWUS PBXInterface)POMTable stores trigger records about posting voiding and adjustment (Mainly for reporting purpose)POSTable stores all posting recordsPOSITIONTable stores Position Info from CMSPOTTable stores total posting per each cruise day (insert upon system date change)POXTable stores special processing records for various purposes kind of like TYP table but without limitations(CHAR) of TYP table, more columns may be add later on.PPATable stores actual department selected by the passenger for flex package planPPAITable stores Package Plan Micros Item Quantity for flexi packagePPCTable stores cruise itinerary detail for ship via Data Import (Table Not Being Reference within SPMSmodules but in Data Import)PPDTable stores Package plan setup per cruisePPITable stores Package plan template item setupPPNTable stores Package Plan for cruise setupPPNITable stores Package Plan Micros Item by QuantityPPNRTable stores Micros Revenue Center eligible for the packagePPPTable stores Package Plan assign to passengerPPSTable stores pre cruise posting recordsPPTTable stores Package plan template setup detailsPPTITable stores Package Template Micros Item by QuantityPPTRTable stores Micros Revenue Center eligible for the packagePRDTable stores Promotion detail setupPROTable stores Promotion group setupPRPTable Not Being Reference within SPMS modulesPRSTable stores Payroll pay raise detailsPRTTable stores Promotion target guest list who is eligible for the promotion (upon running IFC Promoter)PSGTable stores Payroll Signature DataPSLTable stores Port State List for United States of America for IFC ENOADPTDTable stores Positions for Drill Definition table

PTGTable stores PGE posting status for Payroll GLPVFTable stores Persistent Visionline Function

QTable NameCommentsQCITable stores Ship and Shore synchronize and updates in offline quick check in

RTable NameCommentsREOTable stores data temporarily for production of special reportsREPTable stores all Report filesREQTable stores required courses and certificates for each safety positionRERTable stores required courses/certificates for each operational positionRESTable stores all accounts (passenger/crew/visitors/groups) reservationsRESERVATION MSGSTable stores ResOnline reservation messagesRETTable stores all future account reservationsRFIDTable stores RFID Information require for encodingRIPTable tracks number of licenses allowed for external connections to interfaces (i.e. FCUI and Data Importconnection)ROTTable stores Routing instructionsRQSTable stores requirement for substitution coursesRSDTable stores update details for ResOnlineRSFTable stores ResOnline viewer field mappingRSLTable stores ResOnline update logRSOTable stores International Ship Security Certificate RSO for IFC ENOADRSPTable stores ResOnline response messageRSTTable stores Restaurant dinning assignment (Used with SilverWhere)RSUTable stores ResOnline user field customization (Record exists mean hide)RSVTable stores ResOnline user define viewRTSTable stores ResOnline transactions statusRURTable stores DGS CMS Pay record uploaded to registerRVCTable stores Micros Revenue Center

STable NameCommentsSAGTable stores user definable security alert setup informationSAPTable stores Medical quick posting recordsSASSalary@Sea PostingSCATable stores Certificate Management Agency List for IFC ENOADSCDTable stores System Cruise Days informationSCHTable stores SPMS Crew SchedulingSCHEDCOSTCNTRTable stores Payroll Scheduled Assignment History Cost Center from DGS CMSSCHEDDTLSTable stores Payroll Scheduling Details from DGS CMSSCLTable holds Cruise Classifications (Table Not Being Reference within SPMS modules)SCMTable stores status change management of drill schedulingSCRTable stores Cruise itinerariesSCSTable stores Sail Cabin Assignment at the Point of SYNSCTTable stores Supported Document Type for E-BorderSCVTable stores System cruise visa requirements (which nationality requires which visa)SDDTable stores all Payroll pay code specific detailsSDETable stores Crew safety drill excuse schedule informationSDRTable stores SPMS Audit Trail for DeletionSEATable stores Port Management Season PricingSECTable stores all Passenger/Crew/Visitors photosSEDTable stores all Payroll pay code detailsSEVTable stores Micros Service ChargeSEWLOGTable stores error message from IFC SeawareSEWLOG XMLTable stores request and response Seaware XML APISGLTable stores Paycode GL variationSGRPThis table contains sub group information.SGRPDThis table contains sub group delegates information.SGTTable stores Payroll Pay Group Contract Template detailsSHIPTable stores Ship Info from CMSSIBTable stores Multiple Barcode for Medical Item

SIGTable stores Signature captured for credit cardSIRTable stores SPMS Audit Trail for insertionSITTable stores Medical sales itemsSLBTable stores Loyalty Bonus based on Seniority LevelSLDTable stores all Shore leave denied recordsSOLTable stores Cruise Operation Activities LogSPATable stores SPA Appointments and Reservations to holds information for all bookings, postings andblocked time for the systemSPBTable stores SPA Packages/Combos to holds the top level definition for a Package or CombinationSPCTable stores Spa Crew Therapy LinkSPDTable stores Payroll's contract detailsSPDPTable stores SPA Discount Periods Setup infoSPDPLTable stores SPA Retail and Therapies Item assigned to Discount PeriodsSPETable stores Spa Therapy Equipment LinkSPGTable stores Spa Generic SchedulesSPHTable stores SPA Therapist Extra InformationSPITable stores SPA Retail ProductsSPKTable stores SPA Package DetailsSPLTable stores SPA LocationsSPMTable stores SPA Miscellaneous ItemsSPNTable stores SPA Daily CalendarSPOTable stores Payroll Salary PositionsSPPTable stores Payroll's pay period detailsSPQTable stores SPA EquipmentSPRTable stores SPA Detail PostingsSPRMTable stores SPA Treatment RoomsSPSTable stores SPA Calendar Line SchedulesSPTTable stores payroll's salary contract templatesSPUTable stores SPA Items Bar CodesSPVTable stores SPA Detail PricesSPWTable stores SPA Package EntitlementSPYTable stores SPA Therapies

SPZTable stores SPA Retail Recommendations/InclusionsSRTTable stores guest special request recordsSSCDTable holds POS detail items sold on a checkSSCITable holds one record per MICROS check (Sales Check Import)SSHTable stores Payroll pay sheet information for crew member for a time periodSSH CMSTable stores Payroll Paysheet Information (SSH Data) from CMSSTLTable stores stolen item records (Table Not Being Reference within SPMS modules but in FC Security)STRTable stores Medical Sales transactionsSVATable stores Survey resultsSVCTable stores Cruise summary statistic and comment update recordsSVDTable stores Crew Incentive distribution recordsSVGTable stores Crew Incentive type setupSVQTable stores Survey question setupSVYTable stores Survey group setupSYNTable stores data that need to sync to Seaware Interface

TTable NameCommentsTADTable stores Time and Attendance template for schedule dayTADRTable stores daily roster schedule of crew membersTAITable stores Travel Agency InformationTAKTable stores Crew member's completed courses and certificatesTAKITable stores scanned images of courses /certificates taken by crew membersTALGTable stores ILO Violations for Clock-In/Out modeTALOTable stores Time Attendance locationsTAMLTable stores Time Attendance main location ownerTAMSTable stores message to/from guest/crew for SPMS modulesTAPTable stores Time Attendance template of all positions and time slot in a schedule dayTARSTable stores Time Attendance user defined rostering statesTATTable stores Time Attendance template of schedule typeTATETable stores each Time Attendance terminals configuration setupTATSTable stores T

AFD Table stores Universal APIS field definition AIL Table stores all air flight records per account. It has a one passenger/crew account to many air flight records relationship. AIR Table stores all air flight information details ALG Table stores guest medical allergies assignment AME Table stores guest amenities information