Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Table converting OECS Gear Codes to Standard Gear Codes

Notes:

Loaded by batch 2006, 12-03-2007 10:40

Entity Information

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

Table converting OECS Gear Codes to Standard Gear Codes

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key ID VARCHAR2 Mnemonic OECS Gear Code
100
CREATED_BY_USER_ID VARCHAR2 User creating Record
100
CREATED_DATE DATE Date/Time stamp of record creation
100
NAME VARCHAR2 Gear Name
100
STANDARD_GEAR_ID VARCHAR2 Standard Gear Code
100
MODIFIED_BY_USER_ID VARCHAR2 User modifying record
100
MODIFIED_DATE DATE Date/Time stamp of when record was modifed

Attribute Details

ID

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

Mnemonic OECS Gear Code

General Data Type: VARCHAR2

CREATED_BY_USER_ID

CC ID: 23157
Seq. Order: 2
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: 23158
Seq. Order: 3
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: 23159
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Gear Name

General Data Type: VARCHAR2

STANDARD_GEAR_ID

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

Standard Gear Code

General Data Type: VARCHAR2

MODIFIED_BY_USER_ID

CC ID: 23161
Seq. Order: 6
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: 23162
Seq. Order: 7
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

Catalog Details

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