5 regional_ce Tables

Attributes

Data Type

Null?

Comment

trip

longinteger

No

Trip identification number for regional purse-seine and CCAMLR BLL trips

vessel_key

longinteger

Mfish id key for vessel

vessel

character(30,1)

Vessel name

start_datetime

time

Trip start date and departure time

end_datetime

time

Trip end date and arrival time in port

cal_year

integer

Calendar year

land_date

date(0)

Trip landing date

port_departure

character(20,1)

Port of departure

port_unload

character(20,1)

Port of unloading

fads

smallint

For Purse-seine, number of fads used

tender

character(1,1)

Purse-seine tender used. Y or N nation_

reg

character(16,1)

Country of registration

reg_no_country

longinteger

Registration number in country of registration

reg_no_region

longinteger

FFA regional registration number

call_sign

character(8,1)

International radio call sign

captain

character(30,1)

Name of vessels captain

company

character(30,1)

Company name

agent

character(30,1)

Name of agent in port

amount_start

integer

Amount of fish onboard at start of the trip

amount_end

integer

Amount of fish onboard after unloading

crew

smallint

Number of crew - KIR forms only

observer1

character(20,1)

Name of observer 1

observer2

character(32,1)

Name of observer 2

version_no

smallint

No

Version number of record

memo

character(12,1)

Memo code that tracks any changes to the record, refer t_memo_codes table

Creator:

dba

Indices:

UNIQUE BTREE trip_indx

ON (trip)

Attributes

Data Type

Null?

Comment

trip

longinteger

No

Trip identification number

version_no

smallint

No

Version number of record

comments

character(80,1)

Any comments for the trip

Creator:

dba

Referential:

Invalid trip verion number (trip, version_no) INSERT t_trip (trip, version_no)

Indices:

NORMAL (2, 15) BTREE trip

ON (trip)

Attributes

Data Type

Null?

Comment

trip

longinteger

No

Trip identification number for regional purse-seine and CCAMLR BLL trips

station_no

integer

No

Identification number for a set - distinct within a trip

grp_no

smallint

Associates each South Pacific Regional Purse-seine station with a fishing permit or licence number stored in t_permits

fish_year

character(7,1)

Fishing year for the period 01 October to 30 September displayed as year/yr e.g. 2004/05.

cal_year

integer

Calendar year

datetime_s

time

Set start date and time, when first part of longline cast from vessel

datetime_e

time

Set end date and time when last part of longline cast from vessel

time_zone

character(12,1)

The time difference ahead or behind Greenwich Mean Time (GMT) (hrs)

activity

smallint

PS effort activity code

duration

decimal(8,4)

Fishing duration (hours)

school_assn

smallint

PS school association code

aerial_search

character(1,1)

PS aerial search Yes/No

well_numbers

character(15,1)

PS well numbers catch put into

target_sp

character(3,1)

Target species

latitude_s

decimal(8,6)

Latitude start in decimal degrees

longitude_s

decimal(9,6)

Longitude start in decimal degrees (in degrees east of Greenwich)

latitude_e

decimal(8,6)

Latitude at end of set in decimal degrees

longitude_e

decimal(9,6)

Longitude at end of set in decimal degrees (in degrees east of Greenwich)

subarea

character(8,1)

CCAMLR area codes

depth_bottom_s

integer

Bottom depth at start of set

depth_bottom_e

integer

Bottom depth at end of set

depth_fishing_s

integer

Fishing depth at start

depth_fishing_e

integer

Fishing depth at end

bottom_to_line

integer

Distance from the bottom to fishing line (m)

set_direction

integer

Direction in which the fishing gear is set (degrees)

set_direction_e

integer

Direction in which the fishing gear is set at end of set (degrees), where provided separately from start direction

longline_type

character(6,1)

Type of longline configuration - CCAMLR code, see Appendix 2

line_type

character(1,1)

Type of material used in main line - CCAMLR code, see Appendix 2

bait_type

character(20,1)

Type of bait used - CCAMLR code

hooks_baited

smallint

Percentage of hooks set with bait

hook_size

character(8,1)

Mean width of the gap of hooks used (mm)

hook_make

character(8,1)

Brand name and type of hooks used - CCAMLR code

hook_spacing

integer

Spacing between hooks on line (cm)

line_length

integer

Length of the main line set (m)

num_hooks

integer

Total number of hooks used for the set

haul_datetime_s

time

Date and time when the first part of the longline is retrieved

haul_datetime_e

time

