...
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: |
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: |
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: |
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: |
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: |
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: |
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: |
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 |
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. |