# title : OPERA Cloud RnA ProfilesLoyaltyClaims GraphQL API, # description : GraphQL API to cater for Detailed information on the Loyalty Program providing details on the Membership, Profiles, Stay Information and the ability to track Claims. # Compatible with OPERA Cloud RnA release 26.1.0.0. # This document and all content within is available under the Universal Permissive License v 1.0 # (https://oss.oracle.com/licenses/upl). Copyright (c) 2020,2026 Oracle and/or its affiliates # version : 26.1.0.0 # termsOfService : https://www.oracle.com/legal/terms.html # contact_email : hospitality_apis_ww_grp@oracle.com # license : https://opensource.org/licenses/upl directive @stream(if: Boolean, label: String, initialCount: Int = 0) on FIELD directive @conditionalInputPair(pair: Int) on INPUT_FIELD_DEFINITION directive @mandatoryInput on INPUT_FIELD_DEFINITION scalar Date scalar DateTime # Date format: "YYYY-MM-DD" input DateInput{ _eq: Date _ne: Date _in: [Date] _nin: [Date] _gt: Date _lt: Date _gte: Date _lte: Date _btn: DateRangeInput _isNull: Boolean } input DateRangeInput { start: Date! end: Date! } # Datetime format: "YYYY-MM-DD HH24:MI:SS" input DateTimeInput { _eq: DateTime _ne: DateTime _in: [DateTime] _nin: [DateTime] _gt: DateTime _lt: DateTime _gte: DateTime _lte: DateTime _btn: DateTimeRangeInput _isNull: Boolean } input DateTimeRangeInput { start: DateTime! end: DateTime! } input StringInput { _eq: String _ne: String _in: [String] _nin: [String] _gt: String _lt: String _gte: String _lte: String _isNull: Boolean } input FloatInput { _eq: Float _ne: Float _in: [Float] _nin: [Float] _gt: Float _lt: Float _gte: Float _lte: Float _btn: FloatRangeInput _isNull: Boolean } input FloatRangeInput { start: Float! end: Float! } # Mandatory filters: # The following filters are mandatory required filters. # Please ensure the request includes all the below fields. # - membershipclaimDetailsClaimDate # - membershipclaimDetailsResort input ProfilesLoyaltyClaimsQueryArgumentsType { """Approval Status""" membershipclaimDetailsApprovalStatus: StringInput """Approve/Reject/None""" membershipclaimDetailsApproveReject: StringInput """Arrival Date""" membershipclaimDetailsArrivalDate: DateInput """Central Xchange Date""" membershipclaimDetailsCXchangeDate: DateInput """Information about the caller.""" membershipclaimDetailsCallerInformation: StringInput """name of the person who called.""" membershipclaimDetailsCallerName: StringInput """Chain Code""" membershipclaimDetailsChainCode: StringInput """Channel""" membershipclaimDetailsChannel: StringInput """Claim Adj Limit Code""" membershipclaimDetailsClaimAdjLimitCode: StringInput """Date claim was posted in the database.""" membershipclaimDetailsClaimDate: DateInput! @mandatoryInput """Primary key.""" membershipclaimDetailsMembershipClaimId: FloatInput """User defined origin of claim.""" membershipclaimDetailsClaimOrigin: StringInput """Source of the Claim""" membershipclaimDetailsClaimSource: StringInput """Status of the claim.""" membershipclaimDetailsClaimStatus: StringInput """User Defined Claim Types""" membershipclaimDetailsClaimType: StringInput """Date and time cashier was closed.""" membershipclaimDetailsCloseDate: DateInput """Comments""" membershipclaimDetailsComments: StringInput """Confirmation Number""" membershipclaimDetailsPmsResvNo: StringInput """Deleted Flag""" membershipclaimDetailsDeletedFlag: StringInput """Departure Date""" membershipclaimDetailsDepartureDate: DateInput """External Reference Number""" membershipclaimDetailsCrsBookNo: StringInput """Insert Date""" membershipclaimDetailsInsertDate: DateTimeInput """JRN Update Date and Time""" membershipclaimDetailsJrnupdatedttm: DateTimeInput """Market Code""" membershipclaimDetailsMarketCode: StringInput """Membership Claim Property""" membershipclaimDetailsResort: StringInput! @mandatoryInput """Membership ID""" membershipclaimDetailsMembershipId: FloatInput """Membership Number""" membershipclaimDetailsMembershipCardNo: StringInput """Membership Trx ID""" membershipclaimDetailsMembershipTrxId: FloatInput """Membership Type""" membershipclaimDetailsMembershipType: StringInput """Name""" membershipclaimDetailsName: StringInput """Name ID""" membershipclaimDetailsNameId: FloatInput """Origin of Booking""" membershipclaimDetailsOriginOfBooking: StringInput """Owner""" membershipclaimDetailsClaimOwnerName: StringInput """Purpose of stay.""" membershipclaimDetailsPurposeOfStay: StringInput """Rate Code""" membershipclaimDetailsRateCode: StringInput """Record Type""" membershipclaimDetailsRecordType: StringInput """Date when the user gets a response to his/her claim.""" membershipclaimDetailsReplyByDate: DateInput """Reservation Status""" membershipclaimDetailsResvStatus: StringInput """Room""" membershipclaimDetailsRoom: StringInput """Submitter""" membershipclaimDetailsSubmitter: StringInput """Update Date""" membershipclaimDetailsUpdateDate: DateTimeInput """Base Rate Code""" ratecodeDetailsBaseRateCode: StringInput """Business Date""" ratecodeDetailsBeginBookingDate: DateInput """Central Xchange Date""" ratecodeDetailsCXchangeDate: DateInput """Commission Code""" ratecodeDetailsCommissionCode: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" ratecodeDetailsDsi: FloatInput """Daily Rates Y/N""" ratecodeDetailsDailyRatesYn: StringInput """The rate code on which this rate shedule is dynamically based on.""" ratecodeDetailsDbaseRateCode: StringInput """Display Sequence""" ratecodeDetailsSellSequence: FloatInput """End Date""" ratecodeDetailsEndBookingDate: DateInput """Group Code""" ratecodeDetailsGroupCode: StringInput """JRN Update Date and Time""" ratecodeDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Property""" ratecodeDetailsLocationid: StringInput """Market Code""" ratecodeDetailsMarketCode: StringInput """Maximum Days Advance Booking""" ratecodeDetailsMaxDvanceBooking: FloatInput """Maximum Length of Stay""" ratecodeDetailsMaxLos: FloatInput """Maximum Occupancy""" ratecodeDetailsMaxOccupancy: FloatInput """Minimum Days Advance Booking""" ratecodeDetailsMinAdvanceBooking: FloatInput """Minimum Occupancy""" ratecodeDetailsMinOccupancy: FloatInput """Order By""" ratecodeDetailsOrderBy: FloatInput """Internal ID to uniquely identify the Organization""" ratecodeDetailsOrganizationid: FloatInput """Original Rate Code""" ratecodeDetailsRateCode: StringInput """Indicates the order in which this rate should be displayed during the booking process when the ors_rate_sell_sequence functionality is active.""" ratecodeDetailsOrsSellSequence: FloatInput """Indicates whether the rate code is pending for approval or not""" ratecodeDetailsPendingApprovalYn: StringInput """Code to uniquely identify the Property""" ratecodeDetailsResort: StringInput """Yield rate bucket""" ratecodeDetailsRateBucket: StringInput """Rate Code ID""" ratecodeDetailsRateCodeId: StringInput """Rate Level this rate code belongs to.""" ratecodeDetailsRateLevel: FloatInput """Source Code""" ratecodeDetailsSourceCode: StringInput """Rate transaction code""" ratecodeDetailsTransactionCode: StringInput """Indicates the lengh of Stay Unit in days. If value is > 1 then it is a pkg rate code.""" ratecodeDetailsLosUnit: FloatInput """DSI Internal Data Source ID to identify Opera Chain and instance""" marketDetailsDsi: FloatInput """JRN Update Date and Time""" marketDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Property""" marketDetailsLocationid: StringInput """Market Code""" marketDetailsMarketCode: StringInput """Market group attached to the market code""" marketDetailsParentMarketCode: StringInput """Marketgroupid""" marketDetailsMarketgroupid: StringInput """Marketid""" marketDetailsMarketid: StringInput """Internal ID to uniquely identify the Organization""" marketDetailsOrganizationid: FloatInput """Property""" marketDetailsResort: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" sourcetableDetailsDsi: FloatInput """JRN Update Date and Time""" sourcetableDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Property""" sourcetableDetailsLocationid: StringInput """Internal ID to uniquely identify the Organization""" sourcetableDetailsOrganizationid: FloatInput """Property""" sourcetableDetailsResort: StringInput """Source Code""" sourcetableDetailsSourceCode: StringInput """Sourceid""" sourcetableDetailsSourceid: StringInput """Based On Rule""" reservationpromotionsDetailsBasedOnRule: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" reservationpromotionsDetailsDsi: FloatInput """JRN Update Date and Time""" reservationpromotionsDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Property""" reservationpromotionsDetailsLocationid: StringInput """Internal ID to uniquely identify the Organization""" reservationpromotionsDetailsOrganizationid: FloatInput """Promotion Code""" reservationpromotionsDetailsPromoCode: StringInput """Code to uniquely identify the Property""" reservationpromotionsDetailsResort: StringInput """Resv Name ID""" reservationpromotionsDetailsResvNameId: FloatInput """DSI Internal Data Source ID to identify Opera Chain and instance""" roomDetailsDsi: FloatInput """JRN Update Date and Time""" roomDetailsJrnupdatedttm: DateTimeInput """Internal ID to uniquely identify the Property""" roomDetailsLocationid: StringInput """Internal ID to uniquely identify the Organization""" roomDetailsOrganizationid: FloatInput """Code to uniquely identify the Property""" roomDetailsResort: StringInput """Room""" roomDetailsRoompmsref: StringInput """Room Number""" roomDetailsRoom: StringInput """Roomid""" roomDetailsRoomid: StringInput """JRN Update Date and Time""" membershipclaimshistoryDetailsJrnupdatedttm: DateTimeInput """DSI Internal Data Source ID to identify Opera Chain and instance""" channelDetailsDsi: FloatInput """Entity Name""" channelDetailsEntityName: StringInput """JRN Update Date and Time""" channelDetailsJrnupdatedttm: DateTimeInput """Language Code""" channelDetailsLanguageCode: StringInput """Internal ID to uniquely identify the Organization""" channelDetailsOrganizationid: FloatInput """Origin Code""" channelDetailsAttributeCode: StringInput """Title Suffix""" channelDetailsTitleSuffix: FloatInput } type Query { """Detailed information on the Loyalty Program providing details on the Membership Profiles Stay Information and the ability to track Claims.""" profilesLoyaltyClaims(limit: Int offset: Int input: ProfilesLoyaltyClaimsQueryArgumentsType!): [ProfilesLoyaltyClaimsType] } type ProfilesLoyaltyClaimsType { """Membership Claim Details""" membershipClaimDetails: ProfilesLoyaltyClaimsMembershipClaimDetailsType """Rate Code Details""" rateCodeDetails: ProfilesLoyaltyClaimsRateCodeDetailsType """Market Details""" marketDetails: ProfilesLoyaltyClaimsMarketDetailsType """Source Table Details""" sourceTableDetails: ProfilesLoyaltyClaimsSourceTableDetailsType """Reservation Promotions Details""" reservationPromotionsDetails: ProfilesLoyaltyClaimsReservationPromotionsDetailsType """Room Details""" roomDetails: ProfilesLoyaltyClaimsRoomDetailsType """Membership Claims History Details""" membershipClaimsHistoryDetails: ProfilesLoyaltyClaimsMembershipClaimsHistoryDetailsType """Channel Details""" channelDetails: ProfilesLoyaltyClaimsChannelDetailsType profilesLoyaltyClaimsRecordCount: Int } type ProfilesLoyaltyClaimsMembershipClaimDetailsType { """Approval Status""" approvalStatus: String """Approve/Reject/None""" approveReject: String """Arrival Date""" arrivalDate: Date """Central Xchange Date""" cExchangeDate: Date """Central Xchange Rate""" cExchangeRate: Float """Central Membership Base Revenue""" cMembershipBaseRevenue: Float """Central Membership Bonus Revenue""" cMembershipBonusRevenue: Float """Information about the caller.""" callerInformation: String """name of the person who called.""" callerName: String """Chain Code""" chainCode: String """Channel""" channel: String """Claim Adj Limit Code""" claimAdjLimitCode: String """Date claim was posted in the database.""" claimDate: Date """Primary key.""" claimNumber: Float """User defined origin of claim.""" claimOrigin: String """Claim Owner""" claimOwner: Float """Source of the Claim""" claimSource: String """Status of the claim.""" claimStatus: String """User Defined Claim Types""" claimType: String """Date and time cashier was closed.""" closeDate: Date """Comments""" comments: String """Confirmation Number""" confirmationNumber: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Departure Date""" departureDate: Date """External Reference Number""" externalReferenceNumber: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Market Code""" marketCode: String """Membership Base Nights""" membershipBaseNights: Float """Membership Base Revenue""" membershipBaseRevenue: Float """Membership Base Stay""" membershipBaseStay: Float """Membership Bonus Nights""" membershipBonusNights: Float """Membership Bonus Revenue""" membershipBonusRevenue: Float """Membership Bonus Stay""" membershipBonusStay: Float """Membership Claim Property""" membershipClaimProperty: String """Membership ID""" membershipId: Float """Membership Number""" membershipNumber: String """Membership Trx ID""" membershipTransactionId: Float """Membership Type""" membershipType: String """Name""" name: String """Name ID""" nameId: Float """Internal ID to uniquely identify the Organization""" organizationID: Float """Origin of Booking""" originOfBooking: String """Owner""" owner: String """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Purpose of stay.""" purposeOfStay: String """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Rate Code""" rateCode: String """Tier ID for the Rate Detail.""" rateTier: Float """Record Type""" recordType: String """Date when the user gets a response to his/her claim.""" replyBy: Date """Reservation Name ID""" reservationNameID: Float """Reservation Status""" reservationStatus: String """Room""" room: String """Submitter""" submitter: String """Total Base Points""" totalBasePoints: Float """Total Bonus Points""" totalBonusPoints: Float """Total Miscellaneous Points""" totalMiscPoints: Float """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type ProfilesLoyaltyClaimsRateCodeDetailsType { """Not null value in this column indicates that this is ASB Rate. This column also specifies the cycle of ASB rate. MC=Fixed Calendar Month Cycle WC=Fixed Calendar Week Cycle MF= Floating Monthly Cycle WF=Floating Weekly Cycle.""" aSBRateCycle: String """Amount to be added to the base rate when shown on rate query""" addition: String """With Advanced Base Rate Parameter ON this field stores the rate code on which this rate schedule is dynamically based on.""" advBaseRateCode: String """Indicates how rounding of advanced dynamic rate calculation is performed.[U]p [D]own [N]one [C] -Up - keep decimal [F] -Down - keep decimal.""" advBaseRounding: String """Identifies if during the availability check the calculated based amount should be compared to rate detail of BAR rate code.""" advanceBaseCompareYN: String """Indicates if this rate code is an Advanced Daily Base Rate.""" advanceDailyBaseYN: String """Indicates if this rate code is an Advanced Daily Rate.""" advanceDailyRateYN: String """Alternative rate code if current rate is not available""" alternateRateCode: String """Flag to indicate whether to send Rate code to AVH or not.""" availabilityUpdateYn: String """Back To Back YN""" backToBackYN: String """Base Amount""" baseAmount: Float """Flat or Percentage of the Base Rate""" baseFltPct: String """Base Rate Code""" baseRateCode: String """Indicates if rounding of rate is required""" baseRounding: String """Indicating a rate type such as flat rate or percentage rate. Possible values are: FLAT DIFFERENTIAL and NULL.""" baseType: String """This column use to store Percentage or Amount difference between BAR Rate code and this Rate Code.""" bbarBaseAmount: Float """This flag column identify that amount column represent Flat or Percentage value.""" bbarBaseFltPct: String """This column identify the rounding formula for the BBAR Rate calculation.""" bbarBaseRounding: String """This column will identify that Rate Code is Best BAR based rate code or not. Possible values are Y/N.""" bbarBasedYn: String """Identifies if during the availability check the calculated based amount should be compared to rate detail of BBAR rate code.""" bbarCompareYn: String """Bbar Y/N""" bbarYn: String """Block Name""" blockName: String """PCR: Is breakfast is included in this rate code?""" breakfastInclYn: String """Breakfast Price""" breakfastPrice: Float """Business Date""" businessDate: Date """In case of ORMS when this flag is Y system ignore this rate code from Hurdle Check.""" bypassHurdleYn: String """Indicates that this rate code will not go through rank validations if value is 'Y'.""" bypassRankCheckYn: String """Central Base Amount""" cBaseAmount: Float """Central Bbar Base Amount""" cBbarBaseAmount: Float """Central Bfst Price""" cBreakfastPrice: Float """Central Dbase Amount""" cDbaseAmount: Float """Central Discount Rate Amount""" cDiscountRateAmount: Float """Central Dbl Rm Supplement Price""" cDoubleRoomSupplementPrice: Float """Central Xchange Date""" cExchangeDate: Date """Central Xchange Rate""" cExchangeRate: Float """Central Rate Floor""" cRateFloor: Float """Central Rate Level""" cRateLevel: Float """Central Rod Base Amount""" cRodBaseAmount: Float """Central Room Assignment Value""" cRoomAssignmentValue: Float """Stores the catering package code linked to this rate code.""" catPackageCode: String """Specifies if a catering package is linked to this rate code.""" cateringPackageYN: String """Central Market Code""" centralMarketCode: String """Central Market Description""" centralMarketDescription: String """Central Market Group Code""" centralMarketGroupCode: String """Central Market Group Description""" centralMarketGroupDescription: String """Central Rate Bucket""" centralRateBucket: String """Central Rate Bucket Description""" centralRateBucketDescription: String """Central Rate Category""" centralRateCategory: String """Central Rate Category Description""" centralRateCategoryDescription: String """Central Rate Class""" centralRateClass: String """Central Rate Class Description""" centralRateClassDescription: String """Central Room Type""" centralRoomType: String """Central Room Type Description""" centralRoomTypeDescription: String """Central Source Code""" centralSourceCode: String """Central Source Description""" centralSourceDescription: String """Central Source Group Code""" centralSourceGroupCode: String """Central Source Group Description""" centralSourceGroupDescription: String """Indicates the state of chaange of the rate code with values null=enabled D=disabled P=changes pending of approval""" changeState: String """This field is used to populate rate code commission percentage for informational purposes for GDS and ORS reservation agents""" commissionPercent: Float """Commission Code""" commissionCode: String """Are commissions allowed for this rate code? Y/N""" commissionYn: String """PCR: Commissionable Percentage.""" commissionablePerc: Float """Commissionable Y/N""" commissionableYn: String """Complimentary YN""" complimentaryYN: String """Introduced for Holidex inbound delta rate processing this column stores the value indicating the decimal position specific to the received the currency code.""" currCodeDecimalPos: Float """Currency Code""" currencyCode: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Daily Rates Y/N""" dailyRatesYn: String """Day use reservation Y/N.""" dayUseYN: String """Days the rate restriction is not available for arrival""" daysWhenClosedToArrival: String """Indicates either Flat amount or Percentage increase or decrease from the dynamic base rate.""" dbaseAmount: Float """This flag identify that while checking availability calculated based amount should be compared to rate detail of rate code or not.""" dbaseCompareYn: String """Flat or Percentage of the dynamic base rate code.""" dbaseFltPct: String """The rate code on which this rate shedule is dynamically based on.""" dbaseRateCode: String """Indicates if rounding of dynamic rate calculation is required.""" dbaseRounding: String """Stores the double room supplement price.""" dblRoomSupplementPrice: Float """For BAR dependent Rate Code this flag indicates that when all BAR Rates are closed the Rate Amount should be calculated based on the highest BAR Rate Amount instead of based on its own Rate Detail.""" defaultToHighestBarYn: String """Deleted Flag""" deletedFlag: String """Stores the Deposit maturity preference.""" depositMaturityPreference: String """Department code for the transaction.""" deptCode: String """Discount rate amount value.""" discountRateAmount: Float """Indicates if discount rate amount is a percentage value.""" discountRatePercentageYn: String """Discount Flag.""" discountYN: String """Display Sequence""" displaySequence: Float """Display Set""" displaySet: String """Indicates if the profile should be distributed to the external database.""" distributeYn: String """Stores the double room supplement.""" doubleRoomSupplementYN: String """End Date""" endDate: Date """Indicates if the value set for the specific property.""" eventProperty: String """Exchange Type""" exchangeType: String """Externally Controlled YN""" externallyControlledYN: String """Introduced for Holidex inbound delta rate processing this column stores the value indicating at person level the extra charge begins.""" extraPersonChargeBegins: Float """Fit Discount Level.""" fitDiscountLevel: Float """Published Corporate Rate: Discount Percentage.""" fitDiscountPerc: Float """Flat YN""" flatYN: String """Text displayed on the Folio""" folioText: String """Frequent Flyer YN""" frequentFlyerYN: String """Is this rate code available for GDS""" gDSAllowedYN: String """Group Code""" groupCode: String """To highlight on the rate query""" highlightRateAmountYn: String """House-Use YN""" houseUseYN: String """Inactive Date""" inactiveDate: Date """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """Location ID""" internalLocationId: String """Organization ID""" internalOrganizationId: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Internal ID to uniquely identify the Property""" locationID: String """Long Info""" longInfo: String """Flag to indicate if this is a loyalty program""" loyaltyProgramYN: String """Indicates mandatory reservation profiles. This is used to force entry of profiles on the reservation header if this rate is picked.""" mandateResvProfiles: String """Market Code""" marketCode: String """Market Description""" marketDescription: String """Market Group Code""" marketGroupCode: String """Market Group Description""" marketGroupDescription: String """Contains the rate program information from the MARSHA interface.""" marshaRateProgram: String """Maximum Days Advance Booking""" maximumDaysAdvanceBooking: Float """Maximum Length of Stay""" maximumLengthOfStay: Float """Maximum Occupancy""" maximumOccupancy: Float """Flag used to determine if the rate code is to be sent to MyFidelio.net if the rate is being received from a V6 V7 V8 or OPMS on a lower version on which flag used to determine if the rate code is to be sent to MyFidelio.net does not exist on the rate header.""" mfnUploadYn: String """Minimum Days Advance Booking""" minimumDaysAdvanceBooking: Float """Minimum Occupancy""" minimumOccupancy: Float """Mobile Checkin Allowed Y/N""" mobileCheckinAllowedYn: String """Mobile Chkout Allowed""" mobileChkoutAllowed: String """Amount to be multiplied to the base rate when shown on rate query""" multiplication: String """MyFidelio Upload YN""" myFidelioUploadYN: String """Property is negotiated of search criteria or not.""" negotiatedYN: String """Indicates if the rate code is occupancy based.""" occupancyBasedYn: String """Indicates the occupancy level for hurdle evaluation.""" occupancyLevel: Float """The operator type to use during the calculation of base rates. (ADD_TO SUBTRACT)""" operatorType: String """Order By""" orderBy: Float """Internal ID to uniquely identify the Organization""" organizationID: Float """Original Rate Code""" originalRateCode: String """Indicates the order in which this rate should be displayed during the booking process when the ors_rate_sell_sequence functionality is active.""" orsSellSequence: Float """Indicates if we need to override package for hurdle evaluation.""" overridePackageYn: String """Indicates Owners Rate Code. This is used to perform rolling noshow.""" ownerRateYN: String """Package Transaction Code""" packageTransactionCode: String """Package Transaction Code Weekend""" packageTransactionCodeWeekend: String """Wrapper transaction code tax inclusive Y/N""" packageTransactionTaxInclYN: String """Transaction code is inclusive of tax Y/N""" packageTransactionTaxIncludedYN: String """Wrapper transaction code tax inclusive for weekend days Y/N""" packageTransactionWkTaxInclYN: String """Package YN""" packageYN: String """Packages""" packages: String """Indicates whether the rate code is pending for approval or not""" pendingApprovalYn: String """Posting Rhythm""" postingRhythm: String """Number of nights for posting rhythm.""" postingRhythmNights: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Print Rate Y/N""" printRateYn: String """Indicates if restriction for rate is privileged or not.""" privilegedRestrictionYn: String """Indicates if rate is privileged or not.""" privilegedYn: String """Profit Transaction Code""" profitTransactionCode: String """Code to uniquely identify the Property""" property: String """Property Name""" propertyName: String """Any number between -10 and +10. This adjustment factor will be applied to the daily ranking value of table RESORT_DAY_TYPE_DATES for the stay date to determine the Rate code rank value.""" rankAdjustmentFactor: Float """Rank Value""" rankValue: Float """Yield rate bucket""" rateBucket: String """Rate Bucket Description""" rateBucketDescription: String """Indicates if rate Calendar factors such as adder/multiplier should be used for price calculation.""" rateCalendarYn: String """Rate Category""" rateCategory: String """Rate Category Description""" rateCategoryDescription: String """Rate Class""" rateClass: String """Rate Class Description""" rateClassDescription: String """Rate Code ID""" rateCodeId: String """Rate Code Locked Y/N""" rateCodeLockedYn: String """Contains the minimum value of the rate amount which can be defined in the rate details.""" rateFloor: Float """This flag indicates if the Rate Floor Rate is overridden for a particular Rate Code.""" rateFloorOverrideYn: String """Does this rate include tax? Y/N""" rateIncludesTaxYn: String """Rate Label""" rateLabel: String """Rate Level this rate code belongs to.""" rateLevel: Float """Needs to send this rate to GDS or not.""" rateUpdateYN: String """Rateinfo Url""" rateinfoUrl: String """Redemption Rate YN""" redemptionRateYN: String """Regional Availability YN""" regionalAvailabilityYN: String """Indicates if the posting rhythm on the rate code is repeated until the end of the stay otherwise the posting rhythm is applied only once.""" repeatPostingRhythmYn: String """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Rod Base Amount""" rodBaseAmount: Float """Rod Base Flt Pct""" rodBaseFltPct: String """Rod Base Rounding""" rodBaseRounding: String """Is the group code rate of day based""" rodBasedYn: String """Rod Y/N""" rodYn: String """Room Assignment Value""" roomAssignmentValue: Float """Room Type""" roomType: String """Room Type Description""" roomTypeDescription: String """Holds a copy of the column begin_booking_date while the rate code is disabled or with changes pending of approval""" sdowBeginBookingDate: Date """Holds a copy of the column end_booking_date while the rate code is disabled or with changes pending of approval""" sdowEndBookingDate: Date """PCR: Are Service Charges included in this rate code?""" serviceInclYn: String """Service Percentage included.""" servicePerc: Float """Information to be used in the rate query""" shortInfo: String """Flag used to show or hide rate column in Block Grid and used as default by block reservations.""" showRateAmountYn: String """Source Code""" sourceCode: String """Source Description""" sourceDescription: String """Source Group Code""" sourceGroupCode: String """Source Group Description""" sourceGroupDescription: String """Percentage of included Tax.""" taxIncludedPerc: Float """Tax is included in this rate.""" taxIncludedYn: String """Indicates if the rate is a tiered rate.""" tieredYN: String """Rate transaction code""" transactionCode: String """Transaction Code Weekend""" transactionCodeWeekend: String """Transaction code is inclusive of tax for weekend days Y/N""" transactionTaxWeekendIncludedYN: String """Indicates the lengh of Stay Unit in days. If value is > 1 then it is a pkg rate code.""" unitOfLengthOfStay: Float """Update Date""" updateDate: DateTime """Update User""" updateUser: Float """Indicates if the rate code can be upsold""" upsellYn: String """Flag to indicate if this is a voucher benefit rate code.""" voucherBenefitRateYn: String """Indicates weekend days seperated by '' Eg 17 ie Sun and Sat""" weekendDays: String """Wk Dept Code""" wkDeptCode: String """Yield As""" yieldAs: String """Yieldable YN""" yieldableYN: String """Ym Code""" ymCode: String } type ProfilesLoyaltyClaimsMarketDetailsType { """Central Market Code""" centralMarketCode: String """Central Market Description""" centralMarketDescription: String """Central Market Group Code""" centralMarketGroupCode: String """Central Market Group Description""" centralMarketGroupDescription: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Display Color""" displayColor: String """Inactive Date""" inactiveDate: DateTime """Inactive YN""" inactiveYN: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """Deleted Flag""" internalDeletedflag: String """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Internal ID to uniquely identify the Property""" locationID: String """Market Code""" marketCode: String """Market Description""" marketDescription: String """Market Display Sequence""" marketDisplaySequence: Float """Market group attached to the market code""" marketGroupCode: String """Market Group Description""" marketGroupDescription: String """Market Group Display Sequence""" marketGroupDisplaySequence: Float """Marketgroupid""" marketgroupid: String """Marketid""" marketid: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Print Group for Nationality Report""" printGroup: String """Property""" property: String """Reporting Item""" repItem: String """Reporting Item Name""" repItemName: String """Reporting Item Orderby""" repItemOrderby: Float """Reporting Market Sell Sequence""" repMarketSellSequence: Float """Reporting Parent Sell Sequence""" repParentSellSequence: Float """Reporting Updatedate""" repUpdateDate: DateTime """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Sc Orderby""" scOrderby: Float """Transaction Code""" trxCode: String """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type ProfilesLoyaltyClaimsSourceTableDetailsType { """Central Sequence""" centralSequence: Float """Central Source Code""" centralSourceCode: String """Central Source Description""" centralSourceDescription: String """Central Source Group Code""" centralSourceGroupCode: String """Central Source Group Description""" centralSourceGroupDescription: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Row deleted YN (if set to 'Y' then the row joined by SEQ from postal_codes will not be displayed).""" deletedYn: String """Deleted Flag""" deletedflag: String """Inactive Date""" inactiveDate: Date """Inactive YN""" inactiveFlagYN: String """Inactive Y/N""" inactiveYn: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """Indicates if the source code is marked to track internet sales.""" internetSalesYn: String """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Lastuseddatetime""" lastuseddatetime: DateTime """Internal ID to uniquely identify the Property""" locationID: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Parentsourceid""" parentsourceid: String """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Property""" property: String """Reporting Item""" repItem: String """Reporting Item Name""" repItemName: String """Reporting Item Orderby""" repItemOrderby: Float """Reporting Updatedate""" repUpdateDate: DateTime """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Sequence""" sequence: Float """Source Code""" sourceCode: String """Source Description""" sourceDescription: String """Source Display Sequence""" sourceDisplaySequence: Float """Source group of the source code""" sourceGroupCode: String """Source Group Description""" sourceGroupDescription: String """Source Group Display Sequence""" sourceGroupDisplaySequence: Float """Sourceid""" sourceid: String """Temp Y/N""" tempYn: String """Update Date""" updateDate: DateTime """Update User""" updateUser: Float } type ProfilesLoyaltyClaimsReservationPromotionsDetailsType { """Based On Rule""" basedOnRule: String """Central Promotion Code""" centralPromotionCode: String """Central Promotion Description""" centralPromotionDescription: String """Chain Code""" chainCode: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Internal ID to uniquely identify the Property""" locationID: String """Internal ID to uniquely identify the Organization""" organizationID: Float """P Promo Code""" pPromoCode: String """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Promotion Code""" promotionCode: String """Promotion Name.""" promotionDescription: String """Code to uniquely identify the Property""" property: String """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Resv Name ID""" reservationNameId: Float } type ProfilesLoyaltyClaimsRoomDetailsType { """Accessible""" accessible: String """Area in sqft""" areaF: Float """Area in sqm""" areaM: Float """Assign Assign Status""" assignAssignStatus: String """Room assignment date""" assignDate: DateTime """Assign Reason Desc""" assignReasonDesc: String """Assign Type""" assignType: String """Assignemployeeid""" assignemployeeid: Float """Assignreasonid""" assignreasonid: String """Bed Type""" bedType: String """Building""" building: String """Building Group""" buildingGroup: String """Business Date""" businessDate: Date """Central Xchange Date""" cExchangeDate: Date """Central Xchange Rate""" cExchangeRate: Float """Central Minimum Revenue""" cMinimumRevenue: Float """Central Rack Rate""" cRackRate: Float """Central Meeting Room Type""" centralMeetingRoomType: String """Central Room Class""" centralRoomClass: String """Central Room Type""" centralRoomType: String """Central Room Type Description""" centralRoomTypeDescription: String """Combination Room YN""" combinationRoomYN: String """Comments""" comments: String """Suite component room numbers""" componentRoom: String """Connecting Room Number""" connectingRoomNumber: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Indicates the section to which employee belongs.""" daySection: String """Deduct YN""" deductYN: String """Defatulratecodeid""" defatulratecodeid: String """Default Rate Description""" defaultRateDesc: String """Deleted Flag""" deletedflag: String """Credits associated with the task after departure.""" departureCredits: Float """Description""" description: String """Diary name to show room in""" diaryName: String """Diarydisplayflag""" diarydisplayflag: String """Discrepancy""" discrepancy: String """Number of doors""" doors: String """Section the room belongs to for evening housekeeping""" eveningSection: String """Facility ID for eVisitor.""" evisitorFacilityId: String """Stores event types which do not require alternate spaces.""" excludedEventTypes: String """Direction room faces""" facing: String """Floor""" floor: String """The persons staying in room according to Front office.""" foPers: Float """Defines if the function space needs an alternate space when booked.""" forceAlternateYn: String """The front desk location this room should check in to.""" frontDeskLocation: String """Front Office Status of the room i.e.: Vacant or Occupied.""" frontOfficeStatus: String """Minutes occupied that define the room as 100% utilized. Maximum is 1440 minutes.""" fullUtilizationTime: Float """Generic YN""" genericYN: String """Handicapflag""" handicapflag: String """Max Height in ft""" heightmaxF: Float """Max Height in m""" heightmaxM: Float """Minumum heigth of room (feet)""" heightminF: Float """Minumum heigth of room (meters)""" heightminM: Float """Date and time when room will be released from hold.""" holdDateTime: DateTime """Hold type from resort_assignment_reasons table.""" holdType: String """User that is holding the room.""" holdUser: Float """Sequence for automatically generated task assignment.""" housekeepingAssignmentOrderBy: Float """Housekeeping Inspected date""" housekeepingInspDate: Date """Houskeeping inspected employee id""" housekeepingInspEmpId: String """The number of persons staying in the room according to housekeeping""" housekeepingPers: Float """The status of this room according to housekeeping""" housekeepingStatus: String """Image ID""" imageId: Float """Inactive Flag""" inactiveflag: String """Include in Statistics YN""" includeInStatisticsYN: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """Tempflag""" internalTempflag: String """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """The current key code for this room. Used to create keys for a room.""" keyCode: String """Privileges available for this key""" keyOptions: String """The last check out date for this room.""" lastCheckOutDate: Date """The last meter reading for condos that track electrical usage of rented rooms.""" lastMeterReading: Float """Length (feet)""" lengthF: Float """Length (meters)""" lengthM: Float """Number of lights in the room""" light: String """Internal ID to uniquely identify the Property""" locationID: String """Loudspeakersflag""" loudspeakersflag: String """Maximum number of days before the catering event date that the space can be booked on the web.""" maxAdvance: Float """Function Space Maximum Capacity.""" maxCapacity: Float """Maximum number of groups for a Shared function space allowed.""" maxSharedGroups: Float """Maximum Occupancy""" maximumOccupancy: Float """The unit of measurement for this square units (IE: Feet Meters etc)""" measurement: String """Type of meeting room""" meetingRoomType: String """Meeting Room YN""" meetingRoomYN: String """Meetingroom Type Description""" meetingroomTypeDesc: String """Meetingroom Type Sequence""" meetingroomTypeSeq: Float """Type of microphone sockets""" microphoneSocketTypes: String """Number of microphone sockets""" microphoneSockets: Float """Minimum number of days before the catering event date that the space can be booked on the web.""" minAdvance: Float """Minimum Capacity""" minCapacity: Float """Minimum Revenue""" minimumRevenue: Float """Specifies the number of beds in this room.""" numberOfBeds: Float """Current room condition updated daily.(ie StayOverDueOutExpected etc)""" occupancyCondition: String """Discrepancy between front desk and housekeeping""" occupantDiscrepancy: Float """Used for pseudo rooms. If Y then this pseudo room will be included in Online Printing for reservation changes.""" onlinePrintingYn: String """Display sequence 2""" orderBy2: Float """Display sequence 3""" orderBy3: Float """Display sequence 4""" orderBy4: Float """Display sequence 5""" orderBy5: Float """Internal ID to uniquely identify the Organization""" organizationID: Float """Stores a Grade associated with a unit to determine the room display order in Room Assignment and Room Plan screens.""" ovosGradeCode: String """Room can be OVOS unit.""" ovosUnitYn: String """Not used""" pcode: String """Person discrepancy between front desk and houskeeping""" personDiscrepancy: Float """Phone Number""" phoneNumber: String """Physical Number of Rooms""" physicalNumberOfRooms: Float """Houskeeping credits for cleaning room in pickup status""" pickupCredits: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Code to uniquely identify the Property""" property: String """Pseudo Room YN""" pseudoRoomYN: String """Default rate for the room""" publishedRateAmount: Float """Default rate code to be used to calculate the total revenue.""" publishedRateCode: String """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Rate Code""" rateCode: String """Rating""" rating: String """Reporting Assign Reason Desc""" repAssignReasonDescription: String """Reporting Bed Type Desc""" repBedTypeDescription: String """Reporting Meetingroom Type Desc""" repMeetingroomTypeDescription: String """Reporting Meetingroom Type Seq""" repMeetingroomTypeSequence: Float """Reporting Room Class Sell Seq""" repRoomClassSellSequence: Float """Reporting Room Features Descs""" repRoomFeaturesDescs: String """Reporting Room Status Reason""" repRoomStatusReason: String """Reporting Room Status Reason Desc""" repRoomStatusReasonDescription: String """Room return status""" returnStatus: String """Room""" room: String """Room Assignment Rating.""" roomAssignmentRating: Float """Room Category Bedtype""" roomCategoryBedtype: String """Room Category Desc""" roomCategoryDesc: String """Room Class""" roomClass: String """Room Class Central Description""" roomClassCentralDescription: String """Room Class Description""" roomClassDescription: String """Room Class Sequence""" roomClassSequence: Float """Room Condition""" roomCondition: String """Room Feature Description""" roomFeatureDescription: String """This stores the codes for the rooms features. Currently not used""" roomFeatures: String """Room Number""" roomNumber: String """Room Parity""" roomParity: String """Room Status""" roomStatus: String """Room Status Description""" roomStatusDescription: String """The date as of which the room_status is valid.""" roomStatusFromDate: Date """Room Status Reason""" roomStatusReason: String """Room Status Reason Description""" roomStatusReasonDesc: String """Room status remarks""" roomStatusRemarks: String """The date till which the room_status is valid.(Used during OO and OS status of rooms )""" roomStatusToDate: Date """Room Type""" roomType: String """Total Count of the number of days the room was used.""" roomUseCount: Float """Roomcategoryid""" roomcategoryid: String """Roomclassid""" roomclassid: String """Roomid""" roomid: String """Roomstatusreasonid""" roomstatusreasonid: String """Sequence""" sequence: Float """Current guest service status code for this room. Example: Service status can be DND (Do Not Disturb) or MUP (Make Up Room)""" serviceStatus: String """Notes for the setup of the room""" setupNotes: String """Shareableflag""" shareableflag: String """Smoking""" smoking: String """Smoking Preferences""" smokingPreferences: String """The square units for this room (IE: if a condo in the US likely the square feet of this room)""" squareUnits: Float """Stayover Credits""" stayoverCredits: Float """Standard or Suite""" suiteType: String """Suite YN""" suiteYN: String """Supplement""" supplement: String """Temp Flag""" tempFlag: String """Number for the booth""" translationboothNum: Float """Turn Down""" turnDown: String """Houskeeping credits for Turndown.""" turndownCredits: Float """Number of TV or radio sockets""" tvRadioSockets: Float """Unit""" unit: String """Update Date""" updateDate: DateTime """Update User""" updateUser: Float """Flag makes a Function Space visible on the web.""" visibleOnWebYn: String """Web Booking Y/N""" webBookingYn: String """Room weigth (feet)""" weightF: Float """Room weigth (meters)""" weightM: Float """Width (feet)""" widthF: Float """Width (meters)""" widthM: Float } type ProfilesLoyaltyClaimsMembershipClaimsHistoryDetailsType { """Code to indicate the activity ocuured in the transaction (i.e. OPEN CLOSE)""" activity: String """Chain Code""" chainCode: String """Comments""" comments: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Date claim was posted in the database.""" date: Date """Deleted Flag""" deletedFlag: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Primary key.""" membershipClaimId: Float """Internal ID to uniquely identify the Organization""" organizationID: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Sequence""" sequence: Float """The name of the user who created the record.""" submitter: String } type ProfilesLoyaltyClaimsChannelDetailsType { """Business Title""" businessTitle: String """Can Delete Y/N""" canDeleteYn: String """Central Origin Code""" centralOriginCode: String """Central Origin Description""" centralOriginDescription: String """Central Sequence""" centralSequence: Float """Chain Code""" chainCode: String """Channelid""" channelid: String """Comments""" comments: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Deleted Flag""" deletedFlag: String """Display Color""" displayColor: String """Entity Name""" entityName: String """Contains a list of codes used by a vendor.""" externalAttributeCodes: String """Inactive Date""" inactiveDate: DateTime """Inactive Flag""" inactiveflag: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """Deleted Flag""" internalDeletedflag: String """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Language Code""" languageCode: String """Indicates if the KEYWORD TYPE is to be copied from a Company Master to a Company Subsidiary.""" masterSubKeywordYn: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Origin Code""" originCode: String """Origin Description""" originDescription: String """Origin Display Sequence""" originDisplaySequence: Float """Internal Primary Key ID to uniquely identify the row""" primaryKeyID: Float """Property""" property: String """Ranking""" ranking: Float """Reporting Item""" repItem: String """Reporting Item Name""" repItemName: String """Reporting Item Orderby""" repItemOrderby: Float """Reporting Updatedate""" repUpdateDate: DateTime """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Title Suffix""" titleSuffix: Float """Update Date""" updateDate: DateTime """Update User""" updateUser: Float }