Date and time when the last part of the longline is retrieved

method

character(3,1)

Fishing method code

fishing_type

character(3,1)

Main activity during each set: Commercial, Research

line_weighting

character(4,1)

Description of the line weighting used - CCAMLR code

affect_code

character(4,1)

Factors influencing fishing strategy - CCAMLR code

form_type

character(3,1)

Form type: Purse-seine = PUR or KIR, CCAMLR = xls

bottom_type

character(120,1)

Description of the bottom type

comments

character(120,1)

Comments as required

version_no

smallint

No

Version number of an event - currently all ver. 1

memo

character(12,1)

Memo codes that document any changes to the record, refer t_memo_codes.

Creator:

dba

Referential:

Invalid trip version number (trip, version_no) INSERT t_trip (trip, version_no)

Indices:

UNIQUE BTREE trip_set_ndx

ON (trip, station_no)

Attributes

Data Type

Null?

Comment

trip

longinteger

No

Trip identification number

station_no

integer

No

Identification number for a set - distinct within a trip

species

character(3,1)

No

Species code identifying the species caught

status

character(1,1)

No

Code to identify the destination or status of the catch

grp_no

smallint

Identifies a fishing permit or licence number stored in t_permits for the catch for South Pacific Regional Purse-seine data set

weight

decimal(10,2)

Weight of the fish caught

number_caught

longinteger

The number of fish caught

av_weight

decimal(5,2)

The average weight of fish in the catch

sp_ccamlr

character(3,1)

Species code as recorded in the CCAMLR data set

version_no

smallint

No

Version number of an event - currently all ver. 1

memo

character(12,1)

Memo codes that document any changes to the record, refer t_memo_codes.

Creator:

dba

Referential:

invalid trip stn ver (trip, station_no, version_no) INSERT t_effort (trip, station_no, version_no)

Indices:

NORMAL (2, 15) BTREE ON (trip)

NORMAL (2, 15) BTREE ON (station_no)

UNIQUE BTREE trip stn spe status

ON (trip, station_no, species, status)

Attributes

Data Type

Null?

Comment

trip

longinteger

No

Trip identification number for regional purse-seine trips

grp_no

longinteger

No

Associates each record in the t_effort table for a South Pacific Regional Purse-seine trip with a fishing permit or licence number stored in this table

permit_no

character(30,1)

The fishing permit or licence number issued to South Pacific Regional Purse-seine vessels

version_no

smallint

No

Version number of an event - currently all ver. 1

memo

character(12,1)

Memo codes that document any changes to the record, refer t_memo_codes.

Creator:

dba

Referential:

Invalid trip version numbers (trip, version_no) INSERT t_trip (trip, version_no)

Indices:

UNIQUE BTREE trip ON (trip, grp_no)

Attributes

Data Type

Null?

Comment

land_key

longinteger

No

Primary key for the identification of landings

trip

longinteger

No

Trip identification number for regional purse-seine trips and CCAMLR BLL trips

date_land_start

date(0)

First day of unloading / transhipping date_land_end date(0) Last day of unloading / transhipping

species

character(3,1)

No

Species code of the species landed state character(3,1) Code for the processed state of fish

green_wt

longinteger

Weight of landed fish as whole weight (kgs)

wt_units

character(2,1)

Landing weight units, only recorded on Purse-seine Kiribati waters form: .mt/st (all weights stored as kgs)

rec_call_sign

character(8,1)

Carrier Radio Call sign

cannery

character(20,1)

Name of Cannery or Carrier fish unloaded to.

fish_destination

character(30,1)

Destination of unloaded fish

dated

date(0)

Date recorded against landing signature

version_no

smallint

No

Version number of an event - currently all ver. 1

memo

character(12,1)

Memo codes that document any changes to the record, refer t_memo_codes.

Creator:

dba

Referential:

Invalid trip version numbers (trip, version_no) INSERT t_trip (trip, version_no)

Indices:

UNIQUE BTREE land key indx ON (land_key)

Attributes

Data Type

Null?

Comment

memo

character(3,1)

No

Memo code used in memo fields description character(40,1) Description for a change made or to tag a record

Creator:

dba

Indices:

UNIQUE BTREE memo indx ON (memo)

Attributes

Data Type

Null?

Comment

status

character(1,1)

No

Code for catch status CCAMLR BLL 1 char and Purse-seine are numeric tuna discard codes

description

character(40,1)

A description for each status code

Creator:

dba

Indices:

UNIQUE BTREE status indx ON (status)