Spreadsheet Batch Upload

Status of this document: Working draft

Author:

  • Tore Christiansen

Contents

  1. Abstract
  2. 2. Overview of import functionality
  3. 3. Inserting new Reference Data
  4. 4. Updating existing Reference Data
  5. 5. Deleting existing Reference Data
  6. 6. Common fields for all types of Reference Data
  7. 7. Example parameters for defining Reference Data
    1. 7.1 Defining classes and relationships
    2. 7.2 Defining Express strings and numbers
    3. 7.3 Defining Multidimensional objects
  8. 8. Explanation of all parameters
    1. 8.1 The Object sheet
    2. 8.2 The Relationship sheet
    3. 8.3 The Representation sheet
    4. 8.4 The Role sheet
    5. 8.5 The Parameter sheet
    6. 8.6 The Dimension sheet
    7. 8.7 The Cardinality sheet
  9. Spreadsheets illustrated

Abstract

This note describes how to use the import facility of the ISO 15926 based Reference Data Editor (RDE) from POSC Caesar to insert, update and delete various types of Reference Data (RD) objects (classes and relationships) according to the ISO 15926-2 Data Model, as a part of, or an extension to, ISO 15926-4 Reference Data Library (RDL).

See also:

The RDE is intended as an introductory overview for users who possess domain knowledge in their field of application, and also have a basic understanding of the concept, content and structure of reference data libraries.

Section 2 outlines the overall structure of the different import sheets, and how they should be filled with parameters to create and describe various types of reference data objects.

Sections 3, 4 and 5 outline the process to insert new, update existing and delete existing reference data objects, respectively.

Section 6 describes parameters that are common to all import sheets, while Section 7 gives examples of typical parameters for different types of reference data objects. Finally, section 8 contains a list of explanations for all parameters.

2. Overview of import functionality

In the current version of the RDE, new RD objects, as well as modifications to existing RD, can be entered by either interactive editing or in batch. This note describes batch input by means of tabular worksheets.

The batch input facility, currently consists of seven worksheets for different types of RD. The worksheets are placed on tabs in the lower right hand part of the RDE user interface, and consist of –

  • The Object sheet is used to define and/or modify all (instances of) ISO 15926-2 Thing. That is, data about any type of class, relationship, individual (or instances of any other legal entity type can be specified here.
  • The Relationship sheet is used to add necessary information for (instances of) ISO 15926-2 Relationship (as well as Class of Relationship and Class of Class of Relationship). Note that these Relationships can already be defined in the Object sheet, or be defined directly in the Relationship sheet.
  • The Representation sheet is used to add the value of (instances of) ISO 15926-2) Express String, Express Real, Express Integer, Gregorian Date and UTC Time, etc. Note that these Representations can already be defined in the Object sheet, or be defined directly in the Representation sheet.
  • The Role sheet is used to add information about (instances of) ISO 15926-2 Role and Domain, used in Multidimensional objects. Note that these Roles must already be defined in the Object sheet.
  • The Parameters sheet is used to add information about (the classes that are used as) Parameters in (instances of) ISO 15926-2 Class of Multidimensional object. Note that these Parameters (classes) must already be defined in the Object sheet.
  • The Dimension sheet is used to add necessary information about (the class instances that are used as) Parameters in (instances of) ISO 15926-2 Multidimensional object.. Note that these Dimensions must already be defined in the Object sheet.
  • The Cardinality sheet is used to add necessary information about (the instances of) ISO 15926-2 Cardinality. Note that these Cardinalities must already be defined in the Object sheet.

The sheets are organized with one row for each Reference Data object, and with each column holding a given RD parameter. The result is (of course) that each cell holds one parameter value for one RD object.

3. Inserting new Reference Data

To create new Reference Data, describe it by filling out parameter values for all (mandatory and relevant non-mandatory) fields in the worksheets of the Excel template.

See Section 7 for illustrative examples and Section 8 for a full explanation of all Parameters. Note that the Action command (first column) in all rows should contain the value INSERT.

The Excel worksheet values should be “cut and pasted” into the corresponding worksheets in the lower right hand part of the RDE interface. The import data should then be validated (by pressing the “validate” button in the RDE User Interface) which will go through each row and report any errors in the last two columns. After all reported errors are corrected the data can be imported into RDE (by pressing the “update” button).

