documentation for the cnwra survey database and queries for … · 2012. 11. 19. · 3.22 count...

DOCUMENTATION FOR THE CNWRA SURVEYDATABASE AND QUERIES FOR PRIORITY DOCUMENT

LOADING FOR THE LICENSING SUPPORT SYSTEM

Prepared for

Nuclear Regulatory CommissionContract NRC-02-88-005

Prepared by

Joseph H. Cooper

Center for Nuclear Waste Regulatory AnalysesSan Antonio, Texas

January 1993

TABLE OF CONTENTS

SECTION

1 INTRODUCTIONC

PAGE

. . 1-1

2 DATABASE TABLE DEFINITIONS.2.1 ACTIVITY TABLE.2.2 AUTHOR TABLE .2.3 BLDAUTHOR TABLE.2.4 BLDDOCS TABLE.2.5 CATEGORY TABLE.2.6 CATDOC TABLE .2.7 DOCSRCE TABLE.2.8 DOCSUBJ TABLE.2.9 DOCTYPE TABLE.2.10 RESPONDENT TABLE.2.11 RESP DOC TABLE.2.12 TYPEMASTER TABLE.

............. .2-1............. .2-1

.. ........... . 2-2

.. ........... . 2-3

.. ........... . 2-3

.. ........... . 2-5

.. ........... . 2-6

.. ........... . 2-7............. .2-7............. .2-8............. .2-8............. .2-9............ .2-10

3 QUERY DESCRIPTIONS.3.1 COUNT DISTINCT AUTHOR REFERENCES FOR ENTIRE SURVEY

(C 1AUTHALL SURV) .3.2 COUNT DISTINCT SUBJECT KEYWORDS FOR ENTIRE SURVEY

WHICH DID NOT MAP INTO THESAURUS KEYWORDS(ClDNONTHES)..

3.3 COUNT DISTINCT DOCUMENT REFERENCES FOR PHASE 1 OF THESURVEY (ClD_REFALL PHI).

3.4 COUNT DISTINCT DOCUMENT REFERENCES FOR ENTIRE SURVEY(Ci1DREFALL_SURV) ......................................

3.5 COUNT DISTINCT SUBJECT KEYWORDS FOR ENTIRE SURVEY(Ci1DSUBJALLSURV) ......................................

3.6 COUNT ALL RESPONSES FOR PHASE 1 OF THE SURVEY(Cl REFALLP1).

3.7 COUNT ALL RESPONSES FOR PHASE 2 OF THE SURVEY(Cl REFALLP2).

3.8 COUNT ALL RESPONSES FOR ALL PHASES OF THE SURVEY(Cl REFALL SURV).

3.9 COUNT HIGH-VALUE RESPONSES FOR PHASE 1 OF THE SURVEY(Cl REFHV_P1) .

3.10 COUNT HIGH-VALUE RESPONSES FOR PHASE 2 OF THE SURVEY(Cl _REF_HV_P2).

3.11 COUNT HIGH-VALUE RESPONSES FOR ALL PHASES OF THESURVEY (ClREFHVSURV)...

3.12 COUNT SUBJECT REFERENCES FOR ALL PHASES OF THE SURVEY(C 1SUBJALLSURV) .....................................

3-1

3-2

3-2

3-2

3-2

3-3

3-3

3-3

3-3

3-4

3-4

3-4

3-4

ii

TABLE OF CONTENTS (Cont'd)

SECTION PAGE

3.13 COUNT REFERENCES TO SUBJECT KEYWORDS FOR THE ENTIRESURVEY WHICH DID MAP INTO THESAURUS KEYWORDS(Cl THESSURV) ..................................

3.14 COUNT DOCUMENT TYPE REFERENCES FOR ALL PHASES OF THESURVEY (Cl TYPEALLSURV)..

3.15 COUNT AUTHOR REFERENCES FOR ALL PHASES OF THE SURVEY(EXCLUDING ABSTRACTS, BOOKS, JOURNAL ARTICLES, ANDPROCEEDINGS) (C2_AUTHALLSURV)..

3.16 COUNT DISTINCT DOCUMENT REFERENCES FOR PHASE 1 OF THESURVEY (EXCLUDING ABSTRACTS, BOOKS, JOURNAL ARTICLES,AND PROCEEDINGS) (C2_DREFALL_PHL).

3.17 COUNT DISTINCT DOCUMENT REFERENCES FOR PHASE 2 OF THESURVEY (EXCLUDING ABSTRACTS, BOOKS, JOURNAL ARTICLES,AND PROCEEDINGS) (C2_DREFALL_PH2).

3.18 COUNT DISTINCT DOCUMENT REFERENCES FOR ALL PHASES OFTHE SURVEY (EXCLUDING ABSTRACTS, BOOKS, JOURNALARTICLES, AND PROCEEDINGS) (C2_DREFALL SURV)..

3.19 COUNT DISTINCT DOCUMENT SOURCE REFERENCES FOR ALLPHASES OF THE SURVEY (EXCLUDING ABSTRACTS, BOOKS,JOURNAL ARTICLES, AND PROCEEDINGS) (C2SDSRCEALL SURV).

3.20 COUNT DISTINCT SUBJECT CODE REFERENCES FOR ALL PHASESOF THE SURVEY (EXCLUDING BOOKS, ABSTRACTS, JOURNALARTICLES, AND PROCEEDINGS) (C2)DSUBJALLSURV)....

3.21 COUNT DISTINCT THESAURUS KEYWORD REFERENCES FOR ALL'PHASES OF THE SURVEY (EXCLUDING ABSTRACTS, BOOKS,JOURNAL ARTICLES, AND PROCEEDINGS) (C2SDTHESALL SURV).

3.22 COUNT THESAURUS REFERENCES FOR ALL PHASES OF THESURVEY (EXCLUDING ABSTRACTS, BOOKS, JOURNAL ARTICLES,AND PROCEEDINGS) (C2_DTHESREFSURV) .

3.23 COUNT DISTINCT DOCUMENT TYPE REFERENCES FOR ALLPHASES OF THE SURVEY (EXCLUDING ABSTRACTS, BOOKS,JOURNAL ARTICLES, AND PROCEEDINGS) (C2SDTYPEALL SURV).

3.24 COUNT ALL REFERENCES FOR PHASE 1 OF THE SURVEY(EXCLUDING ABSTRACTS, BOOKS, JOURNAL ARTICLES, AND

3-5

3-5

3-5

3-6

3-6

3-6

3-7

3-7

3-7

3-8

3-8

PROCEEDINGS) (C2_REFALL_PHI)..3.25 COUNT ALL REFERENCES FOR PHASE 2 OF THE SURVEY

(EXCLUDING ABSTRACTS, BOOKS, JOURNAL ARTICLES, ANDPROCEEDINGS) (C2_REFALLPH2)..

3.26 COUNT ALL REFERENCES FOR ALL PHASES OF THE SURVEY(EXCLUDING ABSTRACTS, BOOKS, JOURNAL ARTICLES, ANDPROCEEDINGS) (C2_REFALLSURV)..

... .... . 3-8

... ..... 3-9

... ..... 3-9

iii


SECTION PAGE

3.27 COUNT HIGH-VALUE REFERENCES FOR PHASE 1 OF THE SURVEY(EXCLUDING ABSTRACTS, BOOKS, JOURNAL ARTICLES, ANDPROCEEDINGS) (C2_REF_HVPH)..

3.28 COUNT HIGH-VALUE REFERENCES FOR PHASE 2 OF THE SURVEY(EXCLUDING ABSTRACTS, BOOKS, JOURNAL ARTICLES, ANDPROCEEDINGS) (C2_REFHVPH2)..

3.29 COUNT HIGH-VALUE REFERENCES FOR ALL PHASES OF THESURVEY (EXCLUDING ABSTRACTS, BOOKS, JOURNAL ARTICLES,AND PROCEEDINGS) (C2_REFHVSURV)..

3.30 COUNT ALL SOURCE REFERENCES FOR ALL PHASES OF THESURVEY (EXCLUDING ABSTRACTS, BOOKS, JOURNAL ARTICLES,AND PROCEEDINGS) (C2_SRCEALL_SURV).

3.31 COUNT ALL THESAURUS REFERENCES FOR ALL PHASES OF THESURVEY (EXCLUDING ABSTRACTS, BOOKS, JOURNAL ARTICLES,AND PROCEEDINGS) (C2_THESALLSURV)..

3.32 LIST DOCUMENTS (EXCLUDING BOOKS, JOURNALS,PROCEEDINGS, AND ABSTRACTS) FOR CATEGORY 5,CALCULATING A PRIORITY FACTOR BASED UPON VALUE,EASE OF ACCESS, AND USE FACTOR (CATPRIORITY_1).

3.33 DISTINCT LISTING AND COUNT OF DOCUMENT TYPES (DTYPE).3.34 LISTING AND COUNT OF AUTHORS FOR ALL DOCUMENTS

(EXCLUDING ABSTRACTS, BOOKS, JOURNAL ARTICLES, ANDPROCEEDINGS) FOR ALL PHASES OF THE SURVEY(F2 AUTHALL SURV).

3.35 LISTING AND COUNT OF DOCUMENT SOURCES FOR ALLDOCUMENTS (EXCLUDING ABSTRACTS, BOOKS, JOURNALARTICLES, AND PROCEEDINGS) FOR PHASE 1 OF THE SURVEY(F2_SRCEALLPH1) .......................................

3.36 LISTING AND COUNT OF DOCUMENT SOURCES FOR ALLDOCUMENTS (EXCLUDING ABSTRACTS, BOOKS, JOURNALARTICLES, AND PROCEEDINGS) FOR PHASE 2 OF THE SURVEY(F2_SRCEALLPH2).

3.37 LISTING AND COUNT OF DOCUMENT SOURCES FOR ALLDOCUMENTS (EXCLUDING ABSTRACTS, BOOKS, JOURNAL

3-9

3-10

3-10

3-10

3-11

3-113-12

3-12

3-12

3-13

3-13

3-14

ARTICLES, AND PROCEEDINGS) FOR ALL PHASES OF THE SURVEY(F2_SRCEALLSURV).

3.38 LISTING AND COUNT OF DOCUMENT SOURCES FOR HIGH-VALUEDOCUMENTS (EXCLUDING ABSTRACTS, BOOKS, JOURNALARTICLES, AND PROCEEDINGS) FOR PHASE 1 OF THE SURVEY(F2_SRCE_HVPH1).

iv


SECTION PAGE

3.39 LISTING AND COUNT OF DOCUMENT SOURCES FOR HIGH-VALUEDOCUMENTS (EXCLUDING ABSTRACTS, BOOKS, JOURNALARTICLES, AND PROCEEDINGS) FOR PHASE 2 OF THE SURVEY(F2_SRCEHVPH2) ........................................ 3-14

3.40 LISTING AND COUNT OF DOCUMENT SOURCES FOR HIGH-VALUEDOCUMENTS (EXCLUDING ABSTRACTS, BOOKS, JOURNALARTICLES, AND PROCEEDINGS) FOR ALL PHASES OF THE SURVEY(F2_SRCEHVSURV ) ....................................... 3-15

3.41 LISTING AND COUNT OF KEYWORDS BY SELECTED DOCUMENTSOURCES FOR ALL DOCUMENTS (EXCLUDING ABSTRACTS, BOOKS,JOURNAL ARTICLES, AND PROCEEDINGS) (F2_SRC_TYP_ALL_SUR) ..... 3-15

3.42 LISTING AND COUNT OF STANDARD DOCUMENT TYPES BYSELECTED DOCUMENT SOURCES FOR ALL DOCUMENTS(EXCLUDING ABSTRACTS, BOOKS, JOURNAL ARTICLES, ANDPROCEEDINGS) (F2_SRCSTYP ALL SV) .......... ............... 3-16

3.43 LISTING AND COUNT OF DOCUMENT TYPES BY SELECTEDDOCUMENT SOURCES FOR ALL DOCUMENTS (EXCLUDINGABSTRACTS, BOOKS, JOURNAL ARTICLES, AND PROCEEDINGS)(F2_SRCTYPALL_SUR) ................... 3-17

3.44 LISTING AND COUNT OF STANDARD DOCUMENT TYPES FOR ALLDOCUMENTS (EXCLUDING ABSTRACTS, BOOKS, JOURNALARTICLES, AND PROCEEDINGS) FOR PHASE 1 OF THE SURVEY(F2_STYPALL_PHI) ............... 3-17

