Ad Hoc Reports FAQs - IMS-PIC

Information by State  Print version

Contents

	What’s different about ad hoc reports?
	How up-to-date is the data in ad hoc reports?
	What choices do I have in ad hoc reports?
	Can I include PHA-use fields in the data request?
	Is there any data I can’t get in an ad hoc report?
	Can I save my ad hoc report template?
	How can I correct data in an ad hoc report?
	Can I download the report?
	Why can’t I see the whole SSNs in the data?
	How can I get FSS data in an ad hoc report?
	Can I specify which program to pull data for?
	Can I get historical data in an ad hoc report?
	Is special handling required for this data?

Browse Questions and Answers

What’s different about ad hoc reports?

Several things were changed in the December 2007 release. The Ah Hoc Report for MTW agencies was added. It works the same way the Ad Hoc Report for Form 50058 works but with a different set of data fields. In addition, the HA Query, which had been in the Viewer Reports tab, was moved to the Ad Hoc Module and expanded to search through all heads of household in both Form 50058 and MTW tenant data.

How up-to-date is the data in ad hoc reports?

The data in Ad Hoc Reports comes live from the database so it is always up to date.

What choices do I have in ad hoc reports?

You have a choice of program type (field 1b) to include in the report, type of action (field 2a, date range (effective date or update date) to include, and you select which fields to include, even PHA use fields (2q-2u), then generate the report. You can download it to a spreadsheet for further analysis or editing.

Can I include PHA-use fields in the data request?

Yes, fields 2q through 2u are available for selection.

 Back to top   

Is there any data I can’t get in an ad hoc report?

There are two things you cannot get in the Ad Hoc Report:

1. You cannot list the family members.
2. You cannot include any but current records, regardless of their dates.

Can I save my ad hoc report template?

Unfortunately, not at this time. PIH is considering whether to add that feature versus other high priority items.

How can I correct data in an ad hoc report?

You can only correct that data by submitting the correct data in Form 50058.

Can I download the report?

Yes, you can download it to a spreadsheet if your systems people have not restricted your download capability.

 Back to top   

Why can’t I see the whole SSNs in the data?

The combination of SSN, birthdate and full name is protected by the Privacy Act of 1974. Unauthorized disclosure of privacy data is subject to a federal civil penalty of $5,000 per disclosure. A limited number of users with specific need to see the privacy data can be given “Special System Privileges” by the agency security coordinator.

How can I get FSS data in an ad hoc report?

You select the FSS fields that you want to include, then generate the report and download it to a spreadsheet. You will get the same data fields for everyone, whether they are FSS participants. Data sort the spreadsheet on one of the FSS fields with data in it, then delete all of the lines where the FSS data is blank. You could also use a data filter in the spreadsheet to hide all of the FSS-blank rows.

Can I specify which program to pull data for?

Yes, your first choice is which program type(s) to include.

Can I get historical data in an ad hoc report?

No, there is no ad hoc access to historical tables.

Is special handling required for this data?

Data containing privacy information (information protected by the Privacy Act of 1974) must be safeguarded from unauthorized disclosure. Unauthorized disclosure of privacy data is subject to a federal civil penalty of $5,000 per disclosure.