CI99_FORM1
Alaska Fisheries Science Center
Entity
(ENT)
| ID: 75123
| Published / External
Created: 2025-03-05
|
Last Modified: 2025-05-21
Parent: AMMOP Oracle database 1999 - 2013
Data Set (DS) | ID: 75024
Data Set (DS) | ID: 75024
ID: 75123
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
| * » Title | CI99_FORM1 |
|---|---|
| Short Name | |
| * Status | |
| Creation Date | |
| Revision Date | |
| • Publication Date | |
| * » Abstract | |
| * Purpose | |
| Notes | |
| Other Citation Details | |
| • Supplemental Information | |
| DOI (Digital Object Identifier) | |
| DOI Registration Authority | |
| DOI Issue Date |
Keywords
Theme Keywords
| Thesaurus | Keyword |
|---|---|
Temporal Keywords
| Thesaurus | Keyword |
|---|---|
* Spatial Keywords
| Thesaurus | Keyword |
|---|---|
Stratum Keywords
| Thesaurus | Keyword |
|---|---|
Instrument Keywords
| Thesaurus | Keyword |
|---|---|
Platform Keywords
| Thesaurus | Keyword |
|---|---|
Physical Location
| • » Organization | |
|---|---|
| • » City | |
| • » State/Province | |
| • Country | |
| • » Location Description |
Entity Information
| Entity Type | |
|---|---|
| Active Version? | |
| Alias | |
| Schema Name | |
| » Description |
Table created from MS Access 1999 Cook Inlet Alaska Marine Mammal Observer Program Form 1. File CIOP99. 20240711MM |
| Change Summary |
Data Attributes
Attribute Summary
| Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
|---|---|---|---|---|---|
| 100 | No | No | ASS11US | VARCHAR2(26 BYTE) | "MS Access: Description: Associated Form 11US? Caption: 11US." |
| 100 | No | No | ASS2 | VARCHAR2(26 BYTE) | "MS Access: Description: Associated form 2's? Caption: Associated Form 2?." |
| 100 | No | No | ASS3 | VARCHAR2(26 BYTE) | "MS Access: Description: Associated form 3's? Caption: Associated Form 3?." |
| 100 | No | No | ASS4 | VARCHAR2(26 BYTE) | "MS Access: Description: Associated form 4's? Caption: Associated Form 4?." |
| 100 | No | No | BHNC | VARCHAR2(26 BYTE) | "MS Access: Description: Predominate manner the net fished during haul (enter up to three in order of predominance). No caption in MS Access." |
| 100 | No | No | BSNC | VARCHAR2(26 BYTE) | "MS Access: Description: Predominate manner the net fished during soak (enter up to three in order of predominance). No caption in MS Access." |
| 100 | No | No | COMMENTS | VARCHAR2(4000 BYTE) | "MS Access: Description: Comments.? Caption: No MS Access caption." |
| 100 | No | No | DEBID | VARCHAR2(26 BYTE) | "MS Access: Description: 3 digit unique code of person who debriefed observer. Caption: Debrief" |
| 100 | No | No | DEPBH | NUMBER(38,0) | "MS Access: Description: Average water depth in area at beginning of haul, in feet Caption: Depth" |
| 100 | No | No | DEPBS | NUMBER(38,0) | "MS Access: Description: Average water depth in area at beginning of set, in feet. Caption: Depth" |
| 100 | No | No | DISTBH | VARCHAR2(26 BYTE) | "MS Access: Description: Code for maximum distance in meters net is from shore at beginning of haul. Caption: Distance" |
| 100 | No | No | DISTBS | VARCHAR2(26 BYTE) | "MS Access: Description: Code for maximum distance in meters net is from shore at beginning of set. Caption: Distance" |
| 100 | No | No | DISTNNH | VARCHAR2(26 BYTE) | "MS Access: Description: Distance code for distance to next active fishing net at haul. Caption: Dist to nn haul." |
| 100 | No | No | DISTNNS | VARCHAR2(26 BYTE) | "MS Access: Description: Distance code for distance to next active fishing net at soak. Caption: Dist. to next net:." |
| 100 | No | No | DISTOBH | NUMBER(38,0) | "MS Access: Description: Observer distance from net during haul, in feet. Caption: No MS Access caption." |
| 100 | No | No | DISTOBS | VARCHAR2(26 BYTE) | No MS Access description or caption. |
| 100 | No | No | DISTRICTBH | VARCHAR2(26 BYTE) | "MS Access: Description: District code from ADFG statistical map where haul began. No MS Access caption." |
| 100 | No | No | DISTRICTBS | VARCHAR2(26 BYTE) | "MS Access: Description: District code from ADFG statistical map where set began. Caption: DistrictB" |
| 100 | No | No | EDITID | VARCHAR2(26 BYTE) | "MS Access: Description: 3 digit unique code of person who edited data into the form. Caption: Field Edit" |
| 100 | No | No | ENTID | VARCHAR2(26 BYTE) | "MS Access: Description: 3 digit unique code of person who entered data into form. Caption: Data Entry" |
| 100 | No | No | EO1 | VARCHAR2(26 BYTE) | "MS Access: Description: Time when observation stops. Caption: End Obs." |
| 100 | No | No | EO2 | VARCHAR2(26 BYTE) | No MS Access description or caption. |
| 100 | No | No | EO3 | VARCHAR2(26 BYTE) | No MS Access description or caption. |
| 100 | No | No | EO4 | VARCHAR2(26 BYTE) | No MS Access description or caption. |
| 100 | No | No | EO5 | VARCHAR2(26 BYTE) | No MS Access description or caption. |
| 100 | No | No | ESTDAM | NUMBER(38,0) | "MS Access: Description: Estimated square feet (to nearest tenth) of damage. Caption: Est. sq.ft. damage:." |
| 100 | No | No | FINALID | VARCHAR2(26 BYTE) | No MS Access metadata. |
| 100 | No | No | FISHERY | VARCHAR2(26 BYTE) | "MS Access: Description: Fishery observed (drift or set gillnet). Caption: Fishery" |
| 100 | No | No | FTRIP | VARCHAR2(26 BYTE) | "MS Access: Description: Full trip observed? Caption: Full trip (y/n)" |
| 100 | No | No | GUID | VARCHAR2(26 BYTE) | "MS Access: Description: Links Forms 1, 2, 3, and 4 unique to an observed "set" Caption: No MS Access caption." |
| 100 | No | No | HABBH | VARCHAR2(26 BYTE) | "MS Access: Description: Code for substrate type at beginning of haul. Caption: Habitat" |
| 100 | No | No | HABBS | VARCHAR2(26 BYTE) | "MS Access: Description: Code for substrate type at begining of set. Caption: Habitat" |
| 100 | No | No | LATBH | VARCHAR2(26 BYTE) | "MS Access: Description: Latitude to nearest 1/10 minute of begin haul Caption: Latitude" |
| 100 | No | No | LATBS | VARCHAR2(26 BYTE) | "MS Access: Description: Latitude to nearest 1/10 minute of begin set. Caption: Latitude" |
| 100 | No | No | LBREF | VARCHAR2(26 BYTE) | "MS Access: Description: Comments relevant to entries in logbook? Caption: Log book reference (Y/N):." |
| 100 | No | No | LBREFNO | VARCHAR2(26 BYTE) | "MS Access: Description: Comments in logbook #. Caption: (if yes): logbook #." |
| 100 | No | No | LBREFPG | VARCHAR2(26 BYTE) | "MS Access: Description: Comments on page number (?) of logbook. Caption: Logbook page number with comments." |
| 100 | No | No | LDR | NUMBER(38,0) | "MS Access: Description: Set nets only. Seine web used as leader? Caption: If leader, length (fath.):" |
| 100 | No | No | LONGBH | VARCHAR2(26 BYTE) | "MS Access: Description: Longitude to nearest 1/10 minute of begin haul. Caption: Longitude" |
| 100 | No | No | LONGBS | VARCHAR2(26 BYTE) | "MS Access: Description: Longitude to nearest 1/10 minute of begin set. Caption: Longitude" |
| 100 | No | No | MB300 | VARCHAR2(26 BYTE) | "MS Access: Description: Marine birds noted in area during fishing? Caption: MB w/in 300m?." |
| 100 | No | No | MM10CD1 | VARCHAR2(26 BYTE) | "MS Access: Description: Species code of marine mammals within 10m of net if reported by crew. Caption: species code & #:." |
| 100 | No | No | MM10CD2 | VARCHAR2(26 BYTE) | "MS Access: Description: Species code of marine mammals within 10m of net if reported by crew. Caption: species code & #:." |
| 100 | No | No | MM10NO1 | NUMBER(38,0) | "MS Access: Description: Associated number of marine mammals. Caption: No MS Access caption." |
| 100 | No | No | MM10NO2 | NUMBER(38,0) | "MS Access: Description: Associated number of marine mammals. Caption: No MS Access caption." |
| 100 | No | No | MM300 | VARCHAR2(26 BYTE) | "MS Access: Description: Marine mammals noted in area during fishing? Caption: MM w/in 300m?." |
| 100 | No | No | MSIZE | NUMBER(38,14) | "MS Access: Description: Stretch mesh size in tenths of inches. Caption: Mesh size (inches):" |
| 100 | No | No | NETD | NUMBER(38,0) | "MS Access: Description: Hung depth of the net, in feet. Caption: Net depth (ft.)" |
| 100 | No | No | NETL | NUMBER(38,0) | "MS Access: Description: Length of fished net as first set, in fathoms. Caption: Net length (fath.)" |
| 100 | No | No | NETNO | VARCHAR2(26 BYTE) | "MS Access: Description: Position of set net observed based on grid layout. Caption: Set net grid#" |
| 100 | No | No | NONETS | NUMBER(38,0) | "MS Access: Description: Total number of nets being fished by same permit at time of observation. Caption: # of nets fished" |
| 100 | No | No | NUMNN | NUMBER(38,0) | "MS Access: Description: Approx. number of fishing nets within 800m. Caption: # nets<800m:." |
| 100 | No | No | OBSERVATION_DATE | DATE | "MS Access: Description: Date observation of set began. Caption: Date (mm/dd/yy)" |
| 100 | No | No | OBSID | VARCHAR2(26 BYTE) | "MS Access: Description: 3 digit unique observer ID code. Caption: Obs. code" |
| 100 | No | No | OFFID | VARCHAR2(26 BYTE) | "MS Access: Description: 3 digit unique code of office person who reviewed data. Caption: Office Edit" |
| 100 | No | No | ORIENT | VARCHAR2(26 BYTE) | "MS Access: Description: Orientation of net during set code. Caption: Orientation" |
| 100 | No | No | OVRLP | VARCHAR2(26 BYTE) | "MS Access: Description: Mainly for set nets. Any overlap between nearest nets? Caption: Overlap (y/n)" |
| 100 | No | No | PERMAX | VARCHAR2(26 BYTE) | "MS Access: Description: Percent code of largest amount of net fished during set. Caption: max-min % net fished:." |
| 100 | No | No | PERMIN | VARCHAR2(26 BYTE) | "MS Access: Description: Percent code of least amount of net fished during set. Caption: No MS Access caption." |
| 100 | No | No | PERMITID | VARCHAR2(26 BYTE) | "MS Access: Description: CFEC permit (set) or ADFG vessel (drift) number and check digit. Caption: Permit #" |
| 100 | No | No | PERPH | VARCHAR2(26 BYTE) | "MS Access: Description: Percentage of net that was "picked" for fish if a partial haul. Caption: If part % T." |
| 100 | No | No | PERTG | VARCHAR2(26 BYTE) | "MS Access: Description: Code for % time gear was tended. Caption: % time tended gear:." |
| 100 | No | No | PERWN | VARCHAR2(26 BYTE) | "MS Access: Description: Percent code best reflecting total time whole net fished. Caption: % time whole net fished:." |
| 100 | No | No | PHOTO | VARCHAR2(26 BYTE) | "MS Access: Description: Photograph taken? Caption: Photo reference (Y/N):." |
| 100 | No | No | PHTIME | VARCHAR2(26 BYTE) | "MS Access: Description: Time the haul was partially picked. Caption: No MS Access caption." |
| 100 | No | No | PLATFORM | VARCHAR2(26 BYTE) | "MS Access: Description: Platform from which observations were made. Caption: Platform code" |
| 100 | No | No | PRIMKEY | NUMBER(38,0) | No MS Access metadata. |
| 100 | No | No | PROLL | NUMBER(38,0) | "MS Access: Description: Roll number of photographs. Caption: roll#." |
| 100 | No | No | PSHOT | NUMBER(38,0) | "MS Access: Description: Photograph number. Caption: and shot #." |
| 100 | No | No | RELNETS | VARCHAR2(26 BYTE) | "MS Access: Description: Relationship to other nets (outside or inside). Caption: Relt. to nets:" |
| 100 | No | No | RUNG | VARCHAR2(26 BYTE) | "MS Access: Description: Did skipper run gear? Caption: Run Gear (y/n/u)." |
| 100 | No | No | SEABH | NUMBER(38,0) | "MS Access: Description: Sea state code at begining of haul. Caption: No caption in MS Access." |
| 100 | No | No | SEABS | NUMBER(38,0) | "MS Access: Description: Sea state code at begining of set. Caption: Sea state." |
| 100 | No | No | SO1 | VARCHAR2(26 BYTE) | "MS Access: Description: Time when first begin observing. Caption: Start obs." |
| 100 | No | No | SO2 | VARCHAR2(26 BYTE) | No MS Access description or caption. |
| 100 | No | No | SO3 | VARCHAR2(26 BYTE) | No MS Access description or caption. |
| 100 | No | No | SO4 | VARCHAR2(26 BYTE) | No MS Access description or caption. |
| 100 | No | No | SO5 | VARCHAR2(26 BYTE) | No MS Access description or caption. |
| 100 | No | No | STABH | VARCHAR2(26 BYTE) | "MS Access: Description: Tide stage code at begin of haul. Caption: Stage." |
| 100 | No | No | STABS | VARCHAR2(26 BYTE) | "MS Access: Description: Tide stage code at begin of set. Caption: Stage." |
| 100 | No | No | STATWK | NUMBER(38,0) | "MS Access: Description: ADFG statistical week. Caption: Week #" |
| 100 | No | No | TIDEBH | VARCHAR2(26 BYTE) | "MS Access: Description: Tide code at beginning of haul. Caption: Tide." |
| 100 | No | No | TIDEBS | VARCHAR2(26 BYTE) | "MS Access: Description: Ttide code at beginning of set. Caption: Tide." |
| 100 | No | No | TIMEBH | VARCHAR2(26 BYTE) | "MS Access: Description: Time beginning set retrieval or pick. Caption: Begin Haul." |
| 100 | No | No | TIMEBS | VARCHAR2(26 BYTE) | "MS Access: Description: Time of drift/set net set start (or time of set net last haul). Caption: Begin Set." |
| 100 | No | No | TIMEEH | VARCHAR2(26 BYTE) | "MS Access: Description: Time set retrieval ends. Caption: End Haul." |
| 100 | No | No | TIMEES | VARCHAR2(26 BYTE) | "MS Access: Description: Time ofdrift/set net begin soak. Caption: Begin Soak." |
| 100 | No | No | VISBH | VARCHAR2(26 BYTE) | "MS Access: Description: Visibility code for conditions during haul. Caption: No caption in MS Access." |
| 100 | No | No | VISBS | VARCHAR2(26 BYTE) | "MS Access: Description: Visibility code for conditions during soak. Caption: Visibility." |
| 100 | No | No | VPNAME | VARCHAR2(26 BYTE) | MS Access: Description: Vessel name (drift) or permit holder name (set; last, first, mi). Caption:Vessel/permit name |
| 100 | No | No | WEABH | VARCHAR2(26 BYTE) | "MS Access: Description: Weather code for conditions during haul. Caption: No caption in MS Access." |
| 100 | No | No | WEABS | VARCHAR2(26 BYTE) | "MS Access: Description: Weather code for conditions during soak. Caption: Weather." |
| 100 | No | No | WLINE | NUMBER(38,0) | "MS Access: Description: If a weedline is present, how long is the drop? Caption: If weedline (inches):" |
| 100 | No | No | WNFISH | VARCHAR2(26 BYTE) | "MS Access: Description: Did entire length and depth of net fish entire set? Caption: Whole net fished for set (y/n)." |
| 100 | No | No | ZONEBH | VARCHAR2(26 BYTE) | "MS Access: Description: Code for land form at beginning of haul. Caption: Zone" |
| 100 | No | No | ZONEBS | VARCHAR2(26 BYTE) | "MS Access: Description: Code for land form at beginning of set. Caption: Zone" |
| 100 | No | No | SETNO | NUMBER(38,0) | "MS Access: Description: Sequential number of set observed per day by observer. Caption: Observed Set #" |
Attribute Details
| Attribute Name | ASS11US |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Associated Form 11US? Caption: 11US." |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ASS2 |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Associated form 2's? Caption: Associated Form 2?." |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ASS3 |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Associated form 3's? Caption: Associated Form 3?." |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ASS4 |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Associated form 4's? Caption: Associated Form 4?." |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | BHNC |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Predominate manner the net fished during haul (enter up to three in order of predominance). No caption in MS Access." |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | BSNC |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Predominate manner the net fished during soak (enter up to three in order of predominance). No caption in MS Access." |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | COMMENTS |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(4000 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Comments.? Caption: No MS Access caption." |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | DEBID |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: 3 digit unique code of person who debriefed observer. Caption: Debrief" |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | DEPBH |
|---|---|
| Seq. Order | |
| Data Storage Type | NUMBER(38,0) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Average water depth in area at beginning of haul, in feet Caption: Depth" |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | DEPBS |
|---|---|
| Seq. Order | |
| Data Storage Type | NUMBER(38,0) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Average water depth in area at beginning of set, in feet. Caption: Depth" |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | DISTBH |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Code for maximum distance in meters net is from shore at beginning of haul. Caption: Distance" |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | DISTBS |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Code for maximum distance in meters net is from shore at beginning of set. Caption: Distance" |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | DISTNNH |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Distance code for distance to next active fishing net at haul. Caption: Dist to nn haul." |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | DISTNNS |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Distance code for distance to next active fishing net at soak. Caption: Dist. to next net:." |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | DISTOBH |
|---|---|
| Seq. Order | |
| Data Storage Type | NUMBER(38,0) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Observer distance from net during haul, in feet. Caption: No MS Access caption." |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | DISTOBS |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
No MS Access description or caption. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | DISTRICTBH |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: District code from ADFG statistical map where haul began. No MS Access caption." |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | DISTRICTBS |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: District code from ADFG statistical map where set began. Caption: DistrictB" |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | EDITID |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: 3 digit unique code of person who edited data into the form. Caption: Field Edit" |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ENTID |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: 3 digit unique code of person who entered data into form. Caption: Data Entry" |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | EO1 |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Time when observation stops. Caption: End Obs." |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | EO2 |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
No MS Access description or caption. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | EO3 |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
No MS Access description or caption. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | EO4 |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
No MS Access description or caption. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | EO5 |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
No MS Access description or caption. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ESTDAM |
|---|---|
| Seq. Order | |
| Data Storage Type | NUMBER(38,0) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Estimated square feet (to nearest tenth) of damage. Caption: Est. sq.ft. damage:." |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | FINALID |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
No MS Access metadata. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | FISHERY |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Fishery observed (drift or set gillnet). Caption: Fishery" |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | FTRIP |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Full trip observed? Caption: Full trip (y/n)" |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | GUID |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Links Forms 1, 2, 3, and 4 unique to an observed "set" Caption: No MS Access caption." |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | HABBH |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Code for substrate type at beginning of haul. Caption: Habitat" |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | HABBS |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Code for substrate type at begining of set. Caption: Habitat" |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LATBH |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Latitude to nearest 1/10 minute of begin haul Caption: Latitude" |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LATBS |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Latitude to nearest 1/10 minute of begin set. Caption: Latitude" |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LBREF |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Comments relevant to entries in logbook? Caption: Log book reference (Y/N):." |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LBREFNO |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Comments in logbook #. Caption: (if yes): logbook #." |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LBREFPG |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Comments on page number (?) of logbook. Caption: Logbook page number with comments." |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LDR |
|---|---|
| Seq. Order | |
| Data Storage Type | NUMBER(38,0) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Set nets only. Seine web used as leader? Caption: If leader, length (fath.):" |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LONGBH |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Longitude to nearest 1/10 minute of begin haul. Caption: Longitude" |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LONGBS |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Longitude to nearest 1/10 minute of begin set. Caption: Longitude" |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | MB300 |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Marine birds noted in area during fishing? Caption: MB w/in 300m?." |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | MM10CD1 |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Species code of marine mammals within 10m of net if reported by crew. Caption: species code & #:." |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | MM10CD2 |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Species code of marine mammals within 10m of net if reported by crew. Caption: species code & #:." |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | MM10NO1 |
|---|---|
| Seq. Order | |
| Data Storage Type | NUMBER(38,0) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Associated number of marine mammals. Caption: No MS Access caption." |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | MM10NO2 |
|---|---|
| Seq. Order | |
| Data Storage Type | NUMBER(38,0) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Associated number of marine mammals. Caption: No MS Access caption." |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | MM300 |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Marine mammals noted in area during fishing? Caption: MM w/in 300m?." |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | MSIZE |
|---|---|
| Seq. Order | |
| Data Storage Type | NUMBER(38,14) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Stretch mesh size in tenths of inches. Caption: Mesh size (inches):" |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | NETD |
|---|---|
| Seq. Order | |
| Data Storage Type | NUMBER(38,0) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Hung depth of the net, in feet. Caption: Net depth (ft.)" |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | NETL |
|---|---|
| Seq. Order | |
| Data Storage Type | NUMBER(38,0) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Length of fished net as first set, in fathoms. Caption: Net length (fath.)" |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | NETNO |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Position of set net observed based on grid layout. Caption: Set net grid#" |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | NONETS |
|---|---|
| Seq. Order | |
| Data Storage Type | NUMBER(38,0) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Total number of nets being fished by same permit at time of observation. Caption: # of nets fished" |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | NUMNN |
|---|---|
| Seq. Order | |
| Data Storage Type | NUMBER(38,0) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Approx. number of fishing nets within 800m. Caption: # nets<800m:." |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | OBSERVATION_DATE |
|---|---|
| Seq. Order | |
| Data Storage Type | DATE |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Date observation of set began. Caption: Date (mm/dd/yy)" |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | OBSID |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: 3 digit unique observer ID code. Caption: Obs. code" |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | OFFID |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: 3 digit unique code of office person who reviewed data. Caption: Office Edit" |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ORIENT |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Orientation of net during set code. Caption: Orientation" |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | OVRLP |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Mainly for set nets. Any overlap between nearest nets? Caption: Overlap (y/n)" |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | PERMAX |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Percent code of largest amount of net fished during set. Caption: max-min % net fished:." |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | PERMIN |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Percent code of least amount of net fished during set. Caption: No MS Access caption." |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | PERMITID |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: CFEC permit (set) or ADFG vessel (drift) number and check digit. Caption: Permit #" |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | PERPH |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Percentage of net that was "picked" for fish if a partial haul. Caption: If part % T." |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | PERTG |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Code for % time gear was tended. Caption: % time tended gear:." |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | PERWN |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Percent code best reflecting total time whole net fished. Caption: % time whole net fished:." |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | PHOTO |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Photograph taken? Caption: Photo reference (Y/N):." |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | PHTIME |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Time the haul was partially picked. Caption: No MS Access caption." |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | PLATFORM |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Platform from which observations were made. Caption: Platform code" |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | PRIMKEY |
|---|---|
| Seq. Order | |
| Data Storage Type | NUMBER(38,0) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
No MS Access metadata. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | PROLL |
|---|---|
| Seq. Order | |
| Data Storage Type | NUMBER(38,0) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Roll number of photographs. Caption: roll#." |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | PSHOT |
|---|---|
| Seq. Order | |
| Data Storage Type | NUMBER(38,0) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Photograph number. Caption: and shot #." |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | RELNETS |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Relationship to other nets (outside or inside). Caption: Relt. to nets:" |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | RUNG |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Did skipper run gear? Caption: Run Gear (y/n/u)." |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SEABH |
|---|---|
| Seq. Order | |
| Data Storage Type | NUMBER(38,0) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Sea state code at begining of haul. Caption: No caption in MS Access." |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SEABS |
|---|---|
| Seq. Order | |
| Data Storage Type | NUMBER(38,0) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Sea state code at begining of set. Caption: Sea state." |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SO1 |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Time when first begin observing. Caption: Start obs." |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SO2 |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
No MS Access description or caption. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SO3 |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
No MS Access description or caption. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SO4 |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
No MS Access description or caption. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SO5 |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
No MS Access description or caption. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | STABH |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Tide stage code at begin of haul. Caption: Stage." |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | STABS |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Tide stage code at begin of set. Caption: Stage." |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | STATWK |
|---|---|
| Seq. Order | |
| Data Storage Type | NUMBER(38,0) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: ADFG statistical week. Caption: Week #" |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | TIDEBH |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Tide code at beginning of haul. Caption: Tide." |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | TIDEBS |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Ttide code at beginning of set. Caption: Tide." |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | TIMEBH |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Time beginning set retrieval or pick. Caption: Begin Haul." |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | TIMEBS |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Time of drift/set net set start (or time of set net last haul). Caption: Begin Set." |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | TIMEEH |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Time set retrieval ends. Caption: End Haul." |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | TIMEES |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Time ofdrift/set net begin soak. Caption: Begin Soak." |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | VISBH |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Visibility code for conditions during haul. Caption: No caption in MS Access." |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | VISBS |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Visibility code for conditions during soak. Caption: Visibility." |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | VPNAME |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
MS Access: Description: Vessel name (drift) or permit holder name (set; last, first, mi). Caption:Vessel/permit name |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | WEABH |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Weather code for conditions during haul. Caption: No caption in MS Access." |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | WEABS |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Weather code for conditions during soak. Caption: Weather." |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | WLINE |
|---|---|
| Seq. Order | |
| Data Storage Type | NUMBER(38,0) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: If a weedline is present, how long is the drop? Caption: If weedline (inches):" |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | WNFISH |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Did entire length and depth of net fish entire set? Caption: Whole net fished for set (y/n)." |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ZONEBH |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Code for land form at beginning of haul. Caption: Zone" |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | ZONEBS |
|---|---|
| Seq. Order | |
| Data Storage Type | VARCHAR2(26 BYTE) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Code for land form at beginning of set. Caption: Zone" |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SETNO |
|---|---|
| Seq. Order | |
| Data Storage Type | NUMBER(38,0) |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
"MS Access: Description: Sequential number of set observed per day by observer. Caption: Observed Set #" |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | |
|---|---|
| Seq. Order | |
| Data Storage Type | |
| Max Length | |
| Precision | |
| Scale | |
| Required | |
| Primary Key | |
| Status | |
| Description | |
| General Data Type | |
| Case Restriction | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Min Length | |
| Unit of Measure | |
| Display Example | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | |
|---|---|
| Seq. Order | |
| Data Storage Type | |
| Max Length | |
| Precision | |
| Scale | |
| Required | |
| Primary Key | |
| Status | |
| Description | |
| General Data Type | |
| Case Restriction | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Min Length | |
| Unit of Measure | |
| Display Example | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | |
|---|---|
| Seq. Order | |
| Data Storage Type | |
| Max Length | |
| Precision | |
| Scale | |
| Required | |
| Primary Key | |
| Status | |
| Description | |
| General Data Type | |
| Case Restriction | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Min Length | |
| Unit of Measure | |
| Display Example | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
Support Roles
» At least one Distributor Org, one Metadata Contact, one Point of Contact, and one Data Steward should be listed.
| * » Support Role | |
|---|---|
| * » Date Effective From | |
| Date Effective To | |
| * » Contact | |
| * Contact Instructions |
| * » Support Role | |
|---|---|
| * » Date Effective From | |
| Date Effective To | |
| * » Contact | |
| * Contact Instructions |
| * » Support Role | |
|---|---|
| * » Date Effective From | |
| Date Effective To | |
| * » Contact | |
| * Contact Instructions |
Extents
| Currentness Reference |
|---|
Extent Group 1
| Extent Description |
|---|
Extent Group 1 / Geographic Area
| * » W° Bound | |
|---|---|
| * » E° Bound | |
| * » N° Bound | |
| * » S° Bound | |
| * » Description |
Extent Group 1 / Vertical Extent
| EPSG Code | |
|---|---|
| Vertical Minimum | |
| Vertical Maximum |
Extent Group 1 / Time Frame
| * » Time Frame Type | |
|---|---|
| * » Start | |
| End | |
| Alternate Start as of Info | |
| Alternate End as of Info | |
| Description |
Access Information
| * » Security Class | |
|---|---|
| * Security Classification System |
|
| Security Handling Description |
|
| • Data Access Policy |
|
| » Data Access Procedure |
|
| • » Data Access Constraints |
|
| • Data Use Constraints |
|
| Metadata Access Constraints |
|
| Metadata Use Constraints |
|
Distribution Information
| Start Date | |
|---|---|
| End Date | |
| » Download URL | |
| Distributor | |
| File Name | |
| Description | |
| File Date/Time | |
| File Type | |
| FGDC Content Type | |
| File Size | |
| Application Version | |
| Compression | |
| Review Status |
| Start Date | |
|---|---|
| End Date | |
| » Download URL | |
| Distributor | |
| File Name | |
| Description | |
| File Date/Time | |
| File Type | |
| FGDC Content Type | |
| File Size | |
| Application Version | |
| Compression | |
| Review Status |
| Start Date | |
|---|---|
| End Date | |
| » Download URL | |
| Distributor | |
| File Name | |
| Description | |
| File Date/Time | |
| File Type | |
| FGDC Content Type | |
| File Size | |
| Application Version | |
| Compression | |
| Review Status |
Activity Log
| Activity Time | |
|---|---|
| Activity Type | |
| Responsible Party | |
| Description |
| Activity Time | |
|---|---|
| Activity Type | |
| Responsible Party | |
| Description |
| Activity Time | |
|---|---|
| Activity Type | |
| Responsible Party | |
| Description |
Issues
| Issue Date | |
|---|---|
| Author | |
| Issue |
| Issue Date | |
|---|---|
| Author | |
| Issue |
| Issue Date | |
|---|---|
| Author | |
| Issue |
FAQs
| Date | |
|---|---|
| Author | |
| Question | |
| Answer |
Child Items
Rubric scores updated every 15m
| Score | Type | Title |
|---|---|---|
Related Items
| Item Type | Relationship Type | Title |
|---|---|---|
Catalog Details
| Catalog Item ID | 75123 |
|---|---|
| Metadata Record Created By | Rachel Wuest |
| Metadata Record Created | 2025-03-05 23:40+0000 |
| Metadata Record Last Modified By | Daniel Woodrich |
| » Metadata Record Last Modified | 2025-05-21 19:12+0000 |
| Metadata Record Published | 2025-05-21 |
| Owner Org | AFSC |
| Metadata Publication Status | Published Externally |
| Do Not Publish? | N |
| Metadata Workflow State | Published / External |
| Metadata Last Review Date | |
| Metadata Review Frequency | 1 Year |
| Metadata Next Review Date |
| Tags |
|---|