Search Help Show/Hide Menu
Summary
Item Identification
Data Attributes
Catalog Details

Summary

Abstract

History record table for RACKS table.

Entity Information

Data Attribute / Type Description
SEQ_NUMBER
NUMBER
Primary key of history table. Generated by database.
CHANGED_BY
VARCHAR2 (100 Byte)
The user who changed the record lastly.
DATE_CHANGED
DATE
The date and time on which the record was changed lastly.
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

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

Title: RACKS_H
Abstract:

History record table for RACKS table.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key SEQ_NUMBER NUMBER Primary key of history table. Generated by database.
100
CHANGED_BY VARCHAR2 (100 Byte) The user who changed the record lastly.
100
DATE_CHANGED DATE The date and time on which the record was changed lastly.
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

SEQ_NUMBER

CC ID: 1378152
Seq. Order: 1
Data Storage Type: NUMBER
Required: Yes
Primary Key: Yes
Status: Active
Description:

Primary key of history table. Generated by database.

CHANGED_BY

CC ID: 1378153
Seq. Order: 2
Data Storage Type: VARCHAR2 (100 Byte)
Required: No
Primary Key: No
Status: Active
Description:

The user who changed the record lastly.

DATE_CHANGED

CC ID: 1378154
Seq. Order: 3
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

The date and time on which the record was changed lastly.

RACK_SEQUENCE

CC ID: 1378155
Seq. Order: 4
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

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

FILLED_RACK

CC ID: 1378156
Seq. Order: 5
Data Storage Type: VARCHAR2 (1 Byte)
Required: No
Primary Key: No
Status: Active
Description:

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

CREATE_DATE

CC ID: 1378157
Seq. Order: 6
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

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

LAST_UPDATE_DATE

CC ID: 1378158
Seq. Order: 7
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: 1378159
Seq. Order: 8
Data Storage Type: VARCHAR2 (100 Byte)
Required: No
Primary Key: No
Status: Active
Description:

The user who initially created the record in the system.

LAST_UPDATED_BY

CC ID: 1378160
Seq. Order: 9
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: 1378161
Seq. Order: 10
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: 1378162
Seq. Order: 11
Data Storage Type: VARCHAR2 (3 Byte)
Required: No
Primary Key: No
Status: Active
Description:

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

LOCATION

CC ID: 1378163
Seq. Order: 12
Data Storage Type: VARCHAR2 (3 Byte)
Required: No
Primary Key: No
Status: Active
Description:

The geographic location where the box is stored or placed.

SPECIES

CC ID: 1378164
Seq. Order: 13
Data Storage Type: NUMBER (3)
Required: No
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: 1378165
Seq. Order: 14
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 Details

Catalog Item ID: 75387
GUID: gov.noaa.nmfs.inport:75387
Metadata Record Created By: Martin Park
Metadata Record Created: 2025-03-25 22:20+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