Historical Trip Interview Program (TIP) Data Moved into TIPonline

This document explains the transformation that were applied to the old Trip Interview Program (TIP) data to bring it into the new TIPONLINE format.

This is best viewed in Internet Explorer.

If your display is set at 1024 x 768 pixels, you can still see the entire screen if you set the text size to the smallest size possible. Another alternative is to set your desktop to 1280 x 1024 pixels, and medium text size.

A gray line separates fields.

Each field has at least one line for the information in the old system followed by the information in the new system and then a comment on the transformation.

If the field is a coded item, the code tables will have the old values on one line and the new value on the next line.

When either the code or the description of the code changed from the old system to the new system, that change will be highlighted in yellow and bolded.


TABLE OF CONTENTS

SEFSC.TIP_TIP11 FILLS TIPONLINE.INTERVIEW

COLUMN ORDER TRANSFORMATION OLD: OWNER TABLE COLUMN NAME MANDATORY? TYPE
COLUMN ORDER TRANSFORMATION NEW: OWNER TABLE COLUMN NAME MANDATORY? TYPE
1 OLD_FIELD_DROPPED SEFSC TIP_TIP11 RECORD_TYPE MANDATORY VARCHAR2(2)
- OLD_FIELD_DROPPED - - - - -
- OLD_FIELD_DROPPED The field is no longer needed and was dropped.
 
2 NAME_CHANGE SEFSC TIP_TIP11 SEQUENCE_NUMBER MANDATORY VARCHAR2(10)
1 NAME_CHANGE TIPONLINE INTERVIEW OLD_SEQUENCE_NUMBER OPTIONAL VARCHAR2(10)
1 NAME_CHANGE Name change. The field is not shown on the form.
 
3 OLD_FIELD_DROPPED SEFSC TIP_TIP11 PC_SEQUENCE_NUMBER OPTIONAL VARCHAR2(11)
- OLD_FIELD_DROPPED - - - - -
- OLD_FIELD_DROPPED The field is no longer needed and was dropped.
 
4 NAME_CHANGE SEFSC TIP_TIP11 TRIP_TYPE OPTIONAL VARCHAR2(3)
45 NAME_CHANGE TIPONLINE INTERVIEW TRIP_TYPE_ID OPTIONAL NUMBER
45 NAME_CHANGE Not shown on the form. It was carried for historical data and must match id in table TIPONLINE.TRIP_TYPE, shown below.
45 NAME_CHANGE
Old? Code Description
OLD    
NEW 0 UNKNOWN TRIP TYPE
 
OLD 030 LONG HAUL SEINES
NEW 30 LONG HAUL SEINES
 
OLD 100 ENCIRCLING NETS (PURSE)
NEW 100 ENCIRCLING NETS (PURSE)
 
OLD 200 TRAWLS,UNSPECIFIED
NEW 200 TRAWLS,UNSPECIFIED
 
OLD 300 POTS AND TRAPS
NEW 300 POTS AND TRAPS
 
OLD 400 ENTANGLING NETS(GILL)
NEW 400 ENTANGLING NETS(GILL)
 
OLD 600 TROLL AND HAND LINES
NEW 600 TROLL AND HAND LINES
 
OLD 675 SURFACE LONGLINES
NEW 675 SURFACE LONGLINES
 
OLD 676 BOTTOM LONGLINES
NEW 676 BOTTOM LONGLINES
 
OLD 735 CAST OR DIP NETS
NEW 735 CAST OR DIP NET
 
OLD 900 GIGS,SPEARS,POWERHEADS,BY HAND
NEW 900 GIGS, SPEARS, POWERHEADS, HAND
 
5 UNCHANGED SEFSC TIP_TIP11 VESSEL_LENGTH OPTIONAL NUMBER(4)
24 UNCHANGED TIPONLINE INTERVIEW VESSEL_LENGTH OPTIONAL NUMBER
24 UNCHANGED Unchanged. Not shown on the form.
 
6 NAME_CHANGE SEFSC TIP_TIP11 VESSEL_ID_NUMBER OPTIONAL VARCHAR2(15)
22 NAME_CHANGE TIPONLINE INTERVIEW VESSEL_ID OPTIONAL VARCHAR2(15)
22 NAME_CHANGE Name was changed.
 
7 NAME_CHANGE SEFSC TIP_TIP11 FISHERY_TYPE OPTIONAL NUMBER(2)
44 NAME_CHANGE TIPONLINE INTERVIEW TARGET_FISHERY_ID OPTIONAL NUMBER
44 NAME_CHANGE Not shown on the form. For historical data, it must match id in table TIPONLINE.FISHERY_TYPE, shown below.
44 NAME_CHANGE
Old? Code Description
OLD    
NEW 0 UNKNOWN TARGET FISHERY
 
OLD 1 M. COASTAL PELAGICS
NEW 1 M. COASTAL PELAGICS
 
OLD 2 REEF FISH
NEW 2 REEF FISH
 
OLD 3 OCEANIC PELAGICS
NEW 3 OCEANIC PELAGICS
 
OLD 4 INVERTEBRATES
NEW 4 INVERTEBRATES
 
OLD 5 MULLET
NEW 5 MULLET
 
OLD 6 BLUEFIN TUNA
NEW 6 BLUEFIN TUNA
 
OLD 7 ESTUARINE & GROUNDFISH
NEW 7 ESTUARINE & GROUNDFISH
 
OLD 8 MIXED
NEW 8 MIXED
 
OLD 9 SLOPE FISH
NEW 9 SLOPE FISH
 
 
8 UNCHANGED SEFSC TIP_TIP11 INTERVIEW_DATE MANDATORY DATE
2 UNCHANGED TIPONLINE INTERVIEW INTERVIEW_DATE MANDATORY DATE
2 UNCHANGED Unchanged
 
9 OLD_FIELD_DROPPED SEFSC TIP_TIP11 INTERVIEWDATE MANDATORY VARCHAR2(8)
- OLD_FIELD_DROPPED - - - - -
- OLD_FIELD_DROPPED InterviewDate was the character version of the date field, Interview_date, saving invalid date specifications. The new system requires a valid date so this field was dropped.
 
10 CODE_CHANGE SEFSC TIP_TIP11 REPORTING_STATE MANDATORY VARCHAR2(2)
6 CODE_CHANGE TIPONLINE INTERVIEW LANDING_AREA_STATE_CODE MANDATORY VARCHAR2(20)
6 CODE_CHANGE It was a NMFS code and now it is a FIPS state abbreviation. The distinction between Florida East Coast and Florida West Coast must be established by counties. The value must match id in the table Tiponline.State.
6 CODE_CHANGE
Old? Code Description
OLD    
NEW CS COMBINED STATES
 
OLD    
NEW CT CONNECTICUT
 
OLD    
NEW DE DELAWARE
 
OLD    
NEW MD MARYLAND
 
OLD    
NEW ME MAINE
 
OLD    
NEW NH NEW HAMPSHIRE
 
OLD    
NEW NJ NEW JERSEY
 
OLD    
NEW NY NEW YORK
 
OLD    
NEW PA PENNSYLVANIA
 
OLD    
NEW RI RHODE ISLAND
 
OLD    
NEW UN UNKNOWN STATE
 
OLD 01 ALABAMA
NEW AL ALABAMA
 
OLD 10 FLORIDA EAST COAST
NEW FL FLORIDA
 
OLD 11 FLORIDA WEST COAST
NEW FL FLORIDA
 
OLD 13 GEORGIA
NEW GA GEORGIA
 
OLD 21 LOUISIANA
NEW LA LOUISIANA
 
OLD 24 MASSACHUSETTS
NEW MA MASSACHUSETTS
 
OLD 27 MISSISSIPPI
NEW MS MISSISSIPPI
 
OLD 36 NORTH CAROLINA
NEW NC NORTH CAROLINA
 
OLD 43 SOUTH CAROLINA
NEW SC SOUTH CAROLINA
 
OLD 46 TEXAS
NEW TX TEXAS
 
OLD 49 VIRGINIA
NEW VA VIRGINIA
 
OLD 60 MEXICO
NEW MX MEXICO
 
OLD 72 PUERTO RICO
NEW PR PUERTO RICO
 
OLD 78 VIRGIN ISLANDS
NEW VI VIRGIN ISLANDS
 
OLD AN ANTIGUA/BARBUDA
NEW    
 
OLD BD BARBADOS
NEW    
 
OLD BV BRITISH VIRGIN ISLANDS
NEW    
 
OLD BZ BELIZE
NEW    
 
OLD DC COMMONWEALTH OF DOMINICA
NEW DC DISTRICT OF COLUMBIA
 
OLD GN GRENADA
NEW    
 
OLD GY GUYANA
NEW    
 
OLD JA JAMAICA
NEW    
 
OLD MN MONTSERRAT
NEW    
 
OLD SK ST. KITTS
NEW    
 
OLD SL ST. LUCIA
NEW    
 
OLD SN NEVIS
NEW    
 
OLD SV ST. VINCENT AND THE GRENADINES
NEW    
 
OLD TO TOBAGO
NEW    
 
OLD TR TRINIDAD
NEW    
 
 
11 NAME_CHANGE SEFSC TIP_TIP11 AREA_STATE OPTIONAL VARCHAR2(2)
16 NAME_CHANGE TIPONLINE INTERVIEW SAMPLE_AREA_STATE_CODE MANDATORY VARCHAR2(20)
16 NAME_CHANGE It was a NMFS code and now it is a FIPS state abbreviation. The distinction between Florida East Coast and Florida West Coast must be established by counties. Code table is same as for Reporting_state.
 
12 CODE_CHANGE SEFSC TIP_TIP11 AREA_COUNTY OPTIONAL VARCHAR2(2)
14 CODE_CHANGE TIPONLINE INTERVIEW LANDING_AREA_COUNTY_CODE OPTIONAL VARCHAR2(20)
14 CODE_CHANGE It was a NMFS county code and is now a FIPS (Federal Information Processing Standard) county_code. The value must match id in the table Tiponline.County.
14 CODE_CHANGE
Old TIP State Code
14 CODE_CHANGE
Old? Code Value
OLD    
NEW 000 NOT CODED
 
 
13 OLD_FIELD_DROPPED SEFSC TIP_TIP11 ORIG_AREA_COUNTY OPTIONAL VARCHAR2(2)
- OLD_FIELD_DROPPED - - - - -
- OLD_FIELD_DROPPED The field is no longer needed and was dropped.
 
14 NAME_CHANGE SEFSC TIP_TIP11 AREA_ZIP OPTIONAL VARCHAR2(5)
51 NAME_CHANGE TIPONLINE INTERVIEW REPORTING_AREA_ZIP OPTIONAL VARCHAR2(5)
51 NAME_CHANGE The field was carried for the historical data, but was not considered important enough to display on the screen. It will not be requested for new TIPONLINE data.
 
15 OLD_FIELD_DROPPED SEFSC TIP_TIP11 FIPS_AREA_STATE OPTIONAL VARCHAR2(2)
- OLD_FIELD_DROPPED - - - - -
- OLD_FIELD_DROPPED The field was no longer needed and was dropped. The reporting_state was used to compute the new landing_area_state_code, which is a FIPS code.
 
16 OLD_FIELD_DROPPED SEFSC TIP_TIP11 FIPS_AREA_COUNTY OPTIONAL VARCHAR2(2)
- OLD_FIELD_DROPPED - - - - -
- OLD_FIELD_DROPPED The field was no longer needed and was dropped. The area_county was used to compute the new landing_area_county_code, which is a FIPS code.
 
17 CODE_CHANGE SEFSC TIP_TIP11 SITE_COUNTY OPTIONAL VARCHAR2(3)
15 CODE_CHANGE TIPONLINE INTERVIEW SAMPLE_AREA_COUNTY_CODE MANDATORY VARCHAR2(20)
15 CODE_CHANGE It was a NMFS county code and is now a FIPS county_code. The value must match id in the table Tiponline.County
 
18 OLD_FIELD_DROPPED SEFSC TIP_TIP11 ORIG_SITE_COUNTY OPTIONAL VARCHAR2(2)
- OLD_FIELD_DROPPED - - - - -
- OLD_FIELD_DROPPED The field was no longer needed and was dropped.
 
19 NAME_CHANGE SEFSC TIP_TIP11 SITE_ZIP OPTIONAL VARCHAR2(5)
38 NAME_CHANGE TIPONLINE INTERVIEW SAMPLE_AREA_ZIP OPTIONAL NUMBER(5)
38 NAME_CHANGE Carried for historical data only. Will not be shown on the screen. Will not be collected in the future.
 
20 UNCHANGED SEFSC TIP_TIP11 SITE_LOCATION OPTIONAL VARCHAR2(4)
43 UNCHANGED TIPONLINE INTERVIEW SITE_LOCATION OPTIONAL VARCHAR2(4)
43 UNCHANGED The site location was carried for historical data only. Where there was just one per site location, a dealer_id was computed from a site_location. The dealer_id is the preferred data item, so site_location is not shown on the screen.
 
20 CODE_CHANGE SEFSC TIP_TIP11 SITE_LOCATION OPTIONAL VARCHAR2(4)
41 CODE_CHANGE TIPONLINE INTERVIEW DEALER_ID OPTIONAL VARCHAR2(15)
43 UNCHANGED When the site location had only 1 dealer in it, that dealer was assigned to dealer_id. The field will be populated more frequently in the new online data entry system.
 
21 OLD_FIELD_DROPPED SEFSC TIP_TIP11 INTERVIEW_NUMBER OPTIONAL NUMBER(5)
- OLD_FIELD_DROPPED - - - - -
- OLD_FIELD_DROPPED This field was dropped.
 
22 OLD_FIELD_DROPPED SEFSC TIP_TIP11 PROGRAM_NUMBER OPTIONAL NUMBER(3)
- OLD_FIELD_DROPPED - - - - -
- OLD_FIELD_DROPPED The new TIPONLINE program will probably be continually evolving, so the notion of a single program number or version was not considered relevant.
 
23 OLD_FIELD_DROPPED SEFSC TIP_TIP11 TYPE_13_RECORDS OPTIONAL NUMBER(4)
- OLD_FIELD_DROPPED - - - - -
- OLD_FIELD_DROPPED This field was dropped.
 
24 UNCHANGED SEFSC TIP_TIP11 SOURCE_FILE OPTIONAL VARCHAR2(20)
53 UNCHANGED TIPONLINE INTERVIEW SOURCE_FILE OPTIONAL VARCHAR2(30)
53 UNCHANGED The source file field was retained for historical data, but the new system will have online data entry, making it unnecessary. It will not be shown on the screen.
 
25 NAME_CHANGE SEFSC TIP_TIP11 LOAD_DATE OPTIONAL DATE
52 NAME_CHANGE TIPONLINE INTERVIEW ORIGINAL_LOAD_DATE OPTIONAL DATE
52 NAME_CHANGE Carried for historical data only. It is not shown on the screen. The new TIPONLINE data has a new field, called CREATED_DATE, that serves the same purpose as load_date.

SEFSC.TIP_TIP12 FILLS TIPONLINE.INTERVIEW

COLUMN ORDER TRANSFORMATION OLD: OWNER TABLE COLUMN NAME MANDATORY? TYPE
COLUMN ORDER TRANSFORMATION NEW: OWNER TABLE COLUMN NAME MANDATORY? TYPE
1 OLD_FIELD_DROPPED SEFSC TIP_TIP12 RECORD_TYPE MANDATORY VARCHAR2(2)
- OLD_FIELD_DROPPED - - - - -
- OLD_FIELD_DROPPED This field was dropped.
 
2 NAME_CHANGE SEFSC TIP_TIP12 SEQUENCE_NUMBER MANDATORY VARCHAR2(11)
50 NAME_CHANGE TIPONLINE INTERVIEW OLD_SEQUENCE_NUMBER OPTIONAL VARCHAR2(20)
50 NAME_CHANGE The data in TIP_TIP12 was joined with the data in TIP_TIP11 to make up the TIPONLINE.INTERVIEW table. This is not shown on the screen.
 
3 NAME_CHANGE SEFSC TIP_TIP12 START_DATE OPTIONAL DATE
8 NAME_CHANGE TIPONLINE INTERVIEW TRIP_START_DATE MANDATORY DATE
8 NAME_CHANGE It is now mandatory.
 
4 OLD_FIELD_DROPPED SEFSC TIP_TIP12 STARTDATE OPTIONAL VARCHAR2(8)
- OLD_FIELD_DROPPED - - - - -
- OLD_FIELD_DROPPED StartDate was the character version of the date field, Start_date. It was used for invalid dates. It is not needed now that the new system requires a valid date.
 
5 NAME_CHANGE SEFSC TIP_TIP12 END_DATE OPTIONAL DATE
5 NAME_CHANGE TIPONLINE INTERVIEW TRIP_END_DATE MANDATORY DATE
5 NAME_CHANGE It is now mandatory.
 
6 OLD_FIELD_DROPPED SEFSC TIP_TIP12 ENDDATE OPTIONAL VARCHAR2(8)
- OLD_FIELD_DROPPED - - - - -
- OLD_FIELD_DROPPED EndDate was the character version of the date field, End_date. It was saved for invalid dates. The new system requires a valid date.
 
7 NAME_CHANGE SEFSC TIP_TIP12 INFORMATION_SOURCE OPTIONAL VARCHAR2(2)
42 NAME_CHANGE TIPONLINE INTERVIEW INFORMATION_SOURCE_ID OPTIONAL NUMBER
42 NAME_CHANGE Must match id in table TIPONLINE.INFORMATION_SOURCE, shown below.
42 NAME_CHANGE
Old? Code Description
OLD    
NEW 8 NO LANDINGS
 
OLD 1 SALES RECORDS
NEW 1 SALES RECORDS
 
OLD 2 LOGBOOK
NEW 2 LOGBOOK
 
OLD 3 SITE SAMPLING
NEW 3 SITE SAMPLING
 
OLD 4 SALES RECORDS AND INTERVIEW
NEW 4 SALES, INTERVIEW
 
OLD 5 OBSERVER DATA
NEW 5 OBSERVER DATA
 
OLD 7 SALES RECORDS AND OBSERVATION
NEW 7 SALES,OBSERVER
 
 
8 NAME_CHANGE SEFSC TIP_TIP12 FISHING_MODE OPTIONAL VARCHAR2(2)
28 NAME_CHANGE TIPONLINE INTERVIEW FISHING_MODE_ID OPTIONAL NUMBER
28 NAME_CHANGE Must match id in table TIPONLINE.FISHING_MODE, shown below.
28 NAME_CHANGE
Old? Code Description
OLD    
NEW 0 UNKNOWN FISHING MODE
 
OLD 1 COMMERCIAL
NEW 1 COMMERCIAL
 
OLD 2 CHARTER/PARTY
NEW 2 PARTY/CHARTER
 
OLD 3 HEADBOAT
NEW 3 HEADBOAT
 
OLD 4 PRIVATE RECREATIONAL
NEW 4 PRIVATE RECREATIONAL
 
OLD 5 TOURNAMENT
NEW 5 TOURNAMENT
 
OLD 6 SCIENTIFIC SURVEY
NEW 6 SCIENTIFIC SURVEY
 
 
9 NAME_CHANGE SEFSC TIP_TIP12 START_HOUR OPTIONAL VARCHAR2(2)
29 NAME_CHANGE TIPONLINE INTERVIEW BEGIN_TIME_HOUR OPTIONAL NUMBER
29 NAME_CHANGE The name and the data type were changed.
 
10 NAME_CHANGE SEFSC TIP_TIP12 START_MIN OPTIONAL VARCHAR2(2)
29 NAME_CHANGE TIPONLINE INTERVEW BEGIN_TIME_MINUTE OPTIONAL NUMBER
29 NAME_CHANGE The name and the data type were changed.
 
11 NAME_CHANGE SEFSC TIP_TIP12 END_HOUR OPTIONAL VARCHAR2(2)
11 NAME_CHANGE TIPONLINE INTERVIEW END_TIME_HOUR OPTIONAL NUMBER
11 NAME_CHANGE The name and the data type were changed.
 
12 NAME_CHANGE SEFSC TIP_TIP12 END_MIN OPTIONAL VARCHAR2(2)
37 NAME_CHANGE TIPONLINE INTERVIEW END_TIME_MINUTE OPTIONAL NUMBER
37 NAME_CHANGE The name and the data type were changed.
 
13 NAME_CHANGE SEFSC TIP_TIP12 AGENT OPTIONAL VARCHAR2(2)
3 NAME_CHANGE TIPONLINE INTERVIEW AGENT_USERNAME_ID MANDATORY VARCHAR2(20)
3 NAME_CHANGE Name changed. The two character agent code was transformed into the Oracle userid of the person responsible for maintaining the historical data for that agency.
 
14 NAME_CHANGE SEFSC TIP_TIP12 INTERVIEW_TYPE OPTIONAL VARCHAR2(2)
11 NAME_CHANGE TIPONLINE INTERVIEW INTERVIEW_TYPE_ID OPTIONAL NUMBER
11 NAME_CHANGE Must match id in table TIPONLINE.INTERVIEW_TYPE, shown below.
11 NAME_CHANGE
Old? Code Description
OLD    
NEW 0 UNKNOWN INTERVIEW TYPE
 
OLD 1 FISHERMAN SAMPLE
NEW 1 FISHERMAN SAMPLE
 
OLD 2 DEALER SAMPLE
NEW 2 DEALER SAMPLE
 
OLD 3 TRIP SURVEY
NEW 3 TRIP SURVEY
 
OLD 4 ANGLER TRIP
NEW 4 ANGLER TRIP
 
OLD 5 OBSERVER TRIP
NEW 5 OBSERVER TRIP
 
 
15 NAME_CHANGE SEFSC TIP_TIP12 LANDINGS_TYPE OPTIONAL VARCHAR2(2)
9 NAME_CHANGE TIPONLINE INTERVIEW LANDING_TYPE_ID MANDATORY NUMBER
9 NAME_CHANGE Must match id in table TIPONLINE.LANDING_TYPE, shown below.
9 NAME_CHANGE
Old? Code Description
OLD 1 COMPLETE LANDINGS (weight)
NEW 1 COMPLETE LANDINGS
 
OLD 2 INCOMPLETE LANDINGS (weight)
NEW 2 INCOMPLETE LANDINGS
 
OLD 3 NO LANDINGS
NEW 3 NO LANDINGS
 
OLD 4 NO FISH CAUGHT
NEW 4 NO FISH CAUGHT
 
 
16 UNCHANGED SEFSC TIP_TIP12 CREW_SIZE OPTIONAL NUMBER(3)
40 UNCHANGED TIPONLINE INTERVIEW CREW_SIZE OPTIONAL NUMBER
40 UNCHANGED Unchanged.
 
17 NAME_CHANGE SEFSC TIP_TIP12 DAYS_OUT OPTIONAL NUMBER(5,1)
26 NAME_CHANGE TIPONLINE INTERVIEW TRIP_DAYS_OUT OPTIONAL NUMBER
26 NAME_CHANGE Name changed.
 
