Search Help Show/Hide Menu
Metadata Rubric
67%
4 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > Otolith Racking System >

OTOLITH_VIALS_H

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:75385  |  Updated: March 25, 2025  |  Published / External 
Summary
Item Identification
Data Attributes
Catalog Details

Summary

Abstract

History record table for OTOLITH_VIALS table.

Entity Information

Data Attribute / Type Description
SEQ_NUMBER
NUMBER 		Primary key of history table. Generated by database.
CHANGED_BY
VARCHAR2 (50 Byte) 		The user who changed the record lastly.
DATE_CHANGED
DATE 		The date and time on which the record was changed lastly.
X_COLUMN
NUMBER (2) 		Column number of a rack cell.
Y_ROW
NUMBER (2) 		Row number of a rack cell.
BARCODE
NUMBER 		Otolith vial barcode number, Primary key of the table.
RACK_SEQUENCE
NUMBER 		Rack sequence number. Primary key of the rack table.
LAST_CHANGED_BY
VARCHAR2 (100 Byte) 		Application user or database user who made the latest change of the record.

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: OTOLITH_VIALS_H
Abstract:

History record table for OTOLITH_VIALS table.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 SEQ_NUMBER NUMBER Primary key of history table. Generated by database.
100
 CHANGED_BY VARCHAR2 (50 Byte) The user who changed the record lastly.
100
 DATE_CHANGED DATE The date and time on which the record was changed lastly.
100
 X_COLUMN NUMBER (2) Column number of a rack cell.
100
 Y_ROW NUMBER (2) Row number of a rack cell.
100
 BARCODE NUMBER Otolith vial barcode number, Primary key of the table.
100
 RACK_SEQUENCE NUMBER Rack sequence number. Primary key of the rack table.
100
 LAST_CHANGED_BY VARCHAR2 (100 Byte) Application user or database user who made the latest change of the record.

Attribute Details

SEQ_NUMBER

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

Primary key of history table. Generated by database.

CHANGED_BY

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

The user who changed the record lastly.

DATE_CHANGED

CC ID: 1378135
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.

X_COLUMN

CC ID: 1378136
Seq. Order: 4
Data Storage Type: NUMBER (2)
Required: No
Primary Key: No
Status: Active
Description:

Column number of a rack cell.

Y_ROW

CC ID: 1378137
Seq. Order: 5
Data Storage Type: NUMBER (2)
Required: No
Primary Key: No
Status: Active
Description:

Row number of a rack cell.

BARCODE

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

Otolith vial barcode number, Primary key of the table.

RACK_SEQUENCE

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

Rack sequence number. Primary key of the rack table.

LAST_CHANGED_BY

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

Application user or database user who made the latest change of the record.

Catalog Details

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