3.45 LISTING AND COUNT OF STANDARD DOCUMENT TYPES FOR ALL'DOCUMENTS (EXCLUDING ABSTRACTS, BOOKS, JOURNALARTICLES, AND PROCEEDINGS) FOR PHASE 2 OF THE SURVEY(F2_STYPALLPH2) ........................................ 3-18

3.46 LISTING AND COUNT OF STANDARD DOCUMENT TYPES FOR ALLDOCUMENTS (EXCLUDING ABSTRACTS, BOOKS, JOURNALARTICLES, AND PROCEEDINGS) FOR ALL PHASES OF THE SURVEY(F2_STYPALL SURV) ...................................... 3-18

3.47 LISTING AND COUNT OF STANDARD DOCUMENT TYPES FOR HIGHVALUE DOCUMENTS (EXCLUDING ABSTRACTS, BOOKS, JOURNALARTICLES, AND PROCEEDINGS) FOR PHASE 1 OF THE SURVEY(F2_STYPHVPHI) ........................................ 3-19

3.48 LISTING AND COUNT OF STANDARD DOCUMENT TYPES FOR HIGHVALUE DOCUMENTS (EXCLUDING ABSTRACTS, BOOKS, JOURNALARTICLES, AND PROCEEDINGS) FOR PHASE 2 OF THE SURVEY(F2_STYPHVPH2) ........................................ 3-19

v


SECTION PAGE

3.49 LISTING AND COUNT OF STANDARD DOCUMENT TYPES FOR HIGHVALUE DOCUMENTS (EXCLUDING ABSTRACTS, BOOKS, JOURNALARTICLES, AND PROCEEDINGS) FOR ALL PHASES OF THE SURVEY(F2 STYPHVSURV) ................ 3-20

3.50 LISTING AND COUNT OF THESAURUS KEYWORDS FOR ALLDOCUMENTS (EXCLUDING ABSTRACTS, BOOKS, JOURNALARTICLES, AND PROCEEDINGS) FOR PHASE 1 OF THE SURVEY(F2_THESALLPHI) ............... 3-20

3.51 LISTING AND COUNT OF THESAURUS KEYWORDS FOR ALLDOCUMENTS (EXCLUDING ABSTRACTS, BOOKS, JOURNALARTICLES, AND PROCEEDINGS) FOR PHASE 2 OF THE SURVEY(F2_THESALLPH2) ........................................ 3-21

3.52 LISTING AND COUNT OF THESAURUS KEYWORDS FOR ALLDOCUMENTS (EXCLUDING ABSTRACTS, BOOKS, JOURNALARTICLES, AND PROCEEDINGS) FOR ALL PHASES OF THE SURVEY(F2 THESALL SURV) ................. 3-21

3.53 LISTING AND COUNT OF THESAURUS KEYWORDS FOR HIGHVALUE DOCUMENTS (EXCLUDING ABSTRACTS, BOOKS, JOURNALARTICLES, AND PROCEEDINGS) FOR PHASE 1 OF THE SURVEY(F2_THESHV_PHI ) .............. 3-22

3.54 LISTING AND COUNT OF THESAURUS KEYWORDS FOR HIGHVALUE DOCUMENTS (EXCLUDING ABSTRACTS, BOOKS, JOURNALARTICLES, AND PROCEEDINGS) FOR PHASE 2 OF THE SURVEY(F2 THESHV_PH2) .............. 3-22

3.55 LISTING AND COUNT OF THESAURUS KEYWORDS FOR HIGHVALUE DOCUMENTS (EXCLUDING ABSTRACTS, BOOKS, JOURNALARTICLES, AND PROCEEDINGS) FOR ALL PHASES OF THE SURVEY(F2_THESHVSURV) ....................................... 3-23

3.56 LISTING AND COUNT OF DOCUMENT TYPES FOR ALL DOCUMENTS(EXCLUDING ABSTRACTS, BOOKS, JOURNAL ARTICLES, ANDPROCEEDINGS) FOR PHASE 1 OF THE SURVEY (F2_TYPEALL PHI) ..... 3-23

3.57 LISTING AND COUNT OF DOCUMENT TYPES FOR ALL DOCUMENTS(EXCLUDING ABSTRACTS, BOOKS, JOURNAL ARTICLES, ANDPROCEEDINGS) FOR PHASE 2 OF THE SURVEY (F2 TYPE ALL PH2) ..... 3-23

3.58 LISTING AND COUNT OF DOCUMENT TYPES FOR ALL DOCUMENTS(EXCLUDING ABSTRACTS, BOOKS, JOURNAL ARTICLES, ANDPROCEEDINGS) FOR ALL PHASES OF THE SURVEY(F2_TYPEALL SURV) ................. 3-24

3.59 LISTING AND COUNT OF DOCUMENT TYPES FOR HIGH-VALUEDOCUMENTS (EXCLUDING ABSTRACTS, BOOKS, JOURNALARTICLES, AND PROCEEDINGS) FOR PHASE 1 OF THE SURVEY(F2 TYPEHVPH 1) ........................................ 3-24

vi

0


SECTION PAGE

3.60 LISTING AND COUNT OF DOCUMENT TYPES FOR HIGH-VALUEDOCUMENTS (EXCLUDING ABSTRACTS, BOOKS, JOURNALARTICLES, AND PROCEEDINGS) FOR PHASE 2 OF THE SURVEY(F2 TYPEHV_PH2).

3.61 LISTING AND COUNT OF DOCUMENT TYPES FOR HIGH-VALUEDOCUMENTS (EXCLUDING ABSTRACTS, BOOKS, JOURNALARTICLES, AND PROCEEDINGS) FOR ALL PHASES OF THE SURVEY(F2_TYPE_HVSURV).

3.62 COUNT RESPONSES BY BASELINE DOCUMENT (DBASELINE)..3.63 LIST AND COUNT DOCUMENT TYPES (FD TYPE) .

3-25

3-253-263-26

4 REXX PROGRAMS . ......................................... 4-14.1 GENERATE RESPONDENT CROSS-REFERENCES (ARESPDOC.CMD) ........ 4-14.2 READ A FILE OF BIBLIOGRAPHIC ENTRIES AND CREATE

DOCUMENT ENTRIES IN BLDDOCS (BLD_BIBL.CMD) .4-24.3 READ DOCUMENT RECORDS FROM THE BLDDOCS TABLE AND

GENERATE RECORDS IN THE DOCSRCE RELATIONAL TABLE(BLDSRCE.CMD) .4-2

4.4 READ DOCUMENT RECORDS FROM THE BLDDOCS TABLE ANDGENERATE RECORDS IN THE DOCSUBJ RELATIONAL TABLE(BLDSUBJ.CMD) .4-2

4.5 READ DOCUMENT RECORDS FROM THE BLDDOCS TABLE ANDGENERATE RECORDS IN THE TYPEMASTER TABLE(BLDTMST.CMD) . 4-3

4.6 READ DOCUMENT RECORDS FROM THE BLDDOCS TABLE AND-GENERATE RECORDS IN THE DOCTYPE RELATIONAL TABLE(BLDTYPE.CMD) .4-3

4.7 INITIALIZE THE HP LASERJET III PRINTER SO THAT IT WILLPRINT AT 16.6 CPI IN LANDSCAPE MODE ON LEGAL SIZED PAPER(HPLGLLND.CMD) ..........................................

4.8 INITIALIZE THE HP LASERJET III PRINTER SO THAT IT WILLPRINT AT 16.6 CPI IN LANDSCAPE MODE ON LETTER SIZED PAPER(HPLTRLNDS.CMD).

4.9 PRINT A REPORT OF DOCUMENTS WHICH WERE SUBMITTED BYRESPONDENTS FROM A SPECIFIED ELEMENT (REPTNCMD).. .

4.10 PRINT A REPORT IN RESPONDENT / TITLE SEQUENCE OFDOCUMENTS WHICH WERE SUBMITTED BY RESPONDENTS FROMA SPECIFIED ELEMENT (REPTO02.CMD).

4.11 PRINT A REPORT OF DOCUMENTS WHICH WERE SUBMITTED BYA SPECIFIED RESPONDENT (REPT_03.CMD) .

4-4

4-4

4-5

4-5

4-6

vii


SECTION PAGE

4.12 PRINT A REPORT OF DOCUMENTS IN ACTIVITY / TYPE SEQUENCEWHICH WERE SUBMITTED BY A SPECIFIED RESPONDENT(REPT_04.CM D) ............................................ 46

4.13 PRINT A REPORT OF ALL DOCUMENTS IN DOCUMENT ACCESSIONNUMBER SEQUENCE (REPT_05.CMD) ............................ 4-7

5 MACHINE READABLE MEDIA .............................. 5-1

viii

0 4

1 INTRODUCTION

As part of the Licensing Support System (LSS) Task 2 work on determining the feasibility of priorityloading of the LSS, a computerized database was prepared and used to store the results of the Center forNuclear Waste Regulatory Analyses (CNWRA) survey. The database was implemented using the DatabaseManager and Query Manager facilities of the OS/2 Operating System, Version 2.0. During theimplementation of the CNWRA survey database, a number of Structured Query Language (SQL) querieswere developed and used to analyze the survey data. The results derived from some of these queries wereused in the report entitled Lessons Learned from the CNWRA Survey About the Feasibility of PriorityLoading of the LSS (LSS Task 2 Report), while other queries were simply used to investigate aspects ofthe data. The following documentation describes the relational database tables and major queries whichwere developed and used in the preparation of the Task 2 Report. This documentation is intended to beused as reference information by users who are familiar with the facilities and operation of the OS/2Database Manager and OS/2 Query Manager.

A number of SQL database tables were created and loaded with survey data. Chapter 2 includesdescriptions of these database tables and the columns (fields) which comprise each table. The databasetable descriptions are intended to provide reference information for the user of the survey database toclarify the contents of the SQL database and the significance of table names and column names used inthe SQL query statements. Additionally, if the data in the survey database is to be migrated to a databaseenvironment other than OS/2 Database Manager, then the information in the table descriptions may beused to create appropriate tables in the new database environment to hold the survey data.

A large number of queries were developed in the course of the CNWRA survey to explore and analyzethe survey data. Only a limited number of these queries were actually used, however, to produce thetables and information contained in the LSS Task 2 Report. Therefore, the query documentationconcentrates on these queries. Chapter 3 includes descriptions of the major queries which were used inthe preparation of the Task 2 Report. Each query description contains a brief narrative Oiscussion of thequery and its use as well as a listing of the SQL statements executed by the query. The SQL statementsare included for reference, but are not required by the user when executing the query.

Several computer programs were written in the REXX language and were used under the OS/2 operatingsystem to manipulate and print the survey information. Chapter 4 includes brief descriptions of theseREXX programs. These programs have been copied to diskette in ASCII format, and they may bereloaded and executed in an OS/2 environment, or they may be converted to an alternative language ifthe database is to be implemented in some other environment. These REXX programs are auxiliary innature and they are not critical to the operation of the database.

Following suspension of the LSS Task 2 work, the database tables and queries were unloaded to diskettemedia using the OS/2 Database Manager recovery utility facilities. The source code of the REXXprograms was also copied to diskette media. Chapter 5 describes the machine readable mediaaccompanying this report, which contains the survey database data and the supporting REXX programs.The survey database data is included on diskette in two formats:

1-1

* The standard unload format which permits the entire database with all associated queries andpresentation formats (forms) to be reloaded on another machine configuration using OS/2Database Manager.

* Delimited ASCII format which permits the data from each of the tables to be loaded and intoother database environments. It should be noted that the SQL queries and forms used tomanipulate and report the data are not included in the ASCII format data because they aregenerally specific to the OS/2 Database Manager environment.

1-2

0 0

2 DATABASE TABLE DEFINITIONS

The following sections describe the contents and intended use of the relational database tables in theCNWRA Survey database. Following the general description of each table, the individual table columns(fields) are described. The bold print heading for each column (field) includes the internal SQL name forthe column (e.g., ACTVACCS), the type and maximum length of the data (e.g., SMALL INT,VARCHAR (254), etc.), an indication of whether or not null entries are permitted for the column (e.g.,NOT NULL), and an indication of whether the column is a primary key for the table (e.g., PRIMARYKEY).

2.1 ACTIVITY TABLE

The survey information pertaining to activities is stored in the activities database table. Forpurposes of positive identification and conservation of database space, each activity is defined one timeand is assigned an arbitrary accession number which is used internally to relate the activities to theirassociated respondent and document information. Activity accession numbers were assigned manually.The descriptions and dates for each activity occur only once in the database. Thus, if the descriptionand/or dates for an activity are changed, those changes are automatically reflected in all subsequentreporting.