4. Updating existing Reference Data

To modify existing Reference Data the changes should be described by filling out relevant parameter values for all relevant fields in all affected worksheets of the Excel template.

See section 7 for illustrative examples and Section 8 for a full explanation of all Parameters. Note that the Action command (first column) in all rows should contain the value UPDATE. Note also that all parameter values that are not modified must be filled in with their current value (since blank values lead to the corresponding parameters being set to “null”). For Reference Data that shall be updated, it is therefore advisable to first export it from the RDE and paste it into a copy of the Excel template, in order to create a starting point for the import template.

The Excel worksheet values should then be “cut and pasted” into the corresponding worksheets in the lower right hand part of the RDE interface. The import data should then be validated (by pressing the “validate” button in the RDE User Interface) which will go through each row and report any errors in the last two columns. After all reported errors are corrected the data can be imported into RDE (by pressing the “update” button).

5. Deleting existing Reference Data

To delete existing Reference Data the relevant objects should be uniquely referenced by filling out either the PCA ID or the RDL Designation.

See Section 7 for illustrative examples and Section 8 for a full explanation of all Parameters. Note that the Action command (first column) in all rows should contain the value DELETE. Note that only ID or Designation need to be filled in.

The Excel worksheet values should then be “cut and pasted” into the corresponding worksheets in the lower right hand part of the RDE interface. The data should then be validated (by pressing the “validate” button in the RDE User Interface) which will go through each row and report any errors in the last two columns. After all reported errors are corrected the data can be deleted from RDE (by pressing the “update” button). Note that in order to delete RD classes, all relationships connected to those classes must be deleted first. It is therefore often easier to delete classes interactively using the RDE UI.

6. Common fields for all types of Reference Data

In the description of all Reference Data (i.e., in all worksheets) there are some parameters that are used for the same purpose -

  • Action: The action to be performed by the RDE (if Action is not set, no evaluation of the data will be performed). Use INSERT for new classes, UPDATE for changing data of existing classes, DELETE for removing classes.
  • PCA ID: Unique identification for all RD objects in a given Reference Data Library (i.e., on a given Reference Data Server). Leave blank when importing new classes.
  • RDL Designation: Unique name for all RD objects in a given Reference Data Library (i.e., on a given Reference Data Server).
  • Entity type: The ISO 15926-2 entity type from which the current RD object is instantiated.
  • Error code: A numerical code returned from the RDE in case of errors.
  • Error description: A textual description returned from the RDE corresponding to the Error code.

7. Example parameters for defining Reference Data

This section gives examples of typical parameters for different reference data types. The examples (first) give the row of parameters as they appear in the import sheet, and (then) each parameter name (column header) and value (cell). A full explanation of all parameters is given in chapter 8.

7.1 Defining classes and relationships

In order to change the description of the RDL class named Pump the imported values in the Object sheet might be like the example below. The text string (value) of the RDL Definition parameter is changed; the other parameter values are included unchanged.

  • Action: UPDATE
  • PCA ID: 327239
  • RDL Designation: PUMP
  • Entity type: CLASS_OF_INANIMATE_PHYSICAL_OBJECT
  • Registration status: Recorded
  • RDL Description: A physical object that is a driven piece of equipment in which energy is either constantly or periodically added to an amount of pumped liquid in order to increase the pressure required for the process in which the pump is in operation.

In order to define a new RDL class named Activated Sludge Pump the imported values in the Object sheet might be like the example below.

  • Action: INSERT
  • RDL Designation: ACTIVATED SLUDGE PUMP
  • Entity type: CLASS_OF_INANIMATE_PHYSICAL_OBJECT
  • Registration status: Incomplete
  • RDL Definition: A pump that pumps activated sludge.
  • Note(s): 'Biological sludge pump' is a synonym.

