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

CAS_ARCHIVE_ALL_H

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

Summary

Abstract

History record table for CAS_ARCHIVE_ALL 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.
ARCHIVE_SEQ
NUMBER (38) 		Primary key or the table CAS_ARCHIVE_ALL.
FDV_FLAG
VARCHAR2 (1 Byte) 		A mandatory flag indicating the archive type: F – Foreign, D-Domestic,V– Vessel Log
ARCHIVE_TYPE
VARCHAR2 (30 Byte) 		A mandatory foreign key referencing the CAS_LOV_ARCHIVE_TYPE table, indicating the archive type.
DATA_YEAR
NUMBER (4) 		The year in which the record was created.
CRUISE
NUMBER (8) 		A sequence generated by Norpac and provided to the observer as a unique identifier for an observer cruise record.
VESSEL
VARCHAR2 (30 Byte) 		A sequence-generated unique identifier for an Atlas vessel record. The lov_vessel table combines the vessplant and catcher boat code tables.
PERMIT
VARCHAR2 (6 Byte) 		Unique Code identifying a vessel - inherited from the NORPAC data set and created by the RAM division in Juneau
CRUISE_RANGE
VARCHAR2 (50 Byte) 		The range of observer cruise numbers that comprise the archive.
NATION
VARCHAR2 (30 Byte) 		The country to which the observed vessel belongs.
BOX_NUMBER
NUMBER (3) 		The order number of the physical box that contains the document.
VESSLOG_BOX_CONTENT
VARCHAR2 (100 Byte) 		A summary, list, or description of the contents within the box.
ACCESSION_CODE
VARCHAR2 (100 Byte) 		A unique identifier assigned to a group of archival materials that have been transferred into the legal custody of the National Archives and Records Administration (NARA).
LOCATION_NUMBER
VARCHAR2 (100 Byte) 		A unique identifier created by local NARA units to identify specific archival materials.
DISPOSAL_CODE
VARCHAR2 (50 Byte) 		The unique identifier assigned by NARA to a category of records, indicating that their disposition has been approved. This is also known as the schedule number.
COMMENTS
VARCHAR2 (4000 Byte) 		Additional comments or notes related to the archive

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: CAS_ARCHIVE_ALL_H
Creation Date: 2016-05-06
Abstract:

History record table for CAS_ARCHIVE_ALL 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
 ARCHIVE_SEQ NUMBER (38) Primary key or the table CAS_ARCHIVE_ALL.
100
 FDV_FLAG VARCHAR2 (1 Byte) A mandatory flag indicating the archive type: F – Foreign, D-Domestic,V– Vessel Log
100
 ARCHIVE_TYPE VARCHAR2 (30 Byte) A mandatory foreign key referencing the CAS_LOV_ARCHIVE_TYPE table, indicating the archive type.
100
 DATA_YEAR NUMBER (4) The year in which the record was created.
100
 CRUISE NUMBER (8) A sequence generated by Norpac and provided to the observer as a unique identifier for an observer cruise record.
100
 VESSEL VARCHAR2 (30 Byte) A sequence-generated unique identifier for an Atlas vessel record. The lov_vessel table combines the vessplant and catcher boat code tables.
100
 PERMIT VARCHAR2 (6 Byte) Unique Code identifying a vessel - inherited from the NORPAC data set and created by the RAM division in Juneau
100
 CRUISE_RANGE VARCHAR2 (50 Byte) The range of observer cruise numbers that comprise the archive.
100
 NATION VARCHAR2 (30 Byte) The country to which the observed vessel belongs.
100
 BOX_NUMBER NUMBER (3) The order number of the physical box that contains the document.
100
 VESSLOG_BOX_CONTENT VARCHAR2 (100 Byte) A summary, list, or description of the contents within the box.
100
 ACCESSION_CODE VARCHAR2 (100 Byte) A unique identifier assigned to a group of archival materials that have been transferred into the legal custody of the National Archives and Records Administration (NARA).
100
 LOCATION_NUMBER VARCHAR2 (100 Byte) A unique identifier created by local NARA units to identify specific archival materials.
100
 DISPOSAL_CODE VARCHAR2 (50 Byte) The unique identifier assigned by NARA to a category of records, indicating that their disposition has been approved. This is also known as the schedule number.
100
 COMMENTS VARCHAR2 (4000 Byte) Additional comments or notes related to the archive

Attribute Details

SEQ_NUMBER

CC ID: 1378086
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: 1378087
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: 1378088
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.

ARCHIVE_SEQ

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

Primary key or the table CAS_ARCHIVE_ALL.

FDV_FLAG

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

A mandatory flag indicating the archive type: F – Foreign, D-Domestic,V– Vessel Log

ARCHIVE_TYPE

CC ID: 1378094
Seq. Order: 6
Data Storage Type: VARCHAR2 (30 Byte)
Required: No
Primary Key: No
Status: Active
Description:

A mandatory foreign key referencing the CAS_LOV_ARCHIVE_TYPE table, indicating the archive type.

DATA_YEAR

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

The year in which the record was created.

CRUISE

CC ID: 1378096
Seq. Order: 8
Data Storage Type: NUMBER (8)
Required: No
Primary Key: No
Status: Active
Description:

A sequence generated by Norpac and provided to the observer as a unique identifier for an observer cruise record.

VESSEL

CC ID: 1378097
Seq. Order: 9
Data Storage Type: VARCHAR2 (30 Byte)
Required: No
Primary Key: No
Status: Active
Description:

A sequence-generated unique identifier for an Atlas vessel record. The lov_vessel table combines the vessplant and catcher boat code tables.

PERMIT

CC ID: 1378098
Seq. Order: 10
Data Storage Type: VARCHAR2 (6 Byte)
Required: No
Primary Key: No
Status: Active
Description:

Unique Code identifying a vessel - inherited from the NORPAC data set and created by the RAM division in Juneau

CRUISE_RANGE

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

The range of observer cruise numbers that comprise the archive.

NATION

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

The country to which the observed vessel belongs.

BOX_NUMBER

CC ID: 1378101
Seq. Order: 13
Data Storage Type: NUMBER (3)
Required: No
Primary Key: No
Status: Active
Description:

The order number of the physical box that contains the document.

VESSLOG_BOX_CONTENT

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

A summary, list, or description of the contents within the box.

ACCESSION_CODE

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

A unique identifier assigned to a group of archival materials that have been transferred into the legal custody of the National Archives and Records Administration (NARA).

LOCATION_NUMBER

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

A unique identifier created by local NARA units to identify specific archival materials.

DISPOSAL_CODE

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

The unique identifier assigned by NARA to a category of records, indicating that their disposition has been approved. This is also known as the schedule number.

COMMENTS

CC ID: 1378106
Seq. Order: 18
Data Storage Type: VARCHAR2 (4000 Byte)
Required: No
Primary Key: No
Status: Active
Description:

Additional comments or notes related to the archive

Catalog Details

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