18871
AFSC/FMA/Observer Declare and Deploy (Resturcture)
AFSC/FMA/Observer Declare and Deploy
Data Set
Published / External
16688
Observer Restructure (ODDS)
Project
In Work
The new Observer Program restructures and replaces what was originally considered an "interim program," which lasted for 23 years. Broadly speaking, under the interim program, vessels and plants paid for observers by the day at coverage rates specified in law based on days in a calendar quarter at-sea (not fishery as is often assumed) and on tons processed for shoreside processors. Under the interim program, catcher vessels between 60 and 125 ft in overall length were allowed to self-select which trips were to be observed. Because vessels less than 60 ft or those targeting Pacific halibut were not observed, the former static regulatory structure of observer coverage created not only an incentive for owners to change the length of their vessels (indeed a disproportionately high number of 124 ft and 58 ft vessels exist in the fleet), but also created a mechanism for owners, because of self-selected trips, to skew observer coverage towards trips with lower bycatch rates (e.g. pollock) and away from those with higher bycatch rates (e.g. most flatfish fisheries).
New regulations governing how observers are deployed into the fisheries of Alaska became effective on 1 January 2013. Amendment 86 to the Fisheries Management Plan (FMP) of the Bering Sea and Aleutian Islands and Amendment 76 to the FMP of the Gulf of Alaska establish the new North Pacific Groundfish and Halibut Observer Program (Observer Program). The new regulations change how observer coverage is funded and the observer coverage requirements for vessels and processors. These changes will increase the statistical reliability of data collected by the program, address cost inequality among fishery participants, and expand observer coverage to previously unobserved fisheries. These changes are necessary to successfully manage Alaska's billion dollar fisheries industry.
The 2013 Observer Program is the result of the third attempt by the National Marine Fisheries Service (NMFS) to restructure the interim program since 1990. This recent effort began with a 2008 Council problem statement, involved more than 53 individuals from five agencies, and took 5 years to accomplish. The new program places all vessels and processors in the groundfish and halibut fisheries off Alaska into either full or partial coverage categories. No operations are exempt from the new program. Vessels and processors in the full coverage category will continue to obtain observers by contracting directly with observer providers. Vessels and processors in the partial coverage category will obtain observers through NMFS, paying a fee on landings to cover costs.
Theme
electronic monitoring
Theme
goa
Theme
gulf of alaska
Theme
observer
Theme
odds
Theme
restructure
Theme
trip selection
Theme
vessel selection
Temporal
2013
Stratum
partial coverage
Alaska Fisheries Science Center
Seattle
WA
USA
Data Set
Database
As Needed
Table (digital)
Modeled in Oracle Designer
https://sites.google.com/a/noaa.gov/afsc-home/it-services/data-management-and-metadata-1?pli=1
Craig Faunce
N/A
N/A
N/A
18852
View: ODDS_CNT_PLANT_BILLABLE_DAY_V
ODDS_CNT_PLANT_BILLABLE_DAY_V
Published / External
Completed
Loaded by batch 4561, 04-30-2013 18:33
Data View
Yes
NORPAC
1
CRUISE
NUMBER
22
No
No
8
0
Active
NUMBER
2
PERMIT
VARCHAR2
6
No
No
Active
VARCHAR2
3
YEAR
NUMBER
22
No
No
38
Active
NUMBER
4
MONTH
NUMBER
22
No
No
Active
NUMBER
5
AT_PLANT_DATE
DATE
7
No
No
Active
DATE
6
DAY_COUNT
NUMBER
22
No
No
Active
NUMBER
18853
View: ODDS_CNT_TOTAL_DAY_V
ODDS_CNT_TOTAL_DAY_V
Published / External
Completed
Loaded by batch 4561, 04-30-2013 18:33
Data View
Yes
NORPAC
1
CRUISE
NUMBER
22
No
No
8
0
Active
NUMBER
2
PERMIT
VARCHAR2
6
No
No
Active
VARCHAR2
3
BILLABLE_DATE
DATE
7
No
No
Active
DATE
4
DAY_COUNT
NUMBER
22
No
No
Active
NUMBER
18854
View: ODDS_CNT_VESSEL_BILLABLE_DAY_V
ODDS_CNT_VESSEL_BILLABLE_DAY_V
Published / External
Completed
Loaded by batch 4561, 04-30-2013 18:33
Data View
Yes
NORPAC
1
CRUISE
NUMBER
22
Yes
No
8
0
Active
NUMBER
2
PERMIT
VARCHAR2
6
Yes
No
Active
VARCHAR2
3
YEAR
NUMBER
22
No
No
38
Active
NUMBER
4
MONTH
NUMBER
22
No
No
Active
NUMBER
5
VESSEL_LOA
NUMBER
22
No
No
38
0
Active
NUMBER
6
AT_SEA_DAY_DATE
DATE
8
No
No
Active
DATE
7
DAY_COUNT
NUMBER
22
No
No
38
Active
NUMBER
18855
View: ODDS_LOGGED_TRIP_SUMMARY_V
ODDS_LOGGED_TRIP_SUMMARY_V
Published / External
Completed
Loaded by batch 4561, 04-30-2013 18:33
Data View
Yes
NORPAC
1
YEAR
VARCHAR2
4
No
No
Active
VARCHAR2
2
ODDS_TRIP_NUMBER
NUMBER
22
Yes
No
9
0
Active
NUMBER
3
ODDS_SAMPLE_PLAN
NUMBER
22
Yes
No
Active
NUMBER
4
ODDS_SAMPLE_PLAN_DESCRIPTION
VARCHAR2
50
Yes
No
Active
VARCHAR2
5
OBSERVER_STATUS_CODE
VARCHAR2
2
No
No
Active
VARCHAR2
6
OBSERVER_STATUS_DESCRIPTION
VARCHAR2
40
No
No
Active
VARCHAR2
7
VESSEL_CANCELLED_OBS_TRIP
VARCHAR2
3
No
No
Active
VARCHAR2
8
NMFS_RELEASE_FROM_COVERAGE
VARCHAR2
3
No
No
Active
VARCHAR2
9
LOGGED_BY
VARCHAR2
200
Yes
No
Active
VARCHAR2
10
LOGGED_BY_ACCOUNT_TYPE
VARCHAR2
4000
No
No
Active
VARCHAR2
11
TELEPHONE_CENTER_LOGGED_FOR
VARCHAR2
200
No
No
Active
VARCHAR2
12
LOGGED_FOR_ACCOUNT_TYPE
VARCHAR2
4000
No
No
Active
VARCHAR2
13
VESSEL_NAME
VARCHAR2
50
No
No
Active
VARCHAR2
14
ADFG
NUMBER
22
No
No
38
Active
NUMBER
15
AKR_VESSEL_ID
NUMBER
22
No
No
Active
NUMBER
16
VESSEL_LENGTH
NUMBER
22
No
No
38
0
Active
NUMBER
17
DATE_LOGGED
DATE
7
Yes
No
Active
DATE
18
NUMBER_OF_TIMES_TRIP_EDITED
NUMBER
22
No
No
38
0
Active
NUMBER
19
LAST_TIME_EDITED
DATE
7
No
No
Active
DATE
20
LAST_EDITED_BY
VARCHAR2
200
No
No
Active
VARCHAR2
21
LAST_EDITED_BY_ACCOUNT_TYPE
VARCHAR2
4000
No
No
Active
VARCHAR2
22
GEAR_TYPE
CHAR
5
No
No
Active
CHAR
23
TRIP_STATUS
VARCHAR2
40
No
No
Active
VARCHAR2
24
DATE_CANCELED
DATE
7
No
No
Active
DATE
25
DECLARED_LEAVE_DATE
DATE
7
Yes
No
Active
DATE
26
DECLARED_PORT_OF_DEPARTURE
VARCHAR2
50
No
No
Active
VARCHAR2
27
DECLARED_RETURN_DATE
DATE
7
No
No
Active
DATE
28
CLOSED_RETURN_DATE
DATE
7
No
No
Active
DATE
29
DECLARED_PLANT_OFFLOADING_TO
VARCHAR2
50
Yes
No
Active
VARCHAR2
30
DECLARED_PROCESSOR_ID
NUMBER
22
No
No
38
Active
NUMBER
31
CLOSED_PLANT_OFFLOADED_TO
VARCHAR2
50
No
No
Active
VARCHAR2
32
CLOSED_PROCESSOR_ID
NUMBER
22
No
No
38
Active
NUMBER
33
CLOSED_LANDING_ID
NUMBER
22
No
No
10
0
Active
NUMBER
18857
Table: ODDS_LOV_SAMPLE_PLAN
ODDS_LOV_SAMPLE_PLAN
Published / External
Completed
Loaded by batch 4561, 04-30-2013 18:33
Data Table
Yes
NORPAC
List of values for sample plan types.
1
SAMPLE_PLAN_SEQ
NUMBER
22
Yes
Yes
9
0
Active
unique key that defines observer pool a vessel belongs to
NUMBER
2
DESCRIPTION
VARCHAR2
50
Yes
No
Active
describes the vessel observer pool
VARCHAR2
18858
Table: ODDS_LOV_TRIP_OBS_STATUS
ODDS_LOV_TRIP_OBS_STATUS
Published / External
Completed
Loaded by batch 4561, 04-30-2013 18:33
Data Table
Yes
NORPAC
List of values for a trip's observer status
1
TRIP_OBSERVER_SEQ
NUMBER
22
Yes
Yes
9
0
Active
unique key for status of the observer coverage to a logged trip.
NUMBER
2
TRIP_OBS_CODE
VARCHAR2
2
No
No
Active
Code describing observer coverage for a logged trip
VARCHAR2
3
DESCRIPTION
VARCHAR2
40
No
No
Active
Describes the observer status for a logged trip
VARCHAR2
18859
Table: ODDS_LOV_TRIP_STATUS
ODDS_LOV_TRIP_STATUS
Published / External
Completed
An observer declare and deploy fishing trip may be in one of several states e.g. Pending, or Completed. This entity represents the list of valid states at a point of time.
Loaded by batch 4561, 04-30-2013 18:33
Data Table
Yes
NORPAC
An observer declare and deploy fishing trip may be in one of several states e.g. Pending, or Completed. This entity represents the list of valid states at a point of time.
1
TRIP_STATUS_SEQ
NUMBER
22
Yes
Yes
9
0
Active
Unique identifier of an odds_lov_trip_status record.
NUMBER
2
TRIP_STATUS_CODE
VARCHAR2
2
Yes
No
Active
Unique trip log status code
VARCHAR2
3
DESCRIPTION
VARCHAR2
40
No
No
Active
description of trip log status code
VARCHAR2
18860
View: ODDS_LOV_USER_TYPE_V
ODDS_LOV_USER_TYPE_V
Published / External
Completed
Loaded by batch 4561, 04-30-2013 18:33
Data View
Yes
NORPAC
1
TYPE_LEVEL
NUMBER
22
No
No
Active
NUMBER
2
LOV_USER_TYPE_SEQ
NUMBER
22
Yes
No
38
Active
NUMBER
3
SHOW_HIERARCHY
VARCHAR2
4000
No
No
Active
VARCHAR2
4
USER_TYPE_CODE
VARCHAR2
30
Yes
No
Active
VARCHAR2
5
USER_TYPE_DESC
VARCHAR2
4000
No
No
Active
VARCHAR2
6
APP_CODE
VARCHAR2
15
Yes
No
Active
VARCHAR2
7
LSLEAF
NUMBER
22
No
No
Active
NUMBER
18861
Table: ODDS_LOV_WAIVER_STATUS
ODDS_LOV_WAIVER_STATUS
Published / External
Completed
If an observer provider is unable to supply an observer for a fishing trip which has been declared observed. A waiver to the observed trip may be requested. Acceptance or rejection of the waiver request is executed by NMFS staff. This entity represents the list of valid values for the status of the requested waiver.
Loaded by batch 4561, 04-30-2013 18:33
Data Table
Yes
NORPAC
If an observer provider is unable to supply an observer for a fishing trip which has been declared observed. A waiver to the observed trip may be requested. Acceptance or rejection of the waiver request is executed by NMFS staff. This entity represents the list of valid values for the status of the requested waiver.
1
WAIVER_STATUS_SEQ
NUMBER
22
Yes
Yes
9
0
Active
Sequence generated unique identifier for a waiver status record.
NUMBER
2
WAIVER_STATUS_CODE
VARCHAR2
2
Yes
No
Active
Unique Alpha code representing the status of an observer waiver request.
VARCHAR2
3
DESCRIPTION
VARCHAR2
30
No
No
Active
Descriptive text of the meaning of an observer waiver status code.
VARCHAR2
18862
Table: ODDS_MONITOR
ODDS_MONITOR
Published / External
Completed
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
18863
Table: ODDS_PCT_TRIP_SELECT
ODDS_PCT_TRIP_SELECT
Published / External
Completed
The observer declare and deploy system is intended to provide the maximum observer coverage within the financial constraints inherent in its funding stream. From time to time it may be necessary to adjust the level of coverage for future declared fishing trips. This entity records the threshhold value for evaluating a random number, and the date-time at which the level of coverage becomes effective.
Loaded by batch 4561, 04-30-2013 18:33
Data Table
Yes
NORPAC
The observer declare and deploy system is intended to provide the maximum observer coverage within the financial constraints inherent in its funding stream. From time to time it may be necessary to adjust the level of coverage for future declared fishing trips. This entity records the threshhold value for evaluating a random number, and the date-time at which the level of coverage becomes effective.
1
PCT_SELECT_SEQ
NUMBER
22
Yes
Yes
9
0
Active
Unique sequence number for primary key
NUMBER
2
PERCENT
NUMBER
22
Yes
No
5
2
Active
Percentage of trips to be selected for observed trips
NUMBER
3
EFFECTIVE_DATE
DATE
7
Yes
No
Active
Date the percent is effective for
DATE
18864
View: ODDS_REGISTERED_USER_V
ODDS_REGISTERED_USER_V
Published / External
Completed
Loaded by batch 4561, 04-30-2013 18:33
Data View
Yes
NORPAC
1
USER_SEQ
NUMBER
22
Yes
No
Active
NUMBER
2
USER_TYPE
VARCHAR2
30
Yes
No
Active
VARCHAR2
3
ACTIVE_USER
VARCHAR2
1
No
No
Active
VARCHAR2
4
ODDS_USER_ID
VARCHAR2
200
Yes
No
Active
VARCHAR2
5
FIRST_NAME
VARCHAR2
50
Yes
No
Active
VARCHAR2
6
MIDDLE_INITIAL
VARCHAR2
50
No
No
Active
VARCHAR2
7
LAST_NAME
VARCHAR2
50
Yes
No
Active
VARCHAR2
8
SALTED
VARCHAR2
256
No
No
Active
VARCHAR2
9
EMPLOYER_CODE
VARCHAR2
10
No
No
Active
VARCHAR2
10
LAST_LOGIN_DATE
TIMESTAMP(4)
11
No
No
4
Active
TIMESTAMP(4)
11
PARENT_USER_SEQ
NUMBER
22
No
No
Active
NUMBER
12
IS_PW_TEMPORARY
VARCHAR2
1
No
No
Active
VARCHAR2
13
PRIMARY_EMAIL
VARCHAR2
100
No
No
Active
VARCHAR2
14
PRIMARY_PHONE
VARCHAR2
30
No
No
Active
VARCHAR2
15
APP_CODE
VARCHAR2
15
Yes
No
Active
VARCHAR2
16
APP_SEQ
NUMBER
22
Yes
No
38
Active
NUMBER
17
APP_NAME
VARCHAR2
100
Yes
No
Active
VARCHAR2
18
LOV_USER_TYPE_SEQ
NUMBER
22
Yes
No
38
Active
NUMBER
19
USER_LAST_EDITED_ON_DATE
TIMESTAMP(4)
11
Yes
No
4
Active
TIMESTAMP(4)
20
PASSWORD_CHANGED_TIMESTAMP
TIMESTAMP(4) WITH LOCAL TIME Z
11
No
No
4
Active
TIMESTAMP(4) WITH LOCAL TIME Z
21
USER_X_USERTYPE_SEQ
NUMBER
22
Yes
No
Active
NUMBER
22
VESSEL_CONTACT_SEQ
NUMBER
22
No
No
38
Active
NUMBER
18865
Table: ODDS_STRATA_INPT
ODDS_STRATA_INPT
Published / External
Completed
This table created as a record of the inputs referenced to create ODDS_VESSEL_SAMPLE_PLAN, ODDS_USER_VESSEL, and CAMS_USER entries depending on the year, quarter, vessel sample plan, and contact.
Loaded by batch 4561, 04-30-2013 18:33
Data Table
Yes
NORPAC
This table created as a record of the inputs referenced to create ODDS_VESSEL_SAMPLE_PLAN, ODDS_USER_VESSEL, and CAMS_USER entries depending on the year, quarter, vessel sample plan, and contact.
1
INPT_STRATA_SEQ
NUMBER
22
Yes
Yes
Active
primary key sequence number
NUMBER
2
FISHING_YEAR
NUMBER
22
Yes
No
38
Active
Fishing year input applies to
NUMBER
3
SAMPLE_PLAN_SEQ
NUMBER
22
Yes
No
Active
sample plan seq( strata) for the input vessel
NUMBER
NORPAC.ODDS_LOV_SAMPLE_PLAN
4
AKR_VESSEL_ID
NUMBER
22
Yes
No
38
Active
AK region vessel id
NUMBER
5
INPT_STATUS
VARCHAR2
500
No
No
Active
Text generated by the ODDS application, describing the action which triggered the creation of a vessel strata input record.
VARCHAR2
6
FISHING_QUARTER
NUMBER
22
No
No
38
Active
Fishing quarter , used for vessel selection sample plan seq = 1 (not observed) or 2(observed)
NUMBER
7
OWNER_USER_ID
VARCHAR2
200
No
No
Active
User id added to cams for vessel owner
VARCHAR2
8
TEMP_OWNER_PASSWORD
VARCHAR2
256
No
No
Active
Temporary password added for owner. User changes on first use.
VARCHAR2
18866
Table: ODDS_TRIP_PLAN_LOG
ODDS_TRIP_PLAN_LOG
Published / External
Completed
VESSEL PLANT SEQ for deployment of assigned observer.
Loaded by batch 4561, 04-30-2013 18:33
Data Table
Yes
NORPAC
VESSEL PLANT SEQ for deployment of assigned observer.
1
TRIP_PLAN_LOG_SEQ
NUMBER
22
Yes
Yes
9
0
Active
Unique trip log sequence number
NUMBER
2
TRIP_STATUS_SEQ
NUMBER
22
No
No
9
0
Active
This column is the unique FK identifier for an odds_lov_trip_status record. From which trip_status_code is denormalized for the convenience of the APEX GUI.
NUMBER
NORPAC.ODDS_LOV_TRIP_STATUS
3
TRIP_STATUS_CODE
VARCHAR2
2
Yes
No
Active
The trip status completed, cancelled , pending. The value of this attribute is denormalized from odds_lov_trip_status for the convenience of the APEX application.
VARCHAR2
4
TRIP_OBSERVER_SEQ
NUMBER
22
Yes
No
38
0
Active
This fk is the unique key for status of observer coverage for a logged trip.
NUMBER
NORPAC.ODDS_LOV_TRIP_OBS_STATU
5
TRIP_OBS_CODE
VARCHAR2
2
Yes
No
Active
Code describing observer coverage for a logged trip. This code is denormalized from odds_lov_trip_obs_status for the convenience of the user application.
VARCHAR2
6
INHERIT_OBS_TRIP_SEQ
NUMBER
22
No
No
38
0
Active
If a trip is cancelled for any reason within the odds system, this trip number a subsequent trip inherits the properties of the recursive parent.
NUMBER
NORPAC.ODDS_TRIP_PLAN_LOG
7
VESSEL_PLANT_SEQ
NUMBER
22
No
No
9
0
Active
This attribute represents cruise number and vessel from the logistics system of an observer assigned to trip if applicable. It is the FK to ols_vessel_plant, is populated by the application when an observer is assgned by an employer, and provides the connection to employer and to a specific contract for a fishery observer.
NUMBER
NORPAC.OLS_VESSEL_PLANT
8
DATE_LOGGED
DATE
7
Yes
No
Active
date trip was added to system
DATE
9
LOGGED_BY
NUMBER
22
Yes
No
38
0
Active
User who entered t the trip log record - this may be done by NMFS Staff or the Vessel representative. If done by the vessel, the 72 hour rules applies for the observer provider and the column value is validated against the odds_user_vessel table
NUMBER
10
PLANNED_EMBARK_DATE
DATE
7
Yes
No
Active
Date that a vessel representative declares as the planned date of embarkation of a fishing trip.
DATE
11
ORIGINAL_EMBARK_DATE
DATE
7
No
No
Active
date - time of embark date when originally entered into system. allows trip delay check.
DATE
12
PLANNED_EMBARK_PORT
NUMBER
22
Yes
No
9
0
Active
Port the vessel leaves from - fk from atl_lov_port.
NUMBER
NORPAC.ATL_LOV_PORT_CODE
13
PLANNED_DISEMBARK_DATE
DATE
7
No
No
Active
date - time vessel declares as its intent to return from a trip. Close out trip
DATE
14
DISEMBARK_DATE
DATE
7
No
No
Active
Date vessel returned from trip
DATE
15
DISEMBARK_PLANT
NUMBER
22
No
No
9
0
Active
Declared port and processor at which a trip is intended to terminate. This fk is from atl_lov_plant.
NUMBER
NORPAC.ATL_LOV_PLANT
16
PLANNED_DISEMBARK_PLANT
NUMBER
22
No
No
9
0
Active
Stated intention of plant and port trip terminus. Entered when logging a trip.
NUMBER
17
CANCEL_DATE_TIME
DATE
7
No
No
Active
It is permitted to cancel a declared trip prior to fortyeight hours after the declard embark date. This attribute records the timstamp of that action.
DATE
18
TRIP_SELECTED_OBS
VARCHAR2
1
No
No
Active
indicates final outcome if the planned trip is observed or not observed
VARCHAR2
19
AMENDED_COUNT
NUMBER
22
No
No
9
0
Active
Number of times a log record was amended
NUMBER
20
AMENDED_BY
NUMBER
22
No
No
9
0
Active
User who last amended the trip log - this may be done by NMFS Staff or the Vessel representative. If done by the vessel, the 72 hour rules applies for the observer provider and the column value is validated against the odds_user_vessel tabl
NUMBER
21
AMENDED_DATE
DATE
7
No
No
Active
Date user last amended the log record
DATE
22
LANDING_REPORT_ID
NUMBER
22
No
No
38
0
Active
The region uses the landing report id off the electronic fish ticket as a join column for the catch accounting system. The value is printed on the lower quadrant of every ER fish ticket. Landing_Report_ID is unique to an offload.
NUMBER
23
CDQ_FLAG
VARCHAR2
1
Yes
No
Active
indicated if trip is cdq or not
VARCHAR2
24
AFA_TRIP_FLAG
VARCHAR2
1
No
No
Active
inidcates answer for AFA filter question. Should only be N or null. Null for non AFA vessels
VARCHAR2
25
ROCKFISH_TRIP_FLAG
VARCHAR2
1
No
No
Active
inicates answer for rockfish filter question for participating vessels. Should be N or null .
VARCHAR2
26
TRAWL_GEAR_TRIP_FLAG
VARCHAR2
1
No
No
Active
indicates answer for trawl gear filter question. Trawl gear CDQ trips are not logged.
VARCHAR2
27
VESSEL_SEQ
NUMBER
22
No
No
9
0
Active
Sequence for the vessel the trip plan is for
NUMBER
NORPAC.ATL_LOV_VESSEL
28
LOGGED_FOR
NUMBER
22
No
No
9
0
Active
User trip was logged for when logged by the call center
NUMBER
29
TRIP_PLAN_NUMBER
VARCHAR2
10
No
No
Active
If an ODDS trip is recorded manually by the call center. Then a preprinted form is used - that form is prepopulated with a unique alphanumeric identifier composed of AB+an integer. The manual form is provided to allow an ODDS trip to be recorded when the ODDS system is not available.
VARCHAR2
30
SAMPLE_PLAN_SEQ
NUMBER
22
Yes
No
38
Active
Sample plan seq identifing the strata the trip belongs to
NUMBER
18867
Table: ODDS_TRIP_WAIVER
ODDS_TRIP_WAIVER
Published / External
Completed
Loaded by batch 4561, 04-30-2013 18:33
Data Table
Yes
NORPAC
Information on the request for an observed trip waiver by the observer provider and if it was approved
1
TRIP_WAIVER_SEQ
NUMBER
22
Yes
Yes
9
0
Active
unique sequence for a trip log waiver
NUMBER
2
TRIP_PLAN_LOG_SEQ
NUMBER
22
Yes
No
9
0
Active
parent trip log seq number
NUMBER
NORPAC.ODDS_TRIP_PLAN_LOG
3
WAIVER_STATUS_SEQ
NUMBER
22
No
No
9
0
Active
FK link to odds_lov_waiver_status
NUMBER
NORPAC.ODDS_LOV_WAIVER_STATUS
4
WAIVER_REQUEST_DATE_TIME
DATE
7
Yes
No
Active
Date - time user requested a waiver for an observed trip
DATE
5
WAIVER_REQUEST_BY
NUMBER
22
Yes
No
38
0
Active
User making the waiver request
NUMBER
6
REQUEST_COMMENT
CLOB
4000
No
No
Active
Waiver request comment
CLOB
7
ACCEPT_DENY_DATE
DATE
7
No
No
Active
Date - time waiver was accepted or denied.
DATE
8
ACCEPT_DENY_BY
NUMBER
22
No
No
9
0
Active
user accepting or denying the waiver
NUMBER
9
WAIVER_RESPONSE_COMMENT
CLOB
4000
No
No
Active
Comments concerning the response to waiver request.
CLOB
18868
Table: ODDS_USER_VESSEL
ODDS_USER_VESSEL
Published / External
Completed
This entity represents the intersection of a registered user, particularly vessel owners or captains to a fishing vessel which is participating in the program. This table functions as a reference for the application for those instances where trips are logged or edited by vessel owners or captains. Trigger code on the odds trip plan log identifies the user by type and when appropriate validates its existance here. NMFS staff and Enforcement (Call Center) staff are of a different user type and validated directly to the ODDS_Registered_User_V.
Loaded by batch 4561, 04-30-2013 18:33
Data Table
Yes
NORPAC
This entity represents the intersection of a registered user, particularly vessel owners or captains to a fishing vessel which is participating in the program. This table functions as a reference for the application for those instances where trips are logged or edited by vessel owners or captains. Trigger code on the odds trip plan log identifies the user by type and when appropriate validates its existance here. NMFS staff and Enforcement (Call Center) staff are of a different user type and validated directly to the ODDS_Registered_User_V.
1
ODDS_USER_VESSEL_SEQ
NUMBER
22
Yes
Yes
9
0
Active
primary key sequence
NUMBER
2
VESSEL_SEQ
NUMBER
22
Yes
No
9
0
Active
vessel seq in ATL_LOV_VESSEL
NUMBER
3
USER_SEQ
NUMBER
22
Yes
No
9
0
Active
user sequence that belongs with vessel
NUMBER
CUST_AUTH.CAM_USERS
18869
View: ODDS_VESSEL_IMP_COMPARE_V
ODDS_VESSEL_IMP_COMPARE_V
Published / External
Completed
Loaded by batch 4561, 04-30-2013 18:33
Data View
Yes
NORPAC
Vessel identification Import comparison
1
AKR_VESSEL_ID
NUMBER
22
No
No
Active
AK region vessel id
NUMBER
2
VESSEL_SEQ_SRC
NUMBER
22
No
No
38
Active
Source of vessel_seq, Sequence Generated unique identifier of an Atlas vessel record. The lov vessel table combines the vessplant and catcher boat code tables.
NUMBER
3
USER_SEQ_SRC
NUMBER
22
No
No
Active
Source of USER_SEQ, Login user sequence number from CUST_AUTH.CAM_USERS table.
NUMBER
4
SAMPLE_PLAN_SEQ_SRC
NUMBER
22
No
No
38
Active
Source of SAMPLE_PLAN_SEQ, Sequence number of the strata in which is the vessel.
NUMBER
5
VESSEL_SEQ_DB
NUMBER
22
No
No
Active
Database of vessel_seq, Sequence Generated unique identifier of an Atlas vessel record. The lov vessel table combines the vessplant and catcher boat code tables.
NUMBER
6
USER_SEQ_DB
NUMBER
22
No
No
38
Active
Database of USER_SEQ, Login user sequence number from CUST_AUTH.CAM_USERS table.
NUMBER
7
SAMPLE_PLAN_SEQ_DB
NUMBER
22
No
No
Active
Database of SAMPLE_PLAN_SEQ, Sequence number of the strata in which is the vessel.
NUMBER
18870
Table: ODDS_VESSEL_SAMPLE_PLAN
ODDS_VESSEL_SAMPLE_PLAN
Published / External
Completed
This tracks the strata a vessel is in for a given time period
Loaded by batch 4561, 04-30-2013 18:33
Data Table
Yes
NORPAC
This tracks the strata a vessel is in for a given time period
This tracks the strata a vessel is in for a given time period
1
VESSEL_SAMPLE_PLAN_SEQ
NUMBER
22
Yes
Yes
9
0
Active
PK sequence number
NUMBER
2
VESSEL_SEQ
NUMBER
22
Yes
No
9
0
Active
Sequence number of the vessel to which this strata applies.
NUMBER
NORPAC.ATL_LOV_VESSEL
3
SAMPLE_PLAN_SEQ
NUMBER
22
Yes
No
9
0
Active
Sequence number of the strata in which is the vessel.
NUMBER
NORPAC.ODDS_LOV_SAMPLE_PLAN
4
BEGIN_DATE
DATE
7
No
No
Active
Effective start date vessel is in strata
DATE
5
END_DATE
DATE
7
No
No
Active
Effective end date the vessel is in the strata
DATE
6
OBSERVER_TYPE_SEQ
NUMBER
22
No
No
9
0
Active
Observer type for vessel strata. Not used at this time.
NUMBER
NORPAC.ODDS_LOV_OBSERVER_TYPE
Data Steward
2013
Person
Blair, Julie A
julie.blair@noaa.gov
7600 Sandpoint Way NE
Seattle
WA
98115
USA
206 526 4053
(206)526-4066
0700-1630
Email
Distributor
2013
Person
Narita, Renold E
ren.narita@noaa.gov
Metadata Contact
2013
Person
Blair, Julie A
julie.blair@noaa.gov
7600 Sandpoint Way NE
Seattle
WA
98115
USA
206 526 4053
(206)526-4066
0700-1630
Point of Contact
2013
Person
Faunce, Craig
craig.faunce@noaa.gov
Email
-160
-130
60
50
Continuing
2013-01-01
This data set in an ongoing program
Confidential
Confidential under Magnusson Stevens.
Made available to OLE, NMFS Staff with valid confidentiality agreements
Made available to OLE, NMFS Staff with valid confidentiality agreements, requests must be made through Ren Narita.
Confidential data may not be published in raw form
Confidential data may only be used for approved research.
None
None
Oracle 11g database, APEX GUI
Trip log data is entered by authorized fishers with a user account and password.
The trip logging is validated against delivery reports
Unknown
100%
Daily review by inseason staff.
Yes
Unknown
No
Yes
N/A
N/A
N/A
No Archiving Intended
N/A
RAID 1 Drives, Tape backup, Complete data histories maintained
Trips are logged by authorized fishers. A random number is generated which is compared to the desired coverage rate and applied to determine observer coverage
35601
Entity
ODDS_ANNUAL_OPT_STRATA
18856
Entity
Table: ODDS_LOV_OBSERVER_TYPE
18857
Entity
Table: ODDS_LOV_SAMPLE_PLAN
18858
Entity
Table: ODDS_LOV_TRIP_OBS_STATUS
18859
Entity
Table: ODDS_LOV_TRIP_STATUS
18861
Entity
Table: ODDS_LOV_WAIVER_STATUS
18862
Entity
Table: ODDS_MONITOR
18863
Entity
Table: ODDS_PCT_TRIP_SELECT
18865
Entity
Table: ODDS_STRATA_INPT
18866
Entity
Table: ODDS_TRIP_PLAN_LOG
18867
Entity
Table: ODDS_TRIP_WAIVER
18868
Entity
Table: ODDS_USER_VESSEL
18870
Entity
Table: ODDS_VESSEL_SAMPLE_PLAN
18852
Entity
View: ODDS_CNT_PLANT_BILLABLE_DAY_V
18853
Entity
View: ODDS_CNT_TOTAL_DAY_V
18854
Entity
View: ODDS_CNT_VESSEL_BILLABLE_DAY_V
18855
Entity
View: ODDS_LOGGED_TRIP_SUMMARY_V
18860
Entity
View: ODDS_LOV_USER_TYPE_V
18864
Entity
View: ODDS_REGISTERED_USER_V
18869
Entity
View: ODDS_VESSEL_IMP_COMPARE_V
gov.noaa.nmfs.inport:18871
Doug Turnbull
2013-04-30T18:37:35
SysAdmin InPortAdmin
2022-08-09T17:11:08
2016-05-18
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
2016-05-18
1 Year
2017-05-18