18 NAME_CHANGE SEFSC TIP_TIP12 DAYS_FISHED OPTIONAL NUMBER(5,1)
27 NAME_CHANGE TIPONLINE INTERVIEW TRIP_DAYS_FISHED OPTIONAL NUMBER
27 NAME_CHANGE Name changed.
 
19 NAME_CHANGE SEFSC TIP_TIP12 TERMINATION_CODE OPTIONAL VARCHAR2(2)
41 NAME_CHANGE TIPONLINE INTERVIEW TERMINATION_TYPE_ID OPTIONAL NUMBER
41 NAME_CHANGE Name changed. Must match id in table TIPONLINE.TERMINATION_TYPE, shown below.
41 NAME_CHANGE
Old? Code Description
OLD 0 UNKNOWN
NEW 0 UNKNOWN
 
OLD 1 NORMAL
NEW 1 NORMAL
 
OLD 2 WEATHER
NEW 2 WEATHER
 
OLD 3 EQUIPMENT FAILURE
NEW 3 EQUIPMENT FAILURE
 
OLD 4 NO FISH AVAILABLE
NEW 4 NO FISH AVAILABLE
 
OLD 5 SHARK ATTACK
NEW 5 PREDATOR DAMAGE
 
OLD 6 WEIGH IN(END OF SEASON OR TOUR
NEW 6 WEIGH IN
 
OLD 7 OUT OF BAIT
NEW 7 OUT OF BAIT
 
OLD 8 TRIP OR BAG LIMIT REACHED
NEW 8 TRIP OR BAG LIMIT REACHED
 
 
20 NAME_CHANGE SEFSC TIP_TIP12 BIAS_TYPE OPTIONAL VARCHAR2(2)
39 NAME_CHANGE TIPONLINE INTERVIEW BIAS_TYPE_ID OPTIONAL NUMBER
39 NAME_CHANGE Name changed. Must match id in table TIPONLINE.BIAS_TYPE.
39 NAME_CHANGE Must match id in table TIPONLINE.BIAS_TYPE, shown below.
39 NAME_CHANGE
Old? Code Description
OLD 1 NO KNOWN BIAS
NEW 1 NO KNOWN BIAS
 
OLD 2 SIZE BIAS
NEW 2 SIZE BIAS
 
OLD 3 EFFORT BIAS
NEW 3 EFFORT BIAS
 
OLD 4 SIZE AND EFFORT BIAS
NEW 4 SIZE AND EFFORT BIAS
 
OLD 5 NO INFORMATION
NEW 5 NO INFORMATION
 
OLD 6 TARGETING SEX BIAS
NEW 6 TARGETING SEX BIAS
 
 
21 OLD_FIELD_DROPPED SEFSC TIP_TIP12 TYPE_21_RECORDS OPTIONAL NUMBER(3)
- OLD_FIELD_DROPPED - - - - -
- OLD_FIELD_DROPPED The field was dropped.
 
- NEW_FIELD_ADDED - - - - -
1 NEW_FIELD_ADDED TIPONLINE INTERVIEW ID MANDATORY NUMBER
1 NEW_FIELD_ADDED New field added. TIPONLINE.Interview.Id is a sequential number generated when the interview record is created. That number is assigned to TIPONLINE.Effort.Interview_Id to relate this effort to a particular interview. There is also an Interview_id field in TIPONLINE.Landing, TIPONLINE.Sample and TIPONLINE.Observation. The field is shown as the last digits on the Interview Number after the characters for the state code.
 
- NEW_FIELD_ADDED - - - - -
4 NEW_FIELD_ADDED TIPONLINE INTERVIEW IS_DISABLED MANDATORY NUMBER
4 NEW_FIELD_ADDED New field added. During the historical loading process, it is assigned 0, meaning No - the record is not disabled. This control field is not shown on the screen. If the value is set to 1, then the record will not appear on the screen and will not appear in reports.
 
- NEW_FIELD_ADDED - - - - -
6 NEW_FIELD_ADDED TIPONLINE INTERVIEW IS_HISTORICAL MANDATORY NUMBER
6 NEW_FIELD_ADDED New field added. During the historical loading process, it is assigned 1, meaning Yes - the record is historical data, not data entered online through the TIPONLINE program. This is not shown on the screen.
 
- NEW_FIELD_ADDED - - - - -
7 NEW_FIELD_ADDED TIPONLINE INTERVIEW IS_EFFORT_DATA_COLLECTED MANDATORY NUMBER
7 NEW_FIELD_ADDED New field added. During the historical loading process, it is assigned 1, meaning Yes - effort data was collected if that trip had any gear but `999' (Combined Gear) OR area_fished is not null. Otherwise, it is assigned, 0 - no effort data was collected.
 
- NEW_FIELD_ADDED - - - - -
10 NEW_FIELD_ADDED TIPONLINE INTERVIEW AGENCY_ID MANDATORY NUMBER
10 NEW_FIELD_ADDED New field added. It must match id in TIPONLINE.Agency, shown below in the code field. Name - Description appear under the description heading.
10 NEW_FIELD_ADDED
Old? Code Description
OLD    
NEW 1 MAINE - State of Maine Department of Marine Resources
 
OLD    
NEW 2 NEW HAMPSHIRE - State of New Hampshire Fish & Game Dept.
 
OLD    
NEW 3 MASSACHUSETTS - State of Massachusetts Division of Marine Fisheries
 
OLD    
NEW 4 RHODE ISLAND - State of Rhode Island Division of Fish and Wildlife
 
OLD    
NEW 5 CONNECTICUT - State of Connecticut DEP, Marine Fisheries Division
 
OLD    
NEW 6 NEW YORK - State of New York Dept of Environmental Conservation
 
OLD    
NEW 7 NEW JERSEY - State of New Jersey Division of Fish & Wildlife
 
OLD    
NEW 8 PENNSYLVANIA - State of Pennsylvania Fish and Boat Commission
 
OLD    
NEW 9 DELAWARE - State of Delaware Dept of Natural Resources
 
OLD    
NEW 10 MARYLAND - State of Maryland DNR, Fisheries Service
 
OLD    
NEW 11 VIRGINIA - Virginia Marine Resources Comission
 
OLD    
NEW 12 NORTH CAROLINA - State of North Carolina DENR, Division of Marine Fisheries
 
OLD    
NEW 13 SOUTH CAROLINA - South Carolina Department of Natural Resources
 
OLD    
NEW 14 GEORGIA - State of Georgia DNR, Coastal Resources Division
 
OLD    
NEW 15 FLORIDA - State of Florida FWC
 
OLD    
NEW 16 NMFS-NER - National Marine Fisheries Service - Northeast Region
 
OLD    
NEW 17 NMFS_HQ - National Marine Fisheries Service - Headquarters
 
OLD    
NEW 18 NMFS-SER - National Marine Fisheries Service - Southeast Region
 
OLD    
NEW 19 ASMFC - Atlantic States Marine Fisheries Commission
 
OLD    
NEW 20 NEFMC - New England Fishery Management Council
 
OLD    
NEW 21 MAFMC - Mid Atlantic Fishery Management Council
 
OLD    
NEW 22 SAFMC - South Atlantic Fishery Management Council
 
OLD    
NEW 23 USFWS - United States Fish & Wildlife Service
 
OLD    
NEW 24 DISTRICT OF COLUMBIA- District of Columbia Fisheries & WIldlife Division
 
OLD    
NEW 25 POTOMAC RIVER FC - Potomac River Fish Commission
 
OLD    
NEW 26 ALABAMA - State of Alabama Marine Resources Division
 
OLD    
NEW 27 MISSISSIPPI - State of Misissippi Dept of Marine Resources
 
OLD    
NEW 28 LOUISIANA - State of Louisiana Dept Wildlife & Fisheries
 
OLD    
NEW 29 TEXAS - State of Texas Parks & Wildlife Dept
 
OLD    
NEW 30 GSMFC - Gulf States Marine Fisheries Commission
 
OLD    
NEW 31 PUERTO RICO - Puerto Rico DENR
 
OLD    
NEW 32 USVI - United States Virgin Islands
 
OLD    
NEW 999 DUMMY - Dummy test agency
 
 
- NEW_FIELD_ADDED - - - - -
12 NEW_FIELD_ADDED TIPONLINE INTERVIEW LANDING_AREA_PLACE_CODE OPTIONAL NUMBER
12 NEW_FIELD_ADDED New field added. This is a large list that shows places for a previously selected state and county. See the ONLINE program's interview section to examine the extensive codes provided. The value must match id in the table Tiponline.Place_Code.
 
- NEW_FIELD_ADDED - - - - -
15 NEW_FIELD_ADDED TIPONLINE INTERVIEW SAMPLE_AREA_PLACE_CODE OPTIONAL NUMBER
15 NEW_FIELD_ADDED New field added. This is a large list that shows places for a previously selected state and county. See the ONLINE program's interview section to examine the extensive codes provided. The value must match id in the table Tiponline.Place_Code.
 
- NEW_FIELD_ADDED - - - - -
18 NEW_FIELD_ADDED TIPONLINE INTERVIEW NUMBER_OF_VESSELS MANDATORY NUMBER
18 NEW_FIELD_ADDED New field added. During the historical loading process, it is assigned 1 if a vessel_id was provided. If the related sefsc.tip_tip21.no_of_trips has a maximum value of 1, then number_of_vessels = 1, otherwise it is assigned 0, meaning we have no information about the number of vessels.
 
- NEW_FIELD_ADDED - - - - -
19 NEW_FIELD_ADDED TIPONLINE INTERVIEW CREATED_BY_USER_ID MANDATORY VARCHAR2(20)
19 NEW_FIELD_ADDED New field added. Whenever a record is created, the Oracle user id is automatically recorded in this field. Not shown on the screen.
 
- NEW_FIELD_ADDED - - - - -
20 NEW_FIELD_ADDED TIPONLINE INTERVIEW CREATED_DATE MANDATORY DATE
20 NEW_FIELD_ADDED New field added. Whenever a record is created, the date and time of the record creation is automatically recorded in this field. Not shown on the screen.
 
- NEW_FIELD_ADDED - - - - -
21 NEW_FIELD_ADDED TIPONLINE INTERVIEW VESSEL_NAME OPTIONAL VARCHAR2(30)
21 NEW_FIELD_ADDED New field added. Although this field is shown on the PC program, the vessel name was never stored in the sefsc.tip_tip11 table. It is now provided for the agent to indicate a name change from the previously listed vessel_name shown in the on-screen vessel list of values.
 
- NEW_FIELD_ADDED - - - - -
23 NEW_FIELD_ADDED TIPONLINE INTERVIEW VESSEL_TYPE_ID OPTIONAL NUMBER
23 NEW_FIELD_ADDED New field added. This field was not loaded and was not used. It may be removed in a future version.
 
- NEW_FIELD_ADDED - - - - -
25 NEW_FIELD_ADDED TIPONLINE INTERVIEW TRIP_NUMBER OPTIONAL NUMBER
25 NEW_FIELD_ADDED New field added. It does not exist in the historical data.
 
- NEW_FIELD_ADDED - - - - -
33 NEW_FIELD_ADDED TIPONLINE INTERVIEW TRIP_TICKET_NUMBER OPTIONAL VARCHAR2(30)
33 NEW_FIELD_ADDED New field added. It does not exist in the historical data.
 
- NEW_FIELD_ADDED - - - - -
35 NEW_FIELD_ADDED TIPONLINE INTERVIEW TRIP_TICKET_LICENSE_AGENCY_ID OPTIONAL NUMBER
35 NEW_FIELD_ADDED New field added. It does not exist in the historical data.
 
- NEW_FIELD_ADDED - - - - -
36 NEW_FIELD_ADDED TIPONLINE INTERVIEW INDIVIDUAL_LICENSE_NUMBER OPTIONAL VARCHAR2(30)
36 NEW_FIELD_ADDED New field added. It does not exist in the historical data.
 
- NEW_FIELD_ADDED - - - - -
37 NEW_FIELD_ADDED TIPONLINE INTERVIEW DELETE_REASON_ID OPTIONAL NUMBER
37 NEW_FIELD_ADDED New field added. It does not exist in the historical data. When deleting new data, it must match an id in table TIPONLINE.Delete_Reason, shown below.
37 NEW_FIELD_ADDED
Old? Code Description
OLD    
NEW 1 DUPLICATE RECORD - RECORD WAS ENTERED MORE THAN ONCE
 
OLD    
NEW 2 MULTIPLE ERRORS - RECORD HAS MULTIPLE ERRORS, EASIER TO RE-ENTER IT
 
 
- NEW_FIELD_ADDED - - - - -
46 NEW_FIELD_ADDED TIPONLINE INTERVIEW COMMENTS OPTIONAL VARCHAR2(4000)
46 NEW_FIELD_ADDED New field added. It does not exist in the historical data.
 
- NEW_FIELD_ADDED - - - - -
47 NEW_FIELD_ADDED TIPONLINE INTERVIEW MODIFIED_BY_USER_ID OPTIONAL VARCHAR2(20)
47 NEW_FIELD_ADDED New field added. This field is comparable to sefsc.tip_changes.userid. However, sefsc.tip_tip11 does not record such information. The new TIPONLINE program will automatically record the Oracle user id of the person updating the record. Not shown on screen.
 
- NEW_FIELD_ADDED - - - - -
48 NEW_FIELD_ADDED TIPONLINE INTERVIEW MODIFIED_DATE MANDATORY NUMBER
48 NEW_FIELD_ADDED New field added. This field is comparable to sefsc.tip_changes.changedate. However, sefsc.tip_tip11 does not record such information. The new TIPONLINE program will automatically record the date and time the record is updated. Not shown on screen.
 
- NEW_FIELD_ADDED - - - - -
49 NEW_FIELD_ADDED TIPONLINE INTERVIEW STATUS_ID MANDATORY NUMBER
49 NEW_FIELD_ADDED New field added. During the historical loading process, status_id is assigned 1, meaning the record is valid. If a record in any of the related tables causes an Oracle exception, the entire interview is removed from the database. The offending record(s) must be fixed and the trip must be reloaded. This field is only shown on the data entry screen that lets you search for records to edit.

SEFSC.TIP_TIP13 FILLS TIPONLINE.EFFORT

COLUMN ORDER TRANSFORMATION OLD: OWNER TABLE COLUMN NAME MANDATORY? TYPE
COLUMN ORDER TRANSFORMATION NEW: OWNER TABLE COLUMN NAME MANDATORY? TYPE
1 UNCHANGED SEFSC TIP_TIP13 RECORD_TYPE MANDATORY VARCHAR2(2)
34 UNCHANGED TIPONLINE EFFORT RECORD_TYPE OPTIONAL VARCHAR2(2)
34 UNCHANGED The old record type field was only saved for the Effort table in order to provide a key to exactly match 1 record in the historical table to one record in the new TIPONLINE data. The other tables could have a matching key without using record_type. This is not shown on the screen.
 
2 OLD_FIELD_DROPPED SEFSC TIP_TIP13 SEQUENCE_NUMBER MANDATORY VARCHAR2(11)
- OLD_FIELD_DROPPED - - - - -
- OLD_FIELD_DROPPED Although sequence_number is not carried in the new TIPONLINE data there is a new field, INTERVIEW_ID, which relates all data back to the original interview record. TIPONLINE.Interview.Id is a sequential number generated when the interview record is created. That number is assigned to TIPONLINE.Effort.Interview_Id to relate this effort to a particular interview.
 
3 UNCHANGED SEFSC TIP_TIP13 GEAR_CODE OPTIONAL VARCHAR2(3)
3 UNCHANGED TIPONLINE EFFORT GEAR_CODE OPTIONAL VARCHAR2(20)
3 UNCHANGED In TIPONLINE, each agency can have an agency specific gear_code table. For the historical data, we created tiponline.nmfs_gear from data in sefsc.gear_code_nmfs, with the minor difference that the old codes were in upper and lower case and the new codes are all upper case.
3 UNCHANGED
Old? Code Description
OLD    
NEW 0 NOT CODED
 
OLD    
NEW 20 HAUL SEINES, BEACH
 
OLD    
NEW 30 HAUL SEINES, LONG
 
OLD    
NEW 32 HAUL SEINES, LONG(DANISH)
 
OLD    
NEW 40 STOP SEINES
 
OLD    
NEW 50 STOP NETS
 
OLD 000 NOT CODED
NEW    
 
OLD 020 HAUL SEINES, BEACH
NEW    
 
OLD 030 HAUL SEINES, LONG
NEW    
 
OLD 032 HAUL SEINES, LONG(DANISH)
NEW    
 
OLD 040 STOP SEINES
NEW    
 
OLD 050 STOP NETS
NEW    
 
OLD 100 ENCIRCLINLING NETS (PURSE)
NEW 100 ENCIRCLINLING NETS (PURSE)
 
OLD 103 PURSE SEINES, ANCHOVY
NEW 103 PURSE SEINES, ANCHOVY
 
OLD 105 PURSE SEINES, BARRACUDA
NEW 105 PURSE SEINES, BARRACUDA
 
OLD 110 PURSE SEINES, HERRING
NEW 110 PURSE SEINES, HERRING
 
OLD 120 PURSE SEINES, MACKEREL
NEW 120 PURSE SEINES, MACKEREL
 
OLD 125 PURSE SEINES, MENHADEN
NEW 125 PURSE SEINES, MENHADEN
 
OLD 130 PURSE SEINES, SALMON
NEW 130 PURSE SEINES, SALMON
 
OLD 135 PURSE SEINES, SARDINE
NEW 135 PURSE SEINES, SARDINE
 
OLD 140 PURSE SEINES, TUNA
NEW 140 PURSE SEINES, TUNA
 
OLD 145 PURSE SEINES, OTHER
NEW 145 PURSE SEINES, OTHER
 
OLD 150 NETS UNC, HAWAII
NEW 150 NETS UNC, HAWAII
 
OLD 151 NETS, EXCLUDING TRAWLS
NEW 151 NETS, EXCLUDING TRAWLS
 
OLD 155 LAMPARA & RING NETS, MACKEREL
NEW 155 LAMPARA & RING NETS, MACKEREL
 
OLD 160 LAMPARA & RING NETS, SARDINE
NEW 160 LAMPARA & RING NETS, SARDINE
 
OLD 165 LAMPARA & RING NETS, SQUID
NEW 165 LAMPARA & RING NETS, SQUID
 
OLD 170 LAMPARA & RING NETS, TUNA
NEW 170 LAMPARA & RING NETS, TUNA
 
OLD 175 LAMPARA & RING NETS, OTHER
NEW 175 LAMPARA & RING NETS, OTHER
 
OLD 180 BAG NETS
NEW 180 BAG NETS
 
OLD 185 PARANELLA NETS
NEW 185 PARANELLA NETS
 
OLD 189 BUTTERFLY NETS
NEW 189 BUTTERFLY NETS
 
OLD 191 BEAM TRAWLS, CRAB
NEW 191 BEAM TRAWLS, CRAB
 
OLD 192 BEAM TRAWLS, SHRIMP
NEW 192 BEAM TRAWLS, SHRIMP
 
OLD 193 BEAM TRAWLS, OTHER
NEW 193 BEAM TRAWLS, OTHER
 
OLD 194 BEAM TRAWLS, CHOPSTICKS
NEW 194 BEAM TRAWLS, CHOPSTICKS
 
OLD 200 TRAWLS, UNSPECIFIED
NEW 200 TRAWLS, UNSPECIFIED
 
OLD 205 OTTER TRAWL BOTTOM, CRAB
NEW 205 OTTER TRAWL BOTTOM, CRAB
 
OLD 210 OTTER TRAWL BOTTOM, FISH
NEW 210 OTTER TRAWL BOTTOM, FISH
 
OLD 212 OTTER TRAWL BOTTOM, LOBSTER
NEW 212 OTTER TRAWL BOTTOM, LOBSTER
 
OLD 214 OTTER TRAWL BOTTOM, SCALLOP
NEW 214 OTTER TRAWL BOTTOM, SCALLOP
 
OLD 215 OTTER TRAWL BOTTOM, SHRIMP
NEW 215 OTTER TRAWL BOTTOM, SHRIMP
 
OLD 220 OTTER TRAWL BOTTOM, OTHER
NEW 220 OTTER TRAWL BOTTOM, OTHER
 
OLD 230 OTTER TRAWL MIDWATER
NEW 230 OTTER TRAWL MIDWATER
 
OLD 233 TRAWL MIDWATER, PAIRED
NEW 233 TRAWL MIDWATER, PAIRED
 
OLD 235 TRAWL BOTTOM, PAIRED
NEW 235 TRAWL BOTTOM, PAIRED
 
OLD 240 SCOTTISH SEINE
NEW 240 SCOTTISH SEINE
 
OLD 250 WEIRS
NEW 250 WEIRS
 
OLD 275 POUND NETS, FISH
NEW 275 POUND NETS, FISH
 
OLD 280 POUND NETS, CRAB
NEW 280 POUND NETS, CRAB
 
OLD 285 POUND NETS, HORSESHOE CRAB
NEW 285 POUND NETS, HORSESHOE CRAB
 
OLD 289 POUND NETS, OTHER
NEW 289 POUND NETS, OTHER
 
OLD 290 TRAP NETS
NEW 290 TRAP NETS
 
OLD 295 FLOATING TRAPS (SHALLOW)
NEW 295 FLOATING TRAPS (SHALLOW)
 
OLD 300 POTS AND TRAPS, CMB
NEW 300 POTS AND TRAPS, CMB
 
OLD 305 FYKE AND HOOP NETS, CRAB
NEW 305 FYKE AND HOOP NETS, CRAB
 
OLD 310 FYKE AND HOOP NETS, FISH
NEW 310 FYKE AND HOOP NETS, FISH
 
OLD 315 FYKE AND HOOP NETS, TURTLE
NEW 315 FYKE AND HOOP NETS, TURTLE
 
OLD 320 FYKE NET, OTHER
NEW 320 FYKE NET, OTHER
 
OLD 325 POTS AND TRAPS, CONCH
NEW 325 POTS AND TRAPS, CONCH
 
OLD 330 POTS AND TRAPS, CRAB, BLUE
NEW 330 POTS AND TRAPS, CRAB, BLUE
 
OLD 331 POTS AND TRAPS, CRAB, DUNGENS
NEW 331 POTS AND TRAPS, CRAB, DUNGENS
 
OLD 332 POTS AND TRAPS, CRAB, KING
NEW 332 POTS AND TRAPS, CRAB, KING
 
OLD 333 POTS AND TRAPS, CRAB, OTHER
NEW 333 POTS AND TRAPS, CRAB, OTHER
 
OLD 334 POTS AND TRAPS, CRAB, BLUE PEELER
NEW 334 POTS AND TRAPS, CRAB, BLUE PEE
 
OLD 335 POTS AND TRAPS,CRAYFSH(FRHWA)
NEW 335 POTS AND TRAPS,CRAYFSH(FRHWA)
 
OLD 340 POTS AND TRAPS, EEL
NEW 340 POTS AND TRAPS, EEL
 
OLD 345 POTS AND TRAPS, FISH
NEW 345 POTS AND TRAPS, FISH
 
OLD 350 POTS AND TRAPS, LOBSTER INSHORE
NEW 350 POTS AND TRAPS, LOBSTER INSHOR
 
OLD 351 POTS AND TRAPS, LOBSTER OFSHORE
NEW 351 POTS AND TRAPS, LOBSTER OFSHOR
 
OLD 355 POTS AND TRAPS, SPINY LOBSTER
NEW 355 POTS AND TRAPS, SPINY LOBSTER
 
OLD 360 POTS AND TRAPS, OCTOPUS
NEW 360 POTS AND TRAPS, OCTOPUS
 
OLD 365 POTS AND TRAPS, PERWKLE OR CKLE
NEW 365 POTS AND TRAPS, PERWKLE OR CKL
 
OLD 370 POTS AND TRAPS, SHRIMP
NEW 370 POTS AND TRAPS, SHRIMP
 
OLD 375 POTS AND TRAPS, TURTLE
NEW 375 POTS AND TRAPS, TURTLE
 
OLD 379 POTS AND TRAPS, OTHER
NEW 379 POTS AND TRAPS, OTHER (INCLUDE
 
OLD 380 POTS AND TRAPS, BOX TRAP
NEW 380 POTS AND TRAPS, BOX TRAP
 
OLD 385 POTS AND TRAPS, WIRE BASKETS
NEW 385 POTS AND TRAPS, WIRE BASKETS
 
OLD 387 POTS, UNCLASSIFIED
NEW 387 POTS, UNCLASSIFIED
 
OLD 390 SLAT TRAPS (VIRGINIA)
NEW 390 SLAT TRAPS (VIRGINIA)
 
OLD 400 ENTANGLING NETS (GILL) UNSPC
NEW 400 ENTANGLING NETS (GILL) UNSPC
 
OLD 405 GILL NETS, CALIFORNIA HALIBUT
NEW 405 GILL NETS, CALIFORNIA HALIBUT
 
OLD 410 GILL NETS, CRAB
NEW 410 GILL NETS, CRAB
 
OLD 415 GILL NETS, SALMON
NEW 415 GILL NETS, SALMON
 
OLD 420 GILL NETS, SEA BASS
NEW 420 GILL NETS, SEA BASS
 
OLD 425 GILL NETS, OTHER
NEW 425 GILL NETS, OTHER
 
OLD 430 GILL NETS, SINK/ANCHOR, OTHER
NEW 430 GILL NETS, SINK/ANCHOR, OTHER
 
OLD 450 GILL NETS, DRIFT, BARRACUDA
NEW 450 GILL NETS, DRIFT, BARRACUDA
 
OLD 455 GILL NETS, DRIFT, SALMON
NEW 455 GILL NETS, DRIFT, SALMON
 
OLD 460 GILL NETS, DRIFT, SEA BASS
NEW 460 GILL NETS, DRIFT, SEA BASS
 
OLD 465 GILL NETS, DRIFT, SHAD
NEW 465 GILL NETS, DRIFT, SHAD
 
OLD 470 GILL NETS, DRIFT, OTHER
NEW 470 GILL NETS, DRIFT, OTHER
 
OLD 475 GILL NETS, DRIFT, RUNAROUND
NEW 475 GILL NETS, DRIFT, RUNAROUND
 
OLD 480 GILL NETS, STAKE
NEW 480 GILL NETS, STAKE
 
OLD 490 GILL NETS, GL SHOAL
NEW 490 GILL NETS, GL SHOAL
 
OLD 500 GILL NETS, GL 1 - 2 INCH
NEW 500 GILL NETS, GL 1 - 2 INCH
 
OLD 505 GILL NETS, GL 2 - 4 INCH
NEW 505 GILL NETS, GL 2 - 4 INCH
 
OLD 510 GILL NETS, GL 4 - 7 INCH
NEW 510 GILL NETS, GL 4 - 7 INCH
 
OLD 515 GILL NETS, GL 7 - 14 INCH
NEW 515 GILL NETS, GL 7 - 14 INCH
 
OLD 520 GILL NETS, DRIFT LARGE PELAGIC
NEW 520 GILL NETS, DRIFT LARGE PELAGIC
 
OLD 530 TRAMMEL NETS
NEW 530 TRAMMEL NETS
 
OLD 600 TROLL & HAND LINES CMB
NEW 600 TROLL & HAND LINES CMB
 
OLD 601 LINES HAND, ALBACORE
NEW 601 LINES HAND, ALBACORE
 
OLD 605 LINES HAND, ROCKFISH
NEW 605 LINES HAND, ROCKFISH
 
OLD 607 LINES HAND, YELLOWFISH
NEW 607 LINES HAND, YELLOWFISH
 
OLD 610 LINES HAND, OTHER
NEW 610 LINES HAND, OTHER
 
OLD 611 ROD AND REEL
NEW 611 ROD AND REEL
 
OLD 612 REEL, MANUAL
NEW 612 REEL, MANUAL
 
OLD 613 REEL, ELECTRIC OR HYDRAULIC
NEW 613 REEL, ELECTRIC OR HYDRAULIC
 
OLD 614 LINES LONG, VERTICAL
NEW 614 LINES LONG, VERTICAL
 
OLD 616 ROD AND REEL, ELECTRIC (HAND)
NEW 616 ROD AND REEL, ELECTRIC (HAND)
 
OLD 621 LINES JIGGING MACHINE
NEW 621 LINES JIGGING MACHINE
 
OLD 650 LINES TROLL, SALMON
NEW 650 LINES TROLL, SALMON
 
OLD 651 LINES POWER TROLL SALMON
NEW 651 LINES POWER TROLL SALMON
 
OLD 655 LINES TROLL, TUNA
NEW 655 LINES TROLL, TUNA
 
OLD 656 LINES POWER TROLL TUNA
NEW 656 LINES POWER TROLL TUNA
 
OLD 660 LINES TROLL, OTHER
NEW 660 LINES TROLL, OTHER
 
OLD 661 LINES POWER TROLL OTHER
NEW 661 LINES POWER TROLL OTHER
 
OLD 665 LINES TROLL, MACKEREL
NEW 665 LINES TROLL, MACKEREL
 
OLD 675 LINES LONG SET WITH HOOKS
NEW 675 LINES LONG SET WITH HOOKS
 
OLD 676 LINES LONG, REEF FISH
NEW 676 LINES LONG, REEF FISH
 
OLD 677 LINES LONG, SHARK
NEW 677 LINES LONG, SHARK
 
OLD 678 LINES LONG DRIFT WITH HOOKS
NEW 678 LINES LONG DRIFT WITH HOOKS
 
OLD 680 LINES TROT WITH BAITS
NEW 680 LINES TROT WITH BAITS
 
OLD 685 LINES SNAG
NEW 685 LINES SNAG
 
OLD 690 LINES ELECTRICAL DEVICES
NEW 690 LINES ELECTRICAL DEVICES
 
OLD 703 DIP NETS, COMMON
NEW 703 DIP NETS, COMMON
 
OLD 705 DIP NETS, DROP
NEW 705 DIP NETS, DROP
 
OLD 710 BRAIL OR SCOOP
NEW 710 BRAIL OR SCOOP
 
OLD 715 LIFT NET
NEW 715 LIFT NET
 
OLD 720 REEF NET
NEW 720 REEF NET
 
OLD 725 PUSH NET
NEW 725 PUSH NET
 
OLD 730 WHEELS
NEW 730 WHEELS
 
OLD 735 CAST NETS
NEW 735 CAST NETS
 
OLD 751 HARPOONS, SWORDFISH
NEW 751 HARPOONS, SWORDFISH
 
OLD 752 HARPOONS, TURTLE
NEW 752 HARPOONS, TURTLE
 
OLD 753 HARPOONS, WHALE
NEW 753 HARPOONS, WHALE
 
OLD 754 HARPOONS, OTHER
NEW 754 HARPOONS, OTHER
 
OLD 760 SPEARS
NEW 760 SPEARS
 
OLD 765 POWERHEADS (BANGSTICKS)
NEW 765 POWERHEADS (BANGSTICKS)
 
OLD 770 SCRAPES
NEW 770 SCRAPES
 
OLD 781 WATER PUMP,SAND SHRIMP
NEW 781 WATER PUMP,SAND SHRIMP
 
OLD 785 BARGE KELP
NEW 785 BARGE KELP
 
OLD 802 DREDGE CLAM HYDRAULIC
NEW 802 DREDGE CLAM HYDRAULIC
 
OLD 803 DREDGE CLAM
NEW 803 DREDGE CLAM
 
OLD 804 DREDGE CONCH
NEW 804 DREDGE CONCH
 
OLD 805 DREDGE CRAB
NEW 805 DREDGE CRAB
 
OLD 810 DREDGE MUSSEL
NEW 810 DREDGE MUSSEL
 
OLD 815 DREDGE OYSTER, COMMON
NEW 815 DREDGE OYSTER, COMMON
 
OLD 820 DREDGE OYSTER, SUCTION
NEW 820 DREDGE OYSTER, SUCTION
 
OLD 823 DREDGE SCALLOP, BAY
NEW 823 DREDGE SCALLOP, BAY
 
OLD 825 DREDGE SCALLOP, SEA
NEW 825 DREDGE SCALLOP, SEA
 
OLD 827 DREDGE URCHIN, SEA
NEW 827 DREDGE URCHIN, SEA
 
OLD 830 DREDGE OTHER
NEW 830 DREDGE OTHER
 
OLD 840 TONGS AND GRABS, OYSTER
NEW 840 TONGS AND GRABS, OYSTER
 
OLD 841 TONGS PATENT, OYSTER
NEW 841 TONGS PATENT, OYSTER
 
OLD 845 TONGS AND GRABS, OTHER
NEW 845 TONGS AND GRABS, OTHER
 
OLD 846 TONGS PATENT, CLAM OTHER
NEW 846 TONGS PATENT, CLAM OTHER
 
OLD 853 RAKES, OYSTER
NEW 853 RAKES, OYSTER
 
OLD 855 RAKES, OTHER
NEW 855 RAKES, OTHER
 
OLD 860 HOES
NEW 860 HOES
 
OLD 865 FORKS
NEW 865 FORKS
 
OLD 870 SHOVELS
NEW 870 SHOVELS
 
OLD 875 PICKS
NEW 875 PICKS
 
OLD 880 BRUSH TRAP
NEW 880 BRUSH TRAP
 
OLD 890 CROWFOOT BARS
NEW 890 CROWFOOT BARS
 
OLD 895 FROG GRABS
NEW 895 FROG GRABS
 
OLD 925 HOOKS, SPONGE
NEW 925 HOOKS, SPONGE
 
OLD 930 HOOKS, ABALONE
NEW 930 HOOKS, ABALONE
 
OLD 935 HOOKS, OTHER
NEW 935 HOOKS, OTHER
 
OLD 941 DIVING OUTFITS, ABALONE
NEW 941 DIVING OUTFITS, ABALONE
 
OLD 942 DIVING OUTFITS, SPONGE
NEW 942 DIVING OUTFITS, SPONGE
 
OLD 943 DIVING OUTFITS, OTHER
NEW 943 DIVING OUTFITS, OTHER
 
OLD 951 BY HAND, OYSTER
NEW 951 BY HAND, OYSTER
 
OLD 955 BY HAND, OTHER
NEW 955 BY HAND, OTHER
 
OLD 966 OTHER GEAR, HAWAII
NEW 966 OTHER GEAR, HAWAII
 
OLD 967 VARIOUS GEAR, FISHPONDS HAWAII
NEW 967 VARIOUS GEAR, FISHPONDS HAWAII
 
OLD 989 UNSPECIFIED GEAR
NEW 989 UNSPECIFIED GEAR
 
OLD 999 COMBINED GEARS
NEW 999 COMBINED GEARS
 
 
4 OLD_FIELD_DROPPED SEFSC TIP_TIP13 GEAR_NUM_TYPE OPTIONAL NUMBER(1)
- OLD_FIELD_DROPPED - - - - -
- OLD_FIELD_DROPPED Although gear_num_type was dropped, it played a vital role in loading the effort table. It was used to split the 3 data items in the old tip (gear_num, gear_qty, gear_other) into the 7 new data items in tiponline (gear_qty, gear_use_freq, gear_size, gear_avg_info, gear_number_set, gear_total_line_length, gear_avg_miles_per_set)
 
5 NAME_CHANGE SEFSC TIP_TIP13 GEAR_NUM OPTIONAL NUMBER(4)
13 NAME_CHANGE TIPONLINE INTERVIEW GEAR_QTY FOR MOST GEARS OR GEAR_NUMBER_SET OR GEAR_AVG_MILES_PER_SET OR GEAR_USE_FREQ OPTIONAL NUMBER
13 NAME_CHANGE Gear_num_type transforms gear_data.
GEAR_NUM_TYPE TYPES OF GEAR OLD GEAR PARAMETER NEW GEAR PARAMETER
1 OTTER TRAWLS BEAM TRAWLS PARANZELLA NETS SEFSC.TIP_TIP13.GEAR_NUM TIPONLINE.EFFORT.GEAR_QTY
2 FISH POTS SHELLFISH TRAPS POTS SEFSC.TIP_TIP13.GEAR_NUM TIPONLINE.EFFORT.GEAR_NUM_SET
3 PURSE SEINES HAUL SEINS STOP SEINES GILL NET TRAMMEL NET LAMPARA NETS SEFSC.TIP_TIP13.GEAR_NUM TIPONLINE.EFFORT.GEAR_QTY
4 HAND LINES TROLLING GEAR SEFSC.TIP_TIP13.GEAR_NUM TIPONLINE.EFFORT.GEAR_QTY
5 LONG LINES BOTTOM LINES SURFACE LINES SEFSC.TIP_TIP13.GEAR_NUM TIPONLINE.EFFORT.GEAR_AVG_MILES_PER_SET
6 DIVERS SEFSC.TIP_TIP13.GEAR_NUM TIPONLINE.EFFORT.GEAR_USE_FREQ
 
6 OLD_FIELD_DROPPED SEFSC TIP_TIP13 GEAR_QTY_TYPE OPTIONAL NUMBER(1)
- OLD_FIELD_DROPPED - - - - -
- OLD_FIELD_DROPPED Since old gear parameters were assigned to new gear parameters with more descriptive names this old field was no longer needed.
 
7 NAME_CHANGE SEFSC TIP_TIP13 GEAR_QTY OPTIONAL NUMBER(4)
10 NAME_CHANGE TIPONLINE INTERVIEW GEAR_TOTAL_LINE_LENGTH OR GEAR_QTY OR GEAR_AVG_INFO OPTIONAL NUMBER
10 NAME_CHANGE Gear_num_type transforms gear_data.
GEAR_NUM_TYPE TYPES OF GEAR OLD GEAR PARAMETER NEW GEAR PARAMETER
1 OTTER TRAWLS BEAM TRAWLS PARANZELLA NETS SEFSC.TIP_TIP13.GEAR_QTY TIPONLINE.EFFORT.GEAR_TOTAL_LINE_LENGTH
2 FISH POTS SHELLFISH TRAPS POTS SEFSC.TIP_TIP13.GEAR_QTY TIPONLINE.EFFORT.GEAR_QTY
3 PURSE SEINES HAUL SEINS STOP SEINES GILL NET TRAMMEL NET LAMPARA NETS SEFSC.TIP_TIP13.GEAR_QTY TIPONLINE.EFFORT.GEAR_AVG_INFO
4 HAND LINES TROLLING GEAR SEFSC.TIP_TIP13.GEAR_QTY TIPONLINE.EFFORT.GEAR_AVG_INFO
5 LONG LINES BOTTOM LINES SURFACE LINES SEFSC.TIP_TIP13.GEAR_QTY TIPONLINE.EFFORT.GEAR_AVG_INFO
6 DIVERS SEFSC.TIP_TIP13.GEAR_QTY TIPONLINE.EFFORT.GEAR_QTY
 
8 NAME_CHANGE SEFSC TIP_TIP13 GEAR_OTHER OPTIONAL NUMBER(6,2)
31 NAME_CHANGE TIPONLINE EFFORT GEAR_SIZE OPTIONAL NUMBER
31 NAME_CHANGE Gear_num_type transforms gear_data.
GEAR_NUM_TYPE TYPES OF GEAR OLD GEAR PARAMETER NEW GEAR PARAMETER
1 OTTER TRAWLS BEAM TRAWLS PARANZELLA NETS SEFSC.TIP_TIP13.GEAR_OTHER TIPONLINE.EFFORT.GEAR_SIZE
2 FISH POTS SHELLFISH TRAPS POTS SEFSC.TIP_TIP13.GEAR_OTHER TIPONLINE.EFFORT.GEAR_SIZE
3 PURSE SEINES HAUL SEINS STOP SEINES GILL NET TRAMMEL NET LAMPARA NETS SEFSC.TIP_TIP13.GEAR_OTHER TIPONLINE.EFFORT.GEAR_SIZE
5 LONG LINES BOTTOM LINES SURFACE LINES SEFSC.TIP_TIP13.GEAR_OTHER TIPONLINE.EFFORT.GEAR_USE_FREQ
 
9 UNCHANGED SEFSC TIP_TIP13 SOAKTIME OPTIONAL NUMBER(7,1)
18 UNCHANGED TIPONLINE EFFORT SOAKTIME OPTIONAL NUMBER
18 UNCHANGED Unchanged.
 
10 NAME_CHANGE SEFSC TIP_TIP13 AREA_FISHED OPTIONAL NUMBER(7,1)
30 NAME_CHANGE TIPONLINE EFFORT AREA_ID OR LAT_DEGREE LONG_DEGREE AREA_QUADRANT OPTIONAL NUMBER
30 NAME_CHANGE Agencies are allowed to choose their own area code tables. For the historical tip data, we used TIPONLINE.noaa_area to code our areas. Like all area tables, it has the column, STANDARD_AREA_ID, that gives the standard_area_code so that all participants can understand the area where fishing occurred.   The old area_fished is assigned to area_id for area_fished_types of 2, 3, 5 or 6. For area fished_type of 4, area_id is not filled in, only some latitude, longitude information. For example, 3745.4 would be recoded as: LAT_DEGREE    = 37 LONG_DEGREE   = 45 AREA_QUADRANT = 4. If the number to the right of the decimal is not 1, 2, 3 or 4, then AREA_QUADRANT is not filled in.
 
11 NAME_CHANGE SEFSC TIP_TIP13 START_DEPTH OPTIONAL NUMBER(6,1)
21 NAME_CHANGE TIPONLINE EFFORT MIN_DEPTH OPTIONAL NUMBER
21 NAME_CHANGE The name was changed.
 
12 NAME_CHANGE SEFSC TIP_TIP13 END_DEPTH OPTIONAL NUMBER(6,1)
12 NAME_CHANGE TIPONLINE EFFORT END_DEPTH OPTIONAL NUMBER
12 NAME_CHANGE The name was changed.
 
13 CODE_CHANGE SEFSC TIP_TIP13 AREA_FISHED_TYPE OPTIONAL NUMBER(1)
27 CODE_CHANGE TIPONLINE EFFORT REGION_ID OPTIONAL NUMBER
- OLD_FIELD_DROPPED There is no direct equivalent to area_fished_type in the new TIPONLINE system. However, the area_fished_type was used to populate another column under some circumstances. Area Fished Type 2 => region_id 5 (GULF) Area Fished Type 3 => region_id 4 (SOUTH ATLANTIC) Area Fished Type 5 => region_id 9 (PUERTO RICO) Area Fished Type 6 => region_id 9 (PUERTO RICO) The value must match id in the table Tiponline.Region.
 
- NEW_FIELD_ADDED - - - - -
1 NEW_FIELD_ADDED TIPONLINE EFFORT ID MANDATORY NUMBER
1 NEW_FIELD_ADDED New field added. TIPONLINE.Effort.Id is a sequential number generated when the effort record is created. In sefsc.tip_tip13, sequence_number and record_type together identified a single effort record. In TIPONLINE, this single field identifies a particular Effort record.
 
- NEW_FIELD_ADDED - - - - -
2 NEW_FIELD_ADDED TIPONLINE EFFORT INTERVIEW_ID MANDATORY NUMBER
2 NEW_FIELD_ADDED New field added. TIPONLINE.Interview.Id is a sequential number generated when the interview record is created. That number is assigned to TIPONLINE.Effort.Interview_Id to relate this effort to a particular interview. There is also an Interview_id field in TIPONLINE.Landing, TIPONLINE.Sample and TIPONLINE.Observation. The field is shown as the last digits on the Interview Number after the characters for the state code.
 
- NEW_FIELD_ADDED - - - - -
4 NEW_FIELD_ADDED TIPONLINE EFFORT CREATED_DATE MANDATORY DATE
4 NEW_FIELD_ADDED New field added. Whenever a record is created, the date and time of the record creation is automatically recorded in this field. Not shown on the screen.
 
- NEW_FIELD_ADDED - - - - -
5 NEW_FIELD_ADDED TIPONLINE EFFORT CREATED_BY_USER_ID MANDATORY VARCHAR2(20)
5 NEW_FIELD_ADDED New field added. Whenever a record is created, the Oracle user id is automatically recorded in this field. Not shown on screen.
 
- NEW_FIELD_ADDED - - - - -
7 NEW_FIELD_ADDED TIPONLINE EFFORT LAT_SECOND OPTIONAL NUMBER
7 NEW_FIELD_ADDED New field added. It does not exist in the historical data.
 
- NEW_FIELD_ADDED - - - - -
8 NEW_FIELD_ADDED TIPONLINE EFFORT LONG_MINUTE OPTIONAL NUMBER
8 NEW_FIELD_ADDED New field added. It does not exist in the historical data.
 
- NEW_FIELD_ADDED - - - - -
9 NEW_FIELD_ADDED TIPONLINE EFFORT AREA_QUADRANT OPTIONAL NUMBER
9 NEW_FIELD_ADDED New field added. It does not exist in the historical data.
 
- NEW_FIELD_ADDED - - - - -
11 NEW_FIELD_ADDED TIPONLINE EFFORT LONG_HEMISPHERE OPTIONAL VARCHAR2(1)
11 NEW_FIELD_ADDED New field added. It does not exist in the historical data. We assume long_degree is 'W'.
 
- NEW_FIELD_ADDED - - - - -
15 NEW_FIELD_ADDED TIPONLINE EFFORT LONG_SECOND OPTIONAL NUMBER
15 NEW_FIELD_ADDED New field added. It does not exist in the historical data.
 
- NEW_FIELD_ADDED - - - - -
19 NEW_FIELD_ADDED TIPONLINE EFFORT AREA_10_MIN OPTIONAL NUMBER
19 NEW_FIELD_ADDED New field added. It does not exist in the historical data.
 
- NEW_FIELD_ADDED - - - - -
22 NEW_FIELD_ADDED TIPONLINE EFFORT DISTANCE_TO_SHORE_MILES OPTIONAL NUMBER
22 NEW_FIELD_ADDED New field added. It does not exist in the historical data.
 
- NEW_FIELD_ADDED - - - - -
23 NEW_FIELD_ADDED TIPONLINE EFFORT LAT_HEMISPHERE OPTIONAL VARCHAR2(1)
23 NEW_FIELD_ADDED New field added. It does not exist in the historical data. We assume long_degree is 'N'.
 
- NEW_FIELD_ADDED - - - - -
24 NEW_FIELD_ADDED TIPONLINE EFFORT COMMENTS OPTIONAL VARCHAR2(4000)
24 NEW_FIELD_ADDED New field added. It does not exist in the historical data.
 
- NEW_FIELD_ADDED - - - - -
14 NEW_FIELD_ADDED TIPONLINE INTERVIEW ID MANDATORY NUMBER
14 NEW_FIELD_ADDED New field added. It does not exist in the historical data.
 
- NEW_FIELD_ADDED - - - - -
28 NEW_FIELD_ADDED TIPONLINE EFFORT MODIFIED_BY_USER_ID OPTIONAL VARCHAR2(20)
28 NEW_FIELD_ADDED New field added. This field is comparable to sefsc.tip_changes.userid. However, sefsc.tip_tip13 does not record such information. The new TIPONLINE program will automatically record the Oracle user id of the person updating the record. Not shown on screen.
 
- NEW_FIELD_ADDED - - - - -
29 NEW_FIELD_ADDED TIPONLINE EFFORT MODIFIED_DATE OPTIONAL DATE
29 NEW_FIELD_ADDED New field added. This field is comparable to sefsc.tip_changes.changedate. However, sefsc.tip_tip11 does not record such information. The new TIPONLINE program will automatically record the date and time the record is updated. Not shown on screen.
 
- NEW_FIELD_ADDED - - - - -
32 NEW_FIELD_ADDED TIPONLINE EFFORT STANDARD_GEAR_ID OPTIONAL VARCHAR2(20)
32 NEW_FIELD_ADDED New field added. This field is automatically filled in by a trigger using information provided by the gear_code. Not shown on the screen. The value must match id in the table Tiponline.Standard_Gear.
 
- NEW_FIELD_ADDED - - - - -
33 NEW_FIELD_ADDED TIPONLINE EFFORT STANDARD_AREA_ID OPTIONAL NUMBER
33 NEW_FIELD_ADDED New field added. This field is automatically filled in by a trigger using information provided by the area function. Not shown on the screen. The value must match id in the table Tiponline.Standard_Area.
 

SEFSC.TIP_TIP21 FILLS TIPONLINE.LANDING

COLUMN ORDER TRANSFORMATION OLD: OWNER TABLE COLUMN NAME MANDATORY? TYPE
COLUMN ORDER TRANSFORMATION NEW: OWNER TABLE COLUMN NAME MANDATORY? TYPE
1 OLD_FIELD_DROPPED SEFSC TIP_TIP21 RECORD_TYPE MANDATORY VARCHAR2(2)
- OLD_FIELD_DROPPED - - - - -
- OLD_FIELD_DROPPED The field was not needed and was dropped.
 
2 OLD_FIELD_DROPPED SEFSC TIP_TIP21 SEQUENCE_NUMBER MANDATORY VARCHAR2(11)
- OLD_FIELD_DROPPED - - - - -
- OLD_FIELD_DROPPED Although sequence_number is not carried in the new TIPONLINE data there is a new field, INTERVIEW_ID, which relates all data back to the original interview record. TIPONLINE.Interview.Id is a sequential number generated when the interview record is created. That number is assigned to TIPONLINE.Landing.Interview_Id to relate this landing record to a particular interview.
 
3 UNCHANGED SEFSC TIP_TIP21 REPLICATE MANDATORY NUMBER(2)
3 UNCHANGED TIPONLINE LANDING REPLICATE OPTIONAL NUMBER(2)
3 UNCHANGED The replicate was included for the historical data in order to relate each sefsc.tip_tip21 record to an individual tiponline.landing record. It is not shown on screen.
 
4 FIELD_SPLIT SEFSC TIP_TIP21 SIZE_CODE OPTIONAL NUMBER(1)
4 FIELD_SPLIT TIPONLINE LANDING SPECIES_SIZE_ID MANDATORY NUMBER
4 FIELD_SPLIT The old size codes were actually a mixture of sizes, conditions, grade and sex information. The new system strives to have only 1 type of information in a single field. The value must match id in the table Tiponline.Species_Size. For size code, this is a two step process. First the program tries to determine the size information from the size code.
4 FIELD_SPLIT
Old? Code Description
OLD 1 UNSORTED(GRADE 1 TUNA)
NEW 50 MIXED/UNSIZED
 
OLD 2 SMALL(GRADE 2 TUNA)
NEW 52 SMALL OR #3
 
OLD 3 MEDIUM(GRADE 3 TUNA)
NEW 48 MEDIUM OR #2
 
OLD 4 LARGE
NEW 46 LARGE OR #1
 
OLD 5 JUMBO
NEW 69 JUMBO
 
OLD 6 BAIT(SCRAP)
NEW 41 FISH/SHRIMP, BAIT, UNCL
 
OLD 7 DISCARDS
NEW 53 UNKNOWN
 
OLD 9 TUNA UNGRADED
NEW 53 UNKNOWN
 
OLD 01 PIECES OR CHUNKS
NEW 53 UNKNOWN
 
OLD 02 FINS
NEW 53 UNKNOWN
 
OLD 03 FILLET
NEW 53 UNKNOWN
 
OLD 11 LOUISIANA < 50 LBS.
NEW 99 LOUISIANA < 50 LBS.
 
OLD 12 LOUISIANA 1- 10 LBS.
NEW 103 LOUISIANA 1-10 LBS
 
OLD 13 UNSORTED > 100 LBS.
NEW 50 MIXED/UNSIZED
 
OLD 15 LA. SWD FISH 100-999 LBS.
NEW 73 LARGE (100-199 LBS)
 
OLD 16 LOUISIANA 1-6 LBS
NEW 104 LOUISIANA 1-6 LBS
 
OLD 17 LOUISIANA 6-15 LBS.
NEW 109 LOUISIANA 6-15 LBS.
 
OLD 19 SORTED LATER
NEW 50 MIXED/UNSIZED
 
OLD 1G GRADE 1
NEW 46 LARGE OR #1
 
OLD 1L UNSORTED LIGHT
NEW 50 MIXED/UNSIZED
 
OLD 21 LOUISIANA 0- 1 LB.
NEW 101 LOUISIANA 0-1 LB.
 
OLD 22 LOUISIANA 0- 2 LB.
NEW 102 LOUISIANA 0-2 LB.
 
OLD 2G GRADE 2
NEW 48 MEDIUM OR #2
 
OLD 2L SMALL LIGHT
NEW 52 SMALL OR #3
 
OLD 31 LOUISIANA 2- 4 LB.
NEW 105 LOUISIANA 2-4 LB.
 
OLD 32 LA. SWD FISH 26-49 LBS.
NEW 52 SMALL OR #3
 
OLD 33 LOUISIANA 4-6 LBS.
NEW 107 LOUISIANA 4-6 LBS.
 
OLD 34 LOUISIANA 6-10 LBS.
NEW 108 LOUISIANA 6-10 LBS.
 
OLD 3C MEDIUM COOKED
NEW 48 MEDIUM OR #2
 
OLD 3G GRADE 3
NEW 52 SMALL OR #3
 
OLD 3L MEDIUM LIGHT
NEW 48 MEDIUM OR #2
 
OLD 3U MEDIUM UNCOOKED
NEW 48 MEDIUM OR #2
 
OLD 41 LOUISIANA 4-10 LB.
NEW 106 LOUISIANA 4-10 LB.
 
OLD 42 LA. SWD FISH 49-99 LBS.
NEW 48 MEDIUM OR #2
 
OLD 4C LARGE COOKED
NEW 46 LARGE OR #1
 
OLD 4L LARGE LIGHT
NEW 46 LARGE OR #1
 
OLD 4U LARGE UNCOOKED
NEW 46 LARGE OR #1
 
OLD 51 LOUISIANA > 10 LBS.
NEW 100 LOUISIANA > 10 LBS.
 
OLD 52 LA. SWD FISH 100-200 LBS.
NEW 46 LARGE OR #1
 
OLD 5C JUMBO COOKED
NEW 69 JUMBO
 
OLD 5L JUMBO LIGHT
NEW 69 JUMBO
 
OLD 5U JUMBO UNCOOKED
NEW 69 JUMBO
 
OLD 60 SHRIMP 10-15
NEW 42 COUNT
 
OLD 61 SHRIMP 16-20
NEW 42 COUNT
 
OLD 62 SHRIMP 21-25
NEW 42 COUNT
 
OLD 63 SHRIMP 26-30
NEW 42 COUNT
 
OLD 64 SHRIMP 31-35
NEW 42 COUNT
 
OLD 65 SHRIMP 36-40
NEW 42 COUNT
 
OLD 66 SHRIMP 41-50
NEW 42 COUNT
 
OLD 67 SHRIMP 51-60
NEW 42 COUNT
 
OLD 68 SHRIMP 61-70
NEW 42 COUNT
 
OLD 69 SHRIMP 71-80
NEW 42 COUNT
 
OLD 6C COLOSSAL COOKED
NEW 44 GIANT/COLOSSAL
 
OLD 6L COLOSSAL LIGHT
NEW 44 GIANT/COLOSSAL
 
OLD 6U COLOSSAL UNCOOKED
NEW 44 GIANT/COLOSSAL
 
OLD 70 SHRIMP 81-100
NEW 42 COUNT
 
OLD 71 DISCARDS(LIVE)
NEW 53 UNKNOWN
 
OLD 72 DISCARDS(DEAD)
NEW 53 UNKNOWN
 
OLD 73 SHRIMP 100+
NEW 42 COUNT
 
OLD 80 TOURN. DISP. UNKNOWN
NEW 53 UNKNOWN
 
OLD 81 TOURN. ENTERED
NEW 53 UNKNOWN
 
OLD 82 TOURNAMENT, SOLD
NEW 53 UNKNOWN
 
OLD 83 TOURN., PERSONAL USE
NEW 53 UNKNOWN
 
OLD 84 TOURN., DISCARDED
NEW 53 UNKNOWN
 
OLD 85 TOURN., DISP. OTHER
NEW 53 UNKNOWN
 
OLD 91 BOTTOMFISH
NEW 53 UNKNOWN
 
OLD 92 MISCELLANEOUS FOOD FISH
NEW 53 UNKNOWN
 
OLD 93 CORE-G.AMBERJACK HEADED&GUTTED
NEW 53 UNKNOWN
 
OLD 94 LOG-G.AMBERJACK HDD,TLD,GTTD
NEW 53 UNKNOWN
 
OLD 95 MALE,UNC.
NEW 53 UNKNOWN
 
OLD 96 FEMALE,UNC.
NEW 53 UNKNOWN
 
OLD 97 NO ROE,RAIL,OR RETURNS
NEW 53 UNKNOWN
 
4 FIELD_SPLIT If the previous size code was still UNKNOWN, a second lookup tries to get some size information from the 4 digit NMFS species code.
4 FIELD_SPLIT
Old? Code Description
OLD 0517 BUTTERFISH,SUPERSMALL
NEW 66 EXTRA SMALL
 
OLD 0518 BUTTERFISH,SUPER SUPER SMALL
NEW 92 SUPER SUPER SMALL
 
OLD 0810 ATLANTIC COD
NEW 69 JUMBO
 
OLD 1208 SUMMER FLOUNDER (FLUKE)
NEW 69 JUMBO
 
OLD 1218 FLOUNDER,ATLANTIC,WITCH,JUMBO
NEW 69 JUMBO
 
OLD 2211 MENHADEN,FOR BAIT (DISP CODE
NEW 41 FISH/SHRIMP, BAIT, UNCL
 
OLD 3289 SCUPS OR PORGIES, SPARIDAE
NEW 69 JUMBO
 
OLD 5290 FINFISHES,UNC,BAIT,ANIMAL FOO
NEW 41 FISH/SHRIMP, BAIT, UNCL
 
OLD 7179 CRAB,STONE (JUMBO CLAWS)
NEW 69 JUMBO
 
OLD 7275 LOBSTER,AMERICAN,JUMBO
NEW 69 JUMBO
 
OLD 7381 SHRIMP,MARINE,OTHER
NEW 41 FISH/SHRIMP, BAIT, UNCL
 
OLD 7472 CLAM,ATLANTIC,LITTLENECKS
NEW 27 LITTLE NECK
 
OLD 7473 CLAM,ATLANTIC,MIDDLENECKS
NEW 29 MIDDLE NECK
 
OLD 7474 CLAM,ATLANTIC,TOPNECKS
NEW 32 TOP NECK
 
OLD 7475 CLAM,CHERRY
NEW 25 CHERRY
 
OLD 7476 CLAM,CHOWDER
NEW 24 CHOWDER
 
OLD 7486 PACIFIC LITTLENECK
NEW 27 LITTLE NECK
 
 
4 FIELD_SPLIT SEFSC TIP_TIP21 SIZE_CODE OPTIONAL NUMBER(1)
13 FIELD_SPLIT TIPONLINE LANDING GRADE_ID OPTIONAL NUMBER
13 FIELD_SPLIT The old size codes were actually a mixture of sizes, conditions, grade and sex information. The new system strives to have only 1 type of information in a single field. For size code, this is a two step process. First the program tries to determine the grade information from the size code.
13 FIELD_SPLIT
Old? Code Description
OLD 01 PIECES OR CHUNKS
NEW 0 NO GRADE
 
OLD 02 FINS
NEW 0 NO GRADE
 
OLD 03 FILLET
NEW 0 NO GRADE
 
OLD 1 UNSORTED(GRADE 1 TUNA)
NEW 1 #1 IF TUNA
 
OLD 11 LOUISIANA < 50 LBS.
NEW 0 NO GRADE
 
OLD 12 LOUISIANA 1- 10 LBS.
NEW 0 NO GRADE
 
OLD 13 UNSORTED > 100 LBS.
NEW 0 NO GRADE
 
OLD 15 LA. SWD FISH 100-999 LBS.
NEW 0 NO GRADE
 
OLD 16 LOUISIANA 1-6 LBS
NEW 0 NO GRADE
 
OLD 17 LOUISIANA 6-15 LBS.
NEW 0 NO GRADE
 
OLD 19 SORTED LATER
NEW 0 NO GRADE
 
OLD 1G GRADE 1
NEW 1 #1 IF TUNA
 
OLD 1L UNSORTED LIGHT
NEW 0 NO GRADE
 
OLD 2 SMALL(GRADE 2 TUNA)
NEW 2 #2 IF TUNA
 
OLD 21 LOUISIANA 0- 1 LB.
NEW 0 NO GRADE
 
OLD 22 LOUISIANA 0- 2 LB.
NEW 0 NO GRADE
 
OLD 2G GRADE 2
NEW 2 #2 IF TUNA
 
OLD 2L SMALL LIGHT
NEW 0 NO GRADE
 
OLD 3 MEDIUM(GRADE 3 TUNA)
NEW 3 #3 IF TUNA
 
OLD 31 LOUISIANA 2- 4 LB.
NEW 0 NO GRADE
 
OLD 32 LA. SWD FISH 26-49 LBS.
NEW 0 NO GRADE
 
OLD 33 LOUISIANA 4-6 LBS.
NEW 0 NO GRADE
 
OLD 34 LOUISIANA 6-10 LBS.
NEW 0 NO GRADE
 
OLD 3C MEDIUM COOKED
NEW 0 NO GRADE
 
OLD 3G GRADE 3
NEW 3 #3 IF TUNA
 
OLD 3L MEDIUM LIGHT
NEW 0 NO GRADE
 
OLD 3U MEDIUM UNCOOKED
NEW 0 NO GRADE
 
OLD 4 LARGE
NEW 0 NO GRADE
 
OLD 41 LOUISIANA 4-10 LB.
NEW 0 NO GRADE
 
OLD 42 LA. SWD FISH 49-99 LBS.
NEW 0 NO GRADE
 
OLD 4C LARGE COOKED
NEW 0 NO GRADE
 
OLD 4L LARGE LIGHT
NEW 0 NO GRADE
 
OLD 4U LARGE UNCOOKED
NEW 0 NO GRADE
 
OLD 51 LOUISIANA > 10 LBS.
NEW 0 NO GRADE
 
OLD 52 LA. SWD FISH 100-200 LBS.
NEW 0 NO GRADE
 
OLD 5C JUMBO COOKED
NEW 0 NO GRADE
 
OLD 5L JUMBO LIGHT
NEW 0 NO GRADE
 
OLD 5U JUMBO UNCOOKED
NEW 0 NO GRADE
 
OLD 6 BAIT(SCRAP)
NEW 0 NO GRADE
 
OLD 60 SHRIMP 10-15
NEW 0 NO GRADE
 
OLD 61 SHRIMP 16-20
NEW 0 NO GRADE
 
OLD 62 SHRIMP 21-25
NEW 0 NO GRADE
 
OLD 63 SHRIMP 26-30
NEW 0 NO GRADE
 
OLD 64 SHRIMP 31-35
NEW 0 NO GRADE
 
OLD 65 SHRIMP 36-40
NEW 0 NO GRADE
 
OLD 66 SHRIMP 41-50
NEW 0 NO GRADE
 
OLD 67 SHRIMP 51-60
NEW 0 NO GRADE
 
OLD 68 SHRIMP 61-70
NEW 0 NO GRADE
 
OLD 69 SHRIMP 71-80
NEW 0 NO GRADE
 
OLD 6C COLOSSAL COOKED
NEW 0 NO GRADE
 
OLD 6L COLOSSAL LIGHT
NEW 0 NO GRADE
 
OLD 6U COLOSSAL UNCOOKED
NEW 0 NO GRADE
 
OLD 7 DISCARDS
NEW 21 DISCARD (UNKNOWN)
 
OLD 70 SHRIMP 81-100
NEW 0 NO GRADE
 
OLD 71 DISCARDS(LIVE)
NEW 19 DISCARD (LIVE)
 
OLD 72 DISCARDS(DEAD)
NEW 20 DISCARD (DEAD)
 
OLD 73 SHRIMP 100+
NEW 0 NO GRADE
 
OLD 80 TOURN. DISP. UNKNOWN
NEW 0 NO GRADE
 
OLD 81 TOURN. ENTERED
NEW 23 TOURNAMENT ENTRY
 
OLD 82 TOURNAMENT, SOLD
NEW 0 NO GRADE
 
OLD 83 TOURN., PERSONAL USE
NEW 24 PERSONAL USE
 
OLD 84 TOURN., DISCARDED
NEW 21 DISCARD (UNKNOWN)
 
OLD 85 TOURN., DISP. OTHER
NEW 0 NO GRADE
 
OLD 9 TUNA UNGRADED
NEW 0 NO GRADE
 
OLD 91 BOTTOMFISH
NEW 0 NO GRADE
 
OLD 92 MISCELLANEOUS FOOD FISH
NEW 0 NO GRADE
 
OLD 93 CORE-G.AMBERJACK HEADED&GUTTED
NEW 0 NO GRADE
 
OLD 94 LOG-G.AMBERJACK HDD,TLD,GTTD
NEW 0 NO GRADE
 
OLD 95 MALE,UNC.
NEW 0 NO GRADE
 
OLD 96 FEMALE,UNC.
NEW 0 NO GRADE
 
OLD 97 NO ROE,RAIL,OR RETURNS
NEW 0 NO GRADE
 
13 FIELD_SPLIT If the previous grade name was NO GRADE, a second lookup tries to get some grade information from the 4 digit NMFS species code.
13 FIELD_SPLIT
Old? Code Description
OLD 5510 CATFISH,AQUACULTURE
NEW 22 AQUACULTURE
 
OLD 5530 TROUT,BROWN,AQUACULTURE
NEW 22 AQUACULTURE
 
OLD 5531 BROOK TROUT
NEW 22 AQUACULTURE
 
OLD 5532 TROUT,RAINBOW,AQUACULTURE
NEW 22 AQUACULTURE
 
OLD 5580 SALMON,KING,AQUACULTURE
NEW 22 AQUACULTURE
 
OLD 5581 SALMON,CHUM,AQUACULTURE
NEW 22 AQUACULTURE
 
OLD 5582 SALMON,PINK,AQUACULTURE
NEW 22 AQUACULTURE
 
OLD 5583 SALMON,SOCKEYE,AQUACULTURE
NEW 22 AQUACULTURE
 
OLD 5584 SALMON,COHO,AQUACULTURE
NEW 22 AQUACULTURE
 
OLD 5585 TROUT,CUTTHROAT,AQUACULTURE
NEW 22 AQUACULTURE
 
OLD 5586 SALMON,ATLANTIC,AQUACULTURE
NEW 22 AQUACULTURE
 
OLD 5587 SALMON AND TROUT,SALMONIDAE
NEW 22 AQUACULTURE
 
OLD 9560 SHRIMP,AQUACULTURE
NEW 22 AQUACULTURE
 
 
5 OLD_FIELD_DROPPED SEFSC TIP_TIP21 SPECIES_CODE OPTIONAL VARCHAR2(10)
- OLD_FIELD_DROPPED - - - - -
- OLD_FIELD_DROPPED The species code was not loaded into the new system, the NODC code was used instead. However, some of the extra information provided in the 4 digit NMFS codes was passed to new landing fields.
 
6 CODE_CHANGE SEFSC TIP_TIP21 NODC_CODE OPTIONAL VARCHAR2(10)
4 CODE_CHANGE TIPONLINE LANDING MARKET_SPECIES_ID MANDATORY VARCHAR2(20)
4 CODE_CHANGE In addition to the name change, the 10 digit NODC code was changed to a 12 digit NODC code. Although a function could allow last 2 digits beside 00, all historical data matched the first 10 digits and had the last 2 digits as 00.
 
7 NAME_CHANGE SEFSC TIP_TIP21 GEAR_STAT OPTIONAL VARCHAR2(3)
6 NAME_CHANGE TIPONLINE LANDING GEAR_CODE MANDATORY VARCHAR2(20)
6 NAME_CHANGE The same codes were used.
6 NAME_CHANGE
Old? Code Description
OLD 000 NOT CODED
NEW 0 NOT CODED
 
OLD 020 HAUL SEINES, BEACH
NEW 20 HAUL SEINES, BEACH
 
OLD 030 HAUL SEINES, LONG
NEW 30 HAUL SEINES, LONG
 
OLD 032 HAUL SEINES, LONG(DANISH)
NEW 32 HAUL SEINES, LONG(DANISH)
 
OLD 040 STOP SEINES
NEW 40 STOP SEINES
 
OLD 050 STOP NETS
NEW 50 STOP NETS
 
OLD 100 ENCIRCLINLING NETS (PURSE)
NEW 100 ENCIRCLINLING NETS (PURSE)
 
OLD 103 PURSE SEINES, ANCHOVY
NEW 103 PURSE SEINES, ANCHOVY
 
OLD 105 PURSE SEINES, BARRACUDA
NEW 105 PURSE SEINES, BARRACUDA
 
OLD 110 PURSE SEINES, HERRING
NEW 110 PURSE SEINES, HERRING
 
OLD 120 PURSE SEINES, MACKEREL
NEW 120 PURSE SEINES, MACKEREL
 
OLD 125 PURSE SEINES, MENHADEN
NEW 125 PURSE SEINES, MENHADEN
 
OLD 130 PURSE SEINES, SALMON
NEW 130 PURSE SEINES, SALMON
 
OLD 135 PURSE SEINES, SARDINE
NEW 135 PURSE SEINES, SARDINE
 
OLD 140 PURSE SEINES, TUNA
NEW 140 PURSE SEINES, TUNA
 
OLD 145 PURSE SEINES, OTHER
NEW 145 PURSE SEINES, OTHER
 
OLD 150 NETS UNC, HAWAII
NEW 150 NETS UNC, HAWAII
 
OLD 151 NETS, EXCLUDING TRAWLS
NEW 151 NETS, EXCLUDING TRAWLS
 
OLD 155 LAMPARA & RING NETS, MACKEREL
NEW 155 LAMPARA & RING NETS, MACKEREL
 
OLD 160 LAMPARA & RING NETS, SARDINE
NEW 160 LAMPARA & RING NETS, SARDINE
 
OLD 165 LAMPARA & RING NETS, SQUID
NEW 165 LAMPARA & RING NETS, SQUID
 
OLD 170 LAMPARA & RING NETS, TUNA
NEW 170 LAMPARA & RING NETS, TUNA
 
OLD 175 LAMPARA & RING NETS, OTHER
NEW 175 LAMPARA & RING NETS, OTHER
 
OLD 180 BAG NETS
NEW 180 BAG NETS
 
OLD 185 PARANELLA NETS
NEW 185 PARANELLA NETS
 
OLD 189 BUTTERFLY NETS
NEW 189 BUTTERFLY NETS
 
OLD 191 BEAM TRAWLS, CRAB
NEW 191 BEAM TRAWLS, CRAB
 
OLD 192 BEAM TRAWLS, SHRIMP
NEW 192 BEAM TRAWLS, SHRIMP
 
OLD 193 BEAM TRAWLS, OTHER
NEW 193 BEAM TRAWLS, OTHER
 
OLD 194 BEAM TRAWLS, CHOPSTICKS
NEW 194 BEAM TRAWLS, CHOPSTICKS
 
OLD 200 TRAWLS, UNSPECIFIED
NEW 200 TRAWLS, UNSPECIFIED
 
OLD 205 OTTER TRAWL BOTTOM, CRAB
NEW 205 OTTER TRAWL BOTTOM, CRAB
 
OLD 210 OTTER TRAWL BOTTOM, FISH
NEW 210 OTTER TRAWL BOTTOM, FISH
 
OLD 212 OTTER TRAWL BOTTOM, LOBSTER
NEW 212 OTTER TRAWL BOTTOM, LOBSTER
 
OLD 214 OTTER TRAWL BOTTOM, SCALLOP
NEW 214 OTTER TRAWL BOTTOM, SCALLOP
 
OLD 215 OTTER TRAWL BOTTOM, SHRIMP
NEW 215 OTTER TRAWL BOTTOM, SHRIMP
 
OLD 220 OTTER TRAWL BOTTOM, OTHER
NEW 220 OTTER TRAWL BOTTOM, OTHER
 
OLD 230 OTTER TRAWL MIDWATER
NEW 230 OTTER TRAWL MIDWATER
 
OLD 233 TRAWL MIDWATER, PAIRED
NEW 233 TRAWL MIDWATER, PAIRED
 
OLD 235 TRAWL BOTTOM, PAIRED
NEW 235 TRAWL BOTTOM, PAIRED
 
OLD 240 SCOTTISH SEINE
NEW 240 SCOTTISH SEINE
 
OLD 250 WEIRS
NEW 250 WEIRS
 
OLD 275 POUND NETS, FISH
NEW 275 POUND NETS, FISH
 
OLD 280 POUND NETS, CRAB
NEW 280 POUND NETS, CRAB
 
OLD 285 POUND NETS, HORSESHOE CRAB
NEW 285 POUND NETS, HORSESHOE CRAB
 
OLD 289 POUND NETS, OTHER
NEW 289 POUND NETS, OTHER
 
OLD 290 TRAP NETS
NEW 290 TRAP NETS
 
OLD 295 FLOATING TRAPS (SHALLOW)
NEW 295 FLOATING TRAPS (SHALLOW)
 
OLD 300 POTS AND TRAPS, CMB
NEW 300 POTS AND TRAPS, CMB
 
OLD 305 FYKE AND HOOP NETS, CRAB
NEW 305 FYKE AND HOOP NETS, CRAB
 
OLD 310 FYKE AND HOOP NETS, FISH
NEW 310 FYKE AND HOOP NETS, FISH
 
OLD 315 FYKE AND HOOP NETS, TURTLE
NEW 315 FYKE AND HOOP NETS, TURTLE
 
OLD 320 FYKE NET, OTHER
NEW 320 FYKE NET, OTHER
 
OLD 325 POTS AND TRAPS, CONCH
NEW 325 POTS AND TRAPS, CONCH
 
OLD 330 POTS AND TRAPS, CRAB, BLUE
NEW 330 POTS AND TRAPS, CRAB, BLUE
 
OLD 331 POTS AND TRAPS, CRAB, DUNGENS
NEW 331 POTS AND TRAPS, CRAB, DUNGENS
 
OLD 332 POTS AND TRAPS, CRAB, KING
NEW 332 POTS AND TRAPS, CRAB, KING
 
OLD 333 POTS AND TRAPS, CRAB, OTHER
NEW 333 POTS AND TRAPS, CRAB, OTHER
 
OLD 334 POTS AND TRAPS, CRAB, BLUE PEELER
NEW 334 POTS AND TRAPS, CRAB, BLUE PEE
 
OLD 335 POTS AND TRAPS,CRAYFSH(FRHWA)
NEW 335 POTS AND TRAPS,CRAYFSH(FRHWA)
 
OLD 340 POTS AND TRAPS, EEL
NEW 340 POTS AND TRAPS, EEL
 
OLD 345 POTS AND TRAPS, FISH
NEW 345 POTS AND TRAPS, FISH
 
OLD 350 POTS AND TRAPS, LOBSTER INSHORE
NEW 350 POTS AND TRAPS, LOBSTER INSHOR
 
OLD 351 POTS AND TRAPS, LOBSTER OFSHORE
NEW 351 POTS AND TRAPS, LOBSTER OFSHOR
 
OLD 355 POTS AND TRAPS, SPINY LOBSTER
NEW 355 POTS AND TRAPS, SPINY LOBSTER
 
OLD 360 POTS AND TRAPS, OCTOPUS
NEW 360 POTS AND TRAPS, OCTOPUS
 
OLD 365 POTS AND TRAPS, PERWKLE OR CKLE
NEW 365 POTS AND TRAPS, PERWKLE OR CKL
 
OLD 370 POTS AND TRAPS, SHRIMP
NEW 370 POTS AND TRAPS, SHRIMP
 
OLD 375 POTS AND TRAPS, TURTLE
NEW 375 POTS AND TRAPS, TURTLE
 
OLD 379 POTS AND TRAPS, OTHER
NEW 379 POTS AND TRAPS, OTHER (INCLUDE
 
OLD 380 POTS AND TRAPS, BOX TRAP
NEW 380 POTS AND TRAPS, BOX TRAP
 
OLD 385 POTS AND TRAPS, WIRE BASKETS
NEW 385 POTS AND TRAPS, WIRE BASKETS
 
OLD 387 POTS, UNCLASSIFIED
NEW 387 POTS, UNCLASSIFIED
 
OLD 390 SLAT TRAPS (VIRGINIA)
NEW 390 SLAT TRAPS (VIRGINIA)
 
OLD 400 ENTANGLING NETS (GILL) UNSPC
NEW 400 ENTANGLING NETS (GILL) UNSPC
 
OLD 405 GILL NETS, CALIFORNIA HALIBUT
NEW 405 GILL NETS, CALIFORNIA HALIBUT
 
OLD 410 GILL NETS, CRAB
NEW 410 GILL NETS, CRAB
 
OLD 415 GILL NETS, SALMON
NEW 415 GILL NETS, SALMON
 
OLD 420 GILL NETS, SEA BASS
NEW 420 GILL NETS, SEA BASS
 
OLD 425 GILL NETS, OTHER
NEW 425 GILL NETS, OTHER
 
OLD 430 GILL NETS, SINK/ANCHOR, OTHER
NEW 430 GILL NETS, SINK/ANCHOR, OTHER
 
OLD 450 GILL NETS, DRIFT, BARRACUDA
NEW 450 GILL NETS, DRIFT, BARRACUDA
 
OLD 455 GILL NETS, DRIFT, SALMON
NEW 455 GILL NETS, DRIFT, SALMON
 
OLD 460 GILL NETS, DRIFT, SEA BASS
NEW 460 GILL NETS, DRIFT, SEA BASS
 
OLD 465 GILL NETS, DRIFT, SHAD
NEW 465 GILL NETS, DRIFT, SHAD
 
OLD 470 GILL NETS, DRIFT, OTHER
NEW 470 GILL NETS, DRIFT, OTHER
 
OLD 475 GILL NETS, DRIFT, RUNAROUND
NEW 475 GILL NETS, DRIFT, RUNAROUND
 
OLD 480 GILL NETS, STAKE
NEW 480 GILL NETS, STAKE
 
OLD 490 GILL NETS, GL SHOAL
NEW 490 GILL NETS, GL SHOAL
 
OLD 500 GILL NETS, GL 1 - 2 INCH
NEW 500 GILL NETS, GL 1 - 2 INCH
 
OLD 505 GILL NETS, GL 2 - 4 INCH
NEW 505 GILL NETS, GL 2 - 4 INCH
 
OLD 510 GILL NETS, GL 4 - 7 INCH
NEW 510 GILL NETS, GL 4 - 7 INCH
 
OLD 515 GILL NETS, GL 7 - 14 INCH
NEW 515 GILL NETS, GL 7 - 14 INCH
 
OLD 520 GILL NETS, DRIFT LARGE PELAGIC
NEW 520 GILL NETS, DRIFT LARGE PELAGIC
 
OLD 530 TRAMMEL NETS
NEW 530 TRAMMEL NETS
 
OLD 600 TROLL & HAND LINES CMB
NEW 600 TROLL & HAND LINES CMB
 
OLD 601 LINES HAND, ALBACORE
NEW 601 LINES HAND, ALBACORE
 
OLD 605 LINES HAND, ROCKFISH
NEW 605 LINES HAND, ROCKFISH
 
OLD 607 LINES HAND, YELLOWFISH
NEW 607 LINES HAND, YELLOWFISH
 
OLD 610 LINES HAND, OTHER
NEW 610 LINES HAND, OTHER
 
OLD 611 ROD AND REEL
NEW 611 ROD AND REEL
 
OLD 612 REEL, MANUAL
NEW 612 REEL, MANUAL
 
OLD 613 REEL, ELECTRIC OR HYDRAULIC
NEW 613 REEL, ELECTRIC OR HYDRAULIC
 
OLD 614 LINES LONG, VERTICAL
NEW 614 LINES LONG, VERTICAL
 
OLD 616 ROD AND REEL, ELECTRIC (HAND)
NEW 616 ROD AND REEL, ELECTRIC (HAND)
 
OLD 621 LINES JIGGING MACHINE
NEW 621 LINES JIGGING MACHINE
 
OLD 650 LINES TROLL, SALMON
NEW 650 LINES TROLL, SALMON
 
OLD 651 LINES POWER TROLL SALMON
NEW 651 LINES POWER TROLL SALMON
 
OLD 655 LINES TROLL, TUNA
NEW 655 LINES TROLL, TUNA
 
OLD 656 LINES POWER TROLL TUNA
NEW 656 LINES POWER TROLL TUNA
 
OLD 660 LINES TROLL, OTHER
NEW 660 LINES TROLL, OTHER
 
OLD 661 LINES POWER TROLL OTHER
NEW 661 LINES POWER TROLL OTHER
 
OLD 665 LINES TROLL, MACKEREL
NEW 665 LINES TROLL, MACKEREL
 
OLD 675 LINES LONG SET WITH HOOKS
NEW 675 LINES LONG SET WITH HOOKS
 
OLD 676 LINES LONG, REEF FISH
NEW 676 LINES LONG, REEF FISH
 
OLD 677 LINES LONG, SHARK
NEW 677 LINES LONG, SHARK
 
OLD 678 LINES LONG DRIFT WITH HOOKS
NEW 678 LINES LONG DRIFT WITH HOOKS
 
OLD 680 LINES TROT WITH BAITS
NEW 680 LINES TROT WITH BAITS
 
OLD 685 LINES SNAG
NEW 685 LINES SNAG
 
OLD 690 LINES ELECTRICAL DEVICES
NEW 690 LINES ELECTRICAL DEVICES
 
OLD 703 DIP NETS, COMMON
NEW 703 DIP NETS, COMMON
 
OLD 705 DIP NETS, DROP
NEW 705 DIP NETS, DROP
 
OLD 710 BRAIL OR SCOOP
NEW 710 BRAIL OR SCOOP
 
OLD 715 LIFT NET
NEW 715 LIFT NET
 
OLD 720 REEF NET
NEW 720 REEF NET
 
OLD 725 PUSH NET
NEW 725 PUSH NET
 
OLD 730 WHEELS
NEW 730 WHEELS
 
OLD 735 CAST NETS
NEW 735 CAST NETS
 
OLD 751 HARPOONS, SWORDFISH
NEW 751 HARPOONS, SWORDFISH
 
OLD 752 HARPOONS, TURTLE
NEW 752 HARPOONS, TURTLE
 
OLD 753 HARPOONS, WHALE
NEW 753 HARPOONS, WHALE
 
OLD 754 HARPOONS, OTHER
NEW 754 HARPOONS, OTHER
 
OLD 760 SPEARS
NEW 760 SPEARS
 
OLD 765 POWERHEADS (BANGSTICKS)
NEW 765 POWERHEADS (BANGSTICKS)
 
OLD 770 SCRAPES
NEW 770 SCRAPES
 
OLD 781 WATER PUMP,SAND SHRIMP
NEW 781 WATER PUMP,SAND SHRIMP
 
OLD 785 BARGE KELP
NEW 785 BARGE KELP
 
OLD 802 DREDGE CLAM HYDRAULIC
NEW 802 DREDGE CLAM HYDRAULIC
 
OLD 803 DREDGE CLAM
NEW 803 DREDGE CLAM
 
OLD 804 DREDGE CONCH
NEW 804 DREDGE CONCH
 
OLD 805 DREDGE CRAB
NEW 805 DREDGE CRAB
 
OLD 810 DREDGE MUSSEL
NEW 810 DREDGE MUSSEL
 
OLD 815 DREDGE OYSTER, COMMON
NEW 815 DREDGE OYSTER, COMMON
 
OLD 820 DREDGE OYSTER, SUCTION
NEW 820 DREDGE OYSTER, SUCTION
 
OLD 823 DREDGE SCALLOP, BAY
NEW 823 DREDGE SCALLOP, BAY
 
OLD 825 DREDGE SCALLOP, SEA
NEW 825 DREDGE SCALLOP, SEA
 
OLD 827 DREDGE URCHIN, SEA
NEW 827 DREDGE URCHIN, SEA
 
OLD 830 DREDGE OTHER
NEW 830 DREDGE OTHER
 
OLD 840 TONGS AND GRABS, OYSTER
NEW 840 TONGS AND GRABS, OYSTER
 
OLD 841 TONGS PATENT, OYSTER
NEW 841 TONGS PATENT, OYSTER
 
OLD 845 TONGS AND GRABS, OTHER
NEW 845 TONGS AND GRABS, OTHER
 
OLD 846 TONGS PATENT, CLAM OTHER
NEW 846 TONGS PATENT, CLAM OTHER
 
OLD 853 RAKES, OYSTER
NEW 853 RAKES, OYSTER
 
OLD 855 RAKES, OTHER
NEW 855 RAKES, OTHER
 
OLD 860 HOES
NEW 860 HOES
 
OLD 865 FORKS
NEW 865 FORKS
 
OLD 870 SHOVELS
NEW 870 SHOVELS
 
OLD 875 PICKS
NEW 875 PICKS
 
OLD 880 BRUSH TRAP
NEW 880 BRUSH TRAP
 
OLD 890 CROWFOOT BARS
NEW 890 CROWFOOT BARS
 
OLD 895 FROG GRABS
NEW 895 FROG GRABS
 
OLD 925 HOOKS, SPONGE
NEW 925 HOOKS, SPONGE
 
OLD 930 HOOKS, ABALONE
NEW 930 HOOKS, ABALONE
 
OLD 935 HOOKS, OTHER
NEW 935 HOOKS, OTHER
 
OLD 941 DIVING OUTFITS, ABALONE
NEW 941 DIVING OUTFITS, ABALONE
 
OLD 942 DIVING OUTFITS, SPONGE
NEW 942 DIVING OUTFITS, SPONGE
 
OLD 943 DIVING OUTFITS, OTHER
NEW 943 DIVING OUTFITS, OTHER
 
OLD 951 BY HAND, OYSTER
NEW 951 BY HAND, OYSTER
 
OLD 955 BY HAND, OTHER
NEW 955 BY HAND, OTHER
 
OLD 966 OTHER GEAR, HAWAII
NEW 966 OTHER GEAR, HAWAII
 
OLD 967 VARIOUS GEAR, FISHPONDS HAWAII
NEW 967 VARIOUS GEAR, FISHPONDS HAWAII
 
OLD 989 UNSPECIFIED GEAR
NEW 989 UNSPECIFIED GEAR
 
OLD 999 COMBINED GEARS
NEW 999 COMBINED GEARS
 
 
8 NAME_CHANGE SEFSC TIP_TIP21 BYCATCH OPTIONAL VARCHAR2(1)
12 NAME_CHANGE TIPONLINE LANDING ISBYCATCH OPTIONAL NUMBER
12 NAME_CHANGE The name changed and the data type changed but the values remained the same. It is not shown on screen.
 
9 NAME_CHANGE SEFSC TIP_TIP21 WEIGHT OPTIONAL NUMBER(10,2)
17 NAME_CHANGE TIPONLINE LANDING TOTAL_WEIGHT OPTIONAL NUMBER
17 NAME_CHANGE Name change. Although the new database field name is TOTAL_WEIGHT, the data entry screen shows WEIGHT.
 
10 FIELD_SPLIT SEFSC TIP_TIP21 WEIGHT_TYPE OPTIONAL VARCHAR2(2)
10 FIELD_SPLIT TIPONLINE LANDING SPECIES_CONDITION_ID OPTIONAL NUMBER
10 FIELD_SPLIT The weight_type codes were actually a mixture of conditions and weight units. The new system strives to have only 1 type of information in a single field, so weight_type will determine SPECIES_CONDITION_ID and WEIGHT_UNIT_ID. These fields are determined in one, two or three steps. If the weight is null, then SPECIES_CONDITION_ID and WEIGHT_UNIT_ID will be null. If a weight greater than 0 is provided, then First the program tries to determine the condition information from the weight_type
10 FIELD_SPLIT
Old? Code Description
OLD 0 PIECES IN POUNDS
NEW 42 CHUNKS
 
OLD 1 GUTTED IN POUNDS
NEW 23 GUTTED - HEAD ON
 
OLD 2 HEADED IN POUNDS
NEW 58 HEAD OFF
 
OLD 3 ROUND/WHOLE IN POUNDS
NEW 1 ROUND (WHOLE)
 
OLD 4 GUTTED IN KILOGRAMS
NEW 23 GUTTED - HEAD ON
 
OLD 5 HEADED IN KILOGRAMS
NEW 58 HEAD OFF
 
OLD 6 ROUND/WHOLE IN KILOS
NEW 1 ROUND (WHOLE)
 
OLD 7 HEADED & GUTTED IN POUNDS
NEW 24 GUTTED - HEAD OFF
 
OLD 8 HEADED & GUTTED IN KILOS
NEW 24 GUTTED - HEAD OFF
 
OLD 9 CARCASS(SWORDFISH)IN #S
NEW 79 TUBE
 
OLD A GUTTED IN GRAMS
NEW 23 GUTTED - HEAD ON
 
OLD B ROUND/WHOLE IN GRAMS
NEW 1 ROUND (WHOLE)
 
OLD C LOG IN POUNDS
NEW 79 TUBE
 
OLD D LOG IN KILOS
NEW 79 TUBE
 
OLD E FINS IN POUNDS
NEW 10 FINS
 
OLD F ROUND/WHOLE IN OUNCES
NEW 1 ROUND (WHOLE)
 
OLD G CLAWS IN KG
NEW 65 CLAWS
 
OLD H CLAWS IN GRAMS
NEW 65 CLAWS
 
OLD I CLAWS IN OUNCES
NEW 65 CLAWS
 
OLD J CLAWS IN POUNDS
NEW 65 CLAWS
 
10 FIELD_SPLIT SEFSC TIP_TIP21 WEIGHT_TYPE OPTIONAL VARCHAR2(2)
18 FIELD_SPLIT TIPONLINE LANDING WEIGHT_UNIT_ID OPTIONAL NUMBER
18 FIELD_SPLIT The weight_type codes were actually a mixture of conditions and weight units. The new system strives to have only 1 type of information in a single field, so weight_type will determine SPECIES_CONDITION_ID and WEIGHT_UNIT_ID. These fields are determined in one, two or three steps. If the weight is null, then SPECIES_CONDITION_ID and WEIGHT_UNIT_ID will be null. If a weight greater than 0 is provided, then The program tries to determine the weight_unit_id from the weight_type
18 FIELD_SPLIT
Old? Code Description
OLD 0 PIECES IN POUNDS
NEW 4 POUNDS
 
OLD 1 GUTTED IN POUNDS
NEW 4 POUNDS
 
OLD 2 HEADED IN POUNDS
NEW 4 POUNDS
 
OLD 3 ROUND/WHOLE IN POUNDS
NEW 4 POUNDS
 
OLD 4 GUTTED IN KILOGRAMS
NEW 2 KILOGRAMS
 
OLD 5 HEADED IN KILOGRAMS
NEW 2 KILOGRAMS
 
OLD 6 ROUND/WHOLE IN KILOS
NEW 2 KILOGRAMS
 
OLD 7 HEADED & GUTTED IN POUNDS
NEW 4 POUNDS
 
OLD 8 HEADED & GUTTED IN KILOS
NEW 2 KILOGRAMS
 
OLD 9 CARCASS(SWORDFISH)IN #S
NEW 4 POUNDS
 
OLD A GUTTED IN GRAMS
NEW 1 GRAMS
 
OLD B ROUND/WHOLE IN GRAMS
NEW 1 GRAMS
 
OLD C LOG IN POUNDS
NEW 4 POUNDS
 
OLD D LOG IN KILOS
NEW 2 KILOGRAMS
 
OLD E FINS IN POUNDS
NEW 4 POUNDS
 
OLD F ROUND/WHOLE IN OUNCES
NEW 3 OUNCES
 
OLD G CLAWS IN KG
NEW 2 KILOGRAMS
 
OLD H CLAWS IN GRAMS
NEW 1 GRAMS
 
OLD I CLAWS IN OUNCES
NEW 3 OUNCES
 
OLD J CLAWS IN POUNDS
NEW 4 POUNDS
 
18 FIELD_SPLIT If the previous weight type could not be determined, a second lookup tries to get condition info from the 4 digit NMFS species code.
18 FIELD_SPLIT
Old? Code Description
OLD 0119 GOOSEFISH
NEW 13 LIVERS
 
OLD 0819 COD,ATLANTIC,MILT
NEW 19 WHITE ROE
 
OLD 2348 LIZA,MUGIL LIZA
NEW 17 WITH ROE
 
OLD 2349 MULLET WITH (ROE WHITE) (MILT
NEW 19 WHITE ROE
 
OLD 3086 SALMON,PACIFIC,UNC ROE
NEW 18 ONLY ROE
 
OLD 3471 AMERICAN SHAD
NEW 47 BUCK
 
OLD 3472 SHAD,ROE
NEW 17 WITH ROE
 
OLD 3475 SHARK FINS, UNCLASSIFIED
NEW 10 FINS
 
OLD 3476 SMOOTH DOGFISH
NEW 9 TAILS
 
OLD 3477 SHARK,DOGFISH,SMOOTH,FINS
NEW 10 FINS
 
OLD 3486 SHARK,SAND TIGER FINS
NEW 10 FINS
 
OLD 3487 SANDBAR SHARK
NEW 10 FINS
 
OLD 3488 ATLANTIC SHARPNOSE SHARK
NEW 10 FINS
 
OLD 3489 DUSKY SHARK
NEW 10 FINS
 
OLD 3499 THRESHER SHARK
NEW 10 FINS
 
OLD 3525 SHARK,DOGFISH FINS
NEW 10 FINS
 
OLD 3526 SHARK,HAMMERHEAD FINS
NEW 10 FINS
 
OLD 3527 SHARK,PORBEAGLE FINS
NEW 10 FINS
 
OLD 3531 SHARK,DOGFISH SPINY FINS
NEW 10 FINS
 
OLD 6000 BRINE SHRIMP
NEW 76 SPAWN(ROE)
 
OLD 7028 CRAB,BLUE,PEELER
NEW 67 SOFT (CRAB)
 
OLD 7029 CRAB,BLUE,SOFT
NEW 67 SOFT (CRAB)
 
OLD 7030 CRAB,BLUE,SOFT AND PEELER
NEW 67 SOFT (CRAB)
 
OLD 7111 CRAB,JONAH(CLAWS)
NEW 65 CLAWS
 
OLD 7121 CRAB,ATLANTIC,ROCK,CLAWS
NEW 65 CLAWS
 
OLD 7141 CRAB,CANCER SPP. CLAWS
NEW 65 CLAWS
 
OLD 7176 FLORIDA STONE CRAB
NEW 65 CLAWS
 
OLD 7177 CRAB,STONE (MEDIUM CLAWS)
NEW 65 CLAWS
 
OLD 7178 CRAB,STONE (LARGE CLAWS)
NEW 65 CLAWS
 
OLD 7179 CRAB,STONE (JUMBO CLAWS)
NEW 65 CLAWS
 
OLD 7180 CRAB,STONE (UNC CLAWS)
NEW 65 CLAWS
 
OLD 7301 LOBSTERS,SPINY TAILS
NEW 9 TAILS
 
OLD 7891 OYSTER,EASTERN,MKT,PBL,SPR
NEW 78 SPRING
 
OLD 7892 OYSTER,EASTERN,MKT,PBL,FALL
NEW 52 FALL
 
OLD 7893 OYSTER,EASTERN,MKT,PBL,SEED
NEW 75 SEED
 
OLD 7894 OYSTER,EASTERN,MKT,SEED,PRIV
NEW 75 SEED
 
OLD 7895 OYSTER,EASTERN,MKT,PRIV.,SPR
NEW 78 SPRING
 
OLD 7896 OYSTER,EASTERN,MKT,PRIV.,FALL
NEW 52 FALL
 
18 FIELD_SPLIT If the previous weight type could not be determined, a third lookup tries to get condition info from the size code.
18 FIELD_SPLIT
Old? Code Description
OLD 01 PIECES OR CHUNKS
NEW 42 CHUNKS
 
OLD 02 FINS
NEW 10 FINS
 
OLD 03 FILLET
NEW 30 FILLETS
 
OLD 93 CORE-G.AMBERJACK HEADED&GUTTED
NEW 25 CORE
 
OLD 94 LOG-G.AMBERJACK HDD,TLD,GTTD
NEW 79 TUBE
 
 
11 UNCHANGED SEFSC TIP_TIP21 VALUE OPTIONAL NUMBER(8)
22 UNCHANGED TIPONLINE LANDING VALUE OPTIONAL NUMBER
22 UNCHANGED Unchanged. The field is not shown on the data entry screens, but appears in the database.
 
12 UNCHANGED SEFSC TIP_TIP21 PRICE OPTIONAL NUMBER(7,2)
23 UNCHANGED TIPONLINE LANDING PRICE OPTIONAL NUMBER
23 UNCHANGED Unchanged. The field is not shown on the data entry screens, but appears in the database.
 
13 OLD_FIELD_DROPPED SEFSC TIP_TIP21 NO_OF_TRIPS OPTIONAL VARCHAR2(3)
- OLD_FIELD_DROPPED - - - - -
- OLD_FIELD_DROPPED The field is no longer needed and was dropped.
14 OLD_FIELD_DROPPED SEFSC TIP_TIP21 TYPE_31_RECORDS OPTIONAL NUMBER(3)
- OLD_FIELD_DROPPED - - - - -
- OLD_FIELD_DROPPED The field is no longer needed and was dropped.
 
- NEW_FIELD_ADDED - - - - -
1 NEW_FIELD_ADDED TIPONLINE LANDING ID MANDATORY NUMBER
1 NEW_FIELD_ADDED New field added. TIPONLINE.Landing.Id is a sequential number generated when the landing record is created. That number is assigned to TIPONLINE.Sample.Landing_Id to relate that sample record to a particular landing record.
 
- NEW_FIELD_ADDED - - - - -
2 NEW_FIELD_ADDED TIPONLINE LANDING INTERVIEW_ID MANDATORY NUMBER
2 NEW_FIELD_ADDED New field added. TIPONLINE.Interview.Id is a sequential number generated when the interview record is created. That number is assigned to TIPONLINE.Landing.Interview_Id to relate this landing to a particular interview. There is also an Interview_id field in TIPONLINE.Effort, TIPONLINE.Sample and TIPONLINE.Observation. The field is shown as the last digits on the Interview Number after the characters for the state code.
 
- NEW_FIELD_ADDED - - - - -
5 NEW_FIELD_ADDED TIPONLINE LANDING SPECIES_QTY OPTIONAL NUMBER
5 NEW_FIELD_ADDED New field was not used. It will be removed in a future release.
 
- NEW_FIELD_ADDED - - - - -
7 NEW_FIELD_ADDED TIPONLINE LANDING REGION_ID OPTIONAL NUMBER
7 NEW_FIELD_ADDED New field added. Although region is present in Effort, it was not assigned to the landing record for the historical data. It is not shown on screen.
 
- NEW_FIELD_ADDED - - - - -
8 NEW_FIELD_ADDED TIPONLINE LANDING CREATED_BY_USER_ID MANDATORY VARCHAR2(20)
8 NEW_FIELD_ADDED New field added. Whenever a record is created, the Oracle user id is automatically recorded in this field. Not shown on screen.
 
- NEW_FIELD_ADDED - - - - -
20 NEW_FIELD_ADDED TIPONLINE INTERVIEW CREATED_DATE MANDATORY DATE
20 NEW_FIELD_ADDED New field added. Whenever a record is created, the date and time of the record creation is automatically recorded in this field. Not shown on the screen.
 
- NEW_FIELD_ADDED - - - - -
7 NEW_FIELD_ADDED TIPONLINE LANDING ISRIPE OPTIONAL NUMBER
7 NEW_FIELD_ADDED New field added. It does not exist in the historical data. It can be entered in the online data entry program. 0=false, 1=true.
 
- NEW_FIELD_ADDED - - - - -
14 NEW_FIELD_ADDED TIPONLINE LANDING MARKET_COUNT_MIN OPTIONAL NUMBER
14 NEW_FIELD_ADDED New field added. It can be entered in the online data entry program.
 
- NEW_FIELD_ADDED - - - - -
15 NEW_FIELD_ADDED TIPONLINE LANDING MARKET_COUNT_MAX OPTIONAL NUMBER
15 NEW_FIELD_ADDED New field added. It can be entered in the online data entry program.
 
- NEW_FIELD_ADDED - - - - -
16 NEW_FIELD_ADDED TIPONLINE LANDING TOTAL_VOLUME OPTIONAL NUMBER
16 NEW_FIELD_ADDED New field added. It does not exist in the historical data. It is not used in the new system. It is not shown on the screen, and will be removed in a future release.
 
- NEW_FIELD_ADDED - - - - -
19 NEW_FIELD_ADDED TIPONLINE LANDING VOLUME_UNIT_ID OPTIONAL NUMBER
19 NEW_FIELD_ADDED New field added. It does not exist in the historical data. It is not used in the new system. It is not shown on the screen, and will be removed in a future release.
 
- NEW_FIELD_ADDED - - - - -
20 NEW_FIELD_ADDED TIPONLINE LANDING ISAGGREGATED OPTIONAL NUMBER
20 NEW_FIELD_ADDED New field added. It does not exist in the historical data. It can be entered in the online data entry program via a list. 0=No, 1=Yes, 2=None
 
- NEW_FIELD_ADDED - - - - -
21 NEW_FIELD_ADDED TIPONLINE LANDING LANDING_COMMENT OPTIONAL VARCHAR2(4000)
21 NEW_FIELD_ADDED New field added. It does not exist in the historical data.
 
- NEW_FIELD_ADDED - - - - -
24 NEW_FIELD_ADDED TIPONLINE LANDING MODIFIED_DATE OPTIONAL DATE
24 NEW_FIELD_ADDED New field added. This field is comparable to sefsc.tip_changes.changedate. However, sefsc.tip_tip21 does not record such information. The new TIPONLINE program will automatically record the last date and time the record is updated. Not shown on screen.
 
- NEW_FIELD_ADDED - - - - -
25 NEW_FIELD_ADDED TIPONLINE LANDING MODIFIED_BY_USER_ID OPTIONAL VARCHAR2(20)
25 NEW_FIELD_ADDED New field added. This field is comparable to sefsc.tip_changes.userid. However, sefsc.tip_tip21 does not record such information. The new TIPONLINE program will automatically record the Oracle user id of the person last updating the record. Not shown on screen.
 
- NEW_FIELD_ADDED - - - - -
26 NEW_FIELD_ADDED TIPONLINE LANDING AREA_ID OPTIONAL NUMBER
26 NEW_FIELD_ADDED New field added. Not in historical data but can be entered when available in the online data entry program.
 
- NEW_FIELD_ADDED - - - - -
28 NEW_FIELD_ADDED TIPONLINE LANDING STANDARD_GEAR_ID OPTIONAL VARCHAR2(20)
28 NEW_FIELD_ADDED New field added. This field is automatically filled in by a trigger using information provided by the gear_code. It is not shown on screen.
 
- NEW_FIELD_ADDED - - - - -
29 NEW_FIELD_ADDED TIPONLINE LANDING STANDARD_SPECIES_ID OPTIONAL NUMBER
29 NEW_FIELD_ADDED New field added. This field is automatically filled in by a trigger using information provided by the market_species_id. It is not shown on screen.
 
- NEW_FIELD_ADDED - - - - -
30 NEW_FIELD_ADDED TIPONLINE LANDING STANDARD_AREA_ID OPTIONAL NUMBER
30 NEW_FIELD_ADDED New field added. This field is automatically filled in by a trigger using information provided by the area_id. It is not shown on screen.
 

SEFSC.TIP_TIP31 FILLS TIPONLINE.SAMPLE

COLUMN ORDER TRANSFORMATION OLD: OWNER TABLE COLUMN NAME MANDATORY? TYPE
COLUMN ORDER TRANSFORMATION NEW: OWNER TABLE COLUMN NAME MANDATORY? TYPE
1 OLD_FIELD_DROPPED SEFSC TIP_TIP31 RECORD_TYPE MANDATORY VARCHAR2(2)
- OLD_FIELD_DROPPED - - - - -
- OLD_FIELD_DROPPED The field was not needed and was dropped.
 
2 OLD_FIELD_DROPPED SEFSC TIP_TIP31 SEQUENCE_NUMBER MANDATORY VARCHAR2(11)
- OLD_FIELD_DROPPED - - - - -
- OLD_FIELD_DROPPED Although sequence_number is not carried in the new TIPONLINE data there is a new field, INTERVIEW_ID, which relates all data back to the original interview record. TIPONLINE.Interview.Id is a sequential number generated when the interview record is created. That number is assigned to TIPONLINE.Sample.Interview_Id to relate this sample record to a particular interview.
 
3 UNCHANGED SEFSC TIP_TIP31 REPLICATE MANDATORY NUMBER(2)
27 UNCHANGED TIPONLINE SAMPLE REPLICATE OPTIONAL NUMBER(2)
27 UNCHANGED The replicate was included for the historical data in order to relate each sefsc.tip_tip31 record to an individual tiponline.landing record. It is not shown on screen.
 
4 CODE_CHANGE SEFSC TIP_TIP31 SPECIES_CODE OPTIONAL VARCHAR2(10)
7 CODE_CHANGE TIPONLINE SAMPLE SPECIES_CODE OPTIONAL VARCHAR2(20)
7 CODE_CHANGE The old species code was not loaded into the new system, the NODC code was used instead for this field and for the preferred new field for species, MARKET_SPECIES_ID. However, some of the extra information provided in the old 4 digit NMFS codes was passed to new SAMPLE fields for condition and grade.
 
5 CODE_CHANGE SEFSC TIP_TIP31 NODC_CODE OPTIONAL VARCHAR2(10)
24 CODE_CHANGE TIPONLINE SAMPLE MARKET_SPECIES_ID MANDATORY VARCHAR2(20)
24 CODE_CHANGE In addition to the name change, the 10 digit NODC code was changed to a 12 digit NODC code. Although a function could allow last 2 digits beside 00, all historical data matched the first 10 digits and had the last 2 digits as 00.
 
6 FIELD_SPLIT SEFSC TIP_TIP31 MARKET_CATEGORY OPTIONAL VARCHAR2(2)
14 FIELD_SPLIT TIPONLINE SAMPLE SPECIES_SIZE_ID MANDATORY NUMBER
14 FIELD_SPLIT The old market category field was a mixture of sizes, conditions, grade and sex information. The new system strives to have only 1 type of information in a single field. The market category breakdown into species_size_id is the same as for TIP_TIP21.Size_Code and will not be repeated here.
 
6 FIELD_SPLIT SEFSC TIP_TIP31 MARKET_CATEGORY OPTIONAL VARCHAR2(2)
15 FIELD_SPLIT TIPONLINE SAMPLE CONDITION_TYPE_ID OPTIONAL NUMBER
15 FIELD_SPLIT The old market category field was a mixture of sizes, conditions, grade and sex information. The new system strives to have only 1 type of information in a single field. The value must match id in the table Tiponline.Condition_Type. Note: The market_category will determine condition_type_id only if weight_type and the species_code failed to provide a condition. Then the market category breakdown into condition_type_id will be the same as the tip_tip21.size_code breakdown into Landing.Species_Condition_Id and will not be repeated here.
 
6 FIELD_SPLIT SEFSC TIP_TIP31 MARKET_CATEGORY OPTIONAL VARCHAR2(2)
16 FIELD_SPLIT TIPONLINE SAMPLE GRADE_ID OPTIONAL NUMBER
16 FIELD_SPLIT The old market category field was a mixture of sizes, conditions, grade and sex information. The new system strives to have only 1 type of information in a single field. The value must match id in the table Tiponline.Grade. The tip_tip31.market category breakdown into sample.grade_id is the same as the breakdown for tip_tip21.size_code into landing.grade_id and will not be repeated here.
 
5 UNCHANGED SEFSC TIP_TIP31 SAMPLE_NUMBER MANDATORY NUMBER(2)
28 UNCHANGED TIPONLINE SAMPLE SAMPLE_NUMBER OPTIONAL NUMBER(2)
28 UNCHANGED The replicate and sample_number were included for the historical data in order to relate each sefsc.tip_tip31 record to an individual tiponline.sample record. It is not shown on the screen.
 
8 NAME_CHANGE SEFSC TIP_TIP31 FISH_IN_SAMPLE OPTIONAL NUMBER(4)
9 NAME_CHANGE TIPONLINE SAMPLE SAMPLE_COUNT OPTIONAL NUMBER
9 NAME_CHANGE Only the name changed.
 
9 OLD_FIELD_DROPPED SEFSC TIP_TIP31 WEIGHT_AS_ENTERED OPTIONAL VARCHAR2(9)
- OLD_FIELD_DROPPED - - - - -
- OLD_FIELD_DROPPED This field was used for invalid weights. The new system requires valid numbers so this field was dropped.
 
10 NAME_CHANGE SEFSC TIP_TIP31 WEIGHT_OF_SAMPLE OPTIONAL NUMBER(9,3)
8 NAME_CHANGE TIPONLINE SAMPLE TOTAL_WEIGHT OPTIONAL NUMBER
8 NAME_CHANGE Name change. Although the new database field name is TOTAL_WEIGHT, the data entry screen shows WEIGHT.
 
11 FIELD_SPLIT SEFSC TIP_TIP31 MEASUREMENT_TYPE OPTIONAL VARCHAR2(2)
15 FIELD_SPLIT TIPONLINE SAMPLE CONDITION_TYPE_ID OPTIONAL NUMBER
15 FIELD_SPLIT The measurement_type codes (called weight_type in the Landings Section) were actually a mixture of conditions and weight units. The new system strives to have only 1 type of information in a single field. The value must match id in the table Tiponline.Condition_Type. Measurement_Type will determine Condition_Type_Id and Weight_Unit_Id in the same manner that TIP_TIP21.Weight_Type determined TIPONLINE.Landing.Species_Condition_id and Weight_Unit_Id. See Landing.Species_Condition_Id for tables showing how the fields are split.
 
11 FIELD_SPLIT SEFSC TIP_TIP31 MEASUREMENT_TYPE OPTIONAL VARCHAR2(2)
12 FIELD_SPLIT TIPONLINE SAMPLE WEIGHT_UNIT_ID OPTIONAL NUMBER
12 FIELD_SPLIT The measurement_type codes (called weight_type in the Landings Section) were actually a mixture of conditions and weight units. The new system strives to have only 1 type of information in a single field. The value must match id in the table Tiponline.Weight_Unit. tip_tip31.measurement_type will determine Sample.weight_unit_id in the same way that tip_tip21.weight_type determined Landing.Weight_Unit_Id.
 
12 CODE_CHANGE SEFSC TIP_TIP31 CATCH_STATUS OPTIONAL VARCHAR2(2)
4 CODE_CHANGE TIPONLINE SAMPLE IS_FULL_CATCH MANDATORY NUMBER
4 CODE_CHANGE The name was changed. A slight change was made to the codes. 0=No, 1=Yes, 2=Unknown. Thus nulls were replaced by the value 2.
 
13 NAME_CHANGE SEFSC TIP_TIP31 FISH_IN_SUBSAMPLE OPTIONAL NUMBER(4)
17 NAME_CHANGE TIPONLINE SAMPLE SUB_SAMPLE_COUNT OPTIONAL NUMBER
17 NAME_CHANGE Only the name changed.
 
14 OLD_FIELD_DROPPED SEFSC TIP_TIP31 SUB_WEIGHT_AS_ENTERED OPTIONAL VARCHAR2(9)
- OLD_FIELD_DROPPED - - - - -
- OLD_FIELD_DROPPED The field was used for invalid weight_of_subsamples. The new system requires valid numbers so the field was dropped.
 
15 NAME_CHANGE SEFSC TIP_TIP31 WEIGHT_OF_SUBSAMPLE OPTIONAL NUMBER(9,3)
19 NAME_CHANGE TIPONLINE SAMPLE SUBSAMPLE_TOTAL_WEIGHT OPTIONAL NUMBER
19 NAME_CHANGE Only the name was changed.
16 FIELD_SPLIT SEFSC TIP_TIP31 MEASUREMENT_TYPE_SUB OPTIONAL VARCHAR2(1)
18 FIELD_SPLIT TIPONLINE SAMPLE SUB_SAMPLE_WEIGHT_UNIT_ID OPTIONAL NUMBER
18 FIELD_SPLIT The measurement_type_sub codes (called weight_type in the Landings Section) were actually a mixture of conditions and weight units. The new system strives to have only 1 type of information in a single field. The value must match id in the table Tiponline.Weight_Unit. tip_tip31.measurement_type_sub will determine Sample.sub_sample_weight_unit_id in the same way that tip_tip21.weight_type determined Landing.Weight_Unit_Id.
 
17 FIELD_SPLIT SEFSC TIP_TIP31 MEASUREMENT_TYPE_SUB OPTIONAL VARCHAR2(1)
20 FIELD_SPLIT TIPONLINE SAMPLE SUB_SAMPLE_COND_TYPE_ID OPTIONAL NUMBER
20 FIELD_SPLIT The measurement_type_sub codes (called weight_type in the Landings Section) were actually a mixture of conditions and weight units. The new system strives to have only 1 type of information in a single field. The value must match id in the table Tiponline.Condition_Type. Measurement_Type_sub will determine Sub_Sample_Cond_Type_Id in the same manner that TIP_TIP21.Weight_Type determined TIPONLINE.Landing.Species_Condition_id. See Landing.Species_Condition_Id for tables showing how the fields are split.
 
17 NAME_CHANGE SEFSC TIP_TIP31 SAMPLE_TYPE OPTIONAL VARCHAR2(2)
11 NAME_CHANGE TIPONLINE SAMPLE SAMPLE_METHOD_TYPE_ID OPTIONAL NUMBER
11 NAME_CHANGE Name change. The value must match id in the table Tiponline.Sample_Method_Type.
11 NAME_CHANGE
Old? Code Description
OLD 0 NOT PROVIDED
NEW 0 UNKNOWN
 
OLD 1 LANDED UNSORTED
NEW 1 LANDED UNSORTED
 
OLD 2 LANDED SORTED
NEW 2 LANDED SORTED
 
OLD 3 AT SEA UNSORTED
NEW 3 AT SEA UNSORTED
 
OLD 4 AS AVAILABLE
NEW 4 AS AVAILABLE
 
OLD 5 QUOTA SAMPLING
NEW 5 QUOTA SAMPLING
 
 
16 NAME_CHANGE SEFSC TIP_TIP31 SAMPLE_FORMAT OPTIONAL VARCHAR2(2)
10 NAME_CHANGE TIPONLINE SAMPLE SAMPLE_FORM OPTIONAL VARCHAR2(20)
10 NAME_CHANGE Only the name changed.
 
19 OLD_FIELD_DROPPED SEFSC TIP_TIP31 TYPE_41_RECORDS OPTIONAL NUMBER(3)
- OLD_FIELD_DROPPED - - - - -
- OLD_FIELD_DROPPED The field is no longer needed and was dropped.
 
- NEW_FIELD_ADDED - - - - -
1 NEW_FIELD_ADDED TIPONLINE SAMPLE ID MANDATORY NUMBER
1 NEW_FIELD_ADDED New field added. TIPONLINE.SAMPLE.Id is a sequential number generated when the SAMPLE record is created. That number is assigned to TIPONLINE.Observation.Sample_Id to relate that observation record to a particular sample record.
 
- NEW_FIELD_ADDED - - - - -
2 NEW_FIELD_ADDED TIPONLINE SAMPLE INTERVIEW_ID MANDATORY NUMBER
2 NEW_FIELD_ADDED New field added. TIPONLINE.Interview.Id is a sequential number generated when the interview record is created. That number is assigned to TIPONLINE.Sample.Interview_Id to relate this Sample to a particular interview. There is also an Interview_id field in TIPONLINE.Effort, TIPONLINE.Landing and TIPONLINE.Observation. The field is shown as the last digits on the Interview Number after the characters for the state code.
 
- NEW_FIELD_ADDED - - - - -
3 NEW_FIELD_ADDED TIPONLINE SAMPLE IS_RANDOM MANDATORY NUMBER
3 NEW_FIELD_ADDED New field added. It was assigned 1 = true for the historical data. It can be entered in the online data entry program. When unchecked, field is assigned 0 meaning false, when checked, field is assigned 1 meaning true.
 
- NEW_FIELD_ADDED - - - - -
5 NEW_FIELD_ADDED TIPONLINE SAMPLE CREATED_BY_USER_ID MANDATORY VARCHAR2(20)
5 NEW_FIELD_ADDED New field added. Whenever a record is created, the Oracle user id is automatically recorded in this field. Not shown on screen.
 
- NEW_FIELD_ADDED - - - - -
6 NEW_FIELD_ADDED TIPONLINE INTERVIEW CREATED_DATE MANDATORY DATE
6 NEW_FIELD_ADDED New field added. Whenever a record is created, the date and time of the record creation is automatically recorded in this field. Not shown on the screen.
 
- NEW_FIELD_ADDED - - - - -
14 NEW_FIELD_ADDED TIPONLINE SAMPLE SAMPLE_COMMENT OPTIONAL VARCHAR2(4000)
14 NEW_FIELD_ADDED New field added. It does not exist in the historical data.
 
- NEW_FIELD_ADDED - - - - -
21 NEW_FIELD_ADDED TIPONLINE SAMPLE SUB_SAMPLE_IS_RANDOM OPTIONAL NUMBER
21 NEW_FIELD_ADDED New field added. It does not exist in the historical data. It can be entered in the online data entry program. When unchecked, field is assigned 0 meaning false, when checked, field is assigned 1 meaning true.
 
- NEW_FIELD_ADDED - - - - -
22 NEW_FIELD_ADDED TIPONLINE SAMPLE MODIFIED_BY_USER_ID OPTIONAL VARCHAR2(20)
22 NEW_FIELD_ADDED New field added. This field is comparable to sefsc.tip_changes.userid. However, sefsc.TIP_TIP31 does not record such information. The new TIPONLINE program will automatically record the Oracle user id of the person last updating the record. Not shown on screen.
 
- NEW_FIELD_ADDED - - - - -
24 NEW_FIELD_ADDED TIPONLINE SAMPLE MODIFIED_DATE OPTIONAL DATE
24 NEW_FIELD_ADDED New field added. This field is comparable to sefsc.tip_changes.changedate. However, sefsc.TIP_TIP31 does not record such information. The new TIPONLINE program will automatically record the last date and time the record is updated. Not shown on screen.
 
- NEW_FIELD_ADDED - - - - -
25 NEW_FIELD_ADDED TIPONLINE SAMPLE SPECIES_QUANTITY OPTIONAL NUMBER
25 NEW_FIELD_ADDED New field added. Not loaded, not used. Will be removed in a future version.
 
- NEW_FIELD_ADDED - - - - -
26 NEW_FIELD_ADDED TIPONLINE SAMPLE LANDING_ID OPTIONAL NUMBER
26 NEW_FIELD_ADDED New field added. TIPONLINE.Landing.Id is a sequential number generated when the landing record is created. That number is assigned to TIPONLINE.Sample.Landing_Id to relate that sample record to a particular landing record.
 
- NEW_FIELD_ADDED - - - - -
29 NEW_FIELD_ADDED TIPONLINE SAMPLE STANDARD_SPECIES_ID OPTIONAL VARCHAR2(20)
29 NEW_FIELD_ADDED New field added. This field is automatically filled in by a trigger using information provided by the market_species_id. It is not shown on screen. The value must match id in the table Tiponline.Standard_Species.
 

SEFSC.TIP_TIP41 FILLS TIPONLINE.OBSERVATION

COLUMN ORDER TRANSFORMATION OLD: OWNER TABLE COLUMN NAME MANDATORY? TYPE
COLUMN ORDER TRANSFORMATION NEW: OWNER TABLE COLUMN NAME MANDATORY? TYPE
1 OLD_FIELD_DROPPED SEFSC TIP_TIP41 RECORD_TYPE MANDATORY VARCHAR2(2)
- OLD_FIELD_DROPPED - - - - -
- OLD_FIELD_DROPPED The field was not needed and was dropped.
 
2 OLD_FIELD_DROPPED SEFSC TIP_TIP41 SEQUENCE_NUMBER MANDATORY VARCHAR2(11)
- OLD_FIELD_DROPPED - - - - -
- OLD_FIELD_DROPPED Although sequence_number is not carried in the new TIPONLINE data there is a new field, Interview_Id, which relates all data back to the original interview record. TIPONLINE.Interview.Id is a sequential number generated when the interview record is created. That number is assigned to TIPONLINE.Observation.Interview_Id to relate this Observation record to a particular interview.
 
3 UNCHANGED SEFSC TIP_TIP41 REPLICATE MANDATORY NUMBER(2)
27 UNCHANGED TIPONLINE OBSERVATION REPLICATE OPTIONAL NUMBER(2)
27 UNCHANGED The replicate was included for the historical data in order to relate each sefsc.tip_tip41 record to an individual tiponline.landing record. It is not shown on screen.
 
4 CODE_CHANGE SEFSC TIP_TIP41 SPECIES_CODE OPTIONAL VARCHAR2(10)
3 CODE_CHANGE TIPONLINE OBSERVATION SPECIES_CODE OPTIONAL VARCHAR2(20)
3 CODE_CHANGE The old species code was not loaded into the new system, the NODC code was used instead. However, some of the extra information provided in the old 4 digit NMFS codes was passed to new OBSERVATION fields for condition and grade.
 
5 CODE_CHANGE SEFSC TIP_TIP41 NODC_CODE OPTIONAL VARCHAR2(10)
3 CODE_CHANGE TIPONLINE OBSERVATION SPECIES_CODE MANDATORY VARCHAR2(20)
3 CODE_CHANGE In addition to the name change, the 10 digit NODC code was changed to a 12 digit NODC code. Although a function could allow last 2 digits beside 00, all historical data matched the first 10 digits and had the last 2 digits as 00. All historical data have values that match id in the table Tiponline.Nmfs_Species.
 
6 FIELD_SPLIT SEFSC TIP_TIP41 MARKET_CATEGORY OPTIONAL VARCHAR2(2)
28 FIELD_SPLIT TIPONLINE OBSERVATION SPECIES_SIZE_ID OPTIONAL NUMBER
28 FIELD_SPLIT The old market category field was a mixture of sizes, conditions, grade and sex information. The new system strives to have only 1 type of information in a single field. The value must match id in the table Tiponline.Species_Size. The market category breakdown into species_size_id is the same as for TIP_TIP21.Size_Code and will not be repeated here.
 
6 FIELD_SPLIT SEFSC TIP_TIP41 MARKET_CATEGORY OPTIONAL VARCHAR2(2)
15 FIELD_SPLIT TIPONLINE OBSERVATION CONDITION_TYPE_ID OPTIONAL NUMBER
15 FIELD_SPLIT The old market category field was a mixture of sizes, conditions, grade and sex information. The new system strives to have only 1 type of information in a single field. The value must match id in the table Tiponline.Condition_Type. Note: The market_category will determine condition_type_id only if weight_type and the species_code failed to provide a condition. Then the market category breakdown into condition_type_id will be the same as the tip_tip21.size_code breakdown into Landing.Species_Condition_Id and will not be repeated here.
 
7 UNCHANGED SEFSC TIP_TIP41 SAMPLE_NUMBER MANDATORY NUMBER(2)
30 UNCHANGED TIPONLINE OBSERVATION SAMPLE_NUMBER OPTIONAL NUMBER(2)
30 UNCHANGED The replicate and sample_number and line number were included for the historical data in order to relate the sefsc.tip_tip41 record to an individual tiponline.observation record. It is not shown on screen.
 
8 UNCHANGED SEFSC TIP_TIP41 LINE_NUMBER MANDATORY NUMBER(3)
31 UNCHANGED TIPONLINE OBSERVATION LINE_NUMBER OPTIONAL NUMBER(3)
31 UNCHANGED The replicate and sample_number and line number were included for the historical data in order to relate the sefsc.tip_tip41 record to an individual tiponline.observation record. It is not shown on screen.
 
9 NAME_CHANGE SEFSC TIP_TIP41 FREQUENCY OPTIONAL NUMBER(4)
4 NAME_CHANGE TIPONLINE OBSERVATION QUANTITY MANDATORY NUMBER
4 NAME_CHANGE The name changed.
 
10 NAME_CHANGE SEFSC TIP_TIP41 START_LENGTH OPTIONAL NUMBER(7,2)
17 NAME_CHANGE TIPONLINE OBSERVATION LENGTH1 OPTIONAL NUMBER
17 NAME_CHANGE Only the name changed.
 
11 NAME_CHANGE SEFSC TIP_TIP41 END_LENGTH OPTIONAL NUMBER(7,2)
18 NAME_CHANGE TIPONLINE OBSERVATION LENGTH2 OPTIONAL NUMBER
18 NAME_CHANGE Only the name changed.
 
12 FIELD_SPLIT SEFSC TIP_TIP41 LENGTH_TYPE OPTIONAL VARCHAR2(2)
23 FIELD_SPLIT TIPONLINE OBSERVATION LENGTH_TYPE_ID1 OPTIONAL NUMBER
23 FIELD_SPLIT The old length_type field was a mixture of length_type and length_unit information. The new system strives to have only 1 type of information in a single field. The value must match id in the table Tiponline.Length_Type. If tip_tip41.start_length is null or zero, length_type_id will be null. The length_type to length_type_id_1 breakdown follows for lengths greater than 0:
23 FIELD_SPLIT
Old? Code Description
OLD 1 FORK IN CENTIMETERS
NEW 3 FORK LENGTH
 
OLD 2 TOTAL IN CENTIMETERS
NEW 16 TOTAL LENGTH
 
OLD 3 FORK IN INCHES
NEW 3 FORK LENGTH
 
OLD 4 TOTAL IN INCHES
NEW 16 TOTAL LENGTH
 
OLD 5 STANDARD IN CENTIMETERS
NEW 4 STANDARD LENGTH
 
OLD 6 CARAPACE IN CENTIMETERS
NEW 7 CARAPACE LENGTH
 
OLD 7 CARAPACE IN INCHES
NEW 7 CARAPACE LENGTH
 
OLD 8 FORK AND TOTAL IN CENTIMETERS
NEW 3 FORK LENGTH
 
OLD 9 FORK IN MILLIMETERS
NEW 3 FORK LENGTH
 
OLD A TOTAL IN MILLIMETERS
NEW 16 TOTAL LENGTH
 
OLD B CARAPACE IN MILLIMETERS
NEW 7 CARAPACE LENGTH
 
OLD C CORE IN CENTIMETERS
NEW 2 CORE LENGTH
 
OLD D LOG IN CENTIMETERS
NEW 17 LOG LENGTH
 
OLD E STANDARD AND FORK IN CM
NEW 4 STANDARD LENGTH
 
OLD F STANDARD AND TOTAL IN CM
NEW 4 STANDARD LENGTH
 
OLD G STONE CRAB CLAW NRNF FRACTURE
NEW 6 CLAW LENGTH
 
OLD H STONE CRAB CLAW NRF FRACTURE
NEW 6 CLAW LENGTH
 
OLD I STONE CRAB CLAW RNF FRACTURE
NEW 6 CLAW LENGTH
 
OLD J STONE CRAB CLAW RF FRACTURE
NEW 6 CLAW LENGTH
 
OLD K STONE CRAB CLAW (MM)
NEW 6 CLAW LENGTH
 
OLD L SHELL LIP IN MM
NEW 9 LIP THICKNESS,CONCH
 
OLD M SHELL LENGTH IN MM
NEW 11 SHELL LENGTH
 
OLD N SHELL LENGTH IN CM
NEW 11 SHELL LENGTH
 
OLD O LOWER LENGTH SHELL/UPPER LENGH
NEW 11 SHELL LENGTH
 
OLD P TAIL WIDTH MM/TAIL LENGTH IN
NEW 19 TAIL WIDTH
 
OLD Q TELSON LENGTH MM/TAIL LEN IN
NEW 20 TELSON LENGTH
 
OLD R CARAPACE WIDTH INCHES
NEW 8 CARAPACE WIDTH
 
OLD S TELSON LENGTH MM
NEW 20 TELSON LENGTH
 
OLD T TAIL LENGTH MM
NEW 18 TAIL LENGTH
 
OLD U WINGTIP TO WINGTIP CM
NEW 5 WINGTIP TO WINGTIP
 
OLD V CARAPACE WIDTH CENTIMETERS
NEW 8 CARAPACE WIDTH
 
OLD W TAIL WIDTH MM
NEW 19 TAIL WIDTH
 
OLD X CORE IN MILLIMETERS
NEW 2 CORE LENGTH
 
OLD Y LOG IN MILLIMETERS
NEW 17 LOG LENGTH
 
OLD Z CARAPACE WIDTH MILLIMETERS
NEW 8 CARAPACE WIDTH
 
 
12 FIELD_SPLIT SEFSC TIP_TIP41 LENGTH_TYPE OPTIONAL VARCHAR2(2)
20 FIELD_SPLIT TIPONLINE OBSERVATION LENGTH_UNIT_ID1 OPTIONAL NUMBER
20 FIELD_SPLIT The old length_type field was a mixture of length_type and length_unit information. The new system strives to have only 1 type of information in a single field. The value must match id in the table Tiponline.Length_Unit. If tip_tip41.start_length is null or zero, length_unit_id will be null. The length_type to length_unit_id_1 breakdown follows for lengths greater than 0:
20 NAME_CHANGE
Old? Code Description
OLD 1 FORK IN CENTIMETERS
NEW 1 CENTIMETERS
 
OLD 2 TOTAL IN CENTIMETERS
NEW 1 CENTIMETERS
 
OLD 3 FORK IN INCHES
NEW 4 INCHES
 
OLD 4 TOTAL IN INCHES
NEW 4 INCHES
 
OLD 5 STANDARD IN CENTIMETERS
NEW 1 CENTIMETERS
 
OLD 6 CARAPACE IN CENTIMETERS
NEW 1 CENTIMETERS
 
OLD 7 CARAPACE IN INCHES
NEW 4 INCHES
 
OLD 8 FORK AND TOTAL IN CENTIMETERS
NEW 1 CENTIMETERS
 
OLD 9 FORK IN MILLIMETERS
NEW 7 MILLIMETERS
 
OLD A TOTAL IN MILLIMETERS
NEW 7 MILLIMETERS
 
OLD B CARAPACE IN MILLIMETERS
NEW 7 MILLIMETERS
 
OLD C CORE IN CENTIMETERS
NEW 1 CENTIMETERS
 
OLD D LOG IN CENTIMETERS
NEW 1 CENTIMETERS
 
OLD E STANDARD AND FORK IN CM
NEW 1 CENTIMETERS
 
OLD F STANDARD AND TOTAL IN CM
NEW 1 CENTIMETERS
 
OLD G STONE CRAB CLAW NRNF FRACTURE
NEW 7 MILLIMETERS
 
OLD H STONE CRAB CLAW NRF FRACTURE
NEW 7 MILLIMETERS
 
OLD I STONE CRAB CLAW RNF FRACTURE
NEW 7 MILLIMETERS
 
OLD J STONE CRAB CLAW RF FRACTURE
NEW 7 MILLIMETERS
 
OLD K STONE CRAB CLAW (MM)
NEW 7 MILLIMETERS
 
OLD L SHELL LIP IN MM
NEW 7 MILLIMETERS
 
OLD M SHELL LENGTH IN MM
NEW 7 MILLIMETERS
 
OLD N SHELL LENGTH IN CM
NEW 1 CENTIMETERS
 
OLD O LOWER LENGTH SHELL/UPPER LENGH
NEW 7 MILLIMETERS
 
OLD P TAIL WIDTH MM/TAIL LENGTH IN
NEW 7 MILLIMETERS
 
OLD Q TELSON LENGTH MM/TAIL LEN IN
NEW 7 MILLIMETERS
 
OLD R CARAPACE WIDTH INCHES
NEW 4 INCHES
 
OLD S TELSON LENGTH MM
NEW 7 MILLIMETERS
 
OLD T TAIL LENGTH MM
NEW 7 MILLIMETERS
 
OLD U WINGTIP TO WINGTIP CM
NEW 1 CENTIMETERS
 
OLD V CARAPACE WIDTH CENTIMETERS
NEW 1 CENTIMETERS
 
OLD W TAIL WIDTH MM
NEW 7 MILLIMETERS
 
OLD X CORE IN MILLIMETERS
NEW 7 MILLIMETERS
 
OLD Y LOG IN MILLIMETERS
NEW 7 MILLIMETERS
 
OLD Z CARAPACE WIDTH MILLIMETERS
NEW 7 MILLIMETERS
 
 
12 FIELD_SPLIT SEFSC TIP_TIP41 LENGTH_TYPE OPTIONAL VARCHAR2(2)
24 FIELD_SPLIT TIPONLINE OBSERVATION LENGTH_TYPE_ID2 OPTIONAL NUMBER
24 FIELD_SPLIT The old length_type field was a mixture of length_type and length_unit information. The new system strives to have only 1 type of information in a single field. The value must match id in the table Tiponline.Length_Unit. If tip_tip41.end_length is null or zero, length_type_id2 will be null. Note:A few tip_tip41.length_type codes specify a different length_type and unit for the start_length and the end_length. The length_type to length_type_id_2 breakdown follows for end_lengths greater than 0:
24 NAME_CHANGE
Old? Code Description
OLD 1 FORK IN CENTIMETERS
NEW 3 FORK LENGTH
 
OLD 2 TOTAL IN CENTIMETERS
NEW 16 TOTAL LENGTH
 
OLD 3 FORK IN INCHES
NEW 3 FORK LENGTH
 
OLD 4 TOTAL IN INCHES
NEW 16 TOTAL LENGTH
 
OLD 5 STANDARD IN CENTIMETERS
NEW 4 STANDARD LENGTH
 
OLD 6 CARAPACE IN CENTIMETERS
NEW 7 CARAPACE LENGTH
 
OLD 7 CARAPACE IN INCHES
NEW 7 CARAPACE LENGTH
 
OLD 8 FORK AND TOTAL IN CENTIMETERS
NEW 16 TOTAL LENGTH
 
OLD 9 FORK IN MILLIMETERS
NEW 3 FORK LENGTH
 
OLD A TOTAL IN MILLIMETERS
NEW 16 TOTAL LENGTH
 
OLD B CARAPACE IN MILLIMETERS
NEW 7 CARAPACE LENGTH
 
OLD C CORE IN CENTIMETERS
NEW 2 CORE LENGTH
 
OLD D LOG IN CENTIMETERS
NEW 17 LOG LENGTH
 
OLD E STANDARD AND FORK IN CM
NEW 3 FORK LENGTH
 
OLD F STANDARD AND TOTAL IN CM
NEW 16 TOTAL LENGTH
 
OLD G STONE CRAB CLAW NRNF FRACTURE
NEW 6 CLAW LENGTH
 
OLD H STONE CRAB CLAW NRF FRACTURE
NEW 6 CLAW LENGTH
 
OLD I STONE CRAB CLAW RNF FRACTURE
NEW 6 CLAW LENGTH
 
OLD J STONE CRAB CLAW RF FRACTURE
NEW 6 CLAW LENGTH
 
OLD K STONE CRAB CLAW (MM)
NEW 6 CLAW LENGTH
 
OLD L SHELL LIP IN MM
NEW 9 LIP THICKNESS,CONCH
 
OLD M SHELL LENGTH IN MM
NEW 11 SHELL LENGTH
 
OLD N SHELL LENGTH IN CM
NEW 11 SHELL LENGTH
 
OLD O LOWER LENGTH SHELL/UPPER LENGH
NEW 11 SHELL LENGTH
 
OLD P TAIL WIDTH MM/TAIL LENGTH IN
NEW 18 TAIL LENGTH
 
OLD Q TELSON LENGTH MM/TAIL LEN IN
NEW 18 TAIL LENGTH
 
OLD R CARAPACE WIDTH INCHES
NEW 8 CARAPACE WIDTH
 
OLD S TELSON LENGTH MM
NEW 20 TELSON LENGTH
 
OLD T TAIL LENGTH MM
NEW 18 TAIL LENGTH
 
OLD U WINGTIP TO WINGTIP CM
NEW 5 WINGTIP TO WINGTIP
 
OLD V CARAPACE WIDTH CENTIMETERS
NEW 8 CARAPACE WIDTH
 
OLD W TAIL WIDTH MM
NEW 19 TAIL WIDTH
 
OLD X CORE IN MILLIMETERS
NEW 2 CORE LENGTH
 
OLD Y LOG IN MILLIMETERS
NEW 17 LOG LENGTH
 
OLD Z CARAPACE WIDTH MILLIMETERS
NEW 8 CARAPACE WIDTH
 
 
12 FIELD_SPLIT SEFSC TIP_TIP41 LENGTH_TYPE OPTIONAL VARCHAR2(2)
20 FIELD_SPLIT TIPONLINE OBSERVATION LENGTH_UNIT_ID2 OPTIONAL NUMBER
20 FIELD_SPLIT The old length_type field was a mixture of length_type and length_unit information. The new system strives to have only 1 type of information in a single field. The value must match id in the table Tiponline.Length_Unit. If tip_tip41.end_length is null or zero, length_unit_id2 will be null. Note:A few tip_tip41.length_type codes specify a different length_type and unit for the start_length and the end_length. The length_type to length_unit_id_2 breakdown follows for end_lengths greater than 0:
20 FIELD_SPLIT
Old? Code Description
OLD 1 FORK IN CENTIMETERS
NEW 1 CENTIMETERS
 
OLD 2 TOTAL IN CENTIMETERS
NEW 1 CENTIMETERS
 
OLD 3 FORK IN INCHES
NEW 4 INCHES
 
OLD 4 TOTAL IN INCHES
NEW 4 INCHES
 
OLD 5 STANDARD IN CENTIMETERS
NEW 1 CENTIMETERS
 
OLD 6 CARAPACE IN CENTIMETERS
NEW 1 CENTIMETERS
 
OLD 7 CARAPACE IN INCHES
NEW 4 INCHES
 
OLD 8 FORK AND TOTAL IN CENTIMETERS
NEW 1 CENTIMETERS
 
OLD 9 FORK IN MILLIMETERS
NEW 7 MILLIMETERS
 
OLD A TOTAL IN MILLIMETERS
NEW 7 MILLIMETERS
 
OLD B CARAPACE IN MILLIMETERS
NEW 7 MILLIMETERS
 
OLD C CORE IN CENTIMETERS
NEW 1 CENTIMETERS
 
OLD D LOG IN CENTIMETERS
NEW 1 CENTIMETERS
 
OLD E STANDARD AND FORK IN CM
NEW 1 CENTIMETERS
 
OLD F STANDARD AND TOTAL IN CM
NEW 1 CENTIMETERS
 
OLD G STONE CRAB CLAW NRNF FRACTURE
NEW 7 MILLIMETERS
 
OLD H STONE CRAB CLAW NRF FRACTURE
NEW 7 MILLIMETERS
 
OLD I STONE CRAB CLAW RNF FRACTURE
NEW 7 MILLIMETERS
 
OLD J STONE CRAB CLAW RF FRACTURE
NEW 7 MILLIMETERS
 
OLD K STONE CRAB CLAW (MM)
NEW 7 MILLIMETERS
 
OLD L SHELL LIP IN MM
NEW 7 MILLIMETERS
 
OLD M SHELL LENGTH IN MM
NEW 7 MILLIMETERS
 
OLD N SHELL LENGTH IN CM
NEW 1 CENTIMETERS
 
OLD O LOWER LENGTH SHELL/UPPER LENGH
NEW 7 MILLIMETERS
 
OLD P TAIL WIDTH MM/TAIL LENGTH IN
NEW 4 INCHES
 
OLD Q TELSON LENGTH MM/TAIL LEN IN
NEW 4 INCHES
 
OLD R CARAPACE WIDTH INCHES
NEW 4 INCHES
 
OLD S TELSON LENGTH MM
NEW 7 MILLIMETERS
 
OLD T TAIL LENGTH MM
NEW 7 MILLIMETERS
 
OLD U WINGTIP TO WINGTIP CM
NEW 1 CENTIMETERS
 
OLD V CARAPACE WIDTH CENTIMETERS
NEW 1 CENTIMETERS
 
OLD W TAIL WIDTH MM
NEW 7 MILLIMETERS
 
OLD X CORE IN MILLIMETERS
NEW 7 MILLIMETERS
 
OLD Y LOG IN MILLIMETERS
NEW 7 MILLIMETERS
 
OLD Z CARAPACE WIDTH MILLIMETERS
NEW 7 MILLIMETERS
 
 
13 OLD_FIELD_DROPPED SEFSC TIP_TIP41 WEIGHT_AS_ENTERED OPTIONAL VARCHAR2(8)
- OLD_FIELD_DROPPED - - - - -
- OLD_FIELD_DROPPED The field was used for invalid weights. The new system requires valid numbers so the field was dropped.
 
14 NAME_CHANGE SEFSC TIP_TIP41 WEIGHT OPTIONAL NUMBER(8,3)
11 NAME_CHANGE TIPONLINE OBSERVATION TOTAL_WEIGHT OPTIONAL NUMBER
11 NAME_CHANGE Name change. Although the new database field name is TOTAL_WEIGHT, the data entry screen shows WEIGHT.
 
15 FIELD_SPLIT SEFSC TIP_TIP41 WEIGHT_TYPE OPTIONAL VARCHAR2(2)
15 FIELD_SPLIT TIPONLINE OBSERVATION CONDITION_TYPE_ID OPTIONAL NUMBER
15 FIELD_SPLIT The weight_type codes were actually a mixture of conditions and weight units. The new system strives to have only 1 type of information in a single field. The value must match id in the table Tiponline.Condition_Type. Weight_Type will determine Condition_Type_Id in the same manner that TIP_TIP21.Weight_Type determined TIPONLINE.Landing.Species_Condition_id. See Landing.Species_Condition_Id for tables showing how the fields are split.
 
15 FIELD_SPLIT SEFSC TIP_TIP41 WEIGHT_TYPE OPTIONAL VARCHAR2(2)
14 FIELD_SPLIT TIPONLINE OBSERVATION WEIGHT_UNIT_ID OPTIONAL NUMBER
14 FIELD_SPLIT The weight_type codes were actually a mixture of conditions and weight units. The new system strives to have only 1 type of information in a single field. The value must match id in the table Tiponline.Weight_Unit. tip_tip41.weight_type will determine Observation.Weight_Unit_Id in the same way that tip_tip21.weight_type determined Landing.Weight_Unit_Id.
 
16 FIELD_SPLIT SEFSC TIP_TIP41 SEX OPTIONAL VARCHAR2(1)
5 FIELD_SPLIT TIPONLINE OBSERVATION SEX OPTIONAL VARCHAR2(5)
5 FIELD_SPLIT The tip_tip41.sex code was actually a mixture of sex and sexual maturity. The new system strives to have only 1 type of information in a single field, so The sex was split as follows:
5 FIELD_SPLIT
Old? Code Description
OLD 0 MALE - Without Sperm
NEW M MALE
 
OLD 1 MALE - Maturation Unknown
NEW M MALE
 
OLD 2 FEMALE - Maturation Unknown
NEW F FEMALE
 
OLD 3 UNKNOWN
NEW U UNKNOWN
 
OLD 4 TAR(LOBSTER)
NEW F FEMALE
 
OLD 5 GONADS TAKEN
NEW U UNKNOWN
 
OLD 6 FEMALE - Without Eggs
NEW F FEMALE
 
OLD 7 FEMALE - With Eggs
NEW F FEMALE
 
OLD 8 FEMALE - Developing
NEW F FEMALE
 
OLD 9 FEMALE - Spent
NEW F FEMALE
 
OLD A MALE (MATURE BUT INACTIVE)
NEW M MALE
 
OLD B FEMALE (MATURE BUT INACTIVE)
NEW F FEMALE
 
OLD H SEX UNKNOWN (MATURE BUT INACTV
NEW U UNKNOWN
 
OLD I SEX UNKNOWN (IMMATURE)
NEW U UNKNOWN
 
OLD J SEX UNKN (PART DEV.,PART SPENT
NEW U UNKNOWN
 
OLD K SEX UNKN (DEVELOPING)
NEW U UNKNOWN
 
OLD L MALE - Developing
NEW M MALE
 
OLD O SEX UNKNOWN (SPENT)
NEW U UNKNOWN
 
OLD P MALE - Spent
NEW M MALE
 
OLD Q MALE (PART DEVELOP.,PART RIPE)
NEW M MALE
 
OLD R FEMALE (PART DEVEL.,PART RIPE)
NEW F FEMALE
 
OLD V MALE - With Sperm
NEW M MALE
 
OLD X FEMALE (PART DEVEL.,PART SPENT
NEW F FEMALE
 
OLD Y MALE (PART DEVEL.,PART SPENT)
NEW M MALE
 
 
16 FIELD_SPLIT SEFSC TIP_TIP41 SEX OPTIONAL VARCHAR2(1)
13 FIELD_SPLIT TIPONLINE OBSERVATION MATURITY_STAGE_ID OPTIONAL NUMBER
13 FIELD_SPLIT The tip_tip41.sex code was actually a mixture of sex and sexual maturity. The new system strives to have only 1 type of information in a single field. The value must match id in the table Tiponline.Maturity_Stage. The sexual maturity was split as follows:
13 FIELD_SPLIT
Old? Code Description
OLD 0 MALE - Without Sperm
NEW 1 INACTIVE
 
OLD 1 MALE - Maturation Unknown
NEW 0 UNKNOWN
 
OLD 2 FEMALE - Maturation Unknown
NEW 0 UNKNOWN
 
OLD 3 UNKNOWN
NEW 0 UNKNOWN
 
OLD 4 TAR(LOBSTER)
NEW 6 TAR
 
OLD 5 GONADS TAKEN
NEW 0 UNKNOWN
 
OLD 6 FEMALE - Without Eggs
NEW 1 INACTIVE
 
OLD 7 FEMALE - With Eggs
NEW 3 RIPE, RUNNING
 
OLD 8 FEMALE - Developing
NEW 2 DEVELOPING
 
OLD 9 FEMALE - Spent
NEW 4 SPENT
 
OLD A MALE (MATURE BUT INACTIVE)
NEW 1 INACTIVE
 
OLD B FEMALE (MATURE BUT INACTIVE)
NEW 1 INACTIVE
 
OLD H SEX UNKNOWN (MATURE BUT INACTV
NEW 1 INACTIVE
 
OLD I SEX UNKNOWN (IMMATURE)
NEW 5 IMMATURE
 
OLD J SEX UNKN (PART DEV.,PART SPENT
NEW 2 DEVELOPING
 
OLD K SEX UNKN (DEVELOPING)
NEW 2 DEVELOPING
 
OLD L MALE - Developing
NEW 2 DEVELOPING
 
OLD O SEX UNKNOWN (SPENT)
NEW 4 SPENT
 
OLD P MALE - Spent
NEW 4 SPENT
 
OLD Q MALE (PART DEVELOP.,PART RIPE)
NEW 2 DEVELOPING
 
OLD R FEMALE (PART DEVEL.,PART RIPE)
NEW 2 DEVELOPING
 
OLD V MALE - With Sperm
NEW 3 RIPE, RUNNING
 
OLD X FEMALE (PART DEVEL.,PART SPENT
NEW 2 DEVELOPING
 
OLD Y MALE (PART DEVEL.,PART SPENT)
NEW 2 DEVELOPING
 
 
18 UNCHANGED SEFSC TIP_TIP41 AGE_STATUS OPTIONAL VARCHAR2(1)
10 UNCHANGED TIPONLINE OBSERVATION AGE_STATUS OPTIONAL VARCHAR2(20)
10 CODE_CHANGE The field was carried unchanged from the historical data, but not shown on the screen.
 
18 UNCHANGED SEFSC TIP_TIP41 AGE OPTIONAL NUMBER(2)
32 UNCHANGED TIPONLINE OBSERVATION AGE OPTIONAL VARCHAR2(20)
32 UNCHANGED The field was carried unchanged from the historical data, but not shown on the screen.
 
21 OLD_FIELD_DROPPED SEFSC TIP_TIP41 TYPE_51_RECORDS OPTIONAL NUMBER(3)
- OLD_FIELD_DROPPED - - - - -
- OLD_FIELD_DROPPED The field is no longer needed and was dropped.
 
17 NAME_CHANGE SEFSC TIP_TIP31 SAMPLE_TYPE OPTIONAL VARCHAR2(2)
6 NAME_CHANGE TIPONLINE OBSERVATION SAMPLE_METHOD_TYPE_ID MANDATORY NUMBER
6 NAME_CHANGE The value must match id in the table Tiponline.Sample_Method_Type. In TIPONLINE, the sample method in observation was carried over from the corresponding sample record. See Tip_tip31.Sample_Type for the codes.
 
- NEW_FIELD_ADDED - - - - -
1 NEW_FIELD_ADDED TIPONLINE OBSERVATION ID MANDATORY NUMBER
1 NEW_FIELD_ADDED New field added. TIPONLINE.Observation.Id is a sequential number generated when the OBSERVATION record is created. That number is assigned to TIPONLINE.Observation_Sample.Observation_Id to relate that observation sample record to a particular Observation record.
 
- NEW_FIELD_ADDED - - - - -
2 NEW_FIELD_ADDED TIPONLINE OBSERVATION INTERVIEW_ID MANDATORY NUMBER
2 NEW_FIELD_ADDED New field added. TIPONLINE.Interview.Id is a sequential number generated when the interview record is created. That number is assigned to TIPONLINE.OBSERVATION.Interview_Id to relate this OBSERVATION to a particular interview. There is also an Interview_id field in TIPONLINE.Effort, TIPONLINE.Landing and TIPONLINE.Sample. The field is shown as the last digits on the Interview Number after the characters for the state code.
 
- NEW_FIELD_ADDED - - - - -
7 NEW_FIELD_ADDED TIPONLINE OBSERVATION CREATED_BY_USER_ID MANDATORY VARCHAR2(20)
7 NEW_FIELD_ADDED New field added. Whenever a record is created, the Oracle user id is automatically recorded in this field. Not shown on screen.
 
- NEW_FIELD_ADDED - - - - -
8 NEW_FIELD_ADDED TIPONLINE INTERVIEW CREATED_DATE MANDATORY DATE
8 NEW_FIELD_ADDED New field added. Whenever a record is created, the date and time of the record creation is automatically recorded in this field. Not shown on the screen.
 
- NEW_FIELD_ADDED - - - - -
9 NEW_FIELD_ADDED TIPONLINE OBSERVATION SAMPLE_ID OPTIONAL NUMBER
9 NEW_FIELD_ADDED New field added. It does not exist in the historical data. It holds the Sample.Id, which relates this Observation record to a Sample record.
 
- NEW_FIELD_ADDED - - - - -
12 NEW_FIELD_ADDED TIPONLINE OBSERVATION GONAD_WEIGHT OPTIONAL NUMBER
12 NEW_FIELD_ADDED New field added. It does not exist in the historical data. It was not used and is not shown on the screen. It will be removed in a future version.
 
- NEW_FIELD_ADDED - - - - -
16 NEW_FIELD_ADDED TIPONLINE OBSERVATION OBS_COMMENT OPTIONAL VARCHAR2(4000)
16 NEW_FIELD_ADDED New field added. It does not exist in the historical data.
 
- NEW_FIELD_ADDED - - - - -
19 NEW_FIELD_ADDED TIPONLINE OBSERVATION LENGTH3 OPTIONAL NUMBER
19 NEW_FIELD_ADDED New field added. It does not exist in the historical data. It can be entered in the online data entry program.
 
- NEW_FIELD_ADDED - - - - -
22 NEW_FIELD_ADDED TIPONLINE OBSERVATION LENGTH_UNIT_ID3 OPTIONAL NUMBER
22 NEW_FIELD_ADDED New field added. The value must match id in the table Tiponline.Length_Unit. It does not exist in the historical data, which has, at most, two lengths. A third length can be entered in the online data entry program. It has the same new codes as Observation.Length_Unit_Id1.
 
- NEW_FIELD_ADDED - - - - -
25 NEW_FIELD_ADDED TIPONLINE OBSERVATION LENGTH_TYPE_ID3 OPTIONAL NUMBER
25 NEW_FIELD_ADDED New field added. The value must match id in the table Tiponline.Length_Type. It does not exist in the historical data, which has, at most, two lengths. A third length can be entered in the online data entry program. It has the same new codes as Observation.Length_Type_Id1.
 
- NEW_FIELD_ADDED - - - - -
26 NEW_FIELD_ADDED TIPONLINE OBSERVATION MODIFIED_BY_USER_ID OPTIONAL VARCHAR2(20)
26 NEW_FIELD_ADDED New field added. This field is comparable to sefsc.tip_changes.userid. However, sefsc.TIP_TIP41 does not record such information. The new TIPONLINE program will automatically record the Oracle user id of the person last updating the record. Not shown on screen.
 
- NEW_FIELD_ADDED - - - - -
27 NEW_FIELD_ADDED TIPONLINE OBSERVATION MODIFIED_DATE OPTIONAL DATE
27 NEW_FIELD_ADDED New field added. This field is comparable to sefsc.tip_changes.changedate. However, sefsc.TIP_TIP41 does not record such information. The new TIPONLINE program will automatically record the last date and time the record is updated. Not shown on screen.
 
- NEW_FIELD_ADDED - - - - -
33 NEW_FIELD_ADDED TIPONLINE OBSERVATION STANDARD_SPECIES_ID OPTIONAL VARCHAR2(20)
33 NEW_FIELD_ADDED New field added. The value must match id in the table Tiponline.Standard_Species. This field is automatically filled in by a trigger using information provided by the species_code.
 

SEFSC.TIP_TIP41 FILLS TIPONLINE.OBSERVATION_SAMPLE

COLUMN ORDER TRANSFORMATION OLD: OWNER TABLE COLUMN NAME MANDATORY? TYPE
COLUMN ORDER TRANSFORMATION NEW: OWNER TABLE COLUMN NAME MANDATORY? TYPE
1 UNCHANGED SEFSC TIP_TIP41 TAG_NUMBER OPTIONAL VARCHAR2(3)
3 UNCHANGED TIPONLINE OBSERVATION_SAMPLE TAG_NUMBER MANDATORY NUMBER
3 UNCHANGED One, two or three observation_sample records will be created from tip_tip41.age_structure. When age_structure and tag_number are provided, the tag_number field is carried unchanged for each observation_sample record created.
 
17 FIELD_SPLIT SEFSC TIP_TIP41 AGE_STRUCTURE OPTIONAL VARCHAR2(2)
4 FIELD_SPLIT TIPONLINE OBSERVATION_SAMPLE SAMPLE_TYPE_ID MANDATORY NUMBER
4 FIELD_SPLIT The value must match id in the table Tiponline.Observation_Sample_Method_Type. One, two or three observation_sample records will be created from tip_tip41.age_structure. The following age structure codes provide the first observation_sample record.
4 FIELD_SPLIT
Old? Code Description
OLD 1 SCALE
NEW 2 SCALES
 
OLD 2 PECTORAL FIN RAY
NEW 7 FINRAY
 
OLD 3 OTOLITH
NEW 1 OTOLITH
 
OLD 4 SCALE AND OTOLITH
NEW 2 SCALES
 
OLD 5 DORSAL SPINE
NEW 3 SPINES
 
OLD 6 OTOLITH AND TISSUE
NEW 1 OTOLITH
 
OLD 7 OTOLITH AND GONAD
NEW 1 OTOLITH
 
OLD 8 GONAD
NEW 10 GONAD
 
OLD 9 TISSUE
NEW 19 TISSUE
 
OLD A OTOLITH, SPINE AND GONAD
NEW 1 OTOLITH
 
OLD B OTOLITH, SCALE AND GONAD
NEW 1 OTOLITH
 
OLD C OTOLITH, SCALE AND SPINE
NEW 1 OTOLITH
 
OLD D TISSUE, SCALE AND SPINE
NEW 19 TISSUE
 
OLD E MUSCLE
NEW 18 MUSCLE
 
OLD F HEART
NEW 16 HEART
 
OLD G LIVER
NEW 17 LIVER
 
OLD H EYE LENSES
NEW 15 EYE LENSES
 
OLD V VERTEBRAE
NEW 4 VERTEBRAE
 
4 FIELD_SPLIT One, two or three observation_sample records will be created from tip_tip41.age_structure. The following age structures codes provide a second observation_sample record.
4 FIELD_SPLIT
Old? Code Description
OLD 4 SCALE AND OTOLITH
NEW 1 OTOLITH
 
OLD 6 OTOLITH AND TISSUE
NEW 19 TISSUE
 
OLD 7 OTOLITH AND GONAD
NEW 10 GONAD
 
OLD A OTOLITH, SPINE AND GONAD
NEW 3 SPINES
 
OLD B OTOLITH, SCALE AND GONAD
NEW 2 SCALES
 
OLD C OTOLITH, SCALE AND SPINE
NEW 2 SCALES
 
OLD D TISSUE, SCALE AND SPINE
NEW 2 SCALES
 
4 FIELD_SPLIT One, two or three observation_sample records will be created from tip_tip41.age_structure. The following age structures codes provide a third observation_sample record.
4 FIELD_SPLIT
Old? Code Description
OLD A OTOLITH, SPINE AND GONAD
NEW 10 GONAD
 
OLD B OTOLITH, SCALE AND GONAD
NEW 10 GONAD
 
OLD C OTOLITH, SCALE AND SPINE
NEW 3 SPINES
 
OLD D TISSUE, SCALE AND SPINE
NEW 3 SPINES
 
 
- NEW_FIELD_ADDED - - - - -
1 NEW_FIELD_ADDED TIPONLINE OBSERVATION_SAMPLE ID MANDATORY NUMBER
1 NEW_FIELD_ADDED New field added. TIPONLINE.Observation_Sample.Id is a sequential number generated when the Observation_Sample record is created. It is not shown on the screen.
 
- NEW_FIELD_ADDED - - - - -
2 NEW_FIELD_ADDED TIPONLINE OBSERVATION_SAMPLE OBSERVATION_ID MANDATORY NUMBER
2 NEW_FIELD_ADDED New field added. TIPONLINE.Observation.Id is a sequential number generated when the Observation record is created. That number is assigned to TIPONLINE.Observation_Sample.Observation_Id to relate this Observation_Sample to a particular Observation record. It is not shown on the screen.
 
- NEW_FIELD_ADDED - - - - -
5 NEW_FIELD_ADDED TIPONLINE OBSERVATION_SAMPLE CREATED_BY_USER_ID MANDATORY VARCHAR2(20)
5 NEW_FIELD_ADDED New field added. Whenever a record is created, the Oracle user id is automatically recorded in this field. Not shown on screen.
 
- NEW_FIELD_ADDED - - - - -
6 NEW_FIELD_ADDED TIPONLINE OBSERVATION_SAMPLE CREATED_DATE MANDATORY DATE
6 NEW_FIELD_ADDED New field added. Whenever a record is created, the date and time of the record creation is automatically recorded in this field. Not shown on the screen.
 
- NEW_FIELD_ADDED - - - - -
7 NEW_FIELD_ADDED TIPONLINE OBSERVATION_SAMPLE MODIFIED_BY_USER_ID OPTIONAL VARCHAR2(20)
7 NEW_FIELD_ADDED New field added. This field is comparable to sefsc.tip_changes.userid. However, sefsc.TIP_TIP41 does not record such information. The new TIPONLINE program will automatically record the Oracle user id of the person last updating the record. Not shown on screen.
 
- NEW_FIELD_ADDED - - - - -
8 NEW_FIELD_ADDED TIPONLINE OBSERVATION_SAMPLE MODIFIED_DATE OPTIONAL DATE
8 NEW_FIELD_ADDED New field added. This field is comparable to sefsc.tip_changes.changedate. However, sefsc.TIP_TIP41 does not record such information. The new TIPONLINE program will automatically record the last date and time the record is updated. Not shown on screen.