Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Materialized View Of Join Between Observation and Sample Table. Decodes of codes are supplied

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 Join Between Observation and Sample Table. Decodes of codes are supplied

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
OBSERVATION_ID NUMBER Link To Observation Table
N/A
TAG1 NUMBER First Tag Number on Record
N/A
SAMPLE_TYPE_1 VARCHAR2 Sample Type Associated With First Tag
N/A
TAG2 NUMBER Second Tag Number On Record
N/A
SAMPLE_TYPE_2 VARCHAR2 Sample Type Associated With Second Tag
N/A
TAG3 NUMBER Third Tag Number on Record
N/A
SAMPLE_TYPE3 VARCHAR2 Sample Type Associated With Third Tag

Attribute Details

OBSERVATION_ID

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

Link To Observation Table

General Data Type: NUMBER

TAG1

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

First Tag Number on Record

General Data Type: NUMBER

SAMPLE_TYPE_1

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

Sample Type Associated With First Tag

General Data Type: VARCHAR2

TAG2

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

Second Tag Number On Record

General Data Type: NUMBER

SAMPLE_TYPE_2

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

Sample Type Associated With Second Tag

General Data Type: VARCHAR2

TAG3

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

Third Tag Number on Record

General Data Type: NUMBER

SAMPLE_TYPE3

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

Sample Type Associated With Third Tag

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 8508
GUID: gov.noaa.nmfs.inport:8508
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