Table: SVCRUISE_STATUS
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:31501 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Support table for the STATUS_CODE field of the MASTER_CRUISE_TABLE and MASTER_CRUISE_DETAILS table. Identifies the availability of master data.
DescriptionSupport table for the STATUS_CODE field of the MASTER_CRUISE_TABLE and MASTER_CRUISE_DETAILS table. Identifies the availability of master data.
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
STATUS_CODE
VARCHAR2 |
Code referencing whether or not a cruise is available in the SVDBS system. See SVDBS.SVCRUISE_STATUS |
STATUS
VARCHAR2 |
A data status code indictating whether a cruise is availabe in SVDBS system. See SVDBS.SVCRUISE_STATUS |
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: 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 8360, 03-16-2016 14:48 |
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
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
100
|
![]() |
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
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
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: | 31501 |
---|---|
GUID: | gov.noaa.nmfs.inport:31501 |
Metadata Record Created By: | Patricia L Jones |
Metadata Record Created: | 2016-03-16 14:48+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 |