Standard General Reports
Description and contents of each standard report in the General 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 General Reports section of the Reports page.
Tip: User access to specific reports can be managed on the User Role Setup page.
General Reports
Facility List
Export a list of facilities associated with the client, organized by Facility Status.
\Edge\SSRS\FacilityList.rdl| Column Name | Field Label |
|---|---|
| Facility Name | FacilityName |
| Facility ID | FacilNbr |
| # of UST Registered | NumOfUST |
| # of AST Registered | NumOfAST |
| Brand | GasBrand |
| Street Address | AddressLines |
| City | fCity |
| State | fState |
| Zip | fZip |
| Phone | fPhone |
Facility Dispenser Counts
Export a list of facilities including the number of dispensers associated with each facility.
\Edge\SSRS\FacilityDispenserCounts.rdl| Column Name | Field Label |
|---|---|
| Facility Name | FacilityName |
| Address | Address |
| City | City |
| State | State |
| Postal Code | PostalCode |
| Facility Status | FacilityStatus |
| Facility Groups | FacilityGroups |
| Gas Brand | GasBrand |
| # of Dispensers | NumDispensers |
Facility Contacts
Export a list of contacts organized by facility.
This report also includes the Facility Name, Address, City, State/Province, and Zip.
Client-level contacts are listed for each facility they are linked to within the report parameters.
\Edge\SSRS\ContactEntryReport.rdl| Column Name | Field Label |
|---|---|
| Facility Name | FacilityName |
| Facility Address | fAddress1 |
| City | fCity |
| State | fState |
| Zip | fZip |
| Name | DisplayName |
| Contact Level | ContactLevel |
| Contact Type | ContactType |
| Department | Department |
| Job Title | JobTitle |
| Primary Email | PrimaryEmailAddress |
| Secondary Email | SecondaryEmailAddress |
| Primary Phone | PrimaryPhoneNumber |
| Secondary Phone | SecondaryPhoneNumber |
| Primary Address | PrimaryAddress |
| Secondary Address | SecondaryAddress |
EFile Report (AKA AffiliateEFile)
Export a list of E-files dated within the specified parameters.
This report includes a “Sub Clients” parameter when accessed by an affiliate client.
\Edge\SSRS\AffiliateEFile.rdl| Column Name | Field Label |
|---|---|
| E-File Type | eFType |
| E-File Sub Type | eFSubType |
| E-File Date | eFDate |
| E-File Name | eFName |
| Client Name | ClientName |
| Facility Name | FacilityName |
| Notes | Notes |
| E-File App | App |
| Updated By | UpdatedBy |
| File Size | FileSize |
| Tags | Tags |
Facility Group by Facility
Export a list of Facilities that identifies which Facility Group(s) each is included in.
\Edge\SSRS\FacilityGroup_Facility.rld| Column Name | Field Label |
|---|---|
| Facility Status | FacilityStatusDescription |
| Facility Name | FacilityName |
| Address | fAddress1 |
| City | fCity |
| State/Province | fState |
| Group Name | FacilityGroupName |
Facility Group by Facility Group
Export a list of Facility Groups that identifies which facilities are in each Group.
\Edge\SSRS\FacilityGroup_FacilityGroup.rld| Column Name | Field Label |
|---|---|
| Group Name | FacilityGroupName |
| Facility Status | FacilityStatusDescription |
| Facility Name | FacilityName |
| Address | fAddress1 |
| City | fCity |
| State/Province | fState |
Competitor Pricing
Export competitor pricing entries organized by facility.
\Edge\SSRS\CompetitorPricing.rdl| Column Name | Field Label |
|---|---|
| Facility Name | FacilityName |
| Price Date | PriceDate |
| Competitor | FacilityCompetitorDisplayName |
| Regular | Regular1 |
| Midgrade | MidGrade |
| Premium | Premium |
| Diesel | Diesel |
| Entry Date | EntryDateUtc |
Tank Close
Export a list of tanks that have been opened and/or closed during the specified date range.
\Edge\SSRS\TankClose.rdl| Column Name | Field Label |
|---|---|
| Facility Name | FacilityName |
| Division | FacilityDivisionDescription |
| Market | Market |
| Tank Count | NumOfUST |
| Tank # | TankNbr |
| Tank Substance | TankSubstanceProductDescription |
| Tank Size | TankSize |
| Install Date | InstDate |
| Tank Type | TankTypeDescription |
| Manufacturer | TankMaker |
| Model | TankModel |
| Status | TankStatusDescription |
| TOS/POS Date | TOSDate |
| TOS Reason | TOSReason |
| Tank Removal Date | TankRemovalDate |
| Facility Status | FacilityStatusDescription |
| State | State |
| Tank Material | TankMaterial |
| Tank Installation Date | TankInstallationDate |
| Tank Wall | TankWall |
| # Fuel Dispensers | NumFuelDispensers |
| Dispenser Manufacturer | DispenserManufacturer |
| Dispenser Model | DispenserModel |
| Dispenser Make | DispenserMake |
| Fuel Brand | FuelBrand |
| Pipe Material | PipeMaterial |
| Pipe Manufacturer | PipeManufacturer |
| Opened/Closed | Status |
EMS Setup Facility Info
This report is a required component for setting up facilities for EMS imports.
\Edge\SSRS\EMSSetupFacilityInfo.rdl| Column Name | Field Label |
|---|---|
| OUID | EMSClientId |
| Client Name | ClientName |
| Facility Name | FacilityName |
| EMSSite ID | EMSSiteID |
| Facility Address 1 | fAddress1 |
| Facility Address 2 | fAddress2 |
| Facility State | fCity |
| Facility Zip | fState |
| Phone | fPhone |
EMS Setup Tank Details
This report is a required component for setting up tanks for EMS imports.
\Edge\SSRS\EMSSetupTankDetails.rdl| Column Name | Field Label |
|---|---|
| Client Name | ClientName |
| Facility Name | FacilityName |
| EMS Site ID | EMSSiteID |
| Tank Nbr | TankNbr |
| Tank Location Type | TankLocationType |
| Tank Contents | TankContents |
| Tank Size | TankSize |
| Release Detection Type | ReleaseDetectionType |
| Manifolded Tanks Nbrs | ManifoldedTanksNbrs |
EMS Inventory Variance Export
Export Inventory Variance results for import to EMS.
\Edge\SSRS\EMSInventoryVarianceExport.rdl| Column Name | Field Label |
|---|---|
| Client Name | ClientName |
| Facility Name | FacilityName |
| EMSSite ID | EMSSiteID |
| Tank Number | TankNbr |
| Inventory Date | InventoryVarianceDate |
| Sales | Sales |
| Stick | Stick |
| Delivery (gross) | DeliveryGross |
| Delivery (net) | PurchaseUnitNet |
New Facilities Added
Export a list of facilities added to the client account during the specified date range.
\Edge\SSRS\NewFacilitiesAdded.rdl| Column Name | Field Label |
|---|---|
| Client | ClientName |
| Facility | FacilityName |
| Status | Status |
| Address | fAddress1 |
| City | fCity |
| State | fState |
| Zip | fZip |
| Date Facility was Added | DateAdded |
| Creator | Creator |
User Details
Export a detailed list of all users in the client account.
This report does not include configurable parameters.
\Edge\SSRS\UserDetails.rdl| Column Name | Field Label |
|---|---|
| User Name | UserName |
| Role | Role |
| Full Name | FullName |
| Company | Company |
| Department | Department |
| Time Zone | TimeZone |
| Language | Language |
| Notes | Notes |
| Address | Address |
| City | City |
| State | State |
| County | County |
| Zip Code | ZipCode |
| Phone | Phone |
| Mobile Phone | MobilePhone |
Email |
|
| Client Administrator | ClientAdministrator |
| Expiration Date | ExpirationDate |
| Force Password Change | ForcePasswordChange |
| User Agreement Accepted | UserAgreementAccepted |
| Change User Password | ChangeUserPassword |
| Facility Access Restricted | FacilityAccessRestricted |
| Restricted Facilities | RestrictedFacilities |
| Include In Assigned To Activity | IncludeInAssignedToActivity |
| Include In Forward To Activity | IncludeInForwardToActivity |
| Include In Watchers To Activity | IncludeInWatchersToActivity |
| Include in Assigned to Inspection NOV | IncludeInAssignedToInspectionNOV |
| Include in Assigned to NOV Watchers In Regulatory Inspections | IncludeInAssignedToNOVWatchersInRegulatoryInspections |
| Activity Log Daily Summaries | ActivityLogDailySummaries |
| Activity Log Weekly Summaries | ActivityLogWeeklySummaries |
| Activity Log Monthly Summaries | ActivityLogMonthlySummaries |
| Activity Log Creation Change Notification | ActivityLogCreationChangeNotification |
| Send Activity Log Change Notifications For Own Changes | SendActivityLogChangeNotificationsForOwnChanges |
| Include In Owner In Maintenance | IncludeInOwnerInMaintenance |
| Client Landing Page | ClientLandingPage |
| Facility Landing Page | FacilityLandingPage |
| Last Login | LastLogin |
| MFA | MFA |
| Created Date | CreatedDate |
| Created By | CreatedBy |
Usage - Log On History
Export a list of users detailing log on activity during the specified date range.
\Edge\SSRS\UsageLogOnHistory.rdl| Column Name | Field Label |
|---|---|
| User Name | UserName |
| Login Name | LoginName |
| Number Of Log Ons | NumberOfLogOns |
| Number Of Log Offs | NumberOfLogOffs |
| Number Of Working Days | NumberOfWorkingDays |
| Total Logged On Minutes | TotalLoggedOnMinutes |
| Logged Average Hours Per Working Day | LoggedAverageHoursPerWorkingDay |