Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

We recommend sites to provide a data dictionary of structural metadata that includes the following information:

Required = *

Metadata Field

Completion Guidance

Constraints

Mandatory?

Table Name *

Name of the table in the dataset. Use a fully qualified name if appropriate.

255 characters max

Yes

Table Description

Description of the table in the dataset.

20,000 characters max

No

Column Name *

Name of the column in the table dataset

255 characters max

Yes

Column Description *

Description of the column in the table dataset.

20,000 characters max

Yes

Data Type Name  *

Type of data contained in the column.

255 characters max

YesSensitive *

Please indicate (True / False) whether the information must be treated as sensitive and may need additional constraints / removal / anonymisation / masking through the data access request process. Definition: An ODRL conformant policy expressing the rights associated with the resource.

True / False only.

Yes

Where can I see some concrete examples of valid Structural Metadata?

Please see the following example for your reference. If you require further clarification, we also have several fully populated submissions from other sites that we would be happy to walk through with you. Please contact us via Service Desk to arrange a session.

Structural Metadata Example

Table Name

Table Description

Column Name

Column Description

Data TypeSensitive

Summary

The summary

Identifier

The identifier

StringTRUE

Summary

The summary

Title

The title

StringFALSE

Summary

The summary

Description

The description

String

TRUE

Required

The required elements

Release Date

The release date

Date

FALSE

Required

The required elements

Data Controller

The controller

String

FALSE

Required

The required elements

Data Processor

The data processor

StringTRUE

Required

The required elements

License

The license

StringFALSE

Recommended

The recommended elements

Periodicity

The periodicity

IntegerTRUE

Recommended

The recommended elements

Frequency

The frequency

String

FALSE

What format should this be in?

...

Please see this template file:

View file
nameTechnical Metadata TemplateStructuralMetadataTemplateForONS.xlsx

Is an Excel spreadsheet the only option in which I can upload metadata?

...

Info

If you would like to know more about them please raise a Service Desk ticket and we'd be happy to arrange a call to walk through some of them.