# Entries: KOOP (NL) PLOOI Entries
- Catalog: `PLOOI`
- Schema: `KOOP`
- Label: Entries
This is a read-only table function. The KOOP (NL) PLOOI API may not support changing the data or the Invantive UniversalSQL driver for KOOP (NL) PLOOI does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the KOOP (NL) PLOOI API.
## Parameters of Table Function
The following parameters can be used to control the behaviour of the table function `Entries`. A value must be provided at all times for required parameters, but optional parameters in general do not need to have a value and the execution will default to a pre-defined behaviour. Values can be specified by position and by name. In both cases, all parameters not specified will be evaluated using their default values.
Value specification by position is done by listing all values from the first to the last needed value. For example: a `select * from table(value1, value2, value3)` on a table with four parameters will use the default value for the fourth parameter and the specified values for the first three.
Value specification by name is done by listing all values that require a value. For example with `select * from table(name1 => value1, name3 => value3)` on the same table will use the default values for the second and fourth parameters and the specified values for the first and third.
| Name | Data Type | Required | Default Value | Documentation |
|---|:---:|:---:|:---:|---|
| `textAndIndexes` | `` | ☐ | | Search across all text fields. |
## Columns of Table Function
The columns of the table function `Entries` are shown below. Each column has an SQL data type.
| Name | Data Type | Label | Required | Documentation |
|---|:---:|---|:---:|---|
| `Abbreviation` | `varchar2` | Abbreviation | ☐ | |
| `Abstract` | `varchar2` | Abstract | ☐ | |
| `AchievementDate0` | `datetime` | #1 | ☐ | |
| `AchievementDate1` | `datetime` | #2 | ☐ | |
| `AchievementDate2` | `datetime` | #3 | ☐ | |
| `AchievementDate3` | `datetime` | #4 | ☐ | |
| `AchievementDate4` | `datetime` | #5 | ☐ | |
| `AchievementDate` | `varchar2` | (grouped) | ☐ | |
| `ActItemNumber` | `varchar2` | | ☐ | |
| `ActivityScheme` | `varchar2` | Activity Scheme | ☐ | |
| `Activity` | `varchar2` | Activity | ☐ | |
| `AgreementStatus` | `varchar2` | | ☐ | |
| `AgreementType` | `varchar2` | Type Agreement | ☐ | |
| `Alternative` | `varchar2` | Alternative | ☐ | |
| `Announcement` | `varchar2` | Publication | ☐ | |
| `Annual` | `int32` | | ☐ | |
| `Appendix` | `varchar2` | Attachment | ☐ | |
| `AreaMarkingCadastralSection` | `varchar2` | Area Marking Water Cadastral Section | ☐ | |
| `AreaMarkingGeometryLabel` | `varchar2` | Area Marking Geometry Label | ☐ | |
| `AreaMarkingGeometry` | `varchar2` | Area Marking Geometry | ☐ | |
| `AreaMarkingHectometreNumber` | `varchar2` | Area Marking Water Hectometre Number | ☐ | |
| `AreaMarkingHouseCharacter` | `varchar2` | Area Marking House Character | ☐ | |
| `AreaMarkingHouseNumberAddition` | `varchar2` | Area Marking House Number Addition | ☐ | |
| `AreaMarkingHouseNumber` | `varchar2` | Area Marking House Number | ☐ | |
| `AreaMarkingLocatedInMunicipality` | `varchar2` | Area Marking Located in Municipality | ☐ | |
| `AreaMarkingLocatedInProvinceScheme` | `varchar2` | Area Marking Located in Province Scheme | ☐ | |
| `AreaMarkingLocatedInProvince` | `varchar2` | Area Marking is in Province | ☐ | |
| `AreaMarkingLocationArea` | `varchar2` | Area Marking Location Area | ☐ | |
| `AreaMarkingLocationPoint` | `varchar2` | Area Marking Location Point | ☐ | |
| `AreaMarkingLotNumber` | `varchar2` | Area Marking Water Lot Number | ☐ | |
| `AreaMarkingMunicipalityNameScheme` | `varchar2` | Area Marking Municipality Name Scheme | ☐ | |
| `AreaMarkingMunicipalityName` | `varchar2` | Area Marking Municipality Name | ☐ | |
| `AreaMarkingPostcode` | `varchar2` | Area Marking Postcode | ☐ | |
| `AreaMarkingProvinceName` | `varchar2` | Area Marking Province Name | ☐ | |
| `AreaMarkingResidence` | `varchar2` | Area Marking Residence | ☐ | |
| `AreaMarkingRoadNumber` | `varchar2` | Area Marking Water Road Number | ☐ | |
| `AreaMarkingScheme` | `varchar2` | Area Marking Scheme | ☐ | |
| `AreaMarkingStreetName` | `varchar2` | Area Marking Street Name | ☐ | |
| `AreaMarkingType` | `varchar2` | Area Marking Type | ☐ | |
| `AreaMarkingWaterAuthorityName` | `varchar2` | Area Marking Water Authority Name | ☐ | |
| `AttachmentNumber` | `varchar2` | Attachment Number | ☐ | |
| `Attachment` | `varchar2` | Attachment | ☐ | |
| `AudienceScheme` | `varchar2` | Audience Scheme | ☐ | |
| `Audience` | `varchar2` | Audience | ☐ | |
| `AuthorityResourceIdentifier` | `varchar2` | Authority Resource Identifier | ☐ | |
| `AuthorityScheme` | `varchar2` | Authority Scheme | ☐ | |
| `Authority` | `varchar2` | Authority | ☐ | |
| `AvailableForInspectionBG` | `varchar2` | | ☐ | |
| `AvailableForInspectionOP` | `varchar2` | | ☐ | |
| `Available` | `datetime` | Available | ☐ | |
| `BailiffFile` | `varchar2` | | ☐ | |
| `CadastralSection` | `varchar2` | | ☐ | |
| `CaseNumber` | `varchar2` | Case Number | ☐ | |
| `ChainID` | `varchar2` | | ☐ | |
| `CompanyName` | `varchar2` | Company Name | ☐ | |
| `ConcernsCaption` | `varchar2` | | ☐ | |
| `ConcernsScheme` | `varchar2` | | ☐ | |
| `Concerns` | `varchar2` | Concerns | ☐ | |
| `ContactPoint` | `varchar2` | Contact Point | ☐ | |
| `ContentArea` | `varchar2` | Content Area | ☐ | |
| `ContentIndication` | `varchar2` | Content Indication | ☐ | |
| `CoverHasVersion` | `varchar2` | Has Version | ☐ | |
| `Created` | `datetime` | Created | ☐ | |
| `CreatorAlt` | `varchar2` | Creator | ☐ | |
| `CreatorScheme` | `varchar2` | Creator Scheme | ☐ | |
| `Creator` | `varchar2` | Creator | ☐ | |
| `DataUrl` | `varchar2` | Data (URL) | ☐ | |
| `DateEstablished` | `varchar2` | Estabishment Date | ☐ | |
| `DateNotification` | `datetime` | Date Notification | ☐ | |
| `Date` | `datetime` | Date | ☐ | |
| `DecisionRequirement` | `varchar2` | | ☐ | |
| `Decision` | `varchar2` | Decision | ☐ | |
| `DerivedLocationArea` | `varchar2` | Derived Location Area | ☐ | |
| `DerivedMunicipality` | `varchar2` | Derived Municipality | ☐ | |
| `Description` | `varchar2` | Description | ☐ | |
| `DocumentStatus` | `varchar2` | Document Status | ☐ | |
| `DocumentTitle` | `varchar2` | Document Title | ☐ | |
| `DocumentType` | `varchar2` | Document Type | ☐ | |
| `Ecli` | `varchar2` | ECLI | ☐ | |
| `EffectAreaGeometryLabel` | `varchar2` | Effect Area Geometry Label | ☐ | |
| `EffectAreaGeometry` | `varchar2` | Effect Area Geometry | ☐ | |
| `EffectAreaLocationArea` | `varchar2` | Effect Area Location Area | ☐ | |
| `EffectiveDate` | `datetime` | | ☐ | |
| `EndDate` | `datetime` | End Date | ☐ | |
| `EndPage` | `varchar2` | End Page | ☐ | |
| `EndResponsePeriodDate` | `datetime` | | ☐ | |
| `ExpressionChangeDate` | `datetime` | | ☐ | |
| `ExternalAttachment` | `varchar2` | External Attachment | ☐ | |
| `Feature` | `varchar2` | Reference | ☐ | |
| `FileNumber` | `varchar2` | Document Number | ☐ | |
| `FileTitle` | `varchar2` | File Title | ☐ | |
| `Format` | `varchar2` | Format | ☐ | |
| `GeometryLabel` | `varchar2` | Geometry Label | ☐ | |
| `HandledFile` | `varchar2` | | ☐ | |
| `HasNotice` | `varchar2` | Has Note | ☐ | |
| `HasPart` | `varchar2` | Has Part | ☐ | |
| `HasVersionResourceIdentifier` | `varchar2` | Has Version Resource Identifier | ☐ | |
| `HasVersion` | `int32` | Has Version | ☐ | |
| `HectometerNumber` | `varchar2` | | ☐ | |
| `HouseLetter` | `varchar2` | House Character | ☐ | |
| `HouseNumberAddition` | `varchar2` | House Number Addition | ☐ | |
| `HouseNumber` | `varchar2` | House Number | ☐ | |
| `Identifier` | `varchar2` | Identifier | ☐ | |
| `IneffectiveDate` | `datetime` | | ☐ | |
| `InstanceDomain` | `varchar2` | Instance Domain | ☐ | |
| `InstancePlace` | `varchar2` | Instance Place | ☐ | |
| `InstanceType` | `varchar2` | Instance Type | ☐ | |
| `IsConsolidatonOf` | `varchar2` | Is Consolidation of | ☐ | |
| `IsFormatOf` | `char` | Is Format of | ☐ | |
| `IsHagueConferenceOnPrivateLaw` | `char` | | ☐ | |
| `IsNLDepositair` | `char` | | ☐ | |
| `IsPartOf` | `varchar2` | Is Part of | ☐ | |
| `IsReplacedBy` | `varchar2` | Is Replaced by | ☐ | |
| `IsRequiredBy` | `varchar2` | Is Required by | ☐ | |
| `Issued` | `datetime` | Issued | ☐ | |
| `ItemUrlManifestation` | `varchar2` | Item URL Manifestation | ☐ | |
| `Jurisdiction` | `varchar2` | | ☐ | |
| `Keyword` | `varchar2` | Keyword | ☐ | |
| `Language` | `varchar2` | Language | ☐ | |
| `LawFamily` | `varchar2` | | ☐ | |
| `LegalDomain` | `varchar2` | Legal Domain | ☐ | |
| `LetterDate` | `datetime` | Date Letter | ☐ | |
| `Ljn` | `varchar2` | LJN | ☐ | |
| `LocatedInMunicipality` | `varchar2` | Is in Municipality | ☐ | |
| `LocatedInProvince` | `varchar2` | Is in Province | ☐ | |
| `LocationAchievement` | `varchar2` | | ☐ | |
| `LocationPoint` | `varchar2` | Location Point | ☐ | |
| `LotNumber` | `varchar2` | Lot Number | ☐ | |
| `MainDocument` | `varchar2` | Main Document | ☐ | |
| `MeetingDate` | `datetime` | Date Meeting | ☐ | |
| `MeetingYear` | `varchar2` | Meeting Year | ☐ | |
| `Modified` | `datetime` | Modified | ☐ | |
| `MunicipalityName` | `varchar2` | Municipality Name | ☐ | |
| `Municipality` | `varchar2` | Municipality | ☐ | |
| `NoticeAbout` | `varchar2` | | ☐ | |
| `NoticeConcerningPlan` | `varchar2` | Publication Regarding Plan | ☐ | |
| `NumberOfPages` | `int32` | Number of Pages | ☐ | |
| `OneOffSubscription` | `varchar2` | | ☐ | |
| `OnlineRequests` | `varchar2` | Online Requests | ☐ | |
| `OpinionStateCouncil` | `varchar2` | Recommendation Raad van State | ☐ | |
| `OrganisationTypeScheme` | `varchar2` | Organisation Type Scheme | ☐ | |
| `OrganisationType` | `varchar2` | Organisation Type | ☐ | |
| `PartyAltScheme` | `varchar2` | Party Alt Scheme | ☐ | |
| `PartyAlt` | `varchar2` | Party | ☐ | |
| `Party` | `varchar2` | Party | ☐ | |
| `PersonalData` | `varchar2` | Personal Data | ☐ | |
| `PlansoortScheme` | `varchar2` | Plan Type Scheme | ☐ | |
| `Plansoort` | `varchar2` | | ☐ | |
| `PostcodeHouseNumber` | `varchar2` | Postal Code House Number | ☐ | |
| `Postcode` | `varchar2` | Postal Code | ☐ | |
| `PreferredEnUrl` | `varchar2` | Preferred English URL | ☐ | |
| `PreferredPublicationUrl` | `varchar2` | Preferred Publication URL | ☐ | |
| `ProductArea` | `varchar2` | Product Area | ☐ | |
| `ProductHtml` | `varchar2` | Product HTML | ☐ | |
| `ProductId` | `varchar2` | Product ID | ☐ | |
| `ProductNameResourceIdentifier` | `varchar2` | Product Resource Identifier | ☐ | |
| `ProfessionalGroup` | `varchar2` | | ☐ | |
| `ProvinceAltScheme` | `varchar2` | | ☐ | |
| `ProvinceAlt` | `varchar2` | Province | ☐ | |
| `ProvinceName` | `varchar2` | Province Name | ☐ | |
| `Province` | `varchar2` | Province | ☐ | |
| `ProvisionalApplicationDate` | `datetime` | | ☐ | |
| `PublicationName` | `varchar2` | Publication Name | ☐ | |
| `PublicationNumber` | `varchar2` | Publication Number | ☐ | |
| `PublishedAmendmentDate` | `datetime` | Date Published Change | ☐ | |
| `PublisherScheme` | `varchar2` | Publisher Scheme | ☐ | |
| `Publisher` | `varchar2` | Publisher | ☐ | |
| `QuestionNumber` | `varchar2` | | ☐ | |
| `ReceiptDate` | `datetime` | Date Reception | ☐ | |
| `Recipient` | `varchar2` | Recipient | ☐ | |
| `RecordPosition` | `int32` | Record Position | ☐ | |
| `ReferenceNumber` | `varchar2` | Reference Number | ☐ | |
| `ReferendabilityDecision` | `varchar2` | | ☐ | |
| `RelatedProduct` | `varchar2` | Related Product | ☐ | |
| `Relation` | `varchar2` | Relation | ☐ | |
| `Replaces` | `varchar2` | Replaces | ☐ | |
| `RequestUrl` | `varchar2` | Request (URL) | ☐ | |
| `RequirementOfDecisionScheme` | `varchar2` | Requirement of Decision Scheme | ☐ | |
| `RequirementOfDecision` | `varchar2` | Requirement of Decision | ☐ | |
| `Requires` | `varchar2` | Requires | ☐ | |
| `ResidenceCity` | `varchar2` | Residence City | ☐ | |
| `RetroactiveDate` | `datetime` | | ☐ | |
| `RoadCategoryScheme` | `varchar2` | Road Category Scheme | ☐ | |
| `RoadCategory` | `varchar2` | Road Category | ☐ | |
| `RoadNumber` | `varchar2` | Road Number | ☐ | |
| `RoadUserScheme` | `varchar2` | Road User Scheme | ☐ | |
| `RoadUser` | `varchar2` | Road User | ☐ | |
| `RulingDate` | `datetime` | | ☐ | |
| `SessionDate` | `datetime` | | ☐ | |
| `SignatureDate` | `datetime` | Date Signature | ☐ | |
| `Signature` | `varchar2` | Signature | ☐ | |
| `SignificantlyElaborated` | `varchar2` | | ☐ | |
| `Source0` | `varchar2` | Source #1 | ☐ | |
| `Source10` | `varchar2` | Source #11 | ☐ | |
| `Source11` | `varchar2` | Source #12 | ☐ | |
| `Source12` | `varchar2` | Source #13 | ☐ | |
| `Source13` | `varchar2` | Source #14 | ☐ | |
| `Source14` | `varchar2` | Source #15 | ☐ | |
| `Source15` | `varchar2` | Source #16 | ☐ | |
| `Source16` | `varchar2` | Source #17 | ☐ | |
| `Source17` | `varchar2` | Source #18 | ☐ | |
| `Source18` | `varchar2` | Source #19 | ☐ | |
| `Source19` | `varchar2` | Source #20 | ☐ | |
| `Source1` | `varchar2` | Source #2 | ☐ | |
| `Source2` | `varchar2` | Source #3 | ☐ | |
| `Source3` | `varchar2` | Source #4 | ☐ | |
| `Source4` | `varchar2` | Source #5 | ☐ | |
| `Source5` | `varchar2` | Source #6 | ☐ | |
| `Source6` | `varchar2` | Source #7 | ☐ | |
| `Source7` | `varchar2` | Source #8 | ☐ | |
| `Source8` | `varchar2` | Source #9 | ☐ | |
| `Source9` | `varchar2` | Source #10 | ☐ | |
| `SourceIdentifier` | `varchar2` | Source Identifier | ☐ | |
| `Source` | `varchar2` | Source (grouped) | ☐ | |
| `SpatialResourceIdentifier` | `varchar2` | Spatial Resource Identifier | ☐ | |
| `SpatialScheme` | `varchar2` | Spatial Scheme | ☐ | |
| `SpatialType` | `varchar2` | Spatial Type | ☐ | |
| `Spatial` | `varchar2` | Spatial | ☐ | |
| `Speaker` | `varchar2` | Speaker | ☐ | |
| `StartPage` | `varchar2` | Start Page | ☐ | |
| `Startdate` | `datetime` | Start Date | ☐ | |
| `StateLawNumber` | `varchar2` | | ☐ | |
| `StreetName` | `varchar2` | Street Name | ☐ | |
| `SubNumber` | `varchar2` | Sub Number | ☐ | |
| `SubSectionScheme` | `varchar2` | Subsection Scheme | ☐ | |
| `SubSection` | `varchar2` | | ☐ | |
| `SubSubject` | `varchar2` | Sub Subject | ☐ | |
| `Subject0` | `varchar2` | Subject #1 | ☐ | |
| `Subject1` | `varchar2` | Subject #2 | ☐ | |
| `Subject2` | `varchar2` | Subject #3 | ☐ | |
| `Subject3` | `varchar2` | Subject #4 | ☐ | |
| `Subject4` | `varchar2` | Subject #5 | ☐ | |
| `Subject5` | `varchar2` | Subject #6 | ☐ | |
| `Subject6` | `varchar2` | Subject #7 | ☐ | |
| `Subject7` | `varchar2` | Subject #8 | ☐ | |
| `Subject8` | `varchar2` | Subject #9 | ☐ | |
| `Subject9` | `varchar2` | Subject #10 | ☐ | |
| `SubjectAlt` | `varchar2` | Subject | ☐ | |
| `SubjectScheme0` | `varchar2` | Subject Scheme 0 | ☐ | |
| `SubjectScheme1` | `varchar2` | Subject Scheme 1 | ☐ | |
| `SubjectScheme2` | `varchar2` | Subject Scheme 2 | ☐ | |
| `SubjectScheme3` | `varchar2` | Subject Scheme 3 | ☐ | |
| `SubjectScheme4` | `varchar2` | Subject Scheme 4 | ☐ | |
| `SubjectScheme5` | `varchar2` | Subject Scheme 5 | ☐ | |
| `SubjectScheme6` | `varchar2` | Subject Scheme 6 | ☐ | |
| `SubjectScheme7` | `varchar2` | Subject Scheme 7 | ☐ | |
| `SubjectScheme8` | `varchar2` | Subject Scheme 8 | ☐ | |
| `SubjectScheme9` | `varchar2` | Subject Scheme 9 | ☐ | |
| `SubjectScheme` | `varchar2` | Subject Scheme | ☐ | |
| `Subject` | `varchar2` | Subject (grouped) | ☐ | |
| `SubmissionDate` | `datetime` | | ☐ | |
| `Submitter` | `varchar2` | | ☐ | |
| `SysNumber` | `varchar2` | Sysnumber | ☐ | |
| `SysSeqNumber` | `varchar2` | Sysseqnumber | ☐ | |
| `SysYear` | `varchar2` | Sysyear | ☐ | |
| `Temporal` | `varchar2` | Temporal | ☐ | |
| `Timestamp` | `datetimeoffset` | Timestamp | ☐ | |
| `TitleAltScheme` | `varchar2` | Title (Alternative) Scheme | ☐ | |
| `TitleAlt` | `varchar2` | Title | ☐ | |
| `TitleLanguage` | `varchar2` | Title Language | ☐ | |
| `TitleNotification` | `varchar2` | | ☐ | |
| `Title` | `varchar2` | Title | ☐ | |
| `TrafficDecisionTypeScheme` | `varchar2` | Traffic Decision Type Scheme | ☐ | |
| `TrafficDecisionType` | `varchar2` | | ☐ | |
| `TrafficSignCode` | `varchar2` | | ☐ | |
| `TreatyNumber` | `varchar2` | | ☐ | |
| `TypeScheme` | `varchar2` | Type Scheme | ☐ | |
| `Type` | `varchar2` | Type | ☐ | |
| `UniformProductNameScheme` | `varchar2` | Uniform Product Name Scheme | ☐ | |
| `UniformProductName` | `varchar2` | | ☐ | |
| `ValidPeriodArubaEndDate` | `datetime` | | ☐ | |
| `ValidPeriodArubaStartDate` | `datetime` | | ☐ | |
| `ValidPeriodAruba` | `varchar2` | Valid Period Aruba | ☐ | |
| `ValidPeriodBonaireEndDate` | `datetime` | | ☐ | |
| `ValidPeriodBonaireStartDate` | `datetime` | | ☐ | |
| `ValidPeriodBonaire` | `varchar2` | Valid Period Bonaire | ☐ | |
| `ValidPeriodCuracaoEndDate` | `datetime` | | ☐ | |
| `ValidPeriodCuracaoStartDate` | `datetime` | | ☐ | |
| `ValidPeriodCuracao` | `varchar2` | Valid Period Curacao | ☐ | |
| `ValidPeriodEndDate` | `datetime` | | ☐ | |
| `ValidPeriodNetherlandsEndDate` | `datetime` | | ☐ | |
| `ValidPeriodNetherlandsStartDate` | `datetime` | | ☐ | |
| `ValidPeriodNetherlands` | `varchar2` | Valid Period the Netherlands | ☐ | |
| `ValidPeriodSabaEndDate` | `datetime` | | ☐ | |
| `ValidPeriodSabaStartDate` | `datetime` | | ☐ | |
| `ValidPeriodSaba` | `varchar2` | Valid Period Saba | ☐ | |
| `ValidPeriodSintEustatiusEndDate` | `datetime` | | ☐ | |
| `ValidPeriodSintEustatiusStartDate` | `datetime` | | ☐ | |
| `ValidPeriodSintEustatius` | `varchar2` | Valid Period Sint Eustatius | ☐ | |
| `ValidPeriodSintMaartenEndDate` | `datetime` | | ☐ | |
| `ValidPeriodSintMaartenStartDate` | `datetime` | | ☐ | |
| `ValidPeriodSintMaarten` | `varchar2` | Valid Period Sint Maarten | ☐ | |
| `ValidPeriodStartDate` | `datetime` | | ☐ | |
| `ValidPeriod` | `varchar2` | Valid Period | ☐ | |
| `VerdictText` | `varchar2` | Verdict Text | ☐ | |
| `VersionInformation` | `varchar2` | Version Information | ☐ | |
| `VersionNumber` | `varchar2` | Version Number | ☐ | |
| `ViewPeriodEndDate` | `datetime` | | ☐ | |
| `ViewPeriodStartDate` | `datetime` | | ☐ | |
| `ViewPeriod` | `varchar2` | View Period | ☐ | |
| `WaterAuthorityName` | `varchar2` | | ☐ | |
| `WaterAuthority` | `varchar2` | | ☐ | |
| `WorkChangeDate` | `datetime` | | ☐ | |