In order to define that Activated Sludge Pump is a subclass of pump we use the Specialization relationship.

  • Action: INSERT
  • RDL Designation: (leave blank for unnamed relationship)
  • Entity type: SPECIALIZATION
  • 1. Role: SUBCLASS
  • 1. Entity type: CLASS_OF_INANIMATE_PHYSICAL_OBJECT
  • 1. PCA ID: (leave blank since class is uniquely defined by RDL designation)
  • 1. RDL Designation: ACTIVATED SLUDGE PUMP
  • 2. Role: SUPERCLASS
  • 2. Entity type: CLASS_OF_INANIMATE_PHYSICAL_OBJECT 327239
  • 2. PCA ID: (leave blank, alternatively give PCA ID, and leave RDL Designation blank)
  • 2. RDL Designation: PUMP

In order to make Pump a member of the Epistle Rotating Equipment Core RDL Classes we use the Classification relationship

  • Action: INSERT
  • Entity type: CLASSIFICATION
  • 1. Role: CLASSIFIED
  • 1. Entity type: CLASS_OF_INANIMATE_PHYSICAL_OBJECT
  • 1. RDL Designation: PUMP
  • 2. Role CLASSIFIER
  • 2. Entity type: CLASS_OF_CLASS_OF_INDIVIDUAL
  • 2. RDL Designation: EPISTLE ROTATING EQUIPMENT CORE RDL CLASS

In order to give Pump the property Design Pressure we use the Class_of_indirecct_property relationship

  • Action: INSERT
  • Entity type: CLASS_OF_ASSEMBLY_OF_INDIVIDUAL
  • 1. Role: CLASS_OF_PART
  • 1. Entity type: CLASS_OF_INANIMATE_PHYSICAL_OBJECT
  • 1. RDL Designation: PUMP
  • 1. Cardinality name: Zero to Many
  • 2. Role: CLASS_OF_WHOLE
  • 2. Entity type: CLASS_OF_INANIMATE_PHYSICAL_OBJECT
  • 2. RDL Designation: COOLING SYSTEM
  • 2. Cardinality name: [ One to Many]

7.2 Defining Express strings and numbers

  • Action: INSERT
  • RDL Designation: (normally not given for parameters)
  • Entity type: EXPRESS_STRING
  • Value: ID number of driven unit as text

7.3 Defining Multidimensional objects

Class of Multidimensional object –

In order to define a new instance of ISO 15926-2 Class_of_multidimensional_object named ST3401 PROPERTY the imported values in the Object sheet might be like the example below. Note that this is an example of an implementation of so-called ISO 15926-7 templates.

  • Action: INSERT
  • PCA ID: RDS403754361
  • RDL Designation: ST 3401 PROPERTY
  • Entity type: CLASS_OF_MULTIDIMENSIONAL_OBJECT
  • Registration status: Incomplete
  • RDL Description: A Shorthand Template for representing possession of property by a Thing
  • Administrative note(s): This Class_of_multidimensional_object is a generic template used in ISO 15926-7
  • Explanatory comment: A Class of Multidimensional Object that specifies the roles used in ST 3401
  • Unresolved issue: Use of this template within ISO 15926-7 is not yet standardized
  • RDS Adapted definition: This is the template specification for describing assignment relationships
  • Abbreviation: ST 3401
  • Submitting organization: DNV IQM
  • Submitter: TCHR
  • Registrar: tchr
  • Registration authority: RDS

In order to define a new instance of ISO 15926-2 Class_of_multidimensional_object named ST 3401 RICH GAS ALLOCATED VOLUME the imported values in the Object sheet might be like the example below. Note that this is a subclass of ST 3401 PROPERTY above.

  • Action: INSERT
  • PCA ID: RDS409581711
  • RDL Designation: ST 3401 RICH GAS ALLOCATED VOLUME SM3
  • Entity type: CLASS_OF_MULTIDIMENSIONAL_OBJECT
  • Registration status: Incomplete
  • RDL Description: A Shorthand Template for representing possession of property by a Thing
  • Administrative note(s): This Class_of_multidimensional_object is a generic template used in ISO 15926-7 for |Representation of NPD report templates in the RDS
  • Explanatory comment: A Class of Multidimensional Object that specifies the roles used in ST 3401
  • Unresolved issue: Use of this template within ISO 15926-7 is not yet standardized
  • RDS Adapted definition: This is the template specification for describing assignment relationships
  • Submitting organization: DNV IQM
  • Submitter: TCHR
  • Registrar: tchr
  • Registration authority: RDS

