17389
View: INPORT$TABLES_VIEWS_V
INPORT$TABLES_VIEWS_V
Entity
Published / External
17195
AFSC/FMA/CAMS Data Objects
Data Set
Completed
InPort extract view. DROP after extract. Each row represents a table/view + comments needed in the InPort extract.
Loaded by batch 3994, 01-03-2013 16:38
Data View
Yes
CUST_AUTH
InPort extract view. DROP after extract. Each row represents a table/view + comments needed in the InPort extract.
1
OWNER
VARCHAR2
30
No
No
Active
VARCHAR2
2
EXTRACT_DTM
VARCHAR2
16
No
No
Active
VARCHAR2
3
OBJECT_TYPE
VARCHAR2
19
No
No
Active
VARCHAR2
4
OBJECT_NAME
VARCHAR2
30
No
No
Active
VARCHAR2
5
PARENT_OBJECT_NAME
VARCHAR2
No
No
Active
VARCHAR2
6
REQUIRED_YN
VARCHAR2
No
No
Active
VARCHAR2
7
COL_ID
NUMBER
22
No
No
Active
NUMBER
8
DATA_TYPE
VARCHAR2
No
No
Active
VARCHAR2
9
DATA_LENGTH
NUMBER
22
No
No
Active
NUMBER
10
DATA_PRECISION
CHAR
4
No
No
Active
CHAR
11
DATA_SCALE
CHAR
4
No
No
Active
CHAR
12
PRIMARY_KEY_YN
CHAR
1
No
No
Active
CHAR
13
PRIMARY_KEY_SEQ
NUMBER
22
No
No
Active
NUMBER
14
FOREIGN_KEY_YN
CHAR
1
No
No
Active
CHAR
15
FOREIGN_KEY_SEQ
NUMBER
22
No
No
38
Active
NUMBER
16
COMMENTS
VARCHAR2
4000
No
No
Active
VARCHAR2
17
REF_ENTITY
VARCHAR2
No
No
Active
VARCHAR2
gov.noaa.nmfs.inport:17389
Doug Turnbull
2013-01-03T16:38:22
SysAdmin InPortAdmin
2022-08-09T17:11:08
2018-09-20
Alaska Fisheries Science Center
AFSC
7600 Sand Point Way N.E., Building 4
Seattle
WA
98115
USA
http://www.afsc.noaa.gov
0700-1700 Pacific Time
1001
Public
No
2018-09-20
1 Year
2019-09-20