**9.0 QUERYING**

#  QUERYING

This system has querying or search capabilities for some of the
individual HCS user functions. Please refer to chapter 4.0 for more
information.

Each section in HCS allows the user to drill down to pin-point their
query with each view offering summary information. Use of these pages
can be beneficial in viewing information.

Each section has a feature to create spreadsheets listing most if not
all fields as columns. This presents a rich source for information
allowing querying to customize information searches.

For the more experience user, in the Management Function menu is section
"Ad Hoc Query". If the user understands the table data titles and
layouts, they can create customize queries in this feature.

**10.0 REPORTING**

# REPORTING

You can generate, export, view, and print a variety of reports using the
HCS system. For more information on reporting, please refer to Chapter
3.0. There, you will find four reporting sections (one for each user
type: Agency User, GTR, Office Manager, and Program Manger).

Most reports in HCS are fixed reports to satisfy reporting requirements.
The majority of these fixed reports are posted in the Grant Processing
section.

The user can customize a report by creating a spreadsheet of the desire
section and customize the list and columns.

**11.0 TROUBLE SHOOTING**

# TROUBLE SHOOTING

This section lists the most typical problems and solutions.

##  User Cannot Access HCS

Corrective Action -- Reset user password

Select User Information menu item and access the user profile. In the
user profile click the 'Reset Password'. This will reset the password to
default and is displayed for reference. Wait 15-30 minutes before trying
to access HCS.

Refer to 3.3 for more information**.**

![](media/image1.png){width="4.803472222222222in"
height="3.6479166666666667in"}

##  Agency Information is not Posted on HUD's Web Site

There can be several reasons for an agency to be excluded from the list
on the web site. Make the following checks in the order that best suits
the user.

-   Check the web site and confirm agency is not listed. Often agencies
    forget that the list is in alphabetical order by the city.

-   Check the agency profile to determine if agency is currently active
    having one of the following status

```{=html}
<!-- -->
```
-   Approved

-   Participating

-   Conditional

-   Check the agency profile to determine if the control boxes to
    post/not post agency information at the bottom of the page. If
    unmarked, mark the appropriate boxes.

```{=html}
<!-- -->
```
-   Check the agency profile for critical missing information that will
    preclude the agency from being posted:

```{=html}
<!-- -->
```
-   Address

-   City

-   State

-   Zip Code

-   Phone Number

-   Counseling Services

Refer to 3.4 for more information

##  Agency 9902 Report is Not Available

Only approved and certain agency types must report their 9902 report.

-   Check the agency profile:

    -   Is the status not listed as terminated?

        -   Approved

        -   Participating

        -   Conditional

        -   Inactive

-   Is the agency type an appropriate designation?

-   If the agency is a sub-agency, is it affiliated/assigned to a parent
    organization?

Refer to 3.5 for more information