Multidimensional object -

In order to define a new instance of ISO 15926-2 Multidimensional_object named SD 3401 EKOFISK A INJECTION RICH GAS MONTHLY ALLOCATED VOLUME SM3 FEBRUARY 2007 the imported values in the Object sheet might be like the example below. Note that this is an instance of ST 3401 RICH GAS ALLOCATED VOLUME above.

  • Action: INSERT
  • PCA ID: RDS409942781
  • RDL Designation: SD 3401 EKOFISK A INJECTION RICH GAS MONTHLY ALLOCATED VOLUME SM3 FEBRUARY 2007
  • Entity type: 2007 MULTIDIMENSIONAL_OBJECT
  • Registration status: Incomplete
  • Administrative note(s): Representation of NPD report templates in the RDS
  • Registrar: tchr
  • Registration authority: RDS

Roles –

In order to define Roles for ISO 15926-2 Class_of_multidimensional_object named ST 3401 RICH GAS ALLOCATED VOLUM the imported values in the Role sheet might be like the example below. Note that these Roles (classes) must already be defined in the Object sheet.

  • PCA ID: RDS40375437260
  • RDL Designation (KEY): POSSESSOR
  • Entity type: ROLE
  • MC PCA ID: RDS409581711
  • MC RDL Designation: ST 3401 RICH GAS ALLOCATED VOLUME SM3
  • Role position: 1
  • Mandatory: TRUE
  • Cardinality: ECH10050
  • PCA ID: RDS40375437280
  • RDL Designation (KEY): PROPERTY TYPE
  • Entity type: ROLE
  • MC PCA ID: RDS409581711
  • MC RDL Designation: ST 3401 RICH GAS ALLOCATED VOLUME SM3
  • Role position: 2
  • Mandatory: FALSE
  • Cardinality: ECH10050

Parameters –

In order to define Parameters for ISO 15926-2 Class_of_multidimensional_object named ST 3401 RICH GAS ALLOCATED VOLUM the imported values in the Parameter sheet might be like the example below. Note that these Parameters (classes) must already be defined in the Object sheet.

  • PCA ID: 16229440
  • RDL Designation: (may be left blank, since the RDL class already exists, and is uniquely identified by PCA ID)
  • Entity type: CLASS_OF_COMPOUND
  • Role Position: 1
  • Role PCA ID: RDS40375437260
  • Role RDL Designation: (may be left blank, since the RDL class already exists, and is uniquely identified by PCA ID)
  • MC PCA ID: RDS409581711
  • MC RDL Designation: ST 3401 RICH GAS ALLOCATED VOLUME SM3
  • PCA ID: RDS409510451
  • RDL Designation: (may be left blank, since the RDL class already exists, and is uniquely identified by PCA ID)
  • Entity type: SINGLE_PROPERTY_DIMENSION
  • Role Position: 2
  • Role PCA ID: RDS40375437280
  • Role RDL Designation: (may be left blank, since the RDL class already exists, and is uniquely identified by PCA ID)
  • MC PCA ID: RDS409581711
  • MC RDL Designation: ST 3401 RICH GAS ALLOCATED VOLUME SM3

Dimensions –

In order to define Parameters for ISO 15926-2 Multidimensional_object named

SD 3401 EKOFISK A INJECTION RICH GAS MONTHLY ALLOCATED VOLUME SM3 FEBRUARY 2007 the imported values in the Parameter sheet might be like the example below. These Dimensions correspond to the above Parameters for ST 3401 RICH GAS ALLOCATED VOLUM E SM3. Note that these Dimensions (classes) must already be defined in the Object sheet.

  • PCA ID: 16229440
  • RDL Designation: RICH GAS
  • Entity type: CLASS_OF_COMPOUND
  • Role Position: 1
  • Position: 1
  • MO PCA ID: RDS409942781
  • MO RDL Designation: SD 3401 EKOFISK A INJECTION RICH GAS MONTHLY ALLOCATED VOLUME SM3 FEBRUARY 2007
  • Role PCA ID: RDS40375437260
  • Role RDL Designation: POSSESSOR
  • PCA ID: RDS409510451
  • RDL Designation: ALLOCATED AMOUNT
  • Entity type: SINGLE_PROPERTY_DIMENSION
  • Role Position: 2
  • Position: 2
  • MO PCA ID: RDS409942781
  • MO RDL Designation: SD 3401 EKOFISK A INJECTION RICH GAS MONTHLY ALLOCATED VOLUME SM3 FEBRUARY 2007
  • Role PCA ID: RDS40375437280
  • Role RDL Designation: PROPERTY TYPE

