csv file description

From wiki.eclass.eu
Jump to: navigation, search

You will find hereunder a detailed description of the csv files.

Please note, that

  • "A_B" stands for the eCl@ss Release number
  • “xy” stands for a language code


Contents

[edit] eClassA_B_CC_xy.csv (Class table)

No. Attribute Name Description Length
1 Supplier** International Code Designator (0173-1 for eCl@ss) CHAR(6)
2 IdCC** Identifier + VersionNumber CHAR(9)
3 Identifier** Identifier (unique within the structure element type: class) CHAR(6)
4 VersionNumber** Version number CHAR(3)
5 VersionDate Publication date of version CHAR(10)
6 RevisionNumber Revision number CHAR(2)
7 CodedName eCl@ss class code CHAR(8)
8 PreferredName Name CHAR(80)
9 Definition Definition CHAR(1023)
10 ISOLanguageCode Language code according to ISO 639-1 / ISO 639-2, e.g. „en“ CHAR(2)
11 ISOCountryCode Country code according to ISO 3166-1 / ISO 3166-2, e.g. “US” CHAR(2)
12 Note Note on definition CHAR(1023)
13 Remark Remark on usage of the class CHAR(1023)
14 Level Hierarchichal level in class tree CHAR(1)
15 MKSubclass Flag subgroup (0=no/1=yes) CHAR(1)
16 MKKeyword Flag, if keywords exist for class (0=no/1=yes) CHAR(1)
17 MKBSA Flag standard set of properties (2= Standard set of properties (SSP))* CHAR(1)
18 IrdiCC Primary key of the class; globally unique International Registration Data Identifier (Supplier+TypeOfSE+Identifier+VersionNumber) CHAR(20)


  • *eCl@ss differentiates between standard sets of properties (SSP) and basic sets of properties (BSP). SSP are individually developed for specific classes. The BSP (one for each segment) is automatically assigned to every single eCl@ss class, i.e. each eCl@ss class has at least the BSP. The segments’ BSPs are listed HERE. The entries in the field "mkbsa" have the following meaning:
    • No entry = The property contains only the basic set of properties (BSP), see HERE
    • 2 = The property contains a standard set of properties, i.e. the BSP plus specific properties for the product class

[edit] eClassA_B_KWSY_xy.csv (Keyword table)

No. Attribute Name Description Length
1 SupplierKW/SupplierSY** International Code Designator of the keyword/synonym CHAR(6)
2 Identifier** Identifier (unique within the structure element type: keyword/synonym) CHAR(6)
3 VersionNumber** Version number CHAR(3)
4 IdCC/IdPR** Primary key of the related class/property CHAR(9)
5 KeywordValue/SynonymValue Name of keyword/synonym CHAR(80)
6 Explanation Description of keyword/synonym CHAR(255)
7 ISOLanguageCode Language code according to ISO 639-1 / ISO 639-2, e.g. „en“ CHAR(2)
8 ISOCountryCode Country code according to ISO 3166-1 / ISO 3166-2, e.g. “US” CHAR(2)
9 TypeOfTargetSE Identifier of target element type (CC=class, PR=property) CHAR(2)
10 IrdiTarget Primary key of target; globally unique International Registration Data Identifier (Supplier+TypeOfSE+Identifier+VersionNumber) CHAR(20)
11 IrdiKW/IrdiSY Primary key of the keyword/synonym; globally unique International Registration Data Identifier (Supplier+TypeOfSE+Identifier+VersionNumber) CHAR(20)
12 TypeOfSE Identifier of structure element type (KW=keyword, SY=synonym). Note: keywords can only be assigned to classes, synonyms can only be assigned to properties (see TypeOfTargetSE) CHAR(2)


[edit] eClassA_B_CC_PR_xy.csv (relations eClassA_B_CC_xy / eClassA_B_PR_xy)

No. Attribute Name Description Length
1 SupplierIdCC* International Code Designator of the class (0173-1 für eCl@ss) CHAR(6)
2 IdCC** Identifier+VersionNumber of the target class CHAR(9)
3 ClassCodedName eCl@ss class code of the target class CHAR(8)
4 SupplierIdPR** International Code Designator of the property (0173-1 for eCl@ss) CHAR(6)
5 IdPR** Identifier+VersionNumber of the assigned property CHAR(9)
6 IrdiCC Primary key of the target; globally unique International Registration Data Identifier (Supplier+TypeOfSE+Identifier+VersionNumber) CHAR(20)
7 IrdiPR Primary key of the assigned property; globally unique International Registration Data Identifier (Supplier+TypeOfSE+Identifier+VersionNumber) CHAR(20)


