## General Guidance on use of Operators {#general-guidance-on-use-of-operators .Appendix2}

Each time that you select a data field to search on, EDICS determines
the type of search operators which are valid as follows:

-   Text fields will have = , \<\>, LIKE, IS NULL, and IS NOT NULL
    operators. A text box will be provided to input the criteria.

-   Boolean (Yes / No) fields will have = and \<\> operators. A drop
    down list with Y for Yes and N for No will be provided to input the
    criteria.

-   Enumerated lists will have = and \<\> operators. A drop down list
    with the legal values for the item chosen will be provided to input
    the criteria.

-   Date fields will have =, \<\>, \<, \>, \<=, \>=, IS NULL and IS NOT
    NULL operators. An input field, masked to allow only date input,
    will be provided to input the criteria.

-   Number fields will have =, \<\>, \<, \>, \<=, \>=, IS NULL and IS
    NOT NULL operators. An input field, masked to allow only numeric
    input, will be provided to input the criteria.

The = operator should be used when you want to find an exact match to
the criteria you specify.

The \< (less than) operator should be used when you want to find all
values less than the number or date that you specify. The \> (greater
than), \<= (less than or equal to), and \>= (greater than or equal to)
operators provide analogous searches.

The IS NULL operator will search for all occurrences where no
information is entered in the subject field, i.e. the field is blank.
The IS NOT NULL operator will search for all occurrences where ANY
information is entered in the field, i.e. it is not blank.

The LIKE operator is a text-search operator which searches for all
occurrences of the specified criteria. It is used on text fields, and is
set up to follow the following rules:

-   It is case insensitive. Searching for ed, Ed, ED, or eD will return
    the same results.

-   Embedded spaces can be included in search phrases, e.g. you can
    search for **public law**

-   Any occurrence of the search phrase will be found. Searching for ed
    will find occurrences of **ed**, **ed**ucation, fr**ed**, and
    p**ed**estrian.

-   No quotes are needed around text strings. If you include a quote
    mark, it will be part of the search string.

## Collection Package Data Fields Available for Ad Hoc Report {#collection-package-data-fields-available-for-ad-hoc-report .Appendix2}

A number of data fields relating to collection packages are available
both for use as search criteria and for inclusion in a report. Each of
these data elements exists once for each collection, and they are
described in Table E-1 below. Note the following when using these data
fields:

1.  Data Fields which can take on only Y/N (i.e. Yes/No) values are
    useful to use as search criteria but usually not useful as report
    columns. If used as a report column, the field will be blank if it
    is No and will contain an "X" if it is Yes.

2.  Only unique occurrences are included in the output report.
    Therefore, for example, if you search on collections with Affects
    Farms = Y and include Current OMB Control Number as the output
    column, you may get a different result than if you report on Current
    Tracking and OMB Number. This is because the latter will include a
    separate entry for each version of collections with the same OMB
    Control Number.

Table E-1. Definition of Collection Package-related Data Items for Ad
Hoc Reporting

