DIMOFFICE

This dimension table stores information about offices.

Columns

Column	Data type	Description
BUILDID	NUMBER	Avionté’s unique identifier for each of its customers’ instances or builds. The value in this field is the same for all rows.
CUSTOMERKEY	NUMBER	A foreign key referencing the customer record in the DIMCUSTOMER table.
OFFICECITY	VARCHAR	The city where the office is located.
OFFICECOUNTRY	VARCHAR	The country where the office is located.
OFFICEDIVISION	VARCHAR	The division of the office.
OFFICEID	NUMBER	The identifier for the office. For a visual reference of this data element in the source system, see Appendix B: OFFICEID.
OFFICEKEY	NUMBER	The primary key referencing an office.
OFFICENAME	VARCHAR	The name of the office.
OFFICEQBNAME	VARCHAR	Not used.
OFFICEREGION	VARCHAR	The region where the office is located.
OFFICESTATE	VARCHAR	The state where the office is located.
OFFICEUPDATEDATE	TIMESTAMP_NTZ	The date of the most recent update to the office record.