Table: MRNATIONS
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:33168 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Nations used in recording an event and for formatting addresses
DescriptionNations used in recording an event and for formatting addresses
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
NATIONCD
VARCHAR2 |
Nation code. |
NATION_DESC
VARCHAR2 |
Nation description. |
ADDRESS_FORMAT
VARCHAR2 |
Address format. 1= city state/province postal code; 2= postal code city state/province; 3= city state/province/county postal code;;4= city postal code state/province |
FISHERY_STRING
VARCHAR2 |
Fisheries to which species is affiliated (comma separated list of fishery codes). |
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. |
MRSEQUENCE
VARCHAR2 |
Sequencing for web application select list |
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: MRNATIONS |
---|---|
Short Name: | MRNATIONS |
Status: | Completed |
Abstract: |
Nations used in recording an event and for formatting addresses |
Notes: |
Loaded by batch 8929, 07-01-2016 09:57 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | MRDBS |
Description: |
Nations used in recording an event and for formatting addresses |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
NATIONCD | VARCHAR2 | Nation code. | |
100
|
NATION_DESC | VARCHAR2 | Nation description. | |
100
|
ADDRESS_FORMAT | VARCHAR2 | Address format. 1= city state/province postal code; 2= postal code city state/province; 3= city state/province/county postal code;;4= city postal code state/province | |
100
|
FISHERY_STRING | VARCHAR2 | Fisheries to which species is affiliated (comma separated list of fishery codes). | |
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. | |
100
|
MRSEQUENCE | VARCHAR2 | Sequencing for web application select list |
Attribute Details
NATIONCD
Seq. Order: | 1 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | Yes |
Primary Key: | Yes |
Status: | Active |
Description: |
Nation code. |
General Data Type: | VARCHAR2 |
NATION_DESC
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 40 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Nation description. |
General Data Type: | VARCHAR2 |
ADDRESS_FORMAT
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Address format. 1= city state/province postal code; 2= postal code city state/province; 3= city state/province/county postal code;;4= city postal code state/province |
General Data Type: | VARCHAR2 |
FISHERY_STRING
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Fisheries to which species is affiliated (comma separated list of fishery codes). |
General Data Type: | VARCHAR2 |
DOE
Seq. Order: | 5 |
---|---|
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: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 12 |
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: | 7 |
---|---|
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: | 8 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 12 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The Oracle username of the individual who changed the current record. |
General Data Type: | VARCHAR2 |
MRSEQUENCE
Seq. Order: | 9 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 40 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Sequencing for web application select list |
General Data Type: | VARCHAR2 |
Catalog Details
Catalog Item ID: | 33168 |
---|---|
GUID: | gov.noaa.nmfs.inport:33168 |
Metadata Record Created By: | Patricia L Jones |
Metadata Record Created: | 2016-07-01 09:57+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2016-07-27 |
Owner Org: | NEFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2016-07-27 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2017-07-27 |