Search Help Show/Hide Menu
Metadata Rubric
83%
5 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > Custom User Authentication > AFSC/FMA/CAMS Data Objects >

View: INPORT$COLUMNS_V

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:17387  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

InPort extract view. DROP after extract. Each row represents a column defn + comments needed in the InPort extract.

Description

InPort extract view. DROP after extract. Each row represents a column defn + comments needed in the InPort extract.

Entity Information

Entity Type
Data View

Data Attribute / Type Description
OWNER
VARCHAR2
EXTRACT_DTM
VARCHAR2
OBJECT_TYPE
CHAR
OBJECT_NAME
VARCHAR2
PARENT_OBJECT_NAME
VARCHAR2
REQUIRED_YN
VARCHAR2
COL_ID
NUMBER
DATA_TYPE
VARCHAR2
DATA_LENGTH
NUMBER
DATA_PRECISION
VARCHAR2
DATA_SCALE
VARCHAR2
PRIMARY_KEY_YN
VARCHAR2
PRIMARY_KEY_SEQ
NUMBER
FOREIGN_KEY_YN
VARCHAR2
FOREIGN_KEY_SEQ
NUMBER
COMMENTS
VARCHAR2
REF_ENTITY
VARCHAR2

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (AFSC) for inquiries on this record.

Item Identification

Title: View: INPORT$COLUMNS_V
Short Name: INPORT$COLUMNS_V
Status: Completed
Abstract:

InPort extract view. DROP after extract. Each row represents a column defn + comments needed in the InPort extract.
Notes:

Loaded by batch 3994, 01-03-2013 16:38

Entity Information

Entity Type: Data View
Active Version?: Yes
Schema Name: CUST_AUTH
Description:

InPort extract view. DROP after extract. Each row represents a column defn + comments needed in the InPort extract.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
67
 OWNER VARCHAR2
67
 EXTRACT_DTM VARCHAR2
67
 OBJECT_TYPE CHAR
67
 OBJECT_NAME VARCHAR2
67
 PARENT_OBJECT_NAME VARCHAR2
67
 REQUIRED_YN VARCHAR2
67
 COL_ID NUMBER
67
 DATA_TYPE VARCHAR2
67
 DATA_LENGTH NUMBER
67
 DATA_PRECISION VARCHAR2
67
 DATA_SCALE VARCHAR2
67
 PRIMARY_KEY_YN VARCHAR2
67
 PRIMARY_KEY_SEQ NUMBER
67
 FOREIGN_KEY_YN VARCHAR2
67
 FOREIGN_KEY_SEQ NUMBER
67
 COMMENTS VARCHAR2
67
 REF_ENTITY VARCHAR2

Attribute Details

OWNER

CC ID: 84382
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

EXTRACT_DTM

CC ID: 84383
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 16
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

OBJECT_TYPE

CC ID: 84384
Seq. Order: 3
Data Storage Type: CHAR
Max Length: 6
Required: No
Primary Key: No
Status: Active
General Data Type: CHAR

OBJECT_NAME

CC ID: 84385
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

PARENT_OBJECT_NAME

CC ID: 84386
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 30
Required: Yes
Primary Key: No
Status: Active
General Data Type: VARCHAR2

REQUIRED_YN

CC ID: 84387
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

COL_ID

CC ID: 84388
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
General Data Type: NUMBER

DATA_TYPE

CC ID: 84389
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 106
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

DATA_LENGTH

CC ID: 84390
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
General Data Type: NUMBER

DATA_PRECISION

CC ID: 84391
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

DATA_SCALE

CC ID: 84392
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

PRIMARY_KEY_YN

CC ID: 84393
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

PRIMARY_KEY_SEQ

CC ID: 84394
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
General Data Type: NUMBER

FOREIGN_KEY_YN

CC ID: 84395
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

FOREIGN_KEY_SEQ

CC ID: 84396
Seq. Order: 15
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
General Data Type: NUMBER

COMMENTS

CC ID: 84397
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

REF_ENTITY

CC ID: 84398
Seq. Order: 17
Data Storage Type: VARCHAR2
Max Length: 61
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 17387
GUID: gov.noaa.nmfs.inport:17387
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2013-01-03 16:38+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-05-18
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-05-18
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-05-18