SQL> desc STORETW.ACTIVITY_GROUP_DETAIL Name Null? Type ----------------------------------------- -------- ---------------------------- FK_ACTIVITY_GROUP NUMBER FK_ACTIVITY NUMBER SOURCE_ACTGRP_UID NUMBER ACTIVITY_ID VARCHAR2(256 CHAR) FK_ORG NUMBER SQL> desc STORETW.ACTIVITY_METRIC_INDEX Name Null? Type ----------------------------------------- -------- ---------------------------- FK_ACTIVITYMETRIC NOT NULL NUMBER FK_BIO_HABITAT_INDEX NOT NULL NUMBER SQL> desc STORETW.APP_COLUMN_NAME Name Null? Type ----------------------------------------- -------- ---------------------------- ELEMENT_NAME NOT NULL VARCHAR2(255 CHAR) PRINT_NAME VARCHAR2(255 CHAR) COL_NAME NOT NULL VARCHAR2(255 CHAR) REG_REPORT_NUMBER NUMBER REG_COL_ORDER NUMBER REG_ELEMENT_DEFAULT CHAR(1 CHAR) STN_REPORT_NUMBER NUMBER STN_COL_ORDER NUMBER STN_ELEMENT_DEFAULT CHAR(1 CHAR) BIO_REPORT_NUMBER NUMBER BIO_COL_ORDER NUMBER BIO_ELEMENT_DEFAULT CHAR(1 CHAR) HAB_REPORT_NUMBER NUMBER HAB_COL_ORDER NUMBER HAB_ELEMENT_DEFAULT CHAR(1 CHAR) HELP_LINK NUMBER ALL_REPORT_NUMBER NUMBER ALL_COL_ORDER NUMBER ALL_ELEMENT_DEFAULT CHAR(1 CHAR) MET_REPORT_NUMBER NUMBER MET_COL_ORDER NUMBER MET_ELEMENT_DEFAULT CHAR(1 CHAR) IND_REPORT_NUMBER NUMBER IND_COL_ORDER NUMBER IND_ELEMENT_DEFAULT CHAR(1 CHAR) SQL> desc STORETW.BATCH_HUC_UPDATE_TEMP Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER(38) HUCTWELVEDIGITCODE VARCHAR2(12 CHAR) GENERATED_HUC CHAR(8 CHAR) SQL> desc STORETW.BIOLOGICAL_RESULT_PROJECT Name Null? Type ----------------------------------------- -------- ---------------------------- FK_PROJECT NOT NULL NUMBER(12) FK_RESULT NOT NULL NUMBER(12) SQL> desc STORETW.CHARACTERISTIC_CHARTYPE Name Null? Type ----------------------------------------- -------- ---------------------------- FK_CHARTYPE NOT NULL NUMBER FK_CHARACTERISTIC NOT NULL NUMBER SQL> desc STORETW.DI_ACTIVITY_INTENT Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER(12) ACTIVITY_INTENT NOT NULL VARCHAR2(256) SQL> desc STORETW.DI_ACTIVITY_MATRIX Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER(12) MATRIX_CODE CHAR(4) MATRIX_NAME VARCHAR2(256) MATRIX_DESCRIPTION VARCHAR2(120) SQL> desc STORETW.DI_ACTIVITY_MEDIUM Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER(12) ACTIVITY_MEDIUM VARCHAR2(20) SQL> desc STORETW.DI_BIOPART Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER(12) BIOPART_NAME NOT NULL VARCHAR2(256) SQL> desc STORETW.DI_CHARACTERISTIC Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER(12) SEARCH_NAME VARCHAR2(256 CHAR) DISPLAY_NAME VARCHAR2(256 CHAR) CHARACTERISTIC_GROUP_TYPE VARCHAR2(256 CHAR) TYPE_CODE CHAR(1) REGISTRY_NAME VARCHAR2(256 CHAR) SRS_ID NUMBER(12) CAS_NUMBER VARCHAR2(256 CHAR) ITIS_NUMBER VARCHAR2(256 CHAR) CHARTYPE VARCHAR2(256 CHAR) LAST_CHANGE_DATE DATE DESCRIPTION VARCHAR2(1000) WQX_CHR_UID NUMBER(12) FK_CHARGRPTYPE NUMBER(12) FK_CHARTYPE NUMBER(12) ITIS_PARENT VARCHAR2(256) KINGDOM_NAME VARCHAR2(256) RANK_NAME VARCHAR2(256) SQL> desc STORETW.DI_COMMUNITY_SAMPLED Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER(12) ACTIVITY_COMMUNITY NOT NULL VARCHAR2(256) ACTIVITY_COMMUNITY_DESC VARCHAR2(4000) SQL> desc STORETW.DI_DATE Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER FULL_DATE DATE DAY_OF_WEEK CHAR(9 CHAR) DAY_NUMBER_IN_MONTH NUMBER(2) DAY_NUMBER_OVERALL NUMBER(5) WEEK_NUMBER_IN_YEAR NUMBER(2) WEEK_NUMBER_OVERALL NUMBER(4) MONTH CHAR(9 CHAR) MONTH_NUMBER_OVERALL NUMBER(4) QUARTER NUMBER(1) FISCAL_PERIOD NUMBER(4) WEEKDAY_FLAG CHAR(1 CHAR) LAST_DAY_IN_MONTH_FLAG CHAR(1 CHAR) SQL> desc STORETW.DI_DB_CAT Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER(12) HYDROLOGIC_UNIT_CODE NOT NULL CHAR(8 CHAR) HYDROLOGIC_UNIT_NAME VARCHAR2(200 CHAR) GEOM MDSYS.SDO_GEOMETRY SQL> desc STORETW.DI_EPA_REGION Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER(12) EPA_REGION_CODE NOT NULL VARCHAR2(2 CHAR) EPA_REGION_NAME NOT NULL VARCHAR2(256 CHAR) SQL> desc STORETW.DI_GEO_COUNTY Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER(12) FK_GEO_STATE NUMBER(12) FIPS_COUNTY_CODE CHAR(3 CHAR) COUNTY_NAME VARCHAR2(256) GEOM MDSYS.SDO_GEOMETRY SQL> desc STORETW.DI_GEO_STATE Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER(12) FIPS_STATE_CODE NOT NULL CHAR(4) STATE_POSTAL_CODE CHAR(2 CHAR) STATE_NAME VARCHAR2(256) COUNTRY_CODE CHAR(2 CHAR) COUNTRY_NAME VARCHAR2(256) GEOM MDSYS.SDO_GEOMETRY EPA_REGION_CODE VARCHAR2(2 CHAR) EPA_REGION_NAME VARCHAR2(256 CHAR) SQL> desc STORETW.DI_GROUP_TYPE Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER(12) BIO_GROUP_TYPE NOT NULL VARCHAR2(32) SQL> desc STORETW.DI_METHOD Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NUMBER(12) METHOD_ID NOT NULL VARCHAR2(256) METHOD_SOURCE NOT NULL VARCHAR2(256) METHOD_NAME VARCHAR2(1000) METHOD_DESC VARCHAR2(4000) METHOD_QUAL_TYPE VARCHAR2(256) METHOD_TYPE VARCHAR2(256) METHOD_URL VARCHAR2(256) SOURCE_UID NUMBER(12) LAST_CHANGE_DATE VARCHAR2(256) NEMI_ID VARCHAR2(256) NEMI_SOURCE VARCHAR2(256) AMCTX_UID NUMBER(6) SQL> desc STORETW.DI_ORG Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER(12) ORGANIZATION_ID NOT NULL VARCHAR2(256) ORGANIZATION_NAME NOT NULL VARCHAR2(256) ORGANIZATION_IS_NUMBER NUMBER(20) ORGANIZATION_TYPE VARCHAR2(256 CHAR) ORGANIZATION_DESCRIPTION VARCHAR2(500) PARENT_ORG VARCHAR2(256 CHAR) LAST_CHANGE_DATE DATE SOURCE_SYSTEM VARCHAR2(256) TRIBAL_CODE VARCHAR2(256) SQL> desc STORETW.DI_ORG_TYPES Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER(12) ORGANIZATION_TYPE NOT NULL VARCHAR2(256) SORT_ORDER NUMBER SQL> desc STORETW.DI_PROJECT Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER TSMPROJ_IS_NUMBER NUMBER(12) TSMPROJ_ORG_ID VARCHAR2(256) PROJECT_CD VARCHAR2(256 CHAR) PROJECT_NAME VARCHAR2(256 CHAR) START_DATE DATE PLANNED_DURATION VARCHAR2(256 CHAR) LAST_USERID VARCHAR2(100) LAST_CHANGE_DATE DATE FK_ORG NUMBER(12) PURPOSE VARCHAR2(4000 CHAR) STUDY_AREA VARCHAR2(4000 CHAR) PROJECT_DESIGN VARCHAR2(4000 CHAR) OBTAIN_PLAN VARCHAR2(4000 CHAR) QUALITY_ASSURANCE VARCHAR2(4000 CHAR) QUALITY_OBJECTIVES VARCHAR2(4000 CHAR) BLOB_TITLE VARCHAR2(256 CHAR) BLOB_ID VARCHAR2(256) PROJECT_DESCRIPTION VARCHAR2(4000) SOURCE_SYSTEM VARCHAR2(256 CHAR) SOURCE_UID NUMBER(20) QA_APPROVAL_AGENCY VARCHAR2(256) FK_QA_AGENCY NUMBER QA_APPROVED VARCHAR2(256) SAMPLING_DESIGN_TYPE_CD VARCHAR2(256) PROJECT_POR_START DATE PROJECT_POR_END DATE LAST_TRANSACTION_ID VARCHAR2(100) SQL> desc STORETW.DI_STATN_TYPES Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER(12) PRIMARY_TYPE NOT NULL VARCHAR2(256) SECONDARY_TYPE VARCHAR2(256) SORT_ORDER NUMBER SGO_INDICATOR CHAR(1 CHAR) STATION_GROUP_TYPE VARCHAR2(256 CHAR) SQL> desc STORETW.DI_SUBJECT_TAXON Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER(12) ACTIVITY_SUBJECT_TAXON NOT NULL VARCHAR2(69) SQL> desc STORETW.DW_DATA_REQUESTS Name Null? Type ----------------------------------------- -------- ---------------------------- REQUEST_ID NUMBER REQUEST_TYPE CHAR(3 CHAR) DATETIME DATE FILESIZE_KB NUMBER F_STATE CHAR(1 CHAR) F_COUNTY CHAR(1 CHAR) F_LATLONG CHAR(1 CHAR) F_HUC CHAR(1 CHAR) F_STATIONTYPE CHAR(1 CHAR) F_CHARACTERISTIC CHAR(1 CHAR) F_ORGANIZATION CHAR(1 CHAR) F_STATION CHAR(1 CHAR) F_ACT_STARTDATE CHAR(1 CHAR) F_ACT_MEDIUM CHAR(1 CHAR) F_PROJECT CHAR(1 CHAR) F_ACT_INTENT CHAR(1 CHAR) F_COMMUNITY_SAMPLED CHAR(1 CHAR) REQUEST_MODE VARCHAR2(10 CHAR) REQUEST_STATUS VARCHAR2(10 CHAR) EMAIL_ADDRESS VARCHAR2(100 CHAR) NOTIFIED CHAR(1 CHAR) QUERY_TEXT VARCHAR2(4000 CHAR) FILENAME VARCHAR2(30 CHAR) RECORD_COUNT NUMBER RECORD_TITLE VARCHAR2(4000 CHAR) JOB_QUEUE_ID NUMBER PROCESSED_DATE DATE QUERY_TEXT2 VARCHAR2(4000 CHAR) QUERY_REPORT VARCHAR2(4000 CHAR) RQUERY_TEXT VARCHAR2(4000 CHAR) RQUERY_TEXT2 VARCHAR2(4000 CHAR) BQUERY_TEXT VARCHAR2(4000 CHAR) BQUERY_TEXT2 VARCHAR2(4000 CHAR) HQUERY_TEXT VARCHAR2(4000 CHAR) HQUERY_TEXT2 VARCHAR2(4000 CHAR) R_RECORD_TITLE VARCHAR2(4000 CHAR) B_RECORD_TITLE VARCHAR2(4000 CHAR) H_RECORD_TITLE VARCHAR2(4000 CHAR) F_CHARTYPE CHAR(1 CHAR) REG_DATA_FLAG VARCHAR2(5 CHAR) BIO_DATA_FLAG VARCHAR2(5 CHAR) HAB_DATA_FLAG VARCHAR2(5 CHAR) DATA_BY_ORG_ID VARCHAR2(4000 CHAR) FK_ORG_TYPE NUMBER(12) MQUERY_TEXT VARCHAR2(4000 CHAR) MQUERY_TEXT2 VARCHAR2(4000 CHAR) M_RECORD_TITLE VARCHAR2(4000 CHAR) MET_DATA_FLAG VARCHAR2(5 CHAR) IQUERY_TEXT VARCHAR2(4000 CHAR) IQUERY_TEXT2 VARCHAR2(4000 CHAR) I_RECORD_TITLE VARCHAR2(4000 CHAR) IND_DATA_FLAG VARCHAR2(5 CHAR) ACTGRP_DATA_FLAG VARCHAR2(5 CHAR) STNSYN_DATA_FLAG VARCHAR2(5 CHAR) PRJSTNWT_DATA_FLAG VARCHAR2(5 CHAR) FORMAT_TYPE VARCHAR2(10 CHAR) DELIMITER VARCHAR2(10 CHAR) ACTGRPQUERY_TEXT VARCHAR2(4000 CHAR) SQL> desc STORETW.FA_ACTIVITY_GROUP Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER ORGANIZATION_ID VARCHAR2(256 CHAR) ACTIVITYGROUP_ID VARCHAR2(256 CHAR) ACTIVITYGROUP_TYPE_ID VARCHAR2(256 CHAR) ACTIVITYGROUP_NAME VARCHAR2(256 CHAR) SOURCE_SYSTEM VARCHAR2(256 CHAR) SOURCE_UID NUMBER LAST_CHANGE_DATE DATE LAST_USERID VARCHAR2(100) LAST_TRANSACTION_ID VARCHAR2(100) FK_DATE_LC NUMBER(12) FK_DATE_ACTGROUP_START NUMBER(12) FK_DATE_ACTGROUP_END NUMBER(12) SQL> desc STORETW.FA_ACTIVITY_METRIC Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER ACTIVITY_ID VARCHAR2(256 CHAR) ORGANIZATION_ID VARCHAR2(256 CHAR) METRICTYPE_ID VARCHAR2(256 CHAR) ACT_METRIC_SCORE VARCHAR2(256 CHAR) ACT_METRIC_VALUE VARCHAR2(256 CHAR) ACT_METRIC_UNIT VARCHAR2(256 CHAR) ACT_METRIC_COMMENT VARCHAR2(256 CHAR) FK_ORG NUMBER(12) FK_METRICTYPE NUMBER(12) SOURCE_SYSTEM VARCHAR2(256) SOURCE_ACT_UID NUMBER SOURCE_UID NUMBER LAST_CHANGE_DATE DATE LAST_USERID VARCHAR2(100) LAST_TRANSACTION_ID VARCHAR2(100) STATION_ID VARCHAR2(256 CHAR) STATION_NAME VARCHAR2(256 CHAR) STN_LATITUDE NUMBER STN_LONGITUDE NUMBER STN_HDATUM CHAR(12 CHAR) STN_STD_LATITUDE NUMBER STN_STD_LONGITUDE NUMBER STN_STD_HDATUM CHAR(12 CHAR) HYDROLOGIC_UNIT_CODE CHAR(8 CHAR) GENERATED_HUC CHAR(8 CHAR) TRIP_NAME VARCHAR2(256 CHAR) ACTIVITY_START_DATE_TIME DATE ACT_START_TIME_ZONE VARCHAR2(5 CHAR) ACTIVITY_STOP_DATE_TIME DATE ACT_STOP_TIME_ZONE VARCHAR2(5 CHAR) ACTIVITY_MEDIUM VARCHAR2(20 CHAR) ACTIVITY_MATRIX VARCHAR2(256 CHAR) ACTIVITY_TYPE VARCHAR2(256 CHAR) ACTIVITY_CATEGORY VARCHAR2(256 CHAR) REPLICATE_NUMBER NUMBER(3) ACTIVITY_INTENT VARCHAR2(20 CHAR) ACTIVITY_COMMUNITY VARCHAR2(256 CHAR) ACTIVITY_SUBJECT_TAXON VARCHAR2(69 CHAR) LOCATION_POINT_TYPE CHAR(16 CHAR) POINT_SEQUENCE_NUMBER NUMBER POINT_NAME VARCHAR2(30 CHAR) ACTIVITY_LATITUDE NUMBER ACTIVITY_LONGITUDE NUMBER ACT_STD_LATITUDE NUMBER ACT_STD_LONGITUDE NUMBER ACT_STD_HDATUM CHAR(12 CHAR) WELL_NUMBER CHAR(15 CHAR) PIPE_NUMBER CHAR(15 CHAR) MAP_SCALE VARCHAR2(20 CHAR) ACTIVITY_DEPTH VARCHAR2(256 CHAR) ACTIVITY_DEPTH_UNIT VARCHAR2(256 CHAR) ACTIVITY_UPPER_DEPTH VARCHAR2(256 CHAR) ACTIVITY_REL_DEPTH CHAR(15 CHAR) ACTIVITY_LOWER_DEPTH VARCHAR2(256 CHAR) ACTIVITY_DEPTH_REF_POINT VARCHAR2(256 CHAR) UPR_LWR_DEPTH_UNIT VARCHAR2(256 CHAR) FIELD_PROCEDURE_ID VARCHAR2(256 CHAR) FIELD_GEAR_ID VARCHAR2(256 CHAR) METRIC_CONTEXT VARCHAR2(256 CHAR) METRIC_NAME VARCHAR2(256 CHAR) FORMULA_DESC VARCHAR2(4000 CHAR) METRIC_SCALE VARCHAR2(256 CHAR) METRIC_DETAIL_CITATION_ID VARCHAR2(256 CHAR) FISHED_DURATION CHAR(15 CHAR) BOAT_SPEED CHAR(15 CHAR) PASS_COUNT NUMBER PASS_LENGTH CHAR(10 CHAR) SAMPLING_DURATION VARCHAR2(256 CHAR) ACTIVITY_IS_NUMBER NUMBER(12) ACTIVITY_ISN NUMBER FK_STATION NUMBER(12) FK_DB_CAT NUMBER(12) FK_GEN_DB_CAT NUMBER(12) FK_GEO_COUNTY NUMBER(12) FK_GEO_STATE NUMBER(12) FK_ACT_MAD_HDATUM NUMBER(12) FK_ACT_MAD_HMETHOD NUMBER(12) FK_DATE_ACT_START NUMBER(12) FK_ACT_MEDIUM NUMBER(12) FK_ACT_MATRIX NUMBER(12) FK_ACT_INTENT NUMBER(12) FK_COMMUNITY_SAMPLED NUMBER(12) FK_GROUP_TYPE NUMBER(12) TSRUOM_ORG_ID VARCHAR2(256 CHAR) PORTABLE_DATA_LOGGER VARCHAR2(34 CHAR) FK_STN_ACT_PT NUMBER(12) FK_STATN_TYPES NUMBER(12) CONTAINER_DESC VARCHAR2(256 CHAR) TEMP_PRESERVN_TYPE VARCHAR2(25 CHAR) PRESRV_STRGE_PRCDR VARCHAR2(256 CHAR) BLOB_ID VARCHAR2(25 CHAR) BLOB_TITLE VARCHAR2(256 CHAR) ACT_BLOB_ID VARCHAR2(25 CHAR) ACT_BLOB_TITLE VARCHAR2(256 CHAR) ACTIVITY_COMMENT VARCHAR2(4000 CHAR) PROJECT_ID VARCHAR2(256 CHAR) TRIBAL_WATER_QUALITY_MEASURE CHAR(1 CHAR) ACTIVITY_COND_ORG_TEXT VARCHAR2(256 CHAR) SMPRP_TRANSPORT_STORAGE_DESC VARCHAR2(1999 CHAR) ETL_ID VARCHAR2(256 CHAR) TOW_CURRENT_SPEED VARCHAR2(256 CHAR) TOW_NET_MESH_SIZE VARCHAR2(256 CHAR) TOW_NET_SURFACE_AREA VARCHAR2(256 CHAR) NON_TOW_CURRENT_SPEED VARCHAR2(256 CHAR) NON_TOW_NET_MESH_SIZE VARCHAR2(256 CHAR) NON_TOW_NET_SURFACE_AREA VARCHAR2(256 CHAR) REACH_LENGTH VARCHAR2(256 CHAR) REACH_WIDTH VARCHAR2(256 CHAR) SAMPLE_COMPONENT_NAME VARCHAR2(256 CHAR) PLACE_IN_SERIES VARCHAR2(256 CHAR) TOXICITY_TEST_TYPE VARCHAR2(256 CHAR) HORIZONTAL_ACCURACY_MEASURE VARCHAR2(256 CHAR) LAB_ACCRED_AUTHORITY VARCHAR2(256 CHAR) SAMPLING_POINT_NAME VARCHAR2(256 CHAR) FK_DATE_LC NUMBER(12) SGO_INDICATOR CHAR(1) ORGANIZATION_IS_NUMBER VARCHAR2(10) ALL_RESULT_DETECTION_LIMIT VARCHAR2(2000 CHAR) ANALYSIS_DATE_TIME DATE ANALYSIS_TIME_ZONE VARCHAR2(256 CHAR) ANALYTICAL_METHOD_LIST_AGENCY VARCHAR2(256 CHAR) ANALYTICAL_PROCEDURE_ID VARCHAR2(256 CHAR) ANALYTICAL_PROCEDURE_SOURCE VARCHAR2(256 CHAR) BIAS VARCHAR2(256 CHAR) BIOPART_NAME VARCHAR2(30 CHAR) CAS_NUMBER VARCHAR2(500 CHAR) CELL_FORM VARCHAR2(256 CHAR) CELL_SHAPE VARCHAR2(256 CHAR) CHARACTERISTIC_DESCRIPTION VARCHAR2(256 CHAR) CHARACTERISTIC_NAME VARCHAR2(256 CHAR) COMMON_CLASS_DESC VARCHAR2(256 CHAR) CONFIDENCE_LEVEL VARCHAR2(256 CHAR) DURATION_BASIS VARCHAR2(256 CHAR) FEEDING_GROUP VARCHAR2(256 CHAR) FK_BIOPART NUMBER(12) FK_CHAR NUMBER(12) FK_UNIT_CONVERSION NUMBER(12) HABIT VARCHAR2(256 CHAR) INDIVIDUAL_NUMBER NUMBER LAB_CERTIFIED VARCHAR2(1 CHAR) LAB_NAME VARCHAR2(60 CHAR) LAB_REMARK VARCHAR2(256 CHAR) PARTICLE_SIZE VARCHAR2(40 CHAR) PHYS_BIO_INDICATOR VARCHAR2(1 CHAR) POLLUTION_TOLERANCE VARCHAR2(256 CHAR) PRECISION VARCHAR2(256 CHAR) PRIMARY_CLASS_DESC VARCHAR2(256 CHAR) RESULT_COMMENT VARCHAR2(4000 CHAR) RESULT_IS_NUMBER NUMBER(12) RESULT_MEAS_QUAL_CODE VARCHAR2(256 CHAR) RESULT_UNIT VARCHAR2(256 CHAR) RESULT_VALUE NUMBER RESULT_VALUE_STATUS VARCHAR2(12 CHAR) RESULT_VALUE_TEXT VARCHAR2(256 CHAR) RESULT_VALUE_TYPE VARCHAR2(256 CHAR) SAMPLE_FRACTION_TYPE VARCHAR2(256 CHAR) SECONDARY_CLASS_DESC VARCHAR2(256 CHAR) STATISTIC_TYPE VARCHAR2(256 CHAR) STD_UNIT VARCHAR2(240 CHAR) STD_VALUE NUMBER TEMPERATURE_BASIS_LEVEL VARCHAR2(256 CHAR) TROPHIC_LEVEL VARCHAR2(256 CHAR) VOLTINISM VARCHAR2(256 CHAR) WEIGHT_BASIS_TYPE VARCHAR2(256 CHAR) RESULT_DEPTH_ALT_REF_PT_TXT VARCHAR2(256 CHAR) RESULT_DEPTH_MEAS_VALUE VARCHAR2(256 CHAR) RESULT_DEPTH_MEAS_UNIT_CODE VARCHAR2(256 CHAR) LAB_SAMP_PRP_START_DATE_TIME DATE LAB_SAMP_PRP_START_TMZONE VARCHAR2(5 CHAR) LAB_SAMP_PRP_END_DATE_TIME DATE LAB_SAMP_PRP_END_TMZONE VARCHAR2(5 CHAR) LAB_SAMP_PRP_DILUTION_FACTOR VARCHAR2(256 CHAR) LAB_SAMP_PRP_METHOD_ID VARCHAR2(256 CHAR) LAB_SAMP_PRP_METHOD_CONTEXT VARCHAR2(256 CHAR) LAB_SAMP_PRP_METHOD_QUAL_TYPE VARCHAR2(256 CHAR) FREQUENCY_CLASS VARCHAR2(4000) LOWER_BOUND_AMOUNT NUMBER UPPER_BOUND_AMOUNT NUMBER SPECIES_ID VARCHAR2(256 CHAR) INDIVIDUAL_ID VARCHAR2(256 CHAR) POLLUTION_TOLERANCE_SCALE VARCHAR2(256) RESULT_GROUP_SUMMARY_CT_WT VARCHAR2(256 CHAR) TAXONOMIST_ACCRED_AUTHORITY VARCHAR2(256 CHAR) TAXONOMIST_ACCRED_YN VARCHAR2(1 CHAR) CONFIDENCE_INTERVAL VARCHAR2(256) LAB_ID CHAR(8 CHAR) LAB_BATCH_ID CHAR(12 CHAR) CORRECTION_INDICATOR VARCHAR2(1 CHAR) RECOVERY_INDICATOR VARCHAR2(1 CHAR) DILUTION_INDICATOR VARCHAR2(1 CHAR) TEXT_RESULT VARCHAR2(4000 CHAR) ANALYTICAL_METHOD_LIST_VER VARCHAR2(256) TAXON_DETAIL_CITATION_ID VARCHAR2(256 CHAR) FK_GEN_GEO_STATE NUMBER(12) FK_GEN_GEO_COUNTY NUMBER(12) FK_METHOD NUMBER(12) FK_CHARGRPTYPE NUMBER(12) FK_CHARTYPE NUMBER(12) TRAP_NET_COMMENT VARCHAR2(254) ANALYSIS_END_DATE_TIME DATE ANALYSIS_END_TIME_ZONE VARCHAR2(256) FIELD_PREP_PROCEDURE_ID VARCHAR2(256 CHAR) SQL> desc STORETW.FA_BIOLOGICAL_RESULT Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER ORGANIZATION_ID VARCHAR2(256) ORGANIZATION_IS_NUMBER NUMBER(20) STATION_ID VARCHAR2(256 CHAR) STATION_NAME VARCHAR2(256) STN_LATITUDE NUMBER STN_LONGITUDE NUMBER STN_HDATUM CHAR(12) STN_STD_LATITUDE NUMBER STN_STD_LONGITUDE NUMBER STN_STD_HDATUM CHAR(12) HYDROLOGIC_UNIT_CODE CHAR(8) GENERATED_HUC CHAR(8) SGO_INDICATOR CHAR(1) STATION_VISIT_ID CHAR(3) VISIT_START_DATE_TIME DATE VISIT_START_TIME_ZONE CHAR(3) VISIT_STOP_DATE_TIME DATE VISIT_STOP_TIME_ZONE CHAR(3) TRIP_ID VARCHAR2(256) TRIP_NAME VARCHAR2(256) ACTIVITY_ID VARCHAR2(256) ACTIVITY_START_DATE_TIME DATE ACT_START_TIME_ZONE VARCHAR2(256) ACTIVITY_STOP_DATE_TIME DATE ACT_STOP_TIME_ZONE VARCHAR2(256) ACTIVITY_MEDIUM VARCHAR2(20) ACTIVITY_TYPE VARCHAR2(256) ACTIVITY_CATEGORY VARCHAR2(256) REPLICATE_NUMBER NUMBER(3) ACTIVITY_INTENT VARCHAR2(20) ACTIVITY_COMMUNITY VARCHAR2(256) ACTIVITY_SUBJECT_TAXON VARCHAR2(69) BIOPART_NAME VARCHAR2(30) FIELD_SET VARCHAR2(130) LOCATION_POINT_TYPE CHAR(16) POINT_SEQUENCE_NUMBER NUMBER POINT_NAME VARCHAR2(30) ACTIVITY_LATITUDE NUMBER ACTIVITY_LONGITUDE NUMBER ACT_STD_LATITUDE NUMBER ACT_STD_LONGITUDE NUMBER ACT_STD_HDATUM CHAR(12) WELL_NUMBER CHAR(15) PIPE_NUMBER CHAR(15) MAP_SCALE VARCHAR2(20) ACTIVITY_DEPTH VARCHAR2(256) ACTIVITY_DEPTH_UNIT VARCHAR2(256) ACTIVITY_UPPER_DEPTH VARCHAR2(256) ACTIVITY_REL_DEPTH CHAR(15) ACTIVITY_LOWER_DEPTH VARCHAR2(256) UPR_LWR_DEPTH_UNIT VARCHAR2(256) FIELD_PROCEDURE_ID VARCHAR2(256) FIELD_GEAR_ID VARCHAR2(256) GEAR_CONFIG_ID VARCHAR2(256) CHARACTERISTIC_GROUP_TYPE VARCHAR2(256 CHAR) CHARACTERISTIC_NAME VARCHAR2(256 CHAR) CAS_NUMBER VARCHAR2(500) EPA_REG_NUMBER VARCHAR2(500) ITIS_NUMBER VARCHAR2(500) SAMPLE_FRACTION_TYPE VARCHAR2(256) RESULT_VALUE_TYPE VARCHAR2(256) STATISTIC_TYPE VARCHAR2(256) RESULT_VALUE_TEXT VARCHAR2(256) RESULT_VALUE NUMBER RESULT_UNIT VARCHAR2(256) STD_VALUE NUMBER STD_UNIT VARCHAR2(240) RESULT_COMMENT VARCHAR2(4000) TEXT_RESULT VARCHAR2(4000) WEIGHT_BASIS_TYPE VARCHAR2(256) TEMPERATURE_BASIS_LEVEL VARCHAR2(256) DURATION_BASIS VARCHAR2(256) PARTICLE_SIZE VARCHAR2(40) DISTANCE_MEASURE_FROM VARCHAR2(20) DISTANCE_MEASURE_TO VARCHAR2(20) ANALYTICAL_PROCEDURE_SOURCE VARCHAR2(256) ANALYTICAL_PROCEDURE_ID VARCHAR2(256) DETECTION_LIMIT VARCHAR2(25) DETECTION_LIMIT_DESCRIPTION VARCHAR2(256) LOWER_QUANTITATION_LIMIT CHAR(30 CHAR) UPPER_QUANTITATION_LIMIT CHAR(30 CHAR) LAB_REMARK VARCHAR2(256) DILUTION_INDICATOR CHAR(1) RECOVERY_INDICATOR CHAR(1) CORRECTION_INDICATOR CHAR(1) LAB_ID CHAR(8) LAB_NAME VARCHAR2(60) LAB_CERTIFIED VARCHAR2(1) LAB_BATCH_ID CHAR(12) ANALYSIS_DATE_TIME DATE ANALYSIS_TIME_ZONE VARCHAR2(256) REPLICATE_ANALYSIS_COUNT NUMBER PRECISION VARCHAR2(256) BIAS VARCHAR2(256) CONFIDENCE_LEVEL VARCHAR2(256) CONF_LVL_CORR_BIAS CHAR(1) TR_START_POINT_NAME VARCHAR2(30) TR_START_LATITUDE NUMBER TR_START_LONGITUDE NUMBER TR_START_HDATUM CHAR(12) TR_START_DEPTH CHAR(15) TR_START_STD_LATITUDE NUMBER TR_START_STD_LONGITUDE NUMBER TR_START_STD_HDATUM CHAR(12) TR_STOP_POINT_NAME VARCHAR2(30) TR_STOP_LATITUDE NUMBER TR_STOP_LONGITUDE NUMBER TR_STOP_HDATUM CHAR(12) TR_STOP_DEPTH CHAR(15) TR_STOP_STD_LATITUDE NUMBER TR_STOP_STD_LONGITUDE NUMBER TR_STOP_STD_HDATUM CHAR(12) FISHED_DURATION CHAR(15) BOAT_SPEED CHAR(15) FISHED_DISTANCE CHAR(10) REL_CURRENT_DIR NUMBER(3) REL_WIND_DIR NUMBER(3) TRAWL_COMMENT VARCHAR2(254) VOLTAGE_MEASURE NUMBER(6,3) CURRENT_TYPE_CODE CHAR(2) AMPERAGE_MEASURE NUMBER(6,3) PASS_COUNT NUMBER PASS_LENGTH CHAR(10) PULSE_RATE NUMBER(3) ELECTROSHOCK_COMMENT VARCHAR2(254) TOTAL_ENERGZD_TIME CHAR(15) SAMPLING_DURATION VARCHAR2(256) ORIENTATION_TO_CURRENT CHAR(15) TRAP_NET_COMMENT VARCHAR2(254) BIO_GROUP_ID CHAR(8) BIO_GROUP_TYPE VARCHAR2(32) BIO_GROUP_SUBJECT_TXN VARCHAR2(69) BIO_GROUP_DESCRIPTION VARCHAR2(1999) FEEDING_GROUP VARCHAR2(256) POLLUTION_TOLERANCE VARCHAR2(256) TROPHIC_LEVEL VARCHAR2(256) HABIT VARCHAR2(256) VOLTINISM VARCHAR2(256) CELL_SHAPE VARCHAR2(256) CELL_FORM VARCHAR2(256) NUMBER_IN_GROUP NUMBER BIO_GROUP_COUNT_TYPE CHAR(10) PHYS_BIO_INDICATOR CHAR(1) GROUP_DESC_SEX CHAR(15) GROUP_DESC_LIFESTAGE VARCHAR2(25) COMMON_CLASS_DESC VARCHAR2(256) PRIMARY_CLASS_DESC VARCHAR2(256) SECONDARY_CLASS_DESC VARCHAR2(256) LOWER_BOUND_AMOUNT NUMBER UPPER_BOUND_AMOUNT NUMBER BIO_RCI_UNITS CHAR(10) INDIVIDUAL_NUMBER NUMBER RESULT_VALUE_STATUS VARCHAR2(12 CHAR) ACTIVITY_IS_NUMBER NUMBER(12) RESULT_IS_NUMBER NUMBER(12) ACTIVITY_ISN NUMBER FK_ORG NUMBER(12) FK_STATION NUMBER(12) FK_CHAR NUMBER(12) FK_DB_CAT NUMBER(12) FK_GEN_DB_CAT NUMBER(12) FK_GEO_COUNTY NUMBER(12) FK_GEO_STATE NUMBER(12) FK_ACT_MAD_HDATUM NUMBER(12) FK_ACT_MAD_HMETHOD NUMBER(12) FK_DATE_ACT_START NUMBER(12) FK_ACT_MEDIUM NUMBER(12) FK_ACT_INTENT NUMBER(12) FK_COMMUNITY_SAMPLED NUMBER(12) FK_SUBJECT_TAXON NUMBER(12) FK_BIOPART NUMBER(12) FK_GROUP_TYPE NUMBER(12) FK_UNIT_CONVERSION NUMBER(12) TSRUOM_ORG_ID VARCHAR2(256) FK_STN_ACT_PT NUMBER(12) FK_STATN_TYPES NUMBER(12) LAST_USERID VARCHAR2(100) LAST_CHANGE_DATE DATE CONTAINER_DESC VARCHAR2(256) TEMP_PRESERVN_TYPE VARCHAR2(25) PRESRV_STRGE_PRCDR VARCHAR2(256 CHAR) BLOB_ID VARCHAR2(25) BLOB_TITLE VARCHAR2(256) ACT_BLOB_ID VARCHAR2(25) ACT_BLOB_TITLE VARCHAR2(256) ACTIVITY_COMMENT VARCHAR2(4000 CHAR) ACTIVITY_DEPTH_REF_POINT VARCHAR2(256) PROJECT_ID VARCHAR2(4000 CHAR) TRIBAL_WATER_QUALITY_MEASURE CHAR(1 CHAR) ACTIVITY_COND_ORG_TEXT VARCHAR2(256 CHAR) RESULT_MEAS_QUAL_CODE VARCHAR2(256 CHAR) RESULT_DEPTH_MEAS_VALUE VARCHAR2(256 CHAR) RESULT_DEPTH_MEAS_UNIT_CODE VARCHAR2(256 CHAR) RESULT_DEPTH_ALT_REF_PT_TXT VARCHAR2(256 CHAR) ANALYTICAL_METHOD_LIST_AGENCY VARCHAR2(256) ANALYTICAL_METHOD_LIST_VER VARCHAR2(256) SMPRP_TRANSPORT_STORAGE_DESC VARCHAR2(1999) SOURCE_SYSTEM VARCHAR2(256 CHAR) SOURCE_UID NUMBER(20) ETL_ID VARCHAR2(256) TOW_CURRENT_SPEED VARCHAR2(256) TOW_NET_MESH_SIZE VARCHAR2(256) TOW_NET_SURFACE_AREA VARCHAR2(256) NON_TOW_CURRENT_SPEED VARCHAR2(256) NON_TOW_NET_MESH_SIZE VARCHAR2(256) NON_TOW_NET_SURFACE_AREA VARCHAR2(256) REACH_LENGTH VARCHAR2(256) REACH_WIDTH VARCHAR2(256) SAMPLE_COMPONENT_NAME VARCHAR2(256) PLACE_IN_SERIES VARCHAR2(256) TOXICITY_TEST_TYPE VARCHAR2(256) HORIZONTAL_ACCURACY_MEASURE VARCHAR2(256) LAB_ACCRED_AUTHORITY VARCHAR2(256) SUBSTANCE_DILUTION_FACTOR VARCHAR2(256) TAXONOMIST_ACCRED_AUTHORITY VARCHAR2(256) TAXONOMIST_ACCRED_YN VARCHAR2(256) TAXON_DETAIL_CITATION_ID VARCHAR2(256) POLLUTION_TOLERANCE_SCALE VARCHAR2(256) RESULT_GROUP_SUMMARY_CT_WT VARCHAR2(256) LAB_SAMP_PRP_METHOD_ID VARCHAR2(256) LAB_SAMP_PRP_METHOD_CONTEXT VARCHAR2(256) LAB_SAMP_PRP_METHOD_QUAL_TYPE VARCHAR2(256) LAB_SAMP_PRP_START_DATE_TIME DATE LAB_SAMP_PRP_START_TMZONE VARCHAR2(256) LAB_SAMP_PRP_END_DATE_TIME DATE LAB_SAMP_PRP_END_TMZONE VARCHAR2(256) LAB_SAMP_PRP_DILUTION_FACTOR VARCHAR2(256) SAMPLING_POINT_NAME VARCHAR2(256) LAST_TRANSACTION_ID VARCHAR2(100) CHARACTERISTIC_DESCRIPTION VARCHAR2(1000) FK_DATE_LC NUMBER(12) DETECTION_LIMIT_UNIT CHAR(10) ALL_RESULT_DETECTION_LIMIT VARCHAR2(2000) FREQUENCY_CLASS VARCHAR2(4000) SPECIES_ID VARCHAR2(256 CHAR) INDIVIDUAL_ID VARCHAR2(256 CHAR) CONFIDENCE_INTERVAL VARCHAR2(256) FK_GEN_GEO_STATE NUMBER(12) FK_GEN_GEO_COUNTY NUMBER(12) FK_METHOD NUMBER(12) FK_CHARGRPTYPE NUMBER(12) FK_CHARTYPE NUMBER(12) ANALYSIS_END_DATE_TIME DATE ANALYSIS_END_TIME_ZONE VARCHAR2(256) FIELD_PREP_PROCEDURE_ID VARCHAR2(256 CHAR) SQL> desc STORETW.FA_BIO_HABITAT_INDEX Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER ORGANIZATION_ID VARCHAR2(256 CHAR) STATION_ID VARCHAR2(256 CHAR) BIOHAB_INDEX_ID VARCHAR2(256 CHAR) CALCULATED_DATE VARCHAR2(10 CHAR) QUALIFIER_CODE VARCHAR2(256 CHAR) BHI_SCORE VARCHAR2(256 CHAR) INDEXTYPE_ID VARCHAR2(256 CHAR) FK_INDEX NUMBER(12) FK_ORG NUMBER(12) FK_STATION NUMBER(12) SOURCE_SYSTEM VARCHAR2(256) SOURCE_UID NUMBER BIOHAB_INDEX_COMMENT VARCHAR2(4000) LAST_TRANSACTION_ID VARCHAR2(100 CHAR) LAST_USERID VARCHAR2(100 CHAR) LAST_CHANGE_DATE DATE INDEXTYPE_NAME VARCHAR2(256 CHAR) BIOHAB_INDEX_TYPE_SCALE VARCHAR2(256 CHAR) CITATION_ID VARCHAR2(256 CHAR) FK_DATE_LC NUMBER(12) ACTIVITY_ID VARCHAR2(256) SQL> desc STORETW.FA_BLOB Name Null? Type ----------------------------------------- -------- ---------------------------- TSMBLOB_IS_NUMBER NOT NULL NUMBER(12) TSMBLOB_ORG_ID NOT NULL VARCHAR2(256) BLOB_CONTENT NOT NULL BLOB TABLE_NAME NOT NULL VARCHAR2(256) TSMPROJ_IS_NUMBER NUMBER(12) TSMPROJ_ORG_ID VARCHAR2(256) TSRRSULT_IS_NUMBER NUMBER(12) TSRRSULT_ORG_ID VARCHAR2(256) TSMSTATN_IS_NUMBER NUMBER(12) TSMSTATN_ORG_ID VARCHAR2(256) TSRSTVST_IS_NUMBER NUMBER(12) TSRSTVST_ORG_ID VARCHAR2(256) TSRCITN_IS_NUMBER NUMBER(12) TSRCITN_ORG_ID VARCHAR2(256) TSROPPRD_IS_NUMBER NUMBER(12) TSROPPRD_ORG_ID VARCHAR2(256) D_USERID_CODE CHAR(8) D_LAST_UPDATE_TS DATE TSRFDACT_IS_NUMBER NUMBER(12) TSRFDACT_ORG_ID VARCHAR2(256) BLOB_TYPE CHAR(6) BLOB_TITLE VARCHAR2(256) ORGANIZATION_IS_NUMBER NUMBER(20) SOURCE_SYSTEM VARCHAR2(256 CHAR) SOURCE_UID NUMBER(20) SOURCE_TABLE_UID NUMBER(20) LAST_USERID VARCHAR2(100) LAST_TRANSACTION_ID VARCHAR2(100) LAST_CHANGE_DATE DATE FK_DATE_LC NUMBER(12) SQL> desc STORETW.FA_HABITAT_RESULT Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER ORGANIZATION_ID VARCHAR2(256) ORGANIZATION_IS_NUMBER NUMBER(20) STATION_ID VARCHAR2(256 CHAR) STATION_NAME VARCHAR2(256) ACTIVITY_START_DATE_TIME DATE ACT_START_TIME_ZONE VARCHAR2(256) TRIP_ID VARCHAR2(256) TRIP_NAME VARCHAR2(256) STATION_VISIT_ID CHAR(3) CHARACTERISTIC_GROUP_TYPE VARCHAR2(256 CHAR) CHARACTERISTIC_NAME VARCHAR2(256) HABITAT_CLASS_NAME VARCHAR2(30) EPA_REG_NUMBER VARCHAR2(500) RESULT_VALUE NUMBER RESULT_UNIT VARCHAR2(256) RESULT_VALUE_TEXT VARCHAR2(256) SAMPLE_FRACTION_TYPE VARCHAR2(256) RESULT_VALUE_TYPE VARCHAR2(256) STATISTIC_TYPE VARCHAR2(256) RESULT_VALUE_STATUS VARCHAR2(12 CHAR) WEIGHT_BASIS_TYPE VARCHAR2(256) TEMPERATURE_BASIS_LEVEL VARCHAR2(256) DURATION_BASIS VARCHAR2(256) ANALYTICAL_PROCEDURE_SOURCE VARCHAR2(256) ANALYTICAL_PROCEDURE_ID VARCHAR2(256) LAB_ID CHAR(8) LAB_NAME VARCHAR2(60) LAB_CERTIFIED VARCHAR2(1) LAB_BATCH_ID CHAR(12) ANALYSIS_DATE_TIME DATE ANALYSIS_TIME_ZONE VARCHAR2(256) LOWER_QUANTITATION_LIMIT CHAR(12) UPPER_QUANTITATION_LIMIT CHAR(12) DETECTION_LIMIT VARCHAR2(25) DETECTION_LIMIT_UNIT CHAR(10) DETECTION_LIMIT_DESCRIPTION VARCHAR2(256) LAB_REMARK VARCHAR2(256) DISTANCE_MEASURE_FROM VARCHAR2(20) DISTANCE_MEASURE_TO VARCHAR2(20) REPLICATE_ANALYSIS_COUNT NUMBER PRECISION VARCHAR2(256) CONFIDENCE_LEVEL VARCHAR2(256) DILUTION_INDICATOR CHAR(1) RECOVERY_INDICATOR CHAR(1) CORRECTION_INDICATOR CHAR(1) STN_LATITUDE NUMBER STN_LONGITUDE NUMBER STN_HDATUM CHAR(12) STN_STD_LATITUDE NUMBER STN_STD_LONGITUDE NUMBER STN_STD_HDATUM CHAR(12) HYDROLOGIC_UNIT_CODE CHAR(8) GENERATED_HUC CHAR(8) RESULT_IS_NUMBER NUMBER FK_STATION NUMBER(12) FK_ORG NUMBER(12) FK_DB_CAT NUMBER(12) FK_GEN_DB_CAT NUMBER(12) FK_GEO_COUNTY NUMBER(12) FK_GEO_STATE NUMBER(12) FK_DATE_ACT_START NUMBER(12) ACTIVITY_IS_NUMBER NUMBER(12) FK_CHAR NUMBER(12) FK_UNIT_CONVERSION NUMBER(12) ACTIVITY_ID VARCHAR2(256) REPLICATE_NUMBER NUMBER(3) ACTIVITY_TYPE VARCHAR2(256) ACTIVITY_CATEGORY VARCHAR2(256) LOCATION_POINT_TYPE CHAR(16) POINT_SEQUENCE_NUMBER NUMBER(5) WELL_NUMBER CHAR(15) PIPE_NUMBER CHAR(15) ACTIVITY_STOP_DATE_TIME DATE ACT_STOP_TIME_ZONE VARCHAR2(256) ACTIVITY_LATITUDE NUMBER ACTIVITY_LONGITUDE NUMBER ACT_STD_LATITUDE NUMBER ACT_STD_LONGITUDE NUMBER ACT_STD_HDATUM CHAR(12) STD_VALUE NUMBER STD_UNIT VARCHAR2(10) FK_ACT_MAD_HDATUM NUMBER(12) FK_ACT_MAD_HMETHOD NUMBER(12) ACTIVITY_ISN NUMBER VISIT_START_DATE_TIME DATE VISIT_START_TIME_ZONE CHAR(3) VISIT_STOP_DATE_TIME DATE VISIT_STOP_TIME_ZONE CHAR(3) FIELD_SET VARCHAR2(130) POINT_NAME VARCHAR2(30) SGO_INDICATOR CHAR(1) MAP_SCALE VARCHAR2(20) BIAS VARCHAR2(256) CONF_LVL_CORR_BIAS CHAR(1) RESULT_COMMENT VARCHAR2(4000) TEXT_RESULT VARCHAR2(4000) FK_STN_ACT_PT NUMBER(12) FK_STATN_TYPES NUMBER(12) LAST_USERID VARCHAR2(100) LAST_CHANGE_DATE DATE BLOB_ID VARCHAR2(25) BLOB_TITLE VARCHAR2(256) ACT_BLOB_ID VARCHAR2(25) ACT_BLOB_TITLE VARCHAR2(256) ACTIVITY_COMMENT VARCHAR2(4000 CHAR) PROJECT_ID VARCHAR2(4000 CHAR) TRIBAL_WATER_QUALITY_MEASURE CHAR(1 CHAR) ACTIVITY_COND_ORG_TEXT VARCHAR2(256 CHAR) RESULT_MEAS_QUAL_CODE VARCHAR2(256 CHAR) RESULT_DEPTH_MEAS_VALUE VARCHAR2(256 CHAR) RESULT_DEPTH_MEAS_UNIT_CODE VARCHAR2(256 CHAR) RESULT_DEPTH_ALT_REF_PT_TXT VARCHAR2(256 CHAR) ETL_ID VARCHAR2(256) ANALYTICAL_METHOD_LIST_AGENCY VARCHAR2(256) ANALYTICAL_METHOD_LIST_VER VARCHAR2(256) SMPRP_TRANSPORT_STORAGE_DESC VARCHAR2(1999) ACTIVITY_DEPTH_REF_POINT VARCHAR2(256) SOURCE_SYSTEM VARCHAR2(256 CHAR) SOURCE_UID NUMBER(20) REACH_LENGTH VARCHAR2(256) REACH_WIDTH VARCHAR2(256) SAMPLE_COMPONENT_NAME VARCHAR2(256) PLACE_IN_SERIES VARCHAR2(256) HORIZONTAL_ACCURACY_MEASURE VARCHAR2(256) LAB_ACCRED_AUTHORITY VARCHAR2(256) SAMPLING_POINT_NAME VARCHAR2(256) LAST_TRANSACTION_ID VARCHAR2(100) FK_DATE_LC NUMBER(12) ALL_RESULT_DETECTION_LIMIT VARCHAR2(2000) LAB_SAMP_PRP_START_DATE_TIME DATE LAB_SAMP_PRP_START_TMZONE VARCHAR2(5 CHAR) LAB_SAMP_PRP_END_DATE_TIME DATE LAB_SAMP_PRP_END_TMZONE VARCHAR2(5 CHAR) LAB_SAMP_PRP_DILUTION_FACTOR VARCHAR2(256 CHAR) LAB_SAMP_PRP_METHOD_ID VARCHAR2(256 CHAR) LAB_SAMP_PRP_METHOD_CONTEXT VARCHAR2(256 CHAR) LAB_SAMP_PRP_METHOD_QUAL_TYPE VARCHAR2(256 CHAR) SAMPLING_DURATION VARCHAR2(256 CHAR) CONFIDENCE_INTERVAL VARCHAR2(256) FK_GEN_GEO_STATE NUMBER(12) FK_GEN_GEO_COUNTY NUMBER(12) FK_CHARGRPTYPE NUMBER(12) FK_CHARTYPE NUMBER(12) ANALYSIS_END_DATE_TIME DATE ANALYSIS_END_TIME_ZONE VARCHAR2(256) SQL> desc STORETW.FA_REGULAR_RESULT Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER ORGANIZATION_ID VARCHAR2(256) ORGANIZATION_IS_NUMBER NUMBER(20) STATION_ID VARCHAR2(256 CHAR) STATION_NAME VARCHAR2(256) ACTIVITY_START_DATE_TIME DATE ACT_START_TIME_ZONE VARCHAR2(256) TRIP_ID VARCHAR2(256) TRIP_NAME VARCHAR2(256) STATION_VISIT_ID CHAR(3 CHAR) CHARACTERISTIC_GROUP_TYPE VARCHAR2(256 CHAR) CHARACTERISTIC_NAME VARCHAR2(256 CHAR) RESULT_VALUE NUMBER RESULT_UNIT VARCHAR2(256) RESULT_VALUE_TEXT VARCHAR2(256) SAMPLE_FRACTION_TYPE VARCHAR2(256) RESULT_VALUE_TYPE VARCHAR2(256) STATISTIC_TYPE VARCHAR2(256) RESULT_VALUE_STATUS VARCHAR2(12 CHAR) WEIGHT_BASIS_TYPE VARCHAR2(256) TEMPERATURE_BASIS_LEVEL VARCHAR2(256) DURATION_BASIS VARCHAR2(256) ANALYTICAL_PROCEDURE_SOURCE VARCHAR2(256) ANALYTICAL_PROCEDURE_ID VARCHAR2(256) LAB_ID CHAR(8 CHAR) LAB_NAME VARCHAR2(60 CHAR) LAB_CERTIFIED VARCHAR2(1) LAB_BATCH_ID CHAR(12 CHAR) ANALYSIS_DATE_TIME DATE ANALYSIS_TIME_ZONE VARCHAR2(256) LOWER_QUANTITATION_LIMIT CHAR(30 CHAR) UPPER_QUANTITATION_LIMIT CHAR(30 CHAR) DETECTION_LIMIT VARCHAR2(25 CHAR) DETECTION_LIMIT_UNIT CHAR(10 CHAR) DETECTION_LIMIT_DESCRIPTION VARCHAR2(256) LAB_REMARK VARCHAR2(256) DISTANCE_MEASURE_FROM VARCHAR2(20 CHAR) DISTANCE_MEASURE_TO VARCHAR2(20 CHAR) PARTICLE_SIZE VARCHAR2(40 CHAR) REPLICATE_ANALYSIS_COUNT NUMBER PRECISION VARCHAR2(256) CONFIDENCE_LEVEL VARCHAR2(256) DILUTION_INDICATOR CHAR(1 CHAR) RECOVERY_INDICATOR CHAR(1 CHAR) CORRECTION_INDICATOR CHAR(1 CHAR) STN_LATITUDE NUMBER STN_LONGITUDE NUMBER STN_HDATUM CHAR(12 CHAR) STN_STD_LATITUDE NUMBER STN_STD_LONGITUDE NUMBER STN_STD_HDATUM CHAR(12 CHAR) HYDROLOGIC_UNIT_CODE CHAR(8 CHAR) GENERATED_HUC CHAR(8 CHAR) RESULT_IS_NUMBER NUMBER ACTIVITY_MEDIUM VARCHAR2(20 CHAR) FK_STATION NUMBER(12) FK_ORG NUMBER(12) FK_DB_CAT NUMBER(12) FK_GEN_DB_CAT NUMBER(12) FK_GEO_COUNTY NUMBER(12) FK_GEO_STATE NUMBER(12) FK_DATE_ACT_START NUMBER(12) FK_ACT_MEDIUM NUMBER(12) FK_ACT_MATRIX NUMBER(12) ACTIVITY_IS_NUMBER NUMBER(12) FK_CHAR NUMBER(12) FK_UNIT_CONVERSION NUMBER(12) ACTIVITY_ID VARCHAR2(256) REPLICATE_NUMBER NUMBER(3) ACTIVITY_TYPE VARCHAR2(256) ACTIVITY_CATEGORY VARCHAR2(256) ACTIVITY_INTENT VARCHAR2(20 CHAR) LOCATION_POINT_TYPE CHAR(16 CHAR) POINT_SEQUENCE_NUMBER NUMBER(5) WELL_NUMBER CHAR(15 CHAR) PIPE_NUMBER CHAR(15 CHAR) ACTIVITY_STOP_DATE_TIME DATE ACT_STOP_TIME_ZONE VARCHAR2(256) ACTIVITY_REL_DEPTH CHAR(15 CHAR) ACTIVITY_DEPTH VARCHAR2(256) ACTIVITY_DEPTH_UNIT VARCHAR2(256) ACTIVITY_UPPER_DEPTH VARCHAR2(256) ACTIVITY_LOWER_DEPTH VARCHAR2(256) UPR_LWR_DEPTH_UNIT VARCHAR2(256) FIELD_PROCEDURE_ID VARCHAR2(256) GEAR_CONFIG_ID VARCHAR2(256) ACTIVITY_LATITUDE NUMBER ACTIVITY_LONGITUDE NUMBER ACT_STD_LATITUDE NUMBER ACT_STD_LONGITUDE NUMBER ACT_STD_HDATUM CHAR(12 CHAR) STD_VALUE NUMBER STD_UNIT VARCHAR2(10 CHAR) FK_ACT_MAD_HDATUM NUMBER(12) FK_ACT_MAD_HMETHOD NUMBER(12) ACTIVITY_ISN NUMBER VISIT_START_DATE_TIME DATE VISIT_START_TIME_ZONE CHAR(3 CHAR) VISIT_STOP_DATE_TIME DATE VISIT_STOP_TIME_ZONE CHAR(3 CHAR) ACTIVITY_MATRIX VARCHAR2(256) FIELD_SET VARCHAR2(130 CHAR) POINT_NAME VARCHAR2(30 CHAR) SGO_INDICATOR CHAR(1 CHAR) MAP_SCALE VARCHAR2(20 CHAR) FIELD_GEAR_ID VARCHAR2(256) BIAS VARCHAR2(256) CONF_LVL_CORR_BIAS CHAR(1 CHAR) RESULT_COMMENT VARCHAR2(4000 CHAR) TEXT_RESULT VARCHAR2(4000 CHAR) CAS_NUMBER VARCHAR2(500 CHAR) EPA_REG_NUMBER VARCHAR2(500 CHAR) ITIS_NUMBER VARCHAR2(500 CHAR) CONTAINER_DESC VARCHAR2(256) TEMP_PRESERVN_TYPE VARCHAR2(25 CHAR) PRESRV_STRGE_PRCDR VARCHAR2(256 CHAR) PORTABLE_DATA_LOGGER VARCHAR2(34 CHAR) FK_STN_ACT_PT NUMBER(12) FK_STATN_TYPES NUMBER(12) LAST_USERID VARCHAR2(100 CHAR) LAST_CHANGE_DATE DATE BLOB_ID VARCHAR2(25 CHAR) BLOB_TITLE VARCHAR2(256) ACT_BLOB_ID VARCHAR2(25 CHAR) ACT_BLOB_TITLE VARCHAR2(256) ACTIVITY_COMMENT VARCHAR2(4000 CHAR) ACTIVITY_DEPTH_REF_POINT VARCHAR2(256 CHAR) PROJECT_ID VARCHAR2(4000 CHAR) TRIBAL_WATER_QUALITY_MEASURE CHAR(1 CHAR) RESULT_MEAS_QUAL_CODE VARCHAR2(256 CHAR) ACTIVITY_COND_ORG_TEXT VARCHAR2(256 CHAR) RESULT_DEPTH_MEAS_VALUE VARCHAR2(256 CHAR) RESULT_DEPTH_MEAS_UNIT_CODE VARCHAR2(256 CHAR) RESULT_DEPTH_ALT_REF_PT_TXT VARCHAR2(256 CHAR) ANALYTICAL_METHOD_LIST_AGENCY VARCHAR2(256) ANALYTICAL_METHOD_LIST_VER VARCHAR2(256) SMPRP_TRANSPORT_STORAGE_DESC VARCHAR2(1999) SOURCE_SYSTEM VARCHAR2(256 CHAR) SOURCE_UID NUMBER(20) ETL_ID VARCHAR2(256) HORIZONTAL_ACCURACY_MEASURE VARCHAR2(256) LAB_ACCRED_AUTHORITY VARCHAR2(256) METHOD_SPECIATION VARCHAR2(256) LAB_SAMP_PRP_METHOD_ID VARCHAR2(256) LAB_SAMP_PRP_METHOD_CONTEXT VARCHAR2(256) LAB_SAMP_PRP_METHOD_QUAL_TYPE VARCHAR2(256) LAB_SAMP_PRP_START_DATE_TIME DATE LAB_SAMP_PRP_START_TMZONE VARCHAR2(256) LAB_SAMP_PRP_END_DATE_TIME DATE LAB_SAMP_PRP_END_TMZONE VARCHAR2(256) LAB_SAMP_PRP_DILUTION_FACTOR VARCHAR2(256) SAMPLING_POINT_NAME VARCHAR2(256) LAST_TRANSACTION_ID VARCHAR2(256) FK_DATE_LC NUMBER(12) ALL_RESULT_DETECTION_LIMIT VARCHAR2(2000) CONFIDENCE_INTERVAL VARCHAR2(256) FK_GEN_GEO_STATE NUMBER(12) FK_GEN_GEO_COUNTY NUMBER(12) FK_METHOD NUMBER(12) FK_CHARGRPTYPE NUMBER(12) FK_CHARTYPE NUMBER(12) ANALYSIS_END_DATE_TIME DATE ANALYSIS_END_TIME_ZONE VARCHAR2(256) FIELD_PREP_PROCEDURE_ID VARCHAR2(256 CHAR) SQL> desc STORETW.FA_STATION Name Null? Type ----------------------------------------- -------- ---------------------------- STATION_ID VARCHAR2(256) STATION_NAME VARCHAR2(256) ORGANIZATION_ID VARCHAR2(256) LOCATION_POINT_TYPE CHAR(16 CHAR) POINT_SEQUENCE_NUMBER NUMBER(4) WELL_NUMBER CHAR(15 CHAR) PIPE_NUMBER CHAR(15 CHAR) LATITUDE NUMBER(9,7) LONGITUDE NUMBER(10,7) MAP_SCALE VARCHAR2(20 CHAR) ELEVATION CHAR(15 CHAR) HYDROLOGIC_UNIT_CODE CHAR(8 CHAR) GENERATED_HUC CHAR(8 CHAR) RF1_SEGMENT_CODE VARCHAR2(3 CHAR) RF1_SEGMENT_NAME VARCHAR2(30 CHAR) RF1_MILEAGE NUMBER(5,2) ON_REACH_IND CHAR(1 CHAR) NRCS_WATERSHED_ID CHAR(8 CHAR) OTHER_ESTUARY_NAME VARCHAR2(30 CHAR) GREAT_LAKE_NAME CHAR(15 CHAR) OCEAN_NAME CHAR(14 CHAR) NATV_AMERICAN_LAND_NAME VARCHAR2(256 CHAR) FRS_KEY_IDENTIFIER VARCHAR2(36 CHAR) STATION_VISITED CHAR(3 CHAR) STATION_IS_NUMBER NUMBER(12) ORGANIZATION_IS_NUMBER NUMBER(20) STATION_GROUP_TYPE VARCHAR2(256 CHAR) SGO_INDICATOR CHAR(1 CHAR) WELL_NAME VARCHAR2(40 CHAR) NAICS_CODE VARCHAR2(30 CHAR) SPRING_TYPE_IMPROVEMENT CHAR(14 CHAR) SPRING_PERMANENCE CHAR(12 CHAR) SPRING_USGS_GEOLOGIC_UNIT VARCHAR2(100 CHAR) SPRING_OTHER_NAME VARCHAR2(120 CHAR) SPRING_USGS_LITHOLOGIC_UNIT VARCHAR2(135 CHAR) POINT_NAME VARCHAR2(30 CHAR) BLOB_TITLE VARCHAR2(60 CHAR) TSMALP_IS_NUMBER NUMBER DESCRIPTION_TEXT VARCHAR2(4000 CHAR) LAST_USERID VARCHAR2(100) LAST_CHANGE_DATE DATE PROJECT_ID CHAR(8 CHAR) TRIBAL_WATER_QUALITY_MEASURE CHAR(1 CHAR) HORIZONTAL_ACCURACY VARCHAR2(256 CHAR) FK_DB_CAT NUMBER(12) FK_GEN_DB_CAT NUMBER(12) FK_GEO_STATE NUMBER(12) FK_GEO_COUNTY NUMBER(12) FK_MAD_HMETHOD NUMBER(12) FK_MAD_HDATUM NUMBER(12) FK_MAD_VMETHOD NUMBER(12) FK_MAD_VDATUM NUMBER(12) STD_LATITUDE NUMBER(9,7) STD_LONGITUDE NUMBER(10,7) FK_STD_HDATUM NUMBER(12) FK_ORG NUMBER(12) FK_STATN_TYPES NUMBER(12) FK_ESTRY_PRIMARY NUMBER(12) FK_ESTRY_SECONDARY NUMBER(12) BLOB_ID VARCHAR2(25) FK_PRIMARY_TYPE VARCHAR2(256) FK_SECONDARY_TYPE VARCHAR2(256) FK_HORIZONTAL_DATUM VARCHAR2(254) FK_GEOPOSITIONING_METHOD VARCHAR2(254) FK_ELEVATION_DATUM VARCHAR2(254) FK_ELEVATION_METHOD VARCHAR2(254) FK_PRIMARY_ESTUARY VARCHAR2(30) FK_SECONDARY_ESTUARY VARCHAR2(30) FK_COUNTRY_CODE CHAR(2) FK_STATE_POSTAL_CODE CHAR(2) SOURCE_SYSTEM VARCHAR2(256 CHAR) SOURCE_UID NUMBER(20) GEOM MDSYS.SDO_GEOMETRY WELL_TYPE_NAME VARCHAR2(256) WELL_FORMATION_TYPE VARCHAR2(256) WELL_HOLE_DEPTH VARCHAR2(256) WELL_AQUIFER_NAME VARCHAR2(256) PK_ISN NOT NULL NUMBER(38) OBJECTID NUMBER(38) FK_GEN_GEO_STATE NUMBER(12) FK_GEN_GEO_COUNTY NUMBER(12) ELEVATION_UNIT CHAR(15 CHAR) GEN_HUCTWELVEDIGITCODE VARCHAR2(12 CHAR) WGS84_LATITUDE NUMBER(9,7) WGS84_LONGITUDE NUMBER(10,7) FK_WGS84_HDATUM NUMBER(12) LAST_TRANSACTION_ID VARCHAR2(100) FK_DATE_LC NUMBER(12) PROGRAM_INDICATOR VARCHAR2(256 CHAR) ELEVATION_BK CHAR(15 CHAR) FK_GEO_COUNTY_BK NUMBER(12) FK_GEO_STATE_BK NUMBER(12) WELL_HOLE_DEPTH_UNIT VARCHAR2(256 CHAR) TRIBAL_LAND_INDICATOR VARCHAR2(1 CHAR) HUCTWELVEDIGITCODE VARCHAR2(12 CHAR) SQL> desc STORETW.HABITAT_RESULT_PROJECT Name Null? Type ----------------------------------------- -------- ---------------------------- FK_PROJECT NOT NULL NUMBER(12) FK_RESULT NOT NULL NUMBER(12) SQL> desc STORETW.LU_CHARGRPTYPE Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NUMBER CHARACTERISTIC_GROUP_TYPE VARCHAR2(256 CHAR) DESCRIPTION VARCHAR2(4000 CHAR) SQL> desc STORETW.LU_CHARTYPE Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER CHARTYPE VARCHAR2(256 CHAR) DESCRIPTION VARCHAR2(4000 CHAR) SQL> desc STORETW.LU_CHAR_ALIAS Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NUMBER(12) FK_CHARACTERISTIC NUMBER(12) CHAR_ALIAS VARCHAR2(500) FK_CHAR_ALIAS_TYPE NUMBER(12) SQL> desc STORETW.LU_CHAR_ALIAS_TYPE Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NUMBER(12) CHAR_ALIAS_TYPE_NAME VARCHAR2(30 CHAR) CHAR_ALIAS_TYPE_CATEGORY CHAR(2 CHAR) SQL> desc STORETW.LU_ESTRY_PRIMARY Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER(12) PRIMARY_ESTUARY VARCHAR2(30 CHAR) SQL> desc STORETW.LU_ESTRY_SECONDARY Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER(12) SECONDARY_ESTUARY VARCHAR2(30 CHAR) SQL> desc STORETW.LU_EXTERNAL_REF_SCHEME Name Null? Type ----------------------------------------- -------- ---------------------------- ORGANIZATION_ID NOT NULL VARCHAR2(256) REF_SCHEME_ACRONYM NOT NULL VARCHAR2(120) REF_SCHEME_NAME NOT NULL VARCHAR2(256) DESCRIPTION_TEXT VARCHAR2(254) PK_ISN NOT NULL NUMBER SQL> desc STORETW.LU_INDEXTYPE Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER CITATION_ID VARCHAR2(256 CHAR) ORGANIZATION_ID VARCHAR2(256 CHAR) INDEXTYPE_ID VARCHAR2(256 CHAR) CONTEXT VARCHAR2(256 CHAR) NAME VARCHAR2(256 CHAR) SCALE VARCHAR2(256 CHAR) FK_ORG NUMBER(12) SQL> desc STORETW.LU_MAD_HDATUM Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER(12) ID_CODE NOT NULL CHAR(12 CHAR) HORIZONTAL_DATUM VARCHAR2(254 CHAR) SQL> desc STORETW.LU_MAD_HMETHOD Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER(12) ID_CODE NOT NULL CHAR(12 CHAR) GEOPOSITIONING_METHOD VARCHAR2(254 CHAR) SQL> desc STORETW.LU_MAD_VDATUM Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER(12) ID_CODE NOT NULL CHAR(12 CHAR) ELEVATION_DATUM VARCHAR2(254 CHAR) SQL> desc STORETW.LU_MAD_VMETHOD Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER(12) ID_CODE NOT NULL CHAR(12 CHAR) ELEVATION_METHOD VARCHAR2(254 CHAR) SQL> desc STORETW.LU_METRICTYPE Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER CITATION_ID VARCHAR2(256 CHAR) METRIC_CONTEXT VARCHAR2(256 CHAR) ORGANIZATION_ID VARCHAR2(256 CHAR) METRICTYPE_ID VARCHAR2(256 CHAR) NAME VARCHAR2(256 CHAR) FORMULA_DESC VARCHAR2(4000 CHAR) SCALE VARCHAR2(256 CHAR) FK_ORG NUMBER(12) SQL> desc STORETW.LU_ORGTYPE Name Null? Type ----------------------------------------- -------- ---------------------------- FK_ORG NOT NULL NUMBER(12) FK_ORG_TYPE NOT NULL NUMBER(12) SQL> desc STORETW.LU_QA_AGENCY Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER(12) QA_AGENCY_NAME VARCHAR2(256 CHAR) SQL> desc STORETW.LU_STATION_ALIAS Name Null? Type ----------------------------------------- -------- ---------------------------- STATION_LABEL NOT NULL VARCHAR2(256) PK_ISN NOT NULL NUMBER FK_REF_SCHEME NUMBER(12) FK_STATION NUMBER(12) SOURCE_SYSTEM VARCHAR2(256 CHAR) SOURCE_MLOC_UID NUMBER(20) SQL> desc STORETW.LU_UNIT_CONVERSION Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER(12) UOM_TYPE VARCHAR2(256 CHAR) SHORT_FORM_NAME VARCHAR2(256) DESCRIPTION_TEXT VARCHAR2(256) TARGET_UNIT VARCHAR2(256) CONVERSION_FACTOR NUMBER SQL> desc STORETW.LU_WS_SERVICE Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER WEB_SERVICE_NAME VARCHAR2(256 CHAR) SQL> desc STORETW.MD_ANALYTICAL_PROC Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER(12) ORGANIZATION_ID NOT NULL VARCHAR2(256) ANLPR_IS_NUMBER NUMBER(12) PROCEDURE_SOURCE VARCHAR2(256 CHAR) PROCEDURE_ID NOT NULL VARCHAR2(256 CHAR) PROCEDURE_NAME NOT NULL VARCHAR2(256 CHAR) CITATION VARCHAR2(4000 CHAR) EQUIPMENT_NAME VARCHAR2(256 CHAR) NATIONAL_PROC_ID VARCHAR2(256 CHAR) ORGANIZATION_IS_NUMBER NUMBER(20) FK_ORG NUMBER(12) SOURCE_SYSTEM VARCHAR2(256 CHAR) SOURCE_UID NUMBER(20) QUALIFIER_TYPE VARCHAR2(25) PROCEDURE_DESC VARCHAR2(4000) SQL> desc STORETW.MD_CITATION Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER(12) ORGANIZATION_ID NOT NULL VARCHAR2(256) CITATION_IS_NUMBER NUMBER(12) ORGANIZATION_IS_NUMBER NUMBER(20) CITATION_ID VARCHAR2(256 CHAR) TITLE VARCHAR2(1999 CHAR) AUTHOR VARCHAR2(256 CHAR) PBLSHR_ORG_NAME VARCHAR2(256 CHAR) PUBLISHING_YEAR VARCHAR2(256 CHAR) VOL_AND_PAGE VARCHAR2(4000 CHAR) REFERENCE_ID VARCHAR2(256 CHAR) COMMENTS VARCHAR2(4000 CHAR) FK_ORG NUMBER(12) SOURCE_SYSTEM VARCHAR2(256 CHAR) SOURCE_UID NUMBER(20) SQL> desc STORETW.MD_COOP Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER(12) ORGANIZATION_ID NOT NULL VARCHAR2(256) COOP_ORG_IS_NUMBER NUMBER(12) COOP_ORGANIZATION_NAME NOT NULL VARCHAR2(256 CHAR) PRIMARY_CONTACT_NAME VARCHAR2(256 CHAR) ORGANIZATION_IS_NUMBER NUMBER(20) FK_ORG NUMBER(12) SOURCE_SYSTEM VARCHAR2(256 CHAR) SOURCE_UID NUMBER(20) SQL> desc STORETW.MD_COOP_ADDRESS Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER(12) COOP_ADDR_IS_NUMBER NUMBER(12) ORGANIZATION_ID NOT NULL VARCHAR2(256) COOP_ADDR_TYPE NOT NULL VARCHAR2(256 CHAR) ADDRESS_ONE_TEXT VARCHAR2(256 CHAR) ADDRESS_TWO_TEXT VARCHAR2(256 CHAR) ADDRESS_THREE_TEXT VARCHAR2(256 CHAR) ADDRESS_FOUR_TEXT VARCHAR2(256 CHAR) COUNTRY_CODE VARCHAR2(256 CHAR) START_DATE DATE COOP_ORG_IS_NUMBER NUMBER(12) FK_COOP NUMBER(12) SOURCE_SYSTEM VARCHAR2(256 CHAR) SOURCE_UID NUMBER(20) SQL> desc STORETW.MD_COOP_EADDRESS Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER(12) COOP_EADDR_IS_NUMBER NUMBER(12) ORGANIZATION_ID NOT NULL VARCHAR2(256) COOP_EADDR_TYPE NOT NULL VARCHAR2(256 CHAR) ADDRESS_ONE_TEXT VARCHAR2(256 CHAR) ADDRESS_TWO_TEXT VARCHAR2(256 CHAR) COOP_ORG_IS_NUMBER NUMBER(12) FK_COOP NUMBER(12) SOURCE_SYSTEM VARCHAR2(256 CHAR) SOURCE_UID NUMBER(20) SQL> desc STORETW.MD_LAB Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER(12) LAB_IS_NUMBER NUMBER(12) ORGANIZATION_ID NOT NULL VARCHAR2(256) ORGANIZATION_IS_NUMBER NUMBER(20) LAB_ID VARCHAR2(256 CHAR) LAB_NAME NOT NULL VARCHAR2(256 CHAR) FK_ORG NUMBER(12) SOURCE_SYSTEM VARCHAR2(256 CHAR) SOURCE_UID NUMBER(20) SQL> desc STORETW.MD_LAB_ADDRESS Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER(12) ADDR_IS_NUMBER NUMBER(12) ORGANIZATION_ID NOT NULL VARCHAR2(256) ADDRESS_TYPE NOT NULL VARCHAR2(256 CHAR) ADDRESS_ONE_TEXT VARCHAR2(256 CHAR) ADDRESS_TWO_TEXT VARCHAR2(256 CHAR) ADDRESS_THREE_TEXT VARCHAR2(256 CHAR) ADDRESS_FOUR_TEXT VARCHAR2(256 CHAR) COUNTRY_CODE VARCHAR2(256 CHAR) START_DATE DATE LAB_IS_NUMBER NUMBER(12) FK_LAB NUMBER(12) SOURCE_SYSTEM VARCHAR2(256 CHAR) SOURCE_UID NUMBER(20) SQL> desc STORETW.MD_LAB_EADDRESS Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER(12) EADDR_IS_NUMBER NUMBER(12) ORGANIZATION_ID NOT NULL VARCHAR2(256) LAB_ADDR_TYPE NOT NULL VARCHAR2(256 CHAR) ADDRESS_ONE_TEXT NOT NULL VARCHAR2(256 CHAR) ADDRESS_TWO_TEXT VARCHAR2(256 CHAR) LAB_IS_NUMBER NUMBER(12) FK_LAB NUMBER(12) SOURCE_SYSTEM VARCHAR2(256 CHAR) SOURCE_UID NUMBER(20) SQL> desc STORETW.MD_LAB_SAMPLE_PREP_PROCEDURE Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER(12) ORGANIZATION_ID NOT NULL VARCHAR2(256) LSPP_IS_NUMBER NUMBER(12) LSPP_SOURCE VARCHAR2(256 CHAR) PROCEDURE_ID NOT NULL VARCHAR2(256 CHAR) PROCEDURE_NAME NOT NULL VARCHAR2(256 CHAR) CITATION VARCHAR2(4000 CHAR) ORGANIZATION_IS_NUMBER NUMBER(20) FK_ORG NUMBER(12) SOURCE_SYSTEM VARCHAR2(256 CHAR) SOURCE_UID NUMBER(20) SQL> desc STORETW.MD_ORG_ADDRESS Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER(12) ORGANIZATION_ID NOT NULL VARCHAR2(256) ADDR_IS_NUMBER NUMBER(12) ORGANIZATION_IS_NUMBER NUMBER(20) ADDRESS_TYPE NOT NULL VARCHAR2(256 CHAR) ADDR_ONE_TEXT VARCHAR2(256 CHAR) ADDR_TWO_TEXT VARCHAR2(256 CHAR) ADDR_THREE_TEXT VARCHAR2(256 CHAR) ADDR_FOUR_TEXT VARCHAR2(256 CHAR) COUNTRY_CODE VARCHAR2(256 CHAR) START_DATE DATE FK_ORG NUMBER(12) SOURCE_SYSTEM VARCHAR2(256 CHAR) SOURCE_UID NUMBER(20) SQL> desc STORETW.MD_ORG_EADDRESS Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER(12) EADDR_IS_NUMBER NUMBER(12) ORGANIZATION_ID NOT NULL VARCHAR2(256) ORGANIZATION_IS_NUMBER NUMBER(20) ADDRESS_TYPE NOT NULL VARCHAR2(256 CHAR) ADDRESS_ONE_TEXT NOT NULL VARCHAR2(256 CHAR) ADDRESS_TWO_TEXT VARCHAR2(256 CHAR) FK_ORG NUMBER(12) SOURCE_SYSTEM VARCHAR2(256 CHAR) SOURCE_UID NUMBER(20) SOURCE_ORGPH_UID NUMBER(20) SQL> desc STORETW.MD_PROGRAM Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER(12) ORGANIZATION_ID NOT NULL VARCHAR2(256) PROGRAM_IS_NUMBER NUMBER(12) PROGRAM_TYPE NOT NULL VARCHAR2(256 CHAR) PROGRAM_NAME NOT NULL VARCHAR2(256 CHAR) DESCRIPTION VARCHAR2(4000 CHAR) ORGANIZATION_IS_NUMBER NUMBER(20) PROJECT_ID NOT NULL VARCHAR2(256 CHAR) PROJECT_NAME NOT NULL VARCHAR2(256 CHAR) FK_ORG NUMBER(12) SOURCE_SYSTEM VARCHAR2(256 CHAR) SOURCE_UID NUMBER(20) SQL> desc STORETW.MD_SAMPLE_GEAR Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER(12) ORGANIZATION_ID NOT NULL VARCHAR2(256) ORGANIZATION_IS_NUMBER NUMBER(20) GEAR_GROUP_NAME VARCHAR2(256 CHAR) FIELD_GEAR_ID VARCHAR2(256 CHAR) GEAR_NAME VARCHAR2(256 CHAR) CONFIG_ID VARCHAR2(256 CHAR) CONFIG_NAME VARCHAR2(256 CHAR) SPECIFICATION_TEXT VARCHAR2(4000 CHAR) FK_ORG NUMBER(12) SOURCE_SYSTEM VARCHAR2(256 CHAR) SOURCE_UID NUMBER(20) SQL> desc STORETW.MD_SAMPLE_PRESRV Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER(12) ORGANIZATION_ID NOT NULL VARCHAR2(256) SDP_ORGANIZATION_IS_NUMBER NUMBER(12) ORGANIZATION_IS_NUMBER NUMBER(20) SAMPLE_ID VARCHAR2(256 CHAR) SAMPLE_NAME VARCHAR2(256 CHAR) CONTAINER_TYPE VARCHAR2(256 CHAR) CONTAINER_COLOR VARCHAR2(256 CHAR) CONTAINER_SIZE NUMBER(6,2) CONTAINER_SIZE_UNIT VARCHAR2(256 CHAR) TEMP_PRESERVATION VARCHAR2(256 CHAR) PRESRV_DESC VARCHAR2(1999 CHAR) FK_ORG NUMBER(12) SOURCE_SYSTEM VARCHAR2(256 CHAR) SOURCE_UID NUMBER(20) SQL> desc STORETW.MD_SAMPLE_PROC Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER(12) ORGANIZATION_ID NOT NULL VARCHAR2(256) FLDPR_IS_NUMBER NUMBER(12) PROCEDURE_ID NOT NULL VARCHAR2(256 CHAR) PROCEDURE_NAME VARCHAR2(256 CHAR) GEAR_GP_NAME VARCHAR2(256 CHAR) DESCRIPTION VARCHAR2(4000 CHAR) CITATION VARCHAR2(4000 CHAR) ORGANIZATION_IS_NUMBER NUMBER(20) FK_ORG NUMBER(12) SOURCE_SYSTEM VARCHAR2(256 CHAR) SOURCE_UID NUMBER(20) PROCEDURE_QUAL_TYPE VARCHAR2(256 CHAR) SQL> desc STORETW.METRIC_RESULT_PROJECT Name Null? Type ----------------------------------------- -------- ---------------------------- FK_PROJECT NOT NULL NUMBER(12) FK_RESULT NOT NULL NUMBER(12) SQL> desc STORETW.MT_ATTRIBUTE_MAP Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER MAPPING_FIELD VARCHAR2(256 CHAR) STORET_NAME VARCHAR2(256 CHAR) STORET_NAME2 VARCHAR2(256 CHAR) WQX_NAME VARCHAR2(256 CHAR) WQX_NAME2 VARCHAR2(256 CHAR) SORT_ORDER NUMBER STATUS CHAR(1 CHAR) ATTR_1 VARCHAR2(256 CHAR) ATTR_2 VARCHAR2(256 CHAR) ATTR_3 VARCHAR2(256 CHAR) ATTR_DESCRIPTION VARCHAR2(1000 CHAR) SQL> desc STORETW.MT_CHAR_CHARTYPE Name Null? Type ----------------------------------------- -------- ---------------------------- CHAR_NAME VARCHAR2(256 CHAR) FK_CHARTYPE NUMBER CHARTYPE VARCHAR2(256 CHAR) CHARACTERISTIC_GROUP_TYPE VARCHAR2(256 CHAR) SQL> desc STORETW.MT_OBJECT_DDL_WQX_ETL Name Null? Type ----------------------------------------- -------- ---------------------------- TABLE_NAME VARCHAR2(30) OBJECT_NAME VARCHAR2(30) OBJECT_TYPE VARCHAR2(30) OBJECT_DDL CLOB DDL_GEN_DATE DATE OBJECT_DELETE_STATUS VARCHAR2(30) OBJECT_DROP_DATE DATE OBJECT_CREATE_STATUS VARCHAR2(30) OBJECT_CREATE_DATE DATE SQL> desc STORETW.MT_PROD_OBJECTS Name Null? Type ----------------------------------------- -------- ---------------------------- ONAME NOT NULL VARCHAR2(256) OTYPE NOT NULL VARCHAR2(256) OWNER NOT NULL VARCHAR2(256) PRE_ETL VARCHAR2(15) PRE_PROD VARCHAR2(15) COMMENT_DESC VARCHAR2(4000) SQL> desc STORETW.MT_WH_CONFIG Name Null? Type ----------------------------------------- -------- ---------------------------- PARAMETER_NAME NOT NULL VARCHAR2(256) PARAMETER_VALUE VARCHAR2(256) APPLICATION VARCHAR2(256) DESCRIPTION VARCHAR2(4000) SQL> desc STORETW.MV_REGULAR_RESULT_ALL Name Null? Type ----------------------------------------- -------- ---------------------------- COUNT_ALL NUMBER SQL> desc STORETW.MV_REGULAR_RESULT_CHAR Name Null? Type ----------------------------------------- -------- ---------------------------- FK_CHAR NUMBER(12) COUNT(PK_ISN) NUMBER SQL> desc STORETW.MV_REGULAR_RESULT_CHAR_COUNTY Name Null? Type ----------------------------------------- -------- ---------------------------- FK_CHAR NUMBER(12) FK_GEO_COUNTY NUMBER(12) COUNT(PK_ISN) NUMBER SQL> desc STORETW.MV_REGULAR_RESULT_CHAR_STATE Name Null? Type ----------------------------------------- -------- ---------------------------- FK_CHAR NUMBER(12) FK_GEO_STATE NUMBER(12) COUNT(PK_ISN) NUMBER SQL> desc STORETW.MV_REGULAR_RESULT_COUNTY Name Null? Type ----------------------------------------- -------- ---------------------------- FK_GEO_COUNTY NUMBER(12) COUNT(PK_ISN) NUMBER SQL> desc STORETW.MV_REGULAR_RESULT_PROJECT Name Null? Type ----------------------------------------- -------- ---------------------------- FK_PROJECT NUMBER(12) COUNT(RE.PK_ISN) NUMBER SQL> desc STORETW.MV_REGULAR_RESULT_PROJECT_CHAR Name Null? Type ----------------------------------------- -------- ---------------------------- FK_PROJECT NUMBER(12) FK_CHAR NUMBER(12) COUNT(RE.PK_ISN) NUMBER SQL> desc STORETW.MV_REGULAR_RESULT_STATE Name Null? Type ----------------------------------------- -------- ---------------------------- FK_GEO_STATE NUMBER(12) COUNT(PK_ISN) NUMBER SQL> desc STORETW.POST_ETL_EXECUTION_METRIC Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER(12) FK_PETL_EXEC_STATUS NOT NULL NUMBER(12) RUN_STATUS NOT NULL VARCHAR2(30 CHAR) START_DATE NOT NULL DATE END_DATE NOT NULL DATE RECORD_COUNT NUMBER COMMENTS VARCHAR2(4000 CHAR) SQL> desc STORETW.POST_ETL_EXECUTION_STATUS Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER(12) PROCEDURE_NAME NOT NULL VARCHAR2(30 CHAR) RUN_STATUS NOT NULL VARCHAR2(30 CHAR) CURRENT_START_DATE DATE CURRENT_END_DATE DATE LAST_START_DATE DATE LAST_END_DATE DATE SQL> desc STORETW.POST_ETL_RESULT_SYNC Name Null? Type ----------------------------------------- -------- ---------------------------- SRC_TABLE NOT NULL VARCHAR2(30 CHAR) SRC_COLUMN NOT NULL VARCHAR2(30 CHAR) DEST_TABLE NOT NULL VARCHAR2(30 CHAR) DEST_COLUMN NOT NULL VARCHAR2(30 CHAR) STATUS NOT NULL VARCHAR2(1 CHAR) PROCESSED NOT NULL NUMBER(12) ERR VARCHAR2(4000 CHAR) CURRENT_START_DATE DATE CURRENT_END_DATE DATE LAST_START_DATE NOT NULL DATE LAST_END_DATE NOT NULL DATE SQL> desc STORETW.POST_ETL_RESULT_SYNC_CONTROL Name Null? Type ----------------------------------------- -------- ---------------------------- DAY_OF_WEEK NOT NULL VARCHAR2(3 CHAR) START_HH24 NOT NULL VARCHAR2(2 CHAR) END_HH24 NOT NULL VARCHAR2(2 CHAR) SQL> desc STORETW.REGULAR_RESULT_PROJECT Name Null? Type ----------------------------------------- -------- ---------------------------- FK_PROJECT NOT NULL NUMBER(12) FK_RESULT NOT NULL NUMBER(12) SQL> desc STORETW.SEQ_GEN Name Null? Type ----------------------------------------- -------- ---------------------------- SEQUENCE_NAME VARCHAR2(128) TABLE_NAME VARCHAR2(50 CHAR) MAX_NUMBER NUMBER SEQ_CR_STMT VARCHAR2(2000 CHAR) SEQ_GEN_FLAG CHAR(1 CHAR) COLUMN_NAME VARCHAR2(100 CHAR) SEQ_CUR_VALUE NUMBER SEQ_NEW_VALUE NUMBER SQL> desc STORETW.STATE_CHAR_YEAR Name Null? Type ----------------------------------------- -------- ---------------------------- FK_CHAR NOT NULL NUMBER(12) FK_GEN_GEO_STATE NOT NULL NUMBER(12) STATE_NAME VARCHAR2(256) DISPLAY_NAME VARCHAR2(256 CHAR) REGULAR_COUNT NUMBER HABITAT_COUNT NUMBER BIOLOGICAL_COUNT NUMBER METRIC_COUNT NUMBER INDEX_COUNT NUMBER ACT_START_YEAR_DATE NOT NULL NUMBER(4) RESULT_COUNT NOT NULL NUMBER SQL> desc STORETW.STATE_ORG_CHAR_YEAR Name Null? Type ----------------------------------------- -------- ---------------------------- FK_CHAR NOT NULL NUMBER(12) FK_ORG NOT NULL NUMBER(12) FK_GEN_GEO_STATE NOT NULL NUMBER(12) STATE_NAME VARCHAR2(256) ORGANIZATION_ID VARCHAR2(256) DISPLAY_NAME VARCHAR2(256 CHAR) REGULAR_COUNT NUMBER HABITAT_COUNT NUMBER BIOLOGICAL_COUNT NUMBER METRIC_COUNT NUMBER INDEX_COUNT NUMBER ACT_START_YEAR_DATE NOT NULL NUMBER(4) RESULT_COUNT NOT NULL NUMBER SQL> desc STORETW.STATE_ORG_YEAR Name Null? Type ----------------------------------------- -------- ---------------------------- FK_ORG NOT NULL NUMBER(12) FK_GEN_GEO_STATE NOT NULL NUMBER(12) STATE_NAME VARCHAR2(256) ORGANIZATION_ID VARCHAR2(256) REGULAR_COUNT NUMBER HABITAT_COUNT NUMBER BIOLOGICAL_COUNT NUMBER METRIC_COUNT NUMBER INDEX_COUNT NUMBER ACT_START_YEAR_DATE NOT NULL NUMBER(4) RESULT_COUNT NOT NULL NUMBER SQL> desc STORETW.STATE_YEAR Name Null? Type ----------------------------------------- -------- ---------------------------- FK_GEN_GEO_STATE NOT NULL NUMBER(12) STATE_NAME VARCHAR2(256) REGULAR_COUNT NUMBER HABITAT_COUNT NUMBER BIOLOGICAL_COUNT NUMBER METRIC_COUNT NUMBER INDEX_COUNT NUMBER ACT_START_YEAR_DATE NOT NULL NUMBER(4) RESULT_COUNT NOT NULL NUMBER SQL> desc STORETW.STATION_CHAR Name Null? Type ----------------------------------------- -------- ---------------------------- FK_CHAR NUMBER(12) FK_FA_STATN NUMBER HYDROLOGIC_UNIT_CODE CHAR(8 CHAR) ORGANIZATION_ID VARCHAR2(256) STATION_ID VARCHAR2(256) STATION_NAME VARCHAR2(256) DISPLAY_NAME VARCHAR2(256 CHAR) SEARCH_NAME VARCHAR2(256 CHAR) CHAR_TYPE_CODE CHAR(1) REGULAR_COUNT NUMBER BIOLOGICAL_COUNT NUMBER HABITAT_COUNT NUMBER ACT_MIN_START_DATE DATE ACT_MAX_START_DATE DATE ACT_MAX_START_STOP_DATE DATE RESULT_COUNT NUMBER TRIBAL_WATER_QUALITY_MEASURE CHAR(1 CHAR) RSLT_MIN_VALUE_MEASURE NUMBER RSLT_MAX_VALUE_MEASURE NUMBER RSLT_AVG_VALUE_MEASURE NUMBER RSLT_MEASURE_UNIT VARCHAR2(10 CHAR) STN_STD_LATITUDE NUMBER STN_STD_LONGITUDE NUMBER ORGANIZATION_NAME VARCHAR2(256 CHAR) METRIC_COUNT NUMBER SQL> desc STORETW.STATION_CHAR_MEDIUM Name Null? Type ----------------------------------------- -------- ---------------------------- FK_CHAR NUMBER(12) FK_ACT_MEDIUM NUMBER(12) FK_FA_STATN NUMBER(12) FK_ORG NUMBER(12) FK_GEN_DB_CAT NUMBER(12) HYDROLOGIC_UNIT_CODE CHAR(8 CHAR) ORGANIZATION_ID VARCHAR2(256) STATION_ID VARCHAR2(256 CHAR) STATION_NAME VARCHAR2(256) DISPLAY_NAME VARCHAR2(256 CHAR) SEARCH_NAME VARCHAR2(256 CHAR) CHAR_TYPE_CODE CHAR(1) REGULAR_COUNT NUMBER BIOLOGICAL_COUNT NUMBER HABITAT_COUNT NUMBER ACT_MIN_START_DATE DATE ACT_MAX_START_DATE DATE ACT_MAX_START_STOP_DATE DATE RESULT_COUNT NUMBER CHARTYPE VARCHAR2(256 CHAR) RSLT_MIN_VALUE_MEASURE NUMBER RSLT_MAX_VALUE_MEASURE NUMBER RSLT_AVG_VALUE_MEASURE NUMBER RSLT_MEASURE_UNIT VARCHAR2(10 CHAR) LAST_CHANGE_DATE DATE FK_DATE_ACT_MIN_START NUMBER(12) FK_DATE_ACT_MAX_START NUMBER(12) FK_CHARGRPTYPE NUMBER(12) FK_CHARTYPE NUMBER(12) METRIC_COUNT NUMBER SQL> desc STORETW.STATION_CHAR_PROJECT Name Null? Type ----------------------------------------- -------- ---------------------------- FK_STATION NUMBER(12) FK_CHAR NUMBER(12) FK_PROJECT NUMBER(12) FK_ORG NUMBER(12) FK_GEN_DB_CAT NUMBER(12) RESULT_COUNT NUMBER REGULAR_COUNT NUMBER BIOLOGICAL_COUNT NUMBER HABITAT_COUNT NUMBER STATION_ID VARCHAR2(256 CHAR) STATION_NAME VARCHAR2(256 CHAR) STN_STD_LATITUDE NUMBER STN_STD_LONGITUDE NUMBER CHARTYPE VARCHAR2(256 CHAR) CHARACTERISTIC_NAME VARCHAR2(256 CHAR) PROJECT_CD VARCHAR2(256 CHAR) PROJECT_NAME VARCHAR2(256 CHAR) PROJECT_POR_START DATE PROJECT_POR_END DATE ORGANIZATION_ID VARCHAR2(256 CHAR) ORGANIZATION_NAME VARCHAR2(256 CHAR) HYDROLOGIC_UNIT_CODE VARCHAR2(8 CHAR) METRIC_COUNT NUMBER SQL> desc STORETW.STATION_CHAR_YEAR Name Null? Type ----------------------------------------- -------- ---------------------------- FK_CHAR NOT NULL NUMBER(12) FK_FA_STATN NOT NULL NUMBER(12) FK_ORG NUMBER(12) FK_GEN_GEO_STATE NUMBER(12) FK_GEN_GEO_COUNTY NUMBER(12) FK_GEN_DB_CAT NUMBER(12) STATE_NAME VARCHAR2(256) ORGANIZATION_ID VARCHAR2(256) STATION_ID VARCHAR2(256) STATION_NAME VARCHAR2(256) DISPLAY_NAME VARCHAR2(256 CHAR) REGULAR_COUNT NUMBER HABITAT_COUNT NUMBER BIOLOGICAL_COUNT NUMBER METRIC_COUNT NUMBER INDEX_COUNT NUMBER ACT_START_YEAR_DATE NOT NULL NUMBER(4) RESULT_COUNT NOT NULL NUMBER SQL> desc STORETW.STATION_PROJECT Name Null? Type ----------------------------------------- -------- ---------------------------- FK_PROJECT NOT NULL NUMBER FK_STATION NOT NULL NUMBER STATION_WEIGHT VARCHAR2(256 CHAR) WEIGHT_UNIT_CODE VARCHAR2(256 CHAR) STRATUM VARCHAR2(256 CHAR) STATION_WEIGHT_CATEGORY VARCHAR2(256 CHAR) SITE_STATUS VARCHAR2(256 CHAR) ORGANIZATION_ID VARCHAR2(256) STATION_ID VARCHAR2(256) PROJECT_CD VARCHAR2(256 CHAR) STATION_WEIGHT_COMMENT VARCHAR2(4000) REFERENCE_LOCATION_CODE VARCHAR2(256) CITATION_ID VARCHAR2(256) REFERENCE_LOC_END_DATE DATE REFERENCE_LOC_START_DATE DATE LAST_CHANGE_DATE DATE SOURCE_SYSTEM VARCHAR2(256 CHAR) SOURCE_MLOC_UID NUMBER(20) SOURCE_PRJ_UID NUMBER(20) SQL> desc STORETW.STATION_YEAR Name Null? Type ----------------------------------------- -------- ---------------------------- FK_FA_STATN NOT NULL NUMBER(12) FK_ORG NOT NULL NUMBER(12) FK_GEN_GEO_STATE NOT NULL NUMBER(12) STATE_NAME VARCHAR2(256) ORGANIZATION_ID VARCHAR2(256) STATION_ID VARCHAR2(256) STATION_NAME VARCHAR2(256) REGULAR_COUNT NUMBER HABITAT_COUNT NUMBER BIOLOGICAL_COUNT NUMBER METRIC_COUNT NUMBER INDEX_COUNT NUMBER ACT_START_YEAR_DATE NOT NULL NUMBER(4) RESULT_COUNT NOT NULL NUMBER SQL> desc STORETW.STG_ACTIVITY_PROJECT Name Null? Type ----------------------------------------- -------- ---------------------------- ACT_UID NOT NULL NUMBER PRJ_UID NOT NULL NUMBER RES_TYPE NOT NULL VARCHAR2(1) STATUS NOT NULL VARCHAR2(1) ERROR_MSG VARCHAR2(256) SQL> desc STORETW.STG_DELETE_REF Name Null? Type ----------------------------------------- -------- ---------------------------- TABLE_NAME NOT NULL VARCHAR2(30 CHAR) REF_UID NOT NULL NUMBER(20) SQL> desc STORETW.STG_DELETE_REF_BASELINE Name Null? Type ----------------------------------------- -------- ---------------------------- TABLE_NAME NOT NULL VARCHAR2(30 CHAR) REF_UID NOT NULL NUMBER(20) PROCESS_DATE DATE SQL> desc STORETW.TMP_FK_CHAR_FIX Name Null? Type ----------------------------------------- -------- ---------------------------- RES_UID NUMBER RES_TYPE CHAR(2) WH_CHAR_NAME VARCHAR2(256 CHAR) CHAR_NAME VARCHAR2(4000) TAX_NAME VARCHAR2(4000) FK_CHAR NUMBER(12) SQL> desc STORETW.TMP_STATION_CHAR_PROJECT Name Null? Type ----------------------------------------- -------- ---------------------------- FK_STATION NUMBER(12) FK_CHAR NUMBER(12) FK_PROJECT NUMBER(12) RESULT_COUNT NUMBER REGULAR_COUNT NUMBER BIOLOGICAL_COUNT NUMBER HABITAT_COUNT NUMBER METRIC_COUNT NUMBER SQL> desc STORETW.TOAD_PLAN_TABLE Name Null? Type ----------------------------------------- -------- ---------------------------- STATEMENT_ID VARCHAR2(30) PLAN_ID NUMBER TIMESTAMP DATE REMARKS VARCHAR2(4000) OPERATION VARCHAR2(30) OPTIONS VARCHAR2(255) OBJECT_NODE VARCHAR2(128) OBJECT_OWNER VARCHAR2(30) OBJECT_NAME VARCHAR2(30) OBJECT_ALIAS VARCHAR2(65) OBJECT_INSTANCE NUMBER(38) OBJECT_TYPE VARCHAR2(30) OPTIMIZER VARCHAR2(255) SEARCH_COLUMNS NUMBER ID NUMBER(38) PARENT_ID NUMBER(38) DEPTH NUMBER(38) POSITION NUMBER(38) COST NUMBER(38) CARDINALITY NUMBER(38) BYTES NUMBER(38) OTHER_TAG VARCHAR2(255) PARTITION_START VARCHAR2(255) PARTITION_STOP VARCHAR2(255) PARTITION_ID NUMBER(38) OTHER LONG DISTRIBUTION VARCHAR2(30) CPU_COST NUMBER(38) IO_COST NUMBER(38) TEMP_SPACE NUMBER(38) ACCESS_PREDICATES VARCHAR2(4000) FILTER_PREDICATES VARCHAR2(4000) PROJECTION VARCHAR2(4000) TIME NUMBER(38) QBLOCK_NAME VARCHAR2(30) OTHER_XML CLOB SQL> desc STORETW.WS_HUC_CHAR_SUMMARY Name Null? Type ----------------------------------------- -------- ---------------------------- HYDROLOGIC_UNIT_CODE NOT NULL VARCHAR2(12 CHAR) CHARACTERISTIC_ID NOT NULL NUMBER(12) CHARTYPE_ID NOT NULL NUMBER(12) CHAR_DISPLAY_NAME VARCHAR2(256 CHAR) CHARTYPE_NAME VARCHAR2(256 CHAR) RESULT_COUNT NUMBER(12) CHAR_ACT_START_DATE DATE CHAR_ACT_STOP_DATE DATE SQL> desc STORETW.WS_HUC_ORG_CHAR_SUMMARY Name Null? Type ----------------------------------------- -------- ---------------------------- HYDROLOGIC_UNIT_CODE NOT NULL VARCHAR2(12 CHAR) ORGANIZATION_ID NOT NULL VARCHAR2(256) CHARACTERISTIC_ID NOT NULL NUMBER(12) CHARTYPE_ID NOT NULL NUMBER(12) CHAR_DISPLAY_NAME VARCHAR2(256 CHAR) CHARTYPE_NAME VARCHAR2(256 CHAR) RESULT_COUNT NUMBER(12) CHAR_ACT_START_DATE DATE CHAR_ACT_STOP_DATE DATE SQL> desc STORETW.WS_HUC_ORG_SUMMARY Name Null? Type ----------------------------------------- -------- ---------------------------- HYDROLOGIC_UNIT_CODE NOT NULL VARCHAR2(12 CHAR) ORGANIZATION_ID NOT NULL VARCHAR2(256) ORGANIZATION_NAME VARCHAR2(256) MIN_ACTIVITY_START_DATE_TIME DATE MAX_ACTIVITY_STOP_DATE_TIME DATE STATION_COUNT NUMBER(12) RESULT_COUNT NUMBER(12) CHARACTERISTIC_COUNT NUMBER(12) SQL> desc STORETW.WS_ORG_ACTIVITY Name Null? Type ----------------------------------------- -------- ---------------------------- ORGANIZATION_ID VARCHAR2(256) ACTIVITY_ID VARCHAR2(256) ACTIVITY_TYPE VARCHAR2(256) STATION_ID VARCHAR2(256) STATION_TYPE VARCHAR2(256) ACTIVITY_MEDIUM VARCHAR2(20 CHAR) ACTIVITY_START_DATE DATE RESULT_TYPE CHAR(1 CHAR) ACTIVITY_MATRIX VARCHAR2(256 CHAR) ACTIVITY_DEPTH VARCHAR2(256 CHAR) ACTIVITY_DEPTH_UNIT VARCHAR2(256 CHAR) ACTIVITY_UPPER_DEPTH VARCHAR2(256 CHAR) UPR_LWR_DEPTH_UNIT VARCHAR2(256 CHAR) ACTIVITY_LOWER_DEPTH VARCHAR2(256 CHAR) ACTIVITY_DEPTH_REF_POINT VARCHAR2(256 CHAR) ACTIVITY_COND_ORG_TEXT VARCHAR2(256 CHAR) SQL> desc STORETW.WS_ORG_ACTIVITY_PROJECT Name Null? Type ----------------------------------------- -------- ---------------------------- ORGANIZATION_ID VARCHAR2(256) ACTIVITY_ID VARCHAR2(256) ACTIVITY_START_DATE DATE PROJECT_CD VARCHAR2(256 CHAR) RESULT_TYPE CHAR(1 CHAR) SQL> desc STORETW.WS_PROJECT_STATION_CHAR Name Null? Type ----------------------------------------- -------- ---------------------------- FK_PROJECT NUMBER(12) FK_CHAR NUMBER(12) HYDROLOGIC_UNIT_CODE VARCHAR2(256 CHAR) PROJECT_CD VARCHAR2(256 CHAR) ORGANIZATION_ID VARCHAR2(256 CHAR) ORGANIZATION_NAME VARCHAR2(256) STATION_ID VARCHAR2(256) STATION_NAME VARCHAR2(256) STN_STD_LATITUDE NUMBER STN_STD_LONGITUDE NUMBER ACT_MIN_START_DATE DATE ACT_MAX_START_STOP_DATE DATE CHARACTERISTIC_NAME VARCHAR2(256 CHAR) CHARTYPE VARCHAR2(256 CHAR) FK_STATION NUMBER FK_ORG NUMBER RESULT_COUNT NUMBER SQL> desc STORETW.WS_PROJECT_STATION_CHAR_TEMP Name Null? Type ----------------------------------------- -------- ---------------------------- FK_PROJECT NUMBER(12) FK_CHAR NUMBER(12) ACT_MIN_START_DATE DATE ACT_MAX_START_STOP_DATE DATE FK_STATION NUMBER(12) FK_ORG NUMBER(12) RESULT_COUNT NUMBER SQL> desc STORETW.WS_STATION_DATA Name Null? Type ----------------------------------------- -------- ---------------------------- HYDROLOGIC_UNIT_CODE VARCHAR2(12 CHAR) ORGANIZATION_ID VARCHAR2(256) ORGANIZATION_NAME VARCHAR2(256) STATION_ID VARCHAR2(256) STATION_NAME VARCHAR2(256) STD_LATITUDE NUMBER(9,7) STD_LONGITUDE NUMBER(10,7) MIN_ACTIVITY_START_DATE_TIME DATE MAX_ACTIVITY_STOP_DATE_TIME DATE CHARACTERISTIC_ID NUMBER(12) CHAR_DISPLAY_NAME VARCHAR2(256 CHAR) CHAR_RESULT_COUNT NUMBER(12) UNIQUE_STATION_IDENTIFIER VARCHAR2(280 CHAR) CHARACTERISTIC_GROUP_TYPE VARCHAR2(256 CHAR) RSLT_MIN_VALUE_MEASURE NUMBER RSLT_MAX_VALUE_MEASURE NUMBER RSLT_AVG_VALUE_MEASURE NUMBER RSLT_MEASURE_UNIT VARCHAR2(10 CHAR) FK_STATION NUMBER SQL> desc STORETW.WS_STATION_SUMMARY Name Null? Type ----------------------------------------- -------- ---------------------------- ORGANIZATION_ID VARCHAR2(256) STATION_ID VARCHAR2(256) CHARACTERISTIC_ID NUMBER(12) CHARTYPE_ID NUMBER(12) HYDROLOGIC_UNIT_CODE VARCHAR2(12 CHAR) ORGANIZATION_NAME VARCHAR2(256) STATION_NAME VARCHAR2(256) STD_LATITUDE NUMBER(9,7) STD_LONGITUDE NUMBER(10,7) MIN_ACTIVITY_START_DATE_TIME DATE MAX_ACTIVITY_STOP_DATE_TIME DATE CHARTYPE VARCHAR2(256 CHAR) CHAR_DISPLAY_NAME VARCHAR2(256 CHAR) CHARACTERISTIC_RESULT_COUNT NUMBER(12) UNIQUE_STATION_IDENTIFIER VARCHAR2(280 CHAR) CHAR_ACT_START_DATE DATE CHAR_ACT_STOP_DATE DATE CHARACTERISTIC_GROUP_TYPE VARCHAR2(256 CHAR) RSLT_MIN_VALUE_MEASURE NUMBER RSLT_MAX_VALUE_MEASURE NUMBER RSLT_AVG_VALUE_MEASURE NUMBER RSLT_MEASURE_UNIT VARCHAR2(10 CHAR) FK_STATION NUMBER SQL> desc STORETW.WS_WEB_METHOD Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER FK_SERVICE NOT NULL NUMBER WEB_METHOD_NAME NOT NULL VARCHAR2(256 CHAR) WEB_METHOD_ID VARCHAR2(256 CHAR) ENVIROMAPPER_FLAG VARCHAR2(10 CHAR) SERVICE_PROTOCOL VARCHAR2(60 CHAR) SUBMIT_METHOD VARCHAR2(60 CHAR) OUTPUT_FORMAT VARCHAR2(60 CHAR) SQL> desc STORETW.WS_WEB_METHOD_INPUT_PARAM Name Null? Type ----------------------------------------- -------- ---------------------------- PK_ISN NOT NULL NUMBER FK_WEB_METHOD NOT NULL NUMBER(8) PARAM_NAME NOT NULL VARCHAR2(256 CHAR) TITLE VARCHAR2(60 CHAR) DATA_TYPE VARCHAR2(60 CHAR) MAX_LENGTH NUMBER(12) MULTIPLICITY VARCHAR2(60 CHAR) SEQUENCE_NUMBER NOT NULL NUMBER(2) SQL> spool off