Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Other: OBSERVATION_MV
Short Name: OBSERVATION_MV
Status: Completed
Abstract:

Materialized View Of Observation Table with decodes of codes

Notes:

Loaded by batch 2243, 12-05-2008 10:11

Entity Information

Entity Type: Other
Active Version?: Yes
Schema Name: TIPONLINE
Description:

Materialized View Of Observation Table with decodes of codes

Data Attributes

Note: Metadata requirements do not apply to attributes for non-tabular entities.

Attribute Summary

Rubric Score Primary Key? Name Type Description
N/A
OBS_ID NUMBER Key to Observation Table
N/A
OBS_SAMPLE_ID NUMBER Key to Observation Sample Table
N/A
OBS_INTERVIEW_ID NUMBER Link To Interview Table
N/A
OBS_SPECIES_CODE VARCHAR2 Species Code On Observation Record
N/A
OBS_AGENCY_SPC_NAME VARCHAR2 Agency Specific Species Name On Observation Record
N/A
OBS_SCIENTIFIC_NAME VARCHAR2 Scientific Name Corresponding to Agency Specific Species Name On Observation Record
N/A
OBS_SPECIES_SIZE_CODE VARCHAR2 Species Size Code On Observation Record
N/A
OBS_SPECIES_SIZE VARCHAR2 Species SIze description On Observation Record
N/A
OBS_GRADE VARCHAR2 Grade description On Observation Record
N/A
SEX VARCHAR2 Sex Recorded On Observation Record
N/A
QUANTITY NUMBER Quantity of fish taken On Observation Record
N/A
OBS_WEIGHT NUMBER Magnitude Of Weight On The Observation Record
N/A
OBS_WEIGHT_UNIT_ID VARCHAR2 Code to indicate units of weight on the observation record
N/A
OBS_WEIGHT_UNIT VARCHAR2 The actual weight unit on the observation record
N/A
OBS_WEIGHT_KG NUMBER The observation Weight in kilograms.
N/A
CONDITION_TYPE VARCHAR2 Code to indicate observed condition of animal
N/A
LENGTH1 NUMBER The magnitude Of The first length measurement
N/A
LENGTH_TYPE_CODE1 VARCHAR2 Code to indicate type of the first length measurement taken
N/A
LENGTH_TYPE1 VARCHAR2 Indcates The kind of the first length measurement Taken
N/A
LENGTH_UNIT_CODE1 VARCHAR2 Code To Indicate Length Unit of first measurment Taken
N/A
LENGTH_UNIT1 VARCHAR2 Length Unit of first measurment Taken
N/A
LENGTH1_MM NUMBER The first length Measurment in Milimeters
N/A
LENGTH2 NUMBER The magnitude Of The second length measurement
N/A
LENGTH_TYPE_CODE2 VARCHAR2 Code to indicate type of the second length measurement taken
N/A
LENGTH_TYPE2 VARCHAR2 Indcates The kind of the second length measurement Taken
N/A
LENGTH_UNIT_CODE2 VARCHAR2 Code To Indicate Length Unit of second measurment Taken
N/A
LENGTH_UNIT2 VARCHAR2 Length Unit of first measurment Taken
N/A
LENGTH2_MM NUMBER The second length Measurment in Milimeters
N/A
LENGTH3 NUMBER The magnitude Of The third length measurement
N/A
LENGTH_TYPE_CODE3 VARCHAR2 Code to indicate type of the third length measurement taken
N/A
LENGTH_TYPE3 VARCHAR2 Indcates The kind of the third length measurement Taken
N/A
LENGTH_UNIT_CODE3 VARCHAR2 Code to indicate Length Unit of thrid measurment Taken
N/A
LENGTH_UNIT3 VARCHAR2 Length Unit of third measurment Taken
N/A
LENGTH3_MM NUMBER The thrid length Measurment in Milimeters
N/A
SAMPLE_METHOD VARCHAR2 Sample Method
N/A
MATURITY_STAGE VARCHAR2 Maturity Stage
N/A
OBS_REPLICATE NUMBER Replicate Number In The Observation Table
N/A
OBS_OLD_SAMPLE_ID NUMBER Old Sample Id in the Observation Table
N/A
LINE_NUMBER NUMBER Line Number On Sample Record
N/A
START_LENGTH NUMBER Starting Length
N/A
END_LENGTH NUMBER End Length
N/A
EXACT_LENGTH VARCHAR2 Exact Length
N/A
LENGTH_INCREMENT NUMBER Incremental Increase for sampling between start and end length
N/A
UNUSUAL_LENGTH VARCHAR2 Indicates If Record is marked as having an unsually short or long length
N/A
OBS_COMMENT VARCHAR2 The comment on the observation record

Attribute Details

OBS_ID

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

Key to Observation Table

General Data Type: NUMBER

OBS_SAMPLE_ID

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

Key to Observation Sample Table

General Data Type: NUMBER

OBS_INTERVIEW_ID

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

Link To Interview Table

General Data Type: NUMBER

