Metadata Rubric

67%

4 / 6

Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > Otolith Racking System >

RACKS

Entity (ENT) | Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:75386 | Updated: March 25, 2025 | Published / External

Summary

Item Identification

Data Attributes

Catalog Details

Abstract

Each rack box contains otolith vials, with each box holding otoliths from a single species.

Data Attribute / Type	Description
RACK_SEQUENCE NUMBER	A unique, database-generated sequential number assigned to each record.
FILLED_RACK VARCHAR2 (1 Byte)	Indicator showing whether the rack is full: 'Y' for Full, 'N' for Not Full.
CREATE_DATE DATE	The timestamp indicating when the record was initially created in the system.
LAST_UPDATE_DATE DATE	The timestamp indicating when the record was last updated or changed in the system.
CREATED_BY VARCHAR2 (100 Byte)	The user who initially created the record in the system.
LAST_UPDATED_BY VARCHAR2 (100 Byte)	The user who last updated or changed the record in the system.
CLOSED VARCHAR2 (1 Byte)	All records are populated with 'N', but it appears to be unused. Further review may be needed to determine its purpose.
RACK_TYPE VARCHAR2 (3 Byte)	The primary key of the rack_types table, identifying the type of rack box.
LOCATION VARCHAR2 (3 Byte)	The geographic location where the box is stored or placed.
SPECIES NUMBER (3)	A code indicating the fish species from which the otoliths in the vials were collected.
NMFS_AREA_ABBR VARCHAR2 (30 Byte)	Only for pollock otoliths box. Abbreviation of NMFS Area NMFS area between 500 and 599 is BSAI, between 600 and 699 is GOA, and between 700 and 800 is WOA

Data Attribute / Type

Description

RACK_SEQUENCE
NUMBER

A unique, database-generated sequential number assigned to each record.

FILLED_RACK
VARCHAR2 (1 Byte)

Indicator showing whether the rack is full: 'Y' for Full, 'N' for Not Full.

CREATE_DATE
DATE

The timestamp indicating when the record was initially created in the system.

LAST_UPDATE_DATE
DATE

The timestamp indicating when the record was last updated or changed in the system.

CREATED_BY
VARCHAR2 (100 Byte)

The user who initially created the record in the system.

LAST_UPDATED_BY
VARCHAR2 (100 Byte)

The user who last updated or changed the record in the system.

CLOSED
VARCHAR2 (1 Byte)

All records are populated with 'N', but it appears to be unused. Further review may be needed to determine its purpose.

RACK_TYPE
VARCHAR2 (3 Byte)

The primary key of the rack_types table, identifying the type of rack box.

LOCATION
VARCHAR2 (3 Byte)

The geographic location where the box is stored or placed.

SPECIES
NUMBER (3)

A code indicating the fish species from which the otoliths in the vials were collected.

NMFS_AREA_ABBR
VARCHAR2 (30 Byte)

Only for pollock otoliths box. Abbreviation of NMFS Area NMFS area between 500 and 599 is BSAI, between 600 and 699 is GOA, and between 700 and 800 is WOA

No Child Items for this record.

No contact information is available for this record.

Please contact the owner organization (AFSC) for inquiries on this record.

Title:	RACKS
Abstract:	Each rack box contains otolith vials, with each box holding otoliths from a single species.

Attribute Summary

	Name	Type	Description
100	RACK_SEQUENCE	NUMBER	A unique, database-generated sequential number assigned to each record.
100	FILLED_RACK	VARCHAR2 (1 Byte)	Indicator showing whether the rack is full: 'Y' for Full, 'N' for Not Full.
100	CREATE_DATE	DATE	The timestamp indicating when the record was initially created in the system.
100	LAST_UPDATE_DATE	DATE	The timestamp indicating when the record was last updated or changed in the system.
100	CREATED_BY	VARCHAR2 (100 Byte)	The user who initially created the record in the system.
100	LAST_UPDATED_BY	VARCHAR2 (100 Byte)	The user who last updated or changed the record in the system.
100	CLOSED	VARCHAR2 (1 Byte)	All records are populated with 'N', but it appears to be unused. Further review may be needed to determine its purpose.
100	RACK_TYPE	VARCHAR2 (3 Byte)	The primary key of the rack_types table, identifying the type of rack box.
100	LOCATION	VARCHAR2 (3 Byte)	The geographic location where the box is stored or placed.
100	SPECIES	NUMBER (3)	A code indicating the fish species from which the otoliths in the vials were collected.
100	NMFS_AREA_ABBR	VARCHAR2 (30 Byte)	Only for pollock otoliths box. Abbreviation of NMFS Area NMFS area between 500 and 599 is BSAI, between 600 and 699 is GOA, and between 700 and 800 is WOA

Name

Type

Description

100

RACK_SEQUENCE

NUMBER

A unique, database-generated sequential number assigned to each record.

100

FILLED_RACK

VARCHAR2 (1 Byte)

