75380 Entity Published / External 75377 Catalog Archive Storage Data Set 2016-05-06 History record table for CAS_ARCHIVE_ALL table. 1 SEQ_NUMBER NUMBER Yes Yes Active Primary key of history table. Generated by database. 2 CHANGED_BY VARCHAR2 (100 Byte) No No Active The user who changed the record lastly. 3 DATE_CHANGED DATE No No Active The date and time on which the record was changed lastly. 4 ARCHIVE_SEQ NUMBER (38) No No Active Primary key or the table CAS_ARCHIVE_ALL. 5 FDV_FLAG VARCHAR2 (1 Byte) No No Active A mandatory flag indicating the archive type: F – Foreign, D-Domestic,V– Vessel Log 6 ARCHIVE_TYPE VARCHAR2 (30 Byte) No No Active A mandatory foreign key referencing the CAS_LOV_ARCHIVE_TYPE table, indicating the archive type. 7 DATA_YEAR NUMBER (4) No No Active The year in which the record was created. 8 CRUISE NUMBER (8) No No Active A sequence generated by Norpac and provided to the observer as a unique identifier for an observer cruise record. 9 VESSEL VARCHAR2 (30 Byte) No No Active A sequence-generated unique identifier for an Atlas vessel record. The lov_vessel table combines the vessplant and catcher boat code tables. 10 PERMIT VARCHAR2 (6 Byte) No No Active Unique Code identifying a vessel - inherited from the NORPAC data set and created by the RAM division in Juneau 11 CRUISE_RANGE VARCHAR2 (50 Byte) No No Active The range of observer cruise numbers that comprise the archive. 12 NATION VARCHAR2 (30 Byte) No No Active The country to which the observed vessel belongs. 13 BOX_NUMBER NUMBER (3) No No Active The order number of the physical box that contains the document. 14 VESSLOG_BOX_CONTENT VARCHAR2 (100 Byte) No No Active A summary, list, or description of the contents within the box. 15 ACCESSION_CODE VARCHAR2 (100 Byte) No No Active 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). 16 LOCATION_NUMBER VARCHAR2 (100 Byte) No No Active A unique identifier created by local NARA units to identify specific archival materials. 17 DISPOSAL_CODE VARCHAR2 (50 Byte) No No Active 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. 18 COMMENTS VARCHAR2 (4000 Byte) No No Active Additional comments or notes related to the archive gov.noaa.nmfs.inport:75380 Martin Park 2025-03-25T21:36:20 Martin Park 2025-03-25T23:13:49 2025-03-25 Alaska Fisheries Science Center AFSC 7600 Sand Point Way N.E., Building 4 Seattle WA 98115 USA https://www.afsc.noaa.gov 0700-1700 Pacific Time 1001 Public No 1 Year