Table: MRPORTS
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:33904 | Updated: August 9, 2022 | Published / External
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details
Data Attributes
Attribute Summary
|
|
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 |