When the activity information was entered, relational table entries were also generated usinga REXX program to associate the activity information with the appropriate respondent and documentinformation. Because documents were related to the activity information, it was necessary to identify anactivity before entering the document records that are to be associated with it.

ACTVACCS SMALL INT NOT NULL PRIMARY KEY

The activity accession number is a unique number which was manuallyassigned as theactivity information was entered. Normally, the user does not need to be aware of theactivity accession number, but it is used within queries to relate activity information to thecorresponding document and respondent records.

ACTVBEGDATE DATE NOT NULL

The beginning date associated with an activity is stored to facilitate sorting of activities bydate. This date field is reformatted by the appropriate Query Manager form for purposes ofprinting.

ACTVENDDATE DATE NOT NULL

The ending date associated with an activity is stored to facilitate sorting of activities by date.This date field is reformatted by the appropriate Query Manager form for purposes ofprinting.

ACTVDESCR VARCHAR (254) NOT NULL

2-1

0 0

The activity description is a variable length text field which contains a brief description ofthe activity.

ACTVPARTICPANT VARCHAR (20) NOT NULL

The activity participant contains a standard abbreviation or acronym for the participantorganization (e.g., DOE, NRC, CNWRA, etc.).

ORGDIV VARCHAR (15)

The activity organizational division contains the standard abbreviation or acronym for theorganizational division of the responsible participant (e.g., HLW, RES, etc.)

PROG VARCHAR (25)

The program contains the standard name, abbreviation, or acronym for the program withinthe organizational division (e.g., THERMOHYDROLOGY, STOCHASTIC,VOLCANOLOGY, etc.).

ELEMENT VARCHAR (10)

The element contains the standard abbreviation or acronym for the responsible element (e.g.,GS, RDCO, EBS, PA, etc.).

2.2 AUTHOR TABLE

The author information for all documents is stored in a single database table. For purposes ofpositive identification and conservation of database space, each author name occurs only once and isassigned an arbitrary accession number at the time of entry. This accession number is used internally torelate the authors with the document records.

AUTHACCS SMALL INT NOT NULL PRIMARY KEY

The author accession number is a unique number which is manually assigned at the timethat the author record is entered. Normally, the user does not need to be aware of the authoraccession number, but it is used by queries to relate the author records to their associateddocuments.

AUTH_LNAME VARCHAR (30) NOT NULL

The author last name field is a variable length text field which contains the last name of theauthor.

AUTH_F_NAME VARCHAR (30)

2-2

0 0

The author first name field is a variable length text field which contains the first name ofthe author.

AUTHINIT VARCHAR (10)

The author initials field is a variable length text field which contains the middle initial(s) ofthe author.

2.3 BLDAUTHOR TABLE

The BLDAUTHOR table is a relational table which contains the linkages between authors anddocuments. By using this relational table, it is possible for a single author to be associated with multipledocuments and for multiple authors to be associated with a single document as well. These relationshipswere established and maintained manually as the documents were entered into the system.

BLDACCS SMALL INTEGER NOT NULL

This field contains the unique accession for the document.

AUTHACCS SMALL INTEGER NOT NULL

This field contains the unique accession for the author.

2.4 BLDDOCS TABLE

The survey information pertaining to documents is stored in the BLDDOCS database table.For purposes of positive identification and conservation of database space, each document appears onlyone time in this table no matter how many times it may have been referenced. Each document record wasmanually assigned an arbitrary accession number which is used internally to relate the document recordsto their associated respondents, authors, subject keywords, document types, document sources, andpriority categories through other relational tables. Since the information pertaining to a document isentered only one time in the database, if any data fields are changed for a document, the changes willautomatically be reflected in all subsequent reporting.

BLDACCS SMALL INT NOT NULL PRIMARY KEY

The document accession number is a unique number which is manually assigned at the timethat the document information is entered. Normally, the user does not need to be aware ofthe document accession number, but it is used internally by queries to relate documentinformation to other database tables.

BLDSUBJ VARCHAR (254)

The subject field is a variable length text field containing a brief description of the subjectmatter addressed by the document. This field was parsed using a REXX program to createthe DOCSUBJ table.

2-3

0 0

BLDTYPE VARCHAR (100)

The document type field is a variable length text field containing a brief description of thetype of documentary material(s) referenced by the entry. This field was parsed using aREXX program to create the DOCTYPE table.

BLDTITLE VARCHAR (254)

The document title field is a variable length text field containing the full title of thedocument.

BLDBEGDATE CHAR (8)

The document beginning date is stored in the form YYYYMMDD to facilitate sequencingand selection of document records by date. The document beginning date is reformatted forpurposes of printing. When the document date is entered as a date range, the beginning dateis entered in this field. When the document date is entered as a single date value, the dateis replicated in both the beginning and ending date fields. The date is left-justified in thefield. If only a year is entered, then the last four characters of the field are blank. If onlya year and month are entered, then the last two characters of the field are blank.

BLDENDDATE CHAR (8)

The document ending date is stored in the form YYYYMMDD to facilitate sequencing andselection of document records by date. The document ending date is reformatted forpurposes of printing. When the document date is entered as a date range, the ending date isentered in this field. When the document date is entered as a single date value, the date isreplicated in both the beginning and ending date fields. The date is left-justified in the field.If only a year is entered, then the last four characters of the field are blank. If only a yearand month are entered, then the last two characters of the field are blank.'

BLDSOURCE VARCHAR (254)

The document source information is stored in a variable length text field.

* For reports, this field indicates the organization which originated the material(s), and ifthe material(s) was originated by a sub-contractor, then the subcontractor name alsoappears in this field.

* For journal articles, this field contains the name of the publication or journal.

* For other material(s), this field contains the name of the publisher or source from whichthe material(s) can be obtained.

BLDREPORT VARCHAR (100)

If a report number is known, it is entered and stored in this variable length text field.

2-4

* 0

BLDNUMDOCS INTEGER

The number of documents is stored in an integer field. This field indicates the respondent'sestimate of the number of documents being referenced by the entry. If no estimate isavailable, this field contains a zero.

BLDNUMPAGES INTEGER

The number of pages is stored in an integer field. This field indicates the respondent'sestimate of the number of pages referenced by the entry. If no estimate is available, thisfield contains a zero.

BLDEASEACCESS SMALL INT

The ease of access field is a small integer field which contains the respondent's estimate ofthe relative ease (or difficulty) of obtaining access to the documentary material(s) other thatthrough the LSS. This information is encoded as a small integer with a value between I and5, where 1 indicates a document which is readily available and 5 indicates a document whichis difficult to obtain. If no estimate is available, this field contains a zero.

BLDVALUE SMALL INT

The value of material(s) field is a small integer field which contains the respondent'sestimate of the relative value of the documentary material(s) to the repository program. Thisinformation is encoded as a small integer with a value between 1 and 5, where 1 indicatesa relatively unimportant document and 5 indicates a document which is critical to therepository program. If no estimate is available, this field contains a zero.

DUPL CHARACTER (1)

The duplicate flag is not used.

2.5 CATEGORY TABLE

The category table contains a master list of priority loading category descriptions and accessionnumbers. Its primary use is to provide category descriptions for display and/or printing.

CATACCS SMALL INT NOT NULL

The category accession number is an arbitrary unique number which is assigned to priorityloading categories as they are defined. This accession number is not normally a matter ofconcern to the user, but is employed internally to establish relational links to the documenttable through the CATDOC relational table.

2-5

CATDESCR VARCHAR (254) NOT NULL

The category description contains a brief textual description of the category. This field isused for display and/or printing of category titles.

2.6 CATDOC TABLE

The category document relational table is used to establish relationships between the categorymaster table and the documents which are assigned to each category. This table contains multiple categorylinkages which permit concurrent experimentation with multiple categorization schemes. The preliminarypriority loading categories which were reported in the LSS Task 2 Report are contained in the fifthcategory field (CAT 05).

CATACCS SMALL INT NOT NULL

The category accession number is a manually assigned unique number which points tothe category description of the record.

DOCACCS SMALL INT NOT NULL

The document accession number is a manually assigned unique number which points tothe document record.

CAT_01 SMALL INT

This field is used to store the category accession numbers assigned during evaluation ofthe first priority loading category scenario.

CAT_02 SMALL INT

This field is used to store the category accession numbers assigned during evaluation ofthe second priority loading category scenario.

CAT_03 SMALL INT

This field is used to store the category accession numbers assigned during evaluation ofthe third priority loading category scenario.

CAT_04 SMALL INT

This field is used to store the category accession numbers assigned during evaluation ofthe fourth priority loading category scenario.

2-6

0 9

CAT_05 SMALL INT

This field is used to store the category accession numbers assigned during evaluation ofthe fifth priority loading category scenario. The preliminary priority loading categorieswhich were reported in the LSS Task 2 Report are contained in this field.

2.7 DOCSRCE TABLE

The document source relational table was created to permit multiple document sources to beassociated with a single document. This table contains many-to-many relationships. Therefore, multiplesources can be associated with a single document entry and multiple documents may be associated witha single source.

DOCSRCE VARCHAR (100) NOT NULL

This field contains a standardized textual description of the document source.

BLDACCS SMALL INT NOT NULL

This field contains the unique accession number of the associated document record in theBLDDOCS table.

2.8 DOCSUBJ TABLE

The document subject relational table was created to permit multiple document subject keywordsto be associated with a single document. This table contains many-to-many relationships. Therefore,multiple subject keywords can be associated with a single document and multiple documents may beassociated with a single subject keyword. When the original subject keywords were mapped into thethesaurus keywords, standard keyword and thesaurus flag fields were added to this table.

SUBJKWD VARCHAR (100) NOT NULL

This field contains the original subject keyword.



STD_KWD VARCHAR (100)

This field contains the standardized subject keyword following mapping of the originalkeywords to the thesaurus keywords. If an appropriate thesaurus keyword was available,then that keyword appears in this field. Otherwise, the original keyword appears in thisfield.

2-7

THESAURUS CHARACTER (1)

This field contains a "Y" or a "N" to indicate whether mapping occurred between theoriginal subject keyword and the standard keyword. If a "Y" appears in this field, thenthe standard keyword is interpreted as a mapped thesaurus keyword. Otherwise, thestandard keyword is interpreted as the original keyword.

2.9 DOCTYPE TABLE

The document type relational table was created to permit multiple document types to beassociated with a single document entry. This table contains many-to-many relationships. Therefore,multiple document types can be associated with a single document and multiple documents may beassociated with a single document type. When the original document types were mapped into standarddocument types, standard type and use factor fields were added to this table.

DOCTYPE VARCHAR (25) NOT NULL

This field contains the original document type.



USEFACTOR SMALL INT

The use factor was added to permit estimates of the relative usage of various documenttypes to be considered in the calculations of priority loading values.

STh KWD VARCHAR (25)

This field contains the standardized document type following mapping of the originaldocument type into the standardized document type classes.

2.10 RESPONDENT TABLE

The information in the respondent table permits the individual respondents to be associated withthe document information which they provided. For purposes of positive identification and conservationof database space, each respondent is entered only one time and is assigned an arbitrary accession numberthat is used internally to relate the respondents with the activities and document they identified.

RESPACCS SMALL INT NOT NULL PRIMARY KEY

The respondent accession number is a unique manually assigned number. Normally, the userdoes not need to be aware of the respondent accession number, but it is used internally byqueries to associate respondent and document records

2-8

RESPNAME VARCHAR (50) NOT NULL

The respondent name field is a variable length text field which contains the name of therespondent. The format of the name is first name, middle initial, and last name.

RESPAFFIL VARCHAR (50) NOT NULL

The respondent affiliation is a variable length text field which contains the name of theorganization with which the respondent (or the person whom the respondent is representing)is affiliated.

RESPREP VARCHAR (50)

If the respondent is actually representing some other person, then the name of the personbeing represented is entered in this variable length text field. The format of this name fieldis first name, middle initial, and last name.

RESPTELE CHAR (20)

The respondent telephone number, including the area code and the extension, if appropriate,is entered in this variable length text field. The telephone number is included to facilitatefollow-up of responses but no indexing or search capability is supported on the telephonenumber field.

RESPDATE DATE NOT NULL

The date of the response is stored in this fixed length numeric field. The response date isreformatted for purposes of printing. No indexing or search capability is supported on theresponse date field.

RESPELEM VARCHAR (10)

This field contains a description of the responsible element represented by the respondent.

2.11 RESPDOC TABLE

The respondent document table is a relational table which permits the respondent informationto be related to the document and activity information. Because this table contains many-to-manyrelationships, a single respondent can be associated with many documents and activities, and a singledocument entry can be associated with many respondents and activities.

RESPACCS SMALL INT

This fiefd contains the unique accession number of the respondent.

