RACKS_H
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:75387 | Updated: March 25, 2025 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
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
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
100
|
![]() |
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |