7284 AFSC/FMA/ATL-NORPAC Data Set Published / External 7290 North Pacific (NORPAC) Groundfish and Halibut Observer Data Dictionary December 2007 - Present Project In Work Data collected by the ATLAS Client and transmitted electronically or by fax to the AFSC are loaded into production transaction tables which are the source data for those interfaces used for fishery management, scientific inquiry and fishing activity monitoring by industry. The prime purpose of the Information and Monitoring Technologies Program is to facilitate the flow of quality data which meets the needs of agency clients and allows the conduct of research and industry outreach, addressing data quality issues while maintaining data confidentiality. Support of information needs for in-season management Support of information needs for stock assessment Support of information needs for bycatch monitoring and reduction, and monitoring fishery interactions with seabirds and marine mammals Provision of information on compliance monitoring to NMFS Enforcement Provision of information to industry and other interested parties consistent with confidentiality policies Provision of assistance to AFSC and Alaska Region staff in the specification of data requirements which are consistent with user requirements and program capabilities Evaluation of innovative technologies Development and maintenance of information systems necessary to support program functions. N/A N/A Theme AFSC Theme FMA Theme NORPAC Theme OBSERVER Spatial AI Spatial ALASKA Spatial BS Spatial BSAI Spatial GOA Spatial NORTH PACIFIC Fisheries Monitoring and Analysis Seattle WA USA Alaska Fisheries Science Center, FMA Division Data Set Database As Needed Table (hardcopy) Logical Model Julie Blair https://www.afsc.noaa.gov/FMA/PDF_DOCS/ATL-NORPAC_SYSTEM_DIAGRAM_2016_07_15.pdf These are confidential data and may not be distributed except under specific conditions. FMA Division N/A N/A N/A 7357 ATLW_RECORD_SET_STATUS Published / External Completed This entity represents the header information for the list of records which will or has been trasmitted to AFSC. It identifies the cruise which owns the records to be transmitted, the status of the transmission, and the version of atlas which created the transmission. Loaded by batch 2164, 03-27-2008 10:42 Data Table Yes NORPAC This entity represents the header information for the list of records which will or has been trasmitted to AFSC. It identifies the cruise which owns the records to be transmitted, the status of the transmission, and the version of atlas which created the transmission. 1 RECORD_SET_STATUS_SEQ NUMBER 22 Yes No 9 0 Active Sequence generated unique identifier of a record set header NUMBER 2 TRANSMIT_CODE VARCHAR2 1 Yes No Active This code identifies the transmission state of this record. Valid Values N = New, P = Prepared, T = Transmitted, R = Resent) VARCHAR2 3 ATLAS_VERSION NUMBER 22 No No 3 2 Active Version of atlas. This is initialized at each new installation. NUMBER 4 PREPARED_DATE_TIME DATE 7 No No Active Timestamp posted by the iinitiating program. When a record set is prepared for transmission this attribute contains the system time. This need not necessiarily be accurate, but must be sequentially consistent. DATE 5 TEST_DATA_FLAG VARCHAR2 1 No No Active Identifies a record set as test or production data. Defaults to (N)o - Data is Production VARCHAR2 7358 ATLW_RECORD_STATUS Published / External Completed This entity represents the list of records which will or has been trasmitted to AFSC. It identifies the table, unique identifier, action status (CRUD), and transmission status of each record. Loaded by batch 2164, 03-27-2008 10:42 Data Table Yes NORPAC This entity represents the list of records which will or has been trasmitted to AFSC. It identifies the table, unique identifier, action status (CRUD), and transmission status of each record. 1 RECORD_STATUS_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence Generated Unique Identifier for records that are currently queued for loading. NUMBER 2 RECORD_SET_STATUS_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a record set header NUMBER 3 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. Here it identifies which cruise this element in the recordset belongs to. NUMBER 4 TABLE_NAME VARCHAR2 30 Yes No Active Table name from which a record is inserted, updated or deleted. VARCHAR2 5 PK1_COLUMN_NAME VARCHAR2 30 Yes No Active Primary key column name for the referenced table. VARCHAR2 6 PK1_VALUE VARCHAR2 9 Yes No Active Primary key column value for the referenced table. VARCHAR2 7 PK2_COLUMN_NAME VARCHAR2 30 No No Active Compound primary key column name for the referenced table. VARCHAR2 8 PK2_VALUE VARCHAR2 9 No No Active Compound primary key column value for the referenced table. VARCHAR2 9 STATUS_CODE VARCHAR2 1 Yes No Active This attribute identifies the action taken on this record. Valid Values I = Insert, U = Update, D = delete VARCHAR2 10 TRANSMISSION_RECEIVED_DATE DATE 7 No No Active Timestamp for the date that the record status was loaded into the working tables. DATE 7359 ATLW_SALMON Published / External Completed This entity records the number of prohibited pacific salmon recorded as bycatch by species for an offload or a haul. Loaded by batch 2164, 03-27-2008 10:42 Data Table Yes NORPAC Retrofitted from table SALMON_TABLE 1 RECORD_SET_STATUS_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a record set header NUMBER 2 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 3 SALMON_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a salmon record NUMBER 4 OFFLOAD_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier for an offload record NUMBER 5 HAUL_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier for a haul record NUMBER 6 RELIABILITY_CODE NUMBER 22 No No 9 0 Active Unique Numeric Value NUMBER 7 SCALE VARCHAR2 1 No No Active Whether the temperature was recorded in degrees farenheit or celsius. VARCHAR2 8 SURFACE_TEMP NUMBER 22 No No 6 1 Active Surface temperature of the water. Applicable only to hauls. NUMBER 9 FISHING_TEMP NUMBER 22 No No 6 1 Active Temperature recorded at fishing depth NUMBER 10 NUMBER_CHINOOK NUMBER 22 No No 38 Active Number of Chinook recorded. NUMBER 11 NUMBER_OTHER NUMBER 22 No No 38 Active Number of Other salmon species recorded NUMBER 12 NUMBER_UNIDENTIFIED NUMBER 22 No No 38 Active Number of Salmon which could not be identified by species. NUMBER 7360 ATLW_SAMPLE Published / External Completed This entity represents the individual samples of a type that may be collected from an observed haul. It does not currently map to any Norpac table, but is header information for species composition.If there are rare species present in sample and there exist multiple predominant species, a recursive subsample or subsamples may be created. The sum of the weights of the subsamples must be less than or equal to the parent sample. Loaded by batch 2164, 03-27-2008 10:42 Data Table Yes NORPAC This entity represents the individual samples of a type that may be collected from an observed haul. It does not currently map to any Norpac table, but is header information for species composition.If there are rare species present in sample and there exist multiple predominant species, a recursive subsample or subsamples may be created. The sum of the weights of the subsamples must be less than or equal to the parent sample. 1 RECORD_SET_STATUS_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a record set header NUMBER 2 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 3 SAMPLE_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a sample NUMBER 4 PARENT_SAMPLE_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier of a sample NUMBER 5 SAMPLE_NUMBER NUMBER 22 Yes No 9 0 Active Sequence within either haul or offload parent. This value is auto-generated but not necessarily unique. NUMBER 6 OFFLOAD_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier for an offload record NUMBER 7 HAUL_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier for a haul record NUMBER 8 COMBINED_SAMPLE_FLAG VARCHAR2 1 Yes No Active Identifies whether unique samples within a haul have been aggregated together. VARCHAR2 9 PRESORTED_FLAG VARCHAR2 1 No No Active The organism did not make into population and was not available for observer species composition sample. VARCHAR2 10 TOTAL_SAMPLE_WEIGHT NUMBER 22 No No 10 2 Active Total weight in kg of this sample. NUMBER 11 SAMPLE_HOOKS_POTS NUMBER 22 No No 6 0 Active Number of hooks or pots sampled. NUMBER 7361 ATLW_SPECIES_COMPOSITION Published / External Completed This entity maps to the old Norpac Species_Comp_Detail Table. It contains records of each species which is identified within an observer sampling frame. The count of animals must be positive, zero count records are not permitted. Species composition records always come from a sample. Loaded by batch 2164, 03-27-2008 10:42 Data Table Yes NORPAC This entity maps to the Norpac Species_Comp_Detail Table. 1 RECORD_SET_STATUS_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a record set header NUMBER 2 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 3 SPECIES_COMPOSITION_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence Generated unique identifier of a species composition record NUMBER 4 SAMPLE_SEQ NUMBER 22 Yes No 9 0 Active Sequence generated unique identifier of a sample NUMBER 5 SPECIES_CODE NUMBER 22 Yes No 4 0 Active Unique identifier for a species imported from Norpac NUMBER 6 SPECIES_WEIGHT NUMBER 22 No No 11 2 Active Weight of each species in the sample. Either the species number or the species weight may be null, but not both. NUMBER 7 SPECIES_NUMBER NUMBER 22 No No 6 0 Active Number of individual animals in the sample. Either the species number or the species weight may be null, but not both. NUMBER 8 SEX_CODE VARCHAR2 1 No No Active Sex if so identified. VARCHAR2 7366 ATL_CRUISE_VESSEL_H Published / External Completed The intersection of an observer cruise and a vessel Loaded by batch 2164, 03-27-2008 10:42 Data Table Yes NORPAC 1 SEQ_NUMBER NUMBER 22 Yes Yes 10 0 Active NUMBER 2 CHANGED_BY VARCHAR2 30 No No Active VARCHAR2 3 DATE_CHANGED DATE 7 No No Active DATE 4 CRUISE_VESSEL_SEQ NUMBER 22 No No 22 0 Active NUMBER 5 CRUISE NUMBER 22 No No 22 0 Active NUMBER 6 VESSEL_SEQ NUMBER 22 No No 22 0 Active NUMBER 7 STATUS NUMBER 22 No No 22 0 Active NUMBER 8 STATUS_DATE DATE 7 No No Active DATE 9 STATUS_USER VARCHAR2 30 No No Active VARCHAR2 10 COMMENTS VARCHAR2 2000 No No Active VARCHAR2 7369 ATL_ERROR_H Published / External Completed This entity represents the list of data and loading errors for the Atlas, Inseason, and Domestic Data sets. Errors are logged by a call to a custom utility which compiles and writes to the Error Log table. Oracle RAISE_APPLICATION_ERROR must not be used because it is not desirable to stop processing when creating a log. Histories of all changes to data are maintained by trigger code on the parent table; allowing change control by user and datetime for all updates and delete events. Loaded by batch 2164, 03-27-2008 10:42 Data Table Yes NORPAC 1 SEQ_NUMBER NUMBER 22 Yes Yes 10 0 Active Sequence generated unique identifier for a history table. Every history table has a unique sequence assigned to it all start with 1, icrement by 1 and do not cycle. NUMBER 2 CHANGED_BY VARCHAR2 30 No No Active Oracle user who made a change to the transaction table record. VARCHAR2 3 DATE_CHANGED DATE 7 No No Active Timestamp of change to transaction record. DATE 4 ERROR_FORM_TYPE VARCHAR2 50 No No Active Error script run for every specific form type. This column groups errors according to the respective subsystem tested. For example: Trip errors relate to the Atlas Trip and related table data. VARCHAR2 5 ERROR_NAME VARCHAR2 50 No No Active Unique name of error VARCHAR2 6 ERROR_NUMBER NUMBER 22 No No 22 0 Active Unique user defined error number between -20000 and -21000 NUMBER 7 ERROR_TEXT VARCHAR2 150 No No Active Text to be returned with error VARCHAR2 8 ERROR_DISCUSSION VARCHAR2 1000 No No Active Optional discussion of history, and remedies relating to this error. Including usage by table and program. It is anticipated that complilation of this metadata will generate an error handbook which will be available to inseason staff VARCHAR2 9 ERROR_LEVEL NUMBER 22 No No 22 0 Active Level of severity NUMBER 10 OLD_ERROR_NUMBER NUMBER 22 No No 22 0 Active NUMBER 7379 ATL_FMA_TRIP Published / External Completed A FMA trip is defined as the time between when a vessel casts off lines and ties up. There may be times where a vessel trip doesn't consist of any fishing. Even though no fishing took place a trip record still musy be created when a transit, offload or observer transfer takes place. Loaded by batch 2164, 03-27-2008 10:42 Data Table Yes NORPAC A FMA trip is defined as the time between when a vessel casts off lines and ties up. There may be times where a vessel trip doesn't consist of any fishing. Even though no fishing took place a trip record still musy be created when a transit, offload or observer transfer takes place. 1 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER NORPAC.ATL_CRUISE_VESSEL 2 TRIP_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a trip within each observer instance of Atlas NUMBER 3 CRUISE_VESSEL_SEQ NUMBER 22 Yes No 9 0 Active Sequence generated unique identifier for a cruise vessel. NUMBER NORPAC.ATL_CRUISE_VESSEL 4 TRIP_NUMBER NUMBER 22 Yes No 4 0 Active Number which is entered by the observer which must be unique within a cruise - vessel combination. NUMBER 5 EMBARKED_PORT_CODE NUMBER 22 No No 38 Active User defined unique identifier of a port currently limited to 1 - 12 NUMBER NORPAC.ATL_LOV_PORT_CODE 6 DISEMBARKED_PORT_CODE NUMBER 22 No No 38 Active User defined unique identifier of a port currently limited to 1 - 12 NUMBER NORPAC.ATL_LOV_PORT_CODE 7 BAIT_USED_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier of a bait used record NUMBER NORPAC.ATL_LOV_BAIT_USED 8 START_DATE DATE 7 No No Active Date of embarkation. DATE 9 START_LATITUDE_DEGREE NUMBER 22 No No 2 0 Active Latitude of embarkation in degrees. NUMBER 10 START_LATITUDE_MIN NUMBER 22 No No 2 0 Active Latitude of embarkation in minutes. NUMBER 11 START_LATITUDE_SEC NUMBER 22 No No 2 0 Active Latitude of embarkation in seconds. NUMBER 12 START_LONGITUDE_DEGREE NUMBER 22 No No 3 0 Active Longitude of embarkation in degrees. NUMBER 13 START_LONGITUDE_MIN NUMBER 22 No No 2 0 Active Longitude of embarkation in minutes. NUMBER 14 START_LONGITUDE_SEC NUMBER 22 No No 2 0 Active Longitude of embarkation in seconds. NUMBER 15 START_EW VARCHAR2 1 No No Active East West longitude identifier for Embarkation. VARCHAR2 16 END_DATE DATE 7 No No Active Date of landing, tying up to a mothership, transfer of fish between codends or other interaction signifying the ending of a trip. DATE 17 END_LATITUDE_DEGREE NUMBER 22 No No 2 0 Active Latitude of disembarkation in degrees. NUMBER 18 END_LATITUDE_MIN NUMBER 22 No No 2 0 Active Latitude of disembarkation in minutes NUMBER 19 END_LATITUDE_SEC NUMBER 22 No No 2 0 Active Latitude of disembarkation in seconds NUMBER 20 END_LONGITUDE_DEGREE NUMBER 22 No No 3 0 Active Longitude of disembarkation in degrees. NUMBER 21 END_LONGITUDE_MIN NUMBER 22 No No 2 0 Active Longitude of disembarkation in minutes NUMBER 22 END_LONGITUDE_SEC NUMBER 22 No No 2 0 Active Longitude of disembarkation in seconds NUMBER 23 END_EW VARCHAR2 1 No No Active East West longitude identifier for Disembarkation. VARCHAR2 24 CREW_SIZE NUMBER 22 No No 38 Active Number of personnel on the vessel. NUMBER 25 DID_FISHING_OCCUR_FLAG VARCHAR2 1 Yes No Active Idetifies whether fishing took place or not. VARCHAR2 26 FISH_IN_HOLD_AT_START_FLAG VARCHAR2 1 Yes No Active Identifies whether there were fish present in the hold at the start of a fishing trip. VARCHAR2 27 ATLAS_VERSION_NUMBER NUMBER 22 Yes No 3 1 Active Current Version of Atlas Program. This is stored in both Trip and Offload and inherited by the rest of the system. NUMBER 28 COMMENTS VARCHAR2 2000 No No Active Any specific comments an observer might make in regards to this trip. In particular comments are required to documented lost fishing time. VARCHAR2 7383 ATL_LENGTH Published / External Completed This entity is mapped to the Norpac length tables. It contains header information about sampled animals. Loaded by batch 2164, 03-27-2008 10:42 Data Table Yes NORPAC This entity is mapped to the Norpac length tables. It contains header information about sampled animals. 1 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER Refers to more than one entity 2 LENGTH_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier for a length record NUMBER 3 SPECIES_COMPOSITION_SEQ NUMBER 22 No No 9 0 Active Sequence Generated unique identifier of a species composition record NUMBER NORPAC.ATL_SPECIES_COMPOSITION 4 HAUL_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier for a haul record NUMBER NORPAC.ATL_HAUL 5 OFFLOAD_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier for an offload record NUMBER NORPAC.ATL_OFFLOAD 6 CONDITION_CODE NUMBER 22 No No 38 Active Numeric code identifying the injury NUMBER NORPAC.ATL_LOV_CONDITION 7 SAMPLE_SYSTEM_CODE NUMBER 22 Yes No 38 Active Unique numeric identifier of a sample coding system. NUMBER NORPAC.ATL_LOV_SAMPLE_SYSTEM_C 8 ANIMAL_TYPE_CODE VARCHAR2 2 No No Active Refers the the class of animal for example M - mammal H-halibut. Enforced by the Domain Animal Type. VARCHAR2 NORPAC.ATL_LOV_CONDITION 9 SPECIES_CODE NUMBER 22 No No 4 0 Active In the case of a length record which is not a child of species composition. This is the species identifier attribute. NUMBER NORPAC.ATL_LOV_SPECIES_CODE 10 SEX_CODE VARCHAR2 1 No No Active The sex of this animal VARCHAR2 11 LENGTH_SIZE NUMBER 22 No No 8 0 Active The length of this animal NUMBER 12 FREQUENCY NUMBER 22 No No 38 Active The total number of animals within this size group NUMBER 13 EGGS_IND VARCHAR2 1 No No Active Identifies the presence or absence of egg for crabs. VARCHAR2 14 VIABILITY VARCHAR2 1 No No Active Identifies the viability status for halibut valid values are Excellent, Poor, Dead, Unknown. VARCHAR2 7390 ATL_LOV_DETERRENCE Published / External Completed This entity maps to both the Norpac Domestic Bird_Deterrence and the Domestic Mammal_Deterrence tables. It is a list of ezuipment and actions used to deter gear interactions with birds or mammals. In Atlas the animal_type column was added to allow this. Loaded by batch 2164, 03-27-2008 10:42 Data Table Yes NORPAC This entity maps to both the Norpac Bird_Deterrence and the Mammal_Deterrence tables. In Atlas the animal_type column was added to allow this. 1 DETERRENCE_CODE VARCHAR2 2 Yes Yes Active Deterrence code from NORPAC bird or mammal deterance tables VARCHAR2 2 ANIMAL_TYPE_CODE VARCHAR2 2 Yes Yes Active Class of animal mammal (M), bird (B) for which the deterrence was utilized. References ATL_LOV_Animal_TYPEClass of animal mammal (M), bird (B) for which the deterrence was utilized VARCHAR2 NORPAC.ATL_LOV_ANIMAL_TYPE 3 DESCRIPTION VARCHAR2 100 Yes No Active Descriptive text of deterrence method used. VARCHAR2 7433 ATL_SPECIES_COMPOSITION Published / External Completed This entity maps to the old Norpac Species_Comp_Detail Table. It contains records of each species which is identified within an observer sampling frame. The count of animals must be positive, zero count records are not permitted. Species composition records always come from a sample.This entity maps to the Norpac Species_Comp_Detail Table. Loaded by batch 2164, 03-27-2008 10:42 Data Table Yes NORPAC This entity maps to the Norpac Species_Comp_Detail Table. 1 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER NORPAC.ATL_SAMPLE 2 SPECIES_COMPOSITION_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence Generated unique identifier of a species composition record NUMBER 3 SAMPLE_SEQ NUMBER 22 Yes No 9 0 Active Sequence generated unique identifier of a sample NUMBER NORPAC.ATL_SAMPLE 4 SPECIES_CODE NUMBER 22 Yes No 4 0 Active Unique identifier for a species imported from Norpac NUMBER NORPAC.ATL_LOV_SPECIES_CODE 5 SPECIES_WEIGHT NUMBER 22 No No 11 2 Active Weight of each species in the sample in kg. Either the species number or the species weight may be null, but not both. NUMBER 6 SPECIES_NUMBER NUMBER 22 No No 6 0 Active Number of individual animals in the sample. Either the species number or the species weight may be null, but not both. NUMBER 7 SEX_CODE VARCHAR2 1 No No Active Sex if so identified. VARCHAR2 7434 ATL_SPECIES_COMPOSITION_H Published / External Completed This entity maps to the old Norpac Species_Comp_Detail Table. It contains records of each species which is identified within an observer sampling frame. The count of animals must be positive, zero count records are not permitted. Species composition records always come from a sample. Loaded by batch 2164, 03-27-2008 10:42 Data Table Yes NORPAC This entity maps to the old Norpac Species_Comp_Detail Table. It contains records of each species which is identified within an observer sampling frame. The count of animals must be positive, zero count records are not permitted. Species composition records always come from a sample. PERMIT VARCHAR2 No No Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau 1 SEQ_NUMBER NUMBER 22 Yes Yes 10 0 Active Sequence generated unique identifier for a history table. Every history table has a unique sequence assigned to it all start with 1, increment by 1 and do not cycle. NUMBER 2 CHANGED_BY VARCHAR2 30 No No Active Oracle user who made a change to the transaction table record. VARCHAR2 3 DATE_CHANGED DATE 7 No No Active Timestamp of change to transaction record. DATE 4 CRUISE NUMBER 22 No No 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 5 SPECIES_COMPOSITION_SEQ NUMBER 22 No No 22 0 Active Sequence Generated unique identifier of a species composition record NUMBER 6 SAMPLE_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier of a sample NUMBER 7 SPECIES_CODE NUMBER 22 No No 22 0 Active Unique identifier for a species imported from Norpac NUMBER 8 SPECIES_WEIGHT NUMBER 22 No No 11 2 Active Weight of each species in the sample in kg. Either the species number or the species weight may be null, but not both. NUMBER 9 SPECIES_NUMBER NUMBER 22 No No 7 0 Active Number of individual animals in the sample. Either the species number or the species weight may be null, but not both. NUMBER 10 SEX_CODE VARCHAR2 1 No No Active Sex if so identified. VARCHAR2 7485 Package: ATL_ERRORS Published / External In Work This Package contains the code that reads and logs data errors within the initial load and processing of data in the NORPAC data set. Data streams come from electronic submissions via ATLAS, data input of faxed observer reports, and from the editing and debriefing process. Since the deployed version of ATLAS is refreshed only annually, error checking on the client will require augmentation by rigorous validation. Data keypunched from faxed forms is not validated at the source and must be reviewed prior to loading into the production table set. Finally edits may affect or invalidate related information in child or parent tables which are not verified by trigger logic. Consequently the entire set of scipts must be executed, and any errors iteratively logged. The package body is organized by transaction table and private procedures call each in the logical validation order. Other No NORPAC This package contains the code that reads and logs data errors within the initial load and processing of data in the NORPAC data set. Data streams come from electronic submissions via ATLAS, data input of faxed observer reports, and from the editing and debriefing process. Since the deployed version of ATLAS is refreshed only annually, error checking on the client will require augmentation by rigorous validation. Data keypunched from faxed forms is not validated at the source and must be reviewed prior to loading into the production table set. Finally, edits may affect or invalidate related information in child or parent tables which are not verified by trigger logic. Consequently, the entire set of scripts must be executed, and any errors iteratively logged. The package body is organized by transaction table and private procedures call each in the logical validation order. 7486 Package: ATL_LOAD_NORPAC Published / External In Work This Package Contains the ATL_ table load and Current View Presentation Processes from the Atlas 2008 Application to the legacy Norpac data set. Note that some of the detail from Observer Data collected and transmitted from deployed versions of ATLAS is lost in the current view presentation layer. Other Yes NOPRPAC This package used to load data into NORPAC 9604 ATLW_BIRD_AGE Published / External Completed This entity resolves the intersection of a bird interaction species and the age categories. An interaction may include multiple age classes of that species. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity resolves the intersection of a bird interaction species and the age categories. An interaction may include multiple age classes of that species. 1 RECORD_SET_STATUS_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a record set header NUMBER 2 BIRD_AGE_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence Generated Unique identifier for a bird age record NUMBER 3 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 4 PERMIT VARCHAR2 6 Yes Yes Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 5 AGE_CATEGORY_CODE VARCHAR2 10 Yes No Active Unique code for classifying bird age VARCHAR2 6 SPECIMEN_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier of a bird specimen. NUMBER 7 INTERACTION_SPECIES_SEQ NUMBER 22 No No 8 0 Active Sequence generated unique identifier for an species interaction record NUMBER 8 NUMBER_OF_ANIMALS NUMBER 22 Yes No 3 0 Active Number of birds of this species of this age category NUMBER 9605 ATLW_BIRD_EVENT Published / External Completed This entity records bird interactions characterized by type, that may occur at either the haul, offload or at the trip level. Each interaction is recorded separately and may be for multiple animals. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity records bird interactions characterized by type, that may occur at either the haul, offload or at the trip level. Each interaction is recorded separately and may be for multiple animals. 1 RECORD_SET_STATUS_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a record set header NUMBER 2 BIRD_EVENT_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a bird interaction event. NUMBER 3 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 4 PERMIT VARCHAR2 6 Yes Yes Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 5 EVENT_NUMBER NUMBER 22 Yes No 4 0 Active User defined event reference number which is unique within a cruise. NUMBER 6 TRIP_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier of a trip NUMBER 7 OFFLOAD_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier for an offload record NUMBER 8 HAUL_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier for a haul record NUMBER 9 DETERRENT_USED_CODE VARCHAR2 10 Yes No Active Unique code dientifying the reason for the use or absence of a bird deterrence strategy. VARCHAR2 10 COUNT_TYPE_CODE VARCHAR2 10 Yes No Active Unique code describing how the number of animals field is determined. Except for a type of specific the grouping is an estimate and number is not required. VARCHAR2 11 LOCATION_CODE VARCHAR2 10 Yes No Active Unique code identifying the location of the bird at the first observation VARCHAR2 12 WEATHER_CODE VARCHAR2 10 Yes No Active Unique weather code VARCHAR2 13 FISHERY_CODE VARCHAR2 5 Yes No Active Unique Abbreviated code for a fishery as defined by the observer. VARCHAR2 14 NUMBER_OF_ANIMALS NUMBER 22 Yes No 4 0 Active Number of animals involved with this interaction NUMBER 15 LATITUDE_DEGREE NUMBER 22 No No 2 0 Active Latitude at which the interaction with a bird occured. NUMBER 16 LATITUDE_MINUTES NUMBER 22 No No 2 0 Active Latitude at which the interaction with a bird occured. NUMBER 17 LATITUDE_SECONDS NUMBER 22 No No 2 0 Active Latitude at which the interaction with a bird occured. NUMBER 18 LONGITUDE_DEGREE NUMBER 22 No No 3 0 Active Longitude at which the interaction with a bird occured. NUMBER 19 LONGITUDE_MINUTES NUMBER 22 No No 2 0 Active Longitude at which the interaction with a bird occured. NUMBER 20 LONGITUDE_SECONDS NUMBER 22 No No 2 0 Active Longitude at which the interaction with a bird occured. NUMBER 21 LONGITUDE_EW VARCHAR2 1 No No Active Identifies the logitude as E(ast) or W(est) VARCHAR2 22 INTERACTION_DATE_TIME DATE 7 No No Active Date the interaction was observed. If an interaction record is related to an offload or a haul this date is inferred as the haul date or offload end date. If the interaction is related to a trip the interaction date is mandatory. DATE 23 COMMENTS VARCHAR2 500 No No Active Observer entered comments regarding this interaction. VARCHAR2 24 BEAUFORT_CODE VARCHAR2 10 No No Active International Beaufort Sea State Code VARCHAR2 9606 ATLW_BIRD_EVENT_OUTCOME Published / External Completed This entity represents the outcome of a bird interaction or a bird event, species interaction or of an indivdual animal (specimen Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity represents the outcome of a bird interaction or a bird event, species interaction or of an indivdual animal (specimen 1 RECORD_SET_STATUS_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a record set header NUMBER 2 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 3 EVENT_OUTCOME_SEQ NUMBER 22 Yes Yes 9 0 Active interaction behavior seq. NUMBER 4 OUTCOME_CODE VARCHAR2 10 Yes No Active Unique code identifying the condition of the bird after this interaction VARCHAR2 5 PERMIT VARCHAR2 6 Yes Yes Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 6 BIRD_EVENT_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier of a bird interaction event. NUMBER 7 INTERACTION_SPECIES_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier for an species interaction record NUMBER 8 SPECIMEN_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier of a bird specimen. NUMBER 9607 ATLW_BIRD_INTERACTION Published / External Completed This entity represents the intersection of an interaction type, its outcome to either the general interaction or to the individual animal. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity represents the intersection of an interaction type, its outcome to either the general interaction or to the individual animal. 1 RECORD_SET_STATUS_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a record set header NUMBER 2 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 3 PERMIT VARCHAR2 6 Yes Yes Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 4 EVENT_INTERACTION_SEQ NUMBER 22 Yes No 9 0 Active Sequence generated unique identifier of a bird event interaction. NUMBER 5 INTERACTION_SPECIES_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier for an species interaction record NUMBER 6 BIRD_EVENT_SEQ NUMBER 22 No No 9 0 Active Sequence generated nique identifier of a bird interaction event. NUMBER 7 SPECIMEN_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier of a bird specimen. NUMBER 8 BIRD_INTERACT_CODE VARCHAR2 6 Yes No Active Unique code identifying a list of the currently valid avian interactions identified with gear, vessels, and offloads. VARCHAR2 9 COMMENTS VARCHAR2 500 No No Active Discussion of the interaction type and it's outcome at the event or specimen level. VARCHAR2 9608 ATLW_BIRD_INTERAC_DETERRENT Published / External Completed This entity resolves the intersection of a bird deterrent code and a bird interaction. Multiple deterrents are allowed none are mandatory. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity resolves the intersection of a bird deterrent code and a bird interaction. Multiple deterrents are allowed none are mandatory. 1 RECORD_SET_STATUS_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a record set header NUMBER 2 ANIMAL_TYPE_CODE VARCHAR2 2 Yes No Active Class of animal mammal (M), bird (B) for which the deterrence was utilized. References ATL_LOV_Animal_TYPEClass of animal mammal (M), bird (B) for which the deterrence was utilized VARCHAR2 3 DETERRENCE_CODE VARCHAR2 2 Yes No Active Deterrence code from NORPAC bird or mammal deterance tables VARCHAR2 4 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 5 PERMIT VARCHAR2 6 Yes Yes Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 6 BIRD_EVENT_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated nique identifier of a bird interaction NUMBER 7 COMMENTS VARCHAR2 500 Yes No Active Problems with deployment of deterrent device or details of type of deterrent. VARCHAR2 9609 ATLW_BIRD_INTERAC_SPECIES Published / External Completed This entity represents the intersections of a bird interaction with one or more species which may be identified through mutually exclusive foreign keys with lov_species or species_composition. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity represents the intersections of a bird interaction with one or more species which may be identified through mutually exclusive foreign keys with lov_species or species_composition. 1 RECORD_SET_STATUS_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a record set header NUMBER 2 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 3 PERMIT VARCHAR2 6 Yes Yes Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 4 INTERACTION_SPECIES_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier for an species interaction record NUMBER 5 BIRD_EVENT_SEQ NUMBER 22 Yes No 9 0 Active Sequence generated unique identifier of a bird interaction event. NUMBER 6 COUNT_TYPE_CODE VARCHAR2 10 Yes No Active Unique code describing how the number of animals field is determined. Except for a type of specific the grouping is an estimate and number is not required. VARCHAR2 7 SPECIES_COMPOSITION_SEQ NUMBER 22 No No 9 0 Active Sequence Generated unique identifier of a species composition record NUMBER 8 SPECIES_CODE NUMBER 22 No No 4 0 Active Unique identifier for a species imported from Norpac NUMBER 9 NUMBER_OF_ANIMALS NUMBER 22 Yes No 3 0 Active Numbers of animals of this species NUMBER 10 GOOD_LOOK_CODE VARCHAR2 3 Yes No Active Code (Domain) which describes how the level of the observation of this bird. VARCHAR2 11 SPECIES_CONFIDENCE_CODE VARCHAR2 5 Yes No Active Code (Domain) identifying level of observer confidence in his-her species identification. VARCHAR2 12 SPECIES_VERIFICATION_FLAG VARCHAR2 1 Yes No Active Flag identifying whether or not the species identification is corroberated by external evidence, which would then be discussed in the comments section. VARCHAR2 13 COMMENTS VARCHAR2 500 No No Active Colors on head, eye erea, bill, legs, back, wings, bill size etc. VARCHAR2 9610 ATLW_BIRD_SPECIES_TAG Published / External Completed This entity represents the tag or leg band(s) observed on an individual animal. It requires that a specimen record be created even if the band(s) are only noted and described. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity represents the tag or leg band(s) observed on an individual animal. It requires that a specimen record be created even if the band(s) are only noted and described. 1 RECORD_SET_STATUS_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a record set header NUMBER 2 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 3 PERMIT VARCHAR2 6 Yes Yes Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 4 TAG_SEQ NUMBER 22 Yes Yes 8 0 Active sequence generated unique identifier for this tag record. NUMBER 5 TYPE_CODE VARCHAR2 3 Yes No Active Unique code identifying the type of recovered tag. VARCHAR2 6 LOCATION_CODE VARCHAR2 10 Yes No Active Unique Code for the found location of a bird tag. For example rtleg; VARCHAR2 7 COLOR_CODE VARCHAR2 5 Yes No Active Color Code VARCHAR2 8 SPECIMEN_SEQ NUMBER 22 Yes No 9 0 Active Sequence generated unique identifier of a bird specimen. NUMBER 9 TAG_CODE VARCHAR2 3 No No Active Code (Domain) identifying presence, absence, applicability of banding. VARCHAR2 10 TAG_NUMBER VARCHAR2 20 No No Active If a tag is present and if read this field records the USFWS number or other number. VARCHAR2 9611 ATLW_BIRD_SPECIMEN Published / External Completed This entity represents the avian specimen which has been chosen for additional biota sampling, preservation, tag recording, or may be representative of a larger group of birds of the same species. A specimen need not be a fatality. It may be an animal that was captured for tag examination and released alive and unharmed. The key is it is a single animal. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity represents the avian specimen which has been chosen for additional biota sampling, preservation, tag recording, or may be representative of a larger group of birds of the same species. A specimen need not be a fatality. It may be an animal that was captured for tag examination and released alive and unharmed. The key is it is a single animal. 1 RECORD_SET_STATUS_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a record set header NUMBER 2 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 3 PERMIT VARCHAR2 6 Yes Yes Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 4 SPECIMEN_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a bird specimen. NUMBER 5 SPECIMEN_NUMBER VARCHAR2 10 Yes No Active User defined uniqe within a specime type identifier. May be a bar code tag. VARCHAR2 6 SPECIMEN_TYPE_CODE VARCHAR2 6 Yes No Active The list of unique type codes associated with a bird specimen. VARCHAR2 7 INTERACTION_SPECIES_SEQ NUMBER 22 Yes No 9 0 Active Sequence generated unique identifier for an species interaction record NUMBER 8 COMMENTS VARCHAR2 500 No No Active Discussion of bird specimen. VARCHAR2 9612 ATLW_BIRD_VESSEL_INTERACT Published / External Completed This entity resolves the intersection between the list of valid events (interactions) that may be observed with a vessel, and the bird event (interaction) record. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity resolves the intersection between the list of valid events (interactions) that may be observed with a vessel, and the bird event (interaction) record. 1 RECORD_SET_STATUS_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a record set header NUMBER 2 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 3 PERMIT VARCHAR2 6 Yes Yes Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 4 BIRD_EVENT_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a bird interaction event. NUMBER 5 ACTIVITY_CODE VARCHAR2 5 Yes Yes Active Unique code for bird activity. VARCHAR2 9613 ATLW_CRUISE_PLANT Published / External Completed The intersection of an observer cruise and a processing plant. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC The intersection of an observer cruise and a processing plant. 1 RECORD_SET_STATUS_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a record set header NUMBER 2 CRUISE_PLANT_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique value for a cruise plant record. NUMBER 3 PLANT_SEQ NUMBER 22 Yes No 9 0 Active Unique Code identifying a processing plant - inherited from the NORPAC data set. The plant_vessel_code is created by logistics staff. NUMBER 4 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 5 PERMIT VARCHAR2 6 Yes Yes Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 9614 ATLW_CRUISE_VESSEL Published / External Completed The intersection of an observer cruise and a vessel Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC The intersection of an observer cruise and a vessel 1 RECORD_SET_STATUS_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a record set header NUMBER 2 CRUISE_VESSEL_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier for a cruise vessel. NUMBER 3 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 4 VESSEL_SEQ NUMBER 22 Yes No 9 0 Active Unique Code identifying a vessel - inherited from the NORPAC data set. Generated by logistics staff. NUMBER 5 PERMIT VARCHAR2 6 Yes Yes Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 9615 ATLW_FISHING_TIME_LOST Published / External Completed Fishing time lost contains the number of hours and reasons for lost fishing time during a trip. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC Fishing time lost contains the number of hours and reasons for lost fishing time during a trip. 1 RECORD_SET_STATUS_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a record set header NUMBER 2 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 3 TRIP_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a trip NUMBER 4 TIME_LOST_CODE VARCHAR2 10 Yes Yes Active Reason code for lost fishing time. VARCHAR2 5 HOURS NUMBER 22 Yes No 3 0 Active Number of hours lost rounded to the nearest hour. NUMBER 6 PERMIT VARCHAR2 6 Yes Yes Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 9616 ATLW_FISH_INV_SPECIMEN Published / External Completed This entity represents the finfish or invertebrate specimen which has been chosen for additional biota sampling from the length sample of animals. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity represents the finfish or invertebrate specimen which has been chosen for additional biota sampling from the length sample of animals. 1 RECORD_SET_STATUS_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a record set header NUMBER 2 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 3 SPECIMEN_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a specimen record. NUMBER 4 SPECIMEN_TYPE NUMBER 22 Yes No 38 Active Unique numeric value for a specimen type record. NUMBER 5 SPECIES_CODE NUMBER 22 No No 4 0 Active Unique identifier for a species imported from Norpac NUMBER 6 MATURITY_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier of a maturity record. NUMBER 7 LENGTH_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier for a length record NUMBER 8 SPECIMEN_NUMBER VARCHAR2 10 Yes No Active A specimen number is unique within a length, user defined identifier. In the case of an otolith it is the bar coded sample identifier attached to the collection vial. VARCHAR2 9 WEIGHT NUMBER 22 No No 10 3 Active Weight in kg of the specimen. NUMBER 10 PERMIT VARCHAR2 6 Yes Yes Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 9617 ATLW_FISH_TICKET Published / External Completed This entity represents the fish ticket preprared from an offload event. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity represents the fish ticket preprared from an offload event. 1 RECORD_SET_STATUS_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a record set header NUMBER 2 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 3 FISH_TICKET_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence within offload parent NUMBER 4 FISHTICKET_NUMBER VARCHAR2 30 Yes No Active A Fish Ticket Number is the Alphanumeric value generated by a processor and given to a vessel captain detailing the transaction and sale of seafood. VARCHAR2 5 OFFLOAD_SEQ NUMBER 22 Yes No 9 0 Active Sequence generated unique identifier for an offload record NUMBER 6 PERMIT VARCHAR2 6 Yes Yes Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 9618 ATLW_FMA_TRIP Published / External Completed AA FMA trip is defined as the time between when a vessel casts off lines and ties up. There may be times where a vessel trip doesn't consist of any fishing. Even though no fishing took place a trip record still musy be created when a transit, offload or observer transfer takes place. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC An FMA trip is defined as any time a vessel leaves a port-floating processor and upon completion it returns to a port-processor and completes an offload or the observer transfers off the vessel. There may be times where a vessel trip doesn't consist of any fishing. Even though no fishing took place a trip record still musy be created when an offload or observer transfer took place. 1 RECORD_SET_STATUS_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a record set header NUMBER 2 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 3 TRIP_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a trip NUMBER 4 CRUISE_VESSEL_SEQ NUMBER 22 Yes No 9 0 Active Sequence generated unique identifier for a cruise vessel. NUMBER 5 TRIP_NUMBER NUMBER 22 Yes No 4 0 Active Number which is entered by the observer identifying a unique within a cruise - vessel combination. Since records are not physically deleted, trigger code preserves uniqueness by allowing only a single active record to exist (delete_marker IS NOT NULL). NUMBER 6 EMBARKED_PORT_CODE NUMBER 22 No No 38 Active User defined unique identifier of a port currently limited to 1 - 12 NUMBER 7 DISEMBARKED_PORT_CODE NUMBER 22 No No 38 Active User defined unique identifier of a port currently limited to 1 - 12 NUMBER 8 BAIT_USED_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier of a bait used record NUMBER 9 START_DATE DATE 7 Yes No Active Date of embarkation. DATE 10 START_LATITUDE_DEGREE NUMBER 22 No No 2 0 Active Latitude of embarkation in degrees. NUMBER 11 START_LATITUDE_MIN NUMBER 22 No No 2 0 Active Latitude of embarkation in minutes. NUMBER 12 START_LATITUDE_SEC NUMBER 22 No No 2 0 Active Latitude of embarkation in seconds. NUMBER 13 START_LONGITUDE_DEGREE NUMBER 22 No No 3 0 Active Longitude of embarkation in degrees. NUMBER 14 START_LONGITUDE_MIN NUMBER 22 No No 2 0 Active Longitude of embarkation in minutes. NUMBER 15 START_LONGITUDE_SEC NUMBER 22 No No 2 0 Active Longitude of embarkation in seconds. NUMBER 16 START_EW VARCHAR2 1 No No Active East West longitude identifier for Embarkation. VARCHAR2 17 END_DATE DATE 7 No No Active Date of landing, tying up to a mothership, transfer of fish between codends or other interaction signifying the ending of a trip. DATE 18 END_LATITUDE_DEGREE NUMBER 22 No No 2 0 Active Latitude of disembarkation in degrees. NUMBER 19 END_LATITUDE_MIN NUMBER 22 No No 2 0 Active Latitude of disembarkation in minutes NUMBER 20 END_LATITUDE_SEC NUMBER 22 No No 2 0 Active Latitude of disembarkation in seconds NUMBER 21 END_LONGITUDE_DEGREE NUMBER 22 No No 3 0 Active Longitude of disembarkation in degrees. NUMBER 22 END_LONGITUDE_MIN NUMBER 22 No No 2 0 Active Longitude of disembarkation in minutes NUMBER 23 END_LONGITUDE_SEC NUMBER 22 No No 2 0 Active Longitude of disembarkation in seconds NUMBER 24 END_EW VARCHAR2 1 No No Active East West longitude identifier for Disembarkation. VARCHAR2 25 CREW_SIZE NUMBER 22 No No 38 Active Number of personnel on the vessel. NUMBER 26 DID_FISHING_OCCUR_FLAG VARCHAR2 1 Yes No Active Idetifies whether fishing took place or not. VARCHAR2 27 FISH_IN_HOLD_AT_START_FLAG VARCHAR2 1 Yes No Active Identifies whether there were fish present in the hold at the start of a fishing trip. VARCHAR2 28 COMMENTS VARCHAR2 2000 No No Active Any specific comments an observer might make in regards to this trip. In particular comments are required to documented lost fishing time. VARCHAR2 29 PERMIT VARCHAR2 6 Yes Yes Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 9619 ATLW_HAUL Published / External Completed Hauls are unique fishing events of gear deployment and retrieval and may also contain information unique to a day where no fishing occured. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC Hauls are unique fishing events of gear deployment and retrieval and may also contain information unique to a day where no fishing occured. 1 RECORD_SET_STATUS_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a record set header NUMBER 2 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 3 HAUL_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier for a haul record NUMBER 4 HAUL_NUMBER NUMBER 22 Yes No 6 0 Active Number which is entered by the observer identifying a unique haul within a trip. Since records are not physically deleted, trigger code preserves uniqueness by allowing only a single active record to exist (delete_marker IS NOT NULL). NUMBER 5 HAUL_PURPOSE_CODE VARCHAR2 3 Yes No Active Haul data may be utilized for catch accounting, stock assessment, or for various special projects. This field is entered by the observer and not validated by ATLAS. Validation is performed when loaded into the production NORPAC data set. VARCHAR2 6 CDQ_CODE VARCHAR2 3 No No Active Unique AlphaNumeric code representing a CDQ or research group VARCHAR2 7 TRIP_SEQ NUMBER 22 Yes No 9 0 Active Sequence generated unique identifier of a trip NUMBER 8 DELIVERY_VESSEL_ADFG VARCHAR2 6 No No Active ADFG number entered by the observer if the delivering vessel does not exist in the vessel lookup table. VARCHAR2 9 GEAR_PERFORMANCE_CODE NUMBER 22 Yes No 38 Active Unique performance code for a gear type. NUMBER 10 RBT_CODE VARCHAR2 1 Yes No Active Currently limted to Y (es) or N(o) VARCHAR2 11 VESSEL_TYPE NUMBER 22 Yes No 38 Active Unique identifier of a vessel type NUMBER 12 GEARTYPE_FORM VARCHAR2 1 Yes No Active Form that the gear is valid for. For example the gear may be Unknown for a delivery but will always be determined for a haul. VARCHAR2 13 GEAR_TYPE_CODE NUMBER 22 Yes No 38 Active Numeric value from Norpac Domestic Gear that combined with the Form defines the unique identifier for a gear record NUMBER 14 RST_CODE VARCHAR2 1 No No Active VARCHAR2 15 DETERRENCE_CODE VARCHAR2 2 No No Active Deterrence code from NORPAC bird or mammal deterance tables VARCHAR2 16 ANIMAL_TYPE_CODE VARCHAR2 1 No No Active Optional FK from LOV_Deterrence. Class of animal mammal (M), bird (B) for which the deterrence (if it exists) was utilized VARCHAR2 17 LOCATION_CODE VARCHAR2 1 Yes No Active Identifies whether the information in a haul is based on retrieval or delivery (as in a mother ship) VARCHAR2 18 RETRV_DATE_TIME DATE 7 Yes No Active Date and time recorded by the observer from the vessel log. DATE 19 RETRV_LATITUDE_DEGREES NUMBER 22 Yes No 2 0 Active Location of gear retrieval. NUMBER 20 RETRV_LATITUDE_MINUTES NUMBER 22 Yes No 2 0 Active Location of gear retrieval. NUMBER 21 RETRV_LATITUDE_SECONDS NUMBER 22 No No 2 0 Active Location of gear retrieval. NUMBER 22 RETRV_EW VARCHAR2 1 Yes No Active Location of gear retrieval. VARCHAR2 23 RETRV_LONGITUDE_DEGREES NUMBER 22 Yes No 3 0 Active Location of gear retrieval. NUMBER 24 RETRV_LONGITUDE_MINUTES NUMBER 22 Yes No 2 0 Active Location of gear retrieval. NUMBER 25 RETRV_LONGITUDE_SECONDS NUMBER 22 No No 2 0 Active Location of gear retrieval. NUMBER 26 DEPLOY_DATE_TIME DATE 7 No No Active Date and time recorded by the observer from the vessel log. DATE 27 DEPLOY_LATITUDE_DEGREES NUMBER 22 No No 2 0 Active Location of gear deployment. NUMBER 28 DEPLOY_LATITUDE_MINUTES NUMBER 22 No No 2 0 Active Location of gear deployment. NUMBER 29 DEPLOY_LATITUDE_SECONDS NUMBER 22 No No 2 0 Active Location of gear deployment. NUMBER 30 DEPLOY_EW VARCHAR2 1 No No Active Location of gear deployment. VARCHAR2 31 DEPLOY_LONGITUDE_DEGREES NUMBER 22 No No 3 0 Active Location of gear deployment. NUMBER 32 DEPLOY_LONGITUDE_MINUTES NUMBER 22 No No 2 0 Active Location of gear deployment. NUMBER 33 DEPLOY_LONGITUDE_SECONDS NUMBER 22 No No 2 0 Active Location of gear deployment. NUMBER 34 BOTTOM_DEPTH NUMBER 22 No No 5 0 Active Average bottom depth recorded by the observer from the vessel log. NUMBER 35 FISHING_DEPTH NUMBER 22 No No 5 0 Active Average fishing depth recorded by the observer from the vessel log. NUMBER 36 DEPTH_METER_FATHOM VARCHAR2 1 No No Active Identifies whether depth is recorded in meters or fathoms. VARCHAR2 37 VESSEL_EST_CATCH NUMBER 22 No No 6 2 Active Total catch weight in metric tons as recorded in the vessel log. NUMBER 38 OBSVR_EST_CATCH NUMBER 22 No No 6 2 Active Total catch weight as estimated by the observer in metric tons. NUMBER 39 OBSVR_EST_METHOD VARCHAR2 1 No No Active Method used to determine the observer estimated catch VARCHAR2 40 OBSVR_EST_DISCARDS NUMBER 22 No No 6 2 Active Observer estimate of total discards NUMBER 41 DENSITY NUMBER 22 No No 3 2 Active Density used by the observer to determine the total catch weights. NUMBER 42 INDIV_FISHING_QUOTA_FLAG VARCHAR2 1 Yes No Active Identifies whether fishing is on an IFQ quota with the subsequent application of IFQ rules. VARCHAR2 43 SAMPLED_BY NUMBER 22 Yes No 38 Active Identifies where a haul is sampled by an observer and in some cases by which observer. NUMBER 44 NUMBER_OF_SKATES NUMBER 22 No No 4 2 Active Number of skates for longline fishing. NUMBER 45 NUMBER_OF_HOOKS_PER_SKATE NUMBER 22 No No 4 0 Active Number of hooks per skate for longline fishing. NUMBER 46 TOTAL_HOOKS NUMBER 22 No No 6 0 Active Total number of hooks deployed for this haul NUMBER 47 TOTAL_POTS NUMBER 22 No No 5 0 Active Total number of pots deployed for this haul. NUMBER 48 MMAMMAL_MONITR_PCT NUMBER 22 No No 3 0 Active Percentage of time for this haul where marine mammal monitoring occured. For fixed gear deployments the valid values are anywhere in the range. For mobile gear deployments the values may be either 0 or 100. NUMBER 49 PERMIT VARCHAR2 6 Yes Yes Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 50 VOLUME NUMBER 22 No No 6 2 Active Estimate of volume of catch NUMBER 51 TOTAL_HOOKS_OVERIDE_FLAG VARCHAR2 1 No No Active If an observer believes that the calculated value of total hooks is not correct. It is allowed that the value is overridden. If that is the case then this flag will be set to Y by trigger code, and total-hooks will be protected from automatic recalculateion. VARCHAR2 52 BIRD_MONITOR_LEVEL_CODE VARCHAR2 4 No No Active Portion of the haulback that was monitored by the observer for bird interactions. VARCHAR2 53 SHORTWIRED_FLAG VARCHAR2 1 Yes No Active Denoting whether the net was shortwired during the haulback. Do not record a Y when the net is shortwired during the tow but then returned to fishing depth. VARCHAR2 54 SAMPLE_UNIT_CODE VARCHAR2 6 No No Active Unique code identifying the unit of measure for a sampling design. Sample Design and units are mandatory at the haul level and optional at the sample level. VARCHAR2 55 SAMPLE_SYSTEM_CODE NUMBER 22 No No 38 Active Unique numeric identifier of a sample coding system. NUMBER 9620 ATLW_HAUL_HOOK_COUNT Published / External Completed This entity represents the observer matching of hauls by haul number to hook count sets by set number. That value is used to compute and populate the haul total hooks, and sample sample hooks-pots. Both total hooks and sample hooks may be overwritten by the observer, however as a general rule will be computed by the average hooks per segment computed for a hook count set * number of segments in the haul or number of segments sampled in the sample. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity represents the observer matching of hauls by haul number to hook count sets by set number. That value is used to compute and populate the haul total hooks, and sample sample hooks-pots. Both total hooks and sample hooks may be overwritten by the observer, however as a general rule will be computed by the average hooks per segment computed for a hook count set * number of segments in the haul or number of segments sampled in the sample. 1 RECORD_SET_STATUS_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a record set header NUMBER 2 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 3 PERMIT VARCHAR2 6 Yes Yes Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 4 SET_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a hook spacing set. NUMBER 5 HAUL_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier for a haul record NUMBER 6 HAUL_NUMBER NUMBER 22 Yes No 38 Active Unique haul for an observer vessel cruise, defaulted to an incremented sequence by the GUI. May be entered and defined by the observer. NUMBER 7 COLLECTION_NUMBER NUMBER 22 Yes No 3 0 Active User Defined Hook Count Sent number unique for a cruise permit. NUMBER 9621 ATLW_HOOKS_PER_SEGMENT Published / External Completed Stock assessment authors for sablefish (and potentially for P.cod) use catch-per-unit-effort information in their models. A key component of this is the spacing of the hooks on the gear. Every year, we issue a special project where the observers measure the spacing of the hooks on a few segments of gear. That special project has been absorbed into the standard data set for 2010. This entity represent the hook count and hook spacing measurements for a segment of gear. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC Stock assessment authors for sablefish (and potentially for P.cod) use catch-per-unit-effort information in their models. A key component of this is the spacing of the hooks on the gear. Every year, we issue a special project where the observers measure the spacing of the hooks on a few segments of gear. That special project has been absorbed into the standard data set for 2010. This entity represent the hook count and hook spacing measurements for a segment of gear. 1 RECORD_SET_STATUS_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a record set header NUMBER 2 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 3 HOOKS_PER_SEGMENT_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a hook count and measure for a segment of longline gear. NUMBER 4 PERMIT VARCHAR2 6 Yes Yes Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 5 SET_SEQ NUMBER 22 Yes No 6 0 Active Sequence generated unique identifier of a hook spacing set. NUMBER 6 SEGMENT_NUMBER NUMBER 22 Yes No 3 0 Active This attribute represents a user defined integer identifying a unit of line for counting and spacing hooks. It must be unique within a hook_count_set. NUMBER 7 NUMBER_OF_HOOKS NUMBER 22 Yes No 8 0 Active Number of hooks as determined by the observer for this segment, contained within a counted set. NUMBER 8 HOOK_SPACING_IN_CM NUMBER 22 No No 4 0 Active Spacing between hooks on a segment. This value is optional for any specific segment except the first set of spacing-count on a trip NUMBER 9622 ATLW_HOOK_COUNT_SET Published / External Completed Twice a week an observer is required to measure hook spacing and total hooks for twenty percent of the segments (skates/racks) of a typical haul. These measurements may be taken all at once or over a period of time and accumulated into a set. This entity represents that collection of hook and spacing data. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC Twice a week an observer is required to measure hook spacing and total hooks for twenty percent of the segments (skates/racks) of a typical haul. These measurements may be taken all at once or over a period of time and accumulated into a set. This entity represents that collection of hook and spacing data. 1 RECORD_SET_STATUS_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a record set header NUMBER 2 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 3 PERMIT VARCHAR2 6 Yes Yes Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 4 SET_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a hook spacing set. NUMBER 5 COLLECTION_NUMBER NUMBER 22 Yes No 3 0 Active User Defined Hook Count Sent number unique for a cruise permit. NUMBER 6 CRUISE_VESSEL_SEQ NUMBER 22 Yes No 9 0 Active Sequence generated unique identifier for a cruise vessel. NUMBER 7 COLLECTION_DATE DATE 7 Yes No Active Date and Time count taken. DATE 9623 ATLW_LENGTH Published / External Completed This entity is mapped to the Norpac length tables. It contains header information about sampled animals. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity is mapped to the Norpac length tables. It contains header information about sampled animals. 1 RECORD_SET_STATUS_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a record set header NUMBER 2 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 3 LENGTH_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier for a length record NUMBER 4 CONDITION_CODE NUMBER 22 No No 38 Active Numeric code identifying the injury NUMBER 5 ANIMAL_TYPE_CODE VARCHAR2 2 No No Active Refers the the class of animal for example M - mammal H-halibut. Enforced by the Domain Animal Type. VARCHAR2 6 SAMPLE_SYSTEM_CODE NUMBER 22 Yes No 38 Active Unique numeric identifier of a sample coding system. NUMBER 7 SPECIES_CODE NUMBER 22 No No 4 0 Active Unique identifier for a species imported from Norpac NUMBER 8 SPECIES_COMPOSITION_SEQ NUMBER 22 No No 9 0 Active Sequence Generated unique identifier of a species composition record NUMBER 9 HAUL_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier for a haul record NUMBER 10 OFFLOAD_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier for an offload record NUMBER 11 SEX_CODE VARCHAR2 1 No No Active The sex of this animal VARCHAR2 12 LENGTH_SIZE NUMBER 22 No No 38 Active The length of this animal NUMBER 13 FREQUENCY NUMBER 22 No No 38 Active The total number of animals within this size group NUMBER 14 EGGS_IND VARCHAR2 1 No No Active Identifies the presence or absence of egg for crabs. VARCHAR2 15 VIABILITY VARCHAR2 1 No No Active Identifies the viability status for halibut VARCHAR2 16 PERMIT VARCHAR2 6 Yes Yes Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 9624 ATLW_MAMMAL Published / External Completed This entity contains the mammal data specific to a haul, offload or a trip. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity contains the mammal data specific to a haul or a trip. 1 RECORD_SET_STATUS_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a record set header NUMBER 2 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 3 MAMMAL_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier for a mammal record NUMBER 4 MAMMAL_SPECIES_CODE VARCHAR2 2 Yes No Active Unique identifier for a species imported from Norpac VARCHAR2 5 OFFLOAD_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier for an offload record NUMBER 6 TRIP_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier of a trip NUMBER 7 HAUL_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier for a haul record NUMBER 8 NUMBER_OF_ANIMALS NUMBER 22 No No 3 0 Active Number of animals involved with this interaction NUMBER 9 PERMIT VARCHAR2 6 Yes Yes Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 9625 ATLW_MAMMAL_INTERACTION Published / External Completed This entity records marine mammal interactions that coud occur at the haul, offload or the trip level. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity records marine mammal interactions that coud occur at the haul level or the trip level. 1 RECORD_SET_STATUS_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a record set header NUMBER 2 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 3 INTERACTION_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence within Mammal Parent record NUMBER 4 MAMMAL_SEQ NUMBER 22 Yes No 9 0 Active Sequence generated unique identifier for a mammal record NUMBER 5 SPECIES_CODE NUMBER 22 No No 4 0 Active Unique identifier for a species imported from Norpac NUMBER 6 DETERRENCE_ANIMAL_TYPE VARCHAR2 1 No No Active Optional FK from LOV_Deterrence. Class of animal mammal (M), bird (B) for which the deterrence (if it exists) was utilized VARCHAR2 7 DETERRENCE_CODE VARCHAR2 2 No No Active Optional FK from LOV_Deterrence combined with deterrence_animal type. Deterrence codes are from NORPAC bird or mammal deterance tables. VARCHAR2 8 DETERRENCE_SUCCESS_FLAG VARCHAR2 1 No No Active Identifies whether or not the deterence measures applied were successful VARCHAR2 9 MAMMAL_INTERACT_CODE NUMBER 22 Yes No 38 Active Numeric code uniquely identifying a mammal interaction. The value is suppllied at data load from Norpac NUMBER 10 CONDITION_CODE NUMBER 22 Yes No 2 0 Active FK from the LOV_Condition_Table. Numeric code identifying the injury NUMBER 11 CONDITION_ANIMAL_TYPE VARCHAR2 1 Yes No Active FK from the LOV_Condition_Table. Refers the the class of animal for example M - mammal H-halibut. Enforced by the Domain Animal Type. VARCHAR2 12 INTERACTION_DATE DATE 7 No No Active Date the mammal interaction was observed. DATE 13 OBSERVATION_FLAG VARCHAR2 1 No No Active Did the observer physically witness the interaction. VARCHAR2 14 NUMBER_OF_ANIMALS NUMBER 22 Yes No 3 0 Active Number of animals involved with this interaction NUMBER 15 LATITUDE_DEGREES NUMBER 22 No No 2 0 Active Latitude at which the interaction with a mammal occured. NUMBER 16 LATITUDE_MINUTES NUMBER 22 No No 2 0 Active Latitude at which the interaction with a mammal occured. NUMBER 17 LATITUDE_SECONDS NUMBER 22 No No 2 0 Active Latitude at which the interaction with a mammal occured. NUMBER 18 LONGITUDE_DEGREES NUMBER 22 No No 3 0 Active Longitude at which the interaction with a mammal occured. NUMBER 19 LONGITUDE_MINUTES NUMBER 22 No No 2 0 Active Longitude at which the interaction with a mammal occured. NUMBER 20 LONGITUDE_SECONDS NUMBER 22 No No 2 0 Active Longitude at which the interaction with a mammal occured. NUMBER 21 LONGITUDE_EW VARCHAR2 1 No No Active Identifies the logitude as E(ast) or W(est) VARCHAR2 22 COMMENTS VARCHAR2 2500 Yes No Active Observer entered comments regarding this interaction. VARCHAR2 23 PERMIT VARCHAR2 6 Yes Yes Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 9626 ATLW_MAMMAL_SPECIMEN Published / External Completed This entity maps to the Norpac Domestic_Mammal_Specimen Table, and records sampling information for marine mammal tissue and measurements recorded for hauls, offloads, or trips. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity maps to the Norpac Domestic_Mammal_Specimen Table 1 RECORD_SET_STATUS_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a record set header NUMBER 2 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 3 MAMMAL_SPECIMEN_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a mammal specimen record. NUMBER 4 ANIMAL_NUMBER NUMBER 22 Yes No 3 0 Active User Entered identifier or a particular animal within a mammal interaction. This number is unique in combination with a specimen type. NUMBER 5 SPECIMEN_TYPE_SEQ NUMBER 22 Yes No 9 0 Active Foreign Key value identifying the type of speciment collected. NUMBER 6 INTERACTION_SEQ NUMBER 22 Yes No 9 0 Active Sequence within Mammal Parent record NUMBER 7 SPECIMEN_NUMBER NUMBER 22 No No 9 0 Active A specimen number is unique with a mammal record. It is auser defined identifier. NUMBER 8 SEX VARCHAR2 1 Yes No Active Sex of a mammal speciem (M)ale, (F)emale, (U)nknown or undertermined. VARCHAR2 9 VALUE VARCHAR2 10 No No Active If the Specimen Type requires a value to be entered this attribute is the data store. VARCHAR2 10 COMMENTS VARCHAR2 1000 No No Active Observer entered comments VARCHAR2 11 PERMIT VARCHAR2 6 Yes Yes Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 9627 ATLW_NON_FISHING_DAY Published / External Completed This entitity represents the date and location of every day during a trip where fishing did not occur. For 2009 this concept was expanded to days wth no observer activity at a processing plant. To impliment this change all non PK fields sans date bacame optional. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entitity represents the date and location of every day during a trip where fishing did not occur. For 2009 this concept was expanded to days wth no observer activity at a processing plant. To impliment this change all non PK fields sans date bacame optional. 1 RECORD_SET_STATUS_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a record set header NUMBER 2 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 3 NO_FISHING_DAY_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a non-fishing day record NUMBER 4 CRUISE_VESSEL_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier for a cruise vessel. NUMBER 5 NONFISH_DATE DATE 7 Yes No Active Date on which no fishing activity occured DATE 6 LATITUDE_DEGREES NUMBER 22 No No 2 0 Active Latitude of non fishing day (not time specfic) in degrees. NUMBER 7 LATITUDE_MINUTES NUMBER 22 No No 2 0 Active Latitude of non fishing day (not time specfic) in minutes NUMBER 8 LATITUDE_SEC NUMBER 22 No No 2 0 Active Latitude of non fishing day (not time specfic) in seconds NUMBER 9 LONGITUDE_DEGREES NUMBER 22 No No 3 0 Active Longitude of of non fishing day (not time specfic) in degrees. NUMBER 10 LONGITUDE_MINUTES NUMBER 22 No No 2 0 Active Longitude of non fishing day (not time specfic) in minutes NUMBER 11 LONGITUDE_SEC NUMBER 22 No No 2 0 Active Longitude of non fishing day (not time specfic) NUMBER 12 LONGITUDE_EW VARCHAR2 1 No No Active East West Longitude indicator for a non fishing day locaton. VARCHAR2 13 PERMIT VARCHAR2 6 Yes Yes Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 14 CRUISE_PLANT_SEQ NUMBER 22 No No 9 0 Active NUMBER 9628 ATLW_OBSERVER_CRUISE Published / External Completed Records the essentials of an observer contract. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC Records within Atlas the essentials of an observer contract. 1 RECORD_SET_STATUS_SEQ NUMBER 22 Yes No 9 0 Active Sequence generated unique identifier of a record set header NUMBER 2 CRUISE NUMBER 22 Yes No 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 3 FIRST_NAME VARCHAR2 25 Yes No Active Observer First Name VARCHAR2 4 LAST_NAME VARCHAR2 50 Yes No Active Observer Last Name VARCHAR2 5 CREATE_DATE DATE 7 Yes No Active Timestamp that record was created DATE 6 PASSWORD RAW 60 No No Active Password entered by the lead observer for use by all observers on a cruise. RAW 9629 ATLW_OFFLOAD Published / External Completed This entity represents an offload event at a processing plant or mothership. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity represents an offload event at a processing plant or mothership. 1 RECORD_SET_STATUS_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a record set header NUMBER 2 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 3 OFFLOAD_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier for an offload record NUMBER 4 OFFLOAD_NUMBER NUMBER 22 Yes No 38 Active Unique offload for an observer cruise entered by the observer. NUMBER 5 TRIP_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier of a trip NUMBER 6 PLANT_SEQ NUMBER 22 No No 9 0 Active Optional FK to Plant. Part of arc involving catcher vessel, haul, and cruise plant. Code identifying a processing plant - inherited from the NORPAC data set. The plant_vessel_code is created by logistics staff. NUMBER 7 CRUISE_PLANT_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique value for a cruise plant record. NUMBER 8 DELIVERY_VESSEL_ADFG VARCHAR2 6 No No Active ADFG number entered by the observer if the vessel does not exist in the vessel lookup table VARCHAR2 9 GEAR_TYPE_CODE NUMBER 22 No No 38 Active Numeric value from Norpac Domestic Gear that combined with the Form defines the unique identifier for a gear record NUMBER 10 GEARTYPE_FORM VARCHAR2 1 No No Active Form that the gear is valid for. For example the gear may be Unknown for a delivery but will always be determined for a haul. VARCHAR2 11 DELIVERY_END_DATE DATE 7 No No Active Date the delivery was complete. DATE 12 NMFS_AREA VARCHAR2 3 No No Active NMFS Reporting Area VARCHAR2 13 DELIVERED_WEIGHT NUMBER 22 No No 10 3 Active Total weight of the delivery NUMBER 14 TOTAL_POLLOCK_WEIGHT NUMBER 22 No No 10 3 Active Identifies the total weight of pollock delivered NUMBER 15 LB_MT VARCHAR2 2 No No Active Pounds (LB) or Metric Tons (MT) identifier of weight. VARCHAR2 16 GROUNDFISH_WEIGHED_FLAG VARCHAR2 1 No No Active Identifies whether or not all the groundfish were weighed. VARCHAR2 17 SORTED_AT_SEA_FLAG VARCHAR2 1 Yes No Active Identifies catch sorted by the catcher vessel at sea. VARCHAR2 18 OFFLOAD_TO_TENDER_FLAG VARCHAR2 1 No No Active Identifies if a tender was used to make this delivery. VARCHAR2 19 PERMIT VARCHAR2 6 Yes Yes Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 20 LANDING_REPORT_ID NUMBER 22 No No 10 0 Active The region uses the landing report id off the electronic fish ticket as a join column for the catch accounting system. The value is printed on the lower quadrant of every ER fish ticket. Landing_Report_ID is unique to an offload. NUMBER 9630 ATLW_PERCENT_RETAINED Published / External Completed This entity records the amount of each species retained as a percentage of the total catch for that species in a haul. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity records the amount of each species retained, for that species in a haul. 1 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 2 RECORD_SET_STATUS_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a record set header NUMBER 3 HAUL_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier for a haul record NUMBER 4 SPECIES_CODE NUMBER 22 Yes Yes 4 0 Active Unique identifier for a species imported from Norpac NUMBER 5 TOTAL_PERCENT_RETAINED NUMBER 22 No No 3 0 Active Percent retained value for that species for this haul. NUMBER 6 PERMIT VARCHAR2 6 Yes Yes Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 9636 ATL_BIRD_AGE Published / External Completed This entity resolves the intersection of a bird interaction species and the age categories. An interaction may include multiple age classes of that species. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity resolves the intersection of a bird interaction species and the age categories. An interaction may include multiple age classes of that species. 1 BIRD_AGE_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence Generated Unique identifier for a bird age record NUMBER 2 CRUISE NUMBER 22 Yes No 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER Refers to more than one entity 3 PERMIT VARCHAR2 6 Yes No Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 Refers to more than one entity 4 AGE_CATEGORY_CODE VARCHAR2 10 Yes No Active Unique code for classifying bird age VARCHAR2 NORPAC.ATL_LOV_BIRD_AGE_CATEGO 5 SPECIMEN_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier of a bird specimen. NUMBER NORPAC.ATL_BIRD_SPECIMEN 6 INTERACTION_SPECIES_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier for an species interaction record NUMBER NORPAC.ATL_BIRD_INTERAC_SPECIE 7 NUMBER_OF_ANIMALS NUMBER 22 Yes No 3 0 Active Number of birds of this species of this age category NUMBER 9637 ATL_BIRD_AGE_H Published / External Completed This entity resolves the intersection of a bird interaction species and the age categories. An interaction may include multiple age classes of that species. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity resolves the intersection of a bird interaction species and the age categories. An interaction may include multiple age classes of that species. 1 SEQ_NUMBER NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier for a history table. Every history table has a unique sequence assigned to it all start with 1, icrement by 1 and do not cycle. NUMBER 2 CRUISE NUMBER 22 Yes No 9 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 3 PERMIT VARCHAR2 6 Yes No Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 4 CHANGED_BY VARCHAR2 30 No No Active Oracle user who made a change to the transaction table record. VARCHAR2 5 DATE_CHANGED DATE 7 No No Active Timestamp of change to transaction record. DATE 6 BIRD_AGE_SEQ NUMBER 22 No No 9 0 Active Sequence Generated Unique identifier for a bird age record NUMBER 7 AGE_CATEGORY_CODE VARCHAR2 10 Yes No Active Unique code for classifying bird age VARCHAR2 8 SPECIMEN_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier of a bird specimen. NUMBER 9 INTERACTION_SPECIES_SEQ NUMBER 22 No No 8 0 Active Sequence generated unique identifier for an species interaction record NUMBER 10 NUMBER_OF_ANIMALS NUMBER 22 No No 3 0 Active Number of birds of this species of this age category NUMBER 9638 ATL_BIRD_EVENT Published / External Completed This entity records bird interactions characterized by type, that may occur at either the haul, offload or at the trip level. Each interaction is recorded separately and may be for multiple animals. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity records bird interactions characterized by type, that may occur at either the haul, offload or at the trip level. Each interaction is recorded separately and may be for multiple animals. 1 BIRD_EVENT_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a bird interaction event. NUMBER 2 cruise1 NUMBER 22 No No 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER Refers to more than one entity 2 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER Refers to more than one entity 3 PERMIT VARCHAR2 6 Yes Yes Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 Refers to more than one entity 4 EVENT_NUMBER NUMBER 22 Yes No 4 0 Active User defined event reference number which is unique within a cruise. NUMBER 5 TRIP_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier of a trip NUMBER NORPAC.ATL_FMA_TRIP 6 OFFLOAD_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier for an offload record NUMBER NORPAC.ATL_OFFLOAD 7 HAUL_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier for a haul record NUMBER NORPAC.ATL_HAUL 8 DETERRENT_USED_CODE VARCHAR2 10 Yes No Active Unique code dientifying the reason for the use or absence of a bird deterrence strategy. VARCHAR2 NORPAC.ATL_LOV_BIRD_DETERERENT 9 BEAUFORT_CODE VARCHAR2 10 Yes No Active International Beaufort Sea State Code VARCHAR2 NORPAC.ATL_LOV_BEAUFORT_SCALE 10 COUNT_TYPE_CODE VARCHAR2 10 Yes No Active Unique code describing how the number of animals field is determined. Except for a type of specific the grouping is an estimate and number is not required. VARCHAR2 NORPAC.ATL_LOV_BIRD_COUNT_TYPE 11 LOCATION_CODE VARCHAR2 10 Yes No Active Unique code identifying the location of the bird at the first observation VARCHAR2 NORPAC.ATL_LOV_BIRD_EVENT_LOCA 12 WEATHER_CODE VARCHAR2 10 Yes No Active Unique weather code VARCHAR2 NORPAC.ATL_LOV_WEATHER_CODE 13 FISHERY_CODE VARCHAR2 5 Yes No Active Unique Abbreviated code for a fishery as defined by the observer. VARCHAR2 NORPAC.ATL_LOV_BIRD_FISHERY 14 NUMBER_OF_ANIMALS NUMBER 22 Yes No 4 0 Active Number of animals involved with this interaction NUMBER 15 LATITUDE_DEGREE NUMBER 22 No No 2 0 Active Latitude at which the interaction with a bird occured. NUMBER 16 LATITUDE_MINUTES NUMBER 22 No No 2 0 Active Latitude at which the interaction with a bird occured. NUMBER 17 LATITUDE_SECONDS NUMBER 22 No No 2 0 Active Latitude at which the interaction with a bird occured. NUMBER 18 LONGITUDE_DEGREE NUMBER 22 No No 3 0 Active Longitude at which the interaction with a bird occured. NUMBER 19 LONGITUDE_MINUTES NUMBER 22 No No 2 0 Active Longitude at which the interaction with a bird occured. NUMBER 20 LONGITUDE_SECONDS NUMBER 22 No No 2 0 Active Longitude at which the interaction with a bird occured. NUMBER 21 LONGITUDE_EW VARCHAR2 1 No No Active Identifies the logitude as E(ast) or W(est) VARCHAR2 22 INTERACTION_DATE_TIME DATE 7 No No Active Date the interaction was observed. If an interaction record is related to an offload or a haul this date is inferred as the haul date or offload end date. If the interaction is related to a trip the interaction date is mandatory. DATE 23 COMMENTS VARCHAR2 500 No No Active Observer entered comments regarding this interaction. VARCHAR2 9639 ATL_BIRD_EVENT_H Published / External Completed This entity records bird interactions characterized by type, that may occur at either the haul, offload or at the trip level. Each interaction is recorded separately and may be for multiple animals. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity records bird interactions characterized by type, that may occur at either the haul, offload or at the trip level. Each interaction is recorded separately and may be for multiple animals. 1 SEQ_NUMBER NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier for a history table. Every history table has a unique sequence assigned to it all start with 1, icrement by 1 and do not cycle. NUMBER 2 CRUISE NUMBER 22 Yes No 9 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 3 PERMIT VARCHAR2 6 Yes No Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 4 EVENT_NUMBER NUMBER 22 No No 4 0 Active User defined event reference number which is unique within a cruise. NUMBER 5 CHANGED_BY VARCHAR2 30 No No Active Oracle user who made a change to the transaction table record. VARCHAR2 6 DATE_CHANGED DATE 7 No No Active Timestamp of change to transaction record. DATE 7 BIRD_EVENT_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier of a bird interaction event. NUMBER 8 TRIP_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier of a trip NUMBER 9 OFFLOAD_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier for an offload record NUMBER 10 HAUL_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier for a haul record NUMBER 11 DETERRENT_USED_CODE VARCHAR2 10 No No Active Unique code dientifying the reason for the use or absence of a bird deterrence strategy. VARCHAR2 12 BEAUFORT_CODE VARCHAR2 10 No No Active International Beaufort Sea State Code VARCHAR2 13 COUNT_TYPE_CODE VARCHAR2 10 No No Active Unique code describing how the number of animals field is determined. Except for a type of specific the grouping is an estimate and number is not required. VARCHAR2 14 LOCATION_CODE VARCHAR2 10 No No Active Unique code identifying the location of the bird at the first observation VARCHAR2 15 WEATHER_CODE VARCHAR2 10 Yes No Active Unique weather code VARCHAR2 16 FISHERY_CODE VARCHAR2 5 No No Active Unique Abbreviated code for a fishery as defined by the observer. VARCHAR2 17 NUMBER_OF_ANIMALS NUMBER 22 No No 4 0 Active Number of animals involved with this interaction NUMBER 18 LATITUDE_DEGREE NUMBER 22 No No 2 0 Active Latitude at which the interaction with a bird occured. NUMBER 19 LATITUDE_MINUTES NUMBER 22 No No 2 0 Active Latitude at which the interaction with a bird occured. NUMBER 20 LATITUDE_SECONDS NUMBER 22 No No 2 0 Active Latitude at which the interaction with a bird occured. NUMBER 21 LONGITUDE_DEGREE NUMBER 22 No No 3 0 Active Longitude at which the interaction with a bird occured. NUMBER 22 LONGITUDE_MINUTES NUMBER 22 No No 2 0 Active Longitude at which the interaction with a bird occured. NUMBER 23 LONGITUDE_SECONDS NUMBER 22 No No 2 0 Active Longitude at which the interaction with a bird occured. NUMBER 24 LONGITUDE_EW VARCHAR2 1 No No Active Identifies the logitude as E(ast) or W(est) VARCHAR2 25 INTERACTION_DATE_TIME DATE 7 No No Active Date the interaction was observed. If an interaction record is related to an offload or a haul this date is inferred as the haul date or offload end date. If the interaction is related to a trip the interaction date is mandatory. DATE 26 COMMENTS VARCHAR2 500 No No Active Observer entered comments regarding this interaction. VARCHAR2 9640 ATL_BIRD_EVENT_OUTCOME Published / External Completed This entity represents the outcome of a bird interaction or a bird event, species interaction or of an indivdual animal (specimen) Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity represents the outcome of a bird interaction or a bird event, species interaction or of an indivdual animal (specimen 1 EVENT_OUTCOME_SEQ NUMBER 22 Yes Yes 9 0 Active interaction behavior seq. NUMBER 2 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER Refers to more than one entity 3 PERMIT VARCHAR2 6 Yes Yes Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 Refers to more than one entity 4 OUTCOME_CODE VARCHAR2 10 Yes No Active Unique code identifying the condition of the bird after this interaction VARCHAR2 NORPAC.ATL_LOV_BIRD_EVENT_OUTC 5 BIRD_EVENT_SEQ NUMBER 22 Yes No 9 0 Active Sequence generated unique identifier of a bird interaction event. NUMBER NORPAC.ATL_BIRD_EVENT 6 INTERACTION_SPECIES_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier for an species interaction record NUMBER NORPAC.ATL_BIRD_INTERAC_SPECIE 7 SPECIMEN_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier of a bird specimen. NUMBER NORPAC.ATL_BIRD_SPECIMEN 9641 ATL_BIRD_EVENT_OUTCOME_H Published / External Completed This entity represents the outcome of a bird interaction or a bird event, species interaction or of an indivdual animal (specimen) Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC 1 SEQ_NUMBER NUMBER 22 Yes Yes 9 0 Active NUMBER 2 EVENT_OUTCOME_SEQ NUMBER 22 No No 9 0 Active interaction behavior seq. NUMBER 3 CRUISE NUMBER 22 Yes No 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 4 PERMIT VARCHAR2 6 Yes No Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 5 OUTCOME_CODE VARCHAR2 10 No No Active Unique code identifying the condition of the bird after this interaction VARCHAR2 6 BIRD_EVENT_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier of a bird interaction event. NUMBER 7 INTERACTION_SPECIES_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier for an species interaction record NUMBER 8 SPECIMEN_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier of a bird specimen. NUMBER 9 CHANGED_BY VARCHAR2 30 No No Active Oracle user who made a change to the transaction table record. VARCHAR2 10 DATE_CHANGED DATE 7 No No Active Timestamp of change to transaction record. DATE 9642 ATL_BIRD_INTERACTION Published / External Completed This entity represents the intersection of an interaction type, its outcome to either the general interaction or to the individual animal. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity represents the intersection of an interaction type, its outcome to either the general interaction or to the individual animal. 1 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER Refers to more than one entity 2 PERMIT VARCHAR2 6 Yes Yes Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 Refers to more than one entity 3 EVENT_INTERACTION_SEQ NUMBER 22 Yes No 9 0 Active Sequence generated unique identifier of a bird event interaction. NUMBER 4 BIRD_EVENT_SEQ NUMBER 22 No No 9 0 Active Sequence generated nique identifier of a bird interaction event. NUMBER NORPAC.ATL_BIRD_EVENT 5 INTERACTION_SPECIES_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier for an species interaction record NUMBER NORPAC.ATL_BIRD_INTERAC_SPECIE 6 SPECIMEN_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier of a bird specimen. NUMBER NORPAC.ATL_BIRD_SPECIMEN 7 BIRD_INTERACT_CODE VARCHAR2 6 Yes No Active Unique code identifying a list of the currently valid avian interactions identified with gear, vessels, and offloads. VARCHAR2 NORPAC.ATL_LOV_BIRD_INTERACTIO 8 COMMENTS VARCHAR2 500 No No Active Discussion of the interaction type and it's outcome at the event or specimen level. VARCHAR2 9643 ATL_BIRD_INTERACTION_H Published / External Completed This entity represents the intersection of an interaction type, its outcome to either the general interaction or to the individual animal. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity represents the intersection of an interaction type, its outcome to either the general interaction or to the individual animal. 1 SEQ_NUMBER NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier for a history table. Every history table has a unique sequence assigned to it all start with 1, icrement by 1 and do not cycle. NUMBER 2 CRUISE NUMBER 22 Yes No 9 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 3 PERMIT VARCHAR2 6 Yes No Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 4 CHANGED_BY VARCHAR2 30 No No Active Oracle user who made a change to the transaction table record. VARCHAR2 5 DATE_CHANGED DATE 7 No No Active Timestamp of change to transaction record. DATE 6 EVENT_INTERACTION_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier of a bird event interaction. NUMBER 7 BIRD_EVENT_SEQ NUMBER 22 No No 9 0 Active Sequence generated nique identifier of a bird interaction event. NUMBER 8 INTERACTION_SPECIES_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier for an species interaction record NUMBER 9 SPECIMEN_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier of a bird specimen. NUMBER 10 BIRD_INTERACT_CODE VARCHAR2 6 No No Active Unique code identifying a list of the currently valid avian interactions identified with gear, vessels, and offloads. VARCHAR2 11 COMMENTS VARCHAR2 500 No No Active Discussion of the interaction type and it's outcome at the event or specimen level. VARCHAR2 9644 ATL_BIRD_INTERAC_DETERRENT Published / External Completed This entity resolves the intersection of a bird deterrent code and a bird interaction. Multiple deterrents are allowed none are mandatory. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity resolves the intersection of a bird deterrent code and a bird interaction. Multiple deterrents are allowed none are mandatory. 1 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER NORPAC.ATL_BIRD_EVENT 2 PERMIT VARCHAR2 6 Yes Yes Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 NORPAC.ATL_BIRD_EVENT 3 BIRD_EVENT_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated nique identifier of a bird interaction NUMBER NORPAC.ATL_BIRD_EVENT 4 ANIMAL_TYPE_CODE VARCHAR2 2 Yes Yes Active Class of animal mammal (M), bird (B) for which the deterrence was utilized. References ATL_LOV_Animal_TYPEClass of animal mammal (M), bird (B) for which the deterrence was utilized VARCHAR2 NORPAC.ATL_LOV_DETERRENCE 5 DETERRENCE_CODE VARCHAR2 2 Yes Yes Active Deterrence code from NORPAC bird or mammal deterance tables VARCHAR2 NORPAC.ATL_LOV_DETERRENCE 6 COMMENTS VARCHAR2 500 Yes No Active Problems with deployment of deterrent device or details of type of deterrent. VARCHAR2 9645 ATL_BIRD_INTERAC_DETERRENT_H Published / External Completed This entity resolves the intersection of a bird deterrent code and a bird interaction. Multiple deterrents are allowed none are mandatory. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity resolves the intersection of a bird deterrent code and a bird interaction. Multiple deterrents are allowed none are mandatory. 1 SEQ_NUMBER NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier for a history table. Every history table has a unique sequence assigned to it all start with 1, icrement by 1 and do not cycle. NUMBER 2 ANIMAL_TYPE_CODE VARCHAR2 2 No No Active Class of animal mammal (M), bird (B) for which the deterrence was utilized. References ATL_LOV_Animal_TYPEClass of animal mammal (M), bird (B) for which the deterrence was utilized VARCHAR2 3 CRUISE NUMBER 22 No No 9 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 4 DETERRENCE_CODE VARCHAR2 2 No No Active Deterrence code from NORPAC bird or mammal deterance tables VARCHAR2 5 PERMIT VARCHAR2 6 No No Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 6 CHANGED_BY VARCHAR2 30 No No Active Oracle user who made a change to the transaction table record. VARCHAR2 7 DATE_CHANGED DATE 7 No No Active Timestamp of change to transaction record. DATE 8 BIRD_EVENT_SEQ NUMBER 22 No No 9 0 Active Sequence generated nique identifier of a bird interaction NUMBER 9 COMMENTS VARCHAR2 500 No No Active Problems with deployment of deterrent device or details of type of deterrent. VARCHAR2 9646 ATL_BIRD_INTERAC_SPECIES Published / External Completed This entity represents the intersections of a bird interaction with one or more species which may be identified through mutually exclusive foreign keys with lov_species or species_composition. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity represents the intersections of a bird interaction with one or more species which may be identified through mutually exclusive foreign keys with lov_species or species_composition. 1 INTERACTION_SPECIES_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier for an species interaction record NUMBER 2 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER Refers to more than one entity 3 PERMIT VARCHAR2 6 Yes Yes Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 Refers to more than one entity 4 BIRD_EVENT_SEQ NUMBER 22 Yes No 9 0 Active Sequence generated unique identifier of a bird interaction event. NUMBER NORPAC.ATL_BIRD_EVENT 5 COUNT_TYPE_CODE VARCHAR2 10 Yes No Active Unique code describing how the number of animals field is determined. Except for a type of specific the grouping is an estimate and number is not required. VARCHAR2 NORPAC.ATL_LOV_BIRD_COUNT_TYPE 6 SPECIES_COMPOSITION_SEQ NUMBER 22 No No 9 0 Active Sequence Generated unique identifier of a species composition record NUMBER NORPAC.ATL_SPECIES_COMPOSITION 7 SPECIES_CODE NUMBER 22 No No 4 0 Active Unique identifier for a species imported from Norpac NUMBER NORPAC.ATL_LOV_SPECIES_CODE 8 NUMBER_OF_ANIMALS NUMBER 22 Yes No 3 0 Active Numbers of animals of this species NUMBER 9 GOOD_LOOK_CODE VARCHAR2 3 Yes No Active Code (Domain) which describes how the level of the observation of this bird. VARCHAR2 10 SPECIES_CONFIDENCE_CODE VARCHAR2 5 Yes No Active Code (Domain) identifying level of observer confidence in his-her species identification. VARCHAR2 11 SPECIES_VERIFICATION_FLAG VARCHAR2 1 Yes No Active Flag identifying whether or not the species identification is corroberated by external evidence, which would then be discussed in the comments section. VARCHAR2 12 COMMENTS VARCHAR2 500 No No Active Colors on head, eye erea, bill, legs, back, wings, bill size etc. VARCHAR2 9647 ATL_BIRD_INTERAC_SPECIES_H Published / External Completed This entity represents the intersections of a bird interaction with one or more species which may be identified through mutually exclusive foreign keys with lov_species or species_composition. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity represents the intersections of a bird interaction with one or more species which may be identified through mutually exclusive foreign keys with lov_species or species_composition. 1 SEQ_NUMBER NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier for a history table. Every history table has a unique sequence assigned to it all start with 1, icrement by 1 and do not cycle. NUMBER 2 CRUISE NUMBER 22 Yes No 9 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 3 PERMIT VARCHAR2 6 Yes No Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 4 CHANGED_BY VARCHAR2 30 No No Active Oracle user who made a change to the transaction table record. VARCHAR2 5 DATE_CHANGED DATE 7 No No Active Timestamp of change to transaction record. DATE 6 INTERACTION_SPECIES_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier for an species interaction record NUMBER 7 BIRD_EVENT_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier of a bird interaction event. NUMBER 8 COUNT_TYPE_CODE VARCHAR2 10 No No Active Unique code describing how the number of animals field is determined. Except for a type of specific the grouping is an estimate and number is not required. VARCHAR2 9 SPECIES_COMPOSITION_SEQ NUMBER 22 No No 9 0 Active Sequence Generated unique identifier of a species composition record NUMBER 10 SPECIES_CODE NUMBER 22 No No 4 0 Active Unique identifier for a species imported from Norpac NUMBER 11 NUMBER_OF_ANIMALS NUMBER 22 No No 3 0 Active Numbers of animals of this species NUMBER 12 GOOD_LOOK_CODE VARCHAR2 3 No No Active Code (Domain) which describes how the level of the observation of this bird. VARCHAR2 13 SPECIES_CONFIDENCE_CODE VARCHAR2 5 No No Active Code (Domain) identifying level of observer confidence in his-her species identification. VARCHAR2 14 SPECIES_VERIFICATION_FLAG VARCHAR2 1 No No Active Flag identifying whether or not the species identification is corroberated by external evidence, which would then be discussed in the comments section. VARCHAR2 15 COMMENTS VARCHAR2 500 No No Active Colors on head, eye erea, bill, legs, back, wings, bill size etc. VARCHAR2 9648 ATL_BIRD_SPECIES_TAG Published / External Completed This entity represents the tag or leg band(s) observed on an individual animal. It requires that a specimen record be created even if the band(s) are only noted and described. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity represents the tag or leg band(s) observed on an individual animal. It requires that a specimen record be created even if the band(s) are only noted and described. 1 TAG_SEQ NUMBER 22 Yes Yes 8 0 Active sequence generated unique identifier for this tag record. NUMBER 2 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER NORPAC.ATL_BIRD_SPECIMEN 3 PERMIT VARCHAR2 6 Yes Yes Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 NORPAC.ATL_BIRD_SPECIMEN 4 TYPE_CODE VARCHAR2 3 Yes No Active Unique code identifying the type of recovered tag. VARCHAR2 NORPAC.ATL_LOV_BIRD_TAG_TYPE 5 LOCATION_CODE VARCHAR2 10 Yes No Active Unique Code for the found location of a bird tag. For example rtleg; VARCHAR2 NORPAC.ATL_LOV_BIRD_TAG_LOCATI 6 COLOR_CODE VARCHAR2 5 Yes No Active Color Code VARCHAR2 NORPAC.ATL_LOV_BIRD_LEG_BAND_C 7 SPECIMEN_SEQ NUMBER 22 Yes No 9 0 Active Sequence generated unique identifier of a bird specimen. NUMBER NORPAC.ATL_BIRD_SPECIMEN 8 TAG_CODE VARCHAR2 3 No No Active Code (Domain) identifying presence, absence, applicability of banding. VARCHAR2 9 TAG_NUMBER VARCHAR2 20 No No Active If a tag is present and if read this field records the USFWS number or other number. VARCHAR2 9649 ATL_BIRD_SPECIES_TAG_H Published / External Completed This entity represents the tag or leg band(s) observed on an individual animal. It requires that a specimen record be created even if the band(s) are only noted and described. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity represents the tag or leg band(s) observed on an individual animal. It requires that a specimen record be created even if the band(s) are only noted and described. 1 SEQ_NUMBER NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier for a history table. Every history table has a unique sequence assigned to it all start with 1, icrement by 1 and do not cycle. NUMBER 2 CRUISE NUMBER 22 No No 9 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 3 PERMIT VARCHAR2 6 No No Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 4 CHANGED_BY VARCHAR2 30 No No Active Oracle user who made a change to the transaction table record. VARCHAR2 5 DATE_CHANGED DATE 7 No No Active Timestamp of change to transaction record. DATE 6 TAG_SEQ NUMBER 22 No No 8 0 Active sequence generated unique identifier for this tag record. NUMBER 7 TYPE_CODE VARCHAR2 3 No No Active Unique code identifying the type of recovered tag. VARCHAR2 8 LOCATION_CODE VARCHAR2 10 No No Active Unique Code for the found location of a bird tag. For example rtleg; VARCHAR2 9 COLOR_CODE VARCHAR2 5 No No Active Color Code VARCHAR2 10 SPECIMEN_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier of a bird specimen. NUMBER 11 TAG_CODE VARCHAR2 3 No No Active Code (Domain) identifying presence, absence, applicability of banding. VARCHAR2 12 TAG_NUMBER VARCHAR2 20 No No Active If a tag is present and if read this field records the USFWS number or other number. VARCHAR2 9650 ATL_BIRD_SPECIMEN Published / External Completed This entity represents the avian specimen which has been chosen for additional biota sampling, preservation, tag recording, or may be representative of a larger group of birds of the same species. A specimen need not be a fatality. It may be an animal that was captured for tag examination and released alive and unharmed. The key is it is a single animal. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity represents the avian specimen which has been chosen for additional biota sampling, preservation, tag recording, or may be representative of a larger group of birds of the same species. A specimen need not be a fatality. It may be an animal that was captured for tag examination and released alive and unharmed. The key is it is a single animal. 1 SPECIMEN_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a bird specimen. NUMBER 2 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER NORPAC.ATL_BIRD_INTERAC_SPECIE 3 PERMIT VARCHAR2 6 Yes Yes Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 NORPAC.ATL_BIRD_INTERAC_SPECIE 4 SPECIMEN_NUMBER VARCHAR2 10 Yes No Active User defined uniqe within a specime type identifier. May be a bar code tag. VARCHAR2 5 SPECIMEN_TYPE_CODE VARCHAR2 6 Yes No Active The list of unique type codes associated with a bird specimen. VARCHAR2 NORPAC.ATL_LOV_BIRD_SPECIMEN_T 6 INTERACTION_SPECIES_SEQ NUMBER 22 Yes No 9 0 Active Sequence generated unique identifier for an species interaction record NUMBER NORPAC.ATL_BIRD_INTERAC_SPECIE 7 COMMENTS VARCHAR2 500 No No Active Discussion of bird specimen. VARCHAR2 9651 ATL_BIRD_SPECIMEN_H Published / External Completed This entity represents the avian specimen which has been chosen for additional biota sampling, preservation, tag recording, or may be representative of a larger group of birds of the same species. A specimen need not be a fatality. It may be an animal that was captured for tag examination and released alive and unharmed. The key is it is a single animal. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity represents the avian specimen which has been chosen for additional biota sampling, preservation, tag recording, or may be representative of a larger group of birds of the same species. A specimen need not be a fatality. It may be an animal that was captured for tag examination and released alive and unharmed. The key is it is a single animal. 1 SEQ_NUMBER NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier for a history table. Every history table has a unique sequence assigned to it all start with 1, icrement by 1 and do not cycle. NUMBER 2 CRUISE NUMBER 22 No No 9 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 3 PERMIT VARCHAR2 6 No No Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 4 CHANGED_BY VARCHAR2 30 No No Active Oracle user who made a change to the transaction table record. VARCHAR2 5 DATE_CHANGED DATE 7 No No Active Timestamp of change to transaction record. DATE 6 SPECIMEN_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier of a bird specimen. NUMBER 7 SPECIMEN_NUMBER VARCHAR2 10 No No Active User defined uniqe within a specime type identifier. May be a bar code tag. VARCHAR2 8 SPECIMEN_TYPE_CODE VARCHAR2 6 No No Active The list of unique type codes associated with a bird specimen. VARCHAR2 9 INTERACTION_SPECIES_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier for an species interaction record NUMBER 10 COMMENTS VARCHAR2 500 No No Active Discussion of bird specimen. VARCHAR2 9652 ATL_BIRD_VESSEL_INTERACT Published / External Completed This entity resolves the intersection between the list of valid events (interactions) that may be observed with a vessel, and the bird event (interaction) record. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity resolves the intersection between the list of valid events (interactions) that may be observed with a vessel, and the bird event (interaction) record. 1 BIRD_EVENT_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a bird interaction event. NUMBER NORPAC.ATL_BIRD_EVENT 2 ACTIVITY_CODE VARCHAR2 5 Yes Yes Active Unique code for bird activity. VARCHAR2 NORPAC.ATL_LOV_BIRD_VESSEL_ACT 3 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER NORPAC.ATL_BIRD_EVENT 4 PERMIT VARCHAR2 6 Yes Yes Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 NORPAC.ATL_BIRD_EVENT 9653 ATL_BIRD_VESSEL_INTERACT_H Published / External Completed This entity resolves the intersection between the list of valid events (interactions) that may be observed with a vessel, and the bird event (interaction) record. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC 1 SEQ_NUMBER NUMBER 22 Yes Yes 9 0 Active NUMBER 2 CRUISE NUMBER 22 No No 9 0 Active NUMBER 3 PERMIT VARCHAR2 6 No No Active VARCHAR2 4 CHANGED_BY VARCHAR2 30 No No Active VARCHAR2 5 DATE_CHANGED DATE 7 No No Active DATE 6 BIRD_EVENT_SEQ NUMBER 22 No No 9 0 Active NUMBER 7 ACTIVITY_CODE VARCHAR2 5 No No Active VARCHAR2 9655 ATL_CRUISE_PLANT Published / External Completed Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC The intersection of an observer cruise and a processing plant. 1 CRUISE_PLANT_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique value for a cruise plant record. NUMBER 2 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER NORPAC.ATL_OBSERVER_CRUISE 3 PLANT_SEQ NUMBER 22 Yes No 9 0 Active Sequence generated unique identifier for a processing plant. NUMBER NORPAC.ATL_LOV_PLANT 4 STATUS NUMBER 22 Yes No 2 0 Active This attribute is the logical foreign key from the CV_Status table owned by Norpac. It represents the current processing phase that a record is in. NUMBER NORPAC.CV_STATUS 5 STATUS_DATE DATE 7 Yes No Active Timestamp of when processing status was assigned DATE 6 STATUS_USER VARCHAR2 30 Yes No Active User who was logged on when the cruise vessel (cruise plant) status was assigned VARCHAR2 7 COMMENTS VARCHAR2 2000 No No Active Optional Comments Field for a cruise_plant data set. This field is provided for use by the debriefing staff. They are not available to observers in the field for this release VARCHAR2 8 PERMIT VARCHAR2 6 Yes Yes Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 9656 ATL_CRUISE_PLANT_H Published / External Completed The intersection of an observer cruise and a processing plant. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC The intersection of an observer cruise and a processing plant. 1 SEQ_NUMBER NUMBER 22 Yes Yes 10 0 Active Sequence generated unique identifier for a history table. Every history table has a unique sequence assigned to it all start with 1, icrement by 1 and do not cycle. NUMBER 2 CHANGED_BY VARCHAR2 30 No No Active Oracle user who made a change to the transaction table record. VARCHAR2 3 DATE_CHANGED DATE 7 No No Active Timestamp of change to transaction record. DATE 4 CRUISE_PLANT_SEQ NUMBER 22 No No 22 0 Active Sequence generated unique value for a cruise plant record. NUMBER 5 CRUISE NUMBER 22 No No 22 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 6 PLANT_SEQ NUMBER 22 No No 22 0 Active Sequence generated unique identifier for a processing plant. NUMBER 7 STATUS NUMBER 22 No No 22 0 Active This attribute is the logical foreign key from the CV_Status table owned by Norpac. It represents the current processing phase that a record is in. NUMBER 8 STATUS_DATE DATE 7 No No Active Timestamp of when processing status was assigned DATE 9 STATUS_USER VARCHAR2 30 No No Active User who was logged on when the cruise vessel (cruise plant) status was assigned VARCHAR2 10 COMMENTS VARCHAR2 2000 No No Active Optional Comments Field for a cruise_plant data set. This field is provided for use by the debriefing staff. They are not available to observers in the field for this release VARCHAR2 11 PERMIT VARCHAR2 6 No No Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 9657 ATL_CRUISE_VESSEL Published / External Completed The intersection of an observer cruise and a vessel Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC The intersection of an observer cruise and a vessel 1 CRUISE_VESSEL_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier for a cruise vessel. NUMBER 2 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER NORPAC.ATL_OBSERVER_CRUISE 3 VESSEL_SEQ NUMBER 22 Yes No 9 0 Active Unique Code identifying a vessel - inherited from the NORPAC data set. Generated by logistics staff. NUMBER NORPAC.ATL_LOV_VESSEL 4 STATUS NUMBER 22 Yes No 2 0 Active This attribute is the logical foreign key from the CV_Status table owned by Norpac. It represents the current processing phase that a record is in. NUMBER NORPAC.CV_STATUS 5 STATUS_DATE DATE 7 Yes No Active Timestamp of when processing status was assigned DATE 6 STATUS_USER VARCHAR2 30 No No Active User who was logged on when the cruise vessel (cruise plant) status was assigned VARCHAR2 7 COMMENTS VARCHAR2 2000 No No Active Optional Comments Field for a cruise_vessel data set. This field is provided for use by the debriefing staff. They are not available to observers in the field for this release. VARCHAR2 8 PERMIT VARCHAR2 6 Yes Yes Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 9659 ATL_DO_NOT_LOAD_CRUISE Published / External Completed If an observer has more than one cruise in the same contract. Data from the field ought to be loaded for only the active cruise. This table provides the list of cruises for which data is currently static. The table is referenced by the atl_load_norpac.load_atl_tables procedure. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC If an observer has more than one cruise in the same contract. Data from the field ought to be loaded for only the active cruise. This table provides the list of cruises for which data is currently static. The table is referenced by the atl_load_norpac.load_atl_tables procedure. 1 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. In this table a listed cruise is held static to automated data loading. NUMBER 2 COMMENTS VARCHAR2 500 No No Active Optional discussion - particularly useful in the case loading data with known errors or when the data for a cruise is frozen for a reason other than multiple cruises in a contract. VARCHAR2 9660 ATL_ERROR Published / External Completed This entity represents the list of data and loading errors for the Atlas, Inseason, and Domestic Data sets. Errors are logged by a call to a custom utility which compiles and writes to the Error Log table. Oracle RAISE_APPLICATION_ERROR must not be used because it is not desirable to stop processing when creating a log. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity represents the list of data and loading errors for the Atlas, Inseason, and Domestic Data sets. Errors are logged by a call to a custom utility which compiles and writes to the Error Log table. Oracle RAISE_APPLICATION_ERROR must not be used because it is not desirable to stop processing when creating a log. 1 ERROR_NUMBER NUMBER 22 Yes Yes 5 0 Active Unique user defined error number between -20000 and -21000 NUMBER 2 ERROR_FORM_TYPE VARCHAR2 50 Yes No Active Error script run for every specific form type. This column groups errors according to the respective subsystem tested. For example: Trip errors relate to the Atlas Trip and related table data. VARCHAR2 3 ERROR_NAME VARCHAR2 50 Yes No Active Unique name of error VARCHAR2 4 ERROR_TEXT VARCHAR2 150 Yes No Active Text to be returned with error VARCHAR2 5 ERROR_DISCUSSION VARCHAR2 1000 No No Active Optional discussion of history, and remedies relating to this error. Including usage by table and program. It is anticipated that complilation of this metadata will generate an error handbook which will be available to inseason staff VARCHAR2 6 ERROR_LEVEL NUMBER 22 Yes No 2 0 Active Level of severity NUMBER 7 OLD_ERROR_NUMBER NUMBER 22 No No 4 0 Active NUMBER 9662 ATL_ERROR_LOG Published / External Completed This entity provides inseason managers with a record of of load and edit errors which require review and correction. This provides a permanent record of data transmission errors and timestamps their resolution. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity provides inseason managers with a record of of load and edit errors which require review and correction. This provides a permanent record of data transmission errors and timestamps their resolution. 1 ERROR_LOG_ID NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier for an error log entry NUMBER 2 ERROR_NUMBER NUMBER 22 Yes No 5 0 Active Unique user defined error number between -20000 and -21000 NUMBER NORPAC.ATL_ERROR 3 CRUISE NUMBER 22 Yes No 10 0 Active Cruise number from Atlas which generated error. NUMBER 4 YEAR NUMBER 22 Yes No 4 0 Active Year extracted from sysdate when error was recorded to facilitate reporting. NUMBER 5 TABLE_NAME VARCHAR2 32 No No Active Name of the table for which loading or editing error was recorded. VARCHAR2 6 PK1_COLUMN_NAME VARCHAR2 32 No No Active Name of the first primary key column. VARCHAR2 7 PK1_VALUE VARCHAR2 20 No No Active Atlas Norpac unique record identifier of record that generated the error. Usually this is numeric but it may be Alpha in the case of a compound primary key. VARCHAR2 8 PK2_COLUMN_NAME VARCHAR2 32 No No Active Name of the second primary key column. VARCHAR2 9 PK2_VALUE VARCHAR2 20 No No Active Atlas Norpac unique record identifier of record that generated the error. Usually this is numeric but it may be Alpha in the case of a compound primary key. VARCHAR2 10 LOADING_LEVEL VARCHAR2 3 No No Active This attribute identifies the loading process where the error occured ATL - atlas production tables, INS - Inseason ETL, DOM - Domestic ETL. VARCHAR2 11 RESOLVED_CODE VARCHAR2 1 Yes No Active Identifying code which indicates that the error was addressed Y, an overide was requested R, Defaults to N. VARCHAR2 12 RESOLVED_BY VARCHAR2 60 No No Active Inseason advisor who addressed and resolved the error. Mandatory when resolved flag set to Y. VARCHAR2 13 RESOLVED_DATE DATE 7 No No Active Timestamp when resolved flag was set to Y DATE 14 ADMIN_OVERRIDE_FLAG VARCHAR2 1 Yes No Active Error Scripts will not allow the loading of data to Inseason or Domestic Tables if errors (99, 50) are logged. If an administrator desires, unresolved errors may be ignored and records moved by setting this flag to Yes. VARCHAR2 15 COMMENTS VARCHAR2 500 No No Active Optional discussion - particularly useful in the case of management setting the admin_overide_flag to Yes and loading data with known errors. VARCHAR2 16 PERMIT VARCHAR2 6 No No Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 17 ACTIVE_FLAG VARCHAR2 1 Yes No Active When a new error is logged it defaults to active. Whe data is validated all the logged errors are set to inactive(N). If found again the flag is reset to active(Y) or if not present the error log record is added. VARCHAR2 9663 ATL_ERROR_LOG_H Published / External Completed This entity provides inseason managers with a record of of load and edit errors which require review and correction. This provides a permanent record of data transmission errors and timestamps their resolution. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC 1 SEQ_NUMBER NUMBER 22 Yes Yes 10 0 Active Sequence generated unique identifier for a history table. Every history table has a unique sequence assigned to it all start with 1, icrement by 1 and do not cycle. NUMBER 2 CHANGED_BY VARCHAR2 30 No No Active Oracle user who made a change to the transaction table record. VARCHAR2 3 DATE_CHANGED DATE 7 No No Active Timestamp of change to transaction record. DATE 4 CRUISE NUMBER 22 No No 22 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 5 ERROR_LOG_ID NUMBER 22 No No 22 0 Active Sequence generated unique identifier for an error log entry NUMBER 6 ERROR_NUMBER NUMBER 22 No No 22 0 Active NUMBER 7 YEAR NUMBER 22 No No 22 0 Active NUMBER 8 TABLE_NAME VARCHAR2 32 No No Active VARCHAR2 9 PK1_COLUMN_NAME VARCHAR2 32 No No Active VARCHAR2 10 PK1_VALUE VARCHAR2 20 No No Active VARCHAR2 11 PK2_COLUMN_NAME VARCHAR2 32 No No Active VARCHAR2 12 PK2_VALUE VARCHAR2 20 No No Active VARCHAR2 13 LOADING_LEVEL VARCHAR2 3 No No Active VARCHAR2 14 RESOLVED_CODE VARCHAR2 1 No No Active VARCHAR2 15 RESOLVED_BY VARCHAR2 60 No No Active VARCHAR2 16 RESOLVED_DATE DATE 7 No No Active DATE 17 ADMIN_OVERRIDE_FLAG VARCHAR2 1 No No Active VARCHAR2 18 COMMENTS VARCHAR2 500 No No Active VARCHAR2 19 PERMIT VARCHAR2 6 No No Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 20 ACTIVE_FLAG VARCHAR2 1 Yes No Active When a new error is logged it defaults to active. Whe data is validated all the logged errors are set to inactive(N). If found again the flag is reset to active(Y) or if not present the error log record is added. VARCHAR2 9665 ATL_EXTRAWL_SPECIES_COMP Published / External Completed This entity provides the repository for extrapolated trawl data. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity provides the repository for extrapolated trawl data. 1 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 2 EXTRAWL_SPCOMP_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence Generated unique identifier of a species composition record NUMBER 3 HAUL_SEQ NUMBER 22 Yes No 9 0 Active Sequence generated unique identifier for a haul record NUMBER 4 HAUL_NUMBER NUMBER 22 Yes No 6 0 Active Number which is entered by the observer identifying a unique haul within a trip. Since records are not physically deleted, trigger code preserves uniqueness by allowing only a single active record to exist (delete_marker IS NOT NULL). NUMBER 5 SPECIES_CODE NUMBER 22 Yes No 4 0 Active Unique identifier for a species imported from Norpac NUMBER NORPAC.ATL_LOV_SPECIES_CODE 6 EXTRAPOLATED_WEIGHT NUMBER 22 Yes No 11 2 Active Weight of each species in the sample in kg. Either the species number or the species weight may be null, but not both. NUMBER 7 EXTRAPOLATED_NUMBER NUMBER 22 No No 7 0 Active Number of individual animals in the sample. Either the species number or the species weight may be null, but not both. NUMBER 8 SEX_CODE VARCHAR2 1 No No Active Sex if so identified. VARCHAR2 9 PERMIT VARCHAR2 6 No No Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 9666 ATL_FISHING_TIME_LOST Published / External Completed Fishing time lost contains a record of the number of hours and reasons for periods where no fishing occured during a trip. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC Fishing time lost contains the number of hours and reasons for lost fishing time during a trip. 1 TRIP_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a trip NUMBER NORPAC.ATL_FMA_TRIP 2 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER NORPAC.ATL_FMA_TRIP 3 TIME_LOST_CODE VARCHAR2 10 Yes Yes Active Reason code for lost fishing time. VARCHAR2 NORPAC.ATL_LOV_TIME_LOST_REASO 4 HOURS NUMBER 22 Yes No 3 0 Active Number of hours lost rounded to the nearest hour. NUMBER 5 PERMIT VARCHAR2 6 Yes Yes Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 NORPAC.ATL_FMA_TRIP 9667 ATL_FISHING_TIME_LOST_H Published / External Completed Fishing time lost contains the number of hours and reasons for lost fishing time during a trip. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC Fishing time lost contains the number of hours and reasons for lost fishing time during a trip. 1 SEQ_NUMBER NUMBER 22 Yes Yes 10 0 Active Oracle user who made a change to the transaction table record. NUMBER 2 CHANGED_BY VARCHAR2 30 No No Active Oracle user who made a change to the transaction table record. VARCHAR2 3 DATE_CHANGED DATE 7 No No Active Timestamp of change to transaction record. DATE 4 CRUISE NUMBER 22 No No 22 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 5 TRIP_SEQ NUMBER 22 No No 22 0 Active Oracle user who made a change to the transaction table record. NUMBER 6 TIME_LOST_CODE VARCHAR2 10 No No Active Reason code for lost fishing time. VARCHAR2 7 HOURS NUMBER 22 No No 22 0 Active Number of hours lost rounded to the nearest hour. NUMBER 8 PERMIT VARCHAR2 6 No No Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 9668 ATL_FISH_INV_SPECIMEN Published / External Completed This entity represents the finfish or invertebrate specimen which has been chosen for additional biota sampling from the length sample of animals. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity represents the finfish or invertebrate specimen which has been chosen for additional biota sampling from the length sample of animals. 1 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER NORPAC.ATL_LENGTH 2 SPECIMEN_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a specimen record. NUMBER 3 SPECIES_CODE NUMBER 22 No No 4 0 Active Unique identifier for a species imported from Norpac, and the FK value from species_maturity. NUMBER NORPAC.ATL_LOV_SPECIES_MATURIT 4 MATURITY_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier of a maturity record. NUMBER NORPAC.ATL_LOV_SPECIES_MATURIT 5 LENGTH_SEQ NUMBER 22 Yes No 9 0 Active Sequence generated unique identifier for a length record NUMBER NORPAC.ATL_LENGTH 6 SPECIMEN_TYPE NUMBER 22 Yes No 38 Active Unique numeric value for a specimen type record. NUMBER NORPAC.ATL_LOV_SPECIMEN_TYPE 7 SPECIMEN_NUMBER VARCHAR2 10 Yes No Active A specimen number is unique within a length, user defined identifier. In the case of an otolith it is the bar coded sample identifier attached to the collection vial. VARCHAR2 8 WEIGHT NUMBER 22 No No 10 3 Active Weight in kg of the specimen. NUMBER 9 AGE NUMBER 22 No No 3 0 Active Age of the animal (Specimen) in years. Populated by Age and Growth Staff without system validation. NUMBER 10 SPECIAL_PROJECT_CODE VARCHAR2 3 No No Active Identifier of a special project record. Project to be a three character acronym unique to the project for a cruise. Populated by Debriefing Staff without System Validation. VARCHAR2 11 PERMIT VARCHAR2 6 Yes Yes Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 NORPAC.ATL_LENGTH 9669 ATL_FISH_INV_SPECIMEN_H Published / External Completed This entity represents the finfish or invertebrate specimen which has been chosen for additional biota sampling from the length sample of animals. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity represents the finfish or invertebrate specimen which has been chosen for additional biota sampling from the length sample of animals. BARCODE NUMBER No No Active Whenever a barcode is printed on a vial (otolith) or bag (tag and bag) this attribute contains the value. 1 SEQ_NUMBER NUMBER 22 Yes Yes 10 0 Active Oracle user who made a change to the transaction table record. NUMBER 2 CHANGED_BY VARCHAR2 30 No No Active Oracle user who made a change to the transaction table record. VARCHAR2 3 DATE_CHANGED DATE 7 No No Active Timestamp of change to transaction record. DATE 4 CRUISE NUMBER 22 No No 22 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 5 MATURITY_SEQ NUMBER 22 No No 22 0 Active Sequence generated unique identifier of a maturity record. NUMBER 6 SPECIES_CODE NUMBER 22 No No 4 0 Active Unique identifier for a species imported from Norpac, and the FK value from species_maturity. NUMBER 7 LENGTH_SEQ NUMBER 22 No No 22 0 Active Sequence generated unique identifier for a length record NUMBER 8 SPECIMEN_SEQ NUMBER 22 No No 22 0 Active Sequence generated unique identifier of a specimen record NUMBER 9 SPECIMEN_TYPE NUMBER 22 No No 22 0 Active Unique numeric value for a specimen type record. NUMBER 10 SPECIMEN_NUMBER VARCHAR2 10 No No Active A specimen number is unique for a cruise/permit combination (effective 01/01/2014). Duplicate specimen numbers indicate multiple specimen types collected for the same fish. In the case of an otolith (type 1 specimen) the barcode may or may not be the specimen number. The specimen number identifies the fish and the barcode is now an added attribute. Current protocol only requires specimen number to be unique for a cruise/permit, so some users are still using barcode as specimen number; however the 'best practice' is to start at '1' for a cruise and ascend from there for all specimen types and species. VARCHAR2 11 WEIGHT NUMBER 22 No No 22 0 Active Weight in kg of the specimen. Effective 01/01/2014, otoliths, scales, and stomachs no longer have a weight associated with the specimen record; instead a separate specimen (type 3) is entered for the same specimen number. NUMBER 12 AGE NUMBER 22 No No 3 0 Active Age of the animal (Specimen) in years. NUMBER 13 SPECIAL_PROJECT_CODE VARCHAR2 3 No No Active Identifier of a special project record. Project to be a three character acronym unique to the project for a cruise. VARCHAR2 14 PERMIT VARCHAR2 6 No No Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 9670 ATL_FISH_TICKET Published / External Completed This entity represents the preprinted state fish ticket preprared from an offload event. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity represents the fish ticket preprared from an offload event. 1 FISH_TICKET_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence within offload parent NUMBER 2 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER NORPAC.ATL_OFFLOAD 3 OFFLOAD_SEQ NUMBER 22 Yes No 9 0 Active Sequence generated unique identifier for an offload record NUMBER NORPAC.ATL_OFFLOAD 4 FISHTICKET_NUMBER VARCHAR2 30 Yes No Active A Fish Ticket Number is the Alphanumeric value generated by a processor and given to a vessel captain detailing the transaction and sale of seafood. VARCHAR2 5 PERMIT VARCHAR2 6 Yes Yes Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 NORPAC.ATL_OFFLOAD 9671 ATL_FISH_TICKET_H Published / External Completed This entity represents the preprinted state fish ticket preprared from an offload event. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity represents the preprinted state fish ticket preprared from an offload event. 1 SEQ_NUMBER NUMBER 22 Yes Yes 10 0 Active Oracle user who made a change to the transaction table record. NUMBER 2 CHANGED_BY VARCHAR2 30 No No Active Oracle user who made a change to the transaction table record. VARCHAR2 3 DATE_CHANGED DATE 7 No No Active Timestamp of change to transaction record. DATE 4 CRUISE NUMBER 22 No No 22 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 5 FISH_TICKET_SEQ NUMBER 22 No No 22 0 Active Sequence within offload parent NUMBER 6 FISHTICKET_NUMBER VARCHAR2 30 No No Active A Fish Ticket Number is the Alphanumeric value generated by a processor and given to a vessel captain detailing the transaction and sale of seafood. VARCHAR2 7 OFFLOAD_SEQ NUMBER 22 No No 22 0 Active Sequence generated unique identifier for an offload record NUMBER 8 PERMIT VARCHAR2 6 No No Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 9673 ATL_FMA_TRIP_H Published / External Completed A FMA trip is defined as the time between when a vessel casts off lines and ties up. There may be times where a vessel trip doesn't consist of any fishing. Even though no fishing took place a trip record still musy be created when a transit, offload or observer transfer takes place. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC A FMA trip is defined as the time between when a vessel casts off lines and ties up. There may be times where a vessel trip doesn't consist of any fishing. Even though no fishing took place a trip record still musy be created when a transit, offload or observer transfer takes place. CAPTAIN_NAME VARCHAR2 No No Active Name of the vessel captain for an observed trip. This data element will be recorded on the trip form or electronically beginning in 2013, and captured during debriefing in 2012. 1 SEQ_NUMBER NUMBER 22 Yes Yes 10 0 Active Oracle user who made a change to the transaction table record. NUMBER 2 CHANGED_BY VARCHAR2 30 No No Active Oracle user who made a change to the transaction table record. VARCHAR2 3 DATE_CHANGED DATE 7 No No Active Timestamp of change to transaction record. DATE 4 CRUISE NUMBER 22 No No 22 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 5 TRIP_SEQ NUMBER 22 No No 22 0 Active Sequence generated unique identifier of a trip within each observer instance of Atlas. NUMBER 6 CRUISE_VESSEL_SEQ NUMBER 22 No No 22 0 Active Sequence generated unique identifier for a cruise vessel. NUMBER 7 TRIP_NUMBER NUMBER 22 No No 22 0 Active Number which is entered by the observer which must be unique within a cruise - vessel combination. NUMBER 8 EMBARKED_PORT_CODE NUMBER 22 No No 22 0 Active User defined unique identifier of a port currently limited to 1 - 12. NUMBER 9 DISEMBARKED_PORT_CODE NUMBER 22 No No 22 0 Active User defined unique identifier of a port currently limited to 1 - 12. NUMBER 10 BAIT_USED_SEQ NUMBER 22 No No 22 0 Active Sequence generated unique identifier of a bait used record. NUMBER 11 START_DATE DATE 7 No No Active Date of embarkation. DATE 12 START_LATITUDE_DEGREE NUMBER 22 No No 22 0 Active Latitude of embarkation in degrees. NUMBER 13 START_LATITUDE_MIN NUMBER 22 No No 22 0 Active Latitude of embarkation in minutes. NUMBER 14 START_LATITUDE_SEC NUMBER 22 No No 22 0 Active Latitude of embarkation in seconds. NUMBER 15 START_LONGITUDE_DEGREE NUMBER 22 No No 22 0 Active Longitude of embarkation in degrees. NUMBER 16 START_LONGITUDE_MIN NUMBER 22 No No 22 0 Active Longitude of embarkation in minutes. NUMBER 17 START_LONGITUDE_SEC NUMBER 22 No No 22 0 Active Longitude of embarkation in seconds. NUMBER 18 START_EW VARCHAR2 1 No No Active East West longitude identifier for Embarkation. VARCHAR2 19 END_DATE DATE 7 No No Active Date of landing, tying up to a mothership, transfer of fish between codends or other interaction signifying the ending of a trip. DATE 20 END_LATITUDE_DEGREE NUMBER 22 No No 22 0 Active Latitude of disembarkation in degrees. NUMBER 21 END_LATITUDE_MIN NUMBER 22 No No 22 0 Active Latitude of disembarkation in minutes. NUMBER 22 END_LATITUDE_SEC NUMBER 22 No No 22 0 Active Latitude of disembarkation in seconds. NUMBER 23 END_LONGITUDE_DEGREE NUMBER 22 No No 22 0 Active Longitude of disembarkation in degrees. NUMBER 24 END_LONGITUDE_MIN NUMBER 22 No No 22 0 Active Longitude of disembarkation in minutes. NUMBER 25 END_LONGITUDE_SEC NUMBER 22 No No 22 0 Active Longitude of disembarkation in seconds. NUMBER 26 END_EW VARCHAR2 1 No No Active East West longitude identifier for Disembarkation. VARCHAR2 27 CREW_SIZE NUMBER 22 No No 22 0 Active Number of personnel on the vessel. NUMBER 28 DID_FISHING_OCCUR_FLAG VARCHAR2 1 No No Active Identifies whether fishing took place or not. VARCHAR2 29 FISH_IN_HOLD_AT_START_FLAG VARCHAR2 1 No No Active Identifies whether there were fish present in the hold at the start of a fishing trip. VARCHAR2 30 ATLAS_VERSION_NUMBER NUMBER 22 Yes No 3 1 Active Current Version of Atlas Program. This is stored in both Trip and Offload and inherited by the rest of the system. NUMBER 31 COMMENTS VARCHAR2 2000 No No Active Any specific comments an observer might make in regards to this trip. In particular comments are required to documented lost fishing time. VARCHAR2 32 PERMIT VARCHAR2 6 No No Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau. VARCHAR2 9675 ATL_HAUL Published / External Completed Hauls are unique fishing events of gear deployment and retrieval and may also contain information unique to a day where no fishing occured. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC Hauls are unique fishing events of gear deployment and retrieval and may also contain information unique to a day where no fishing occured. 1 CRUISE NUMBER 22 Yes Yes 9 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER NORPAC.ATL_FMA_TRIP 2 HAUL_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier for a haul record NUMBER 3 HAUL_NUMBER NUMBER 22 Yes No 6 0 Active Number which is entered by the observer identifying a unique haul within a trip. Since records are not physically deleted, trigger code preserves uniqueness by allowing only a single active record to exist (delete_marker IS NOT NULL). NUMBER 4 HAUL_PURPOSE_CODE VARCHAR2 3 Yes No Active Haul data may be utilized for catch accounting, stock assessment, or for various special projects. This field is entered by the observer and not validated by ATLAS. Validation is performed when loaded into the production NORPAC data set. VARCHAR2 NORPAC.ATL_LOV_HAUL_PURPOSE 5 CDQ_CODE VARCHAR2 3 No No Active Unique AlphaNumeric code representing a CDQ or research group VARCHAR2 NORPAC.ATL_LOV_CDQ 6 DELIVERY_VESSEL_ADFG VARCHAR2 6 No No Active ADFG number entered by the observer if the delivering vessel does not exist in the vessel lookup table. VARCHAR2 7 TRIP_SEQ NUMBER 22 Yes No 9 0 Active Sequence generated unique identifier of a trip NUMBER NORPAC.ATL_FMA_TRIP 8 VESSEL_TYPE NUMBER 22 Yes No 38 Active Unique identifier of a vessel type NUMBER NORPAC.ATL_LOV_VESSEL_TYPE 9 GEAR_PERFORMANCE_CODE NUMBER 22 Yes No 38 Active Unique performance code for a gear type. NUMBER NORPAC.ATL_LOV_GEAR_PERFORMANC 10 GEARTYPE_FORM VARCHAR2 1 Yes No Active Form that the gear is valid for. For example the gear may be Unknown for a delivery but will always be determined for a haul. VARCHAR2 NORPAC.ATL_LOV_GEAR_TYPE 11 GEAR_TYPE_CODE NUMBER 22 Yes No 38 Active Numeric value from Norpac Domestic Gear that combined with the Form defines the unique identifier for a gear record NUMBER NORPAC.ATL_LOV_GEAR_TYPE 12 RBT_CODE VARCHAR2 1 No No Active Random Break Table identifier Currently limted to Y (es) or N(o) VARCHAR2 NORPAC.ATL_LOV_RBT_CODE 13 RST_CODE VARCHAR2 1 No No Active Random Sample Reference Table code reference. VARCHAR2 NORPAC.ATL_LOV_RST_CODE 14 DETERRENCE_CODE VARCHAR2 2 No No Active Deterrence code from NORPAC bird or mammal deterance tables VARCHAR2 NORPAC.ATL_LOV_DETERRENCE 15 ANIMAL_TYPE_CODE VARCHAR2 1 No No Active Optional FK from LOV_Deterrence. Class of animal mammal (M), bird (B) for which the deterrence (if it exists) was utilized VARCHAR2 NORPAC.ATL_LOV_DETERRENCE 16 LOCATION_CODE VARCHAR2 1 Yes No Active Identifies whether the information in a haul is based on retrieval or delivery (as in a mother ship) VARCHAR2 17 RETRV_DATE_TIME DATE 7 Yes No Active Date recorded by the observer from the vessel log. DATE 18 RETRV_LATITUDE_DEGREES NUMBER 22 Yes No 2 0 Active Location of gear retrieval. NUMBER 19 RETRV_LATITUDE_MINUTES NUMBER 22 Yes No 2 0 Active Location of gear retrieval. NUMBER 20 RETRV_LATITUDE_SECONDS NUMBER 22 No No 2 0 Active Location of gear retrieval. NUMBER 21 RETRV_EW VARCHAR2 1 Yes No Active Location of gear retrieval. VARCHAR2 22 RETRV_LONGITUDE_DEGREES NUMBER 22 Yes No 3 0 Active Location of gear retrieval. NUMBER 23 RETRV_LONGITUDE_MINUTES NUMBER 22 Yes No 2 0 Active Location of gear retrieval. NUMBER 24 RETRV_LONGITUDE_SECONDS NUMBER 22 No No 2 0 Active Location of gear retrieval. NUMBER 25 NMFS_AREA NUMBER 22 No No 3 0 Active This is a calculated value from retrieval lat-long. It is stored for the convenience of the user community. NUMBER 26 DEPLOY_DATE_TIME DATE 7 No No Active Date and time recorded by the observer from the vessel log. DATE 27 DEPLOY_LATITUDE_DEGREES NUMBER 22 No No 2 0 Active Location of gear deployment. NUMBER 28 DEPLOY_LATITUDE_MINUTES NUMBER 22 No No 2 0 Active Location of gear deployment. NUMBER 29 DEPLOY_LATITUDE_SECONDS NUMBER 22 No No 2 0 Active Location of gear deployment. NUMBER 30 DEPLOY_EW VARCHAR2 1 No No Active Location of gear deployment. VARCHAR2 31 DEPLOY_LONGITUDE_DEGREES NUMBER 22 No No 3 0 Active Location of gear deployment. NUMBER 32 DEPLOY_LONGITUDE_MINUTES NUMBER 22 No No 2 0 Active Location of gear deployment. NUMBER 33 DEPLOY_LONGITUDE_SECONDS NUMBER 22 No No 2 0 Active Location of gear deployment. NUMBER 34 BOTTOM_DEPTH NUMBER 22 No No 5 0 Active Average bottom depth recorded by the observer from the vessel log. NUMBER 35 FISHING_DEPTH NUMBER 22 No No 5 0 Active Average fishing depth recorded by the observer from the vessel log. NUMBER 36 DEPTH_METER_FATHOM VARCHAR2 1 No No Active Identifies whether depth is recorded in meters or fathoms. VARCHAR2 37 VESSEL_EST_CATCH NUMBER 22 No No 6 2 Active Total catch weight in metric tons as recorded in the vessel log. NUMBER 38 OBSVR_EST_CATCH NUMBER 22 No No 6 2 Active Total catch weight as estimated by the observer in metric tons. NUMBER 39 OBSVR_EST_METHOD VARCHAR2 1 No No Active Method used to determine the observer estimated catch VARCHAR2 40 OBSVR_EST_DISCARDS NUMBER 22 No No 6 2 Active Observer estimate of total discards NUMBER 41 DENSITY NUMBER 22 No No 3 2 Active Density used by the observer to determine the total catch weights. NUMBER 42 INDIV_FISHING_QUOTA_FLAG VARCHAR2 1 Yes No Active Identifies whether fishing is on an IFQ quota with the subsequent application of IFQ rules. VARCHAR2 43 SAMPLED_BY NUMBER 22 Yes No 8 0 Active Identifies where a haul is sampled by an observer and in some cases by which observer. The observer of a haul is not necessarily the primary observer recorded for a cruise. NUMBER 44 NUMBER_OF_SKATES NUMBER 22 No No 4 0 Active Number of skates for longline fishing. NUMBER 45 NUMBER_OF_HOOKS_PER_SKATE NUMBER 22 No No 4 0 Active Number of hooks per skate for longline fishing. NUMBER 46 TOTAL_HOOKS NUMBER 22 No No 6 0 Active Total number of hooks deployed for this haul NUMBER 47 TOTAL_POTS NUMBER 22 No No 6 0 Active Total number of pots deployed for this haul. NUMBER 48 MMAMMAL_MONITR_PCT NUMBER 22 No No 3 0 Active Percentage of time for this haul where marine mammal monitoring occured. For fixed gear deployments the valid values are anywhere in the range. For mobile gear deployments the values may be either 0 or 100. NUMBER 49 PERMIT VARCHAR2 6 Yes Yes Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 NORPAC.ATL_FMA_TRIP 50 VOLUME NUMBER 22 No No 6 2 Active Estimate of volume of catch NUMBER 51 TOTAL_HOOKS_OVERIDE_FLAG VARCHAR2 1 No No Active If an observer believes that the calculated value of total hooks is not correct. It is allowed that the value is overridden. If that is the case then this flag will be set to Y by trigger code, and total-hooks will be protected from automatic recalculateion. VARCHAR2 52 BIRD_MONITOR_LEVEL_CODE VARCHAR2 4 No No Active Portion of the haulback that was monitored by the observer for bird interactions. VARCHAR2 53 SHORTWIRED_FLAG VARCHAR2 1 Yes No Active Denoting whether the net was shortwired during the haulback. Do not record a Y when the net is shortwired during the tow but then returned to fishing depth. VARCHAR2 54 SAMPLE_UNIT_CODE VARCHAR2 6 No No Active Unique code identifying the unit of measure for a sampling design. Sample Design and units are mandatory at the haul level and optional at the sample level. VARCHAR2 NORPAC.ATL_LOV_SAMPLE_UNIT 55 SAMPLE_SYSTEM_CODE NUMBER 22 No No 38 Active Unique numeric identifier of a sample coding system. NUMBER NORPAC.ATL_LOV_SAMPLE_SYSTEM_C 9676 ATL_HAUL_H Published / External Completed Hauls are unique fishing events of gear deployment and retrieval and may also contain information unique to a day where no fishing occured. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC Hauls are unique fishing events of gear deployment and retrieval and may also contain information unique to a day where no fishing occurred. 1 SEQ_NUMBER NUMBER 22 Yes Yes 10 0 Active Sequence generated unique identifier for a history table. Every history table has a unique sequence assigned to it all start with 1, icrement by 1 and do not cycle. NUMBER 2 CHANGED_BY VARCHAR2 30 No No Active Oracle user who made a change to the transaction table record. VARCHAR2 3 DATE_CHANGED DATE 7 No No Active Timestamp of change to transaction record. DATE 4 CRUISE NUMBER 22 No No 22 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 5 HAUL_SEQ NUMBER 22 No No 22 0 Active Sequence generated unique identifier for a haul record. NUMBER 6 HAUL_NUMBER NUMBER 22 No No 22 0 Active Number which is entered by the observer identifying a unique haul within a trip. Since records are not physically deleted, trigger code preserves uniqueness by allowing only a single active record to exist (delete_marker IS NOT NULL). NUMBER 7 HAUL_PURPOSE_CODE VARCHAR2 3 Yes No Active Haul data may be utilized for catch accounting, stock assessment, or for various special projects. This field is entered by the observer and not validated by ATLAS. Validation is performed when loaded into the production NORPAC data set. VARCHAR2 8 CDQ_CODE VARCHAR2 3 No No Active Unique AlphaNumeric code representing a CDQ or research group VARCHAR2 9 TRIP_SEQ NUMBER 22 No No 22 0 Active Sequence generated unique identifier of a trip. NUMBER 10 DELIVERY_VESSEL_ADFG VARCHAR2 6 No No Active ADFG number entered by the observer if the delivering vessel does not exist in the vessel lookup table. VARCHAR2 11 VESSEL_TYPE NUMBER 22 No No 22 0 Active Unique identifier of a vessel type. NUMBER 12 GEAR_PERFORMANCE_CODE NUMBER 22 No No 22 0 Active Unique performance code for a gear type. NUMBER 13 GEARTYPE_FORM VARCHAR2 1 No No Active Form that the gear is valid for. For example the gear may be Unknown for a delivery but will always be determined for a haul. VARCHAR2 14 GEAR_TYPE_CODE NUMBER 22 No No 22 0 Active Numeric value from Norpac Domestic Gear that combined with the Form defines the unique identifier for a gear record NUMBER 15 RBT_CODE VARCHAR2 1 No No Active Random Break Table identifier Currently limted to Y (es) or N(o) VARCHAR2 16 RST_CODE VARCHAR2 1 No No Active Random Sample Reference Table code reference. VARCHAR2 17 DETERRENCE_CODE VARCHAR2 2 No No Active Deterrence code from NORPAC bird or mammal deterance tables. VARCHAR2 18 ANIMAL_TYPE_CODE VARCHAR2 1 No No Active Optional FK from LOV_Deterrence. Class of animal mammal (M), bird (B) for which the deterrence (if it exists) was utilized. VARCHAR2 19 LOCATION_CODE VARCHAR2 1 No No Active Identifies whether the information in a haul is based on retrieval or delivery (as in a mother ship). VARCHAR2 20 RETRV_DATE_TIME DATE 7 No No Active Date recorded by the observer from the vessel log. DATE 21 RETRV_EW VARCHAR2 1 No No Active Location of gear retrieval. VARCHAR2 22 RETRV_LATITUDE_DEGREES NUMBER 22 No No 22 0 Active Location of gear retrieval. NUMBER 23 RETRV_LATITUDE_MINUTES NUMBER 22 No No 22 0 Active Location of gear retrieval. NUMBER 24 RETRV_LATITUDE_SECONDS NUMBER 22 No No 22 0 Active Location of gear retrieval. NUMBER 25 RETRV_LONGITUDE_DEGREES NUMBER 22 No No 22 0 Active Location of gear retrieval. NUMBER 26 RETRV_LONGITUDE_MINUTES NUMBER 22 No No 22 0 Active Location of gear retrieval. NUMBER 27 RETRV_LONGITUDE_SECONDS NUMBER 22 No No 22 0 Active Location of gear retrieval. NUMBER 28 NMFS_AREA NUMBER 22 No No 22 0 Active This is a calculated value from retrieval lat-long. It is stored for the convenience of the user community. NUMBER 29 DEPLOY_DATE_TIME DATE 7 No No Active Date and time recorded by the observer from the vessel log. Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water. DATE 30 DEPLOY_EW VARCHAR2 1 No No Active Location of gear deployment.Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water. VARCHAR2 31 DEPLOY_LATITUDE_DEGREES NUMBER 22 No No 22 0 Active Location of gear deployment. Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water. NUMBER 32 DEPLOY_LATITUDE_MINUTES NUMBER 22 No No 22 0 Active Location of gear deployment. Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water. NUMBER 33 DEPLOY_LATITUDE_SECONDS NUMBER 22 No No 22 0 Active Location of gear deployment. Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water. NUMBER 34 DEPLOY_LONGITUDE_DEGREES NUMBER 22 No No 22 0 Active Location of gear deployment. Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water. NUMBER 35 DEPLOY_LONGITUDE_MINUTES NUMBER 22 No No 22 0 Active Location of gear deployment. Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water. NUMBER 36 DEPLOY_LONGITUDE_SECONDS NUMBER 22 No No 22 0 Active Location of gear deployment. Gear deployment for trawls was defined as, prior to 2012, the time that the net reached fishing depth; for 2012 and later, the time of the beginning of the set, i.e. the time that the net first entered the water. NUMBER 37 BOTTOM_DEPTH NUMBER 22 No No 5 0 Active Average bottom depth recorded by the observer from the vessel log. NUMBER 38 FISHING_DEPTH NUMBER 22 No No 5 0 Active Average fishing depth recorded by the observer from the vessel log. NUMBER 39 DEPTH_METER_FATHOM VARCHAR2 1 No No Active Identifies whether depth is recorded in meters or fathoms. VARCHAR2 40 VESSEL_EST_CATCH NUMBER 22 No No 6 2 Active Total catch weight in metric tons as recorded in the vessel log. NUMBER 41 OBSVR_EST_CATCH NUMBER 22 No No 6 2 Active Total catch weight as estimated by the observer in kgs. NUMBER 42 OBSVR_EST_DISCARDS NUMBER 22 No No 6 2 Active Observer estimate of total discards in kgs. NUMBER 43 OBSVR_EST_METHOD VARCHAR2 1 No No Active Method used to determine the observer estimated catch. VARCHAR2 44 DENSITY NUMBER 22 No No 3 2 Active Density used by the observer to determine the total catch weights. Recorded in kgs per m3. NUMBER 45 INDIV_FISHING_QUOTA_FLAG VARCHAR2 1 No No Active Identifies whether fishing is on an IFQ quota with the subsequent application of IFQ rules. VARCHAR2 46 SAMPLED_BY NUMBER 22 No No 8 0 Active Identifies where a haul is sampled by an observer and in some cases by which observer. The observer of a haul is not necessarily the primary observer recorded for a cruise. NUMBER 47 NUMBER_OF_SKATES NUMBER 22 No No 4 0 Active Number of skates for longline fishing. NUMBER 48 NUMBER_OF_HOOKS_PER_SKATE NUMBER 22 No No 4 0 Active Number of hooks per skate for longline fishing. NUMBER 49 TOTAL_HOOKS NUMBER 22 No No 6 0 Active Total number of hooks deployed for this haul NUMBER 50 TOTAL_POTS NUMBER 22 No No 5 0 Active Total number of pots deployed for this haul. NUMBER 51 MMAMMAL_MONITR_PCT NUMBER 22 No No 3 0 Active Percentage of time for this haul where marine mammal monitoring occured. For fixed gear deployments the valid values are anywhere in the range. For mobile gear deployments the values may be either 0 or 100. NUMBER 52 PERMIT VARCHAR2 6 No No Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 53 VOLUME NUMBER 22 No No 6 2 Active Estimate of volume of catch NUMBER 54 TOTAL_HOOKS_OVERIDE_FLAG VARCHAR2 1 No No Active If an observer believes that the calculated value of total hooks is not correct. It is allowed that the value is overridden. If that is the case then this flag will be set to Y by trigger code, and total-hooks will be protected from automatic recalculation. VARCHAR2 55 BIRD_MONITOR_LEVEL_CODE VARCHAR2 4 No No Active Portion of the haulback that was monitored by the observer for bird interactions. VARCHAR2 56 SHORTWIRED_FLAG VARCHAR2 1 Yes No Active Denoting whether the net was shortwired during the haulback. Do not record a Y when the net is shortwired during the tow but then returned to fishing depth. VARCHAR2 57 SAMPLE_UNIT_CODE VARCHAR2 6 No No Active Unique code identifying the unit of measure for a sampling design. Sample Design and units are mandatory at the haul level and optional at the sample level. VARCHAR2 58 SAMPLE_SYSTEM_CODE NUMBER 22 No No 38 Active Unique numeric identifier of a sample coding system. NUMBER 9677 ATL_HAUL_HOOK_COUNT Published / External Completed This entity represents the observer matching of hauls by haul number to hook count sets by set number. That value is used to compute and populate the haul total hooks, and sample sample hooks-pots. Both total hooks and sample hooks may be overwritten by the observer, however as a general rule will be computed by the average hooks per segment computed for a hook count set * number of segments in the haul or number of segments sampled in the sample. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity represents the observer matching of hauls by haul number to hook count sets by set number. That value is used to compute and populate the haul total hooks, and sample sample hooks-pots. Both total hooks and sample hooks may be overwritten by the observer, however as a general rule will be computed by the average hooks per segment computed for a hook count set * number of segments in the haul or number of segments sampled in the sample. 1 HAUL_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier for a haul record NUMBER NORPAC.ATL_HAUL 2 SET_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a hook spacing set. NUMBER NORPAC.ATL_HOOK_COUNT_SET 3 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER Refers to more than one entity 4 PERMIT VARCHAR2 6 Yes Yes Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 Refers to more than one entity 5 HAUL_NUMBER NUMBER 22 Yes No 38 Active Unique haul for an observer vessel cruise, defaulted to an incremented sequence by the GUI. May be entered and defined by the observer. NUMBER 6 COLLECTION_NUMBER NUMBER 22 Yes No 3 0 Active User Defined Hook Count Sent number unique for a cruise permit. NUMBER 9678 ATL_HAUL_HOOK_COUNT_H Published / External Completed This entity represents the observer matching of hauls by haul number to hook count sets by set number. That value is used to compute and populate the haul total hooks, and sample sample hooks-pots. Both total hooks and sample hooks may be overwritten by the observer, however as a general rule will be computed by the average hooks per segment computed for a hook count set * number of segments in the haul or number of segments sampled in the sample. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity represents the observer matching of hauls by haul number to hook count sets by set number. That value is used to compute and populate the haul total hooks, and sample sample hooks-pots. Both total hooks and sample hooks may be overwritten by the observer, however as a general rule will be computed by the average hooks per segment computed for a hook count set * number of segments in the haul or number of segments sampled in the sample. 1 SEQ_NUMBER NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier for a history table. Every history table has a unique sequence assigned to it all start with 1, icrement by 1 and do not cycle. NUMBER 2 CRUISE NUMBER 22 Yes No 9 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 3 PERMIT VARCHAR2 6 Yes No Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 4 CHANGED_BY VARCHAR2 30 No No Active Oracle user who made a change to the transaction table record. VARCHAR2 5 DATE_CHANGED DATE 7 No No Active Timestamp of change to transaction record. DATE 6 HAUL_SEQ NUMBER 22 Yes No 9 0 Active Sequence generated unique identifier for a haul record NUMBER 7 SET_SEQ NUMBER 22 Yes No 9 0 Active Sequence generated unique identifier of a hook spacing set. NUMBER 8 HAUL_NUMBER NUMBER 22 Yes No 38 Active Unique haul for an observer vessel cruise, defaulted to an incremented sequence by the GUI. May be entered and defined by the observer. NUMBER 9 COLLECTION_NUMBER NUMBER 22 Yes No 3 0 Active User Defined Hook Count Sent number unique for a cruise permit. NUMBER 9679 ATL_HOOKS_PER_SEGMENT Published / External Completed Stock assessment authors for sablefish (and potentially for P.cod) use catch-per-unit-effort information in their models. A key component of this is the spacing of the hooks on the gear. Every year, we issue a special project where the observers measure the spacing of the hooks on a few segments of gear. That special project has been absorbed into the standard data set for 2010. This entity represent the hook count and hook spacing measurements for a segment of gear. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC Stock assessment authors for sablefish (and potentially for P.cod) use catch-per-unit-effort information in their models. A key component of this is the spacing of the hooks on the gear. Every year, we issue a special project where the observers measure the spacing of the hooks on a few segments of gear. That special project has been absorbed into the standard data set for 2010. This entity represent the hook count and hook spacing measurements for a segment of gear. 1 HOOKS_PER_SEGMENT_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a hook count and measure for a segment of longline gear. NUMBER 2 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER NORPAC.ATL_HOOK_COUNT_SET 3 PERMIT VARCHAR2 6 Yes Yes Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 NORPAC.ATL_HOOK_COUNT_SET 4 SET_SEQ NUMBER 22 Yes No 9 0 Active Sequence generated unique identifier of a hook spacing set. NUMBER NORPAC.ATL_HOOK_COUNT_SET 5 SEGMENT_NUMBER NUMBER 22 No No 3 0 Active This attribute represents a user defined integer identifying a unit of line for counting and spacing hooks. It must be unique within a hook_count_set. NUMBER 6 NUMBER_OF_HOOKS NUMBER 22 Yes No 8 0 Active Number of hooks as determined by the observer for this segment, contained within a counted set. NUMBER 7 HOOK_SPACING_IN_CM NUMBER 22 No No 4 0 Active Spacing between hooks on a segment. This value is optional for any specific segment except the first set of spacing-count on a trip NUMBER 9680 ATL_HOOKS_PER_SEGMENT_H Published / External Completed Stock assessment authors for sablefish (and potentially for P.cod) use catch-per-unit-effort information in their models. A key component of this is the spacing of the hooks on the gear. Every year, we issue a special project where the observers measure the spacing of the hooks on a few segments of gear. That special project has been absorbed into the standard data set for 2010. This entity represent the hook count and hook spacing measurements for a segment of gear. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC Stock assessment authors for sablefish (and potentially for P.cod) use catch-per-unit-effort information in their models. A key component of this is the spacing of the hooks on the gear. Every year, we issue a special project where the observers measure the spacing of the hooks on a few segments of gear. That special project has been absorbed into the standard data set for 2010. This entity represent the hook count and hook spacing measurements for a segment of gear. 1 SEQ_NUMBER NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier for a history table. Every history table has a unique sequence assigned to it all start with 1, icrement by 1 and do not cycle. NUMBER 2 CRUISE NUMBER 22 Yes No 9 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 3 PERMIT VARCHAR2 6 Yes No Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 4 CHANGED_BY VARCHAR2 30 No No Active Oracle user who made a change to the transaction table record. VARCHAR2 5 DATE_CHANGED DATE 7 No No Active Timestamp of change to transaction record. DATE 6 HOOKS_PER_SEGMENT_SEQ NUMBER 22 Yes No 9 0 Active Sequence generated unique identifier of a hook count and measure for a segment of longline gear. NUMBER 7 SET_SEQ NUMBER 22 Yes No 9 0 Active Sequence generated unique identifier of a hook spacing set. NUMBER 8 SEGMENT_NUMBER NUMBER 22 No No 3 0 Active This attribute represents a user defined integer identifying a unit of line for counting and spacing hooks. It must be unique within a hook_count_set. NUMBER 9 NUMBER_OF_HOOKS NUMBER 22 Yes No 8 0 Active Number of hooks per segment NUMBER 10 HOOK_SPACING_IN_CM NUMBER 22 No No 4 0 Active Spacing between hooks on a segment. This value is optional for any specific segment except the first set of spacing-count on a trip NUMBER 9681 ATL_HOOK_COUNT_SET Published / External Completed Twice a week an observer is required to measure hook spacing and total hooks for twenty percent of the segments (skates/racks) of a typical haul. These measurements may be taken all at once or over a period of time and accumulated into a set. This entity represents that collection of hook and spacing data. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC Twice a week an observer is required to measure hook spacing and total hooks for twenty percent of the segments (skates/racks) of a typical haul. These measurements may be taken all at once or over a period of time and accumulated into a set. This entity represents that collection of hook and spacing data. 1 SET_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a hook spacing set. NUMBER 2 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER NORPAC.ATL_CRUISE_VESSEL 3 PERMIT VARCHAR2 6 Yes Yes Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 NORPAC.ATL_CRUISE_VESSEL 4 COLLECTION_NUMBER NUMBER 22 Yes No 3 0 Active User Defined Hook Count Sent number unique for a cruise permit. NUMBER 5 CRUISE_VESSEL_SEQ NUMBER 22 Yes No 9 0 Active Sequence generated unique identifier for a cruise vessel. NUMBER NORPAC.ATL_CRUISE_VESSEL 6 COLLECTION_DATE DATE 7 Yes No Active Date and Time count taken. DATE 9682 ATL_HOOK_COUNT_SET_H Published / External Completed Twice a week an observer is required to measure hook spacing and total hooks for twenty percent of the segments (skates/racks) of a typical haul. These measurements may be taken all at once or over a period of time and accumulated into a set. This entity represents that collection of hook and spacing data. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC Twice a week an observer is required to measure hook spacing and total hooks for twenty percent of the segments (skates/racks) of a typical haul. These measurements may be taken all at once or over a period of time and accumulated into a set. This entity represents that collection of hook and spacing data. 1 SEQ_NUMBER NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier for a history table. Every history table has a unique sequence assigned to it all start with 1, icrement by 1 and do not cycle. NUMBER 2 CRUISE NUMBER 22 Yes No 9 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 3 PERMIT VARCHAR2 6 Yes No Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 4 CHANGED_BY VARCHAR2 30 No No Active Oracle user who made a change to the transaction table record. VARCHAR2 5 DATE_CHANGED DATE 7 No No Active Timestamp of change to transaction record. DATE 6 SET_SEQ NUMBER 22 Yes No 9 0 Active Sequence generated unique identifier of a hook spacing set. NUMBER 7 COLLECTION_NUMBER NUMBER 22 Yes No 3 0 Active User Defined Hook Count Sent number unique for a cruise permit. NUMBER 8 CRUISE_VESSEL_SEQ NUMBER 22 Yes No 9 0 Active Sequence generated unique identifier for a cruise vessel. NUMBER 9 COLLECTION_DATE DATE 7 Yes No Active Date and Time count taken. DATE 9684 ATL_LENGTH_H Published / External Completed This entity is mapped to the Norpac length tables. It contains header information about sampled animals grouped by measured length to one cm. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity is mapped to the Norpac length tables. It contains header information about sampled animals grouped by measured length to one cm. 1 SEQ_NUMBER NUMBER 22 Yes Yes 10 0 Active Sequence generated unique identifier for a history table. Every history table has a unique sequence assigned to it all start with 1, increment by 1 and do not cycle. NUMBER 2 CHANGED_BY VARCHAR2 30 No No Active Oracle user who made a change to the transaction table record. VARCHAR2 3 DATE_CHANGED DATE 7 No No Active Timestamp of change to transaction record. DATE 4 CRUISE NUMBER 22 No No 22 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 5 LENGTH_SEQ NUMBER 22 No No 22 0 Active Sequence generated unique identifier for a length record. NUMBER 6 CONDITION_CODE NUMBER 22 No No 22 0 Active Numeric code identifying the injury. NUMBER 7 ANIMAL_TYPE_CODE VARCHAR2 2 No No Active Refers the the class of animal for example M - mammal H-halibut. Enforced by the Domain Animal Type. VARCHAR2 8 SAMPLE_SYSTEM_CODE NUMBER 22 No No 22 0 Active Unique numeric identifier of a sample coding system. NUMBER 9 SPECIES_CODE NUMBER 22 No No 22 0 Active In the case of a length record which is not a child of species composition. This is the species identifier attribute. NUMBER 10 SPECIES_COMPOSITION_SEQ NUMBER 22 No No 22 0 Active Sequence Generated unique identifier of a species composition record. NUMBER 11 HAUL_SEQ NUMBER 22 No No 22 0 Active Sequence generated unique identifier for a haul record. NUMBER 12 OFFLOAD_SEQ NUMBER 22 No No 22 0 Active Sequence generated unique identifier for an offload record. NUMBER 13 SEX_CODE VARCHAR2 1 No No Active The sex of this animal. VARCHAR2 14 LENGTH_SIZE NUMBER 22 No No 22 0 Active The length of this record in cm. If there are more than one animal of this length - of this sex - in this sample then the frequency field will reflect this and be greater than one.The length of this animal. NUMBER 15 FREQUENCY NUMBER 22 No No 22 0 Active The total number of animals within this size group - with a precision of one cm. NUMBER 16 EGGS_IND VARCHAR2 1 No No Active Identifies the presence or absence of egg for crabs. VARCHAR2 17 VIABILITY VARCHAR2 1 No No Active Identifies the viability status for halibut valid values are Excellent, Poor, Dead, Unknown. VARCHAR2 18 SPECIAL_PROJECT_CODE VARCHAR2 3 No No Active Identifier of a special project record. Project to be a three character acronym unique to the project for a cruise. VARCHAR2 19 PERMIT VARCHAR2 6 No No Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau. VARCHAR2 9685 ATL_LOV_ANIMAL_TYPE Published / External Completed Identifies the class of incidental catch for deterrence and condition. Currently (M)ammal, (H)alibut, (B)ird Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC Identifies the class of incidental catch for deterrence and condition. Currently (M)ammal, (H)alibut, (B)ird 1 ANIMAL_TYPE_CODE VARCHAR2 2 Yes Yes Active Animal type identifier for deterrence and condition VARCHAR2 2 DESCRIPTION VARCHAR2 250 Yes No Active Description of type and usage. VARCHAR2 9686 ATL_LOV_BAIT_USED Published / External Completed Type of bait used for fixed gear vessels only. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC Type of bait used for fixed gear vessels only. 1 BAIT_USED_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a bait used record NUMBER 2 CODE VARCHAR2 5 Yes No Active Identifies the type of bait used and the value is generated by FMA staff VARCHAR2 3 NAME VARCHAR2 50 Yes No Active Descriptive name of a code. VARCHAR2 9687 ATL_LOV_BEAUFORT_SCALE Published / External Completed The Beaufort scale in an international set of descriptive sea states and wind conditions. It may be recorded for a bird interaction event. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC The Beaufort scale in an international set of descriptive sea states and wind conditions. It may be recorded for a bird interaction event. 1 BEAUFORT_CODE VARCHAR2 10 Yes Yes Active International Beaufort Sea State Code VARCHAR2 2 DESCRIPTION VARCHAR2 100 Yes No Active Descriptive text for sea state. VARCHAR2 9688 ATL_LOV_BIRD_AGE_CATEGORY Published / External Completed This entity represents the possible values of the age of a bird by general category. e.g. mature, immature, possibly immature, unknown. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity represents the possible values of the age of a bird by general category. e.g. mature, immature, possibly immature, unknown. 1 AGE_CATEGORY_CODE VARCHAR2 10 Yes Yes Active Unique code for classifying bird age VARCHAR2 2 DESCRIPTION VARCHAR2 20 Yes No Active Description of age category. VARCHAR2 9689 ATL_LOV_BIRD_BEHAVIOR Published / External Completed This entity represents the list of valid behaviors that may be recorded for an interaction, species, or specimen record. This is a specific observation at the beginning of an observation. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity represents the list of valid behaviors that may be recorded for an interaction, species, or specimen record. This is a specific observation at the beginning of an observation. 1 BEHAVIOR_CODE VARCHAR2 3 Yes Yes Active Unique Code representing a specific avian behavior. VARCHAR2 2 DESCRIPTION VARCHAR2 150 Yes No Active Descriptive Text describing the use an purpose of this code. VARCHAR2 9690 ATL_LOV_BIRD_COUNT_TYPE Published / External Completed This entity describes how the of number or estimate of animals in species or event was determined. (How were birds counted?) Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity describes how the of number or estimate of animals in species or event was determined. (How were birds counted?) 1 COUNT_TYPE_CODE VARCHAR2 10 Yes Yes Active Unique code describing how the number of animals field is determined. Except for a type of specific the grouping is an estimate and number is not required. VARCHAR2 2 DESCRIPTION VARCHAR2 100 Yes No Active Discriptive text of the meaning and usage of the count type code. VARCHAR2 9691 ATL_LOV_BIRD_DETERERENT_USED Published / External Completed This entity records the list of reasons for the use or absence of deterrent measures for this particular bird event. While most probably limited to haul events it is not structually bound to hauls. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity records the list of reasons for the use or absence of deterrent measures for this particular bird event. While most probably limited to haul events it is not structually bound to hauls. 1 DETERRENT_USED_CODE VARCHAR2 10 Yes Yes Active Unique code dientifying the reason for the use or absence of a bird deterrence strategy. VARCHAR2 2 DESCRIPTION VARCHAR2 100 No No Active Brief descriptive text of the purpose and use of the deterrent_use_code VARCHAR2 9692 ATL_LOV_BIRD_EVENT_LOCATION Published / External Completed This entity represents the list of valid locations available for recording the first observation of a bird or birds - recorded in a bird interaction. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity represents the list of valid locations available for recording the first observation of a bird or birds - recorded in a bird interaction. 1 LOCATION_CODE VARCHAR2 10 Yes Yes Active Unique code identifying the location of the bird at the first observation VARCHAR2 2 DESCRIPTION VARCHAR2 20 Yes No Active Discriptive text identifying the meaning and usage of the code VARCHAR2 9693 ATL_LOV_BIRD_EVENT_OUTCOME Published / External Completed This entity represent the list of valid outcomes which may be associated with a bird event (interaction). It is here that mortality and/or incidental event types are defined. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity represent the list of valid outcomes which may be associated with a bird event (interaction). It is here that mortality and/or incidental event types are defined. 1 OUTCOME_CODE VARCHAR2 10 Yes Yes Active Unique code identifying the condition of the bird after this interaction VARCHAR2 2 DESCRIPTION VARCHAR2 20 Yes No Active Descriptive text of an interaction outcome. VARCHAR2 9694 ATL_LOV_BIRD_FISHERY Published / External Completed This entity identifies the current fishery a vessel in engaged in during a bird interaction. These values are not matched to AKR target fishery as computed by the catch accounting system. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity identifies the current fishery a vessel in engaged in during a bird interaction. These values are not matched to AKR target fishery as computed by the catch accounting system. 1 FISHERY_CODE VARCHAR2 5 Yes Yes Active Unique Abbreviated code for a fishery as defined by the observer. VARCHAR2 2 DESCRIPTION VARCHAR2 100 Yes No Active Descriptive Text of the Fishery VARCHAR2 9695 ATL_LOV_BIRD_INTERACTION Published / External Completed This entity maps to the Norpac Bird_Interaction table and is a list of the currently valid avian interactions identified with gear, vessels, and offloads. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity maps to the Norpac Bird_Interaction table and is a list of the currently valid avian interactions identified with gear, vessels, and offloads. 1 BIRD_INTERACT_CODE VARCHAR2 6 Yes Yes Active This attribute is the list of unique valid codes for a bird - vessel,trip,offload interaction event outcomes. VARCHAR2 2 DESCRIPTION VARCHAR2 100 Yes No Active Descriptive text regardint the use and meaning of an interaction code. VARCHAR2 9696 ATL_LOV_BIRD_LEG_BAND_COLORMAT Published / External Completed This entity represents the list of material and color of leg bands available to be mapped to a bird interaction species record. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity represents the list of material and color of leg bands available to be mapped to a bird interaction species record. 1 COLOR_CODE VARCHAR2 5 Yes Yes Active Color Code VARCHAR2 2 DESCRIPTION VARCHAR2 100 Yes No Active Color Description VARCHAR2 9697 ATL_LOV_BIRD_SPECIMEN_TYPE Published / External Completed This entity represents the list of currently identified avian specimen types. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity represents the list of currently identified avian specimen types. 1 SPECIMEN_TYPE_CODE VARCHAR2 6 Yes Yes Active The list of unique type codes associated with a bird specimen. VARCHAR2 2 DESCRIPTION VARCHAR2 100 Yes No Active Descriptive text regarding the use and meaning of a bird specimen type code. VARCHAR2 9698 ATL_LOV_BIRD_TAG_LOCATION Published / External Completed This entity is the list of possible locations on a specimen where a tag or leg band may be found. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity is the list of possible locations on a specimen where a tag or leg band may be found. 1 LOCATION_CODE VARCHAR2 10 Yes Yes Active Unique Code for the found location of a bird tag. For example rtleg; VARCHAR2 2 DESCRIPTION VARCHAR2 150 Yes No Active Description of the use and meaning of the location code. VARCHAR2 9699 ATL_LOV_BIRD_TAG_TYPE Published / External Completed This entity represents the list of valid types of tags/leg bands. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity represents the list of valid types of tags/leg bands. 1 TYPE_CODE VARCHAR2 3 Yes Yes Active Unique code identifying the type of recovered tag. VARCHAR2 2 DESCRIPTION VARCHAR2 150 Yes No Active Descriptive text describing the use and location of this tag VARCHAR2 9700 ATL_LOV_BIRD_VESSEL_ACTIVITY Published / External Completed This entity describes the current vessel activity. Codes are interaction parent specific. For example Setting gear is only pertinent when the interaction is associated with a haul. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity describes the current vessel activity. Codes are interaction parent specific. For example Setting gear is only pertinent when the interaction is associated with a haul. 1 ACTIVITY_CODE VARCHAR2 5 Yes Yes Active Unique code for an activity. VARCHAR2 2 DESCRIPTION VARCHAR2 100 Yes No Active Descriptive Text for an activity VARCHAR2 9701 ATL_LOV_CDQ Published / External Completed This entity maps to the Norpac CDQ_Codes table and contains unique CDQ organization and research codes and their descriptive names and descriptions. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity maps to the Norpac CDQ_Codes table and contains unique CDQ organization and research codes and their descriptive names and descriptions. 1 CDQ_CODE VARCHAR2 3 Yes Yes Active Unique AlphaNumeric code representing a CDQ or research group VARCHAR2 2 DESCRIPTION VARCHAR2 60 Yes No Active Descriptive text or full CDQ Group name. VARCHAR2 Data Steward 2010-01-01 Person Narita, Renold E ren.narita@noaa.gov 206 526 6697 Distributor 2008 Person Narita, Renold E ren.narita@noaa.gov Email Metadata Contact 2008 Person Narita, Renold E ren.narita@noaa.gov ren.narita@noaa.gov Originator 2009 Person Blair, Julie A julie.blair@noaa.gov 7600 Sandpoint Way NE Seattle WA 98115 USA 206 526 4053 (206)526-4066 0700-1630 julie.blair@noaa.gov Point of Contact 2009 Person Blair, Julie A julie.blair@noaa.gov 7600 Sandpoint Way NE Seattle WA 98115 USA 206 526 4053 (206)526-4066 0700-1630 julie.blair@noaa.gov -180 -132 65 50 North Pacific EEZ Continuing 2008 Re-engineered data model went into production Confidential Under the Magnuson-Stevens Act section 402(b)(2) any observer data shall be confidential and shall not be disclosed except in accordance with certain exceptions. Confidentiality of observer statistics is to be maintained under 50 CFR 600.415 - Access to statistics. Access to these data are provided to Federal, State, Council, Research Institutions and others who have a demonstrated need for such access, and who have submitted and been been granted approval, of limited access confidentiality agreements. These agreements are valid only for the duration of approved projects or research, the data released Under the Magnuson-Stevens Act section 402(b)(2) any observer data shall be confidential and shall not be disclosed except in accordance with certain exceptions. Confidentiality of observer statistics is to be maintained under 50 CFR 600.415 - Access to statistics. Access to these data are provided to Federal, State, Council, Research Institutions and others who have a demonstrated need for such access, and who have submitted and been been granted approval, of limited access confidentiality agreements. These agreements are valid only for the duration of approved projects or research, the data released Confidentiality agreement required for unaggregated data. Aggregated Data provided via AKFIN None on Aggregated Data None on Aggregated Data None None https://www.afsc.noaa.gov/FMA/default.htm N/A These data are confidential and may be accessed in unaggregated form only from FMA Division N/A Not Applicable https://www.afsc.noaa.gov/FMA/PDF_DOCS/ATL-NORPAC_SYSTEM_DIAGRAM_2016_07_15.pdf ATL NORPAC System Diagram ERD for production schema. Data is maintained by the OFIS on an Oracle Database. Data are received by satellite transmission and periodically error checked and loaded in an automated way. These data were subject to inseason review, and comprehensive debriefing. Data are subjected to automated error checking whenever changes are saved. Assumed to be accurate. N/A N/A These fishery statistics are created at sea by fisheries observers. Any sampling bias is assumed to be nil. N/A Data are validated by both automated and inseason review. The data are not finalized until observer debriefing is completed and the data set is determined to be complete. Data are validated by both automated and inseason review. The data are not finalized until observer debriefing is completed and the data set is determined to be complete. N/A N/A N/A N/A Data are validated by both automated and inseason review. The data are not finalized until observer debriefing is completed and the data set is determined to be complete. N/A These data were subject to inseason advising, automated error scripting, and comprehensive debriefing. Yes Unknown No Yes N/A N/A Under the Magnuson-Stevens Act section 402(b)(2) any observer data shall be confidential and shall not be disclosed except in accordance with certain exceptions. Confidentiality of observer statistics is to be maintained under 50 CFR 600.415 - Access to statistics. Access to these data are provided to Federal, State, Council, Research Institutions and others who have a demonstrated need for such access, and who have submitted and been been granted approval, of limited access confidentiality agreements. These agreements are valid only for the duration of approved projects or research, the data released No Archiving Intended N/A These data are preserved in a fully backed up and mirrored Oracle database at the AFSC. The North Pacific Groundfish Observer Program was implemented in early 1990. Under this program, NMFS provides the operational oversight of the program, certification training, definition of observer sampling duties and methods, debriefing of observers, and management of the data. Although the vessel and plant owners pay for the cost of the observers, the costs associated with managing the program are covered by the Federal Government. This data set supersedes the Domestic data model. 12658 Entity 12661 Entity 12662 Entity 7485 Entity 7486 Entity 9604 Entity 9605 Entity 9606 Entity 9607 Entity 9608 Entity 9609 Entity 9610 Entity 9611 Entity 9612 Entity 9613 Entity 9614 Entity 9615 Entity 9616 Entity 9617 Entity 9618 Entity 9619 Entity 9620 Entity 9621 Entity 9622 Entity 9623 Entity 9624 Entity 9625 Entity 9626 Entity 9627 Entity 9628 Entity 9629 Entity 9630 Entity 7357 Entity 7358 Entity 7359 Entity 7360 Entity 7361 Entity 9636 Entity 9637 Entity 9638 Entity 9639 Entity 9640 Entity 9641 Entity 9642 Entity 9643 Entity 9644 Entity 9645 Entity 9646 Entity 9647 Entity 9648 Entity 9649 Entity 9650 Entity 9651 Entity 9652 Entity 9653 Entity 9655 Entity 9656 Entity 9657 Entity 7366 Entity 9659 Entity 9660 Entity 7369 Entity 9662 Entity 9663 Entity 9665 Entity 9666 Entity 9667 Entity 9668 Entity 9669 Entity 9670 Entity 9671 Entity 7379 Entity 9673 Entity 9675 Entity 9676 Entity 9677 Entity 9678 Entity 9679 Entity 9680 Entity 9681 Entity 9682 Entity 7383 Entity 9684 Entity 9685 Entity 9686 Entity 9687 Entity 9688 Entity 9689 Entity 9690 Entity 9691 Entity 9692 Entity 9693 Entity 9694 Entity 9695 Entity 9696 Entity 9697 Entity 9698 Entity 9699 Entity 9700 Entity 9701 Entity 9702 Entity 7390 Entity 9704 Entity 9705 Entity 9706 Entity 9707 Entity 9708 Entity 9709 Entity 9710 Entity 9711 Entity 12278 Entity 9712 Entity 9713 Entity 9714 Entity 9715 Entity 9716 Entity 9717 Entity 9718 Entity 9719 Entity 9720 Entity 9721 Entity 9722 Entity 9723 Entity 9724 Entity 9725 Entity 9726 Entity 9727 Entity 9729 Entity 9730 Entity 9731 Entity 9732 Entity 9733 Entity 9734 Entity 9736 Entity 9737 Entity 9738 Entity 9739 Entity 9741 Entity 9742 Entity 9743 Entity 9744 Entity 9745 Entity 9746 Entity 9747 Entity 9748 Entity 9749 Entity 9750 Entity 9751 Entity 9752 Entity 7433 Entity 7434 Entity 9755 Entity 9756 Entity 9740 Entity gov.noaa.nmfs.inport:7284 Doug Turnbull 2008-03-26T11:18:54 SysAdmin InPortAdmin 2025-05-15T19:15:56 2018-09-26 Alaska Fisheries Science Center AFSC 7600 Sand Point Way N.E., Building 4 Seattle WA 98115 USA https://www.afsc.noaa.gov 0700-1700 Pacific Time 1001 Public No No 2018-09-26 1 Year 2019-09-26