2-9

DOCACCS SMALL INT

This field contains the unique accession number of the document record.

ACTVACCS SMALL INT

This field contains the unique accession number of the activity record.

2.12 TYPEMASTER TABLE

The type master table contains a standardized description for each document type and anumerical value representing an estimate of the relative usage expected for each type of documentarymaterial.

DOCTYPE VARCHAR (25) NOT NULL

This field contains the description of the document type.

USEFACTOR SMALL INT

The use factor was added to permit estimates of the relative usage of various documenttypes to be considered in the calculations of priority loading values.

2-10

3 QUERY DESCRIPTIONS

The following sections describe the contents and intended use of the major queries which support the dataand conclusions of the Task 2 report. The sequence of the query descriptions follows the sequence of thequery selection list in Query Manager from which the user may choose a query for execution. Many ofthe queries have associated presentation formats called "forms". These presentation formats provide pageheadings, specification of field widths, and other formatting information. In general, the form for a querywill have the same name as the query itself. Each query may be executed either by a "RUN" command,which will use the Query Manager default presentation format, or by a "RUN USING" command whichwill use the specified presentation format (form).

Each query description begins with a bold heading which contains a description of the query and, inparentheses, the name of the query. A general description of the query and its intended use follows thebold heading. After the general description of the query, the SQL statements executed by the query arelisted. These SQL statements are included for reference, but they are not needed by the user in the normalexecution of the query.

The SQL statements associated with a number of the queries include enumerations of document types ordocument sources in their selection criteria. These queries are, in fact, selecting subsets of the surveydata. Therefore, the subsets of the data to be included or excluded are specified in the SELECTstatements of these queries.

The SQL statements associated with other queries include explicit numerical values in conjunction withthe document accession number. These queries are selecting data from the survey database by surveyphase. The first phase of the survey included 383 responses. Therefore, by selecting accession numberswhich are less than 384, only responses from Phase 1 of the survey will be included. Similarly, byselecting accession numbers which are greater than 383, only responses from Phase 2 of the survey willbe included.

Other queries include explicit numerical values which are used in the denominators of expressions (e.g.SELECT A.DOC TYPE, COUNT(*), (100.00 * COUNT(*) / 213) ...... ). These queries are calculatingpercentages, and the explicit values are used to avoid a complex and inefficient sub-query which wouldotherwise be required. The numerical values used in these queries were all developed from other querieswhich count the occurrences in various groups of data. The names of all of these "count" queries beginwith "Cl" or "C2".

The queries and presentation formats which were prepared and used in conjunction with the CNWRAsurvey are specific to this database and the OS/2 Database Manager and Query Manager products. If theinformation in the CNWRA survey database is to be migrated to another database or hardware/softwareenvironment, then the queries will need to be generated in the new environment. The SQL statementsincluded for each of the following queries should be portable to any SQL compliant database but thepresentation formats would need to be developed using the facilities of the target database product.

3-1

0 "

3.1 COUNT DISTINCT AUTHOR REFERENCES FOR ENTIRE SURVEY(Cl AUTH ALL SURV)

This query is used to count the total references to authors for the entire survey. The numberof author references is different from the number of authors because a single author may be referencedmultiple times. The count of 619 author references developed by this query was used on page 4-1 of LSSTask 2 Report.

SELECT COUNT(*)FROM BLDAUTHOR

3.2 COUNT DISTINCT SUBJECT KEYWORDS FOR ENTIRE SURVEYWHICH DID NOT MAP INTO THESAURUS KEYWORDS(ClDNONTHIES)

This query is used to count the number of distinct subject keywords referenced in the entiresurvey which did not map into thesaurus keywords. The count of 128 unmapped subject keywords wasused in preparing the analyses on page 4-3 of LSS Task 2 Report.

SELECT COUNT(DISTINCT(SUBJ KWD))FROM DOCSUBJWHERE THESAURUS < > 'Y'

3.3 COUNT DISTINCT DOCU1M1ENT REFERENCES FOR PHASE 1 OF THESURVEY (ClDREFALLPHi)

This query is used to count the number of distinct document references for phase 1 of thesurvey. The count of 367 distinct documents developed by this query was used on page 1-1 of LSSTask 2 Report.

SELECT COUNT(DISTINCT(A.DOCACCS))FROM RESPDOC A, BLDDOCS BWHERE A.DOCACCS = B.BLD ACCS AND BLDVALUE > 0 AND

A.DOCACCS < 384

3.4 COUNT DISTINCT DOCUMENT REFERENCES FOR ENTIRE SURVEY(ClDREFALLSURV)

This query is used to count the number of distinct document references for the entire survey.The count of 538 distinct documents developed by this query was used on page 1-1 of LSS Task 2Report.

3-2

0 0

SELECT COUNT(DISTINCT(A.DOCACCS))FROM RESPDOC A, BLDDOCS BWHERE A.DOCACCS = B.BLDACCS AND BLDVALUE > 0 AND

A.DOCACCS > 0

3.5 COUNT DISTINCT SUBJECT KEYWORDS FOR ENTIRE SURVEY(ClDSUBJALLSURV)

This query is used to count the number of distinct subject keywords referenced in the entiresurvey, including all document types. The count of 395 distinct subject keywords developed by this querywas used on page 4-2 of LSS Task 2 Report.

SELECT COUNT(DISTINCT(A.SUBJKWD))FROM DOCSUBJ A

3.6 COUNT ALL RESPONSES FOR PHASE 1 OF THE SURVEY(ClREFALLPl)

This query is used to count the number of document references, including all document types,for phase 1 of the survey. The count of 796 distinct document references developed by this query wasused on page 1-1 of LSS Task 2 Report.

SELECT COUNT(*)FROM RESPDOC A, BLDDOCS BWHERE A.DOCACCS = B.BLDACCS AND BLDVALUE > 0 AND

A.DOCACCS < 384

3.7 COUNT ALL RESPONSES FOR PHASE 2 OF THE SURVEY(Cl REF ALL P2)

This query is used to count the number of document references, including all document types,for phase 2 of the survey.


A.DOCACCS > 383

3.8 COUNT ALL RESPONSES FOR ALL PHASES OF THE SURVEY(ClREFALLSURV)

This query is used to count the number of document references, including all document types,for all phases of the survey. The count of 1,271 document references developed by this query was usedon page 1-1 of LSS Task 2 Report.

3-3

SELECT COUNT(*)FROM RESPDOC A, BLDDOCS BWHERE A.DOCACCS = B.BLDACCS AND BLD_VALUE > 0 AND

A.DOCACCS > 0

3.9 COUNT HIGH-VALUE RESPONSES FOR PHASE 1 OF THE SURVEY(C1_REF_HVP1)

This query is used to count the number of high-value (value code > 3) document references,including all document types, for phase 1 of the survey.


A.DOCACCS < 384

3.10 COUNT HIGH-VALUE RESPONSES FOR PHASE 2 OF THE SURVEY(C1 REFHV P2)

This query is used to count the number of high-value (value code > 3) document references,including all document types, for phase 2 of the survey.

SELECT COUNT(*)FROM RESPDOC A, BLDDOCS BWHERE A.DOC_ACCS = B.BLD_ACCS AND BLD_VALUE > 3 AND

A.DOC_ACCS > 383

3.11 COUNT HIGH-VALUE RESPONSES FOR ALL PHASES OF THESURVEY (Cl REF HV SURV)

This query is used to count the number of high-value (value code > 3) document references,including all document types, for all phases of the survey.

SELECT COUNT(*)FROM RESPDOC A, BLDDOCS BWHERE A.DOCACCS = B.BLD_ACCS AND BLDVALUE > 3 AND

A.DOCACCS > 0

3.12 COUNT SUBJECT REFERENCES FOR ALL PHASES OF THE SURVEY(C1_SUBJALLSURV)

This query is used to count the subject references for all documents for the entire survey. Thecount of 1378 subject keyword references developed by this query was used on page 4-2 of LSS Task 2Report.

3-4

SELECT COUNT(*)FROM DOCSUBJ A

3.13 COUNT REFERENCES TO SUBJECT KEYWORDS FOR THE ENTIRESURVEY WHICH DID MAP INTO THESAURUS KEYWORDS(Cl THES SURV)

This query is used to count the number of subject keywords references in the entire surveywhich did map into thesaurus keywords. The count of 1111 mapped subject keyword references was usedto develop the analyses on page 4-3 of LSS Task 2 Report.

SELECT COUNT(DISTINCT(SUBJKWD))FROM DOCSUBJWHERE THESAURUS < > 'Y'

3.14 COUNT DOCUMENT TYPE REFERENCES FOR ALL PHASES OF THESURVEY (ClTYPEALLSURV)

This query is used to count all document type references, including all document types. Thecount of document type references developed by this query was used to compute the percentage of reportsindicated on page 2-1 of LSS Task 2 Report.

SELECT COUNT(*)FROM DOCTYPE

3.15 COUNT AUTHOR REFERENCES FOR ALL PHASES OF THE SURVEY(EXCLUDING ABSTRACTS, BOOKS, JOURNAL ARTICLES, ANDPROCEEDINGS) (C2_AUTHALLSURV)

This query is used to count all references to authors for the entire survey, that are associatedwith document types other than abstracts, books, journal articles and proceedings. The count of 374author references developed by this query was used on page 4-1 of LSS Task 2 Report.

SELECT COUNT(*)FROM BLDAUTHOR A, BLDDOCS B, DOCTYPE CWHERE A.BLDACCS = B.BLD ACCS AND A.BLDACCS = C.BLD_ACCS AND

C.DOCTYPE < > 'ABSTRACT' AND C.DOCTYPE < > 'BOOK' ANDC.DOCTYPE < > 'JOURNAL ARTICLE' AND C.DOC TYPE < > 'PROCEEDING'

AND BLDVALUE > 0 AND A.BLDACCS > 0

3-5

* 0

3.16 COUNT DISTINCT DOCUMENT REFERENCES FOR PHASE 1 OF THESURVEY (EXCLUDING ABSTRACTS, BOOKS, JOURNAL ARTICLES,AND PROCEEDINGS) (C2_D_REFALLPHl)

This query is used to count all distinct document references, for phase 1 of the survey, that areassociated with document types other than abstracts, books, journal articles, and proceedings. The countof 231 distinct documents developed by this query was used on page 1-1 of LSS Task 2 Report.

SELECT COUNT(DISTINCT(A.DOC_ACCS))FROM RESPDOC A, BLDDOCS B, DOCTYPE CWHERE A.DOCACCS = B.BLDACCS AND A.DOCACCS = C.BLDACCS AND

C.DOCTYPE < > 'ABSTRACT' AND C.DOCTYPE < > 'BOOK' ANDC.DOCTYPE < > 'JOURNAL ARTICLE' AND C.DOCTYPE < > 'PROCEEDING'AND BLDVALUE > 0 AND A.DOCACCS < 384

3.17 COUNT DISTINCT DOCUMENT REFERENCES FOR PHASE 2 OF THESURVEY (EXCLUDING ABSTRACTS, BOOKS, JOURNAL ARTICLES,AND PROCEEDINGS) (C2_D_REFALL_PH2)

This query is used to count all distinct document references, for phase 1 of the survey,that areassociated with document types other than abstracts, books, journal articles, and proceedings. Baselinedocuments are excluded from this query. The count of 169 distinct documents developed by this querywas used on page 1-1 of LSS Task 2 Report.

SELECT COUNT(DISTINCT(A.DOCACCS))FROM RESPDOC A, BLDDOCS B, DOCTYPE CWHERE A.DOCACCS = B.BLD ACCS AND A.DOCACCS = C.BLDACCS AND

C.DOCTYPE < > 'ABSTRACT' AND C.DOCTYPE < > 'BOOK' ANDC.DOCTYPE < > 'JOURNAL ARTICLE' AND C.DOCTYPE < >'PROCEEDING'AND BLDVALUE > 0 AND A.DOCACCS > 383

3.18 COUNT DISTINCT DOCUMENT REFERENCES FOR ALL PHASES OFTHE SURVEY (EXCLUDING ABSTRACTS, BOOKS, JOURNALARTICLES, AND PROCEEDINGS) (C2_DREFALLSURV)

This query is used to count all distinct document references, for the entire survey, that areassociated with document types other than abstracts, books, journal articles, and proceedings. Baselinedocuments are excluded from this query.

SELECT COUNT(DISTINCT(A.DOCACCS))FROM RESPDOC A, BLDDOCS B, DOCTYPE CWHERE A.DOCACCS = B.BLDACCS AND A.DOCACCS = C.BLDACCS AND

