Report Extract Spreadsheet Columns

The following tables show the pre-defined columns that can be present in the report extracts downloaded as MS Excel or CSV files. Additional columns can be created and populated using formulas. These addition columns must be created in a template Excel file and uploaded using the template upload feature. The formula value for a column must be set in all rows of the spreadsheet where the formula is desired. The eLandings Report Extract fills in rows in the uploaded template file, ignoring columns with labels other than those defined in the table below. Any value in a column with one of the pre-defined column names will be overwritten.

Landing Report

Column Label

Data Type

Oracle Database Data Definition

Values

landing_report_id

integer

NUMBER(10,0)

Landing report IDs will be between 1 and 9,999,999,999

type_of_landing_report

text

CHAR(1)

Valid Types of landing reports are:
C - Crab
G - Groundfish
B - Salmon

type_of_landing_report.name

text

VARCHAR2(50)

The names of landing report types are as above.

status

integer

NUMBER(10,0)

Status values are:
0 - Not submitted
4 - Initial Report Submitted
8 - Final Report Submitted
16 - Report Voided

status.name

text

VARCHAR2(25)

The names of status types are as above.

date_fishing_ended

date

DATE

 

vessel

integer

NUMBER(5,0)

Vessel is the ADF&G Number of the vessel. Vessel ADF&G numbers can be looked up on the CFEC website

vessel.name

text

VARCHAR2(50)

Vessel names can be looked up on the CFEC website, as above.

crew_size

integer

NUMBER(3,0)

Crew size is the size of the crew including the skipper. Rules for crew size are documented by the eLandings business rules

observers_onboard

integer

NUMBER(2,0)

Observers onboard is the number of observers. Rules for observers onboard are documented by the eLandings business rules

port_of_landing

text

CHAR(3)

Port of landing is the eLandings port code. Valid values can be looked up on the eLandings website

port_of_landing.name

text

VARCHAR2(50)

Port of landing name is the city or location associated with the port code. Values can be looked up on the eLandings website, as above.

port_of_landing.ifq_port_code

integer

NUMBER(3,0)

IFQ port code is the numeric code used on the IFQ system. It is associated with the eLandings port code, and can be looked up on the eLandings website. The IFQ port code appears on IFQ receipts.

delivery_port_region

text

VARCHAR2(3)

The Delivery Port Region is the IFQ system port or region code used on some IFQ landings. Valid values can be looked up on the eLandings website

gear

integer

NUMBER(3,0)

Gear is the eLandings gear code. Valid values can be looked up on the eLandings website

gear.name

text

VARCHAR2(25)

Gear name is the description of the gear associated with the gear code. Values can be looked up on the eLandings website, as above.

proc_code_owner

text

VARCHAR2(6)

Proc code owner is the processor code of the processor who is buying the catch.

proc_code_owner.processor

text

VARCHAR2(50)

Proc code owner processor is the name of the processor who is buying the catch.

proc_code_processor

text

VARCHAR2(6)

Proc code processor is the processor code of the processor who is receiving and the catch, in cases of custom processing.

proc_code_processor.processor

text

VARCHAR2(50)

Proc code processor processor is the name of the processor who is receiving and the catch, in cases of custom processing.

date_fishing_began

date

DATE

Date fishing began is the date that the gear first went in the water.

days_fished

integer

NUMBER(3,0)

Days fished is the number of days between the date fishing began and the date of landing when gear was in the water and fishing was taking place. The business rules for days fished are on the eLandings website

date_of_landing

dateTime

DATE

Date of landing is the date upon which the offload from the catcher vessel was completed.

partial_delivery

boolean

CHAR(1)

Partial Delivery indicates whether or not the delivery was for all fish caught on the trip. Value will be TRUE or FALSE.

last_delivery_for_trip

boolean

CHAR(1)

Last Delivery For Trip indicates whether or not the vessel completed offloading all fish onboard with the current delivery. Value will be TRUE or FALSE.

multiple_ifq_permits

boolean

CHAR(1)

Multiple IFQ Permits indicates whether or not the skipper and crew had more than one IFQ permit under which they did the fishing. Value will be TRUE or FALSE.

manual_ifq_report

boolean

CHAR(1)

Manual IFQ Report indicates whether or not an IFQ report for the landing was made manually by phone to the NMFS Data Technicians. Value will be TRUE or FALSE.