Indicator showing whether the rack is full: 'Y' for Full, 'N' for Not Full.

100

CREATE_DATE

DATE

The timestamp indicating when the record was initially created in the system.

100

LAST_UPDATE_DATE

DATE

The timestamp indicating when the record was last updated or changed in the system.

100

CREATED_BY

VARCHAR2 (100 Byte)

The user who initially created the record in the system.

100

LAST_UPDATED_BY

VARCHAR2 (100 Byte)

The user who last updated or changed the record in the system.

100

CLOSED

VARCHAR2 (1 Byte)

All records are populated with 'N', but it appears to be unused. Further review may be needed to determine its purpose.

100

RACK_TYPE

VARCHAR2 (3 Byte)

The primary key of the rack_types table, identifying the type of rack box.

100

LOCATION

VARCHAR2 (3 Byte)

The geographic location where the box is stored or placed.

100

SPECIES

NUMBER (3)

A code indicating the fish species from which the otoliths in the vials were collected.

100

NMFS_AREA_ABBR

VARCHAR2 (30 Byte)

Only for pollock otoliths box. Abbreviation of NMFS Area NMFS area between 500 and 599 is BSAI, between 600 and 699 is GOA, and between 700 and 800 is WOA

Attribute Details

RACK_SEQUENCE

CC ID: 1378141

Seq. Order:	1
Data Storage Type:	NUMBER
Required:	Yes
Primary Key:	Yes
Status:	Active
Description:	A unique, database-generated sequential number assigned to each record.

FILLED_RACK

CC ID: 1378142

Seq. Order:	2
Data Storage Type:	VARCHAR2 (1 Byte)
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Indicator showing whether the rack is full: 'Y' for Full, 'N' for Not Full.

CREATE_DATE

CC ID: 1378143

Seq. Order:	3
Data Storage Type:	DATE
Required:	Yes
Primary Key:	No
Status:	Active
Description:	The timestamp indicating when the record was initially created in the system.

LAST_UPDATE_DATE

CC ID: 1378144

Seq. Order:	4
Data Storage Type:	DATE
Required:	No
Primary Key:	No
Status:	Active
Description:	The timestamp indicating when the record was last updated or changed in the system.

CREATED_BY

CC ID: 1378145

Seq. Order:	5
Data Storage Type:	VARCHAR2 (100 Byte)
Required:	Yes
Primary Key:	No
Status:	Active
Description:	The user who initially created the record in the system.

LAST_UPDATED_BY

CC ID: 1378146

Seq. Order:	6
Data Storage Type:	VARCHAR2 (100 Byte)
Required:	No
Primary Key:	No
Status:	Active
Description:	The user who last updated or changed the record in the system.

CLOSED

CC ID: 1378147

Seq. Order:	7
Data Storage Type:	VARCHAR2 (1 Byte)
Required:	No
Primary Key:	No
Status:	Active
Description:	All records are populated with 'N', but it appears to be unused. Further review may be needed to determine its purpose.

RACK_TYPE

CC ID: 1378148

Seq. Order:	8
Data Storage Type:	VARCHAR2 (3 Byte)
Required:	Yes
Primary Key:	No
Status:	Active
Description:	The primary key of the rack_types table, identifying the type of rack box.

LOCATION

CC ID: 1378149

Seq. Order:	9
Data Storage Type:	VARCHAR2 (3 Byte)
Required:	Yes
Primary Key:	No
Status:	Active
Description:	The geographic location where the box is stored or placed.

SPECIES

CC ID: 1378150

Seq. Order:	10
Data Storage Type:	NUMBER (3)
Required:	Yes
Primary Key:	No
Status:	Active
Description:	A code indicating the fish species from which the otoliths in the vials were collected.

NMFS_AREA_ABBR

CC ID: 1378151

Seq. Order:	11
Data Storage Type:	VARCHAR2 (30 Byte)
Required:	No
Primary Key:	No
Status:	Active
Description:	Only for pollock otoliths box. Abbreviation of NMFS Area NMFS area between 500 and 599 is BSAI, between 600 and 699 is GOA, and between 700 and 800 is WOA

Catalog Item ID:	75386
GUID:	gov.noaa.nmfs.inport:75386
Metadata Record Created By:	Martin Park
Metadata Record Created:	2025-03-25 22:15+0000
Metadata Record Last Modified By:	Martin Park
Metadata Record Last Modified:	2025-03-25 23:14+0000
Metadata Record Published:	2025-03-25
Owner Org:	AFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Review Frequency:	1 Year

RACKS

Summary

Entity Information

Child Items

Contact Information

Item Identification

Data Attributes

Attribute Summary

Attribute Details

RACK_SEQUENCE

FILLED_RACK

CREATE_DATE

LAST_UPDATE_DATE

CREATED_BY

LAST_UPDATED_BY

CLOSED

RACK_TYPE

LOCATION

SPECIES

NMFS_AREA_ABBR

Catalog Details