17387 INPORT$COLUMNS_V Entity Published / External 17195 AFSC/FMA/CAMS Data Objects Data Set Completed InPort extract view. DROP after extract. Each row represents a column defn + 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 column defn + 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 CHAR 6 No No Active CHAR 4 OBJECT_NAME VARCHAR2 30 No No Active VARCHAR2 5 PARENT_OBJECT_NAME VARCHAR2 30 Yes No Active VARCHAR2 6 REQUIRED_YN VARCHAR2 1 No No Active VARCHAR2 7 COL_ID NUMBER 22 No No Active NUMBER 8 DATA_TYPE VARCHAR2 106 No No Active VARCHAR2 9 DATA_LENGTH NUMBER 22 No No Active NUMBER 10 DATA_PRECISION VARCHAR2 4 No No Active VARCHAR2 11 DATA_SCALE VARCHAR2 4 No No Active VARCHAR2 12 PRIMARY_KEY_YN VARCHAR2 1 No No Active VARCHAR2 13 PRIMARY_KEY_SEQ NUMBER 22 No No Active NUMBER 14 FOREIGN_KEY_YN VARCHAR2 1 No No Active VARCHAR2 15 FOREIGN_KEY_SEQ NUMBER 22 No No Active NUMBER 16 COMMENTS VARCHAR2 4000 No No Active VARCHAR2 17 REF_ENTITY VARCHAR2 61 No No Active VARCHAR2 gov.noaa.nmfs.inport:17387 Doug Turnbull 2013-01-03T16:38:22 SysAdmin InPortAdmin 2022-08-09T17:11:08 2016-05-18 Alaska Fisheries Science Center AFSC 7600 Sand Point Way N.E., Building 4 Seattle WA 98115 USA https://www.afsc.noaa.gov 0700-1700 Pacific Time 1001 Public No 2016-05-18 1 Year 2017-05-18