SQL> DESC STORET.APP_HELP Name Null? Type ----------------------------------------- -------- ---------------------------- APP_NAME NOT NULL VARCHAR2(5) APP_TITLE NOT NULL VARCHAR2(80) SQL> DESC STORET.FORMS_HELP Name Null? Type ----------------------------------------- -------- ---------------------------- HELP_ID NOT NULL NUMBER(5) APP_NAME NOT NULL VARCHAR2(5) MODULE_NAME VARCHAR2(30) BLOCK_NAME VARCHAR2(30) ITEM_NAME VARCHAR2(30) HELP_TITLE VARCHAR2(80) HELP_TEXT VARCHAR2(2000) FATHER_ID NUMBER(5) EXAMPLE_TEXT VARCHAR2(2000) SORT_ID NUMBER(5) SQL> DESC STORET.HELP_KEYWORDS Name Null? Type ----------------------------------------- -------- ---------------------------- HELP_ID NOT NULL NUMBER(5) APP_NAME NOT NULL VARCHAR2(5) KEY_ID NOT NULL NUMBER(5) KEY_NAME NOT NULL VARCHAR2(30) SQL> DESC STORET.HELP_RELATED Name Null? Type ----------------------------------------- -------- ---------------------------- HELP_ID NOT NULL NUMBER(5) APP_NAME NOT NULL VARCHAR2(5) COUNTER NOT NULL NUMBER(5) HELP_ID_RELATED NOT NULL NUMBER(5) APP_NAME_RELATED NOT NULL VARCHAR2(5) SQL> DESC STORET.TSMERMSG Name Null? Type ----------------------------------------- -------- ---------------------------- TSMERMSG_IS_NUMBER NOT NULL NUMBER(12) TSMERMSG_ORG_ID NOT NULL CHAR(8) MESSAGE_ID NOT NULL CHAR(6) MESSAGE_TEXT NOT NULL VARCHAR2(254) DESCRIPTION_TEXT VARCHAR2(4000) D_USERID_CODE NOT NULL CHAR(8) D_LAST_UPDATE_TS NOT NULL DATE SQL> DESC STORET.TSMESTRY Name Null? Type ----------------------------------------- -------- ---------------------------- TSMESTRY_IS_NUMBER NOT NULL NUMBER(12) TSMESTRY_ORG_ID NOT NULL CHAR(8) NAME NOT NULL VARCHAR2(30) COUNTRY_CODE NOT NULL CHAR(2) STATE_PROVINCE_NAME NOT NULL VARCHAR2(40) PRIMARY_INDICATOR NOT NULL CHAR(1) D_USERID_CODE NOT NULL CHAR(8) D_LAST_UPDT_TS NOT NULL DATE TSMESTRY0ORG_ID CHAR(8) TSMESTRY0IS_NUMBER NUMBER(12) SQL> DESC STORET.TSMFHU Name Null? Type ----------------------------------------- -------- ---------------------------- TSMFHU_IS_NUMBER NOT NULL NUMBER(12) TSMFHU_ORG_ID NOT NULL CHAR(8) HYDROLOGIC_UNIT_CD NOT NULL CHAR(8) NAME VARCHAR2(200) STATES_NAME CHAR(16) LAT_MAX_DEGREE NUMBER(14,4) LAT_MIN_DEGREE NUMBER(14,4) LONG_MAX_DEGREE NUMBER(14,4) LONG_MIN_DEGREE NUMBER(14,4) D_USERID_CODE NOT NULL CHAR(8) D_LAST_UPDT_TS NOT NULL DATE TYPE_CODE NOT NULL VARCHAR2(7) SQL> DESC STORET.TSMGEOPA Name Null? Type ----------------------------------------- -------- ---------------------------- TSMGEOPA_IS_NUMBER NOT NULL NUMBER(12) TSMGEOPA_ORG_ID NOT NULL CHAR(8) LAT_MIN_DEGREE NUMBER(14,4) LAT_MAX_DEGREE NUMBER(14,4) LONG_MIN_DEGREE NUMBER(14,4) LONG_MAX_DEGREE NUMBER(14,4) FIPS_COUNTY_CODE CHAR(3) COUNTY_NAME VARCHAR2(25) STATE_FIPS_CODE NOT NULL CHAR(2) STATE_NAME NOT NULL VARCHAR2(21) STATE_POSTAL_CODE CHAR(2) COUNTRY_CODE NOT NULL CHAR(2) COUNTRY_NAME NOT NULL CHAR(13) COASTAL_IND_CD NOT NULL CHAR(1) GREAT_LAKE_IND_CD NOT NULL CHAR(1) D_USERID_CODE NOT NULL CHAR(8) D_LAST_UPDT_TS NOT NULL DATE SQL> DESC STORET.TSMGEOUN Name Null? Type ----------------------------------------- -------- ---------------------------- TSMGEOUN_CD NOT NULL CHAR(12) TSMGEOUN_ORG_ID NOT NULL CHAR(8) TYPE_CODE NOT NULL CHAR(1) STATE_CODE NOT NULL CHAR(2) NAME NOT NULL VARCHAR2(80) D_USERID_CODE NOT NULL CHAR(8) D_LAST_UPDT_TS NOT NULL DATE SQL> DESC STORET.TSMLTHUN Name Null? Type ----------------------------------------- -------- ---------------------------- TSMLTHUN_CD NOT NULL CHAR(12) TSMLTHUN_ORG_ID NOT NULL CHAR(8) NAME NOT NULL VARCHAR2(120) D_USERID_CODE NOT NULL CHAR(8) D_LAST_UPDT_TS NOT NULL DATE SQL> DESC STORET.TSMMAD Name Null? Type ----------------------------------------- -------- ---------------------------- TSMMAD_IS_NUMBER NOT NULL NUMBER(12) TSMMAD_ORG_ID NOT NULL CHAR(8) ID_CODE NOT NULL CHAR(12) CATEGORY NOT NULL CHAR(10) SUBCATEGORY NOT NULL CHAR(6) DESCRIPTION VARCHAR2(254) D_USERID_CODE NOT NULL CHAR(8) D_LAST_UPDATE_TS NOT NULL DATE EDR_CODE CHAR(12) SQL> DESC STORET.TSMNAICS Name Null? Type ----------------------------------------- -------- ---------------------------- TSMNAICS_IS_NUMBER NOT NULL NUMBER(12) TSMNAICS_ORG_ID NOT NULL CHAR(8) TSMNAICS_CODE NOT NULL CHAR(6) TITLE NOT NULL VARCHAR2(120) EDR_SERIAL_NUMBER NOT NULL CHAR(12) D_USERID_CODE NOT NULL CHAR(8) D_LAST_UPDT_TS NOT NULL DATE SQL> DESC STORET.TSMNAL Name Null? Type ----------------------------------------- -------- ---------------------------- TSMNAL_CD NOT NULL CHAR(5) TSMNAL_STATE NOT NULL CHAR(2) TSMNAL_ORG_ID NOT NULL CHAR(8) NAME NOT NULL VARCHAR2(40) D_USERID_CODE NOT NULL CHAR(8) D_LAST_UPDT_TS NOT NULL DATE SQL> SQL> DESC STORET.TSMPRMVL Name Null? Type ----------------------------------------- -------- ---------------------------- TSMPRMVL_IS_NUMBER NOT NULL NUMBER(12) TSMPRMVL_ORG_ID NOT NULL CHAR(8) TABLE_NAME NOT NULL CHAR(8) FIELD_NAME NOT NULL VARCHAR2(20) SEQUENCE_NUMBER NOT NULL NUMBER(3) FIELD_VALUE VARCHAR2(40) FIELD_DESC VARCHAR2(254) D_USERID_CODE NOT NULL CHAR(8) D_LAST_UPDATE_TS NOT NULL DATE SQL> DESC STORET.TSMPROLE Name Null? Type ----------------------------------------- -------- ---------------------------- TSMPROLE_IS_NUMBER NOT NULL NUMBER(12) TSMPROLE_ORG_ID NOT NULL CHAR(8) TITLE NOT NULL VARCHAR2(32) TYPE_CODE NOT NULL CHAR(4) D_USERID_CODE NOT NULL CHAR(8) D_LAST_UPDATE_TS NOT NULL DATE SQL> DESC STORET.TSMPSR Name Null? Type ----------------------------------------- -------- ---------------------------- TSMPSR_IS_NUMBER NOT NULL NUMBER(12) TSMPSR_ORG_ID NOT NULL CHAR(8) TYPE_NAME NOT NULL VARCHAR2(32) D_USERID_CODE NOT NULL CHAR(8) D_LAST_UPDATE_TS NOT NULL DATE SQL> DESC STORET.TSMRRR Name Null? Type ----------------------------------------- -------- ---------------------------- TSMRRR_IS_NUMBER NOT NULL NUMBER(12) TSMRRR_ORG_ID NOT NULL CHAR(8) HYDROLOGIC_UNIT_CD NOT NULL CHAR(8) SEGMENT_CODE NOT NULL CHAR(3) NAME VARCHAR2(30) TYPE_CODE CHAR(1) LEVEL_CODE NUMBER(2) MILE_LENGTH NUMBER(5,1) LAT_MAX_DEGREE NUMBER(14,4) LAT_MIN_DEGREE NUMBER(14,4) LONG_MAX_DEGREE NUMBER(14,4) LONG_MIN_DEGREE NUMBER(14,4) D_USERID_CODE NOT NULL CHAR(8) D_LAST_UPDT_TS NOT NULL DATE SQL> DESC STORET.TSMSIC Name Null? Type ----------------------------------------- -------- ---------------------------- TSMSIC_CODE NOT NULL CHAR(4) TSMSIC_ORG_ID NOT NULL CHAR(8) NAME NOT NULL VARCHAR2(120) D_USERID_CODE NOT NULL CHAR(8) D_LAST_UPDT_TS NOT NULL DATE SQL> DESC STORET.TSMVSTC Name Null? Type ----------------------------------------- -------- ---------------------------- TSMVSTC_IS_NUMBER NOT NULL NUMBER(12) TSMVSTC_ORG_ID NOT NULL CHAR(8) PRIMARY_TYPE_CD NOT NULL VARCHAR2(30) SECONDARY_TYPE_CD VARCHAR2(30) NATURAL_IND_CD NOT NULL CHAR(1) D_USERID_CODE NOT NULL CHAR(8) D_LAST_UPDT_TS NOT NULL DATE SQL> DESC STORET.TSRANLEQ Name Null? Type ----------------------------------------- -------- ---------------------------- TSRANLEQ_IS_NUMBER NOT NULL NUMBER(12) TSRANLEQ_ORG_ID NOT NULL CHAR(8) TYPE_NAME NOT NULL VARCHAR2(32) NAME NOT NULL VARCHAR2(60) D_USERID_CODE NOT NULL CHAR(8) D_LAST_UPDATE_TS NOT NULL DATE SQL> DESC STORET.TSRBIOPT Name Null? Type ----------------------------------------- -------- ---------------------------- TSRBIOPT_IS_NUMBER NOT NULL NUMBER(12) TSRBIOPT_ORG_ID NOT NULL CHAR(8) NAME NOT NULL VARCHAR2(30) D_USERID_CODE NOT NULL CHAR(8) D_LAST_UPDT_TS NOT NULL DATE SQL> DESC STORET.TSRCALT Name Null? Type ----------------------------------------- -------- ---------------------------- TSRCALT_IS_NUMBER NOT NULL NUMBER(12) TSRCALT_ORG_ID NOT NULL CHAR(8) TYPE_NAME NOT NULL VARCHAR2(30) TYPE_CATEGORY NOT NULL CHAR(2) D_USERID_CODE NOT NULL CHAR(8) D_LAST_UPDATE_TS NOT NULL DATE SQL> DESC STORET.TSRCHALS Name Null? Type ----------------------------------------- -------- ---------------------------- TSRCHAR_IS_NUMBER NOT NULL NUMBER(12) TSRCHAR_ORG_ID NOT NULL CHAR(8) TSRCHALS_IS_NUMBER NOT NULL NUMBER(12) TYPE_NAME NOT NULL VARCHAR2(30) NAME NOT NULL VARCHAR2(500) D_USERID_CODE NOT NULL CHAR(8) D_LAST_UPDATE_TS NOT NULL DATE TSRCALT_IS_NUMBER NUMBER(12) TSRCALT_ORG_ID CHAR(8) SEARCH_NAME NOT NULL VARCHAR2(500) SQL> DESC STORET.TSRCHAR Name Null? Type ----------------------------------------- -------- ---------------------------- TSRCHAR_IS_NUMBER NOT NULL NUMBER(12) TSRCHAR_ORG_ID NOT NULL CHAR(8) EXTRNL_SERIAL_NUM NUMBER(10) UOM_TYPE NOT NULL CHAR(5) SEARCH_NAME NOT NULL VARCHAR2(60) DISPLAY_NAME NOT NULL VARCHAR2(60) D_SCR_TYPE_CD NOT NULL CHAR(4) PROC_REQ_IND_CD NOT NULL CHAR(1) VALID_FOR_QC_IND CHAR(1) SAMP_FRAC_REQ_CD NOT NULL CHAR(1) CHAR_TYPE_CODE NOT NULL CHAR(1) TAXON_RANK_CODE CHAR(8) D_USERID_CODE NOT NULL CHAR(8) D_LAST_UPDATE_TS NOT NULL DATE TRUE_NAME_TSN NUMBER(10) PARENT_TSN NUMBER(10) TAXON_SORT_CODE VARCHAR2(45) AUTHOR_DATE VARCHAR2(45) STATUS CHAR(3) TAXON_RANK_NAME CHAR(12) SQL> DESC STORET.TSRCHTYP Name Null? Type ----------------------------------------- -------- ---------------------------- TSRCHTYP_CATEGORY NOT NULL CHAR(12) TSRCHTYP_SUBCATGRY NOT NULL VARCHAR2(30) TSRCHTYP_ORG_ID NOT NULL CHAR(8) D_USERID_CODE NOT NULL CHAR(8) D_LAST_UPDATE_TS NOT NULL DATE SQL> DESC STORET.TSRCPV Name Null? Type ----------------------------------------- -------- ---------------------------- TSRCPV_IS_NUMBER NOT NULL NUMBER(12) TSRCPV_ORG_ID NOT NULL CHAR(8) SHORT_NAME NOT NULL CHAR(12) DESCRIPTION_TEXT VARCHAR2(60) D_USERID_CODE NOT NULL CHAR(8) D_LAST_UPDATE_TS NOT NULL DATE TSRCHAR_IS_NUMBER NUMBER(12) TSRCHAR_ORG_ID CHAR(8) SQL> SQL> DESC STORET.TSRCTCA Name Null? Type ----------------------------------------- -------- ---------------------------- TSRCHAR_IS_NUMBER NOT NULL NUMBER(12) TSRCHAR_ORG_ID NOT NULL CHAR(8) TSRCHTYP_CATEGORY NOT NULL CHAR(12) TSRCHTYP_SUBCATGRY NOT NULL VARCHAR2(30) TSRCHTYP_ORG_ID NOT NULL CHAR(8) D_USERID_CODE NOT NULL CHAR(8) D_LAST_UPDATE_TS NOT NULL DATE SQL> DESC STORET.TSRFLDGR Name Null? Type ----------------------------------------- -------- ---------------------------- TSRFLDGR_IS_NUMBER NOT NULL NUMBER(12) TSRFLDGR_ORG_ID NOT NULL CHAR(8) ID_CODE NOT NULL CHAR(10) TYPE_NAME NOT NULL VARCHAR2(25) NAME NOT NULL VARCHAR2(60) DESCRIPTION_TEXT VARCHAR2(1999) D_USERID_CODE NOT NULL CHAR(8) D_LAST_UPDATE_TS NOT NULL DATE SQL> DESC STORET.TSRLBRMK Name Null? Type ----------------------------------------- -------- ---------------------------- TSRLBRMK_IS_NUMBER NOT NULL NUMBER(12) TSRLBRMK_ORG_ID NOT NULL CHAR(8) SHORT_NAME NOT NULL CHAR(6) DESCRIPTION_TEXT NOT NULL VARCHAR2(60) D_USERID_CODE NOT NULL CHAR(8) D_LAST_UPDATE_TS NOT NULL DATE SQL> DESC STORET.TSRMATRX Name Null? Type ----------------------------------------- -------- ---------------------------- TSRMATRX_IS_NUMBER NOT NULL NUMBER(12) TSRMATRX_ORG_ID NOT NULL CHAR(8) CODE NOT NULL CHAR(4) NAME NOT NULL VARCHAR2(25) DESCRIPTION NOT NULL VARCHAR2(120) D_USERID_CODE NOT NULL CHAR(8) D_LAST_UPDATE_TS NOT NULL DATE SQL> DESC STORET.TSRPROJSQ Name Null? Type ----------------------------------------- -------- ---------------------------- DESCRIPTION_NAME NOT NULL VARCHAR2(8) SQ NOT NULL NUMBER(1) DESCRIPTION NOT NULL VARCHAR2(50) SQL> DESC STORET.TSRRLIST Name Null? Type ----------------------------------------- -------- ---------------------------- DISP_SEQ NOT NULL NUMBER RPT_ID NOT NULL NUMBER PT NUMBER LVE NUMBER TITLE NOT NULL VARCHAR2(80) FNAME NOT NULL VARCHAR2(80) SQL> DESC STORET.TSRRPARM Name Null? Type ----------------------------------------- -------- ---------------------------- RPT_ID NOT NULL NUMBER PARAM_NAME NOT NULL VARCHAR2(30) SQL> DESC STORET.TSRUOM Name Null? Type ----------------------------------------- -------- ---------------------------- TSRUOM_IS_NUMBER NOT NULL NUMBER(12) TSRUOM_ORG_ID NOT NULL CHAR(8) UOM_TYPE NOT NULL CHAR(5) SHORT_FORM_NAME NOT NULL CHAR(10) DESCRIPTION_TEXT NOT NULL VARCHAR2(50) D_USERID_CODE NOT NULL CHAR(8) D_LAST_UPDATE_TS NOT NULL DATE SQL>