Public Data Common Standard Terminology Excel File (2020.12.10)

In this article, you can download the public data common standard term Excel file. This is data converted from the Hangul (hwp) file provided by the Ministry of Public Administration and Security into an Excel file.

---

Data standard inspection tool v1.33 (2021-06-06) was uploaded to github and its usage was summarized on the blog.

Data Standard Check Tool Description Contents , Download

If the dictionary of words, domains, and terms is empty, it is difficult to learn how to use it, and it is difficult to understand the entire concept.

1. Public Data Common Standard Terminology (Distributed by the Ministry of Public Administration and Security)

1.1. Common standard terms for public data (Ministry of Public Administration and Security Notice No. 2020-42, enforced on August 11, 2020)

Resource Links: https://www.mois.go.kr/frt/bbs/type001/commonSelectBoardArticle.do?bbsId=BBSMSTR_000000000016&nttId=79284 

1.2. Public Data Common Standard Terminology (Ministry of Public Administration and Security Notice No. 2020-66, 2020.12.10.)

I recently checked, and the above data was revised once at the end of 2020.

Resource Links: https://www.mois.go.kr/frt/bbs/type001/commonSelectBoardArticle.do?bbsId=BBSMSTR_000000000016&nttId=81609 

2. Public Data Common Standard Terminology Excel File Download

The above data is disclosed in the lower Hangul (hwp) format, so it is difficult to use it right away. I added two files organized as excel files to the github repository.

2020.8.11 Data download (file name: Public Data Common Standard_202008.xlsx)
https://github.com/DAToolset/ToolsForDataStandard/raw/main/Public Data Common Standard_202008.xlsx

2020.12.10 Data download (File name: Public data common standard_202012.xlsx)
https://github.com/DAToolset/ToolsForDataStandard/raw/main/Public Data Common Standard_202012.xlsx

In the 2020.12.10 data, management items and explanations for standard terms, standard words, and standard domains were added to the 'Description of Common Standard Management Items' sheet.

This content was excerpted from the hwp file, which is the original data. pasted below

3. Management items and explanations for standard terms, standard words, and standard domains

Target	Management topics	Explanation
standard terms	common standard terms	Korean names of standard terms commonly used by all organizations (a term used by many institutions and with high frequency of column use)
standard terms	Explanation of Common Standard Terms	Explain in detail the contents of common standard terminology
standard terms	Common Standard Terminology English Abbreviation Name	As an abbreviation that abbreviates the English name of the common standard term, it is created by combining the English abbreviation name of the common standard term.
standard terms	common standard domain name	It is a grouping and classification of common characteristics of data types and common standard terms, and is defined to regulate the format and range of data values. (Common standard domain name consists of 'domain classification name + type + length') (Example) Date C8, Amount N15, Whether C1 * The type is Char, Varchar, Numeric, Datetime, etc.
standard terms	tolerance	Maximum/minimum value or effective value that the corresponding common standard domain can have (Example) Month: 01~12, Whether: 'Y', 'N' ※ The code is the administrative standard code management system (https://www.code.go.kr/) Reference
standard terms	Save format	Format for storing data values of the corresponding common standard domain (Example) February 2020 → YYYYMM (202002)
standard terms	form of expression	A format that expresses the data value of the applicable common standard domain (Example) February 2020 → YYYY-MM (2020-02) ※ Numbers other than the date are marked as “9”, English as “A”, Korean as “Ga”, hexadecimal as “f”
standard terms	Administrative standard code name	If applicable to the administrative standard code, the name of the administrative standard code
standard terms	Name of competent institution	The name of the institution that creates and manages the term
standard word	common standard word name	Korean names for common standard words
standard word	Common Standard Word English Abbreviation Name	English abbreviation for common standard words
standard word	common standard word English name	English full name for common standard words
standard word	Explanation of Common Standard Words	Definitions and explanations of common standard words
standard word	whether it is a formal word	Whether the common standard word is a formal word (classification word) with domain characteristics
standard word	Common standard domain classification name	In the case of a formal word (classification word), the classification name of the applicable common standard domain
standard word	list of allophone synonyms	A list of allophones for that common standard word ※ Allophone synonyms: Words that sound different but have the same meaning (Example) year/year, rate/rate ※ Allophone synonyms are the same except for common standard words and Korean names, so only Korean names are managed
standard word	list of banned words	A list of prohibited words for the corresponding common standard word ※ Prohibited words: Words that are not allowed to be used or that have been used for a certain period of time and have been stopped after a certain point in time (Example) File (standard language) ↔ File (Prohibited words. Used ×) ※ Prohibited words are not subject to common standard word definition, and only Korean names of prohibited words are managed
standard domain	Common standard domain group name	High-level division of common standard domain (Example) Date/Time
standard domain	Common standard domain classification name	Subdivision of Common Standard Domain (Example) Year Month
standard domain	Common standard domain name	Corresponding common standard domain name (Ex) Defined in the form of “common standard domain classification name + data type + length (optional)” (Example: Year C4)
standard domain	Common standard domain description	Definition and explanation of the common standard domain
standard domain	data type	Data type of the common standard domain (Example) Character type (CHAR, VARCHAR), number type (NUMERIC), date type (DATETIME)
standard domain	data length	The length of the data value of the corresponding common standard domain Length including decimal places if decimal point exists ※ As the length in bytes, Korean is based on 2 bytes
standard domain	decimal point length	The maximum number of digits after the decimal point that the data value of the corresponding common standard domain can have (Defined only when a decimal value exists and the data type is a numeric type)
standard domain	Save format	Format for storing data values of the corresponding common standard domain (Example) September 1999 → YYYYMM (199909)
standard domain	form of expression	A format that expresses the data value of the applicable common standard domain (Example) September 1999 → YYYY-MM (1999-09)
standard domain	unit	A unit for measuring the data value of the corresponding common standard domain (Example) m, kg, degrees, etc.
standard domain	tolerance	Maximum/minimum value or effective value that the corresponding common standard domain can have (Example) Month: 01 ~ 12, Whether: 'Y','N'
standard domain	Administrative standard code name	Administrative standard code name, if applicable