• Home
• About Us
  • Staff
  • Job Opportunities
  • Leadership
  • Labs
  • Divisions and Groups
• Species
  • Corals
  • Dolphins
  • Fish
  • Invasive/ Exotic
  • Sharks
  • Shrimp
  • Turtles
  • Whales
• Research & Data
• Publications & Forms
  • Publications
  • Forms
  • Library
• Education & Outreach
• For Fishermen/Dealers
  • Permits (SERO)
  • Commercial Data Collection
  • Vessel Reporting Requirements
  • Dealer Reporting Requirements
• For SEFSC Personnel

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.

• The Column Order field describe the physical order in which the field appears in the Oracle table at the time of writing.
• The Transformation field classifies how the field was changed.
• The Owner field gives the Oracle user or schema that owns the table.
• The Table field gives the name of the tables where the data is stored.
• The Column Name describes the fields under discussion.
• The Mandatory? column describes whether the Oracle table requires a value (Mandatory) or permits blanks (Optional).
• The Type column describe the Oracle data type:
  • VARCHAR2(3) means character data up to 3 characters wide
  • NUMBER(3) means numeric data up to 3 digits wide
  • NUMBER means numeric data with 38 digits of precision, more than is needed for TIP data. You decide how many decimal places to add.
  • NUMBER(7,2) means 7 total digits, 5 whole numbers and 2 decimal digits. The plus or minus sign and the decimal point don't count.
  • DATE means a field that has Month, Date, Century, Year encoded into it.

---

TABLE OF CONTENTS

• TIP_TIP11 (Trip - Part 1)
• TIP_TIP12 (Trip - Part 2)
• TIP_TIP13 (Effort)
• TIP_TIP21 (Landing)
• TIP_TIP31 (Samples)
• TIP_TIP41 (Observation)
• TIP_TIP41 (Observation_Sample)

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 ALABAMA FLORIDA EAST COAST FLORIDA WEST COAST GEORGIA LOUISIANA MASSACHUSETTS MISSISSIPPI NORTH CAROLINA SOUTH CAROLINA TEXAS VIRGINIA MEXICO PUERTO RICO VIRGIN ISLANDS ANTIGUA/BARBUDA BARBADOS BRITISH VIRGIN ISLANDS BELIZE COMMONWEALTH OF DOMINICA GRENADA GUYANA JAMAICA MONTSERRAT ST. KITTS ST. LUCIA NEVIS ST. VINCENT AND THE GRENADINES TOBAGO TRINIDAD
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.