Slide Menu
Jump to Section...
Search Help Show/Hide Menu
Metadata Rubric
67%
4 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > Observer Restructure (ODDS) > AFSC/FMA/Observer Declare and Deploy (Resturctu... >

View: ODDS_LOGGED_TRIP_SUMMARY_V

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:18855  |  Updated: August 9, 2022  |  Published / External 

Item Identification

Title: View: ODDS_LOGGED_TRIP_SUMMARY_V
Short Name: ODDS_LOGGED_TRIP_SUMMARY_V
Status: Completed
Notes:

Loaded by batch 4561, 04-30-2013 18:33

Entity Information

Entity Type: Data View
Active Version?: Yes
Schema Name: NORPAC

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
67
 YEAR VARCHAR2
67
 ODDS_TRIP_NUMBER NUMBER
67
 ODDS_SAMPLE_PLAN NUMBER
67
 ODDS_SAMPLE_PLAN_DESCRIPTION VARCHAR2
67
 OBSERVER_STATUS_CODE VARCHAR2
67
 OBSERVER_STATUS_DESCRIPTION VARCHAR2
67
 VESSEL_CANCELLED_OBS_TRIP VARCHAR2
67
 NMFS_RELEASE_FROM_COVERAGE VARCHAR2
67
 LOGGED_BY VARCHAR2
67
 LOGGED_BY_ACCOUNT_TYPE VARCHAR2
67
 TELEPHONE_CENTER_LOGGED_FOR VARCHAR2
67
 LOGGED_FOR_ACCOUNT_TYPE VARCHAR2
67
 VESSEL_NAME VARCHAR2
67
 ADFG NUMBER
67
 AKR_VESSEL_ID NUMBER
67
 VESSEL_LENGTH NUMBER
67
 DATE_LOGGED DATE
67
 NUMBER_OF_TIMES_TRIP_EDITED NUMBER
67
 LAST_TIME_EDITED DATE
67
 LAST_EDITED_BY VARCHAR2
67
 LAST_EDITED_BY_ACCOUNT_TYPE VARCHAR2
67
 GEAR_TYPE CHAR
67
 TRIP_STATUS VARCHAR2
67
 DATE_CANCELED DATE
67
 DECLARED_LEAVE_DATE DATE
67
 DECLARED_PORT_OF_DEPARTURE VARCHAR2
67
 DECLARED_RETURN_DATE DATE
67
 CLOSED_RETURN_DATE DATE
67
 DECLARED_PLANT_OFFLOADING_TO VARCHAR2
67
 DECLARED_PROCESSOR_ID NUMBER
67
 CLOSED_PLANT_OFFLOADED_TO VARCHAR2
67
 CLOSED_PROCESSOR_ID NUMBER
67
 CLOSED_LANDING_ID NUMBER

Attribute Details

YEAR

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

ODDS_TRIP_NUMBER

CC ID: 108005
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 9
Scale: 0
Status: Active
General Data Type: NUMBER

ODDS_SAMPLE_PLAN

CC ID: 108016
Seq. Order: 3
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Status: Active
General Data Type: NUMBER

ODDS_SAMPLE_PLAN_DESCRIPTION

CC ID: 108021
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 50
Required: Yes
Primary Key: No
Status: Active
General Data Type: VARCHAR2

OBSERVER_STATUS_CODE

CC ID: 108022
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

OBSERVER_STATUS_DESCRIPTION

CC ID: 108023
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

VESSEL_CANCELLED_OBS_TRIP

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

NMFS_RELEASE_FROM_COVERAGE

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

LOGGED_BY

CC ID: 108026
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 200
Required: Yes
Primary Key: No
Status: Active
General Data Type: VARCHAR2

LOGGED_BY_ACCOUNT_TYPE

CC ID: 107995
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

TELEPHONE_CENTER_LOGGED_FOR

CC ID: 107996
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 200
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

LOGGED_FOR_ACCOUNT_TYPE

CC ID: 107997
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

VESSEL_NAME

CC ID: 107998
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

ADFG

CC ID: 107999
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
General Data Type: NUMBER

AKR_VESSEL_ID

CC ID: 108000
Seq. Order: 15
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
General Data Type: NUMBER

VESSEL_LENGTH

CC ID: 108001
Seq. Order: 16
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 0
Status: Active
General Data Type: NUMBER

DATE_LOGGED

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

NUMBER_OF_TIMES_TRIP_EDITED

CC ID: 108003
Seq. Order: 18
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 0
Status: Active
General Data Type: NUMBER

LAST_TIME_EDITED

CC ID: 108004
Seq. Order: 19
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
General Data Type: DATE

LAST_EDITED_BY

CC ID: 108006
Seq. Order: 20
Data Storage Type: VARCHAR2
Max Length: 200
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

LAST_EDITED_BY_ACCOUNT_TYPE

CC ID: 108007
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

GEAR_TYPE

CC ID: 108008
Seq. Order: 22
Data Storage Type: CHAR
Max Length: 5
Required: No
Primary Key: No
Status: Active
General Data Type: CHAR

TRIP_STATUS

CC ID: 108009
Seq. Order: 23
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

DATE_CANCELED

CC ID: 108010
Seq. Order: 24
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
General Data Type: DATE

DECLARED_LEAVE_DATE

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

DECLARED_PORT_OF_DEPARTURE

CC ID: 108012
Seq. Order: 26
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

DECLARED_RETURN_DATE

CC ID: 108013
Seq. Order: 27
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
General Data Type: DATE

CLOSED_RETURN_DATE

CC ID: 108014
Seq. Order: 28
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
General Data Type: DATE

DECLARED_PLANT_OFFLOADING_TO

CC ID: 108015
Seq. Order: 29
Data Storage Type: VARCHAR2
Max Length: 50
Required: Yes
Primary Key: No
Status: Active
General Data Type: VARCHAR2

DECLARED_PROCESSOR_ID

CC ID: 108017
Seq. Order: 30
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
General Data Type: NUMBER

CLOSED_PLANT_OFFLOADED_TO

CC ID: 108018
Seq. Order: 31
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

CLOSED_PROCESSOR_ID

CC ID: 108019
Seq. Order: 32
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
General Data Type: NUMBER

CLOSED_LANDING_ID

CC ID: 108020
Seq. Order: 33
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
General Data Type: NUMBER

Catalog Details

Catalog Item ID: 18855
GUID: gov.noaa.nmfs.inport:18855
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2013-04-30 18:33+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-05-18
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-05-18
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-05-18