[edit] eClassA_B_PR_xy.csv (Property table)

No. Attribute Name Description Length
1 Supplier** International Code Designator of the property (0173-1 for eCl@ss) CHAR(6)
2 IdPR** Identifier + VersionNumber CHAR(9)
3 Identifier** Identifier (unique within the structure element type: property) CHAR(6)
4 VersionNumber** Version number CHAR(3)
5 VersionDate Publication date of version CHAR(10)
6 RevisionNumber Revision number CHAR(2)
7 PreferredName Name CHAR(80)
8 ShortName Short name CHAR(17)
9 Definition Definition CHAR(1023)
10 SourceofDefinition Source of definition CHAR(1023)
11 Note Note on definition CHAR(1023)
12 Remark Remark on usage of the property CHAR(1023)
13 FormularSymbol Preferred formular symbol CHAR(17)
14 IrdiUN Primary key of the assigned unit; globally unique International Registration Data Identifier (Supplier+TypeOfSE+Identifier+VersionNumber) CHAR(3)
15 ISOLanguageCode Language code according to ISO 639-1 / ISO 639-2, e.g. „en“ CHAR(2)
16 ISOCountryCode Country code according to ISO 3166-1 / ISO 3166-2, e.g. “US” CHAR(2)
17 Category Type class of property according to IEC 61360 CHAR(3)
18 AttributeType Flag for existing value list (direct= free entry, no value list existing; indirect= chose from a defined value list) CHAR(8)
19 DefinitionClass ICS class CHAR(255)
20 DataType STRING_TRANSLATABLE | REAL_MEASURE | REAL_COUNT | REAL_CURRENCY | INTEGER_MEASURE | INTEGER_COUNT | INTEGER_CURRENCY | BOOLEAN | URL | RATIONAL | RATIONAL_MEASURE | TIME | TIMESTAMP | DATE), see HERE CHAR(19)
21 DigitsBeforeComma Number of digits before comma (REAL_COUNT / REAL_MEASURE / REAL_CURRENCY / INTEGER_COUNT / INTEGER_MEASURE / INTEGER_CURRENCY) INTEGER
22 DigitsAfterComma Number of digits after comma (Real_COUNT / REAL_MEASURE / REAL_CURRENCY) INTEGER
23 NumberOfCharacters For properties of data types STRING / STRING_TRANSLATEABLE/ URL / RATIONAL / RATIONAL_MEASURE / TIME / TIMESTAMP / DATE it specifies the maximum character length of the value.