C.DOCTYPE < > 'ABSTRACT' AND C.DOCTYPE < > 'BOOK' ANDC.DOCTYPE < > 'JOURNAL ARTICLE' AND C.DOCTYPE < > 'PROCEEDING'AND BLDVALUE > 0 AND A.DOCACCS > 0

3-6

0 0

3.19 COUNT DISTINCT DOCUMENT SOURCE REFERENCES FOR ALLPHASES OF THE SURVEY (EXCLUDING ABSTRACTS, BOOKS,JOURNAL ARTICLES, AND PROCEEDINGS) (C2_D_SRCEALLSURV)

This query is used to count all distinct references to document sources, for the entire survey,that are associated with document types other than abstracts, books, journal articles, and proceedings. Thecount of 51 distinct document sources developed by this query was used on page 4-7 of LSS Task 2Report.

SELECT COUNT(DISTINCT(A.DOC_ACCS))FROM RESPDOC A, BLDDOCS B, DOCTYPE CWHERE A.DOCACCS = B.BLDACCS AND A.DOCACCS = C.BLD ACCS AND

C.DOC TYPE < > 'ABSTRACT' AND C.DOC TYPE < > 'BOOK' ANDC.DOCTYPE < > 'JOURNAL ARTICLE' AND C.DOCTYPE < > 'PROCEEDING'AND BLDVALUE > 0 AND A.DOCACCS > 0

3.20 COUNT DISTINCT SUBJECT CODE REFERENCES FOR ALL PHASESOF THE SURVEY (EXCLUDING BOOKS, ABSTRACTS, JOURNALARTICLES, AND PROCEEDINGS) (C2_DSUBJALLSURV)

This query is used to count all distinct references to subject keywords, for the entire survey,that are associated with document types other than abstracts, books, journal articles, and proceedings. Thecount of 323 distinct subject keyword references developed by this query was used on page 4-2 of LSSTask 2 Report.

SELECT COUNT(DISTINCT(A.SUBJKWD))FROM DOCSUBJ A, BLD_DOCS B, DOCTYPE CWHERE A.BLDACCS = B.BLDACCS AND A.BLDACCS = C.BLDACCS AND

C.DOCTYPE < > 'ABSTRACT' AND C.DOCTYPE < > 'BOOK' ANDC.DOCTYPE < > 'JOURNAL ARTICLE' AND C.DOCTYPE < > 'PROCEEDING'AND BLDVALUE > 0 AND A.BLDACCS > 0

3.21 COUNT DISTINCT THESAURUS KEYWORD REFERENCES FOR ALLPHASES OF THE SURVEY (EXCLUDING ABSTRACTS, BOOKS,JOURNAL ARTICLES, AND PROCEEDINGS) (C2_DTHESALLSURV)

This query is used to count the number of distinct thesaurus keywords following the mappingof subject keywords into thesaurus keyword categories. The count includes all references, in the entiresurvey, that are associated with document types other than abstracts, books, journal articles, andproceedings. The count of 202 keyword references developed by this query was used on page 4-2 of LSSTask 2 Report.

3-7

* S

SELECT COUNT(DISTINCT(A.STDKWD))FROM DOCSUBJ A, BLDDOCS B, DOCTYPE CWHERE A.BLDACCS = B.BLDACCS AND A.BLDACCS = C.BLDACCS AND

C.DOCTYPE < > 'ABSTRACT' AND C.DOCTYPE < > 'BOOK' ANDC.DOCTYPE < > 'JOURNAL ARTICLE' AND C.DOCTYPE < > 'PROCEEDING'AND BLDVALUE > 0 AND A.BLDACCS > 0 AND A.THESAURUS = 'Y'

3.22 COUNT THESAURUS REFERENCES FOR ALL PHASES OF THESURVEY (EXCLUDING ABSTRACTS, BOOKS, JOURNAL ARTICLES,AND PROCEEDINGS) (C2_D_THESREFSURV)

This query is used to count thesaurus keywords, for the entire survey, that are associated withdocument types other than abstracts, books, journal articles, and proceedings. Baseline documents arealso excluded from this query.

SELECT COUNT(*)FROM DOCSUBJ A, BLD_DOCS B, DOCTYPE CWHERE A.BLDACCS = B.BLDACCS AND A.BLDACCS = C.BLDACCS AND

C.DOCTYPE < > 'ABSTRACT' AND C.DOCTYPE < > 'BOOK' ANDC.DOC TYPE < > 'JOURNAL ARTICLE' AND C.DOC TYPE < > 'PROCEEDING'AND BLDVALUE > 0 AND A.BLDACCS > 0 AND A.THESAURUS = 'Y'

3.23 COUNT DISTINCT DOCUMENT TYPE REFERENCES FOR ALLPHASES OF THE SURVEY (EXCLUDING ABSTRACTS, BOOKS,JOURNAL ARTICLES, AND PROCEEDINGS) (C2_D_TYPEALLSURV)

This query is used to count the distinct document type references, for the entire survey, that areassociated with document types other than abstracts, books, journal articles, and proceedings. Baselinedocuments are also excluded from this query.

SELECT COUNT(DISTINCT(DOCTYPE))FROM DOCTYPEWHERE DOCTYPE < > 'ABSTRACT' AND DOCTYPE < > 'BOOK' AND

DOCTYPE < > 'JOURNAL ARTICLE' AND DOCTYPE < > 'PROCEEDING' ANDBLDACCS > 0

3.24 COUNT ALL REFERENCES FOR PHASE 1 OF THE SURVEY(EXCLUDING ABSTRACTS, BOOKS, JOURNAL ARTICLES, ANDPROCEEDINGS) (C2 REFALLPH1)

This query is used to count document references, for phase 1 of the survey, that are associatedwith document types other than abstracts, books, journal articles and proceedings. The count of 607document references developed by this query was used on page 1-1 of LSS Task 2 Report.

3-8

SELECT COUNT(*)FROM RESPDOC A, BLDDOCS B, DOCTYPE CWHERE A.DOCACCS = B.BLD_ACCS AND A.DOCACCS = C.BLD ACCS AND


3.25 COUNT ALL REFERENCES FOR PHASE 2 OF THE SURVEY(EXCLUDING ABSTRACTS, BOOKS, JOURNAL ARTICLES, ANDPROCEEDINGS) (C2_REFALL_P12)

This query is used to count document references, for phase 2 of the survey, that are associatedwith document types other than abstracts, books, journal articles and proceedings. The count of 515document references developed by this query was used on page 1-1 of LSS Task 2 Report.

SELECT COUNT(*)FROM RESPDOC A, BLD_DOCS B, DOCTYPE CWHERE A.DOC ACCS = B.BLD ACCS AND A.DOC ACCS = C.BLD ACCS AND


3.26 COUNT ALL REFERENCES FOR ALL PHASES OF THE SURVEY(EXCLUDING ABSTRACTS, BOOKS, JOURNAL ARTICLES, ANDPROCEEDINGS) (C2_REFALLSURV)

This query is used to count document references, for all phases of the survey, that are associatedwith document types other than abstracts, books, journal articles, and proceedings.

SELECT COUNT(*)FROM RESPDOC A, BLDDOCS B, DOCTYPE CWHERE A.DOCACCS = B.BLDACCS AND A.DOCACCS = C.BLDACCS AND

C.DOCTYPE < > 'ABSTRACT' AND C.DOCTYPE < > 'BOOK' ANDC.DOCTYPE < > 'JOURNAL ARTICLE' AND C.DOCTYPE < > 'PROCEEDING'AND BLD_VALUE > 0 AND A.DOCACCS > 0

3.27 COUNT HIGH-VALUE REFERENCES FOR PHASE 1 OF THE SURVEY(EXCLUDING ABSTRACTS, BOOKS, JOURNAL ARTICLES, ANDPROCEEDINGS) (C2_REF_HV_PH1)

This query is used to count high-value document references (value code > 3), for phase 1 ofthe survey, that are associated with document types other than abstracts, books, journal articles andproceedings.

3-9

0 0

SELECT COUNT(*)FROM RESPDOC A, BLDDOCS B, DOCTYPE CWHERE A.DOC ACCS = B.BLDACCS AND A.DOC ACCS = C.BLD ACCS AND


3.28 COUNT HIGH-VALUE REFERENCES FOR PHASE 2 OF THE SURVEY(EXCLUDING ABSTRACTS, BOOKS, JOURNAL ARTICLES, ANDPROCEEDINGS) (C2_REF_HV_PH2)

This query is used to count high-value document references (value code > 3), for phase 2 ofthe survey, that are associated with document types other than abstracts, books, journal articles, andproceedings.

SELECT COUNT(*)FROM RESPDOC A, BLD_DOCS B, DOCTYPE CWHERE A.DOCACCS = B.BLDACCS AND A.DOCACCS = C.BLDACCS AND


3.29 COUNT HIGH-VALUE REFERENCES FOR ALL PHASES OF THESURVEY (EXCLUDING ABSTRACTS, BOOKS, JOURNAL ARTICLES,AND PROCEEDINGS) (C2_REF_HV_SURV)

This query is used to count high-value document references (value code > 3), for all phasesof the survey, that are associated with document types other than abstracts, books, journal articles, andproceedings.

SELECT COUNT(*)FROM RESPDOC A, BLD_DOCS B, DOCTYPE CWHERE A.DOCACCS = B.BLDACCS AND A.DOCACCS = C.BLDACCS AND

C.DOCTYPE < > 'ABSTRACT' AND C.DOCTYPE < > 'BOOK' ANDC.DOCTYPE < > 'JOURNAL ARTICLE' AND C.DOC TYPE < >'PROCEEDING' AND BLDVALUE > 3 AND A.DOCACCS > 0

3.30 COUNT ALL SOURCE REFERENCES FOR ALL PHASES OF THESURVEY (EXCLUDING ABSTRACTS, BOOKS, JOURNAL ARTICLES,AND PROCEEDINGS) (C2_SRCEALLSURV)

This query is used to count all references to document sources, for the entire survey, that areassociated with document types other than abstracts, books, journal articles, and proceedings. The countof 743 source references developed by this query was used on page 4-7 of LSS Task 2 Report.

3-10

* 0

SELECT COUNT(*)FROM DOCSRCE A, BLD_DOCS B, DOCTYPE CWHERE A.BLDACCS = B.BLDACCS AND A.BLDACCS = C.BLDACCS

AND C.DOCTYPE < > 'ABSTRACT' AND C.DOCTYPE < > 'BOOK' ANDC.DOCTYPE < > 'JOURNAL ARTICLE' AND C.DOCTYPE 'PROCEEDING'AND BLDVALUE > 0 AND A.BLDACCS > 0

3.31 COUNT ALL THESAURUS REFERENCES FOR ALL PHASES OF THESURVEY (EXCLUDING ABSTRACTS, BOOKS, JOURNAL ARTICLES,AND PROCEEDINGS) (C2_THESALLSURV)

This query is used to count the number of thesaurus (subject) keyword references that areassociated with all document types except abstracts, books, journal articles, and proceedings, for theentire survey. The count of 1186 keyword references developed by this query was used on page 4-2 ofLSS Task 2 Report.

SELECT COUNT(*)FROM DOCSUBJ A, BLDDOCS B, DOCTYPE CWHERE A.BLDACCS = B.BLDACCS AND A.BLD ACCS = C.BLDACCS

AND C.DOC TYPE < > 'ABSTRACT' AND C.DOC TYPE < > 'BOOK' ANDC.DOCTYPE < > 'JOURNAL ARTICLE' AND C.DOCTYPE < > 'PROCEEDING'AND BLDVALUE > 0 AND A.BLDACCS > 0

3.32 LIST DOCUMENTS (EXCLUDING BOOKS, JOURNALS,PROCEEDINGS, AND ABSTRACTS) FOR CATEGORY 5,CALCULATING A PRIORITY FACTOR BASED UPON VALUE,EASE OF ACCESS, AND USE FACTOR (CATPRIORITY_1)

This query lists document types, titles and computed priority values for documentary materialwithin the proposed priority loading category groups. Documents from all phases of the survey areincluded. Abstracts, books, journal articles, and proceedings are excluded from this query. A form namedCATPRIORITY is associated with this query and should be used to obtain proper formatting of the data.Partial results of this query appear in Table 6-1 found on page 6-8 of LSS Task 2 Report.

SELECT B.CAT_05, C.CATDESCR, A.BLDACCS, D.DOCTYPE, A.BLDTITLE,((2.0 * A.BLD_VALUE) * (2.0*(6-A.BLDEASEACCESS)) + (1.0*D.USEFACTOR))

