18862
Table: ODDS_MONITOR
ODDS_MONITOR
Entity
Published / External
18871
AFSC/FMA/Observer Declare and Deploy (Resturcture)
Data Set
Completed
ODDS system logging - tracking table to record ODDS transactions for trips.
ODDS system logging - tracking table to record ODDS transactions for trips.
Loaded by batch 4561, 04-30-2013 18:33
Data Table
Yes
NORPAC
ODDS system logging - tracking table to record ODDS transactions for trips.
1
MONITOR_SEQ
NUMBER
22
Yes
No
Active
Primary key sequence number
NUMBER
2
MONITOR_DATE
DATE
7
No
No
Active
Date entry added to table
DATE
3
TRIP_PLAN_LOG_SEQ
NUMBER
22
No
No
9
0
Active
Trip plan log seq no motitoring
NUMBER
4
SAMPLE_PLAN_SEQ
NUMBER
22
No
No
9
0
Active
Strata trip is logged for
NUMBER
NORPAC.ODDS_LOV_SAMPLE_PLAN
5
TRIP_OBSERVER_SEQ
NUMBER
22
No
No
9
0
Active
Trip observer seq
NUMBER
NORPAC.ODDS_LOV_TRIP_OBS_STATU
6
TRIP_STATUS_SEQ
NUMBER
22
No
No
9
0
Active
Trip status
NUMBER
NORPAC.ODDS_LOV_TRIP_STATUS
7
MODULE
VARCHAR2
30
No
No
Active
Module issuing monitor message
VARCHAR2
8
MESSAGE
VARCHAR2
200
No
No
Active
System message for the transaction
VARCHAR2
9
USER_NAME
VARCHAR2
30
No
No
Active
User adding the entry
VARCHAR2
10
CDQ
VARCHAR2
1
No
No
Active
CDQ trip Y or N
VARCHAR2
11
AFA
VARCHAR2
1
No
No
Active
AFA trip Y or N
VARCHAR2
12
ROCKFISH
VARCHAR2
1
No
No
Active
GOA Rockfish trip Y or N
VARCHAR2
13
TRAWL_GEAR
VARCHAR2
1
No
No
Active
Trawl Gear trip Y or N
VARCHAR2
14
INHERIT_OBS
NUMBER
22
No
No
38
0
Active
Trip Number observer inherited from or null if not inherited.
NUMBER
15
RANDOM_NUMBER_USED
NUMBER
22
No
No
6
4
Active
Random number used to determine if observed trip
NUMBER
gov.noaa.nmfs.inport:18862
Doug Turnbull
2013-04-30T18:33:21
SysAdmin InPortAdmin
2022-08-09T17:11:08
2018-09-20
Alaska Fisheries Science Center
AFSC
7600 Sand Point Way N.E., Building 4
Seattle
WA
98115
USA
http://www.afsc.noaa.gov
0700-1700 Pacific Time
1001
Public
No
2018-09-20
1 Year
2019-09-20