Table: BENPURPOSE
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:31071 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Benthic Cruise Purpose Codes and Description Support Table
DescriptionBenthic Cruise Purpose Codes and Description Support Table
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
PURPOSE_CODE
VARCHAR2 |
Code referencing purpose of cruise conducted. See table SVDBS.SVCRUISE_PURPOSE for list of purpose codes. |
PURPOSE
VARCHAR2 |
Cruise Purpose description. |
DOE
DATE |
Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS). |
UOE
VARCHAR2 |
The Oracle username of the individual who entered the new record. |
DOC
DATE |
Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS). |
UOC
VARCHAR2 |
The Oracle username of the individual who changed the current record. |
Child Items
No Child Items for this record.
Contact Information
No contact information is available for this record.
Please contact the owner organization (NEFSC) for inquiries on this record.
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
![]() |
![]() |
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
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
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
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
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
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
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 |