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) > Yellowtail Tagging Data (MRDBS) >

Table: MRPORTS

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

Item Identification

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

no-comment
Notes:

Loaded by batch 9111, 08-01-2016 12:11

Entity Information

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

no-comment

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 PORT VARCHAR2 Port (6-character code), see support table MRPORTS for descriptions.
100
 STATECD VARCHAR2 State code (2-digit code).
100
 PORT2 VARCHAR2 Port (2-character code).
100
 COUNTYCD VARCHAR2 County code.
100
 PORTNM VARCHAR2 Port name.
100
 STATEABB VARCHAR2 State abbreviation (2-character code).
100
 COUNTY VARCHAR2 County.
100
 PSREGION VARCHAR2 Northeast sampling regions (see CFDBS.PORTS for complete description).
100
 DOC DATE Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS).

Attribute Details

PORT

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

Port (6-character code), see support table MRPORTS for descriptions.
General Data Type: VARCHAR2

STATECD

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

State code (2-digit code).
General Data Type: VARCHAR2

PORT2

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

Port (2-character code).
General Data Type: VARCHAR2

COUNTYCD

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

County code.
General Data Type: VARCHAR2

PORTNM

CC ID: 341312
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

Port name.
General Data Type: VARCHAR2

STATEABB

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

State abbreviation (2-character code).
General Data Type: VARCHAR2

COUNTY

CC ID: 341314
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

County.
General Data Type: VARCHAR2

PSREGION

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

Northeast sampling regions (see CFDBS.PORTS for complete description).
General Data Type: VARCHAR2

DOC

CC ID: 341316
Seq. Order: 9
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

Catalog Details

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