Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Area Table For The Virgin Islands Coding System

Notes:

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

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None area codes
None virgin island

Entity Information

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

Area Table For The Virgin Islands Coding System

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key ID NUMBER Virgin Islands Area Code
100
Primary Key REGION_ID NUMBER Region Id/Code
100
CREATED_BY_USER_ID VARCHAR2 Id of the creator of this record
100
STANDARD_AREA_ID NUMBER Standasrd Area Identifier/Code
100
CREATED_DATE DATE Date/Time Stamp Of Record Creation
100
MODIFIED_BY_USER_ID VARCHAR2 User modifying record
100
MODIFIED_DATE DATE Date/Time stamp f when record was last changed
100
NAME VARCHAR2 Area Name

Attribute Details

ID

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

Virgin Islands Area Code

General Data Type: NUMBER

REGION_ID

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

Region Id/Code

General Data Type: NUMBER

CREATED_BY_USER_ID

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

Id of the creator of this record

General Data Type: VARCHAR2

STANDARD_AREA_ID

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

Standasrd Area Identifier/Code

General Data Type: NUMBER

CREATED_DATE

CC ID: 23391
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

MODIFIED_BY_USER_ID

CC ID: 23392
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: 23393
Seq. Order: 7
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date/Time stamp f when record was last changed

General Data Type: DATE

NAME

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

Area Name

General Data Type: VARCHAR2

Catalog Details

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