8. Explanation of all parameters

This section contains explanations for all parameters in the various sheets.

8.1 The Object sheet

This subsection contains a commented list of all parameters in the Object sheet, listed in the same order as the columns in the worksheet.

Action
Action to be performed by the RDS (use INSERT for new classes, UPDATE for changing data of existing classes, DELETE for removing classes).
PCA ID
Unique ID of the class (leave blank for new classes).
RDL Designation
The name of the object (class, relationship or individual).
RDL Designation (KEY)
Optional means of identifying existing class If changing RDL Designation of the object, without defining PCA ID, this field should hold the old RDL Designation.
Entity type
The entity type (in ISO 15926-2) that this class is an instance of).
Creator
The (editor) user who created the Reference Data object. Leave blank when importing new data, leave unchanged when updating or deleting data.
Creation date
The date and time that the Reference data object was first imported (or manually created in the RDE). Leave blank when importing new data, leave unchanged when updating or deleting data.
Deleted
The time that the Reference Data object was deleted (this is only set when Reference data is imported with the Action set to DELETE).
Registration status
Choose from set of statuses according to ISO 11179 (use INCOMPLETE for new classes).
Alternative designation
Alternative class name (can be ignored).
RDL Definition
Definition of the class (not mandatory - but probably the most important field for creating meaningful reference data ;-)
Administrative note(s)
Meta-data field specified by ISO 11179 (can be ignored if no relevant data to record).
Change description
Meta-data field specified by ISO 11179 (can be ignored if no relevant data to record).
Explanatory comment(s)
Meta-data field specified by ISO 11179 (can be ignored if no relevant data to record).
Unresolved issue
Meta-data field specified by ISO 11179 (can be ignored if no relevant data to record).
RDL adapted definition
Meta-data field specified by ISO 11179 (can be ignored if no relevant data to record).
Abbreviation
Meta-data field specified by ISO 11179 (can be ignored if no relevant data to record).
Note(s)
Meta-data field specified by ISO 11179 (can be ignored if no relevant data to record).
Examples
Meta-data field specified by ISO 11179 (can be ignored if no relevant data to record).
Submitting organization
Meta-data field specified by ISO 11179 (can be ignored if no relevant data to record).
Submitter
Meta-data field specified by ISO 11179 (can be ignored if no relevant data to record).
Registrar
Meta-data field specified by ISO 11179 (can be ignored if no relevant data to record).
Registration Authority
Meta-data field specified by ISO 11179 (can be ignored if no relevant data to record).
Stewardship
Meta-data field specified by ISO 11179 (can be ignored if no relevant data to record).
Stewardship contact
Meta-data field specified by ISO 11179 (can be ignored if no relevant data to record).
Error code
Added by the RDS if errors in there are errors in import data (leave blank).
Error Description
Added by the RDS if errors in there are errors in import data (leave blank).

8.2 The Relationship sheet

This subsection contains a commented list of all parameters in the Relationship sheet, listed in the same order as the columns in the worksheet.

