DIMAPPLICANT¶
This dimension table stores information about talent/applicants.
Columns¶
| Column | Data type | Description |
|---|---|---|
APPADDR1 |
VARCHAR | The talent's street address, line 1. For a visual reference of this data element in the source system, see Appendix B: APPADDR1. |
APPADDR2 |
VARCHAR | The talent's street address, line 2. For a visual reference of this data element in the source system, see Appendix B: APPADDR2. |
APPARCHIVE |
NUMBER | An indication of whether the talent record is archived or not. |
APPCITY |
VARCHAR | The talent's city. For a visual reference of this data element in the source system, see Appendix B: APPCITY. |
APPCOUNTRY |
VARCHAR | The talent's country. For a visual reference of this data element in the source system, see Appendix B: APPCOUNTRY. |
APPCREATEDATE |
TIMESTAMP_NTZ | The date and time when the talent record was created. For a visual reference of this data element in the source system, see Appendix B: APPCREATEDATE. |
APPCREATEUSERID |
NUMBER | A foreign key referencing a user who created a talent record in the DIMUSER table. |
APPCREATEUSERKEY |
NUMBER | A foreign key referencing a user who created a talent record in the DIMUSER table. |
APPCREATEUSERNAME |
VARCHAR | The user who created a talent record. |
APPEMAIL1 |
VARCHAR | The talent's primary email address. For a visual reference of this data element in the source system, see Appendix B: APPEMAIL1. |
APPEMAIL2 |
VARCHAR | The talent's secondary email address. For a visual reference of this data element in the source system, see Appendix B: APPEMAIL2. |
APPFAXPHONE |
VARCHAR | The talent's fax phone number. |
APPFIRSTNAME |
VARCHAR | The talent's first name. For a visual reference of this data element in the source system, see Appendix B: APPFIRSTNAME. |
APPFLG |
VARCHAR | An indication of whether the talent has been placed in any job before. If the talent has been placed, it is set to 'Y'; otherwise, it is set to 'N'. |
APPHOMEPHONE |
VARCHAR | The talent's home phone number. For a visual reference of this data element in the source system, see Appendix B: APPHOMEPHONE. |
APPHOURLYMAX |
NUMBER | The maximum hourly rate of the talent. For a visual reference of this data element in the source system, see Appendix B: APPHOURLYMAX. |
APPHOURLYMIN |
NUMBER | The minimum hourly rate of the talent. For a visual reference of this data element in the source system, see Appendix B: APPHOURLYMIN. |
APPID |
NUMBER | The identifier for the talent/applicant. For a visual reference of this data element in the source system, see Appendix B: APPID. |
APPLASTNAME |
VARCHAR | The talent's last name. For a visual reference of this data element in the source system, see Appendix B: APPLASTNAME. |
APPLICANTKEY |
NUMBER | The primary key referencing a talent/applicant record. |
APPMOBILEPHONE |
VARCHAR | The talent's mobile phone number. For a visual reference of this data element in the source system, see Appendix B: APPMOBILEPHONE. |
APPNAME |
VARCHAR | The talent's first and last name. For a visual reference of this data element in the source system, see Appendix B: APPNAME. |
APPNAMELINK |
VARCHAR | The link to the talent profile. |
APPOTHERPHONE |
VARCHAR | The talent's other phone number. For a visual reference of this data element in the source system, see Appendix B: APPOTHERPHONE. |
APPPROVINCE |
VARCHAR | The talent's province, state, or region. |
APPREPUSERID |
NUMBER | A foreign key referencing a talent's representative user in the DIMUSER table. |
APPREPUSERKEY |
NUMBER | A foreign key referencing a talent's representative user in the DIMUSER table. |
APPREPUSERNAME |
VARCHAR | The name of the representative user who is working with the talent. |
APPSALARYMAX |
NUMBER | The maximum salary requirement for the talent. For a visual reference of this data element in the source system, see Appendix B: APPSALARYMAX. |
APPSALARYMIN |
NUMBER | The minimum salary requirement for the talent. For a visual reference of this data element in the source system, see Appendix B: APPSALARYMIN. |
APPSTATE |
VARCHAR | The talent's state. For a visual reference of this data element in the source system, see Appendix B: APPSTATE. |
APPSTATUS |
VARCHAR | The talent's status. For a visual reference of this data element in the source system, see Appendix B: APPSTATUS. |
APPUPDATEDATE |
TIMESTAMP_NTZ | The date and time when the talent record was last updated. |
APPWEBSITE |
VARCHAR | Talent resume link. For a visual reference of this data element in the source system, see Appendix B: APPWEBSITE. |
APPWORKPHONE |
VARCHAR | The talent's work phone number. For a visual reference of this data element in the source system, see Appendix B: APPWORKPHONE. |
APPZIP |
VARCHAR | The talent's ZIP/postal code. For a visual reference of this data element in the source system, see Appendix B: APPZIP. |
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 a customer record in the DIMCUSTOMER table. |
OFFICEID |
NUMBER | A foreign key referencing the office in the DIMOFFICE table. |
PRIMARYSOURCE |
VARCHAR | The main source from which the user data was obtained. |
REFERREDBY |
VARCHAR | Deprecated: The talent referred by the user or another talent. |
REFERREROF |
VARCHAR | Deprecated: The talent who referred the user or another talent. |
VENDREP |
NUMBER | A vendor representative, also known as the talent representative, is a single person from a third- party company/agency who manages the business relationship while also handling the sourcing and presentation of job candidates. |