Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Resource Evaluation and Assessment Division > Protected Species Branch > Specimen curation and analysis > Tissue Tracking > Tissue Tracking System >

Table: SAMPLOC

Entity (ENT)  |  Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:35918  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Lookup table for location codes.

Description

Lookup table for location codes.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
SAMPLOC
VARCHAR2 		location code
SAMPLOCDESC
VARCHAR2 		location description
UE
VARCHAR2 		user of entry
DE
DATE 		date of entry
UC
VARCHAR2 		user of change
DC
DATE 		date of change

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (NEFSC) for inquiries on this record.

Item Identification

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

Lookup table for location codes.
Notes:

Loaded by batch 9570, 12-12-2016 13:35

Entity Information

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

Lookup table for location codes.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key SAMPLOC VARCHAR2 location code
100
 SAMPLOCDESC VARCHAR2 location description
100
 UE VARCHAR2 user of entry
100
 DE DATE date of entry
100
 UC VARCHAR2 user of change
100
 DC DATE date of change

Attribute Details

SAMPLOC

CC ID: 362503
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
Primary Key: Yes
Status: Active
Description:

location code
General Data Type: VARCHAR2

SAMPLOCDESC

CC ID: 362504
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 150
Required: No
Primary Key: No
Status: Active
Description:

location description
General Data Type: VARCHAR2

UE

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

user of entry
General Data Type: VARCHAR2

DE

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

date of entry
General Data Type: DATE

UC

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

user of change
General Data Type: VARCHAR2

DC

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

date of change
General Data Type: DATE

Catalog Details

Catalog Item ID: 35918
GUID: gov.noaa.nmfs.inport:35918
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-12-12 13:35+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-12-12
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-12-12
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-12-12