Getting Started | Cataloguing | Data Dictionary | Searching | Team


Data Dictionary 

Overview

There are a number of formats of data that the database fields can store. These include the common ones such as text, number and date formats as well as time, container, calculation and summary fields.

The database fields, their type, required data description along with a sample/ examples are all listed by module, in the following tables.

 

Data Dictionary Table

Holotype (as displayed in Form Views)

Field Name

Data Type

Description

Sample Data 

Basic Info

HolotypeID

text

System Auto Generated

H000121

Carrier Type

text

Carrier Classification

 

Process Type

text

Process Classification

 

Medium Type

text

Medium Classification

 

Name

text

Standard and Common Name

 

Standards

test

Standards

 

Height

text

 

 

Width

text

 

 

Diameter

text

 

 

Depth

text

 

 

Holotype Status

text

 

 

Genre and Notes

Base Genre

text

 

 

Additional Genre (2)

text

 

 

Additional Genre (3)

text

 

 

Additional Genre (4)

text

 

 

Image Management

Image 1 Label

text

 

 

Image 1 Filename

text

 

 

File Path

text

 

 

Image 2 Label

text

 

 

Image 2 Filename

text

 

 

 

 

 

 

 

 

 

 

Variant (as displayed in Form Views)

Basic Info

Field Name

Data Type

Description

Sample Data 

HolotypeID

text

 

H000121

Running Length

text

 

2000 ft (904 m)

Product Name

text

 

 

Product Code

text

 

 

Manufacturer

text

 

 

Marketed Capacity

test

 

 

Market

text

 

 

Distinguishing Features

text

 

 

Status

text

 

 

Depth

text

 

 

Holotype Status

text

 

 

Image Management

Image 1 Label

text

 

 

Image 1 Filename

text

 

 

File Path

text

 

 

Image 2 Label

text

 

 

Image 2 Filename

text

 

 

Community Assessment Summary

text

 

 

 

Additional Requirements for DATA, Sound, Still Image, Microform, Moving Image and Unmediated

Field Name

Data Type

Description

Sample Data 

Required Device

text

 

 

Required Application

text

 

 

Required Operating System

text

 

 

Required Drivers

text

 

 

Required Accessories

text

 

 

Specifications

text

 

 

Form Factor

test

 

 

Recording format

text

 

 

Compression & Ratio

text

 

 

Transfer Rate

text

 

 

Format Type

text

 

 

Specification PDF

text

 

 

Web Reference

text

 

 

Life Manufacturer

text

 

 

Life Community

text

 

 

Moving Image sub tab
Field Name

Data Type

Description

Sample Data 

Film Variant Specifications (Still Image, Microform & Moving Image)

Film Variant ID

text

 

V0000426

Product Name

text

 

EASTMAN Fine Grain Duplicating Panchromatic Negative film

Product Code

text

 

5234

Production Started

text

 

1958

Production Stopped

text

 

current

ISO

test

 

 

Emulsion Type

text

 

 

Base Material

text

 

 

Base Thickness

text

 

 

Emulsion Thickness

text

 

 

Total Thickness

text

 

 

Back Treated

text

 

 

Resolution

text

 

 

Remarks

text

 

 

 

Tape Variant Specifications (Data, Sound & Moving Image)

Data/Sound/Video Tape Variant ID

text

 

Vxxxxxxx

Product Name

text

 

 

Product Code

text

 

 

Production Started

text

 

 

Production Stopped

text

 

 

Application Binder

test

 

 

Oxide

text

 

 

Base

text

 

 

Colour Space

text

 

 

Base Material

text

 

 

Base Thickness

text

 

 

Oxide Thickness

text

 

 

Total Thickness

text

 

 

Back Treated

text

 

 

Coercivity

text

 

 

Coercivity KA_M

text

 

 

Retentivity

text

 

 

Retentivity mT

text

 

 

Remanence

text

 

 

Remanence SatFlux

text

 

 

Remarks

text

 

 

 

Disc Variant Specifications (Data, Sound & Moving Image)

Data/Sound/Video Disc Variant ID

text

 

V0000xxx

Product Name

text

 

 

Product Code

text

 

 

Production Started

text

 

 

Production Stopped

text

 

 

Colour Space

text

 

 

Application Binder

test

 

 

Dye layer

text

 

 

Base

text

 

 

Base Material

text

 

 

Base Thickness

text

 

 

Dye Thickness

text

 

 

Total Thickness

text

 

 

Block Error Rate

text

 

 

Push-Pull Signal

text

 

 

Cross-Talk

text

 

 

Reflectivity

text

 

 

Sensitivity

text

 

 

Light Fastness

text

 

 

Read Stability

text

 

 

Remarks

text

 

 

 

Materials Issues (Data, Sound, Still Image, Microform & Moving Image)

Substrate Stability

text

 

 

Binder Stability

text

 

 

Image/Signal Stability

text

 

 

Filename

text

 

 

 

Reformatting Issues (Data, Sound, Still Image, Microform & Moving Image)

Reformatting & Digitisation Issues

text

 

 

Web Reference - Reformatting

text

 

 

Web Reference - Conservation

text

 

 

 

Database Field Types

Text Field

Up to approximately 2 GB of letters, symbols, and/or numbers used as text per field repetition, limited by available RAM and disk space. Indexes nominally based on the first 100 characters of each word or value. Text fields may contain carriage returns.

Number Field

The Number field supports values up to 800 digits or other characters, and the negative values of the same range. Index is based on the first 400 significant digits. Number fields can also contain Boolean values, to indicate, for example, true, false, yes, and no. Number fields can't contain carriage returns.

Container Field

A picture, file (such as a Microsoft Word or Excel file), PDF, multimedia file, or OLE object (Windows only) of up to 4 GB per field. You can reference container fields in calculations and summary fields. You can't find or sort records based on container fields, but you can define text fields to describe or identify them. Then, you can find or sort records based on the description or identifying number in the text field.