Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > Observer Restructure (ODDS) > AFSC/FMA/Observer Declare and Deploy System (OD... >

Table: ODDS_MONITOR

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:18862  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

ODDS system logging - tracking table to record ODDS transactions for trips.

Description

ODDS system logging - tracking table to record ODDS transactions for trips.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
MONITOR_SEQ
NUMBER 		Primary key sequence number
MONITOR_DATE
DATE 		Date entry added to table
TRIP_PLAN_LOG_SEQ
NUMBER 		Trip plan log seq no motitoring
SAMPLE_PLAN_SEQ
NUMBER 		Strata trip is logged for
TRIP_OBSERVER_SEQ
NUMBER 		Trip observer seq
TRIP_STATUS_SEQ
NUMBER 		Trip status
MODULE
VARCHAR2 		Module issuing monitor message
MESSAGE
VARCHAR2 		System message for the transaction
USER_NAME
VARCHAR2 		User adding the entry
CDQ
VARCHAR2 		CDQ trip Y or N
AFA
VARCHAR2 		AFA trip Y or N
ROCKFISH
VARCHAR2 		GOA Rockfish trip Y or N
TRAWL_GEAR
VARCHAR2 		Trawl Gear trip Y or N
INHERIT_OBS
NUMBER 		Trip Number observer inherited from or null if not inherited.
RANDOM_NUMBER_USED
NUMBER 		Random number used to determine if observed trip

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

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

ODDS system logging - tracking table to record ODDS transactions for trips.
Purpose:

ODDS system logging - tracking table to record ODDS transactions for trips.
Notes:

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

Entity Information

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

ODDS system logging - tracking table to record ODDS transactions for trips.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 MONITOR_SEQ NUMBER Primary key sequence number
100
 MONITOR_DATE DATE Date entry added to table
100
 TRIP_PLAN_LOG_SEQ NUMBER Trip plan log seq no motitoring
100
 SAMPLE_PLAN_SEQ NUMBER Strata trip is logged for
100
 TRIP_OBSERVER_SEQ NUMBER Trip observer seq
100
 TRIP_STATUS_SEQ NUMBER Trip status
100
 MODULE VARCHAR2 Module issuing monitor message
100
 MESSAGE VARCHAR2 System message for the transaction
100
 USER_NAME VARCHAR2 User adding the entry
100
 CDQ VARCHAR2 CDQ trip Y or N
100
 AFA VARCHAR2 AFA trip Y or N
100
 ROCKFISH VARCHAR2 GOA Rockfish trip Y or N
100
 TRAWL_GEAR VARCHAR2 Trawl Gear trip Y or N
100
 INHERIT_OBS NUMBER Trip Number observer inherited from or null if not inherited.
100
 RANDOM_NUMBER_USED NUMBER Random number used to determine if observed trip

Attribute Details

MONITOR_SEQ

CC ID: 108050
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Status: Active
Description:

Primary key sequence number
General Data Type: NUMBER

MONITOR_DATE

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

Date entry added to table
General Data Type: DATE

TRIP_PLAN_LOG_SEQ

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

Trip plan log seq no motitoring
General Data Type: NUMBER

SAMPLE_PLAN_SEQ

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

Strata trip is logged for
General Data Type: NUMBER
Foreign Key Relations:

NORPAC.ODDS_LOV_SAMPLE_PLAN

TRIP_OBSERVER_SEQ

CC ID: 108048
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 9
Scale: 0
Status: Active
Description:

Trip observer seq
General Data Type: NUMBER
Foreign Key Relations:

NORPAC.ODDS_LOV_TRIP_OBS_STATU

TRIP_STATUS_SEQ

CC ID: 108049
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 9
Scale: 0
Status: Active
Description:

Trip status
General Data Type: NUMBER
Foreign Key Relations:

NORPAC.ODDS_LOV_TRIP_STATUS

MODULE

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

Module issuing monitor message
General Data Type: VARCHAR2

MESSAGE

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

System message for the transaction
General Data Type: VARCHAR2

USER_NAME

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

User adding the entry
General Data Type: VARCHAR2

CDQ

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

CDQ trip Y or N
General Data Type: VARCHAR2

AFA

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

AFA trip Y or N
General Data Type: VARCHAR2

ROCKFISH

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

GOA Rockfish trip Y or N
General Data Type: VARCHAR2

TRAWL_GEAR

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

Trawl Gear trip Y or N
General Data Type: VARCHAR2

INHERIT_OBS

CC ID: 108055
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

Trip Number observer inherited from or null if not inherited.
General Data Type: NUMBER

RANDOM_NUMBER_USED

CC ID: 108056
Seq. Order: 15
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 4
Status: Active
Description:

Random number used to determine if observed trip
General Data Type: NUMBER

Catalog Details

Catalog Item ID: 18862
GUID: gov.noaa.nmfs.inport:18862
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: 2018-09-20
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2018-09-20
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2019-09-20