Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Table Listing By Agency The Gear, Species, and Area Codes That They use

Notes:

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

Entity Information

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

Table Listing By Agency The Gear, Species, and Area Codes That They use

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key ID NUMBER Unique ID
100
NAME VARCHAR2 Agency name
100
CREATED_BY_USER_ID VARCHAR2 User creating Record
100
CREATED_DATE DATE date record created
100
GEAR_FORMAT VARCHAR2 Indicates Which Gear Format is used to validate their data
100
SPECIES_FORMAT VARCHAR2 Indicates Which Species Format is used to validate their data
100
EXPORT_DATE DATE Date the last successful export was sent to the partner agency
100
MODIFIED_DATE DATE date modified
100
MODIFIED_BY_USER_ID VARCHAR2 User modifying record
100
DESCRIPTION VARCHAR2 An optional description of the agency
100
AREA_FORMAT VARCHAR2 Indicates Which Area Format is used to validate their data
100
CODE VARCHAR2 Code
100
SHORT_NAME VARCHAR2 Mnemonic Code Fpr Agency

Attribute Details

ID

CC ID: 22793
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 38
Status: Active
Description:

Unique ID

General Data Type: NUMBER

NAME

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

Agency name

General Data Type: VARCHAR2

CREATED_BY_USER_ID

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

User creating Record

General Data Type: VARCHAR2

CREATED_DATE

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

date record created

General Data Type: DATE

GEAR_FORMAT

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

Indicates Which Gear Format is used to validate their data

General Data Type: VARCHAR2

SPECIES_FORMAT

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

Indicates Which Species Format is used to validate their data

General Data Type: VARCHAR2

EXPORT_DATE

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

Date the last successful export was sent to the partner agency

General Data Type: DATE

MODIFIED_DATE

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

date modified

General Data Type: DATE

MODIFIED_BY_USER_ID

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

User modifying record

General Data Type: VARCHAR2

DESCRIPTION

CC ID: 22802
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

An optional description of the agency

General Data Type: VARCHAR2

AREA_FORMAT

CC ID: 22803
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 10
Required: Yes
Primary Key: No
Status: Active
Description:

Indicates Which Area Format is used to validate their data

General Data Type: VARCHAR2

CODE

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

Code

General Data Type: VARCHAR2

SHORT_NAME

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

Mnemonic Code Fpr Agency

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 6607
GUID: gov.noaa.nmfs.inport:6607
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