Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Table: OBSERVATION
Short Name: OBSERVATION
Status: Completed
Abstract:

Table Of Observations

Notes:

Loaded by batch 2005, 12-03-2007 10:12

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: TIPONLINE
Description:

Table Of Observations

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key ID NUMBER Unique key for this record
100
INTERVIEW_ID NUMBER Unique key
100
SPECIES_CODE VARCHAR2 Key to agency specific species table
100
QUANTITY NUMBER Number of individuals of this species that were weighted +/or measured
100
SEX VARCHAR2 this could be a ORACLE constraint sex in (M/F/T/U) 'male/female/transitional/undetermined'
100
SAMPLE_METHOD_TYPE_ID NUMBER Key to Sample_Method_Type (LANDED SORTED, LANDED UNSORTED)
100
CREATED_BY_USER_ID VARCHAR2 User creating Record
100
CREATED_DATE DATE Date/Time stamp of record creation
100
SAMPLE_ID NUMBER Key to related sample method
100
AGE_STATUS VARCHAR2 historical data only
100
TOTAL_WEIGHT NUMBER Total weight for # of individuals specified in quantity
100
GONAD_WEIGHT NUMBER historical data only
100
MATURITY_STAGE_ID NUMBER Key to Maturity_Stage (UNKNOWN, IMMATURE, etc)
100
WEIGHT_UNIT_ID NUMBER Key to weight unit (KILOGRAMS, POUNDS, etc)
100
CONDITION_TYPE_ID NUMBER Key to Condition_Type (ROUND(WHOLE),HEAD OFF, etc)
100
OBS_COMMENT VARCHAR2 Comment on observation
100
LENGTH1 NUMBER The first length taken
100
LENGTH2 NUMBER The second length taken for the same individual
100
LENGTH3 NUMBER The third length taken for the same individual
100
LENGTH_UNIT_ID1 NUMBER Length 1 unit (KILOGRAM, POUND, etc)
100
LENGTH_UNIT_ID2 NUMBER Length2 unit (KILOGRAM, POUND, etc)
100
LENGTH_UNIT_ID3 NUMBER Length3 unit (KILOGRAM, POUND)
100
LENGTH_TYPE_ID1 NUMBER key to Length1 type (TOTAL_LENGTH,FORK_LENGTH, etc)
100
LENGTH_TYPE_ID2 NUMBER Key to length2 type (TOTAL_LENGTH, FORK LENGTH, etc)
100
LENGTH_TYPE_ID3 NUMBER Key to Length3 type (FORK_LENGTH, FORK_LENGTH, etc)
100
MODIFIED_BY_USER_ID VARCHAR2 User modifying record
100
MODIFIED_DATE DATE Date/Time stamp of when record was modifed
100
SPECIES_SIZE_ID NUMBER Key to species size (NO_GRADE, JUMBO, etc)
100
REPLICATE NUMBER Key to landing record in historical data
100
SAMPLE_NUMBER NUMBER Key to Sample Number in the historical data
100
LINE_NUMBER NUMBER Key to line number in historical data
100
AGE NUMBER Age of the fish, estimated for a few individuals from hard parts taken from the animal.
100
STANDARD_SPECIES_ID VARCHAR2 The key to the standard species
100
TAG_NUMBER NUMBER For insert only, used to allow values to be inserted and moved by a trigger to Observation Sample table
100
SAMPLE_TYPE_ID NUMBER For insert only, used to allow values to be inserted and moved by a trigger to Observation Sample table
100
TAG_NUMBER2 NUMBER For insert only, used to allow values to be inserted and moved by a trigger to Observation Sample table
100
SAMPLE_TYPE_ID2 NUMBER For insert only, used to allow values to be inserted and moved by a trigger to Observation Sample table
100
TAG_NUMBER3 NUMBER For insert only, used to allow values to be inserted and moved by a trigger to Observation Sample table
100
SAMPLE_TYPE_ID3 NUMBER For insert only, used to allow values to be inserted and moved by a trigger to Observation Sample table
100
GRADE_ID NUMBER Key to grade (NOT GRADED, #1 IF TUNA, etc)
100
START_LENGTH NUMBER The start of the length interval when fish are not exactly measured
100
END_LENGTH NUMBER The end of the length interval when fish are not exactly measured
100
IS_AN_EXACT_LENGTH NUMBER Was the individual measured, as opposed to falling within a length range
100
LENGTH_INCREMENT NUMBER The size of each length range, when the individual is not measured exactly
100
IS_AN_UNUSUAL_LENGTH_INCREMENT NUMBER For historical data, flags non-standard and probably erroneous length ranges

Attribute Details

ID

CC ID: 22669
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 38
Status: Active
Description:

Unique key for this record

General Data Type: NUMBER

INTERVIEW_ID

CC ID: 22670
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Status: Active
Description:

Unique key

General Data Type: NUMBER

SPECIES_CODE

CC ID: 22671
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 20
Required: Yes
Primary Key: No
Status: Active
Description:

Key to agency specific species table

General Data Type: VARCHAR2

QUANTITY

CC ID: 22672
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Status: Active
Description:

Number of individuals of this species that were weighted +/or measured

General Data Type: NUMBER

SEX

CC ID: 22673
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 5
Required: Yes
Primary Key: No
Status: Active
Description:

this could be a ORACLE constraint sex in (M/F/T/U) 'male/female/transitional/undetermined'

General Data Type: VARCHAR2

SAMPLE_METHOD_TYPE_ID

CC ID: 22674
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Status: Active
Description:

Key to Sample_Method_Type (LANDED SORTED, LANDED UNSORTED)

General Data Type: NUMBER

CREATED_BY_USER_ID

CC ID: 22675
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 20
Required: Yes
Primary Key: No
Status: Active
Description:

User creating Record

General Data Type: VARCHAR2

CREATED_DATE

CC ID: 22676
Seq. Order: 8
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Date/Time stamp of record creation

General Data Type: DATE

SAMPLE_ID

CC ID: 22677
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Key to related sample method

General Data Type: NUMBER

AGE_STATUS

CC ID: 22678
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

historical data only

General Data Type: VARCHAR2

TOTAL_WEIGHT

CC ID: 22679
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Total weight for # of individuals specified in quantity

General Data Type: NUMBER

GONAD_WEIGHT

CC ID: 22680
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

historical data only

General Data Type: NUMBER

MATURITY_STAGE_ID

CC ID: 22681
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Key to Maturity_Stage (UNKNOWN, IMMATURE, etc)

General Data Type: NUMBER

WEIGHT_UNIT_ID

CC ID: 22682
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Key to weight unit (KILOGRAMS, POUNDS, etc)

General Data Type: NUMBER

CONDITION_TYPE_ID

CC ID: 22683
Seq. Order: 15
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Key to Condition_Type (ROUND(WHOLE),HEAD OFF, etc)

General Data Type: NUMBER

OBS_COMMENT

CC ID: 22684
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

Comment on observation

General Data Type: VARCHAR2

LENGTH1

CC ID: 22685
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

The first length taken

General Data Type: NUMBER

LENGTH2

CC ID: 22686
Seq. Order: 18
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

The second length taken for the same individual

General Data Type: NUMBER

LENGTH3

CC ID: 22687
Seq. Order: 19
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

The third length taken for the same individual

General Data Type: NUMBER

LENGTH_UNIT_ID1

CC ID: 22688
Seq. Order: 20
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Length 1 unit (KILOGRAM, POUND, etc)

General Data Type: NUMBER

LENGTH_UNIT_ID2

CC ID: 22689
Seq. Order: 21
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Length2 unit (KILOGRAM, POUND, etc)

General Data Type: NUMBER

LENGTH_UNIT_ID3

CC ID: 22690
Seq. Order: 22
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Length3 unit (KILOGRAM, POUND)

General Data Type: NUMBER

LENGTH_TYPE_ID1

CC ID: 22691
Seq. Order: 23
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

key to Length1 type (TOTAL_LENGTH,FORK_LENGTH, etc)

General Data Type: NUMBER

LENGTH_TYPE_ID2

CC ID: 22692
Seq. Order: 24
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Key to length2 type (TOTAL_LENGTH, FORK LENGTH, etc)

General Data Type: NUMBER

LENGTH_TYPE_ID3

CC ID: 22693
Seq. Order: 25
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Key to Length3 type (FORK_LENGTH, FORK_LENGTH, etc)

General Data Type: NUMBER

MODIFIED_BY_USER_ID

CC ID: 22694
Seq. Order: 26
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

User modifying record

General Data Type: VARCHAR2

MODIFIED_DATE

CC ID: 22695
Seq. Order: 27
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date/Time stamp of when record was modifed

General Data Type: DATE

SPECIES_SIZE_ID

CC ID: 22696
Seq. Order: 28
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Key to species size (NO_GRADE, JUMBO, etc)

General Data Type: NUMBER

REPLICATE

CC ID: 22697
Seq. Order: 29
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Key to landing record in historical data

General Data Type: NUMBER

SAMPLE_NUMBER

CC ID: 22698
Seq. Order: 30
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Key to Sample Number in the historical data

General Data Type: NUMBER

LINE_NUMBER

CC ID: 22699
Seq. Order: 31
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Key to line number in historical data

General Data Type: NUMBER

AGE

CC ID: 22700
Seq. Order: 32
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Age of the fish, estimated for a few individuals from hard parts taken from the animal.

General Data Type: NUMBER

STANDARD_SPECIES_ID

CC ID: 22701
Seq. Order: 33
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

The key to the standard species

General Data Type: VARCHAR2

TAG_NUMBER

CC ID: 22702
Seq. Order: 34
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

For insert only, used to allow values to be inserted and moved by a trigger to Observation Sample table

General Data Type: NUMBER

SAMPLE_TYPE_ID

CC ID: 22703
Seq. Order: 35
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

For insert only, used to allow values to be inserted and moved by a trigger to Observation Sample table

General Data Type: NUMBER

TAG_NUMBER2

CC ID: 22704
Seq. Order: 36
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

For insert only, used to allow values to be inserted and moved by a trigger to Observation Sample table

General Data Type: NUMBER

SAMPLE_TYPE_ID2

CC ID: 22705
Seq. Order: 37
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

For insert only, used to allow values to be inserted and moved by a trigger to Observation Sample table

General Data Type: NUMBER

TAG_NUMBER3

CC ID: 22706
Seq. Order: 38
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

For insert only, used to allow values to be inserted and moved by a trigger to Observation Sample table

General Data Type: NUMBER

SAMPLE_TYPE_ID3

CC ID: 22707
Seq. Order: 39
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

For insert only, used to allow values to be inserted and moved by a trigger to Observation Sample table

General Data Type: NUMBER

GRADE_ID

CC ID: 22708
Seq. Order: 40
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Key to grade (NOT GRADED, #1 IF TUNA, etc)

General Data Type: NUMBER

START_LENGTH

CC ID: 22709
Seq. Order: 41
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

The start of the length interval when fish are not exactly measured

General Data Type: NUMBER

END_LENGTH

CC ID: 22710
Seq. Order: 42
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

The end of the length interval when fish are not exactly measured

General Data Type: NUMBER

IS_AN_EXACT_LENGTH

CC ID: 22711
Seq. Order: 43
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 1
Scale: 0
Status: Active
Description:

Was the individual measured, as opposed to falling within a length range

General Data Type: NUMBER

LENGTH_INCREMENT

CC ID: 22712
Seq. Order: 44
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

The size of each length range, when the individual is not measured exactly

General Data Type: NUMBER

IS_AN_UNUSUAL_LENGTH_INCREMENT

CC ID: 22713
Seq. Order: 45
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 1
Scale: 0
Status: Active
Description:

For historical data, flags non-standard and probably erroneous length ranges

General Data Type: NUMBER

Catalog Details

Catalog Item ID: 6594
GUID: gov.noaa.nmfs.inport:6594
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-12-03 10:12+0000
Metadata Record Last Modified By: Lee M Weinberger
Metadata Record Last Modified: 2021-11-04 13:14+0000
Metadata Record Published: 2021-11-04
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-11-05