DIMWEBAPPLY¶
This dimension table stores information about web applicants.
Columns¶
| Column | Data type | Description |
|---|---|---|
APPID |
NUMBER | The identifier for the talent/applicant. For a visual reference of this data element in the source system, see Appendix B: APPID. |
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. |
CONVERTED |
NUMBER | Not used. |
CUSTOMERKEY |
NUMBER | A foreign key referencing the customer record in the DIMCUSTOMER table. |
REQID |
NUMBER | The identifier for the requirement. For a visual reference of this data element in the source system, see Appendix B: REQID. |
WEBAPPBROWSER |
VARCHAR | The browser used by the talent to apply for a job position on the web. |
WEBAPPDATE |
DATE | The date the talent applied for a job position on the web. |
WEBAPPDATETIME |
TIMESTAMP_NTZ | The date and time the talent applied for a job position on the web. |
WEBAPPDEVICE |
VARCHAR | The device used by the talent to apply for a job position on the web. |
WEBAPPID |
NUMBER | The identifier for the web applicant. |
WEBAPPKEY |
NUMBER | The identifier for the web applicant. |
WEBAPPLAT |
VARCHAR | Not used. |
WEBAPPLON |
VARCHAR | Not used. |
WEBAPPLONGSOURCE |
VARCHAR | The web link of the source from which the talent applied. |
WEBAPPOS |
VARCHAR | The operating system used by the talent to apply for a job position on the web. |
WEBAPPREFER |
VARCHAR | The name of the person who referred the talent. |
WEBAPPSOURCE |
VARCHAR | The source from which the talent applied on the web, such as Indeed, LinkedIn, ZipRecruiter, Glassdoor, etc. |