DIMHIRINGMANAGER

This dimension table stores information about the contacts/hiring managers.

Columns

Column	Data type	Description
BRANCHID	NUMBER	The identifier for the branch. Note: This Branch ID is the Branch ID currently associated with a particular Hiring Manager. This is (or can be) different than a Job Requirement's Branch ID. In other words, the current Branch ID for a particular Hiring Manager can have a different Branch from the Branch associated with a Job Requirement that Hiring Manager owns.
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.
COMPANYID	NUMBER	The identifier for the company. For a visual reference of this data element in the source system, see Appendix B: COMPANYID.
COMPANYKEY	NUMBER	The identifier for the company.
COMPBRANCHKEY	NUMBER	A foreign key referencing a company branch in the DIMCOMPANYBRANCH table.
CUSTOMERKEY	NUMBER	A foreign key referencing the customer record in the DIMCUSTOMER table.
HIRINGMANAGERID	NUMBER	The identifier for the contact. For a visual reference of this data element in the source system, see Appendix B: HIRINGMANAGERID.
HIRINGMANAGERKEY	NUMBER	The primary key referencing a contact/hiring manager.
MGRADDRESS1	VARCHAR	The contact's street address, line 1. For a visual reference of this data element in the source system, see Appendix B: MGRADDRESS1.
MGRADDRESS2	VARCHAR	The contact's street address, line 2. For a visual reference of this data element in the source system, see Appendix B: MGRADDRESS2.
MGRARCHIVE	NUMBER	An indication of whether the contact's record is archived or not.
MGRCITY	VARCHAR	The contact’s city.
MGRCREATEDATE	TIMESTAMP_NTZ	The date the contact's profile was created. For a visual reference of this data element in the source system, see Appendix B: MGRCREATEDATE.
MGRDEPARTMENT	VARCHAR	The contact's department. For a visual reference of this data element in the source system, see Appendix B: MGRDEPARTMENT.
MGRDIVISION	VARCHAR	The contact's division. For a visual reference of this data element in the source system, see Appendix B: MGRDIVISION.
MGREMAIL1	VARCHAR	The contact's primary email. For a visual reference of this data element in the source system, see Appendix B: MGREMAIL1.
MGREMAIL2	VARCHAR	The contact's secondary email. For a visual reference of this data element in the source system, see Appendix B: MGREMAIL2.
MGRFAXPHONE	VARCHAR	The contact's fax phone number. For a visual reference of this data element in the source system, see Appendix B: MGRFAXPHONE.
MGRFIRST	VARCHAR	The contact's first name. For a visual reference of this data element in the source system, see Appendix B: MGRFIRST.
MGRLAST	VARCHAR	The contact's last name. For a visual reference of this data element in the source system, see Appendix B: MGRLAST.
MGRMOBILEPHONE	VARCHAR	The contact's mobile phone number. For a visual reference of this data element in the source system, see Appendix B: MGRMOBILEPHONE.
MGRNAME	VARCHAR	The contact's first and last name. For a visual reference of this data element in the source system, see Appendix B: MGRNAME.
MGRNAMELINK	VARCHAR	The contact profile link.
MGROTHERPHONE	VARCHAR	The contact's other phone number. For a visual reference of this data element in the source system, see Appendix B: MGROTHERPHONE.
MGRSTATE	VARCHAR	The contact's state. For a visual reference of this data element in the source system, see Appendix B: MGRSTATE.
MGRTITLE	VARCHAR	The contact's title. For a visual reference of this data element in the source system, see Appendix B: MGRTITLE.
MGRUPDATEDATE	TIMESTAMP_NTZ	The date of the most recent update to the contact's profile.
MGRWORKPHONE	VARCHAR	The contact's work phone number. For a visual reference of this data element in the source system, see Appendix B: MGRWORKPHONE.
MGRZIP	VARCHAR	The contact's ZIP/postal code. For a visual reference of this data element in the source system, see Appendix B: MGRZIP.