Wikidata:Property proposal/PSC

PSC[edit]

Originally proposed at Wikidata:Property proposal/Authority control

Done: Product and Service Code (P9954) (Talk and documentation)

Description	Product and Service Code (aliases: US PSC, US Product and Service Code)
Represents	Product and Service Code (Q108458292)
Data type	External identifier
Domain	product (Q2424752), service (Q7406919)
Allowed values	[0-9A-Z]{1,4}
Example 1	weapon (Q728) → 10 (WEAPONS)
Example 2	camouflage (Q196113) → 1080 (CAMOUFLAGE AND DECEPTION EQUIPMENT)
Example 3	land mine (Q178795) → 1345 (LAND MINES)
Example 4	recreational equipment (Q21550927) → 7830 (RECREATIONAL AND GYMNASTIC EQUIPMENT)
Example 5	research and development (Q276099) → A (RESEARCH AND DEVELOPMENT)
Example 6	geology (Q1069) → B517 (GEOLOGICAL STUDIES)
Example 7	cost–benefit analysis (Q942582) → B505 (COST BENEFIT ANALYSIS)
Example 8	environmental protection (Q832237) → F1 (ENVIRONMENTAL SYSTEMS PROTECTION)
Example 9	oil spill response (Q12717487) → F112 (Oil Spill Response including Cleanup, Removal, Disposal and Operational Support)
Example 10	education (Q8434) → U (EDUCATION AND TRAINING)
Example 11	tuition fee (Q538104) → U005 (Tuition, Registration, and Membership Fees)
Example 12	rechargeable battery (Q187510) → 6140 (Batteries, Rechargeable)
Source	https://www.acquisition.gov/psc-manual, https://www.acquisition.gov/sites/default/files/manual/PSC%20October%202020.xlsx
Number of IDs in source	3855 (date 30 Oct 2021, reference https://www.acquisition.gov/sites/default/files/manual/PSC%20October%202020.xlsx, accessed 8 Sep 2021)
Expected completeness	always incomplete (Q21873886)
Formatter URL	https://www.fscpsc.com/product-service-codes/$1 (applies only to 4-character codes)
See also	NAICS code (P3224), UNSPSC Code (P2167), Common Procurement Vocabulary (P5417)
Wikidata project	WikiProject Companies (Q15271936), WikiProject Economics (Q7212331), WikiProject Authority control (Q88300058)

Motivation[edit]

Notified participants of WikiProject Companies

Notified participants of WikiProject Economics

Notified participants of WikiProject Authority control

NAICS code (P3224) and PSC are used together in the US SAM system, eg:

ATLANTIC BATTERY COMPANY, INC (SAM H8T6DJYXCBQ6, DUNS 001004969, CAGE 14309)
Has NAICS 335911 Storage Battery Manufacturing and 335912 Primary Battery Manufacturing
And PSC 6135 Batteries, Nonrechargeable and 6140 Batteries, Rechargeable

PSC is the analog of Common Procurement Vocabulary (P5417) used in the EU, and UNSPSC Code (P2167) at the UN level.

Third party formatter: https://www.fpds.gov/ezsearch/fpdsportal?indexName=awardfull&templateName=1.4.4&s=FPDS&q=PRODUCT_OR_SERVICE_CODE:$1 (returns contracts for that PSC)

Vladimir Alexiev (talk) 11:42, 8 September 2021 (UTC)[reply]

Discussion[edit]

Support This sounds useful, yes. ArthurPSmith (talk) 16:29, 8 September 2021 (UTC)[reply]
Comment Note that we can't make the formatter URL work for only some values - either it's there for all or not, so the one-character codes might link to an error page I guess. Any chance we could get them to fix the site to allow it? Or is there an alternate formatter for the one-character codes, that might be possible to handle? Also I'm wondering on a case like the "tuition" one - if this is an external identifier then it should be for exact matching links, not broader terms, right? ArthurPSmith (talk) 16:33, 8 September 2021 (UTC)[reply]
Support RShigapov (talk) 16:32, 19 September 2021 (UTC)[reply]
Support Rtnf (talk) 11:25, 29 September 2021 (UTC)[reply]