Standard Inspection Reports
Description and contents of each standard report in the Inspection Reports category.
Written by Jess Hamilton
Updated at July 27th, 2024
Table of Contents
Titan Cloud offers a large selection of pre-designed reports that may be used to track and analyze the metrics important to your organization. This resource is intended to provide an overview of the available standard reports in the Inspection Reports section of the Reports page.
Tip: User access to specific reports can be managed on the User Role Setup page.
Inspection Reports
Advanced Facility Inspection Deficiency
Export a record of deficiencies noted in inspections, organized by profile section.
\Edge\SSRS\InspectionDeficiency.rdl| Column Name | Field Label |
|---|---|
| Profile Section | ProfileSectionDescription |
| Facility Name | FacilityName |
Market |
|
| Profile Name | ProfileName |
| Street Address | AddressLines |
| City | fCity |
| State | fState |
| Zip | fZip |
| Inspection Date | InspectionDate |
| Inspector Name | InspectorName |
| Question Text | QuestionText |
| Response | Response |
| Comments | Comments |
| Response Status | ResponseStatus |
| Score | Score |
| Total Possible Score | TotalPossibleScore |
| Attachments | eFileIds |
YearlyPdfExists |
|
FacilityId |
|
InspectionId |
|
| Times Answered | ResponseCount |
| % of Use | ResponseAverage |
Advanced Facility Inspection Profile Detail
Export a detailed configuration record of the selected inspection profile.
\Edge\SSRS\FacilityInspectionProfileDetail.rdl| Column Name | Field Label |
|---|---|
| Is Profile Weighted? | ProfileWeighted |
| Effective Date | EffectiveDate |
| Expiration Date | ExpirationDate |
| Revised Date | RevisedDate |
| Inspection Frequency | InspectionFrequencyPeriod |
| Inspection Frequency | FrequencyType |
| Frequency Driven Off | FrequencyDrivenOff |
| Requires Review? | Requires_Review_ |
| Pass/Fail Method | PassFailMethod |
| Total Possible Inspection Score | TotalPossibleScore |
| Threshold Inspection Score | ThresholdScore |
| Include PDF with Email? | IncludePdfAttachmentWithEmail |
| Save PDF to E-Files? | SavePdfToEfilesOnCompleted |
| Inspection Activity Template | InspectionActivityTemplate |
| Completion Email Recipients | CompletionEmailRecipients |
| Section Name | SectionName |
| Section Score | SectionScore |
| Question Text | QuestionText |
| Response Type | QuestionType |
| Validate Answer As | QuestionValidateAnswerAs |
| File Attachment | QuestionFileAttachmentCondition |
| Comment | QuestionCommentCondition |
| Is Question Weighted? | QuestionWeighted |
| Total Question Weight | TotalPossibleQuestionWeight |
| Is Answer Required? | AnswerRequired |
| PDF Form Field | PdfFormField |
| Response | ResponseText |
| Is Passing Response? | PassingResponse |
| File Attachment | ResponseFileAttachmentCondition |
| Comment | ResponseCommentCondition |
| Is Response Weighted? | ResponseWeighted |
| Response Weight | ResponseWeight |
| Activity Template | ResponseActivityTemplate |
| Response for PDF Form | PdfFormFieldResponse |
SectionOrder |
|
ProfileSectionId |
|
QuestionOrder |
|
ProfileQuestionId |
|
ResponseOrder |
Advanced Facility Inspection History
Export a record of facility inspections within the specified parameters.
\Edge\SSRS\AFIHistory.rdl| Column Name | Field Label |
|---|---|
| Facility Status | FacilityStatus |
| Facility Name | FacilityName |
| Street Address | AddressLines |
| City | fCity |
| State | State |
| Zip | fZip |
| Inspection Profile Name | InspectionProfileName |
| Inspection Date | InspectionDate |
| Inspector | InspectorName |
| Status | InspectionStatus |
| Custom Status | CustomStatus |
| Result | IsInspectionPassing |
| Score | InspectionScore |
| Percent | Percentage |
| Attachments | eFileIds |
YearlyPdfExists |
|
FacilityId |
|
InspectionId |
|
| Inspection Created Date | InspectionCreatedDate |
| Inspection Completed Date | InspectionCompletedDate |
Advanced Facility Inspection Affiliate History
Export a record of facility inspections within specified parameters only available to Affiliate clients.
\Edge\SSRS\AFIAffiliateHistory.rdl| Column Name | Field Label |
|---|---|
| Facility Status | FacilityStatus |
| Facility Name | FacilityName |
| Street Address | AddressLines |
| City | fCity |
| State | State |
| Zip | fZip |
| Inspection Profile Name | InspectionProfileName |
| Inspection Date | InspectionDate |
| Inspector | InspectorName |
| Status | InspectionStatus |
| Custom Status | CustomStatus |
| Result | IsInspectionPassing |
| Score | InspectionScore |
| Percent | Percentage |
| Attachments | eFileIds |
YearlyPdfExists |
|
FacilityId |
|
InspectionId |
|
| Inspection Created Date | InspectionCreatedDate |
| Inspection Completed Date | InspectionCompletedDate |
Inspection Response Summary
Export a summary of inspection response rates organized by inspection and question.
\Edge\SSRS\InspectionResponseSummary.rdl| Column Name | Field Label |
|---|---|
| Number of Inspections | NumberOfInspections |
| Profile Name | ProfileName |
| Section Name | SectionName |
| Question Text | QuestionText |
| Response Text | ResponseText |
| Times Used | ResponseCount |
| Percentage |
Inspection Detail Summary
Export a detailed summary of inspection responses.
Tip: Rendering this report in Excel is strongly recommended for formatting purposes. Each Profile Section will be sorted into its own sheet.
\Edge\SSRS\InspectionDetailSummary.rdl| Column Name | Field Label |
|---|---|
Response |
|
BaseProfileQuestionId |
|
QuestionText |
|
| Inspection ID | InspectionId |
InspectionSectionId |
|
| Base Profile ID | BaseProfileID |
ProfileId |
|
| Profile Name | ProfileName |
| Facility Name | FacilityName |
| Profile Section Description | ProfileSectionDescription |
| State | fState |
| Inspector Name | InspectorName |
| Mapped To | MappedTo |
| Inspection Date | InspectionDate |
|
Create Date Create Time |
CreateDate |
| Item Description | ItemDescription |
| Checklist Log for Year |