Property talk:P13179
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
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 reportScope 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, SPARQLType “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
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
Item “located in the administrative territorial entity (P131)”: Items with this property should also have “located in the administrative territorial entity (P131)”. (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 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:
List of this constraint violations: Database reports/Complex constraint violations/P13179#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:
List of this constraint violations: Database reports/Complex constraint violations/P13179#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)
|
Categories:
- Japan-related properties
- All Properties
- Properties with external-id-datatype
- Unused properties
- Properties with entity type constraints
- Properties with scope constraints
- Properties with constraints on type
- Properties with unique value constraints
- Properties with single value constraints
- Properties with format constraints
- Properties with constraints on items using them
- Properties with complex constraints
- Organisation properties