For properties of data types URL / RATIONAL / RATIONAL_MEASURE / TIME / TIMESTAMP / DATE special characters can be included (e.g. http, //, :, / etc.))

INTEGER
24 IrdiPR Primary key of the property; globally unique International Registration Data Identifier (Supplier+TypeOfSE+Identifier+VersionNumber) CHAR(20)
25 CurrencyAlphaCode Specifies the property’s currency (INTEGER_CURRENCY, REAL_CURRENCY) according to ISO 4217, e.g. EUR, USD CHAR(3)


[edit] eClassA_B_PR_VA_xy.csv (Relations eClassA_B_PR_xy/ eClassA_B_VA_xy)

No. Attribute Name Description Length
1 IrdiPR Primary key of the target property; globally unique International Registration Data Identifier (Supplier+TypeOfSE+Identifier+VersionNumber) CHAR(20)
2 IrdiVA Primary key of the assigned value; globally unique International Registration Data Identifier (Supplier+TypeOfSE+Identifier+VersionNumber) CHAR(20)

Note:

eCl@ss interpretes its value lists as open, i.e. as suggestions that cannot guarantee exhaustiveness. As the ISO defines value lists as restrictive and exclusive, i.e. only those values of a value list are valid for a property and no others, eCl@ss had to change its structure to be ISO-compliant. Therefore eCl@ss distinguishes now between restrictive value lists (in the ISO-sense, see HERE) that include only BOOLEAN property-value-relations and suggested lists (proposed "open" lists that are neither exclusive nor exhaustive and only in the context of a class, see HERE).


[edit] eClassA_B_CC_PR_VA_suggested_incl_constraint_xy.csv (Relations eClassA_B_CC_xy / eClassA_B_PR_xy / eClassA_B_VA_xy)

No. Attribute Name Description Length
1 IrdiCC Primary key of the target class; globally unique International Registration Data Identifier (Supplier+TypeOfSE+Identifier+VersionNumber) CHAR(20)
2 IrdiPR Primary key of the target property; globally unique International Registration Data Identifier (Supplier+TypeOfSE+Identifier+VersionNumber) CHAR(20)
3 IrdiVA Primary key of the assigned value; globally unique International Registration Data Identifier (Supplier+TypeOfSE+Identifier+VersionNumber) CHAR(20)
4 Constraint [true;false] CHAR(5)

Note:

With release 9.0 eCl@ss introduces constraints, i.e. the limitation of a set of values of a property in the context of a class. E.g. a property “colour” might have the value list [red;yellow;green]. For a class “traffic light” all colours are valid, but for class “pedestrian traffic light” only [red;green] might be valid, i.e. a constraint is created for the value “yellow”. Therefore all values (except restricted values, see 3.1.5) are to be seen in the context of a class.


[edit] eClassA_B_VA_xy.csv (Value table)

No. Attribute Name Description Length
1 Supplier* International Code Designator (0173-1 for eCl@ss) CHAR(6)
2 IdVA** Identifier + VersionNumber CHAR(9)
3 Identifier** Identifier (unique within the structure element type: property) CHAR(6)
4 VersionNumber** Version number CHAR(3)
5 RevisionNumber Revision Number CHAR(2)
6 VersionDate Publication date of version CHAR(10)
7 PreferredName Name CHAR(80)
8 ShortName Short name CHAR(17)
9 Definition Definition CHAR(1023)
10 Reference Source of definition CHAR(1023)
11 ISOLanguageCode Language code according to ISO 639-1 / ISO 639-2, e.g. „en“ CHAR(2)
12 ISOCountryCode Country code according to ISO 3166-1 / ISO 3166-2, e.g. “US” CHAR(2)
13 IrdiVA Primary key of the value; globally unique International Registration Data Identifier (Supplier+TypeOfSE+Identifier+VersionNumber) CHAR(20)
14 DataType STRING_TRANSLATABLE | REAL_MEASURE | REAL_COUNT | REAL_CURRENCY | INTEGER_MEASURE | INTEGER_COUNT | INTEGER_CURRENCY | BOOLEAN | URL | RATIONAL | RATIONAL_MEASURE | TIME | TIMESTAMP | DATE), see HERE

[edit] eClassA_B_UN_xy.csv (Unit table)

No. Attribute Name Description Length
1 StructuredNaming Structured Naming of the unit, e.g. “volt litre^-1 minute^-1” CHAR(1000)
2 ShortName Short name CHAR(1000)
3 Definition Definition CHAR(1000)
4 Source Source of definition CHAR(1000)
5 Comment Comment on definition CHAR(1000)
6 SINotation Notation (STRING) according to the International System of Units, e.g. “V/(l•min)” CHAR(1000)
7 SIName Name (STRING) according to the International System of Units CHAR(1000)
8 DINNotation Notation (STRING) according to DIN (Deutsches Institut für Normung) CHAR(1000)
9 ECEName ECE Name (STRING), e.g. “volt per liter minute” CHAR(1000)
10 ECECode ECE Code (STRING) according to ECE, e.g. “ F87” CHAR(3)
11 NISTName Name (STRING) according to NIST CHAR(1000)
12 IECClassification Classification of the unit according to IEC CHAR(1000)
13 IrdiUN Primary key of the unit; globally unique International Registration Data Identifier (Supplier+TypeOfSE+Identifier+VersionNumber) CHAR(20)
14 NameOfDedicatedQuantity Name of the superordinate quantity according to DIN CHAR(1000)

Note:

eCl@ss does not use special characters such as <;> or <">, which are interpreted by some systems as a control or separation character. The unit 0173-1#07-AAA683#002 "angular_second" however, is abbreviated as <">, which is both the DIN and the SI notation of this unit. eCl@ss points out that the interpretation of this table might result in difficulties at this point.


[edit] Related information

Personal tools