nearest_bay_or_headland

text

VARCHAR2(50)

The nearest bay or headland is a text description of the geographic location where the fishing took place. The business rules for nearest bay or headland are on the eLandings website

federal_processor_number

integer

NUMBER(6,0)

Federal Processor Number is the Federal Processing Permit or Federal Fisheries Permit of the receiving processor.

registered_buyer_number

integer

NUMBER(6,0)

Registered Buyer Number is the groundfish IFQ registered buyer number of the receiving processor.

registered_crab_receiver_number

integer

NUMBER(6,0)

Registered Crab Receiver Number is the crab IFQ registered receiver number of the receiving processor.

discard_report

text

CHAR(2)

Discard Report indicates the whether discard report blue sheets were received by the processor, or the reason they were not received. Values are:
RC - Received
NC - Not Received
NP - Not Required, vessel not federally permitted
NL - Not Required, vessel less than 60 feet

discard_report.desc

text

VARCHAR2(50)

The description associated with the discard report code, values as above.

tender_vessel

integer

NUMBER(5,0)

Tender Vessel is the ADF&G Number of the tender. Vessel ADF&G numbers can be looked up on the CFEC website

tender_vessel.name

text

VARCHAR2(50)

The name of the tender. Names can be looked up on the CFEC website, as above.

chill_type

text

VARCHAR2(3)

The fish hold chilling system type. Valid chill types are documented on the eLandings website

chill_type.desc

text

VARCHAR2(60)

The description of the chilling system type identified by the chill type.

rsw_temp

decimal

NUMBER(3,1)

The temperature of the fish, as maintained by the chilling system, whether Refrigerated SeaWater or another type. Business rules for the temperature are on the eLandings website

dock_delivery

boolean

CHAR(1)

Dock Delivery indicates whether or not delivery was made to a tender vessel tied up at the processing plant dock. Value will be TRUE or FALSE.

buying_station_name

text

VARCHAR2(60)

The operation name of a buying station operation. It can be up to 60 characters long.

cfec_permit.fishery

text

VARCHAR2(6)

The CFEC permit fishery for the permit. CFEC permits can be looked up on the CFEC website

cfec_permit.permit

text

CHAR(6)

The permit number portion of the CFEC permit, including check character, for a total length of 6 characters.

cfec_permit.year_seq

text

CHAR(5)

The two digit year and the two digit sequence within the year of the permit card. The year sequence includes a check character, for a total length of 5 characters.

cfec_permit.holder

text

VARCHAR2(60)

The name of the permit holder, which can be up to 60 characters long

cfec_permit.serial_number

integer

NUMBER(9,0)

The CFEC file number, or serial number, that uniquely identifies the permit holder.

mag_stripe_read

boolean

CHAR(1)

Mag Stripe Read indicates whether or not the CFEC card was read by a magnetic stripe reader. Value will be TRUE or FALSE.

management_program

text

VARCHAR2(5)

The abbreviation of the management program under which the fishing took place. The valid values can be looked up on the eLandings website

management_program_id

integer

NUMBER(3,0)

The management program participant ID, for management programs that require participant IDs. The valid values can be looked up on the eLandings website

dual_permit

boolean

CHAR(1)

Dual permit indicates whether two or more permit holders were aboard the catcher vessel, allowing additional gear to be deployed. Value will be TRUE or FALSE.

tender_batch

text

VARCHAR2(10)

A processor assigned tender batch number. It can be up to ten characters in length.

floating

boolean

CHAR(1)

Floating indicates whether or not salmon were floating in a tank when unloaded to a tender. Value will be TRUE or FALSE.

slide

boolean

CHAR(1)

Slide indicates whether or not salmon were unloaded to a tender using a slide. Value will be TRUE or FALSE.

round_weight

decimal

NUMBER(13,4)

Round weight is the weight for the catch, converted to round, or green weight according to the condition code. Values will be between 0 and 999,999,999.9999

fish_ticket_number

text

CHAR(10)

Fish Ticket Number is the ticket number that associates particular catch lines with particular permits on the landing report. The business rules for the fish ticket number format are on the eLandings website

.

stat_area

integer

NUMBER(6,0)

Stat area is the statistical area where the catch took place. Valid values can be looked up on the eLandings website

