Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Used to create a custom list by user of the species codes that the port agent excepts to see for the virgin isalnds

Notes:

Loaded by batch 2007, 12-03-2007 11:22

Entity Information

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

Used to create a custom list by user of the species codes that the port agent excepts to see for the virgin isalnds

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
USERNAME VARCHAR2 Port Agent Associated With Speies Code
100
ID VARCHAR2 Local (USVI) Species Code
100
STANDARD_SPECIES_ID VARCHAR2 Standard Species Code
100
CREATED_BY_USER_ID VARCHAR2 User creating Record
100
CREATED_DATE DATE Date/Time stamp of record creation
100
NAME VARCHAR2 Species Common Name
100
MODIFIED_BY_USER_ID VARCHAR2 User modifying record
100
MODIFIED_DATE DATE Date/Time stamp of when record was modifed
100
SCIENTIFIC_NAME VARCHAR2 Species Scientific Name

Attribute Details

USERNAME

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

Port Agent Associated With Speies Code

General Data Type: VARCHAR2

ID

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

Local (USVI) Species Code

General Data Type: VARCHAR2

STANDARD_SPECIES_ID

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

Standard Species Code

General Data Type: VARCHAR2

CREATED_BY_USER_ID

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

User creating Record

General Data Type: VARCHAR2

CREATED_DATE

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

Date/Time stamp of record creation

General Data Type: DATE

NAME

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

Species Common Name

General Data Type: VARCHAR2

MODIFIED_BY_USER_ID

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

User modifying record

General Data Type: VARCHAR2

MODIFIED_DATE

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

Date/Time stamp of when record was modifed

General Data Type: DATE

SCIENTIFIC_NAME

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

Species Scientific Name

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 6707
GUID: gov.noaa.nmfs.inport:6707
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-12-03 11:22+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