FROM BLDDOCS A, CATDOC B, CATEGORY C, TYPEMASTER D, DOCTYPE EWHERE B.CAT_05 > 59 AND E.STDTYPE < > 'BOOK' AND

E.STDTYPE < > 'JOURNAL ARTICLE' AND E.STD TYPE < > 'PROCEEDING'AND E.STDTYPE < > 'ABSTRACT' AND B.DOCACCS = A.BLDACCS ANDB.CAT_05 = C.CATACCS AND A.BLDACCS = E.BLDACCS AND E.DOCTYPE= D.DOC TYPE

ORDER BY 1,6,5

3-11

3.33 DISTINCT LISTING AND COUNT OF DOCUMENT TYPES (DTYPE)

This query lists the distinct document types along with counts of the number of references foreach. A form named D TYPE is associated with this query and should be used for proper formatting ofthe data. The count of report references developed by this query was used to compute the percentage ofreports indicated on page 2-1 of LSS Task 2 Report.

SELECT DOCTYPE, COUNT(*)FROM DOCTYPEGROUP BY DOCTYPEORDER BY 1

3.34 LISTING AND COUNT OF AUTHORS FOR ALL DOCUMENTS(EXCLUDING ABSTRACTS, BOOKS, JOURNAL ARTICLES, ANDPROCEEDINGS) FOR ALL PHASES OF THE SURVEY(F2_AUTHALLSURV)

This query is used to list authors of referenced documents other than abstracts, books, journalarticles, and periodicals. The query has an associated form named F2_AUTHALLSURV that shouldbe used to obtain proper formatting. This query was used to develop the number of authors referencedmore than 5 times, and the 4 most frequently referenced authors mentioned on page 4-1 of LSS Task 2Report.

SELECT A.AUTH_L_NAME, A.AUTH_F_NAME, A.AUTHINIT, COUNT(*),(100.00 * COUNT(*)/372)

FROM AUTHOR A, BLDAUTHOR D, BLDDOCS B, DOCTYPE CWHERE D.BLDACCS = B.BLD ACCS AND A.AUTHACCS = D.AUTHACCS AND

D.BLDACCS = C.BLDACCS AND C.DOCTYPE < > 'ABSTRACT' ANDC.DOCTYPE < > 'BOOK' AND C.DOCTYPE < > 'JOURNAL ARTICLE' ANDC.DOCTYPE < > 'PROCEEDING' AND D.BLDACCS > 0

GROUP BY A.AUTH_L_NAME, A.AUTHF_NAME, A.AUTHINITORDER BY 4

3.35 LISTING AND COUNT OF DOCUMENT SOURCES FOR ALLDOCUMENTS (EXCLUDING ABSTRACTS, BOOKS, JOURNALARTICLES, AND PROCEEDINGS) FOR PHASE 1 OF THE SURVEY(F2_SRCEALLPH1 )

This query lists document sources in alphabetical sequence, with counts and percentages of thereferences for each source, for all documents in phase 1 of the survey. Abstracts, books, journal articles,and proceedings are excluded from this query. A form named F2_SRCEALLPHI is associated withthis query and should be used to obtain proper formatting of the data. Partial results of this query appearin column 1 of Table 4-2 found on page 4-8 of LSS Task 2 Report.

3-12

SELECT A.DOCSRCE, COUNT(*), (100.00 * COUNT(*)/385)FROM DOCSRCE A, BLDDOCS B, DOCTYPE CWHERE A.BLDACCS = B.BLD ACCS AND A.BLD ACCS = C.BLDACCS AND

C.DOCTYPE < > 'ABSTRACT' AND C.DOCTYPE < > 'BOOK' ANDC.DOCTYPE < > 'JOURNAL ARTICLE' AND C.DOCTYPE < > 'PROCEEDING'AND A.BLDACCS < 384

GROUP BY A.DOCSRCEORDER BY 1

3.36 LISTING AND COUNT OF DOCUMENT SOURCES FOR ALLDOCUMENTS (EXCLUDING ABSTRACTS, BOOKS, JOURNALARTICLES, AND PROCEEDINGS) FOR PHASE 2 OF THE SURVEY(F2_SRCEALLPH2)

This query lists document sources in alphabetical sequence, with counts and percentages of thereferences for each source, for all documents in phase 2 of the survey. Abstracts, books, journal articles,and proceedings are excluded from this query. A form named F2 SRCEALLPH2 is associated withthis query and should be used to obtain proper formatting of the data. Partial results of this query appearin column 2 of Table 4-2 found on page 4-8 of LSS Task 2 Report.

SELECT A.DOC_SRCE, COUNT(*), (100.00 * COUNT(*)/358)FROM DOCSRCE A, BLDDOCS B, DOCTYPE CWHERE A.BLDACCS = B.BLDACCS AND A.BLDACCS = C.BLDACCS

AND C.DOCTYPE < > 'ABSTRACT' AND C.DOC_TYPE < > 'BOOK' ANDC.DOCTYPE < > 'JOURNAL ARTICLE' AND C.DOCTYPE < > 'PROCEEDING'AND A.BLDACCS > 383


3.37 LISTING AND COUNT OF DOCUMENT SOURCES FOR ALLDOCUMENTS (EXCLUDING ABSTRACTS, BOOKS, JOURNALARTICLES, AND PROCEEDINGS) FOR ALL PHASES OF THE SURVEY(F2_SRCE_ALLSURV)

This query lists document sources in alphabetical sequence, with counts and percentages of thereferences for each source, for all documents in all phases of the survey. Abstracts, books, journalarticles, and proceedings are excluded from this query. A form named F2_SRCEALLSURV isassociated with this query and should be used to obtain proper formatting of the data. Partial results ofthis query appear in column 3 of Table 4-2 found on page 4-8 of LSS Task 2 Report.

3-13

SELECT A.DOC_SRCE, COUNT(*), (100.00 * COUNT(*)/743)FROM DOCSRCE A, BLDDOCS B, DOCTYPE CWHERE A.BLD_ACCS = B.BLD_ACCS AND A.BLD ACCS = C.BLDACCS AND

C.DOCTYPE < > 'ABSTRACT' AND C.DOC_TYPE < > 'BOOK' ANDC.DOCTYPE < > 'JOURNAL ARTICLE' AND C.DOC_TYPE < > 'PROCEEDING'AND A.BLDACCS > 0


3.38 LISTING AND COUNT OF DOCUMENT SOURCES FOR HIGH-VALUEDOCUMENTS (EXCLUDING ABSTRACTS, BOOKS, JOURNALARTICLES, AND PROCEEDINGS) FOR PHASE 1 OF THE SURVEY(F2_SRCE_HV_PH1)

This query lists document sources in alphabetical sequence, with counts and percentages of thereferences for each source, for high-value documents (value code > 3), in phase 1 of the survey.Abstracts, books, journal articles, and proceedings are excluded from this query. A form namedF2_SRCEHV PH 1 is associated with this query and should be used to obtain proper formatting of thedata. Partial results of this query appear in column 4 of Table 4-2 found on page 4-8 of LSS Task 2Report.

SELECT A.DOCSRCE, COUNT(*), (100.00 * COUNT(*)/297)FROM DOCSRCE A, BLD_DOCS B, DOCTYPE CWHERE A.BLD ACCS = B.BLDACCS AND A.BLD ACCS = C.BLD ACCS AND

C.DOCTYPE < > 'ABSTRACT' AND C.DOCTYPE < > 'BOOK' ANDC.DOCTYPE < > 'JOURNAL ARTICLE' AND C.DOCTYPE < > 'PROCEEDING'AND BLDVALUE > 3 AND A.BLD_ACCS < 384

GROUP BY A.DOCSRCEORDER BY 1 -

