Property talk:P3125
Jump to navigation
Jump to search
Documentation
EDRPOU code
Ukrainian state registry legal entity identifier
Ukrainian state registry legal entity identifier
Description | Ukrainian state registry legal entity identifier | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Data type | External identifier | ||||||||||||
Template parameter | |ЄДРПОУ= , in uk:Шаблон:Картка_компанії | ||||||||||||
Domain | organizations (note: this should be moved to the property statements) | ||||||||||||
Allowed values | According to this template:
up to 8 digits
According to statements in the property:
When possible, data should only be stored as statements[0-9]{8} | ||||||||||||
Example | Naftogaz (Q728513) → 20077720 State University of Trade and Economics (Q694219) → 01566117 | ||||||||||||
Formatter URL | https://opendatabot.ua/c/$1 https://clarity-project.info/edr/$1 https://youcontrol.com.ua/catalog/company_details/$1 | ||||||||||||
Robot and gadget jobs | import from wikipedia | ||||||||||||
Related to country | ![]() | ||||||||||||
See also | Textile Connect publication ID (P7110) | ||||||||||||
Lists |
| ||||||||||||
Proposal discussion | Proposal discussion | ||||||||||||
Current uses |
| ||||||||||||
Search for values |
[create Create a translatable help page (preferably in English) for this property to be included here]
List of violations of this constraint: Database reports/Constraint violations/P3125#Format, hourly updated report, SPARQL
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3125#Item P31, search, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P3125#Item P31, search, SPARQL
Allowed entity types are Wikibase item (Q29934200): the property may only be used on a certain entity type (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303). List of violations of this constraint: Database reports/Constraint violations/P3125#Entity types
Scope is as main value (Q54828448), as reference (Q54828450): the property must be used by specified way only (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303). List of violations of this constraint: Database reports/Constraint violations/P3125#Scope, SPARQL
Distinct values: this property likely contains a value that is different from all other items. (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303). List of violations of this constraint: Database reports/Constraint violations/P3125#Unique value, SPARQL (every item), SPARQL (by value)
Single value: this property generally contains a single value. (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303). List of violations of this constraint: Database reports/Constraint violations/P3125#Single value, SPARQL
![](http://178.128.105.246/cars-http-upload.wikimedia.org/wikipedia/commons/thumb/a/a6/Pictogram_voting_comment.svg/40px-Pictogram_voting_comment.svg.png)
Partial validation of checksum
documentation : http://1cinfo.com.ua/Articles/Proverka_koda_po_EDRPOU.aspx (Help)
Violations query:
List of this constraint violations: Database reports/Complex constraint violations/P3125#Partial validation of checksum
documentation : http://1cinfo.com.ua/Articles/Proverka_koda_po_EDRPOU.aspx (Help)
Violations query:
SELECT ?item ?value ?int { { ?item wdt:P3125 ?value } UNION { ?statement pq:P3125 ?value . ?item ?p ?statement . ?prop wikibase:claim ?p } UNION { ?ref pr:P3125 ?value . ?statement prov:wasDerivedFrom ?ref . ?item ?p ?statement . ?prop wikibase:claim ?p } . FILTER(STRLEN(?value) = 8) . BIND(xsd:integer(?value) AS ?int) . BIND(?int > 30000000 AS ?isBig) . BIND( xsd:integer(SUBSTR(?nohyphen, 1, 1)) * 7 + xsd:integer(SUBSTR(?nohyphen, 2, 1)) * 1 + xsd:integer(SUBSTR(?nohyphen, 3, 1)) * 2 + xsd:integer(SUBSTR(?nohyphen, 4, 1)) * 3 + xsd:integer(SUBSTR(?nohyphen, 5, 1)) * 4 + xsd:integer(SUBSTR(?nohyphen, 6, 1)) * 5 + xsd:integer(SUBSTR(?nohyphen, 7, 1)) * 6 AS ?checksum). BIND(FLOOR(?checksum / 11) * 11 AS ?rest). FILTER (?rest = xsd:integer(SUBSTR(?nohyphen, 1, 8))). FILTER (?isBig). }
List of this constraint violations: Database reports/Complex constraint violations/P3125#Partial validation of checksum
![]() |
This property is being used by:
Please notify projects that use this property before big changes (renaming, deletion, merge with another property, etc.) |
|
Discussion
[edit]Need separate VAT id
[edit] Notified participants of WikiProject Companies
Notified participants of WikiProject Economics
Notified participants of WikiProject Ukraine
Notified participants of WikiProject Authority control
I think we need a separate property "ПДВ ид" (Ukrainian VAT id).
- Eg Energoatom (Q938225) has ЕГРПОУ 24584661 but ПДВ 245846626653. You can see this at https://opendatabot.ua/c/24584661.
- The VAT id is important at least for energy companies, because it's used in Energy Identification Code (P8645) records.
- Eg if you search for "62X205270350215R" at https://www.entsoe.eu/data/energy-identification-codes-eic/eic-approved-codes/, you'll find Energoatom listed with VAT code "UA245846626653".
Does anyone know what's the relation between the two id's? There is a lot of similarity...
Can some Ukrainian participant start a property request? I'll contribute to it. --Vladimir Alexiev (talk) 09:10, 20 July 2022 (UTC)
Categories:
- Ukraine-related properties
- All Properties
- Properties with external-id-datatype
- Properties used on 100+ items
- Properties with format constraints
- Properties with constraints on items using them
- Properties with entity type constraints
- Properties with scope constraints
- Properties with unique value constraints
- Properties with single value constraints
- Properties with complex constraints
- Organisation properties