+-----------------------------+-----------------------------------------+
| **Data Item**               | **Description**                         |
+=============================+=========================================+
| Affects (Impacts) Small     | Indicates whether OMB Form 83-I         |
| Entities                    | question 5 is yes or no                 |
+-----------------------------+-----------------------------------------+
| Affects Business            | Indicates whether OMB Form 83-I         |
|                             | question 11b (affected public) is yes   |
|                             | or no.                                  |
+-----------------------------+-----------------------------------------+
| Affects Farms               | Indicates whether OMB Form 83-I         |
|                             | question 11d (affected public) is yes   |
|                             | or no.                                  |
+-----------------------------+-----------------------------------------+
| Affects Federal Govt.       | Indicates whether OMB Form 83-I         |
|                             | question 11e (affected public) is yes   |
|                             | or no.                                  |
+-----------------------------+-----------------------------------------+
| Affects Individuals or      | Indicates whether OMB Form 83-I         |
| Households                  | question 11a (affected public) is yes   |
|                             | or no.                                  |
+-----------------------------+-----------------------------------------+
| Affects Local Govt.,        | Indicates whether OMB Form 83-I         |
| SEAs/LEAs                   | question 11f (affected public) is yes   |
|                             | or no.                                  |
+-----------------------------+-----------------------------------------+
| Affects Non-Profits         | Indicates whether OMB Form 83-I         |
|                             | question 11c (affected public) is yes   |
|                             | or no.                                  |
+-----------------------------+-----------------------------------------+
| Collection Abstract         | Text of OMB Form 83-I question 10,      |
|                             | Abstract.                               |
+-----------------------------+-----------------------------------------+
| Collection Agency Forms     | Text of OMB Form 83-I question 8,       |
|                             | Agency Forms.                           |
+-----------------------------+-----------------------------------------+
| Collection Contains a       | Indicates whether OMB Form 83-I         |
| Proposed Reg.               | question 19 (regulatory information) is |
|                             | yes or no.                              |
+-----------------------------+-----------------------------------------+
| Collection Keywords         | Text of OMB Form 83-I question 9,       |
|                             | Keywords.                               |
+-----------------------------+-----------------------------------------+
| Collection Point of Contact | Text of OMB Form 83-I question 18,      |
|                             | Name.                                   |
+-----------------------------+-----------------------------------------+
| Collection Program Office   | The first four digits of OMB Form 83-I  |
| Number                      | question 2, OMB Control Number (e.g.    |
|                             | 1820).                                  |
+-----------------------------+-----------------------------------------+
| Collection Proposed Reg.    | The type of proposed regulation         |
| Type                        | included per OMB Form 83-I question 19. |
+-----------------------------+-----------------------------------------+
| Collection Subagency        | The text of the subagency identified in |
|                             | OMB Form 83-I question 1,               |
|                             | Agency/Subagency originating request.   |
+-----------------------------+-----------------------------------------+
| Collection Title            | Text of OMB Form 83-I question 7,       |
|                             | Title.                                  |
+-----------------------------+-----------------------------------------+
| Collection Type             | The type of collection as specified in  |
|                             | OMB Form 83-I question 3, Type of       |
|                             | Information Collection.                 |
+-----------------------------+-----------------------------------------+
| Collection uses Stat.       | Indicates whether OMB Form 83-I         |
| Methods                     | question 17 (statistical methods) is    |
|                             | yes or no.                              |
+-----------------------------+-----------------------------------------+
| Collection Version          | The version number of the collection    |
|                             | package as assigned by EDICS.           |
+-----------------------------+-----------------------------------------+
| Current OMB Control Number  | The full OMB Control Number (e.g.       |
|                             | 1820-0595) currently assigned to this   |
|                             | collection.                             |
+-----------------------------+-----------------------------------------+
| Current OMB Cost Burden     | The current cost burden as last         |
|                             | received from OMB (not necessarily the  |
|                             | same as the cost burden requested on    |
|                             | the Form 83-I).                         |
+-----------------------------+-----------------------------------------+
| Current OMB Expiration Date | The current expiration date as last     |
|                             | received from OMB.                      |
+-----------------------------+-----------------------------------------+
| Current OMB Hour Burden     | The current hour burden as last         |
|                             | received from OMB (not necessarily the  |
|                             | same as the hour burden requested on    |
|                             | the Form 83-I).                         |
+-----------------------------+-----------------------------------------+
| Current OMB Number of       | The current number of annual responses  |
| Annual Responses            | as last received from OMB (not          |
|                             | necessarily the same as the number of   |
|                             | annual responses requested on the Form  |
|                             | 83-I).                                  |
+-----------------------------+-----------------------------------------+
| Current Status              | The current clearance status of this    |
|                             | collection, i.e. under construction,    |
|                             | submitted, pending, active, or          |
|                             | inactive.                               |
+-----------------------------+-----------------------------------------+
| Current Tracking & OMB      | The EDICS tracking number and current   |
| Number                      | OMB number assigned to this collection, |
|                             | in the following format:                |
|                             |                                         |
|                             | (000103)1810-0123                       |
+-----------------------------+-----------------------------------------+
| Database Last Updated By    | The EDICS User ID of the last person to |
|                             | update the collection package           |
|                             | [database.]{.underline} (Does not track |
|                             | update of attachment files)             |
+-----------------------------+-----------------------------------------+
| Database Last Updated On    | The date of the last change to the      |
|                             | collection package database. Note that  |
|                             | changes to the tracking data for the    |
|                             | collection are tracked separately.      |
+-----------------------------+-----------------------------------------+
| Includes a Recordkeeping    | Indicates whether OMB Form 83-I         |
| Requirement                 | question 16a (frequency of              |
|                             | recordkeeping or reporting) is yes or   |
|                             | no.                                     |
+-----------------------------+-----------------------------------------+
| Includes a Reporting        | Indicates whether OMB Form 83-I         |
| Requirement                 | question 16c (frequency of              |
|                             | recordkeeping or reporting) is yes or   |
|                             | no.                                     |
+-----------------------------+-----------------------------------------+
| Includes a Third Party      | Indicates whether OMB Form 83-I         |
| Disclosure Rqmt             | question 16b (frequency of              |
|                             | recordkeeping or reporting) is yes or   |
|                             | no.                                     |
+-----------------------------+-----------------------------------------+
| Proposed % of Resps. which  | The percent of responses which are      |
| are Electronic              | collected electronically per OMB Form   |
|                             | 83-I question 13b1.                     |
+-----------------------------+-----------------------------------------+
| Proposed Annual Burden      | The number of annual burden hours per   |
| Hours                       | OMB Form 83-I question 13c.             |
+-----------------------------+-----------------------------------------+
| Proposed Annual Cost        | The annual cost burden per OMB Form     |
|                             | 83-I question 14c.                      |
+-----------------------------+-----------------------------------------+
| Proposed Annual O&M Costs   | The annual O&M cost burden per OMB Form |
|                             | 83-I question 14b.                      |
+-----------------------------+-----------------------------------------+
| Proposed Annualized Startup | The annualized startup cost burden per  |
| Cost                        | OMB Form 83-I question 14a.             |
+-----------------------------+-----------------------------------------+
| Proposed Number of Annual   | The number of annual responses per OMB  |
| Resps.                      | Form 83-I question 13b.                 |
+-----------------------------+-----------------------------------------+
| Proposed Number of          | The number of respondents per OMB Form  |
| Respondents                 | 83-I question 13a.                      |
+-----------------------------+-----------------------------------------+
| Purpose includes            | Indicates whether OMB Form 83-I         |
| Application for Ben.        | question 15a (purpose of information    |
|                             | collection) is yes or no.               |
+-----------------------------+-----------------------------------------+
| Purpose includes Gen.       | Indicates whether OMB Form 83-I         |
| Purpose Stats.              | question 15c (purpose of information    |
|                             | collection) is yes or no.               |
+-----------------------------+-----------------------------------------+
| Purpose includes Program    | Indicates whether OMB Form 83-I         |
| Evaluation                  | question 15b (purpose of information    |
|                             | collection) is yes or no.               |
+-----------------------------+-----------------------------------------+
| Purpose includes Research   | Indicates whether OMB Form 83-I         |
|                             | question 15f (purpose of information    |
|                             | collection) is yes or no.               |
+-----------------------------+-----------------------------------------+
| Purpose is for Audit        | Indicates whether OMB Form 83-I         |
|                             | question 15d (purpose of information    |
|                             | collection) is yes or no.               |
+-----------------------------+-----------------------------------------+
| Purpose is for Program      | Indicates whether OMB Form 83-I         |
| Mgmt.                       | question 15e (purpose of information    |
|                             | collection) is yes or no.               |
+-----------------------------+-----------------------------------------+
| Purpose is Regulatory       | Indicates whether OMB Form 83-I         |
|                             | question 15g (purpose of information    |
|                             | collection) is yes or no.               |
+-----------------------------+-----------------------------------------+
| Reporting Explanation for   | The text for other frequency of         |
| Other Freq.                 | reporting in OMB Form 83-I question 18  |
|                             | item 8.                                 |
+-----------------------------+-----------------------------------------+
| Reporting is Annual         | Indicates whether OMB Form 83-I         |
|                             | question 16 item 6 (frequency of        |
|                             | recordkeeping or reporting) is yes or   |
|                             | no.                                     |
+-----------------------------+-----------------------------------------+
| Reporting is Biennial       | Indicates whether OMB Form 83-I         |
|                             | question 16 item 7 (frequency of        |
|                             | recordkeeping or reporting) is yes or   |
|                             | no.                                     |
+-----------------------------+-----------------------------------------+
| Reporting is Monthly        | Indicates whether OMB Form 83-I         |
|                             | question 16 item 3 (frequency of        |
|                             | recordkeeping or reporting) is yes or   |
|                             | no.                                     |
+-----------------------------+-----------------------------------------+
| Reporting is Occassional    | Indicates whether OMB Form 83-I         |
|                             | question 16 item 1 (frequency of        |
|                             | recordkeeping or reporting) is yes or   |
|                             | no.                                     |
+-----------------------------+-----------------------------------------+
| Reporting is Quarterly      | Indicates whether OMB Form 83-I         |
|                             | question 16 item 4 (frequency of        |
|                             | recordkeeping or reporting) is yes or   |
|                             | no.                                     |
+-----------------------------+-----------------------------------------+
| Reporting is Semi-Annual    | Indicates whether OMB Form 83-I         |
|                             | question 16 item 5 (frequency of        |
|                             | recordkeeping or reporting) is yes or   |
|                             | no.                                     |
+-----------------------------+-----------------------------------------+
| Reporting is Some Other     | Indicates whether OMB Form 83-I         |
| Freq.                       | question 16 item 8 (frequency of        |
|                             | recordkeeping or reporting) is yes or   |
|                             | no.                                     |
+-----------------------------+-----------------------------------------+
| Reporting is Weekly         | Indicates whether OMB Form 83-I         |
|                             | question 16 item 2 (frequency of        |
|                             | recordkeeping or reporting) is yes or   |
|                             | no.                                     |
+-----------------------------+-----------------------------------------+
| Requested a 3-Year          | Indicates whether OMB Form 83-I         |
| Expiration                  | question 6a (requested expiration date) |
|                             | is yes or no.                           |
+-----------------------------+-----------------------------------------+
| Requested a Streamlined     | Indicates whether OMB Form 83-I         |
| Review                      | question 4a, streamlined review, is yes |
|                             | or no.                                  |
+-----------------------------+-----------------------------------------+
| Requested Approval Date     | The specific approval date requested in |
|                             | OMB Form 83-I question 4b.              |
+-----------------------------+-----------------------------------------+
| Requested Expiration Date   | The specific expiration date requested  |
|                             | in OMB Form 83-I question 6b.           |
+-----------------------------+-----------------------------------------+
| Requested Review Type       | The review type requested in OMB Form   |
|                             | 83-I question 4 (i.e., regular,         |
|                             | emergency, or delegated).               |
+-----------------------------+-----------------------------------------+
| Response is Mandatory       | Indicates whether OMB Form 83-I         |
|                             | question 12c (obligation to respond) is |
|                             | yes or no.                              |
+-----------------------------+-----------------------------------------+
| Response is Reqd to Obtain  | Indicates whether OMB Form 83-I         |
| Ben.                        | question 12b (obligation to respond) is |
|                             | yes or no.                              |
+-----------------------------+-----------------------------------------+
| Response is Voluntary       | Indicates whether OMB Form 83-I         |
|                             | question 12a (obligation to respond) is |
|                             | yes or no.                              |
+-----------------------------+-----------------------------------------+

