SQL> desc 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 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)