Slide Menu
Jump to Section...
Search Help Show/Hide Menu
Metadata Rubric
67%
4 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > North Pacific (NORPAC) Groundfish and Halibut O... > AFSC/FMA/North Pacific Groundfish and Halibut O... >

Table: ATL_CRUISE_VESSEL_H

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:7366  |  Updated: August 9, 2022  |  Published / External 

Item Identification

Title: Table: ATL_CRUISE_VESSEL_H
Short Name: ATL_CRUISE_VESSEL_H
Status: Completed
Abstract:

The intersection of an observer cruise and a vessel
Purpose:

Histories of all changes to data are maintained by trigger code on the parent table; allowing change control by user and datetime for all updates and delete events.
Notes:

Loaded by batch 2164, 03-27-2008 10:42

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: NORPAC

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
67
 Primary Key SEQ_NUMBER NUMBER
67
 CHANGED_BY VARCHAR2
67
 DATE_CHANGED DATE
67
 CRUISE_VESSEL_SEQ NUMBER
67
 CRUISE NUMBER
67
 VESSEL_SEQ NUMBER
67
 STATUS NUMBER
67
 STATUS_DATE DATE
67
 STATUS_USER VARCHAR2
67
 COMMENTS VARCHAR2

Attribute Details

SEQ_NUMBER

CC ID: 28508
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 10
Scale: 0
Status: Active
General Data Type: NUMBER

CHANGED_BY

CC ID: 28503
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

DATE_CHANGED

CC ID: 28507
Seq. Order: 3
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
General Data Type: DATE

CRUISE_VESSEL_SEQ

CC ID: 28506
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 22
Scale: 0
Status: Active
General Data Type: NUMBER

CRUISE

CC ID: 28505
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 22
Scale: 0
Status: Active
General Data Type: NUMBER

VESSEL_SEQ

CC ID: 28512
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 22
Scale: 0
Status: Active
General Data Type: NUMBER

STATUS

CC ID: 28509
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 22
Scale: 0
Status: Active
General Data Type: NUMBER

STATUS_DATE

CC ID: 28510
Seq. Order: 8
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
General Data Type: DATE

STATUS_USER

CC ID: 28511
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

COMMENTS

CC ID: 28504
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 2000
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 7366
GUID: gov.noaa.nmfs.inport:7366
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2008-03-27 10:42+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2018-09-26
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2018-09-26
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2019-09-26