Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Used to create a custom list by user of the standad area codes that the port agent excepts to see

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 standad area codes that the port agent excepts to see

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key USERNAME VARCHAR2 Oracle Id of Port Agent
100
Primary Key ID NUMBER DIsplayed Area Code For Agent
100
REGION_ID NUMBER Region Id/Code
100
NAME VARCHAR2 Area Name
100
STANDARD_AREA_ID NUMBER Standard Area Code

Attribute Details

USERNAME

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

Oracle Id of Port Agent

General Data Type: VARCHAR2

ID

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

DIsplayed Area Code For Agent

General Data Type: NUMBER

REGION_ID

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

Region Id/Code

General Data Type: NUMBER

NAME

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

Area Name

General Data Type: VARCHAR2

STANDARD_AREA_ID

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

Standard Area Code

General Data Type: NUMBER

Catalog Details

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