Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Audit Table For Observation data table

Notes:

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

Entity Information

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

Audit Table For Observation data table

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
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
CHANGE_DATE DATE Date Record Was Changed
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: 22458
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Status: Active
Description:

Unique key for this record

General Data Type: NUMBER

INTERVIEW_ID

CC ID: 22459
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: 22460
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: 22461
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: 22462
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: 22463
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: 22464
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: 22465
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: 22466
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: 22467
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: 22468
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: 22469
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: 22470
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: 22471
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: 22472
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: 22473
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: 22474
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: 22475
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: 22476
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: 22477
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: 22478
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: 22479
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: 22480
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: 22481
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: 22482
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: 22483
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: 22484
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: 22485
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: 22486
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: 22487
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: 22488
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: 22489
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: 22490
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: 22491
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: 22492
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: 22493
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: 22494
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: 22495
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: 22496
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: 22497
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

CHANGE_DATE

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

Date Record Was Changed

General Data Type: DATE

START_LENGTH

CC ID: 22499
Seq. Order: 42
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: 22500
Seq. Order: 43
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: 22501
Seq. Order: 44
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: 22502
Seq. Order: 45
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: 22503
Seq. Order: 46
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: 6579
GUID: gov.noaa.nmfs.inport:6579
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