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$TABLES_VIEWS_V

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:17389  |  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 table/view + comments needed in the InPort extract.

Description

InPort extract view. DROP after extract. Each row represents a table/view + comments needed in the InPort extract.

Entity Information

Entity Type
Data View

Data Attribute / Type Description
OWNER
VARCHAR2
EXTRACT_DTM
VARCHAR2
OBJECT_TYPE
VARCHAR2
OBJECT_NAME
VARCHAR2
PARENT_OBJECT_NAME
VARCHAR2
REQUIRED_YN
VARCHAR2
COL_ID
NUMBER
DATA_TYPE
VARCHAR2
DATA_LENGTH
NUMBER
DATA_PRECISION
CHAR
DATA_SCALE
CHAR
PRIMARY_KEY_YN
CHAR
PRIMARY_KEY_SEQ
NUMBER
FOREIGN_KEY_YN
CHAR
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$TABLES_VIEWS_V
Short Name: INPORT$TABLES_VIEWS_V
Status: Completed
Abstract:

InPort extract view. DROP after extract. Each row represents a table/view + 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 table/view + 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 VARCHAR2
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 CHAR
67
 DATA_SCALE CHAR
67
 PRIMARY_KEY_YN CHAR
67
 PRIMARY_KEY_SEQ NUMBER
67
 FOREIGN_KEY_YN CHAR
67
 FOREIGN_KEY_SEQ NUMBER
67
 COMMENTS VARCHAR2
67
 REF_ENTITY VARCHAR2

Attribute Details

OWNER

CC ID: 84402
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: 84403
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: 84404
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 19
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

OBJECT_NAME

CC ID: 84405
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: 84406
Seq. Order: 5
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

REQUIRED_YN

CC ID: 84407
Seq. Order: 6
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

COL_ID

CC ID: 84408
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: 84409
Seq. Order: 8
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

DATA_LENGTH

CC ID: 84410
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: 84411
Seq. Order: 10
Data Storage Type: CHAR
Max Length: 4
Required: No
Primary Key: No
Status: Active
General Data Type: CHAR

DATA_SCALE

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

PRIMARY_KEY_YN

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

PRIMARY_KEY_SEQ

CC ID: 84414
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: 84415
Seq. Order: 14
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
General Data Type: CHAR

FOREIGN_KEY_SEQ

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

COMMENTS

CC ID: 84417
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: 84418
Seq. Order: 17
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 17389
GUID: gov.noaa.nmfs.inport:17389
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: 2018-09-20
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2018-09-20
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2019-09-20