# title : OPERA Cloud RnA SimpleReportsProfileIndividuals GraphQL API, # description : GraphQL API to cater for The Simple Reports Profile-Individuals Subject Area simplifies creating and building adhoc reports, including the ability to create new reports. # 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. # - nameDetailsChainCode input SimpleReportsProfileIndividualsQueryArgumentsType { """Anonymization Status possible values: REQUESTED ANONYMIZED.""" nameDetailsAnonymizationStatus: StringInput """The unique identifier of the CRS""" nameDetailsCrsNameid: FloatInput """Chain Code""" nameDetailsChainCode: StringInput! @mandatoryInput """Linked internal ID for booker.""" nameDetailsCompanyGroupId: StringInput """Contact Y/N""" nameDetailsContactYn: StringInput """DSI Internal Data Source ID to identify Opera Chain and instance""" nameDetailsDsi: FloatInput """Direct Bill Batch Type""" nameDetailsDirectBillBatchType: StringInput """History Y/N""" nameDetailsHistoryYn: StringInput """IATA Corp No""" nameDetailsIataCorpNo: StringInput """Inactive Date""" nameDetailsInactiveDate: DateInput """JRN Update Date and Time""" nameDetailsJrnupdatedttm: DateTimeInput """Name ID""" nameDetailsNameId: FloatInput """Name Type""" nameDetailsNameType: StringInput """Internal ID to uniquely identify the Organization""" nameDetailsOrganizationid: FloatInput """Resort for which Job is registered.""" nameDetailsResortRegistered: StringInput """Uppercase value of First Name.""" nameDetailsSfirst: StringInput """The Uppercase value of Last or Company.""" nameDetailsSname: StringInput """Internal Indexed field for Searching by Extended Byte First Name.""" nameDetailsSxfirstName: StringInput """Internal Indexed field for Searching by Extended Byte Name.""" nameDetailsSxname: StringInput """Update Date""" nameDetailsUpdateDate: DateTimeInput """JRN Update Date and Time""" nameresortDetailsJrnupdatedttm: DateTimeInput } type Query { """The Simple Reports Profile-Individuals Subject Area simplifies creating and building adhoc reports including the ability to create new reports""" simpleReportsProfileIndividuals(limit: Int offset: Int input: SimpleReportsProfileIndividualsQueryArgumentsType!): [SimpleReportsProfileIndividualsType] } type SimpleReportsProfileIndividualsType { """Profile""" profileDetails: SimpleReportsProfileIndividualsProfileDetailsType """Profile Property""" profilePropertyDetails: SimpleReportsProfileIndividualsProfilePropertyDetailsType simpleReportsProfileIndividualsRecordCount: Int } type SimpleReportsProfileIndividualsProfileDetailsType { """Indicates if a Credit Limit amount on Profile level will be required.""" aRCreditLimitYN: String """Account Type""" accountType: String """Accountsource""" accountsource: String """Billing contact person in company.""" acctContact: String """Active Y/N""" activeYn: String """Addr Cleansed Datetime""" addrCleansedDatetime: Date """Addr Cleansed Errormsg""" addrCleansedErrormsg: String """Addr Cleansed Status""" addrCleansedStatus: String """Addr Cleansed Valstatus""" addrCleansedValstatus: String """Addr Language Code""" addrLanguageCode: String """Addr Language Description""" addrLanguageDesc: String """Address ID""" addressId: Float """Address Type""" addressType: String """Address Type Description""" addressTypeDesc: String """Address1""" address1: String """Address2""" address2: String """Address3""" address3: String """Address4""" address4: String """Country Specific Requirement for Nigeria.""" alienRegistrationNo: String """All Owners""" allOwners: String """The Extended Byte Language of the Profile.""" alternateLanguage: String """Xlanguage Description""" alternateLanguageDesc: String """Alternate Salutation""" alternateSalutation: String """Alternate Title""" alternateTitle: String """System Date when the guest was anonymized in OPERA.""" anonymizationDate: Date """Anonymization Status possible values: REQUESTED ANONYMIZED.""" anonymizationStatus: String """AR No Central""" arNumberCentral: String """Autoenroll Member Y/N""" autoenrollMemberYn: String """Availover Y/N""" availoverYn: String """Barcode""" barcode: String """Country of birth.""" birthCountry: String """Place of birth.""" birthPlace: String """Bl Msg""" blMsg: String """Business Extension""" businessExtension: String """Business Phone ID""" businessPhoneId: Float """Business Phone Number""" businessPhoneNumber: String """Business Title""" businessTitle: String """The unique identifier of the CRS""" cRSNameid: Float """Cbl Individual""" cblInd: String """Chain Code""" chainCode: String """City""" city: String """City Ext""" cityExt: String """This flag will be used in case Profiles are being controlled Centrally (CRS).""" commPayCentral: String """Comm1 Country Dialing Code""" comm1CountryDialingCode: Float """Comm1 ID""" comm1Id: Float """Comm1 Phone Country Code""" comm1PhoneCountryCode: String """Comm1 Type""" comm1Type: String """Comm1 Valid Y/N""" comm1ValidYn: String """Comm1 Validate Date""" comm1ValidateDate: Date """Comm1 Validate Status""" comm1ValidateStatus: String """Comm1 Value""" comm1Value: String """Comm2 Country Dialing Code""" comm2CountryDialingCode: Float """Comm2 ID""" comm2Id: Float """Comm2 Phone Country Code""" comm2PhoneCountryCode: String """Comm2 Type""" comm2Type: String """Comm2 Valid Y/N""" comm2ValidYn: String """Comm2 Validate Date""" comm2ValidateDate: Date """Comm2 Validate Status""" comm2ValidateStatus: String """Comm2 Value""" comm2Value: String """Comm3 Country Dialing Code""" comm3CountryDialingCode: Float """Comm3 ID""" comm3Id: Float """Comm3 Phone Country Code""" comm3PhoneCountryCode: String """Comm3 Type""" comm3Type: String """Comm3 Valid Y/N""" comm3ValidYn: String """Comm3 Validate Date""" comm3ValidateDate: Date """Comm3 Validate Status""" comm3ValidateStatus: String """Comm3 Value""" comm3Value: String """Commission Account ID""" commissionAccountId: Float """Commission Account Name""" commissionAccountName: String """Comp Pre Approval Required Y/N""" compPreApprovalRequiredYn: String """Company""" company: String """Linked internal ID for booker.""" companyGroupId: String """Contact Y/N""" contactYn: String """Contract Number (used for customers).""" contractNo: String """The date the group contract was received.""" contractRecvDate: Date """Country""" country: String """Country Description""" countryDesc: String """Credit Rating""" creditRating: String """Double Opt In for AUTOENROLL_MEMBER_YN""" dOptInAutoenrollMemberFlg: String """Double Opt In for EMAIL_YN""" dOptInEmailFlg: String """Double Opt In for GUEST_PRIV_YN""" dOptInGuestPrivFlg: String """Double Opt In for MAIL_LIST""" dOptInMailListFlg: String """Double Opt In for MARKET_RESEARCH_YN""" dOptInMarketResearchFlg: String """Double Opt In for PHONE_YN""" dOptInPhoneFlg: String """Double Opt In for SMS_YN""" dOptInSmsFlg: String """Double Opt In for THIRD_PARTY_YN""" dOptInThirdPartyFlg: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Department""" department: String """Dept ID""" deptId: String """Direct Bill Batch Type""" directBillBatchType: String """Display Name""" displayName: String """Download Date""" downloadDate: Date """Download Property""" downloadResort: String """Download Srep""" downloadSrep: Float """The date when the E-Invoice liable flag was updated for this profile.""" eInvLiableLastUpdated: Date """Indicates if the payee profile ID is E_INVOICE liable.""" eInvoiceLiableYn: String """E Mail""" eMail: String """E Mail ID""" eMailId: Float """Format type for email messages: HTML PLAIN text.""" emailFormat: String """Email Validate Date""" emailValidateDate: Date """Email Validate Status""" emailValidateStatus: String """Email Y/N""" emailYn: String """Envelope Greeting""" envelopeGreeting: String """Fax Country Code""" faxCountryCode: String """Fax Country Dialing Code""" faxCountryDialingCode: Float """Fax ID""" faxId: Float """Fax Number""" faxNo: String """Fax Valid Y/N""" faxValidYn: String """First""" first: String """Folio Address ID""" folioAddressId: Float """Gender""" gender: String """Guest Priv Y/N""" guestPrivYn: String """Hasnotes""" hasnotes: String """History Y/N""" historyYn: String """Hold Code""" holdCode: String """Home Phone ID""" homePhoneId: Float """Home Phone Number""" homePhoneNumber: String """Specified whether Name_Code column has Company # or IATA #. For Company # the value will beCOMP and for IATA # the Value of this column will be IATA.""" iataCompType: String """IATA Consortia""" iataConsortia: String """IATA Corp No""" iataCorpNumber: String """ID Country""" idCountry: String """ID Date""" idDate: Date """Store the ID value of linked_attachments.attach_id pointing to the physical table column that stores the scanned document.""" idDocumentAttachId: Float """ID Expiration Date""" idExpirationDate: Date """ID Place""" idPlace: String """ID Type""" idType: String """Country Specific Requirement for Nigeria.""" immigrationStatus: String """Inactive Date""" inactiveDate: Date """Reason why record was inactivated.""" inactiveReason: String """Include travel agents/sources profile in 1099 reporting ?Y/N""" includeInTax1099Yn: String """Incognito Displayname""" incognitoDisplayname: String """Incognito First""" incognitoFirst: String """Incognito Name""" incognitoName: String """Incognito Y/N""" incognitoYn: String """Industry Code""" industryCode: String """Influence""" influence: String """Insert Date""" insertDate: DateTime """Insert User""" insertUser: Float """The name of the user who created the record.""" insertUserName: String """Interest Code.""" interest: String """Internal bill that will be solely used for accounting purposes on barter agreements and interim billing amongst hotels which belong to the same owner.""" internalBillYn: String """Primary Key ID""" internalPrimaryKeyIDToUniquelyIdentifyTheRow: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Keyword""" keyword: String """Language""" language: String """Description for each language code.""" languageDesc: String """Last Group""" lastGroup: String """Last Rate""" lastRate: Float """Not used.""" lastRoom: String """Last Source""" lastSource: String """Last Stay""" lastStay: Date """Last property that updated this record.""" lastUpdatedResort: String """Legal Company""" legalCompany: String """Letter Greeting""" letterGreeting: String """Logged Srep Code""" loggedSrepCode: String """Loyalty Segment Codes""" loyaltySegmentCodes: String """Mail List""" mailList: String """The type of mail this user should be sent.""" mailType: String """Mail Y/N""" mailYn: String """Market Research Y/N""" marketResearchYn: String """Markets""" markets: String """Membership Expiration Date""" membershipExpirationDate: Date """Membership ID""" membershipId: Float """Membership Level""" membershipLevel: String """Membership Name On Card""" membershipNameOnCard: String """Membership Number""" membershipNumber: String """User defined field used by external system. Not used by OCIS upgradedowngrade or renewal process.""" membershipStatus: String """Membership Type""" membershipType: String """Middle""" middle: String """Mobile Phone ID""" mobilePhoneId: Float """Mobile Phone Number""" mobilePhoneNumber: String """Multiple Address Y/N""" multipleAddressYn: String """Not used.""" multipleCommentsYn: String """Multiple Phones Y/N""" multiplePhonesYn: String """Name""" name: String """Not Used.""" nameComment: String """Name ID""" nameId: Float """Name Keywords""" nameKeywords: String """Name Type""" nameType: String """Name Type Description""" nameTypeDesc: String """Name2""" name2: String """Name3""" name3: String """Nationality""" nationality: String """Nationality Description""" nationalityDesc: String """Next Stay""" nextStay: Date """Internal ID to uniquely identify the Organization""" organizationID: Float """Number of days a payment is due for the account.""" paymentDueDays: Float """Phone Country Code""" phoneCountryCode: String """Phone Country Dialing Code""" phoneCountryDialingCode: Float """Phone Extension""" phoneExtension: String """Phone ID""" phoneId: Float """Phone no.""" phoneNo: String """Phone Type""" phoneType: String """Phone Valid Y/N""" phoneValidYn: String """Phone Y/N""" phoneYn: String """Preferred Room Number""" preferredRoomNo: String """Profession of the guest""" profession: String """Credit Limit amount for all AR accounts created in different properties for this profile.""" profileCreditLimit: Float """Profile privacy flag determine if the profile is marked as private for a property.""" profilePrivacyFlg: String """Property Action Code""" propertyActionCode: String """Property Competition Code""" propertyCompetitionCode: String """Property Priority""" propertyPriority: String """Property Rooms Potential""" propertyRoomsPotential: String """Protected""" protected: String """Psuedo Profile Y/N""" psuedoProfileYn: String """Reporting Account Type""" repAccountType: String """Reporting Accountsource""" repAccountsource: String """Reporting Actioncode""" repActionCode: String """Reporting Iata Comp Type""" repIATACompType: String """Reporting Inactive Reason""" repInactiveReason: String """Reporting Industry Code""" repIndustryCode: String """Reporting Influence""" repInfluence: String """Reporting Keyword""" repKeyword: String """Reporting Markets""" repMarkets: String """Reporting Name Type""" repNameType: String """Reporting Nationality""" repNationality: String """Reporting Nationality Desc""" repNationalityDescription: String """Reporting Property Priority""" repPropertyPriority: String """Reporting Rooms Potential""" repRoomsPotential: String """Reporting Scope""" repScope: String """Reporting Scope City""" repScopeCity: String """Reporting State""" repState: String """Reporting State Desc""" repStateDescription: String """Reporting Tax Type""" repTaxType: String """Reporting Territory""" repTerritory: String """Reporting Title""" repTitle: String """Reporting Title Name""" repTitleName: String """Reporting Vip Name""" repVIPName: String """Reporting Vip Status""" repVIPStatus: String """User option to replace address in ORS with one from PMS.""" replaceAddress: String """Resort for which Job is registered.""" resortRegistered: String """Restrict Reason Code""" restrictReasonCode: String """RnA Insertdate""" rnaInsertDate: DateTime """RnA Updatedate""" rnaUpdateDate: DateTime """Sales Representative Code for this profile.""" salesrep: String """Salutation Greeting""" salutation: String """Scope""" scope: String """Scope City""" scopeCity: String """Uppercase value of First Name.""" sfirst: String """Use this alert to text a notification.""" smsYn: String """The Uppercase value of Last or Company.""" sname: String """Srep Code""" srepCode: String """Srep ID""" srepId: Float """State""" state: String """State Description of the Guest of Payee""" stateDesc: String """Suffix""" suffix: String """Summ Ref Cc""" summRefCc: String """Internal Indexed field for Searching by Extended Byte First Name.""" sxfirstName: String """Internal Indexed field for Searching by Extended Byte Name.""" sxname: String """Tax1 Number""" tax1No: String """Tax2 Number""" tax2No: String """Tax Category""" taxCategory: String """Tax Office Name""" taxOffice: String """Tax Type""" taxType: String """Territory""" territory: String """Third Party Y/N""" thirdPartyYn: String """Title""" title: String """Title Name""" titleName: String """Title Suffix""" titleSuffix: Float """Total Stay""" totalStay: Float """Tracecode""" tracecode: String """Udfc01""" udfc01: String """Udfc02""" udfc02: String """Udfc03""" udfc03: String """Udfc04""" udfc04: String """Udfc05""" udfc05: String """Udfc06""" udfc06: String """Udfc07""" udfc07: String """Udfc08""" udfc08: String """Udfc09""" udfc09: String """Udfc10""" udfc10: String """Udfc11""" udfc11: String """Udfc12""" udfc12: String """Udfc13""" udfc13: String """Udfc14""" udfc14: String """Udfc15""" udfc15: String """Udfc16""" udfc16: String """Udfc17""" udfc17: String """Udfc18""" udfc18: String """Udfc19""" udfc19: String """Udfc20""" udfc20: String """Udfc21""" udfc21: String """Udfc22""" udfc22: String """Udfc23""" udfc23: String """Udfc24""" udfc24: String """Udfc25""" udfc25: String """Udfc26""" udfc26: String """Udfc27""" udfc27: String """Udfc28""" udfc28: String """Udfc29""" udfc29: String """Udfc30""" udfc30: String """Udfc31""" udfc31: String """Udfc32""" udfc32: String """Udfc33""" udfc33: String """Udfc34""" udfc34: String """Udfc35""" udfc35: String """Udfc36""" udfc36: String """Udfc37""" udfc37: String """Udfc38""" udfc38: String """Udfc39""" udfc39: String """Udfc40""" udfc40: String """Udfd01""" udfd01: Date """Udfd02""" udfd02: Date """Udfd03""" udfd03: Date """Udfd04""" udfd04: Date """Udfd05""" udfd05: Date """Udfd06""" udfd06: Date """Udfd07""" udfd07: Date """Udfd08""" udfd08: Date """Udfd09""" udfd09: Date """Udfd10""" udfd10: Date """Udfd11""" udfd11: Date """Udfd12""" udfd12: Date """Udfd13""" udfd13: Date """Udfd14""" udfd14: Date """Udfd15""" udfd15: Date """Udfd16""" udfd16: Date """Udfd17""" udfd17: Date """Udfd18""" udfd18: Date """Udfd19""" udfd19: Date """Udfd20""" udfd20: Date """Udfn01""" udfn01: Float """Udfn02""" udfn02: Float """Udfn03""" udfn03: Float """Udfn04""" udfn04: Float """Udfn05""" udfn05: Float """Udfn06""" udfn06: Float """Udfn07""" udfn07: Float """Udfn08""" udfn08: Float """Udfn09""" udfn09: Float """Udfn10""" udfn10: Float """Udfn11""" udfn11: Float """Udfn12""" udfn12: Float """Udfn13""" udfn13: Float """Udfn14""" udfn14: Float """Udfn15""" udfn15: Float """Udfn16""" udfn16: Float """Udfn17""" udfn17: Float """Udfn18""" udfn18: Float """Udfn19""" udfn19: Float """Udfn20""" udfn20: Float """Udfn21""" udfn21: Float """Udfn22""" udfn22: Float """Udfn23""" udfn23: Float """Udfn24""" udfn24: Float """Udfn25""" udfn25: Float """Udfn26""" udfn26: Float """Udfn27""" udfn27: Float """Udfn28""" udfn28: Float """Udfn29""" udfn29: Float """Udfn30""" udfn30: Float """Udfn31""" udfn31: Float """Udfn32""" udfn32: Float """Udfn33""" udfn33: Float """Udfn34""" udfn34: Float """Udfn35""" udfn35: Float """Udfn36""" udfn36: Float """Udfn37""" udfn37: Float """Udfn38""" udfn38: Float """Udfn39""" udfn39: Float """Udfn40""" udfn40: Float """Update Date""" updateDate: DateTime """Update User""" updateUser: Float """Update User Name""" updateUserName: String """Upload Date""" uploadDate: Date """VIP Name""" vipName: String """VIP Status""" vipStatus: String """Country Specific Requirement for Nigeria.""" visaValidityType: String """Web Page""" webPage: String """Web Page ID""" webPageId: Float """Xdisplay Name""" xdisplayName: String """Xenvelope Greeting""" xenvelopeGreeting: String """Xfirst Name""" xfirstName: String """Extended Byte middle name.""" xmiddleName: String """Xname""" xname: String """Zipcode Code""" zipCode: String } type SimpleReportsProfileIndividualsProfilePropertyDetailsType { """Action Code""" actionCode: String """AR No""" arNumber: String """Activates auto population of routing instructions.""" autoPopulateRoutingYn: String """Billing Instruction""" billingInstruction: String """Guest type in PH country mode. Further used for showing proper adjustment options.""" birGuestType: String """Business ID""" businessId: String """This column stores the BUSINESS REGISTRATION for a Profile for this property.""" businessRegistration: String """Commission Code""" commissionCode: String """Competition Code""" competitionCode: String """Currency Code""" currencyCode: String """DSI Internal Data Source ID to identify Opera Chain and instance""" dSI: Float """Department Note""" departmentNote: String """Indicates if a Profile can be marked to Generate Fiscal Folio/Payload.""" electronicFiscalFlag: String """Features""" features: String """Guest Type""" guestType: Float """Primary Key ID""" internalPrimaryKeyIDToUniquelyIdentifyTheRow: Float """JRN Update Date""" jRNUpdateDate: Date """JRN Update Date and Time""" jRNUpdateDateAndTime: DateTime """Last date the guest was prompted for privacy option.""" lastPrivacyPromptDate: Date """Name ID""" nameId: Float """Name Tax Type""" nameTaxType: String """Internal ID to uniquely identify the Organization""" organizationID: Float """Payment Method""" paymentMethod: String """Potential Nights""" potentialNights: Float """Potential Revenue""" potentialRevenue: Float """Priority""" priority: String """Product Interest""" productInterest: String """Code to uniquely identify the Property""" property: String """RNA Insert Date""" rNAInsertDate: DateTime """RNA Update Date""" rNAUpdateDate: DateTime """Rate Code""" rateCode: String """Reporting Actioncode""" repActionCode: String """Reporting Competition Code""" repCompetitionCode: String """Reporting Priority""" repPriority: String """Reporting Rooms Potential""" repRoomsPotential: String """Rooms Potential""" roomsPotential: String """Specials""" specials: String """Tax Perc1""" taxPerc1: Float """Tax Perc2""" taxPerc2: Float """Tax Perc3""" taxPerc3: Float """Tax Perc4""" taxPerc4: Float """Tax Perc5""" taxPerc5: Float """Vat Offset Y/N""" vatOffsetYn: String }