OBS_SPECIES_CODE

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

Species Code On Observation Record

General Data Type: VARCHAR2

OBS_AGENCY_SPC_NAME

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

Agency Specific Species Name On Observation Record

General Data Type: VARCHAR2

OBS_SCIENTIFIC_NAME

CC ID: 33314
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Scientific Name Corresponding to Agency Specific Species Name On Observation Record

General Data Type: VARCHAR2

OBS_SPECIES_SIZE_CODE

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

Species Size Code On Observation Record

General Data Type: VARCHAR2

OBS_SPECIES_SIZE

CC ID: 33316
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Species SIze description On Observation Record

General Data Type: VARCHAR2

OBS_GRADE

CC ID: 33317
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Grade description On Observation Record

General Data Type: VARCHAR2

SEX

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

Sex Recorded On Observation Record

General Data Type: VARCHAR2

QUANTITY

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

Quantity of fish taken On Observation Record

General Data Type: NUMBER

OBS_WEIGHT

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

Magnitude Of Weight On The Observation Record

General Data Type: NUMBER

OBS_WEIGHT_UNIT_ID

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

Code to indicate units of weight on the observation record

General Data Type: VARCHAR2

OBS_WEIGHT_UNIT

CC ID: 33322
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

The actual weight unit on the observation record

General Data Type: VARCHAR2

OBS_WEIGHT_KG

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

The observation Weight in kilograms.

General Data Type: NUMBER

CONDITION_TYPE

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

Code to indicate observed condition of animal

General Data Type: VARCHAR2

LENGTH1

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

The magnitude Of The first length measurement

General Data Type: NUMBER

LENGTH_TYPE_CODE1

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

Code to indicate type of the first length measurement taken

General Data Type: VARCHAR2

LENGTH_TYPE1

CC ID: 33327
Seq. Order: 19
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Indcates The kind of the first length measurement Taken

General Data Type: VARCHAR2

LENGTH_UNIT_CODE1

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

Code To Indicate Length Unit of first measurment Taken

General Data Type: VARCHAR2

LENGTH_UNIT1

CC ID: 33329
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Length Unit of first measurment Taken

General Data Type: VARCHAR2

LENGTH1_MM

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

The first length Measurment in Milimeters

General Data Type: NUMBER

LENGTH2

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

The magnitude Of The second length measurement

General Data Type: NUMBER

LENGTH_TYPE_CODE2

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

Code to indicate type of the second length measurement taken

General Data Type: VARCHAR2

LENGTH_TYPE2

CC ID: 33333
Seq. Order: 25
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Indcates The kind of the second length measurement Taken

General Data Type: VARCHAR2

LENGTH_UNIT_CODE2

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

Code To Indicate Length Unit of second measurment Taken

General Data Type: VARCHAR2

LENGTH_UNIT2

CC ID: 33335
Seq. Order: 27
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Length Unit of first measurment Taken

General Data Type: VARCHAR2

LENGTH2_MM

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

The second length Measurment in Milimeters

General Data Type: NUMBER

LENGTH3

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

The magnitude Of The third length measurement

General Data Type: NUMBER

LENGTH_TYPE_CODE3

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

Code to indicate type of the third length measurement taken

General Data Type: VARCHAR2

LENGTH_TYPE3

CC ID: 33339
Seq. Order: 31
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Indcates The kind of the third length measurement Taken

General Data Type: VARCHAR2

LENGTH_UNIT_CODE3

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

Code to indicate Length Unit of thrid measurment Taken

General Data Type: VARCHAR2

LENGTH_UNIT3

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

Length Unit of third measurment Taken

General Data Type: VARCHAR2

LENGTH3_MM

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

The thrid length Measurment in Milimeters

General Data Type: NUMBER

SAMPLE_METHOD

CC ID: 33343
Seq. Order: 35
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Sample Method

General Data Type: VARCHAR2

MATURITY_STAGE

CC ID: 33344
Seq. Order: 36
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Maturity Stage

General Data Type: VARCHAR2

OBS_REPLICATE

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

Replicate Number In The Observation Table

General Data Type: NUMBER

OBS_OLD_SAMPLE_ID

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

Old Sample Id in the Observation Table

General Data Type: NUMBER

LINE_NUMBER

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

Line Number On Sample Record

General Data Type: NUMBER

START_LENGTH

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

Starting Length

General Data Type: NUMBER

END_LENGTH

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

End Length

General Data Type: NUMBER

EXACT_LENGTH

CC ID: 33350
Seq. Order: 42
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Exact Length

General Data Type: VARCHAR2

LENGTH_INCREMENT

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

Incremental Increase for sampling between start and end length

General Data Type: NUMBER

UNUSUAL_LENGTH

CC ID: 33352
Seq. Order: 44
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Indicates If Record is marked as having an unsually short or long length

General Data Type: VARCHAR2

OBS_COMMENT

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

The comment on the observation record

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 8507
GUID: gov.noaa.nmfs.inport:8507
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2008-12-05 10:11+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