species

integer

NUMBER(3,0)

Species is the numeric species code. Valid values can be looked up on the eLandings website

species.name

text

VARCHAR2(60)

Species name is the name associated with the species code. Values can be looked up on the eLandings website, as above

condition_code

integer

NUMBER(3,0)

Condition code is the condition of the fish regarding any processing that has already taken place. Valid values can be looked up on the eLandings website

condition_code.name

text

VARCHAR2(60)

Condition code name is the description associated with the condition code. Values can be looked up on the eLandings website, as above.

weight

decimal

NUMBER(13,4)

Weight is the scale weight of the catch item. It will be between 0 and 999,999,999.9999

weight_modifier

text

VARCHAR2(10)

The weight modifier indicates considerations that apply to the weight of the catch item. Valid values are:
I/S - ice and slime are include, for the purposes of IFQ reporting
EST - Weight is estimated, rather than true scale weight.

count

decimal

NUMBER(13,4)

Count is the number of fish or animals documented by the catch item. It will be between 1 and 100,000,000.

effort

decimal

NUMBER(5,0)

Effort is the effort, in units appropriate to the gear, that produced the catch item. Values will be between 1 and 10,000.

disposition_code

integer

NUMBER(3,0)

Disposition code is the numeric code indicating the disposition of the catch item. Valid values can be looked up on the eLandings website

disposition_code.name

text

VARCHAR2(60)

Disposition Code Name is the description associated with the disposition code. Values can be looked up on the eLandings website, as above.

sold_round_weight

decimal

NUMBER(13,4)

The sold round weight is the sold weight for the product code, converted to round, or green weight. Values will be between 0 and 999,999,999.9999

product_code

integer

NUMBER(3,0)

Product code is the condition code of the sold product. Valid values can be looked up on the eLandings website

product_code.name

text

VARCHAR2(60)

The product code name is the description associated with the product code. Values can be looked up on the eLandings website, as above.

product_type

text

CHAR(1)

Product type identifies whether the item is the main product produced from the fish, or is additional product. Valid values are:
P - Primary
A - Ancillary

size_grade

text

VARCHAR2(16)

The size and grade is the processor's short description of the size and or grading. It can be up to 16 characters long.

sold_weight

decimal

NUMBER(13,4)

The sold weight will be between 0 and 999,999,999.9999

price

decimal

NUMBER(6,4)

Price is the price per pound, and will between -100.00 and 100.00. Negative prices are allowed for some situations where processors charge fees for handling of certain items.

Production Report

Column Label

Data Type

Oracle Database Data Definition

Values

production_report_id

integer

NUMBER(10,0)

Production report IDs will be between 1 and 9,999,999,999

status

integer

NUMBER(10,0)

Status values are:
0 - Not submitted
8 - Final Report Submitted
16 - Report Voided

status.name

text

VARCHAR2(25)

The names of status types are as above.

type_of_production_report

text

CHAR(1)

Valid Types of production reports are:
A - At-sea
S - Shoreside

report_date

date

DATE

Date of the report, referring to the date when the production took place.

no_deliveries

boolean

CHAR(1)

No Deliveries indicates whether or not the operation received deliveries from catcher vessels on the date of the report. No Deliveries only applies to Shoreside production reports. Value will be TRUE or FALSE.

no_production

boolean

CHAR(1)

No Production indicates whether or not the operation did production on the date of the report. No Production indicates that the lack of production items is because there was no data to report. Value will be TRUE or FALSE.

vessel

integer

NUMBER(5,0)

Vessel is the ADF&G Number of the at-sea processing vessel. Vessel ADF&G numbers can be looked up on the CFEC website. Vessel applies to At-Sea production reports only.

vessel.name

text

VARCHAR2(50)

Vessel names can be looked up on the CFEC website, as above.

gear

integer

NUMBER(3,0)

Gear is the eLandings gear code. Valid values can be looked up on the eLandings website. Gear applies to At-Sea production reports only.

gear.name

text

VARCHAR2(25)

Gear name is the description of the gear associated with the gear code. Values can be looked up on the eLandings website, as above.

crew_size

integer

NUMBER(3,0)

Crew size is the size of the crew including the skipper, for at-sea processors. Crew Size applies to At-Sea production reports only. Rules for crew size are documented by the eLandings business rules

