...
The production_report_id is the unique identifier for production reports. The actual number is generated by the eLandings system.
Data Type | Since Schema Version | Oracle Database Data Definition | Values |
---|---|---|---|
integer | 1.0 | NUMBER(10,0) | Production report IDs will be between 1 and 9,999,999,999 |
Type of Production Report
The type of production report distinguishes between At-sea, with a type of "A", and Shoreside, with a type of "S".
Status
...
Data Type | Since Schema Version | Oracle Database Data Definition | Values |
---|---|---|---|
text | 1.0 | CHAR(1) | Valid Types of production reports are: |
Status
The status element contains the submission status of the production report. Reports that are to be imported into eLandings should set the status to zero. Values are:
Status | Meaning | |||
---|---|---|---|---|
0 | Not submitted | |||
8 | Final report submitted | |||
16 | Report voided Data Type | Since Schema Version | Oracle Database Data Definition | Values |
integer | 1.0 | NUMBER(10,0) | Status values are: |
The status element includes a desc attribute, with the text value of the status code.
Transmission
The
Data Type | Since Schema Version | Oracle Database Data Definition | Values |
---|---|---|---|
text | 1.0 | VARCHAR2(25) | The names of status types are as above. |
Transmission
The transmission element is used internally by the eLandings system when reports are transmitted from the seaLandings Processor Workstation software to the server. It is omitted in files exported from eLandings.
...
- Report_date
The report_date element is the date of the production being reported.Data Type
Since Schema Version
Oracle Database Data Definition
Values
date
1.0
DATE
Date of the report, referring to the date when the production took place.
- Federal_processor_number
The federal_processor_number is the federal_processor_permit number for the processor who submitted the report. It is typically omitted from salmon reports. The federal_processor_number element includes three attributes:- name - the name of the processing company, plant, or at-sea processing vessel
- at_sea_proc - a boolean flag indicating the permit is a federal fisheries permit for an at-sea processor. This attribute is omitted from landing reports exported from eLandings.
- license_year - the most recent year for which the processor was licensed. This attribute is omitted from landing reports exported from eLandings.
- No_deliveries
The no_deliveries element is a flag indicating that no deliveries from catcher vessels were received on the date. - No_production
The no_production element is a flag indicating that no processing was done on the date. If the no_production element is set to "true" then the report will not have production_item elements. - Vessel
The vessel element is the vessel ADF&G number, for at-sea operations. It will not be present for shoreside reports.- The vessel element includes a name attribute, which contains the name of the vessel
- Gear
The gear element is the ADF&G gear code, as entered on fish tickets. It will be present on at-sea reports, but will not be on shoreside reports.- then gear element includes a name attribute, which contains the name of the gear type.
- Crew_size
The crew_size element is the number of crew onboard, including the skipper, but excluding any observers. It will only be present for at-sea production reports. - Port_of_landing
The port_of_landing element is the ADF&G port code, as entered on fish tickets. It will be present for at-sea production reports, and it will contain the port code value for the at-sea operation type, such as Catcher/Processor or floating inshore processor.
The port_of_landing element includes two attributes.- the name attribute contains the text name of the port or at-sea operation type
- the ifq_port_code contains the numeric IFQ system port code, as used on IFQ reports. The IFQ port code appears even on reports that do not include IFQ. It is merely an attribute of the alphabetic port code and its presence does not imply IFQ reporting.
- Observers
The observers element is the number of observers in the plant or onboard the vessel. - Proc_code
The proc_code element identifies the entity that purchases or otherwise controls the fish, and is equivalent to the proc code embossed on paper fish tickets. It will only be present for shoreside production reports.- The proc_code element includes a processor attribute, which contains the name of the processor, as listed on their intent to operate application.
- Fed_area
The fed_area element contains the Federal reporting area number where the fish were harvested. It will only be present for at-sea production reports. - Special_area
The special_area element contains the special area code where the fish were harvested, if the harvest was within one of the special areas. It will only be present for at-sea production reports, and will only be present if the harvest took place within a special area.- Management_program
The management_program element identifies the management program under which the fishing took place. It will be present only for at-sea reports.- Program
The program element is the management program abbreviation such as IFQ, CDQ, AFA, or OA. - Program_id
The program_id element is participant identifier. It will be present if the management program has participant IDs. CDQ numbers for CDQ and Co-op numbers for AFA, are examples of program ids. If the management program has no participant numbers, such as ADAK, then this element will be omitted.
- Program
- Management_program
- Trip_event_code
The trip_event_code element indicates events that can occur on at-sea processor trips, which affect maximum retainable amounts. It will be present only for at-sea reports, and only if one of the events occurred on the date of the report.The federal_processor_number element includes three attributes:Data Type
Since Schema Version
Oracle Database Data Definition
Values
integer
1.0
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.
- name - the name of the processing company, plant, or at-sea processing vessel
Data Type
Since Schema Version
Oracle Database Data Definition
Values
text
1.0
VARCHAR2(50)
Federal Processor Number Name is the name of the processor.
- at_sea_proc - a boolean flag indicating the permit is a federal fisheries permit for an at-sea processor. This attribute is omitted from production reports exported from eLandings.
- license_year - the most recent year for which the processor was licensed. This attribute is omitted from production reports exported from eLandings.
- name - the name of the processing company, plant, or at-sea processing vessel
- No_deliveries
The no_deliveries element is a flag indicating that no deliveries from catcher vessels were received on the date.Data Type
Since Schema Version
Oracle Database Data Definition
Values
boolean
1.0
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
The no_production element is a flag indicating that no processing was done on the date. If the no_production element is set to "true" then the report will not have production_item elements.Data Type
Since Schema Version
Oracle Database Data Definition
Values
boolean
1.0
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
The vessel element is the vessel ADF&G number, for at-sea operations. It will not be present for shoreside reports.Data Type
Since Schema Version
Oracle Database Data Definition
Values
integer
1.0
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.
- The vessel element includes a name attribute, which contains the name of the vessel
Data Type
Since Schema Version
Oracle Database Data Definition
Values
text
1.0
VARCHAR2(50)
Vessel names can be looked up on the CFEC website, as above.
- The vessel element includes a name attribute, which contains the name of the vessel
- Gear
The gear element is the ADF&G gear code, as entered on fish tickets. It will be present on at-sea reports, but will not be on shoreside reports.Data Type
Since Schema Version
Oracle Database Data Definition
Values
1.0
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.
- The gear element includes a name attribute, which contains the name of the gear type.
Data Type
Since Schema Version
Oracle Database Data Definition
Values
text
1.0
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.
- The gear element includes a name attribute, which contains the name of the gear type.
- Crew_size
The crew_size element is the number of crew onboard, including the skipper, but excluding any observers. It will only be present for at-sea production reports.Data Type
Since Schema Version
Oracle Database Data Definition
Values
integer
1.0
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
The port_of_landing element is the ADF&G port code, as entered on fish tickets. It will be present for at-sea production reports, and it will contain the port code value for the at-sea operation type, such as Catcher/Processor or floating inshore processor.The port_of_landing element includes two attributes.Data Type
Since Schema Version
Oracle Database Data Definition
Values
text
1.0
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
- the name attribute contains the text name of the port or at-sea operation type
Data Type
Since Schema Version
Oracle Database Data Definition
Values
text
1.0
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.
- the ifq_port_code contains the numeric IFQ system port code, as used on IFQ reports. The IFQ port code appears even on reports that do not include IFQ. It is merely an attribute of the alphabetic port code and its presence does not imply IFQ reporting.
- the name attribute contains the text name of the port or at-sea operation type
- Observers
The observers element is the number of observers in the plant or onboard the vessel.Data Type
Since Schema Version
Oracle Database Data Definition
Values
integer
1.0
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
- Proc_code
The proc_code element identifies the entity that purchases or otherwise controls the fish, and is equivalent to the proc code emprinted on paper fish tickets. It will only be present for shoreside production reports.Data Type
Since Schema Version
Oracle Database Data Definition
Values
text
1.0
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.
- The proc_code element includes a processor attribute, which contains the name of the processor, as listed on their intent to operate application.
Data Type
Since Schema Version
Oracle Database Data Definition
Values
text
1.0
VARCHAR2(50)
Proc code processor is the name of the processor.
- The proc_code element includes a processor attribute, which contains the name of the processor, as listed on their intent to operate application.
- Fed_area
The fed_area element contains the Federal reporting area number where the fish were harvested. It will only be present for at-sea production reports.Data Type
Since Schema Version
Oracle Database Data Definition
Values
integer
1.0
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
The special_area element contains the special area code where the fish were harvested, if the harvest was within one of the special areas. It will only be present for at-sea production reports, and will only be present if the harvest took place within a special area.Data Type
Since Schema Version
Oracle Database Data Definition
Values
text
1.0
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 - Management_program
The management_program element identifies the management program under which the fishing took place. It will be present only for at-sea reports.- Program
The program element is the management program abbreviation such as IFQ, CDQ, AFA, or OA.Data Type
Since Schema Version
Oracle Database Data Definition
Values
text
1.0
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
- Program_id
The program_id element is participant identifier. It will be present if the management program has participant IDs. CDQ numbers for CDQ and Co-op numbers for AFA, are examples of program ids. If the management program has no participant numbers, such as ADAK, then this element will be omitted.Data Type
Since Schema Version
Oracle Database Data Definition
Values
integer
1.0
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
- Program
- Trip_event_code
The trip_event_code element indicates events that can occur on at-sea processor trips, which affect maximum retainable amounts. It will be present only for at-sea reports, and only if one of the events occurred on the date of the report.Data Type
Since Schema Version
Oracle Database Data Definition
Values
integer
1.3
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
Stat_area_worksheet
The stat_area_worksheet element will be present for at-sea reports, but not for shoreside reports.
More that one stat_area_worksheet elements may be specified.
...