Property talk:P13179

From Wikidata
Jump to navigation Jump to search

Documentation

Japanese Health Insurance System Facility ID
10-digit identifier for medical/healthcare facilities on Japanese Health Insurance System
[create Create a translatable help page (preferably in English) for this property to be included here]
Allowed entity types are Wikibase item (Q29934200): the property may only be used on a certain entity type (Help)
List of violations of this constraint: Database reports/Constraint violations/P13179#Entity types, hourly updated report
Scope is as main value (Q54828448), as reference (Q54828450): the property must be used by specified way only (Help)
List of violations of this constraint: Database reports/Constraint violations/P13179#Scope, hourly updated report, SPARQL
Type “medical facility (Q4260475), pharmacy (Q13107184): item must contain property “instance of (P31)” with classes “medical facility (Q4260475), pharmacy (Q13107184)” or their subclasses (defined using subclass of (P279)). (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/P13179#Type Q4260475, Q13107184, 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/P13179#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/P13179#Single value, SPARQL
Format “\d{2}[\dA-HJ-NPR-Z]\d{7}: value must be formatted using this pattern (PCRE syntax). (Help)
List of violations of this constraint: Database reports/Constraint violations/P13179#Format, hourly updated report, SPARQL
Item “country (P17): Japan (Q17): Items with this property should also have “country (P17): Japan (Q17)”. (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/P13179#Item P17, search, 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/P13179#Item P131, search, SPARQL
Japanese Health Insurance System Facility ID
Japanese Health Insurance System Facility ID with a wrong check digit. The last digit is the check digit derived using Luhn algorithm (Q915402); however, some issuers omit the first 3 digits for calculating the check digit. Also, there is an extended format that employs an alphanumeric at the 3rd digit (see [1]). (Help)
Violations query: SELECT ?item ?value { { ?item wdt:P13179 ?value } UNION { ?statement pq:P13179 ?value . ?item ?p ?statement . ?prop wikibase:claim ?p } UNION { ?ref pr:P13179 ?value . ?statement prov:wasDerivedFrom ?ref . ?item ?p ?statement . ?prop wikibase:claim ?p } . FILTER( STRLEN(?value) = 10 ) . BIND(STRLEN(STRBEFORE("0123456789ABCDEFGHJKLMNPRSTUVWXYZ", SUBSTR(?value, 3 , 1 ))) AS ?digit3) . BIND( IF( SUBSTR(?value, 1, 2) IN ("13"), 0, STRLEN(STRBEFORE("0516273849", SUBSTR(?value, 1, 1 ))) + xsd:integer(SUBSTR(?value, 2, 1)) + FLOOR(?digit3 * 2 / 10) + (?digit3 * 2 - FLOOR(?digit3 * 2 / 10) * 10) ) + xsd:integer(SUBSTR(?value, 4, 1)) + STRLEN(STRBEFORE("0516273849", SUBSTR(?value, 5, 1 ))) + xsd:integer(SUBSTR(?value, 6, 1)) + STRLEN(STRBEFORE("0516273849", SUBSTR(?value, 7, 1 ))) + xsd:integer(SUBSTR(?value, 8, 1)) + STRLEN(STRBEFORE("0516273849", SUBSTR(?value, 9, 1 ))) + xsd:integer(SUBSTR(?value, 10, 1)) AS ?checksum) . FILTER( FLOOR(?checksum / 10) != (?checksum / 10) ) } ORDER BY ?value
List of this constraint violations: Database reports/Complex constraint violations/P13179#Japanese Health Insurance System Facility ID
Japanese Health Insurance System Facility ID (mismatched prefecture)
Japanese Health Insurance System Facility ID that have mismatched prefecture code. (Help)
Violations query: SELECT ?item ?value { { ?item wdt:P13179 ?value } UNION { ?statement pq:P13179 ?value . ?item ?p ?statement . ?prop wikibase:claim ?p } UNION { ?ref pr:P13179 ?value . ?statement prov:wasDerivedFrom ?ref . ?item ?p ?statement . ?prop wikibase:claim ?p } . FILTER( STRLEN(?value) = 10 ) OPTIONAL { ?item wdt:P131 ?loc . ?loc wdt:P131* ?pref . ?pref wdt:P31 wd:Q50337 . ?pref wdt:P300 ?iso . } BIND(SUBSTR(?value, 1, 2) AS ?prefcode) BIND(SUBSTR(?iso, 4, 2) AS ?isopref) FILTER(?prefcode != ?isopref) } ORDER BY ?value
List of this constraint violations: Database reports/Complex constraint violations/P13179#Japanese Health Insurance System Facility ID (mismatched prefecture)