Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Benthic Cruise Purpose Codes and Description Support Table

Notes:

Loaded by batch 8254, 03-08-2016 15:45

Entity Information

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

Benthic Cruise Purpose Codes and Description Support Table

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
PURPOSE_CODE VARCHAR2 Code referencing purpose of cruise conducted. See table SVDBS.SVCRUISE_PURPOSE for list of purpose codes.
100
PURPOSE VARCHAR2 Cruise Purpose description.
100
DOE DATE Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS).
100
UOE VARCHAR2 The Oracle username of the individual who entered the new record.
100
DOC DATE Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS).
100
UOC VARCHAR2 The Oracle username of the individual who changed the current record.

Attribute Details

PURPOSE_CODE

CC ID: 301537
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Code referencing purpose of cruise conducted. See table SVDBS.SVCRUISE_PURPOSE for list of purpose codes.

General Data Type: VARCHAR2

PURPOSE

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

Cruise Purpose description.

General Data Type: VARCHAR2

DOE

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

Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS).

General Data Type: DATE

UOE

CC ID: 301540
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

The Oracle username of the individual who entered the new record.

General Data Type: VARCHAR2

DOC

CC ID: 301541
Seq. Order: 5
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS).

General Data Type: DATE

UOC

CC ID: 301542
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

The Oracle username of the individual who changed the current record.

General Data Type: VARCHAR2

Catalog Details

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