Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: View: FLS_ORIGINAL_VESSELS_V
Short Name: FLS_ORIGINAL_VESSELS_V
Status: Completed
Abstract:

Source file for this data

Notes:

Loaded by batch 2103, 02-28-2008 14:10

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None legacy view
None vessels

Entity Information

Entity Type: Data View
Active Version?: Yes
Schema Name: FLS
Description:

Source file for this data

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
67
SOURCE VARCHAR2
100
SCHEDULE VARCHAR2 Schdeule Number
100
BATCH VARCHAR2 Batch Number
100
TIF_NO VARCHAR2 Name Of Image File
100
VESID VARCHAR2 Vessel Id
100
STARTED DATE Date Fishing Started
100
LANDED DATE Date Vessel Landed
100
UNLOAD DATE Date Boat Was Unloaded
100
RECEIVED DATE Date Lognook Form Was Received
100
OPENED DATE Date Logbook Form was opened
100
AWAY NUMBER Number Of Days Away
100
CREW NUMBER Crew Size
100
DEALER VARCHAR2 Dealer Code
100
STATE VARCHAR2 NMFS State Code
100
COUNTY VARCHAR2 NMFS County Code
100
AREA1 NUMBER First Area Fished
100
AREA2 NUMBER Second Area Fished
100
AREA3 NUMBER Third Area Fished
100
TRIP_TICKET VARCHAR2 State Trip Ticket Number
100
SOURCE_FILE VARCHAR2 File That was Source Of This Data

Attribute Details

SOURCE

CC ID: 27309
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 7
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

SCHEDULE

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

Schdeule Number

General Data Type: VARCHAR2

BATCH

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

Batch Number

General Data Type: VARCHAR2

TIF_NO

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

Name Of Image File

General Data Type: VARCHAR2

VESID

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

Vessel Id

General Data Type: VARCHAR2

STARTED

CC ID: 27294
Seq. Order: 6
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date Fishing Started

General Data Type: DATE

LANDED

CC ID: 27307
Seq. Order: 7
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Date Vessel Landed

General Data Type: DATE

UNLOAD

CC ID: 27295
Seq. Order: 8
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date Boat Was Unloaded

General Data Type: DATE

RECEIVED

CC ID: 27311
Seq. Order: 9
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date Lognook Form Was Received

General Data Type: DATE

OPENED

CC ID: 27301
Seq. Order: 10
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date Logbook Form was opened

General Data Type: DATE

AWAY

CC ID: 27297
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Number Of Days Away

General Data Type: NUMBER

CREW

CC ID: 27298
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Crew Size

General Data Type: NUMBER

DEALER

CC ID: 27296
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Dealer Code

General Data Type: VARCHAR2

STATE

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

NMFS State Code

General Data Type: VARCHAR2

COUNTY

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

NMFS County Code

General Data Type: VARCHAR2

AREA1

CC ID: 27293
Seq. Order: 16
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

First Area Fished

General Data Type: NUMBER

AREA2

CC ID: 27310
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Second Area Fished

General Data Type: NUMBER

AREA3

CC ID: 27306
Seq. Order: 18
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Third Area Fished

General Data Type: NUMBER

TRIP_TICKET

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

State Trip Ticket Number

General Data Type: VARCHAR2

SOURCE_FILE

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

File That was Source Of This Data

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 7163
GUID: gov.noaa.nmfs.inport:7163
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2008-02-28 14:10+0000
Metadata Record Last Modified By: Lee M Weinberger
Metadata Record Last Modified: 2021-05-06 22:24+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-05-07