port_of_landing

text

CHAR(3)

Port of landing is the eLandings port code for Shoreside production reports, or the at-sea operation type for At-Sea production reports. Valid values can be looked up on the eLandings website

port_of_landing.name

text

VARCHAR2(50)

Port of landing name is the city or location associated with the port code. Values can be looked up on the eLandings website, as above.

observers

integer

NUMBER(2,0)

Observers is the number of observers in the processing plant. Observers applies to Shoreside production reports only. Rules for observers onboard are documented by the eLandings business rules

federal_processor_number

integer

NUMBER(6,0)

Federal Processor Number is the Federal Processing Permit for Shoreside Production Reports and At-Sea Production Reports for motherships, and the Federal Fisheries Permit for catcher/processors.

federal_processor_number.name

text

VARCHAR2(50)

Federal Processor Number Name is the name of the processor.

proc_code

text

VARCHAR2(6)

Proc code is the ADF&G processor code of the processing plant for Shoreside production reports. It is not used on At-Sea production reports.

proc_code_owner.processor

text

VARCHAR2(50)

Proc code processor is the name of the processor.

fed_area

integer

NUMBER(6,0)

Fed area is the Federal reporting area where the catch took place. Valid values can be looked up on the eLandings website

special_area

text

VARCHAR2(5)

Valid special areas are:
AISWW - Aleutian Islands State Waters West of 120W
COBLZ - Opilio Crab Bycatch Limitation Zone
RKCSA - Red King Crab Savings Area

special_area.desc

text

N/A

The names of special areas, as above.

management_program

text

VARCHAR2(5)

The abbreviation of the management program under which the fishing took place. The valid values can be looked up on the eLandings website

management_program_id

integer

NUMBER(3,0)

The management program participant ID, for management programs that require participant IDs. The valid values can be looked up on the eLandings website

trip_event_code

integer

NUMBER(2,0)

Trip event code values are:
1 - New Week
2 - Gear Change
3 - Offloaded Product
4 - Directed Fishing Closure
5 - Enter SSL Protection Area
6 - Leave SSL Protection Area

trip_event_code.name

text

VARCHAR2(60)

The names of trip events, as above.

item_type

text

N/A

Item type identifies whether the item is a production item, or for At-Sea production reports a discard item. Valid values are:
production item
discard item

round_weight

decimal

NUMBER(13,4)

Round weight is the weight for the production or discard item, converted to round, or green weight according to the condition code. Values will be between 0 and 999,999,999.9999

fmp_area

integer

VARCHAR2(5)

Federal Management Plan area. FMP Area only applies to Shoreside production reports. Values are:
BSAI - Bering Sea and Aleutian Islands
GOA - Gulf of Alaska

fmp_area.description

text

VARCHAR2(50)

The names of FMP areas, as above.

species

integer

NUMBER(3,0)

Species is the numeric species code. Valid values can be looked up on the eLandings website

species.name

text

VARCHAR2(60)

Species name is the name associated with the species code. Values can be looked up on the eLandings website, as above

product_type

text

CHAR(1)

Product type identifies whether the item is the main product produced from the fish, or is additional product. Valid values are:
P - Primary
A - Ancillary
R - Reprocessed

product_code

integer

NUMBER(3,0)

Product code is the condition of the fish regarding processing that has taken place. Valid values can be looked up on the eLandings website, as condition codes

product_code.name

text

VARCHAR2(60)

Product code name is the description associated with the product code. Values can be looked up on the eLandings website, as above.

weight

decimal

NUMBER(13,4)

Weight is the scale weight of the production or discard item. It will be between 0 and 999,999,999.9999

weight.units

text

VARCHAR2(2)

Weight Units is the unit of measure for the weight. It is not used on At-Sea or Shoreside production reports, and is always assumed to be metric tons.

disposition_code

integer

NUMBER(3,0)

Disposition code is the numeric code indicating the disposition of the discard item. Valid values can be looked up on the eLandings website

disposition_code.name

text

VARCHAR2(60)

Disposition Code Name is the description associated with the disposition code. Values can be looked up on the
eLandings website, as above.

count

decimal

NUMBER(13,4)

Count is the number of fish or animals documented by the discard item. It will be between 1 and 100,000,000.