Site Dim
The Site Dim dimension represents the organizational sites within the company, uniquely identifying each location by a combination of company number and site code. It tracks key site details and metadata such as when the information was last updated and whether the site record is marked as deleted. This helps the business maintain accurate, up-to-date site information for reporting and analysis.
| Output Column | Database Logic | Description |
|---|---|---|
| Site Key | A unique identifier created by concatenating the company number and site code, trimmed of any spaces, to distinctly identify each site. | This is a unique site identifier formed by combining the company number and the site code, ensuring each site can be individually tracked across the organization. |
| Company Number | The company number column holds the identifier of the company to which the site belongs. | This represents the company to which the site is associated, providing context within the broader organizational structure. |
| Site | The site code representing the specific site location. | This is the code that represents each physical or logical site location within the company. |
| Last Modified Datetime | The timestamp indicating the last time the site record was altered, derived using a system function to capture modification date and time. | This timestamp shows the most recent update made to the site’s information, helping ensure data is current for decision making. |
| Deleted | A flag indicating whether the site record has been marked as deleted in the source system. | This flag indicates if a site has been marked as deleted, allowing the business to exclude or archive inactive sites from analyses. |
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article