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

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

Summary

Abstract

Table contains list of archive boxes and content, and location, accession in the archive for Federal record archiving.

Entity Information

Data Attribute / Type Description
ARCHIVE_SEQ
NUMBER(38) 		A database-generated primary key or the table that provides a unique sequential number for each record.
FDV_FLAG
VARCHAR2(1) 		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
Creation Date: 2016-05-06
Abstract:

Table contains list of archive boxes and content, and location, accession in the archive for Federal record archiving.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key ARCHIVE_SEQ NUMBER(38) A database-generated primary key or the table that provides a unique sequential number for each record.
100
 FDV_FLAG VARCHAR2(1) 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

ARCHIVE_SEQ

CC ID: 1378069
Seq. Order: 1
Data Storage Type: NUMBER(38)
Required: Yes
Primary Key: Yes
Precision: 38
Status: Active
Description:

A database-generated primary key or the table that provides a unique sequential number for each record.

FDV_FLAG

CC ID: 1378070
Seq. Order: 2
Data Storage Type: VARCHAR2(1)
Required: Yes
Primary Key: No
Status: Active
Description:

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

ARCHIVE_TYPE

CC ID: 1378071
Seq. Order: 3
Data Storage Type: VARCHAR2 (30 Byte)
Required: Yes
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: 1378072
Seq. Order: 4
Data Storage Type: NUMBER (4)
Required: Yes
Primary Key: No
Status: Active
Description:

The year in which the record was created.

CRUISE

CC ID: 1378073
Seq. Order: 5
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: 1378074
Seq. Order: 6
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: 1378075
Seq. Order: 7
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: 1378076
Seq. Order: 8
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: 1378077
Seq. Order: 9
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: 1378078
Seq. Order: 10
Data Storage Type: NUMBER (3)
Required: Yes
Primary Key: No
Status: Active
Description:

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

VESSLOG_BOX_CONTENT

CC ID: 1378079
Seq. Order: 11
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: 1378080
Seq. Order: 12
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: 1378081
Seq. Order: 13
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: 1378082
Seq. Order: 14
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: 1378084
Seq. Order: 15
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: 75379
GUID: gov.noaa.nmfs.inport:75379
Metadata Record Created By: Martin Park
Metadata Record Created: 2025-03-25 21:27+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