Supplier Licence Expiry Report¶
The Supplier Licence Expiry Report provides a comprehensive overview of licences associated with suppliers and their sites within Dsposal's Paperwork platform. This report highlights licences that are expired, expiring soon, or have been archived, empowering users to effectively manage licence compliance and renewal processes. With detailed information on each licence, including registration and expiry dates, status, and direct links for updates, this report offers valuable insights for ensuring regulatory compliance and proactive licence management.
Before you start¶
Before getting started, there are a couple of helpful things to know:
- The report lists suppliers and their associated sites with licences that are expired, expiring soon, or have been archived.
- Each entry includes details such as the supplier's name, address, site name, licence name, registration number, licence type, registration and expiry dates, and the current status of the licence.
- The report provides a direct URL to the update area of the licence for easy access and management.
- Status categories include "Expired" for licences past their expiry date, "Expiring soon" for licences expiring within the next 7 days, and "Indate" for licences within their validity period.
- Archived licences are excluded from the report to focus on current and upcoming expiry statuses.
- The report is organised by supplier name and site name for clarity and ease of navigation.
Fields in the report¶
| Field Name | Format Type | Description |
|---|---|---|
| supplierId | Number | The unique identifier for the supplier. |
| supplierName | Text | The name of the supplier. |
| supplierStatus | Text | The status of the supplier (e.g., Active, Archived). |
| supplierAddress | Text | The address of the supplier. |
| supplierSiteId | Number | The unique identifier for the supplier site. |
| siteName | Text | The name of the supplier site. |
| siteStatus | Text | The status of the supplier site (e.g., Active, Archived). |
| siteAddress | Text | The address of the supplier site. |
| licenceId | Number | The unique identifier for the licence. |
| licenceName | Text | The name of the licence. |
| licenceURL | Text | The URL for accessing the licence information. |
| registrationNumber | Text | The registration number associated with the licence. |
| licenceAddress | Text | The address associated with the licence. |
| licenceType | Text | The type of licence (e.g., Carriers, Brokers, Dealers). |
| registrationDate | Date/Time | The date when the licence was registered. |
| expiryDate | Date/Time | The expiry date of the licence. |
| Status | Text | The status of the licence (e.g., Expired, Active). |
Frequently asked questions¶
What is a field?
A field refers to a single piece of data within a dataset, also known as a column or attribute. It represents a specific characteristic or attribute of the data being collected or analysed. For example, in a dataset of opportunity information, fields may include "department," "salesType," "customerSite," and "lostReason".
Why do your field names look funny?
We use a computer programming convention called camel case (more accurately lower camel case) where multiple words are combined into a single word, with each word (except the first one) capitalised and no spaces between the words. The name "camel case" comes from the capitalisation's resemblance to the humps of a camel.