Action
Action to be performed by the RDS (use INSERT for new relationships, UPDATE for changing data of existing relationships, DELETE for removing relationships).
PCA ID
Unique ID of the relationship (leave blank for new relationships).
RDL Designation
The name of the Relationship.
Entity type
The entity type (in ISO 15926-2) of the relationship.
1.Role
The role of "class 1"
1.Entity type
The entity type (in ISO 15926-2) of "class 1" (NOTE that the choice of class 1 and class 2 is arbitrary, but specified by 1.Role and 2.Role below).
1.PCA ID
Unique ID of "class 1"
1.RDL Designation
The name of the "class 1"
1.Cardinality ID
The PCA ID of the Cardinality of 1.Role
1.Cardinality Name
The RDL Designation of the cardinality of 1.Role
2.Role
The role of "class 2" (NOTE that the choice of class 1 and class 2 is arbitrary, but specified by 1.Role and 2.Role below).
2.Entity type
The entity type (in ISO 15926-2) of "class 2"
2.PCA ID
Unique ID of "class 2"
2.RDL Designation
The name of the "class 2"
2.Cardinality ID
The RDL Designation of the cardinality of 2.Role
2.Cardinality Name
The PCA ID of the Cardinality of 2.Role
Error code
Added by the RDS if errors in there are errors in import data (leave blank).
Error Description
Added by the RDS if errors in there are errors in import data (leave blank).

8.3 The Representation sheet

This subsection contains a commented list of all parameters in the Representation sheet, listed in the same order as the columns in the worksheet.

Action
Action to be performed by the RDS (use INSERT for new relationships, UPDATE for changing data of existing relationships, DELETE for removing relationships).
PCA ID
Unique ID of the Representation (leave blank for new Representations).
RDL Designation
The name of the Representation.
Entity type
The entity type (in ISO 15926-2) that this representation object is an instance of).
Value
The value of the Representation.
Error code
Added by the RDS if errors in there are errors in import data (leave blank).
Error Description
Added by the RDS if errors in there are errors in import data (leave blank).

8.4 The Role sheet

This subsection contains a commented list of all parameters in the Role sheet, listed in the same order as the columns in the worksheet.

Action
Action to be performed by the RDS (use INSERT for new relationships, UPDATE for changing data of existing relationships, DELETE for removing Roles).
PCA ID
Unique ID of the Role (leave blank for new Roles).
RDL Designation (KEY)
The name of the Role. This should be the same as the RDL Designation given to the Role object when defining it through the Object sheet (and can most easily be found by searching in the RDE).
Entity type
The entity type (in ISO 15926-2) that this Role is an instance of).
MC PCA ID
The PCA of the Class of Multidimensional Object that includes the Role (this is a reference to the PCA ID of the Class of Multidimensional Object defined in the Object sheet).
MC RDL Designation
The RDL Designation of the Class of Multidimensional Object that includes the Role (this is a reference to the RDL Designation of the Class of Multidimensional Object defined in the Object sheet). Note that either MC PCA ID or MC RDL Designation must be specified.
Role Position
The position (order) of the Role within the Class of Multidimensional Object The same Role could be used in more than one Position (and this should be specified in different rows). This field is not required for the DELETE action.
Mandatory
Boolean value that specifies whether or not the Role is mandatory in the Class of Multidimensional Object that includes this Role.
Cardinality ID
PCA ID of the Cardinality of the Role in the Class of Multidimensional Object that includes the Role.
Error code
Added by the RDS if errors in there are errors in import data (leave blank).
Error Description
Added by the RDS if errors in there are errors in import data (leave blank).

8.5 The Parameter sheet

This subsection contains a commented list of all parameters in the Parameter sheet, listed in the same order as the columns in the worksheet.

Action
Action to be performed by the RDS (use INSERT for new relationships, UPDATE for changing data of existing relationships, DELETE for removing Parameters).
PCA ID
Unique ID of the Parameter (leave blank for new Parameters).
RDL Designation
The name of the Parameter.
Entity type
The entity type (in ISO 15926-2) that this Parameter is an instance of).
Role Position
The Position of the parent Role of the Parameter in the Class of Multidimensional Object that includes the Parameter. Note that one of Role Position, Role PCA ID or Role RDL Designation must be given.
Role PCA ID
The PCA ID of the parent Role of the Parameter in the Class of Multidimensional Object that includes the Parameter.
Role RDL Designation
The RDL Designation of the parent Role of the Parameter in the Class of Multidimensional Object that includes the Parameter.
MC PCA ID
The PCA of the Class of Multidimensional Object that includes the Parameter (this is a reference to the PCA ID of the Class of Multidimensional Object defined in the Object sheet).
MC RDL Designation
The RDL Designation of the Class of Multidimensional Object that includes the Parameter (this is a reference to the RDL Designation of the Class of Multidimensional Object defined in the Object sheet). Note that either MC PCA ID or MC RDL Designation must be specified.
Error code
Added by the RDS if errors in there are errors in import data (leave blank).
Error Description
Added by the RDS if errors in there are errors in import data (leave blank).

