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
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details
Summary
Abstract
Lookup table for location codes.
DescriptionLookup 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
Name | Type | Description | ||
---|---|---|---|---|
100
|
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 |