## Collection Package Related (many-to-one) Data Fields Available for Ad Hoc Report {#collection-package-related-many-to-one-data-fields-available-for-ad-hoc-report .Appendix2}

There are an additional set of data fields which are available for
searching and for reporting which are collection package-related but
which occur zero, one, or more times for each collection. Therefore the
the guidelines for use of these elements is different. The descriptions
of these data elements are provided in Table E-2 below. Following is
some important guidance on use of these data fields:

1.  Some of these fields will have available the IS NULL and IS NOT NULL
    operators; however these operators will not work as expected because
    in this case NULL values are replaced with text indicating that
    there are no occurrences. Thus, for example, if you performed a
    search for all collections which have Current Status = pending and
    then display the Current Tracking and OMB Number and Linked Data
    Elements for each, a collection with no linked elements will appear
    in the report as follows:\
    \
    (99091)1810-4444-v.1 No elements linked\
    \
    If you want to find collections with no data elements linked, you
    can search for Linked Data Elements = No elements linked rather than
    for Linked Data Elements IS NULL.

2.  It does not usually make sense to include in the report columns from
    more than one category at a time. For example, if you include
    information locator and statute citation data fields in the same
    report, you will get all combinations of each entry for each
    collection.

Table E-2. Definition of Collection Package-related Data Items for Ad
Hoc Reporting

  -----------------------------------------------------------------------
  **Data Item**                 **Description**
  ----------------------------- -----------------------------------------
  **Information Locator         
  Records**                     

  Info Locator Description      Text description of an information
                                locator record.

  Info Locator Link             Information locator link, e.g. name or a
                                report or a World Wide Web link.

  Info Locator Link Type        The type of information locator link
                                included.

  Info Locator Name             The EDICS identifer for an information
                                locator record.

  Info Locator Point of Contact The person to contact regarding the
                                information source described by an
                                information locator record.

  Info Locator Title            A descriptive title for an information
                                locator record.

  Info Locator Type             The type of information being described
                                by an information locator record.

  **Data Dictionary Data        
  Elements**                    

  Linked Data Element           The text description of a data element.
  Description                   

  Linked Data Element ID        The EDICS Identifier for a data element.

  Linked Data Element Long Name The full name of a data element.

  Linked Data Element Short     The short (abbreviated) name of a data
  Name                          element.

  **Regulation Citations**      

  Regulation Citation           The full citation of a regulation. Note
                                that this field concatenates data from
                                several database records.

  Regulation Edition            The date of the regulation cited.

  Regulation Info               Text provided as other information for
                                the regulation.

  **Review Comments**           

  Review Comment Classification The classification of a comment assigned
                                by the IMG analyst.

  Review Comment Disposition    How a comment was resolved.

  Review Comment Number         EDICS-assigned number for a comment.

  Review Comment Receipt Date   The date a comment was received.

  Review Comment Response       The source of a comment (e.g. public,
  Source                        OMB, etc.)

  Review Comment Response Text  The text of a response to a comment.

  Review Comment Source         The source of a response (e.g. IMG, PO,
                                etc.)

  Review Comment Text           The text of a comment.

  **Statute Citations**         

  Statute Citation              A complete citation for a statute.

  Statute Edition               The date of the statute cited.

  Statute Info                  Text of other information provided with
                                the citation.
  -----------------------------------------------------------------------

