Browse Questions and Answers
The data in adhoc reports comes live from the database so it is always up to date.
You have a choice of program type (field 1b) to include in the report, type of action (field 2a), and date range (effective date or update date). You also select which fields to include (options include PHA use fields (2q-2u)). You then generate the report. The report can be downloaded to a spreadsheet for further analysis or editing.
Yes, fields 2q through 2u are available for selection.
There are two things you cannot get in the adhoc reports:
- You cannot list the family members.
- You cannot include any but current records, regardless of their dates.
Unfortunately, not at this time. PIH is considering whether to add that feature versus other high priority items.
You can only correct data in an adhoc report by submitting the correct data in Form 50058.
Yes, you can download it to a spreadsheet unless your download capability is restricted.
The combination of Social Security Number (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.
You select the FSS fields that you want to include and then generate the report and download it to a spreadsheet. You will get the same data fields for all individuals, whether or not they are FSS participants. You can use the "Sort" feature in Excel on one of the FSS fields with data in it and then delete all of the lines where the FSS data is blank. Alternatively, you can use the "Filter" option in Excel to hide all of the FSS-blank rows.
Yes, your first choice is which program type(s) to include.
No, there is no adhoc access to historical tables.
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.
The Form 50058 Adhoc Report sub-module pulls live data from the tables each time a report is run. A user can select which fields to be included in the report and then download the data to a spreadsheet.