| Table of Contents |
|---|
4.1 eRecruit Job, Requisition and Application Data
4.1.1 Application Details
...
Field Name
...
Field Description
...
ApplicationID
...
Application Applied On
...
Application Edited On
...
Application Submitted On
...
Application Is Complete
...
Application Is Withdrawn
...
Application Status
...
Application Step Drop Out
...
Current APM Step Last Edited
...
Current APM Step Name
...
Current APM Step Status
...
Group Description
...
The description of the application group this application is currently in.
...
Group Label
...
The name of the current application group of this application.
...
IsPaperApplication
...
4.1.2 Application Sourcing
...
Field Name
...
Field Description
...
Audience Code
...
Audience Name
...
Audience Description
...
Job Ad Reference
...
The reference number of the advertisement for this application's job board posting.
...
Job Board Name
...
The name of the job board on which the advertisement for this application's job was posted.
...
Source Type Name
...
Vendor Name
...
The name of the vendor organisation (e.g. recruitment agent) that submitted the application.
...
Vendor Branch Name
...
The name of the vendor organisation branch that submitted the application.
4.1.3 Candidate
...
Field Name
...
Field Description
...
UserID
...
The internal system code that uniquely identifies candidate who made this application.
This field should be used to count unique applications or when creating joins to sub-queries.
Format: Universally Unique Indeniter (UUID)
Example Value: fef94d3a-3957-8594-d78f-527cd5f60d25
...
Candidate ID
...
The identification number of the candidate who made this application.
Format: 6 digit numeric
Example Value: 679049
...
Title
...
The title of the candidate who made this application.
Example Values:
* Mr
* Ms
* Dr
...
First Name
...
The first / given name of the candidate who made this application.
...
Middle Name
...
The middle name of the candidate who made this application.
...
Last Name
...
The last / family name of the candidate who made this application.
...
Email Address
...
The email address of the candidate who made this application.
Example Value: mary@somedomain.com
...
User Status
...
The status of the candidate's eRecruit account.
Available Values:
* User Active
* User Inactive
...
User Language
...
The user interface language entered in the candidate record of the candidate who submitted this application.
...
User Region
...
The region entered in the candidate record of the candidate who submitted this application.
...
User Timezone Label
...
The description of the time zone entered in the candidate record of the candidate who submitted this application.
Example Value: Canberra, Melbourne, Sydney
...
User Timezone Name
...
The name of the time zone entered in the candidate record of the candidate who submitted this application.
Example Value: AUS Eastern Standard Time
4.1.4 Flags
...
Field Name
...
Field Description
...
IsGlobal
...
FlagDescription
...
The content of the flag attached to this job.
...
Title
...
MiddleName
...
The middle name of the user who created this flag attached to this job.
...
FirstName
...
The first / given name of the user who created this flag attached to this job.
...
LastName
...
The last / family name of the user who created this flag attached to this job.
...
...
UserGroup
...
The eRecruit user group of the user who created this flag attached to this job.
4.1.5 Job Audience Types (!)
...
Field Name
...
Field Description
...
Audience Code
...
Audience Name
...
Audience Description
...
Job Audience Close Date
...
Job Audience Open Date
...
Timezone Name
...
The name of the time zone associated with the open and closes for a candidate portal audience used to find applications for this job.
4.1.6 Job Categories (!)
...
Field Name
...
Field Description
...
JobCategoryName
...
The name of a category this job was advertised under on the candidate portal.
...
JobCategoryDescription
...
The description of a category this job was advertised under on the candidate portal.
4.1.7 Job Creator
...
Field Name
...
Field Description
...
UserID
...
The internal system code that uniquely identifies the creator of this job.
Format: Universally Unique Indeniter (UUID)
Example Value: fef94d3a-3957-8594-d78f-527cd5f60d25
...
Title
...
The title of the creator of this job.
Example Values:
* Mr
* Ms
* Dr
...
First Name
...
The first / given name of the creator of this job.
...
Middle Name
...
The middle name of the creator of this job.
...
Last Name
...
The last / family name of the creator of this job.
...
Email Address
...
The email address of the creator of this job.
Format: Email address
Example Value: martin.james@domain.com
...
User Group
...
The eRecruit user group of the creator of this job.
...
User Language
...
The user interface language entered in the candidate record of the candidate who submitted this application.
4.1.8 Jobs and Requisitions
...
Field Name
...
Field Description
...
JobID
...
Job Reference No
...
The reference number of this job / requisition.
...
Job Name
...
The name of this job / requisition.
...
Job Highlight 1
...
The first highlight entered on the job details for this job / requisition.
...
Job Highlight 2
...
The second highlight entered on the job details for this job / requisition.
...
Job Highlight 3
...
The third highlight entered on the job details for this job / requisition.
...
Job Archive Date
...
Job Created On
...
Job Edited On
...
Job Close Date
...
Job Open Date
...
Current Workflow Step
...
Job Owner (Username)
...
Job Status
...
Job Keywords
...
The information entered in the job keyword question on the job details form for this job.
...
Job Overview
...
The information entered in the job overview question on the job details form for this job.
...
TimeToArchiveinDays
...
The duration in days between the job creation date and the job archive date.
Format: Integer
...
# of Complete Applicants
...
The number of complete applications received for this job.
Format: Integer
...
# of Incomplete Applicants
...
The number of incomplete applications received for this job.
Format: Integer
...
# of Submitted Applicants
...
The number of submitted applications received for this job.
Format: Integer
...
# of Withdrawn Applicants
...
The number of withdrawn applications received for this job.
Format: Integer
...
JobsRequisition
...
JobsTemplate
...
4.1.9 Notes (!)
...
Field Name
...
Field Description
...
Subject
...
The subject line of this application note.
...
Content
...
The contents of this application note.
...
Created By
...
CreatedOn
...
4.1.10 Vendors
...
Field Name
...
Field Description
...
UserID
...
MiddleName
...
The middle name of the vendor user who submitted this application on behalf of the candidate.
...
Title
...
FirstName
...
The first / given name of the vendor user who submitted this application on behalf of the candidate.
...
LastName
...
The last / family name of the vendor user who submitted this application on behalf of the candidate.
...
...
Username
...
VendorBranchCountry
...
VendorBranchFax
...
VendorBranchName
...
VendorBranchPhone
...
VendorBranchPostCode
...
VendorBranchState
...
VendorBranchStreet
...
VendorBranchSuburb
...
VendorCode
...
vendorName
...
UserStatus
...
4.2 eRecruit Process Step Data
4.2.1 Process
...
Field Name
...
Field Description
...
Template First Created
...
Template Last Edited
...
Template Creation - Last Action (Minutes)
...
Template First Action - Last Action (Minutes)
...
REQ Process Start - Finish (Minutes)
...
APM Process Start - Finish (Minutes)
...
Entire Process Start - Finish (Minutes)
...
REQ Completion (%)
...
The duration of the requisition process epxressed as a percentage of the duration of the complete workflow.
...
JCW Completion (%)
...
The duration of the job creation wizard epxressed as a percentage of the duration of the complete workflow.
...
APM Completion (%)
...
The duration of the assessment process epxressed as a percentage of the duration of the complete workflow.
...
JCW Process Start - Finish (Minutes)
...
Process Step First Created
...
Process Step Last Edited
...
Process Step Time Taken (Minutes)
...
# of Applicants Complete
...
# of Applicants in Progress
...
# of Applicants Not Started
...
# of Applicants On Hold
...
# of Applicants Pending
...
# of Applicants Successful
...
# of Applicants Unsuccessful
...
# of Applicants Withdrawn
...
Process Created On
...
Process is Active
...
Process is Template
...
Process Name
...
Step Auto Complete
...
Process Step ID
...
Process Step is Template
...
Process Step Mandatory
...
Process Step Name
...
Process Step Number
...
Last Process Step Number
...
Overall Workflow Step Number
...
Last Overall Process Step Number
...
Process Type Description
...
Step Created:
...
Step Edited:
...
Step Status
...
Creation to Last Modified (Minutes)
...
ProcessID
...
4.2.2 Process Step Activity (!)
...
Field Name
...
Field Description
...
First Name
...
The first / given name of the user assigned to this process step.
...
Last Name
...
The last / family name of the user assigned to this process step.
...
...
User Group
...
The eRecruit user group of the user assigned to this process step.
...
Username
...
User Group is Vendor
...
Vendor Branch Name
...
Date Task Last Edited
4.2.3 Process Step Permissions (!)
...
Field Name
...
Field Description
...
UserRegion
...
The region entered in the user record of the user with permission to complete this process step.
...
Permission Type
...
Permission Target
...
User Group Name
...
User Group Description
...
User Group Status
...
User Group is Vendor
...
Vendor Branch Name
...
Title
...
Middle Name
...
The first / given name of the user with permission to complete this process step.
...
First Name
...
The middle name of the user with permission to complete this process step.
...
Last Name
...
The last / family name of the user with permission to complete this process step.
...
...
Username
...
User Expiry Date
...
User Status
...
UserGroup
...
User Group is Vendor
...
Vendor Branch Name
...
User Timezone Label
...
User Timezone Name
4.3 eRecruit Activity Data
Activities
...
Field Name
...
Field Description
...
Activity
...
Activity Block
...
Activity Block Status
...
Format:
Example Value: Ended
...
Activity Block Type
...
Activity Block Venue
...
The Activity Block Venue is the location of the interview or activity.
Format: Free text
Example Value: 17 Raglan Street, South Melbourne VIC 3205
...
Slot Start Date & Time
...
Slot End Date & Time
...
Duration (Minutes)
...
4.4 eRecruit Application Assessment History Data
Process (!)
...
Field Name
...
Field Description
...
ProcessStepID
...
CurrentProcessStepID
...
ProcessID
...
ProcessName
...
ProcessStepExecutionStatusValue
...
ProcessStepName
...
ProcessStepNumber
...
ProcessStepScore
...
ProcessStepStartTime
...
ProcessStepDurationDays
...
ProcessStepDurationSeconds
...
ProcessStepEndTime
...
ProcessStepExecCreatedOn
...
ProcessStepExecEditedOn
...
ApplicationUpdateTimestamp
...
4.5 eRecruit Application Status History Data
Application Status History
...
Field Name
...
Field Description
...
ApplicationStatus
...
StatusUpdatedOn
...
4.6 eRecruit Back-end User Activity Data
...
Field Name
...
Field Description
...
LattestDateTaskTargetWasWorkedOn
...
TaskDescription
...
taskID
...
TaskName
...
TaskTarget
...
TaskTargetKey
...
TaskTargetStatusValue
...
4.7 eRecruit Email Data
Emails (!)
...
Field Name
...
Field Description
...
EmailContent
...
The text that was included in the body of the e-mail
...
EmailCopiedFrom
...
EmailCreatedOn
...
EmailEditedOn
...
EmailIsActive
...
yes/no
...
EmailIsDefaultTemplate
...
EmailIsTemplate
...
EmailLabel
...
EmailSenderEmail
...
EmailSignature
...
The email signature that was included in the email that was sent.
...
EmailSubject
...
The subject text included in the email that was sent.
...
EmailTemplateName
...
RecipientEmail
...
SentOn
...
4.8 eRecruit Job Permission Data
Job Permissions
...
4.9 eRecruit Job Status Data
...
Field Name
...
Field Description
...
EventOriginName
...
The origin of the event that triggered the job status update.
Sample values include:
* Copy Job from Template
* Job Creation Wizard
* CP Job Audience
* Job Card
...
EventTypeName
...
The event type that triggered the job status update.
Sample values include:
* Job Created
* Job Creation Wizard Completed
* Job Audience Submitted
...
LogCreatedOn
...
minutesSinceFirstStatusUpdate
...
minutesSinceLastStatusUpdate
...
NewStatus
...
OldStatus
...
StatusUpdateNumber
...
4.10 eRecruit Job-ad Data
...
Field Name
...
Field Description
...
BroadStatus
...
CreatedOn
...
JobAdFirstLastDateTime
...
JobAdFirstSentDateTime
...
JobAdReference
...
The reference number of this job ad.
...
JobAdStatus
...
JobBoardName
...
LastModifiedByUserID
...
LastModifiedOn
...
4.11 eRecruit Job-alert Data
Job Alert
...
Field Name
...
Field Description
...
AverageNumberOfJobsPerMatch
...
The average number of jobs that are returned with each match to the criteria set in the job alert.
...
CreatedOn
...
FirstMatch
...
IsActive
...
JobAlertProfileAudience
...
JobAlertProfileFrequencyValue
...
LatestMatch
...
NumberOfApplicationsLinkedToJobAlerts
...
The total number of applications that this candidate has made to jobs that have been included in job alerts.
...
TotalNumberOfJobsMatched
...
The total number of jobs that have been matched for this job alert profile.
...
TotalNumberOfTimesMatched
...
The total number of job alert e-mails that have been sent for this job alert profile.
4.12 eRecruit Module and Function Permission Data
Functions and Permissions
...
Field Name
...
Field Description
...
FunctionDescription
...
Provides a description of the function for which the permissions are assigned.
...
FunctionName
...
ModuleName
...
PermissionOwner
...
PermissionType
...
4.13 eRecruit Process Template Copy Data
Process (!)
...
Field Name
...
Field Description
...
JobOrProcessName
...
The name of the job or process that was copied.
...
JobOrProcessType
...
LastDateTimeCopied
...
NumberOfTimeCopied
...
The number of times that this job or process has been copied.
4.14 eRecruit SMS Data
SMS
...
Field Name
...
Field Description
...
CreatedByUserFullName
...
MessageContent
...
The content that was included in the SMS message.
...
MessageCreatedOn
...
MessageEditedOn
...
MessageLength
...
The number of characters that were included in the SMS message.
...
MessageSentOn
...
MessageStatus
...
NumberOfMessagesSent
...
RecipientFullName
...
RecipientMobileNumber
...
The mobile number of the recipient of this SMS message.
4.15 eRecruit User Role Data
Roles
...
Field Name
...
Field Description
...
RoleName
...
4.16 eRecruit User Role Permission Data
Functions and Permissions
...
Field Name
...
Field Description
...
PermissionOwner
...
RoleName
...
4.17 eRecruit Talent Search Data
User Searches
...
Field Name
...
Field Description
...
CreatedOn
...
IsPublic
...
IsTemplate
...
LastRun
...
SearchHits
...
The number of candidates that the search retrieved.
...
SearchString
...
4.18 eRecruit Config Change Data
Configuration Log
...
Field Name
...
Field Description
...
ActionExtendedInformation
...
ActionName
...
ConfigurationChangeTargetType
...
ConfigurationLogActionName
...
ConfigurationLogCreatedOn
...
CriteriaName
...
JobName
...
The name of this job / requisition to which the action was recorded against.
...
JobReferenceNo
...
The reference number of this job / requisition to which the action was recorded against.
...
RuleName
4.19 eRecruit Merge Document Data
Merge Document Data
...
Field Name
...
Field Description
...
Form Type
...
Form Type Abrv.
...
Global Question ID
...
Global Question Label
...
The global question text that is set for this specific global question.
...
Global Question Reference
...
The global question reference that is set for this specific global question.
4.20 eRecruit Form Configuration Data
Form and GQ
...
Field Name
...
Field Description
...
AnswerFormat
...
FormID
...
FormName
...
The name of the form.
...
FormTypeLabel
...
GlobalQuestionID
...
jobreferenceNo
...
The name of the job template.
...
ProcessName
...
The name of the process template.
...
ProcessStepName
...
The name of the process template step.
...
QuestionIndex
...
The order in which this question appears on a form.
...
QuestionLabel
...
The question text assigned to this global question.
...
QuestionReference
...
The question reference of this global question.
...
QuestionTypeLabel
...
SectionHeading
...
SectionIndex
...
StepIndex
...
The step number of the given step.
...
StepTitle
...
Navigate to the relevant page below for a data dictionary of the standard fields included in these views.
Fields common across views are outlined in 4.1 eRecruit Job, Requisition and Application Data. Data from commonly used views 2-5 are outlined in separate pages. Other views are grouped together.
| Page Tree | ||
|---|---|---|
|