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)
![공공데이터 공통표준용어(행정안전부고시 제2020-42호, 2020.8.11. 시행)](https://prodskill.com/wp-content/uploads/2022/10/image-34.png)
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.
![공공데이터 공통표준용어(행정안전부고시 제2020-66호, 2020.12.10.)](https://prodskill.com/wp-content/uploads/2022/10/image-35.png)
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 |