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.