Slide Menu
Search Help Show/Hide Menu

Item Identification

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

VESSEL PLANT SEQ for deployment of assigned observer.

Notes:

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

Entity Information

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

VESSEL PLANT SEQ for deployment of assigned observer.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key TRIP_PLAN_LOG_SEQ NUMBER Unique trip log sequence number
100
TRIP_STATUS_SEQ NUMBER 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.
100
TRIP_STATUS_CODE VARCHAR2 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.
100
TRIP_OBSERVER_SEQ NUMBER This fk is the unique key for status of observer coverage for a logged trip.
100
TRIP_OBS_CODE VARCHAR2 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.
100
INHERIT_OBS_TRIP_SEQ NUMBER 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.
100
VESSEL_PLANT_SEQ NUMBER 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.
100
DATE_LOGGED DATE date trip was added to system
100
LOGGED_BY NUMBER 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
100
PLANNED_EMBARK_DATE DATE Date that a vessel representative declares as the planned date of embarkation of a fishing trip.
100
ORIGINAL_EMBARK_DATE DATE date - time of embark date when originally entered into system. allows trip delay check.
100
PLANNED_EMBARK_PORT NUMBER Port the vessel leaves from - fk from atl_lov_port.
100
PLANNED_DISEMBARK_DATE DATE date - time vessel declares as its intent to return from a trip. Close out trip
100
DISEMBARK_DATE DATE Date vessel returned from trip
100
DISEMBARK_PLANT NUMBER Declared port and processor at which a trip is intended to terminate. This fk is from atl_lov_plant.
100
PLANNED_DISEMBARK_PLANT NUMBER Stated intention of plant and port trip terminus. Entered when logging a trip.
100
CANCEL_DATE_TIME DATE 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.
100
TRIP_SELECTED_OBS VARCHAR2 indicates final outcome if the planned trip is observed or not observed
100
AMENDED_COUNT NUMBER Number of times a log record was amended
100
AMENDED_BY NUMBER 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
100
AMENDED_DATE DATE Date user last amended the log record
100
LANDING_REPORT_ID NUMBER 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.
100
CDQ_FLAG VARCHAR2 indicated if trip is cdq or not
100
AFA_TRIP_FLAG VARCHAR2 inidcates answer for AFA filter question. Should only be N or null. Null for non AFA vessels
100
ROCKFISH_TRIP_FLAG VARCHAR2 inicates answer for rockfish filter question for participating vessels. Should be N or null .
100
TRAWL_GEAR_TRIP_FLAG VARCHAR2 indicates answer for trawl gear filter question. Trawl gear CDQ trips are not logged.
100
VESSEL_SEQ NUMBER Sequence for the vessel the trip plan is for
100
LOGGED_FOR NUMBER User trip was logged for when logged by the call center
100
TRIP_PLAN_NUMBER VARCHAR2 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.
100
SAMPLE_PLAN_SEQ NUMBER Sample plan seq identifing the strata the trip belongs to

Attribute Details

TRIP_PLAN_LOG_SEQ

CC ID: 108102
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 9
Scale: 0
Status: Active
Description:

Unique trip log sequence number

General Data Type: NUMBER

TRIP_STATUS_SEQ

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

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.

General Data Type: NUMBER
Foreign Key Relations:

NORPAC.ODDS_LOV_TRIP_STATUS

TRIP_STATUS_CODE

CC ID: 108120
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 2
Required: Yes
Primary Key: No
Status: Active
Description:

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.

General Data Type: VARCHAR2

TRIP_OBSERVER_SEQ

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

This fk is the unique key for status of observer coverage for a logged trip.

General Data Type: NUMBER
Foreign Key Relations:

NORPAC.ODDS_LOV_TRIP_OBS_STATU

TRIP_OBS_CODE

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

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.

General Data Type: VARCHAR2

INHERIT_OBS_TRIP_SEQ

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

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.

General Data Type: NUMBER
Foreign Key Relations:

NORPAC.ODDS_TRIP_PLAN_LOG

VESSEL_PLANT_SEQ

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

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.

General Data Type: NUMBER
Foreign Key Relations:

NORPAC.OLS_VESSEL_PLANT

DATE_LOGGED

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

date trip was added to system

General Data Type: DATE

LOGGED_BY

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

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

General Data Type: NUMBER

PLANNED_EMBARK_DATE

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

Date that a vessel representative declares as the planned date of embarkation of a fishing trip.

General Data Type: DATE

ORIGINAL_EMBARK_DATE

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

date - time of embark date when originally entered into system. allows trip delay check.

General Data Type: DATE

PLANNED_EMBARK_PORT

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

Port the vessel leaves from - fk from atl_lov_port.

General Data Type: NUMBER
Foreign Key Relations:

NORPAC.ATL_LOV_PORT_CODE

PLANNED_DISEMBARK_DATE

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

date - time vessel declares as its intent to return from a trip. Close out trip

General Data Type: DATE

DISEMBARK_DATE

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

Date vessel returned from trip

General Data Type: DATE

DISEMBARK_PLANT

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

Declared port and processor at which a trip is intended to terminate. This fk is from atl_lov_plant.

General Data Type: NUMBER
Foreign Key Relations:

NORPAC.ATL_LOV_PLANT

PLANNED_DISEMBARK_PLANT

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

Stated intention of plant and port trip terminus. Entered when logging a trip.

General Data Type: NUMBER

CANCEL_DATE_TIME

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

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.

General Data Type: DATE

TRIP_SELECTED_OBS

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

indicates final outcome if the planned trip is observed or not observed

General Data Type: VARCHAR2

AMENDED_COUNT

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

Number of times a log record was amended

General Data Type: NUMBER

AMENDED_BY

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

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

General Data Type: NUMBER

AMENDED_DATE

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

Date user last amended the log record

General Data Type: DATE

LANDING_REPORT_ID

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

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.

General Data Type: NUMBER

CDQ_FLAG

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

indicated if trip is cdq or not

General Data Type: VARCHAR2

AFA_TRIP_FLAG

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

inidcates answer for AFA filter question. Should only be N or null. Null for non AFA vessels

General Data Type: VARCHAR2

ROCKFISH_TRIP_FLAG

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

inicates answer for rockfish filter question for participating vessels. Should be N or null .

General Data Type: VARCHAR2

TRAWL_GEAR_TRIP_FLAG

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

indicates answer for trawl gear filter question. Trawl gear CDQ trips are not logged.

General Data Type: VARCHAR2

VESSEL_SEQ

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

Sequence for the vessel the trip plan is for

General Data Type: NUMBER
Foreign Key Relations:

NORPAC.ATL_LOV_VESSEL

LOGGED_FOR

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

User trip was logged for when logged by the call center

General Data Type: NUMBER

TRIP_PLAN_NUMBER

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

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.

General Data Type: VARCHAR2

SAMPLE_PLAN_SEQ

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

Sample plan seq identifing the strata the trip belongs to

General Data Type: NUMBER

Catalog Details

Catalog Item ID: 18866
GUID: gov.noaa.nmfs.inport:18866
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