Metadata Rubric

67%

4 / 6

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Entity Type
Data View

Data Attribute / Type	Description
YEAR VARCHAR2
ODDS_TRIP_NUMBER NUMBER
ODDS_SAMPLE_PLAN NUMBER
ODDS_SAMPLE_PLAN_DESCRIPTION VARCHAR2
OBSERVER_STATUS_CODE VARCHAR2
OBSERVER_STATUS_DESCRIPTION VARCHAR2
VESSEL_CANCELLED_OBS_TRIP VARCHAR2
NMFS_RELEASE_FROM_COVERAGE VARCHAR2
LOGGED_BY VARCHAR2
LOGGED_BY_ACCOUNT_TYPE VARCHAR2
TELEPHONE_CENTER_LOGGED_FOR VARCHAR2
LOGGED_FOR_ACCOUNT_TYPE VARCHAR2
VESSEL_NAME VARCHAR2
ADFG NUMBER
AKR_VESSEL_ID NUMBER
VESSEL_LENGTH NUMBER
DATE_LOGGED DATE
NUMBER_OF_TIMES_TRIP_EDITED NUMBER
LAST_TIME_EDITED DATE
LAST_EDITED_BY VARCHAR2
LAST_EDITED_BY_ACCOUNT_TYPE VARCHAR2
GEAR_TYPE CHAR
TRIP_STATUS VARCHAR2
DATE_CANCELED DATE
DECLARED_LEAVE_DATE DATE
DECLARED_PORT_OF_DEPARTURE VARCHAR2
DECLARED_RETURN_DATE DATE
CLOSED_RETURN_DATE DATE
DECLARED_PLANT_OFFLOADING_TO VARCHAR2
DECLARED_PROCESSOR_ID NUMBER
CLOSED_PLANT_OFFLOADED_TO VARCHAR2
CLOSED_PROCESSOR_ID NUMBER
CLOSED_LANDING_ID NUMBER

Data Attribute / Type

Description

YEAR
VARCHAR2

ODDS_TRIP_NUMBER
NUMBER

ODDS_SAMPLE_PLAN
NUMBER

ODDS_SAMPLE_PLAN_DESCRIPTION
VARCHAR2

OBSERVER_STATUS_CODE
VARCHAR2

OBSERVER_STATUS_DESCRIPTION
VARCHAR2

VESSEL_CANCELLED_OBS_TRIP
VARCHAR2

NMFS_RELEASE_FROM_COVERAGE
VARCHAR2

LOGGED_BY
VARCHAR2

LOGGED_BY_ACCOUNT_TYPE
VARCHAR2

TELEPHONE_CENTER_LOGGED_FOR
VARCHAR2

LOGGED_FOR_ACCOUNT_TYPE
VARCHAR2

VESSEL_NAME
VARCHAR2

ADFG
NUMBER

AKR_VESSEL_ID
NUMBER

VESSEL_LENGTH
NUMBER

DATE_LOGGED
DATE

NUMBER_OF_TIMES_TRIP_EDITED
NUMBER

LAST_TIME_EDITED
DATE

LAST_EDITED_BY
VARCHAR2

LAST_EDITED_BY_ACCOUNT_TYPE
VARCHAR2

GEAR_TYPE
CHAR

TRIP_STATUS
VARCHAR2

DATE_CANCELED
DATE

DECLARED_LEAVE_DATE
DATE

DECLARED_PORT_OF_DEPARTURE
VARCHAR2

DECLARED_RETURN_DATE
DATE

CLOSED_RETURN_DATE
DATE

DECLARED_PLANT_OFFLOADING_TO
VARCHAR2

DECLARED_PROCESSOR_ID
NUMBER

CLOSED_PLANT_OFFLOADED_TO
VARCHAR2

CLOSED_PROCESSOR_ID
NUMBER

CLOSED_LANDING_ID
NUMBER

No Child Items for this record.

No contact information is available for this record.

Please contact the owner organization (AFSC) for inquiries on this record.

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 Type:	Data View
Active Version?:	Yes
Schema Name:	NORPAC

Attribute Summary

	Name	Type
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

Name

Type

Description

YEAR

VARCHAR2

ODDS_TRIP_NUMBER

NUMBER

ODDS_SAMPLE_PLAN

NUMBER

ODDS_SAMPLE_PLAN_DESCRIPTION

VARCHAR2

OBSERVER_STATUS_CODE

VARCHAR2

OBSERVER_STATUS_DESCRIPTION

VARCHAR2

VESSEL_CANCELLED_OBS_TRIP

VARCHAR2

NMFS_RELEASE_FROM_COVERAGE

VARCHAR2

LOGGED_BY

VARCHAR2

LOGGED_BY_ACCOUNT_TYPE

VARCHAR2

TELEPHONE_CENTER_LOGGED_FOR

VARCHAR2

LOGGED_FOR_ACCOUNT_TYPE

VARCHAR2

VESSEL_NAME

VARCHAR2

ADFG

NUMBER

AKR_VESSEL_ID

NUMBER

VESSEL_LENGTH

NUMBER

DATE_LOGGED

DATE

NUMBER_OF_TIMES_TRIP_EDITED

NUMBER

LAST_TIME_EDITED

DATE

LAST_EDITED_BY

VARCHAR2

LAST_EDITED_BY_ACCOUNT_TYPE

VARCHAR2

GEAR_TYPE

CHAR

TRIP_STATUS

VARCHAR2

DATE_CANCELED

DATE

DECLARED_LEAVE_DATE

DATE

DECLARED_PORT_OF_DEPARTURE

VARCHAR2

DECLARED_RETURN_DATE

DATE

CLOSED_RETURN_DATE

DATE

DECLARED_PLANT_OFFLOADING_TO

VARCHAR2

DECLARED_PROCESSOR_ID

NUMBER

CLOSED_PLANT_OFFLOADED_TO

VARCHAR2

CLOSED_PROCESSOR_ID

NUMBER

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 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

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

YEAR

ODDS_TRIP_NUMBER

ODDS_SAMPLE_PLAN

ODDS_SAMPLE_PLAN_DESCRIPTION

OBSERVER_STATUS_CODE

OBSERVER_STATUS_DESCRIPTION

VESSEL_CANCELLED_OBS_TRIP

NMFS_RELEASE_FROM_COVERAGE

LOGGED_BY

LOGGED_BY_ACCOUNT_TYPE

TELEPHONE_CENTER_LOGGED_FOR

LOGGED_FOR_ACCOUNT_TYPE

VESSEL_NAME

ADFG

AKR_VESSEL_ID

VESSEL_LENGTH

DATE_LOGGED

NUMBER_OF_TIMES_TRIP_EDITED

LAST_TIME_EDITED

LAST_EDITED_BY

LAST_EDITED_BY_ACCOUNT_TYPE

GEAR_TYPE

TRIP_STATUS

DATE_CANCELED

DECLARED_LEAVE_DATE

DECLARED_PORT_OF_DEPARTURE

DECLARED_RETURN_DATE

CLOSED_RETURN_DATE

DECLARED_PLANT_OFFLOADING_TO

DECLARED_PROCESSOR_ID

CLOSED_PLANT_OFFLOADED_TO

CLOSED_PROCESSOR_ID

CLOSED_LANDING_ID

Catalog Details