Slide Menu
Jump to Section...
Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Fishery Monitoring & Research Division (FMRD) > Northeast Cooperative Research Program (NCRP) > Industry Based Survey (IBS) Yellowtail >

Table: SVCRUISE_STATUS

Entity (ENT)  |  Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:31520  |  Updated: August 9, 2022  |  Published / External 

Item Identification

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

Support table for the STATUS_CODE field of the MASTER_CRUISE_TABLE and MASTER_CRUISE_DETAILS table. Identifies the availability of master data.
Notes:

Loaded by batch 8361, 03-16-2016 14:49

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: SVDBS
Description:

Support table for the STATUS_CODE field of the MASTER_CRUISE_TABLE and MASTER_CRUISE_DETAILS table. Identifies the availability of master data.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key STATUS_CODE VARCHAR2 Code referencing whether or not a cruise is available in the SVDBS system. See SVDBS.SVCRUISE_STATUS
100
 STATUS VARCHAR2 A data status code indictating whether a cruise is availabe in SVDBS system. See SVDBS.SVCRUISE_STATUS

Attribute Details

STATUS_CODE

CC ID: 307426
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 2
Required: Yes
Primary Key: Yes
Status: Active
Description:

Code referencing whether or not a cruise is available in the SVDBS system. See SVDBS.SVCRUISE_STATUS
General Data Type: VARCHAR2

STATUS

CC ID: 307427
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

A data status code indictating whether a cruise is availabe in SVDBS system. See SVDBS.SVCRUISE_STATUS
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 31520
GUID: gov.noaa.nmfs.inport:31520
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-03-16 14:49+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-07-29
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-07-29
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-07-29