3.39 LISTING AND COUNT OF DOCUMENT SOURCES FOR HIGH-VALUEDOCUMENTS (EXCLUDING ABSTRACTS, BOOKS, JOURNALARTICLES, AND PROCEEDINGS) FOR PHASE 2 OF THE SURVEY(F2_SRCE_HV`_PH2)

This query lists document sources in alphabetical sequence, with counts and percentages of thereferences for each source, for high-value documents (value code > 3), in phase 2 of the survey.Abstracts, books, journal articles, and proceedings are excluded from this query. A form namedF2_SRCEHVPH2 is associated with this query and should be used to obtain proper formatting of thedata. Partial results of this query appear in column 5 of Table 4-2 found on page 4-8 of LSS Task 2Report.

3-14

0 0

SELECT A.DOCSRCE, COUNT(*), (100.00 * COUNT(*)/270)FROM DOCSRCE A, BLD_DOCS B, DOCTYPE CWHERE A.BLDACCS = B.BLDACCS AND A.BLDACCS = C.BLDACCS AND

C.DOCTYPE < > 'ABSTRACT' AND C.DOC TYPE < > 'BOOK' ANDC.DOCTYPE < > 'JOURNAL ARTICLE' AND C.DOCTYPE < > 'PROCEEDING'AND BLDVALUE > 3 AND A.BLDACCS > 383


3.40 LISTING AND COUNT OF DOCUMENT SOURCES FOR HIGH-VALUEDOCUMENTS (EXCLUDING ABSTRACTS, BOOKS, JOURNALARTICLES, AND PROCEEDINGS) FOR ALL PHASES OF THE SURVEY(F2 SRCEHV SURV)

This query lists document sources in alphabetical sequence, with counts and percentages of thereferences for each source, for high-value documents (value code > 3), in all phases of the survey.Abstracts, books, journal articles, and proceedings are excluded from this query. A form namedF2_SRCEHVSURV is associated with this query and should be used to obtain proper formatting of thedata. Partial results of this query appear in column 6 of Table 4-2 found on page 4-8 of LSS Task 2Report.

SELECT A.DOC_SRCE, COUNT(*), (100.00 * COUNT(*)/567)FROM DOCSRCE A, BLD_DOCS B, DOCTYPE CWHERE A.BLDACCS = B.BLDACCS AND A.BLD ACCS = C.BLDACCS AND

C.DOC TYPE < > 'ABSTRACT' AND C.DOC TYPE < > 'BOOK' ANDC.DOCTYPE < > 'JOURNAL ARTICLE' AND C.DOCTYPE < > 'PROCEEDING'AND BLDVALUE > 3 AND A.BLDACCS > 0


3.41 LISTING AND COUNT OF KEYWORDS BY SELECTED DOCUMENTSOURCES FOR ALL DOCUMENTS (EXCLUDING ABSTRACTS, BOOKS,JOURNAL ARTICLES, AND PROCEEDINGS) (F2_SRCTYPALLSUR)

This query lists subject keywords in alphabetical sequence, with counts for selected documentsources. The document sources for this query are DOE, NRC, DOE CONTRACTORS, CNWRA,LLNL, LANL, USGS, SANDIA, DOE-YMPO, UNIVERSITY OF NEVADA, and BATTELLE-PNL.Abstracts, books, journal articles, and proceedings are excluded from this query. A form namedF2_SRCTYPAUSUR is associated with this query and should be used to obtain proper formatting ofthe data. Partial results of this query appear in Table 4-5 found on pages 4-14 to 4-16 of LSS Task 2Report.

3-15

SELECT A.DOC_SRCE, D. THESAURUS, D. STDKWD, COUNT(*)FROM DOCSRCE A, BLDDOCS B, DOCTYPE C, DOC_SUBJ DWHERE (A.DOCSRCE = 'DOE' OR A.DOCSRCE = 'NRC' OR

A.DOCSRCE = 'CNWRA' OR A.DOCSRCE = 'LLNL' OR A.DOCSRCE ='LANL' OR A.DOCSRCE = 'USGS' OR A.DOCSRCE = 'SANDIA' ORA.DOCSRCE = 'DOE-YMPO' OR A.DOCSRCE = 'DOE CONTRACTORS' ORA.DOCSRCE = 'UNIVERSITY OF NEVADA' OR A.DOCSRCE = 'BATTELLE-PNL') AND A.BLDACCS = B.BLDACCS AND A.BLDACCS = C.BLDACCS ANDA.BLDACCS = D.BLDACCS AND C.DOCTYPE < > 'ABSTRACT' ANDC.DOCTYPE < > 'BOOK' AND C.DOCTYPE < > 'JOURNAL ARTICLE' ANDC.DOCTYPE < > 'PROCEEDING' AND A.BLDACCS > 0

GROUP BY A.DOCSRCE, D.THESAURUS, D.STDKWDORDER BY 1 ,3

3.42 LISTING AND COUNT OF STANDARD DOCUMENT TYPES BYSELECTED DOCUMENT SOURCES FOR ALL DOCUMENTS(EXCLUDING ABSTRACTS, BOOKS, JOURNAL ARTICLES, ANDPROCEEDINGS) (F2 SRC STYP ALL SV)

This query lists document types, following reclassification into non-text-searchable categories,in alphabetical sequence with counts for selected document sources. The document sources for this queryare DOE, NRC, DOE CONTRACTORS, CNWRA, LLNL, LANL, USGS, SANDIA, DOE-YMPO,UNIVERSITY OF NEVADA, and BATTELLE-PNL. Abstracts, books, journal articles, and proceedingsare excluded from this query. A form named F2_SRCSTYPALLSV is associated with this query andshould be used to obtain proper formatting of the data. Partial results of this query appear in Table 4-7found on page 4-19 of LSS Task 2 Report.

SELECT A.DOC_SRCE, C.STDTYPE, COUNT(*)FROM DOCSRCE A, BLDDOCS B, DOCTYPE CWHERE (A.DOCSRCE = 'DOE' OR A.DOCSRCE = 'NRC' OR

OR A.DOCSRCE = 'CNWRA' OR A.DOCSRCE = 'LLNL' OR A.DOCSRCE ='LANL' OR A.DOCSRCE = 'USGS' OR A.DOCSRCE = 'SANDIA' ORA.DOCSRCE = 'DOE-YMPO' OR A.DOCSRCE = 'DOE CONTRACTORS' ORA.DOCSRCE = 'UNIVERSITY OF NEVADA' OR A.DOCSRCE ='BATTELLE-PNL') AND A.BLDACCS = B.BLDACCS AND A.BLDACCS =C.BLDACCS AND C.DOCTYPE < > 'ABSTRACT' AND C.DOCTYPE < >'BOOK' AND C.DOCTYPE < > 'JOURNAL ARTICLE' AND C.DOCTYPE < >'PROCEEDING' AND A.BLDACCS > 0

GROUP BY A.DOC_SRCE, C.STDTYPEORDER BY 1 ,2

3-16

3.43 LISTING AND COUNT OF DOCUMENT TYPES BY SELECTEDDOCUMENT SOURCES FOR ALL DOCUMENTS (EXCLUDINGABSTRACTS, BOOKS, JOURNAL ARTICLES, AND PROCEEDINGS)(F2_SRC_TYP_ALL-SUR)

This query lists document types in alphabetical sequence with counts for selected documentsources. The document sources for this query are DOE, NRC, DOE CONTRACTORS, CNWRA, LLNL,LANL, USGS, SANDIA, DOE-YMPO, UNIVERSITY OF NEVADA, and BATTELLE-PNL. Abstracts,books, journal articles, and proceedings are excluded from this query. A form namedF2_SRCTYPALLSUR is associated with this query and should be used to obtain proper formattingof the data. Partial results of this query appear in Table 4-6 found on page 4-18 of LSS Task 2 Report.

SELECT A.DOC SRCE, C.DOCTYPE, COUNT(*)FROM DOCSRCE A, BLD_DOCS B, DOCTYPE CWHERE (A.DOCSRCE = 'DOE' OR A.DOCSRCE = 'NRC' OR

A.DOCSRCE = 'CNWRA' OR A.DOCSRCE = 'LLNL' OR A.DOCSRCE = 'LANL'OR A.DOC SRCE = 'USGS' OR A.DOC_SRCE = 'SANDIA' OR A.DOC SRCE ='DOE-YMPO' OR A.DOCSRCE = 'DOE CONTRACTORS' OR A.DOCSRCE='BATTELLE-PNL' OR A.DOCSRCE = 'UNIVERSITY OF NEVADA' ) ANDA.BLDACCS = B.BLDACCS AND A.BLD_ACCS = C.BLD_ACCS ANDC.DOCTYPE 'ABSTRACT' AND C.DOCTYPE < > 'BOOK' ANDC.DOCTYPE < > 'JOURNAL ARTICLE' AND C.DOCTYPE < > 'PROCEEDING'AND A.BLDACCS > 0

GROUP BY A.DOCSRCE, C.DOC_TYPEORDER BY 1 ,2

3.44 LISTING AND COUNT OF STANDARD DOCUMENT TYPES FOR ALLDOCUMENTS (EXCLUDING ABSTRACTS, BOOKS, JOURNALARTICLES, AND PROCEEDINGS) FOR PHASE 1 OF THE SURVEY(F2_STYPALLPHI)

This query lists standard document types, following reclassification of non-text-searchabledocumentary materials, in alphabetical sequence with counts and percentages of the references for eachstandard type, for all documents in phase 1 of the survey. Abstracts, books, journal articles, andproceedings are excluded from this query. A form named F2_STYP_ALL_PH1 is associated with thisquery and should be used to obtain proper formatting of the data. Partial results of this query appear incolumn 1 of Table 4-4 found on pages 4-12 and 4-13 of LSS Task 2 Report.

SELECT A.STDTYPE, COUNT(*), (100.00 * COUNT(*) / 265)FROM DOCTYPE A, BLDDOCS BWHERE A.BLDACCS = B.BLDACCS AND DOCTYPE < > 'ABSTRACT' AND

DOCTYPE < > 'BOOK' AND DOCTYPE < > 'JOURNAL ARTICLE' ANDDOCTYPE < > 'PROCEEDING' AND A.BLDACCS < 384

GROUP BY STDTYPEORDER BY 1

3-17

0 0

3.45 LISTING AND COUNT OF STANDARD DOCUMENT TYPES FOR ALLDOCUMENTS (EXCLUDING ABSTRACTS, BOOKS, JOURNALARTICLES, AND PROCEEDINGS) FOR PHASE 2 OF THE SURVEY(F2_STYP-ALLPH2)

This query lists standard document types, following reclassification of non-text-searchabledocumentary materials, in alphabetical sequence with counts and percentages of the references for eachstandard type, for all documents in phase 2 of the survey. Abstracts, books, journal articles, andproceedings are excluded from this query. A form named F2_STYPALLPH2 is associated with thisquery and should be used to obtain proper formatting of the data. Partial results of this query appear incolumn 2 of Table 4-4 found on pages 4-12 and 4-13 of LSS Task 2 Report.

SELECT A.STDTYPE, COUNT(*), (100.00 * COUNT(*) / 205)FROM DOC-TYPE A, BLD DOCS BWHERE A.BLDACCS = B.BLD ACCS AND DOCTYPE < > 'ABSTRACT' AND

DOCTYPE < > 'BOOK' AND DOCTYPE < > 'JOURNAL ARTICLE' ANDDOCTYPE < > 'PROCEEDING' AND A.BLDACCS > 383


3.46 LISTING AND COUNT OF STANDARD DOCUMENT TYPES FOR ALLDOCUMENTS (EXCLUDING ABSTRACTS, BOOKS, JOURNALARTICLES, AND PROCEEDINGS) FOR ALL PHASES OF THE SURVEY(F2_STYPALLSURV)

This query lists standard document types, following reclassification of non-text-searchabledocumentary materials, in alphabetical sequence with counts and percentages of the references for eachstandard type, for all documents in all phases of the survey. Abstracts, books, journal articles, andproceedings are excluded from this query. A form named F2_STYPALLSURV is associated with thisquery and should be used to obtain proper formatting of the data. Partial results of this query appear incolumn 3 of Table 4-4 found on pages 4-12 and 4-13 of LSS Task 2 Report.

SELECT A.STDTYPE, COUNT(*), (100.00 * COUNT(*) / 205)FROM DOCTYPE A, BLD_DOCS BWHERE A.BLDACCS = B.BLD ACCS AND DOCTYPE < > 'ABSTRACT' AND

DOC TYPE < > 'BOOK' AND DOCTYPE < > 'JOURNAL ARTICLE' ANDDOCGTYPE < > 'PROCEEDING' AND A.BLDACCS > 383


3-18

3.47 LISTING AND COUNT OF STANDARD DOCUMENT TYPES FOR HIGHVALUE DOCUMENTS (EXCLUDING ABSTRACTS, BOOKS, JOURNALARTICLES, AND PROCEEDINGS) FOR PHASE 1 OF THE SURVEY(F2_STYP_HV_PH1)

This query lists standard document types, following reclassification of non-text-searchabledocumentary materials, in alphabetical sequence with counts and percentages of the references, for eachstandard type, for high-value documents (value code > 3), in phase 1 of the survey. Abstracts, books,journal articles, and proceedings are excluded from this query. A form named F2_STYP_HV_PH1 isassociated with this query and should be used to obtain proper formatting of the data. Partial results ofthis query appear in column 4 of Table 44 found on pages 4-12 and 4-13 of LSS Task 2 Report.

SELECT A.STDTYPE, COUNT(*), (100.00 * COUNT(*) / 213)FROM DOCTYPE A, BLDDOCS BWHERE A.BLDACCS = B.BLD ACCS AND DOCTYPE < > 'ABSTRACT' AND

DOCTYPE < > 'BOOK' AND DOCTYPE < > 'JOURNAL ARTICLE' ANDDOCTYPE < > 'PROCEEDING' AND B.BLD_VALUE > 3 ANDA.BLDACCS < 384


3.48 LISTING AND COUNT OF STANDARD DOCUMENT TYPES FOR HIGHVALUE DOCUMENTS (EXCLUDING ABSTRACTS, BOOKS, JOURNALARTICLES, AND PROCEEDINGS) FOR PHASE 2 OF THE SURVEY(F2_STYPHVPH2)

This query lists standard document types, following reclassification of non-text-searchabledocumentary materials, in alphabetical sequence with counts and percentages of the references for eachstandard type, for high-value documents (value code > 3), in phase 2 of the survey. Abstracts, books,journal articles and proceedings are excluded from this query. A form named F2_STYPHVPH2 isassociated with this query and should be used to obtain proper formatting of the data. Partial results ofthis query appear in column 5 of Table 4-4 found on pages 4-12 and 4-13 of LSS Task 2 Report.

SELECT A.STDTYPE, COUNT(*), (100.00 * COUNT(*) / 145)FROM DOCTYPE A, BLDDOCS BWHERE A.BLDACCS = B.BLD ACCS AND DOCGTYPE < > 'ABSTRACT' AND

DOCGTYPE < > 'BOOK' AND DOC-TYPE < > 'JOURNAL ARTICLE' ANDDOCTYPE < > 'PROCEEDING' AND B.BLDVALUE > 3 ANDA.BLDACCS > 383


3-19

3.49 LISTING AND COUNT OF STANDARD DOCUMENT TYPES FOR HIGHVALUE DOCUMENTS (EXCLUDING ABSTRACTS, BOOKS, JOURNALARTICLES, AND PROCEEDINGS) FOR ALL PHASES OF THE SURVEY(F2_STYPHVSURV)

This query lists standard document types, following reclassification of non-text-searchabledocumentary materials, in alphabetical sequence with counts and percentages of the references for eachstandard type, for high-value documents (value code > 3), in all phases of the survey. Abstracts, books,journal articles, and proceedings are excluded from this query. A form named F2_STYPHVSURV isassociated with this query and should be used to obtain proper formatting of the data. Partial results ofthis query appear in column 6 of Table 44 found on pages 4-12 and 4-13 of LSS Task 2 Report.

SELECT A.STDTYPE, COUNT(*), (100.00 * COUNT(*) / 358)FROM DOCTYPE A, BLDDOCS BWHERE A.BLDACCS = B.BLDACCS AND DOCTYPE < > 'ABSTRACT' AND

DOCTYPE < > 'BOOK' AND DOCTYPE < > 'JOURNAL ARTICLE' ANDDOCTYPE < > 'PROCEEDING' AND B.BLDVALUE > 3 ANDA.BLDACCS > 0


3.50 LISTING AND COUNT OF THESAURUS KEYWORDS FOR ALLDOCUMENTS (EXCLUDING ABSTRACTS, BOOKS, JOURNALARTICLES, AND PROCEEDINGS) FOR PHASE 1 OF THE SURVEY(F2_THESALL_PH1)

This query lists thesaurus keywords in alphabetical sequence, with counts and percentages ofthe references for each keyword, for all documents in phase 1 of the survey. Abstracts, books, journalarticles, and proceedings are excluded from this query. A form named F2_THESALLPHI is associatedwith this query and should be used to obtain proper formatting of the data. Partial results of this queryappear in column 1 of Table 4-1 found on pages 4-4 to 4-6 of LSS Task 2 Report.

SELECT A.THESAURUS, A.STDKWD COUNT(*), (100.00 * COUNT(*) / 716)FROM DOCSUBJ A, BLDDOCS B, DOC-TYPE CWHERE A.BLDACCS = B.BLDACCS AND A.BLDACCS = C.BLD_ACCS AND

C.DOCTYPE < > 'ABSTRACT' AND C.DOCTYPE < > 'BOOK' ANDC.DOC_TYPE < > 'JOURNAL ARTICLE' AND C.DOCTYPE < > 'PROCEEDING'AND BLDVALUE > 0 AND A.BLD_ACCS < 384

GROUP BY A.THESAURUS, A.STD_KWDORDER BY 2

3-20

3.51 LISTING AND COUNT OF THESAURUS KEYWORDS FOR ALLDOCUMENTS (EXCLUDING ABSTRACTS, BOOKS, JOURNALARTICLES, AND PROCEEDINGS) FOR PHASE 2 OF THE SURVEY(F2_THES-ALLP1112)

This query lists thesaurus keywords in alphabetical sequence, with counts and percentages ofthe references for each keyword, for all documents in phase 2 of the survey. Abstracts, books, journalarticles, and proceedings are excluded from this query. A form named F2 THESALLPH2 is associatedwith this query and should be used to obtain proper formatting of the data. Partial results of this queryappear in column 2 of Table 4-1 found on pages 4-4 to 4-6 of LSS Task 2 Report.

SELECT A.THESAURUS, A.STDKWD, COUNT(*), (100.00 * COUNT(*) / 470)FROM DOCSUBJ A, BLDDOCS B, DOCTYPE CWHERE A.BLDACCS = B.BLDACCS AND A.BLDACCS = C.BLDACCS AND

C.DOC TYPE < > 'ABSTRACT' AND C.DOC TYPE < > 'BOOK' ANDC.DOC TYPE < > 'JOURNAL ARTICLE' AND C.DOCTYPE < > 'PROCEEDING'AND BLDVALUE > 0 AND A.BLD ACCS > 383

GROUP BY A.THESAURUS, A.STDKWDORDER BY 2

3.52 LISTING AND COUNT OF THESAURUS KEYWORDS FOR ALLDOCUMENTS (EXCLUDING ABSTRACTS, BOOKS, JOURNALARTICLES, AND PROCEEDINGS) FOR ALL PHASES OF THE SURVEY(F2 THES ALL SURV)

This query lists thesaurus keywords in alphabetical sequence, with counts and percentages ofthe references for each keyword, for all documents in all phases of the survey. Abstracts, books, journalarticles, and proceedings are excluded from this query. A form named F2 THESALL SURV isassociated with this query and should be used to obtain proper formatting of the data. Partial results ofthis query appear in column 3 of Table 4-1 found on pages 4-4 to 4-6 of LSS Task 2 Report.

SELECT A.THESAURUS, A.STD KWD, COUNT(*), (100.00 * COUNT(*) / 1186)FROM DOC SUBJ A, BLDDOCS B, DOCTYPE CWHERE A.BLDACCS = B.BLD ACCS AND A.BLDACCS = C.BLDACCS AND

C.DOCTYPE < > 'ABSTRACT' AND C.DOC TYPE < > 'BOOK' ANDC.DOC TYPE < > 'JOURNAL ARTICLE' AND C.DOC TYPE < > 'PROCEEDING'AND BLD VALUE > 0 AND A.BLD ACCS > 0


3-21

* 0

3.53 LISTING AND COUNT OF THESAURUS KEYWORDS FOR HIGHVALUE DOCUMENTS (EXCLUDING ABSTRACTS, BOOKS, JOURNALARTICLES, AND PROCEEDINGS) FOR PHASE 1 OF THE SURVEY(F2_THES_HV_PH1)

This query lists thesaurus keywords in alphabetical sequence, with counts and percentages ofthe references for each keyword, for high-value documents (value code > 3), for phase 1 of the survey.Abstracts, books, journal articles, and proceedings are excluded from this query. A form namedF2_THESHVPHI is associated with this query and should be used to obtain proper formatting of thedata. Partial results of this query appear in column 4 of Table 4-1 found on pages 4-4 to 4-6 of LSSTask 2 Report.

SELECT A.THESAURUS, A.STDKWD, COUNT(*), (100.00 * COUNT(*) / 603)FROM DOC SUBJ A, BLD DOCS B, DOCGTYPE CWHERE A.BLD_ACCS = B.BLD ACCS AND A.BLD_ACCS = C.BLD_ACCS AND

C.DOCTYPE < > 'ABSTRACT' AND C.DOCTYPE < > 'BOOK' ANDC.DOCTYPE < > 'JOURNAL ARTICLE' AND C.DOCTYPE < > 'PROCEEDING'AND BLD_VALUE > 3 AND A.BLD_ACCS < 384


3.54 LISTING AND COUNT OF THESAURUS KEYWORDS FOR HIGHVALUE DOCUMENTS (EXCLUDING ABSTRACTS, BOOKS, JOURNALARTICLES, AND PROCEEDINGS) FOR PHASE 2 OF THE SURVEY(F2_THESHVPH2)

This query lists thesaurus keywords in alphabetical sequence, with counts and percentages ofthe references for each keyword, for high-value documents (value code > 3), for phase,'2 of the survey.Abstracts, books, journal articles, and proceedings are excluded from this query. A form namedF2_THESHVPH2 is associated with this query and should be used to obtain proper formatting of thedata. Partial results of this query appear in column 5 of Table 4-1 found on pages 4-4 to 4-6 of LSSTask 2 Report.

SELECT A.THESAURUS, A.STDKWD, COUNT(*), (100.00 * COUNT(*) / 317)FROM DOCSUBJ A, BLDDOCS B, DOCTYPE CWHERE A.BLD_ACCS = B.BLDACCS AND A.BLD_ACCS = C.BLD_ACCS AND

C.DOCTYPE < > 'ABSTRACT' AND C.DOCTYPE < > 'BOOK' ANDC.DOCTYPE < > 'JOURNAL ARTICLE' AND C.DOCTYPE < > 'PROCEEDING'AND BLDVALUE > 3 AND A.BLD_ACCS > 383


3-22

* 0

3.55 LISTING AND COUNT OF THESAURUS KEYWORDS FOR HIGHVALUE DOCUMENTS (EXCLUDING ABSTRACTS, BOOKS, JOURNALARTICLES, AND PROCEEDINGS) FOR ALL PHASES OF THE SURVEY(F2_THES_HV_SURV)

This query lists thesaurus keywords in alphabetical sequence, with counts and percentages ofthe references for each keyword, for high-value documents (value code > 3), for all phases of thesurvey. Abstracts, books, journal articles, and proceedings are excluded from this query. A form namedF2 THES HV SURV is associated with this query and should be used to obtain proper formatting of thedata. Partial results of this query appear in column 6 of Table 4-1 found on pages 4-4 to 4-6 of LSSTask 2 Report.

SELECT A.THESAURUS, A.STDKWD, COUNT(*), (100.00 * COUNT(*) / 920)FROM DOCSUBJ A, BLDDOCS B, DOCTYPE CWHERE A.BLDACCS = B.BLDACCS AND A.BLDACCS = C.BLDACCS AND

C.DOCTYPE < > 'ABSTRACT' AND C.DOCTYPE < > 'BOOK' ANDC.DOCTYPE < > 'JOURNAL ARTICLE' AND C.DOCTYPE < > 'PROCEEDING'AND BLD_VALUE > 3 AND A.BLDACCS > 0


3.56 LISTING AND COUNT OF DOCUMENT TYPES FOR ALL DOCUMENTS(EXCLUDING ABSTRACTS, BOOKS, JOURNAL ARTICLES, ANDPROCEEDINGS) FOR PHASE 1 OF THE SURVEY (F2_TYPEALLPHI)

This query lists document types in alphabetical sequence with counts and percentages of thereferences for each type, for all documents in phase 1 of the survey. Abstracts, books, journal articles,and proceedings are excluded from this query. A form named F2_TYPEALLPHI is associated withthis query and should be used to obtain proper formatting of the data. Partial results of tiis query appearin column 1 of Table 4-3 found on page 4-10 of LSS Task 2 Report.

SELECT A.DOCTYPE, COUNT(*), (100.00 * COUNT(*)/265)FROM DOCTYPE A, BLDDOCS BWHERE A.BLDACCS = B.BLD ACCS AND DOCTYPE < > 'ABSTRACT' AND

DOC TYPE < > 'BOOK' AND DOC TYPE < > 'JOURNAL ARTICLE' ANDDOC TYPE < > 'PROCEEDING' AND A.BLDACCS < 384

GROUP BY DOCTYPEORDER BY 2

3.57 LISTING AND COUNT OF DOCUMENT TYPES FOR ALL DOCUMENTS(EXCLUDING ABSTRACTS, BOOKS, JOURNAL ARTICLES, ANDPROCEEDINGS) FOR PHASE 2 OF THE SURVEY (F2_TYPEALL_PH2)

This query lists the distinct document types, along with counts of the number of references foreach, for all documents except abstracts, books, journal articles, and proceedings, for phase 2 of thesurvey. A form named F2_TYPEALLPH2 is associated with this query and should be used to obtain

3-23

* S

proper formatting of the data. The count of report references developed by this query was used tocompute the percentage of reports indicated on page 2-2 and partial results appear in column 2 of Table4-3 found on page 4-10 of LSS Task 2 Report.

SELECT A.DOCTYPE, COUNT(*), (100.00 * COUNT(*) / 205)FROM DOCTYPE A, BLDDOCS BWHERE A.BLDACCS = B.BLD ACCS AND DOCTYPE < > 'ABSTRACT' AND

DOCTYPE < > 'BOOK' AND DOCTYPE < > 'JOURNAL ARTICLE' ANDDOC TYPE < > 'PROCEEDING' AND A.BLD ACCS > 383


3.58 LISTING AND COUNT OF DOCUMENT TYPES FOR ALL DOCUMENTS(EXCLUDING ABSTRACTS, BOOKS, JOURNAL ARTICLES, ANDPROCEEDINGS) FOR ALL PHASES OF THE SURVEY(F2 TYPE ALL SURV)

This query lists document types in alphabetical sequence, with counts and percentages of thereferences for each type, for all documents in all phases of the survey. Abstracts, books, journal articles,and proceedings are excluded from this query. A form named F2_TYPEALLSURV is associated withthis query and should be used to obtain proper formatting of the data. Partial results of this query appearin column 3 of Table 4-3 found on page 4-10 of LSS Task 2 Report.

SELECT A.DOCTYPE, COUNT(*), (100.00 * COUNT(*) / 470)FROM DOCTYPE A, BLDDOCS BWHERE A.BLDACCS = B.BLD ACCS AND DOCTYPE < > 'ABSTRACT' AND

DOC-TYPE < > 'BOOK' AND DOC-TYPE < > 'JOURNAL ARTICLE' ANDDOCTYPE < > 'PROCEEDING' AND A.BLDACCS > 0

GROUP BY DOC-TYPE ,ORDER BY 2

3.59 LISTING AND COUNT OF DOCUMENT TYPES FOR HIGH-VALUEDOCUMENTS (EXCLUDING ABSTRACTS, BOOKS, JOURNALARTICLES, AND PROCEEDINGS) FOR PHASE 1 OF THE SURVEY(F2_TYPEHVPH1)

This query lists document types in alphabetical sequence with counts and percentages of thereferences for each type, for all high-value documents (value code > 3), in phase 1 of the survey.Abstracts, books, journal articles, and proceedings are excluded from this query. A form namedF2_TYPE HVPHI is associated with this query and should be used to obtain proper formatting of thedata. Partial results of this query appear in column 4 of Table 4-3 found on page 4-10 of LSS Task 2Report.

3-24

0 0

SELECT A.DOCTYPE, COUNT(*), (100.00 * COUNT(*) / 213)FROM DOCTYPE A, BLDDOCS BWHERE A.BLDACCS = B.BLDACCS AND DOCTYPE < > 'ABSTRACT' AND

DOCTYPE < > 'BOOK' AND DOCTYPE < > 'JOURNAL ARTICLE' ANDDOCTYPE < > 'PROCEEDING' AND B.BLDVALUE > 3 AND A.BLDACCS < 384


3.60 LISTING AND COUNT OF DOCUMENT TYPES FOR HIGH-VALUEDOCUMENTS (EXCLUDING ABSTRACTS, BOOKS, JOURNALARTICLES, AND PROCEEDINGS) FOR PHASE 2 OF THE SURVEY(F2_TYPEHVPH2)

This query lists document types in alphabetical sequence, with counts and percentages of thereferences for each type, for all high-value documents (value code > 3), in phase 2 of the survey.Abstracts, books, journal articles, and proceedings are excluded from this query. A form namedF2_TYPEHV PH2 is associated with this query and should be used to obtain proper formatting of thedata. Partial results of this query appear in co