## Data Dictionary Data Items Available for Ad Hoc Report {#data-dictionary-data-items-available-for-ad-hoc-report .Appendix2}

When data elements rather than collection packages are selected for
reporting, a different set of data fields are made available for
searching and reporting. Table E-3 describes the data fields which are
associated with each data element (exactly one occurrence per data
element, no more and no less).

Table E-3. Definition of Data Dictionary-related Data Items for Ad Hoc
Reporting

  -----------------------------------------------------------------------
  **Data Item**                 **Description**
  ----------------------------- -----------------------------------------
  Data Element Category         Category assigned to a data element.

  Data Element Comments         Text of the comments entered for a data
                                element.

  Data Element Data Type        Data type assigned to a data element.

  Data Element Description      Text of the description of a data
                                element.

  Data Element Disaggregation   Text describing disaggregation of a data
                                element which is a cross tabulation.

  Data Element Domain           Text describing the allowable range of
                                values for the data element.

  Data Element ID               Unique ID assigned to a data element.

  Data Element Last Revised     Date the data element was last revised in
                                EDICS.

  Data Element Linked Elements  The element IDs of data elements which
                                have been linked to a subject data
                                element.

  Data Element Long Name        The long name of a data element.

  Data Element Program Office   The PO which is currently responsible for
                                a data element.

  Data Element Relation Type    The type of relationship between a data
                                element and data elements linked to it.

  Data Element Short Name       The short name of a data element.
  -----------------------------------------------------------------------

## Data Dictionary Related (many-to-one) Data Items Available for Ad Hoc Report {#data-dictionary-related-many-to-one-data-items-available-for-ad-hoc-report .Appendix2}

There is one data dictionary field which can occur zero to many times:
the collections linked to the data element. It is described in Table E-4
below.

Table E-2. Definition of Data Dictionary-related Data Items for Ad Hoc
Reporting

  -----------------------------------------------------------------------
  **Data Item**                 **Description**
  ----------------------------- -----------------------------------------
  Data Element Linked           The tracking number and OMB number of
  Collections                   each collection which links to a subject
                                data element.

  -----------------------------------------------------------------------