Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Support ISO/IEC 6523 as identifier for /Organization #2915

Closed
alex-jansen opened this issue Jul 1, 2021 · 10 comments
Closed

Support ISO/IEC 6523 as identifier for /Organization #2915

alex-jansen opened this issue Jul 1, 2021 · 10 comments
Assignees
Labels
no-issue-activity Discuss has gone quiet. Auto-tagging to encourage people to re-engage with the issue (or close it!).

Comments

@alex-jansen
Copy link
Contributor

The /Organization type has several identification properties, for example, /duns, /leiCode, /globalLocationNumber, /vatID and /taxID.

Many of these existing identifiers can be expressed using the ISO/IEC 6523 standard. ISO 6523 codes are composed from an International Code Designator (ICD) value, which identifies the type of the code (e.g., 0060 for DUNS, 0199 for leiCode, or 9910+9920-9957 for European /vatID), and an Organization Identifier (OI) which identifies the organization within that frame of reference.

We therefore propose to add a new property /iso6523 with values of type /Text for use on type /Organization. Alternatively we could introduce a structured type with the 2 fields ICD and OI for values of /iso6523, but since /leiCode allows values of type /Text we propose to do the same for /iso6523 for consistency.

@github-actions
Copy link

This issue is being nudged due to inactivity.

@github-actions github-actions bot added the no-issue-activity Discuss has gone quiet. Auto-tagging to encourage people to re-engage with the issue (or close it!). label Sep 30, 2021
alex-jansen added a commit that referenced this issue Dec 6, 2021
danbri pushed a commit that referenced this issue Dec 14, 2021
@VladimirAlexiev
Copy link

VladimirAlexiev commented Jan 4, 2024

ISO/IEC 6523 defines the International Code Designator (ICD)

@danbri or @alex-jansen could you capture some of the above info at https://schema.org/iso6523Code?
In particular this is important:

  • To match OID usage, leading zeros should NOT be included in in the ISO 6523 code
  • What's the separator between ICD and OI? Is it : or something else?
  • Please give some examples (I'll try to give examples here and in the related issue)

@alex-jansen, where did you see "9910+9920-9957 for European vatID"? Please describe your source, and give some examples. Thanks!

@VladimirAlexiev
Copy link

VladimirAlexiev commented Jan 4, 2024

Here are examples of Wikidata item (Wikidata property) -> ICD. I plan to add them to Wikidata

  • US CAGE, NATO NCAGE supplier code: Q1115390 (P5574) -> 0141
  • US DoDAAC military unit: Q5285896 -> 0144
  • SE Organisationsnummer: Q10611373 (P6460) -> 0007
  • FR SIRENE company number: Q3509449 (P1616) -> 0002
  • CH Enterprise Identification Number: Q2498375 (P4829) -> 0183
  • Association for Font Information Interchange: Q119728880 -> 0010 (inactive)
  • RU Classifier of Enterprises and Organizations (Общероссийский классификатор предприятий и организаций): Q15817104 (P2391) -> 0029
  • DnB DUNS company number: Q246386 (P2771) -> 0060
  • GS1 GLN company/location code: Q1258830 (P9860) -> 0088 (called "EAN Location Code")
  • GS1 GTIN goods code: Q521568 (P3962) -> 0160
  • CA business number: Q101003149 (P8860) -> 0093 (called "Revenue Canada Business Number Registration")
  • IANA IP addressing: Q11135 -> 0090
  • European Commission directorate general: Q1485366 -> 0130
  • China National Organization Code Registration Authority (same as National Administration for Code Allocation to Organizations?) -> 0131

@VladimirAlexiev
Copy link

@danbri and @alex-jansen please answer the questions in my first comment.
In particular, is the delimiter :? Where is this documented?

@MatthiasWiesmann
Copy link
Contributor

MatthiasWiesmann commented Jan 8, 2024

Vladimir, this is documented inside the ISO/IEC 6523-1 standard. To characters are given as examples of separators, colon and slash. Given the prevalence of slashes in web-content, colon seems safer. Colon also seems to be the commen format in EDI systems that leverage ISO 6523.

@danbri
Copy link
Contributor

danbri commented Jan 8, 2024

If the ISO spec is not public it could be good to improve the documentation we have here (within appropriate limits).

@MatthiasWiesmann
Copy link
Contributor

I will prepare a change with improved documentation.

@Tiggerito
Copy link

I eventually found a mostly usable ICD list here:

https://ec.europa.eu/digital-building-blocks/wikis/display/DIGITAL/Registry+of+supporting+artefacts+to+implement+EN16931#RegistryofsupportingartefactstoimplementEN16931-Codelists

It's tricky to get the sheet as the URLs are broken:

  1. Pick the latest "Full listing" from lower down on the page
  2. Copy its URL
  3. Remove the query string parameters
  4. Browse the new URL
  5. Open the sheet
  6. Go to the EAS tab

There is also an ECD tab that is missing the 9XXX ones (VAT numbers) but seems to have others, like 0141, which is missing from the EAS tab. I found more numbers in other places but discovered they had been deprecated (first list on that page).

So far, I've yet to find a definitive list to work from.

I also altered some of the names to make them more findable. e.g. I added "UK" to 9932, "DUNS" to 0060, "LEI" to 0199 and "United States" to 9959. I have a nice searchable dropdown for my clients :-)

@MatthiasWiesmann
Copy link
Contributor

MatthiasWiesmann commented Jan 9, 2024

I uploaded an proposal with improved documentation here: https://iso6523-dot-schemadotorg1.ew.r.appspot.com/Organization

Besides the documentation for the iso6523Code field, I also completed the examples.

please have a look and let me know if it helps.

@Tiggerito
Copy link

I like it.

There's a funny (-1) in the link.

It would be nice if it could reference a source for the UIDs. If I had trouble finding them, the average website developer would struggle.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
no-issue-activity Discuss has gone quiet. Auto-tagging to encourage people to re-engage with the issue (or close it!).
Projects
None yet
Development

No branches or pull requests

5 participants