Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Location information used to calculate latitude and longitude from a reported location

Notes:

Loaded by batch 9651, 01-12-2017 16:35

Entity Information

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

Location information used to calculate latitude and longitude from a reported location

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key LOCCD VARCHAR2 Location code.
100
LOC_DESC VARCHAR2 Location description.
100
FISHERY_STRING VARCHAR2 Fisheries to which species is affiliated (comma separated list of fishery codes).
100
ONLAND VARCHAR2 on land (not used).
100
NOS VARCHAR2 North or south.
100
EOW VARCHAR2 East or west.
100
MAPCORRECT FLOAT Map correct.
100
COUNTY VARCHAR2 County.
100
COAST VARCHAR2 Coast.
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
LAT_DEG VARCHAR2 Latitude degrees. (redacted)
100
LAT_MIN VARCHAR2 Latitude minutes. (redacted)
100
LAT_SEC VARCHAR2 Latitude seconds. (redacted)
100
LON_DEG VARCHAR2 Longitude degrees. (redacted)
100
LON_MIN VARCHAR2 Longitude minutes. (redacted)
100
LON_SEC VARCHAR2 Longitude seconds. (redacted)
100
MRSEQUENCE VARCHAR2 Sequencing for web application select list

Attribute Details

LOCCD

CC ID: 374437
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 4
Required: Yes
Primary Key: Yes
Status: Active
Description:

Location code.

General Data Type: VARCHAR2

LOC_DESC

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

Location description.

General Data Type: VARCHAR2

FISHERY_STRING

CC ID: 374450
Seq. Order: 3
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

ONLAND

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

on land (not used).

General Data Type: VARCHAR2

NOS

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

North or south.

General Data Type: VARCHAR2

EOW

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

East or west.

General Data Type: VARCHAR2

MAPCORRECT

CC ID: 374454
Seq. Order: 7
Data Storage Type: FLOAT
Max Length: 22
Required: No
Primary Key: No
Precision: 126
Status: Active
Description:

Map correct.

General Data Type: FLOAT

COUNTY

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

County.

General Data Type: VARCHAR2

COAST

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

Coast.

General Data Type: VARCHAR2

DOE

CC ID: 374438
Seq. Order: 10
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

CC ID: 374439
Seq. Order: 11
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

CC ID: 374440
Seq. Order: 12
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

CC ID: 374441
Seq. Order: 13
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

LAT_DEG

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

Latitude degrees. (redacted)

General Data Type: VARCHAR2

LAT_MIN

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

Latitude minutes. (redacted)

General Data Type: VARCHAR2

LAT_SEC

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

Latitude seconds. (redacted)

General Data Type: VARCHAR2

LON_DEG

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

Longitude degrees. (redacted)

General Data Type: VARCHAR2

LON_MIN

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

Longitude minutes. (redacted)

General Data Type: VARCHAR2

LON_SEC

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

Longitude seconds. (redacted)

General Data Type: VARCHAR2

MRSEQUENCE

CC ID: 374449
Seq. Order: 20
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: 36270
GUID: gov.noaa.nmfs.inport:36270
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2017-01-12 16:35+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2017-01-12
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2017-01-12
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2018-01-12