Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Item_number
    The item_number element is just the sequential item number for the report. However, item numbers may have a break in their sequence if a report is submitted, and then a line item is deleted.
  2. Fish_ticket_number
    The fish_ticket_number element contains the fish ticket for the line. It will match one of the fish ticket numbers specified on the permit worksheet.
    It indicates the relationship between the CFEC permit and the catch, which is documented on the printed fish ticket.

    Data Type

    Since Schema Version

    Oracle Database Data Definition

    Values

    text

    1.0

    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

    .

  3. Stat_area
    The stat_area element indicates the statistical area for the catch documented on the line item. The stat_are element is not required. If it is not present then the statistical areas for the catch documented on the line item are specified by the stat area worksheet. The percentages on the stat area worksheet indicate the allocation of the catch weight to statistical areas.

    Data Type

    Since Schema Version

    Oracle Database Data Definition

    Values

    integer

    1.0

    NUMBER(6,0)

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

    The stat_area element has four attributes.
    • #** fed_area - The Federal Reporting Area where the statistical area lies.
      • fed_area_2 - If the statistical area crosses a federal reporting area boundary, the fed_area_2 attribute will be present, containing the second Federal Reporting Area. Otherwise, it will be omitted.
      • iphc_area - The IPHC Regulatory Area where the statistical area lies.
      • iphc_area_2 - If the statistical area crosses an IPHC area boundary, the iphc_area_2 attribute will be present, containing the second IPHC Regulatory Area. Otherwise, it will be omitted.
  4. Species
    The species element is always present. It is the ADF&G numeric species code, and it indicates the species of the catch documented on the line item.

    Data Type

    Since Schema Version

    Oracle Database Data Definition

    Values

    integer

    1.0

    NUMBER(3,0)

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

    The species element includes one attribute, the species name.

    Data Type

    Since Schema Version

    Oracle Database Data Definition

    Values

    text

    1.0

    VARCHAR2(60)

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

  5. Condition_code
    The condition_code element is always present. It is the numeric condition code indicating the physical state of the catch in terms of processing already done to it. The condition code is used to determine the product recovery rate to apply to the line item weight to derive the round weigh of the catch documented on the line item.

    Data Type

    Since Schema Version

    Oracle Database Data Definition

    Values

    integer

    1.0

    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

    The condition code has a name attribute.

    Data Type

    Since Schema Version

    Oracle Database Data Definition

    Values

    text

    1.0

    VARCHAR2(60)

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

  6. Weight
    The weight element is always present for sold items, and is usually present, except for discard items where only a count is documented. This element is the scale weight in pounds for the line item, unless the weight_modifier element indicates it is estimated weight. The weight may include up to 4 decimal places.

    Data Type

    Since Schema Version

    Oracle Database Data Definition

    Values

    decimal

    1.0

    NUMBER(13,4)

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

  7. Weight_modifier
    The weight_modifier element is not always present. It is primarily used on groundfish IFQ landing reports to document whether Ice and Slime is included in the weight. The Ice and Slime value can only be used for halibut and sablefish. The estimated value is used for hailed weight fish tickets, and should not be seen for line items on submitted reports.

    Data Type

    Since Schema Version

    Oracle Database Data Definition

    Values

    text

    1.0

    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.

  8. Count
    The count element is always present for IFQ crab sold items and salmon, is generally not populated for groundfish. The count element is the number of animals accounted for on that line item. For discard lines on groundfish reports count will be present if weight is omitted.

    Data Type

    Since Schema Version

    Oracle Database Data Definition

    Values

    decimal

    1.0

    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.

  9. Effort
    The effort element is used for IFQ crab. This is the number of pot lifts. Effort will not be present for groundfish or salmon reports. Effort on crab landing reports may not be present if the line item does not have a statistical area noted. In that case the effort is documented on the statistical area worksheet.

    Data Type

    Since Schema Version

    Oracle Database Data Definition

    Values

    decimal

    1.0

    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.

  10. Disposition_code
    The disposition_code element will always be present. It identifies the final usage or action of the line item, such as sold for human consumption or discarded at sea. ||Data Type||Since Schema Version||Oracle Database Data Definition||Values||

    integer

    1.0

    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

    The disposition code has a name attribute.

    Data Type

    Since Schema Version

    Oracle Database Data Definition

    Values

    text

    1.0

    VARCHAR2(60)

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

  11. Agency_line_data
    The agency_line_data element will be omitted from reports that are made visible to processors and third party systems.
  12. Product_item
    The product_item element may be present for line items that have sold dispositions, and in certain other cases. Multiple product_item elements may be specified per line item, for cases where the line item amount has multiple sizes and grades. For line items with a condition code that can be either a primary or ancillary product, at least one product_item will be present. In that case, if the disposition of the line item is not a sold disposition then the product_item will not have a price.
    1. Item_number
      The item_number element is just the sequential item number for the product items under the line item. However, item numbers may have a break in their sequence if a report is submitted, and then a product item is deleted.
    2. Product_code
      The product_code element will always be present. Product code is a misnomer; this data element is actually the sold condition code. For IFQ crab it will be the same as the line item condition code. For groundfish it may be different, for example when the fisherman delivers whole sablefish, but is paid on the weight of dressed fish. In general, salmon product items have the same product code as their line item, but it could be different if the processor wishes to price by a particular condition that is different than the delivery condition. For IFQ crab the product code must always be the same as the line item condition code.

      Data Type

      Since Schema Version

      Oracle Database Data Definition

      Values

      integer

      1.0

      NUMBER(3,0)

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

      The product code element has one attribute, the name.

      Data Type

      Since Schema Version

      Oracle Database Data Definition

      Values

      text

      1.0

      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.

    3. Product_type
      The product_type element is required. It indicates where the sold item is a primary product or an ancillary product.

      Data Type

      Since Schema Version

      Oracle Database Data Definition

      Values

      text

      1.0

      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

    4. Size_grade
      The size_grade element will not always be present. This is an optional field that allows processors to list sizing and grading information on the product items. It is freeform text. Processors are free to price product items without providing size/grade information.

      Data Type

      Since Schema Version

      Oracle Database Data Definition

      Values

      text

      1.0

      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.

    5. Tare
      The tare element is not populated on landing reports extracted from eLandings. Tare is the weight of the brailer or tote. This data element is used by the tLandings subsystem, but is not filled in on landing reports.
    6. Weight
      The weight element will always be present. This is the weight of the sold item. The total of the weights of all the product items for a line item will not be more that the weight of the line item, but could be less if the product codes are not the same as the product code on the line item.

      Data Type

      Since Schema Version

      Oracle Database Data Definition

      Values

      decimal

      1.0

      NUMBER(13,4)

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

    7. Price
      The price element is required. The price can have up to 3 decimal places. In some cases the price will be zero.

      Data Type

      Since Schema Version

      Oracle Database Data Definition

      Values

      decimal

      1.0

      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.

  13. Line_Item_stat_area
    The line_item_stat_area element will not be present.
  14. Line Item Comment
    The line item comment present in specific situations. If the condition code for the line item is 97, the comment code for the line item comment will also be 97 and the comment text will contain a description of the condition of the fish. Disposition codes of 62 for overages and 64 for tagged fish also indicate that a comment should be expected. See the elandings online documentation for codes and valid combinations.
    1. Comment_code
      The comment_code element is the code for the comment.

      Data Type

      Since Schema Version

      Oracle Database Data Definition

      Values

      integer

      1.0

      NUMBER(2,0)

      The comment codes are dependent on condition and disposition codes on the line item. The business rules for comments are on the eLandings website

    2. Comment_test
      The text information for the comment, if any was entered.

      Data Type

      Since Schema Version

      Oracle Database Data Definition

      Values

      text

      1.0

      VARCHAR2(500)

      The comment text is required for some comment codes, as detailed in the business rules above.

Ifq_report

The ifq_report element may be present for landing reports for IFQ species. The ifq_report element will be present only if the IFQ report was submitted through the eLandings system. IFQ reports that were made to the NMFS data clerks will not appear in the landing report XML file. The ifq_report element has ten attributes. The attributes will be populated if the IFQ report was submitted. If the report was not submitted, the attributes for this element, and many of the attributes for other elements will not be populated. Submitted reports will have a return_code of "000" or "001"

...