Search Help Show/Hide Menu
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