8.6 The Dimension sheet

This subsection contains a commented list of all parameters in the Dimension sheet, listed in the same order as the columns in the worksheet.

Action
Action to be performed by the RDS (use INSERT for new relationships, UPDATE for changing data of existing relationships, DELETE for removing Dimensions).
PCA ID
Unique ID of the Dimension (leave blank for new Dimensions).
RDL Designation
The name of the (ISO 15926-4) Dimension.
Entity type
The entity type (in ISO 15926-2) that this Dimension is an instance of).
Role Position
The Position of the parent Role of the Parameter that instantiates the Dimension in the Class of Multidimensional Object that classifies the Multidimensional Object. This is optional.
Position
The Position of Dimension in the Multidimensional Object that instantiates the Class of Multidimensional Object that includes the Parameter corresponding to the Dimension. Note that this has too be specified in INSERT mode.
MO PCA ID
The PCA ID of the Multidimensional Object that includes the Dimension (this is a reference to the PCA ID of the Multidimensional Object defined in the Object sheet).
MO RDL Designation
The RDL Designation of the Multidimensional Object that includes the Dimension (reference to the RDL Designation of the Multidimensional Object defined in the Object sheet).
Role PCA ID
The PCA ID of the Role that classifies the Dimension in the Class of Multidimensional Object instantiating the Multidimensional Object (this is an optional reference to the PCA ID of the Role defined in the Object sheet).
Role RDL Designation
RDL Designation of the Role that classifies the Dimension in the Class of Multidimensional Object instantiating the Multidimensional Object (this is an optional reference to the PCA ID of the Role defined in the Object sheet).
Error code
Added by the RDS if errors in there are errors in import data (leave blank)
Error Description
Added by the RDS if errors in there are errors in import data (leave blank)

8.7 The Cardinality sheet

This subsection contains a commented list of all parameters in the Cardinality sheet, listed in the same order as the columns in the worksheet.

Action
Action to be performed by the RDS (use INSERT for new relationships, UPDATE for changing data of existing relationships, DELETE for removing Cardinalities).
PCA ID
Unique ID of the Cardinality (leave blank for new Cardinalities).
RDL Designation
The name of Cardinality.
Min
The minimum value allowed in the referenced Cardinality.
Max
The maximum value allowed in the referenced Cardinality.
Error code
Added by the RDS if errors in there are errors in import data (leave blank).
Error Description
Added by the RDS if errors in there are errors in import data (leave blank).

Spreadsheets illustrated

The following table lists the columns in each worksheet of the spreadsheet template. Note that most columns are optional.

ObjectRelationshipRepresentationRoleDimensionCardinality
ActionActionActionActionActionAction
PCA IDPCA IDPCA IDPCA IDPCA IDPCA ID
RDL DesignationRDL Designation (Key)RDL Designation (Key)RDL Designation (Key)RDL Designation (Key)RDL Designation (Key)
RDL Designation (Key)Entity typeEntity typeEntity typeEntity typeMin
Entity type1. ROLEValueMC PCA IDRole PositionMax
Creator1. Entity typeError CodeMC RDL DesignationPositionError Code
Creation Date1. PCA IDError DescriptionRole PositionMO PCA IDError Description
Deleted1. RDL DesignationMandatoryMO RDL Designation
Registration status1. Cardinality IDCardinality IDRole PCA ID
Alternative designation1. Cardinality NameCardinality NameRole RDL Designation
RDL Definition2. ROLEError CodeError Code
Administrative note(s)2. Entity typeError DescriptionError Description
Change description2. PCA ID
Explanatory comment(s)2. RDL Designation
Unresolved issue2. Cardinality ID
RDL adapted definition2. Cardinality Name
AbbreviationError Code
Note(s)Error Description
Examples
Submitting organisation
Submitter
Registrar
Registrar Authority
Stewardship
Stewardship contact
Error Code
Error Description
Home
About PCA
Reference Data Services
Projects
Workgroups