4. Data Dictionary

ApplicationID

The internal system code that uniquely identifies this application.

This field should be used to count unique applications or when creating joins to sub-queries.

Format: Universally Unique Identifier (UUID)

Example Value: fef94d3a-3957-8594-d78f-527cd5f60d25

Application Applied On

The date and time when this application was commenced by the candidate.

The time stamp value is used when there is a need to find the earliest (i.e. minimum) or latest (i.e. maximum) events, sort events, create time series charts or create joins to sub-queries.

Format: dd/mm/yyyy hh:mm:ss.s

Example Value: 13/08/2013 13:46:23.457

Application Edited On

The date and time when this application was last edited by the candidate.

The time stamp value is used when there is a need to find the earliest (i.e. minimum) or latest (i.e. maximum) events, sort events, create time series charts or create joins to sub-queries.

Format: dd/mm/yyyy hh:mm:ss.s

Example Value: 13/08/2013 13:46:23.457

Application Submitted On

The date and time when this application was submitted by the candidate. If the application has not been submitted this field is blank.

The time stamp value is used when there is a need to find the earliest (i.e. minimum) or latest (i.e. maximum) events, sort events, create time series charts or create joins to sub-queries.

Format: dd/mm/yyyy hh:mm:ss.s

Example Value: 13/08/2013 13:46:23.457

Application Is Complete

Identifies if the candidate has completed and submitted this application.

Available Values:
* Submitted
* Not Submitted

Application Is Withdrawn

Identifies if the candidate has withdrawn this application.

Available Values:
* Withdrawn
* Not Withdrawn

Application Status

The current overall status of this application.

Default Values:
* Incomplete
* Applied
* Shortlist
* Interview
* Offer
* Accept
* Decline
* Applied Late
* Reinstatement Requested

(Note: There may be additional custom statuses added)

Application Step Drop Out

The furthest step of the application form for this application that has been completed by the candidate.

Example Value: 3. Education

Current APM Step Last Edited

The date and time when the current assessment step of this application was last edited.

The time stamp value is used when there is a need to find the earliest (i.e. minimum) or latest (i.e. maximum) events, sort events, create time series charts or create joins to sub-queries.

Format: dd/mm/yyyy hh:mm:ss.s

Example Value: 13/08/2013 13:46:23.457

Current APM Step Name

The name of the current  step  this application is at in the assessment process.

Format: Step number followed by step name

Example Value: 4. First Interview

Current APM Step Status

The status of the current  step  this application is at in the assessment process.

Available Values:
* Not Started
* In Progress
* Complete
* Successful
* Unsuccessful
* Withdrawn

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

Identifies how this application was created and submitted.

Available Values:
* Online
* Paper

Audience Code

The abbreviated name of the candidate portal audience that was used to submit this application.

Example Value: INT

Audience Name

The full name of the candidate portal audience that was used to submit this application.

Example Value: Internal

Audience Description

The description of the candidate portal audience that was used to submit this application.

Example Value: The internal job web site

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

The source from which this application was received.

Available Values:
* Candidate Portal
* Paper Applicant
* Talent Pool
* Imported
* Vendor
* Job Board

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.

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

IsGlobal

Identifies the scope of the flag attached to this job.

Available Values:
* Global Flag
* Job Flag

FlagDescription

The content of the flag attached to this job.

Title

The title of the user who created this flag.

Example Values:
* Mr
* Ms
* Dr

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.

Email

The full name of the user who created this flag attached to this job.

Format: LastName, FirstName Title

Example Value: Watson, Mary Dr

UserGroup

The eRecruit user group of the user who created this flag attached to this job.

Audience Code

The abbreviated name of a candidate portal audience used to find applications for this job.

Example Value: INT

Audience Name

The full name of a candidate portal audience used to find applications for this job.

Example Value: Internal

Audience Description

The description of a candidate portal audience used to find applications for this job.

Example Value: The internal job web site

Job Audience Close Date

The close date and time for a candidate portal audience used to find applications for this job.

The time stamp value is used when there is a need to find the earliest (i.e. minimum) or latest (i.e. maximum) events, sort events, create time series charts or create joins to sub-queries.

Format: dd/mm/yyyy hh:mm:ss.s

Example Value: 13/08/2013 13:46:23.457

Job Audience Open Date

The open date and time for a candidate portal audience used to find applications for this job.

The time stamp value is used when there is a need to find the earliest (i.e. minimum) or latest (i.e. maximum) events, sort events, create time series charts or create joins to sub-queries.

Format: dd/mm/yyyy hh:mm:ss.s

Example Value: 13/08/2013 13:46:23.457

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.

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.

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.

JobID

The internal system code that uniquely identifies this job.

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

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

The date and time when this job / requisition was archived. If the job / requisition is not archived this field will be blank.

The time stamp value is used when there is a need to find the earliest (i.e. minimum) or latest (i.e. maximum) events, sort events, create time series charts or create joins to sub-queries.

Format: dd/mm/yyyy hh:mm:ss.s

Example Value: 13/08/2013 13:46:23.457

Job Created On

The date and time when this job / requisition was created.

The time stamp value is used when there is a need to find the earliest (i.e. minimum) or latest (i.e. maximum) events, sort events, create time series charts or create joins to sub-queries.

Format: dd/mm/yyyy hh:mm:ss.s

Example Value: 13/08/2013 13:46:23.457

Job Edited On

The date and time when the details of this job / requisition were last edited.

The time stamp value is used when there is a need to find the earliest (i.e. minimum) or latest (i.e. maximum) events, sort events, create time series charts or create joins to sub-queries.

Format: dd/mm/yyyy hh:mm:ss.s

Example Value: 13/08/2013 13:46:23.457

Job Close Date

The date and time this job was last displayed to any candidate portal audience. This field will be blank if this job has not been posted to any candidate portal audience.

The time stamp value is used when there is a need to find the earliest (i.e. minimum) or latest (i.e. maximum) events, sort events, create time series charts or create joins to sub-queries.

Format: dd/mm/yyyy hh:mm:ss.s

Example Value: 13/08/2013 13:46:23.457

Job Open Date

The date and time this job was first displayed to any candidate portal audience. This field will be blank if this job has not been posted to any candidate portal audience.

The time stamp value is used when there is a need to find the earliest (i.e. minimum) or latest (i.e. maximum) events, sort events, create time series charts or create joins to sub-queries.

Format: dd/mm/yyyy hh:mm:ss.s

Example Value: 13/08/2013 13:46:23.457

Current Workflow Step

The name of the current workflow step for this job / requisition.

Format: Step number followed by step name

Example Value: 1. Raise Requisition

Job Owner (Username)

The eRecruit user name of the owner of the  of this job that is entered on the job details form.

Example Value: d.jones

Job Status

The current status of this application.

Example Values:
* Incomplete
* Pending Open Date
* Job Open
* Selection Process
* Onboarding
* In Progress
* Not Approved
* Requires More Information
* Approved
* Job Archived

(Note: There may be additional custom statuses added)

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

Identifies if this job is a requisition or if it has been converted a job.

Available Values:
* Requisition
* Job

JobsTemplate

Identifies if this job is job or a job template.

Available Values:
* Job Template
* Job

Subject

The subject line of this application note.

Content

The contents of this application note.

Created By

The full name of the creator of this application note.

Format: FirstName LastName

Example Value: Susan Maddison

CreatedOn

The date and time when this application note was created.

The time stamp value is used when there is a need to find the earliest (i.e. minimum) or latest (i.e. maximum) events, sort events, create time series charts or create joins to sub-queries.

Format: dd/mm/yyyy hh:mm:ss.s

Example Value: 13/08/2013 13:46:23.457

UserID

The internal system code that uniquely identifies the vendor user who submitted this application on behalf of the candidate.

Example Value: fef94d3a-3957-8594-d78f-527cd5f60d25

MiddleName

The middle name of the vendor user who submitted this application on behalf of the candidate.

Title

The title of the vendor user who submitted this application on behalf of the candidate.

Example Values:
* Mr
* Ms
* Dr

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.

Email

The email address of the vendor user who submitted this application on behalf of the candidate.

Format: Email address

Example Value: martin.james@domain.com

Username

The eRecruit user name of the vendor user who submitted this application on behalf of the candidate.

Example Value: d.jones

VendorBranchCountry

The country of the branch of the vendor user who submitted this application on behalf of the candidate.

Example Value: Australia

VendorBranchFax

The fax number of the branch of the vendor user who submitted this application on behalf of the candidate.

Example Value: (02) 9876-5556

VendorBranchName

The name of the branch of the vendor user who submitted this application on behalf of the candidate.

Example Value: Sydney North

VendorBranchPhone

The phone number of the branch of the vendor user who submitted this application on behalf of the candidate.

Example Value: (02) 9876-5555

VendorBranchPostCode

The post code of the branch of the vendor user who submitted this application on behalf of the candidate.

Example Value: 2065

VendorBranchState

The state of the branch of the vendor user who submitted this application on behalf of the candidate.

Example Value: New South Wales

VendorBranchStreet

The street of the branch of the vendor user who submitted this application on behalf of the candidate.

Example Value: Level 3, 265 Pacific Hwy

VendorBranchSuburb

The suburb of the branch of the vendor user who submitted this application on behalf of the candidate.

Example Value: St Leonards

VendorCode

The abbreviated name of the organisation of the vendor user who submitted this application on behalf of the candidate.

Example Value: ADCC

vendorName

The full name of the organisation of the vendor user who submitted this application on behalf of the candidate.

Example Value: Adecco

UserStatus

The registration status of the eRecruit account of the vendor user who submitted this application on behalf of the candidate.

Available Values:
* User Active
* User Active
* User Inactive

Template First Created

The date and time when this process commenced. The start condition depends on the process type:

* Requisition Process - When the first step in the requisition process started.

* Job Creation Wizard - When the job creation wizard started.

* Assessment Process - When the first applicant reached the first step in the assessment process.

* Candidate Approval - When the first step in the candidate approval process started.

The time stamp value is used when there is a need to find the earliest (i.e. minimum) or latest (i.e. maximum) events, sort events, create time series charts or create joins to sub-queries.

Format: dd/mm/yyyy hh:mm:ss.s

Example Value: 13/08/2013 13:46:23.457

Template Last Edited

The date and time when any step in this process was last edited.

The time stamp value is used when there is a need to find the earliest (i.e. minimum) or latest (i.e. maximum) events, sort events, create time series charts or create joins to sub-queries.

Format: dd/mm/yyyy hh:mm:ss.s

Example Value: 13/08/2013 13:46:23.457

Template Creation - Last Action (Minutes)

The duration, in minutes, between the creation of the process (e.g. create a job from a template) and the last time ANY (i.e not just the furthest) step in the process was actioned. An action could be editing a requisition form or an assessment form, or pushing an application through the process.

Format: Integer

Template First Action - Last Action (Minutes)

The duration, in minutes, between the first action in a process (e.g. the first application is received) and the last time ANY (i.e not just the furthest) action was performed on ANY step in the process. An action could be editing a requisition form or an assessment form, or pushing an application through the process.

Format: Integer

REQ Process Start - Finish (Minutes)

The duration, in minutes, it took for the requisition process to complete.

If the row is for a step in the requisition process then the value of this field will equal the value of the "Process First Action to Last Action Duration (Minutes)" field. If you are looking at a row for a step for another process then the value of the "Process First Action to Last Action Duration (Minutes)" field will equal the duration of that process.

Format: Integer

APM Process Start - Finish (Minutes)

The duration, in minutes, it took for the assessment process to complete.

If the row is for a step in the assessment process then the value of this field will equal the value of the "Process First Action to Last Action Duration (Minutes)" field. If you are looking at a row for a step for another process then the value of the "Process First Action to Last Action Duration (Minutes)" field will equal the duration of that process.

Format: Integer

Entire Process Start - Finish (Minutes)

The duration, in calendar days, of the complete workflow process for this job.

The workflow process duration is the sum of the duration for each process type, that is:

Requisition Process Duration (Minutes) + Job Creation Wizard Duration (Minutes) + Assessment Process Duration (Minutes) + Candidate Approval Duration (Minutes)

Format: Integer

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)

The duration, in minutes, it took for the job creation wizard to complete.

If the row is for a step in the job creation wizard then the value of this field will equal the value of the "Process First Action to Last Action Duration (Minutes)" field. If you are looking at a row for a step for another process then the value of the "Process First Action to Last Action Duration (Minutes)" field will equal the duration of that process.

Format: Integer

Process Step First Created

The date and time when this process step commenced. The start condition depends on the process type:

* Requisition Process - When this step in the requisition process is started.

* Job Creation Wizard - When this step in the job creation wizard is started.

* Assessment Process - When the first applicant reached this step in the assessment process.

* Candidate Approval - When this step in the candidate approval process is started.

The time stamp value is used when there is a need to find the earliest (i.e. minimum) or latest (i.e. maximum) events, sort events, create time series charts or create joins to sub-queries.

Format: dd/mm/yyyy hh:mm:ss.s

Example Value: 13/08/2013 13:46:23.457

Process Step Last Edited

The date and time when this step in this process was lasted edited.

The time stamp value is used when there is a need to find the earliest (i.e. minimum) or latest (i.e. maximum) events, sort events, create time series charts or create joins to sub-queries.

Format: dd/mm/yyyy hh:mm:ss.s

Example Value: 13/08/2013 13:46:23.457

Process Step Time Taken (Minutes)

The duration, in minutes, between the first action in a step (e.g. the first application entering the step) and the last time that step was actioned. An action could be editing a requisition or assessment form, or changing the step status.

Format: Integer

# of Applicants Complete

The number of complete and submitted applications for this job that have an assessment status of "Complete" for this step.

Format: Integer

# of Applicants in Progress

The number of complete and submitted applications for this job that have an assessment status of "In Progress" at this step.

Format: Integer

# of Applicants Not Started

The number of complete and submitted applications for this job that have an assessment status of "Not Started" at this step.

Format: Integer

# of Applicants On Hold

The number of complete and submitted applications for this job that have an assessment status of "On Hold" at this step.

Format: Integer

# of Applicants Pending

The number of complete and submitted applications for this job that have an assessment status of "Pending" at this step.

Format: Integer

# of Applicants Successful

The number of complete and submitted applications for this job that have an assessment status of "Successful" at this step.

Format: Integer

# of Applicants Unsuccessful

The number of complete and submitted applications for this job that have an assessment status of "Unsuccessful" at this step.

Format: Integer

# of Applicants Withdrawn

The number of complete and submitted applications for this job that have an assessment status of "Withdrawn" at this step.

Format: Integer

Process Created On

The date and time when this process was first created.

The time stamp value is used when there is a need to find the earliest (i.e. minimum) or latest (i.e. maximum) events, sort events, create time series charts or create joins to sub-queries.

Format: dd/mm/yyyy hh:mm:ss.s

Example Value: 13/08/2013 13:46:23.457

Process is Active

Identifies if this process is currently active and available for use or inactive and not available for use.

Available Values:
* Active
* Inactive

Process is Template

Identifies if this is a process template or a process derived from a process template.

Available Values:
* Process Template
* Process

Process Name

The user entered name of the process template.

The values in this field are based on the names given to the various requisition, assessment or candidate approval processes created in the eRecruit system.

Example Values:
* Request to Recruit
* Job Creation Wizard
* Casual Position - Online Assessment

Step Auto Complete

Identifies if this process step completes automatically or requires user intervention to be completed.

Available Values:
* Automatic
* Manual

Process Step ID

The internal system code that uniquely identifies this process step.

This field should be used to count unique process steps or when creating joins to sub-queries.

Format: Universally Unique Indeniter (UUID)

Example Value: fef94d3a-3957-8594-d78f-527cd5f60d25

Process Step is Template

Identifies if this is a process step template or a process step derived from a process step template.

Available Values:
* Process Step Template
* Process Step

Process Step Mandatory

Identifies if the completion of this step is mandatory or optional in the process

Available Values:
* Mandatory
* Optional

Process Step Name

The user entered name of the process step.

The values in this field are based on the names given to the various process steps created in the eRecruit system.

Example Values:
* Request to Recruit
* Job Creation Wizard
* Casual Position - Online Assessment

Process Step Number

The overall sequential number for this step in the process type for this job.

This field is used to sort all steps in the process type in the chronological order they occurred.

Format: Integer

Last Process Step Number

The maximum value of the field "Process Step Number" for a given job.

This field allows the most recently executed step in the process type to be identified.

Format: Integer

Overall Workflow Step Number

The overall sequential number for this step in the workflow for this job. This number sequence spans all process types used in the workflow.

This field is used to sort all steps in the workflow in the chronological order they occurred.

Format: Integer

Last Overall Process Step Number

The maximum value of the field "Overall Workflow Step Number" for a given job.

The overall number of workflow steps for a job is the sum of all of the steps in the processes (i.e. Requisition + Job Creation Wizard + Assessment Process + Candidate Approval Process).

This field allows the most recently executed step in the overall workflow to be identified.

Format: Integer

Process Type Description

The type of process within the overall workflow.

Available Values:
* Requisition Process
* Job Creation Wizard
* Assessment Process
* Candidate Approval

Step Created:

Step Edited:

Step Status

The status of this process step for this job.

Available Values:
* Not Started
* In Progress
* Complete

Creation to Last Modified (Minutes)

The internal system code that uniquely identifies this overall workflow.

This field should be used to count unique workflow or when creating joins to sub-queries.

Format: Universally Unique Indeniter (UUID)

Example Value: fef94d3a-3957-8594-d78f-527cd5f60d25

ProcessID

The internal system code that uniquely identifies this process.

This field should be used to count unique processes or when creating joins to sub-queries.

Format: Universally Unique Identifier (UUID)

Example Value: fef94d3a-3957-8594-d78f-527cd5f60d25

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.

Email

The email address of the user assigned to this process step.

Format: Email address

Example Value: martin.james@domain.com

User Group

The eRecruit user group of the user assigned to this process step.

Username

The eRecruit user name of the user assigned to this process step.

Example Value: d.jones

User Group is Vendor

Identifies if the user assigned to this process step is internal to the organisation or an external vendor.

Available Values:
* Internal
* Vendor

Vendor Branch Name

The name of the branch of the vendor user assigned to this process step.

If the user is internal to the organisation the value of this field is empty.

Example Value: Sydney North

Date Task Last Edited

UserRegion

The region entered in the user record of the user with permission to complete this process step.

Permission Type

Identifies the if the permission applied to this process step is allocated to a user or group.

Available Values:
* User
* Group

Permission Target

User Group Name

The name of the group with permission to complete to this process step.

Format: GroupName

Example Value: Graduate Recruiters

User Group Description

The decription of the group with permission to complete to this process step.

Format: Group Description

Example Value: The graduate recruitment team.

User Group Status

Identifies the status in eRecruit of the group with permission  to complete this process step.

Available Values:
* Active
* Inactive

User Group is Vendor

Identifies if the group with permission  to this process step is / are internal to the organisation or an external vendor.

Available Values:
* Internal
* Vendor

Vendor Branch Name

The name of the branch of the vendor group with permission to complete this process step.

If the user is / are internal to the organisation the value of this field is empty.

Example Value: Sydney North

Title

The title of the user with permission to complete this process step.

Example Values:
* Mr
* Ms
* Dr

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.

Email

The email address of the user(s) with permission to complete this process step.

Format: Email address

Example Value: martin.james@domain.com

Username

The eRecruit user name of the user with permission to complete this process step.

Example Value: d.jones

User Expiry Date

User Status

Identifies the status in eRecruit of the user with permission  to complete this process step.

Available Values:
* Active
* Inactive

UserGroup

The name of the group that the user with permission to complete to this process step belongs to.

Format: GroupName

Example Value: Graduate Recruiters

User Group is Vendor

The name of the branch of the vendor group with permission to complete this process step.

If the user is / are internal to the organisation the value of this field is empty.

Example Value: Sydney North

Vendor Branch Name

User Timezone Label

User Timezone Name

Activity

Activities define a series of interviews. An activity can span over several dates, for example, a series of graduate interviews being covered over 5 days. The activity would represent the overall 5 days of interviews.

Example Value: Graduate Program 2013

Activity Block

Activity Blocks define the dates you can schedule the interview bookings for that particular activity. Using a graduate example, the activity would represent the overall 5 days of interviews and the block would define the individual days.

Example Value: Graduate Assessment 20/7

Activity Block Status

Format:
Example Value: Ended

Activity Block Type

The activity type defines the specific interview or activity that you will be inviting your applicatants to.

Example Value: 1st Round Graduate Interview

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

This is the start date and time of the slot.
The time stamp value is used when there is a need to find the earliest (i.e. minimum) or latest (i.e. maximum) events, sort events, create time series charts or create joins to sub-queries.
Format: dd/mm/yyyy hh:mm:ss.s

Example Value: 13/08/2013 13:46:23.457

Slot End Date & Time

This is the end date and time of the slot.
The time stamp value is used when there is a need to find the earliest (i.e. minimum) or latest (i.e. maximum) events, sort events, create time series charts or create joins to sub-queries.
Format: dd/mm/yyyy hh:mm:ss.s

Example Value: 13/08/2013 13:46:23.457

Duration (Minutes)

This is the duration of the activity slot.
Format: mm

Example Value: 90

ProcessStepID

The internal system code that uniquely identifies the step in the Application Process this application passed through.

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

CurrentProcessStepID

The internal system code that uniquely identifies the step in the Application Process this application is currently at. If the process is complete this is the unique identifier of the final step in the process.

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

ProcessID

The internal system code that uniquely identifies the Application Process this application is currently in.

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

ProcessName

The user entered name of the Application Process template.

The values in this field are based on the names given to the various Application Processes created in the eRecruit system.

Example Values:
* Standard Recruitment
* Registration of Interest
* Graduate Campaign

ProcessStepExecutionStatusValue

The status of this process step for this job.

Available Values:
* Complete
* In Progress
* Not Started
* On Hold
* Successful
* Unsuccessful
* Withdrawn

ProcessStepName

The user entered name of the Application Process step this application passed through.

The values in this field are based on the names given to the various process steps created in the eRecruit system.

Example Values:
* Shortlist
* First Interview
* Reference Check

ProcessStepNumber

The overall sequential number for this step in the Application Process this application passed through.

This field is used to sort all steps in the process type in the chronological order they occurred.

Format: Integer

ProcessStepScore

The score achieved by the application at this process step. The score achieved is based on rules defined for the step or from the score obtained from an integrated test provider.

Format: Numeric (3 Decimal Places)

Note: For process stpes related to the "Application Process" the value of this field is blank (i.e. NULL).

ProcessStepStartTime

The date and time when this Application Process step commenced.

If the Application Process Step Name is "Appliction Process" then the value of this field is blank.

The time stamp value is used when there is a need to find the earliest (i.e. minimum) or latest (i.e. maximum) events, sort events, create time series charts or create joins to sub-queries.

Format: dd/mm/yyyy hh:mm:ss.s

Example Value: 13/08/2013 13:46:23.457

The date and time when this Application Process step commenced.

If the Application Process Step Name is "Appliction Process" then the value of this field is blank.

The date value is used for columns / rows in reports, a X-axis on a chart, filters, or date-based sections.

Format: dd/mm/yyyy

Example Value: 13/08/2013

ProcessStepDurationDays

ProcessStepDurationSeconds

ProcessStepEndTime

The date and time when this Application Process step is complete.

If the Application Process Step Name is "Appliction Process" then the value of this field is blank.

The time stamp value is used when there is a need to find the earliest (i.e. minimum) or latest (i.e. maximum) events, sort events, create time series charts or create joins to sub-queries.

Format: dd/mm/yyyy hh:mm:ss.s

Example Value: 13/08/2013 13:46:23.457

ProcessStepExecCreatedOn

The date and time when this Application Process steps was created from a template.

The time stamp value is used when there is a need to find the earliest (i.e. minimum) or latest (i.e. maximum) events, sort events, create time series charts or create joins to sub-queries.

Format: dd/mm/yyyy hh:mm:ss.s

Example Value: 13/08/2013 13:46:23.457

ProcessStepExecEditedOn

The date and time when this Application Process step was last actioned. An action could be editing a assessment form, or changing the step status.

The time stamp value is used when there is a need to find the earliest (i.e. minimum) or latest (i.e. maximum) events, sort events, create time series charts or create joins to sub-queries.

Format: dd/mm/yyyy hh:mm:ss.s

Example Value: 13/08/2013 13:46:23.457

ApplicationUpdateTimestamp

The date and time when the application process step reporting data was refreshed from the source system.

The time stamp value is used when there is a need to find the earliest (i.e. minimum) or latest (i.e. maximum) events, sort events, create time series charts or create joins to sub-queries.

Format: dd/mm/yyyy hh:mm:ss.s

Example Value: 13/08/2013 13:46:23.457

ApplicationStatus

The status of the application.

Default Values:
* Incomplete
* Applied
* Shortlist
* Interview
* Offer
* Accept
* Decline
* Applied Late
* Reinstatement Requested

(Note: There may be additional custom statuses added)

StatusUpdatedOn

The date and time when the application status was updated.

The time stamp value is used when there is a need to find the earliest (i.e. minimum) or latest (i.e. maximum) events, sort events, create time series charts or create joins to sub-queries.

Format: dd/mm/yyyy hh:mm:ss.s

Example Value: 13/08/2013 13:46:23.457

LattestDateTaskTargetWasWorkedOn

The date and time when the task was last worked on.
The time stamp value is used when there is a need to find the earliest (i.e. minimum) or latest (i.e. maximum) events, sort events, create time series charts or create joins to sub-queries.
Format: dd/mm/yyyy hh:mm:ss.s

Example Value: 13/08/2013 13:46:23.457

TaskDescription

taskID

The internal system code that uniquely identifies this task.
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

TaskName

TaskTarget

TaskTargetKey

Available Values:

* Application
* Job
* JobAd
* JobPermissionID
* Position
* SharedFile
* User
* Vendor

TaskTargetStatusValue

Available Values:

* Complete
* In Progress
* Not Started

EmailContent

The text that was included in the body of the e-mail

EmailCopiedFrom

EmailCreatedOn

The date and time when this email was xxxx.

The time stamp value is used when there is a need to find the earliest (i.e. minimum) or latest (i.e. maximum) events, sort events, create time series charts or create joins to sub-queries.

Format: dd/mm/yyyy hh:mm:ss.s

Example Value: 13/08/2013 13:46:23.457

EmailEditedOn

The date and time when this email was xxxx.

The time stamp value is used when there is a need to find the earliest (i.e. minimum) or latest (i.e. maximum) events, sort events, create time series charts or create joins to sub-queries.

Format: dd/mm/yyyy hh:mm:ss.s

Example Value: 13/08/2013 13:46:23.457

EmailIsActive

yes/no

EmailIsDefaultTemplate

Identifies if this is the default email template.

Available Values:
* yes
* no

EmailIsTemplate

Identifies if this is an email or email template.

Available Values:
* yes
* no

EmailLabel

Values include:

* Task
* Default Task Notification
* Withdraw from Job Confirmation
* Job Alert
* Requisition Process

EmailSenderEmail

The email address of the sender of the e-mail.

Example Value: mary@somedomain.com

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

The name of the template the email was created from.

Values include:

* Candidate Application Reinstated
* Candidate Registration Email Template
* Hiring Manager Approval
* Job Alert Template
* Requisition Process Template

RecipientEmail

The email address of the recipient of the e-mail.

Example Value: mary@somedomain.com

SentOn

The date and time when this email was sent.

The time stamp value is used when there is a need to find the earliest (i.e. minimum) or latest (i.e. maximum) events, sort events, create time series charts or create joins to sub-queries.

Format: dd/mm/yyyy hh:mm:ss.s

Example Value: 13/08/2013 13:46:23.457

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

The date and time when the job status was updated.
The time stamp value is used when there is a need to find the earliest (i.e. minimum) or latest (i.e. maximum) events, sort events, create time series charts or create joins to sub-queries.

Format: dd/mm/yyyy hh:mm:ss.s

Example Value: 13/08/2013 13:46:23.457

minutesSinceFirstStatusUpdate

minutesSinceLastStatusUpdate

NewStatus

The status of the job.
Default Values:
* Incomplete
* Pending Open Date
* Job Open
* Selection Process
* Job Archived
* Decline
* Applied Late
* Reinstatement Requested

(Note: There may be additional custom statuses added)

OldStatus

StatusUpdateNumber

The status update order for a given job.

This field is used to identify the chronological order of the job status updates for a given job.

BroadStatus

The type of action that was made against the job ad.

Available Values:

* Sent
* Expired

CreatedOn

The date and time when the job ad was created.

The time stamp value is used when there is a need to find the earliest (i.e. minimum) or latest (i.e. maximum) events, sort events, create time series charts or create joins to sub-queries.

Format: dd/mm/yyyy hh:mm:ss.s

Example Value: 13/08/2013 13:46:23.457

JobAdFirstLastDateTime

The date and time when the job ad was last posted to the job board.

The time stamp value is used when there is a need to find the earliest (i.e. minimum) or latest (i.e. maximum) events, sort events, create time series charts or create joins to sub-queries.

Format: dd/mm/yyyy hh:mm:ss.s

Example Value: 13/08/2013 13:46:23.457

JobAdFirstSentDateTime

The date and time when the job ad was first posted to the job board.

The time stamp value is used when there is a need to find the earliest (i.e. minimum) or latest (i.e. maximum) events, sort events, create time series charts or create joins to sub-queries.

Format: dd/mm/yyyy hh:mm:ss.s

Example Value: 13/08/2013 13:46:23.457

JobAdReference

The reference number of this job ad.

JobAdStatus

The status of this job ad.

Available Values:

* Sent to Job Board
* Expired - Manually
* Expired - Applications Closed

JobBoardName

The name of the job board to which the job ad was posted.

Example Values:

* Seek
* MyCareer

LastModifiedByUserID

LastModifiedOn

The date and time when the job ad was last modified.

The time stamp value is used when there is a need to find the earliest (i.e. minimum) or latest (i.e. maximum) events, sort events, create time series charts or create joins to sub-queries.

Format: dd/mm/yyyy hh:mm:ss.s

Example Value: 13/08/2013 13:46:23.457

AverageNumberOfJobsPerMatch

The average number of jobs that are returned with each match to the criteria set in the job alert.

CreatedOn

The date and time when this job alert was created.

The time stamp value is used when there is a need to find the earliest (i.e. minimum) or latest (i.e. maximum) events, sort events, create time series charts or create joins to sub-queries.

Format: dd/mm/yyyy hh:mm:ss.s

Example Value: 13/08/2013 13:46:23.457

FirstMatch

The date and time when the first match was found after the job alert was created.

The time stamp value is used when there is a need to find the earliest (i.e. minimum) or latest (i.e. maximum) events, sort events, create time series charts or create joins to sub-queries.

Format: dd/mm/yyyy hh:mm:ss.s

Example Value: 13/08/2013 13:46:23.457

IsActive

This field indicates whether or not the job alert profile is currently active.

Available values:

* yes
* no

JobAlertProfileAudience

The audience that was used to set up the job alert profile.

Sample values:

* Internal
* External

JobAlertProfileFrequencyValue

The current frequency that the user has elected to receive job alert e-mails.

Available values:

* daily
* monthly
* weekly

LatestMatch

The date and time when a match was last found for this job alert.

The time stamp value is used when there is a need to find the earliest (i.e. minimum) or latest (i.e. maximum) events, sort events, create time series charts or create joins to sub-queries.

Format: dd/mm/yyyy hh:mm:ss.s

Example Value: 13/08/2013 13:46:23.457

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.

FunctionDescription

Provides a description of the function for which the permissions are assigned.

FunctionName

The name of the function for which the permissions are assigned.

Sample values:

* Edit Job Template
* Delete Applications
* Mobile Reports

ModuleName

The name of the module for which the permissions are assigned.

Sample values:

* Activity Scheduler
* Assessment Process Manager
* Job Manager

PermissionOwner

Indicates whether the entry relates to permissions assigned to a user or user group.

Available Values:

* User
* User-group

PermissionType

Indicates whether the entry relates to permissions for a function or module.

Available Values:

* Function
* Module

JobOrProcessName

The name of the job or process that was copied.

JobOrProcessType

Identifies the type of job or process that was copied.

Available Values:

* Approval
* Assessment
* Job
* Requisition

LastDateTimeCopied

The date and time this job or process was last copied.

The time stamp value is used when there is a need to find the earliest (i.e. minimum) or latest (i.e. maximum) events, sort events, create time series charts or create joins to sub-queries.

Format: dd/mm/yyyy hh:mm:ss.s

Example Value: 13/08/2013 13:46:23.457

NumberOfTimeCopied

The number of times that this job or process has been copied.

CreatedByUserFullName

The full name off the user who created this SMS message.

Format: First Name Last Name

Example Value: John Smith

MessageContent

The content that was included in the SMS message.

MessageCreatedOn

The date and time when the SMS message was created.

The time stamp value is used when there is a need to find the earliest (i.e. minimum) or latest (i.e. maximum) events, sort events, create time series charts or create joins to sub-queries.

Format: dd/mm/yyyy hh:mm:ss.s

Example Value: 13/08/2013 13:46:23.457

MessageEditedOn

The date and time when the SMS message was last edited.

The time stamp value is used when there is a need to find the earliest (i.e. minimum) or latest (i.e. maximum) events, sort events, create time series charts or create joins to sub-queries.

Format: dd/mm/yyyy hh:mm:ss.s

Example Value: 13/08/2013 13:46:23.457

MessageLength

The number of characters that were included in the SMS message.

MessageSentOn

The date and time when the SMS message was sent.

The time stamp value is used when there is a need to find the earliest (i.e. minimum) or latest (i.e. maximum) events, sort events, create time series charts or create joins to sub-queries.

Format: dd/mm/yyyy hh:mm:ss.s

Example Value: 13/08/2013 13:46:23.457

MessageStatus

The status of this SMS Message.

Available values:

* -1
* 100 OK
* 710 0 Invalid destination number
* 720 0 Invalid destination number
* not sent (number is not numeric)
* spooling

NumberOfMessagesSent

The number of SMS messages required to send the full message.

The maximum number of characters per SMS message is 160. Therefore, if you send a message with 161 charactors, two messages will be sent.

RecipientFullName

The full name of the recipient of this SMS message.

Format: First Name Last Name

Example Value: John Smith

RecipientMobileNumber

The mobile number of the recipient of this SMS message.

RoleName

The name of the role that has been assigned to the user.

Sample Values:

* Hiring Manager
* HR Officer
* Panel Member

PermissionOwner

Indicates whether the entry relates to permissions assigned to a user or user group.
Available Values:

* User
* User-group

RoleName

The name of the role that has been assigned to the user or user group.

Sample Values:

* Hiring Manager
* HR Officer
* Panel Member

CreatedOn

The date and time when the talent search was created.

The time stamp value is used when there is a need to find the earliest (i.e. minimum) or latest (i.e. maximum) events, sort events, create time series charts or create joins to sub-queries.

Format: dd/mm/yyyy hh:mm:ss.s

Example Value: 13/08/2013 13:46:23.457

IsPublic

Identifies whether the search is set as public. A public search is able to be used by all users with access to the talent warehouse.

Available Values:

* Yes
* No

IsTemplate

Identifies whether the result is a talent search template, or search result.

Where a search template differs from a saved search is that it won’t have any data attached, just the configured criteria.

Available Values:

* Yes
* No

LastRun

The date and time when this talent search was last run.

The time stamp value is used when there is a need to find the earliest (i.e. minimum) or latest (i.e. maximum) events, sort events, create time series charts or create joins to sub-queries.

Format: dd/mm/yyyy hh:mm:ss.s

Example Value: 13/08/2013 13:46:23.457

SearchHits

The number of candidates that the search retrieved.

SearchString

The parameters that were used to run the search.

Example Value:

( internalcandidate:yes ) AND ( state:nsw )

ActionExtendedInformation

ActionName

The name of the action that was recorded.

Sample Values:

* Change Group to Accounting
* Create Candidate Merge Document
* Set ATS Flag to Masters

ConfigurationChangeTargetType

The target type of the configuration change.

Available Values:

* Action
* Job
* Rule

ConfigurationLogActionName

The name of the action that the configuration change is associated with.

Sample Values:

* Create Job
* Enable Job Alerts
* Role Created

ConfigurationLogCreatedOn

The date and time when the configuration log entry was created.

The time stamp value is used when there is a need to find the earliest (i.e. minimum) or latest (i.e. maximum) events, sort events, create time series charts or create joins to sub-queries.

Format: dd/mm/yyyy hh:mm:ss.s

Example Value: 13/08/2013 13:46:23.457

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

Form Type

The global question use (form type) that is set for this specific global question.

Sample Values:

* Application Form
* Assessment Form

Form Type Abrv.

The global question use (form type abbreviation) that is set for this specific global question.

Sample Values:

* AppForm
* AssessForm

Global Question ID

The internal system code that uniquely identifies this global question

Format: Universally Unique Indeniter (UUID)

Example Value: fef94d3a-3957-8594-d78f-527cd5f60d25

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.

AnswerFormat

The question type of this global question.

Sample Values:

* calendar
* checkbox
* group
* radio

FormID

The internal system code that uniquely identifies this form.

Format: Universally Unique Indeniter (UUID)

Example Value: fef94d3a-3957-8594-d78f-527cd5f60d25

FormName

The name of the form.

FormTypeLabel

Available Values:

* Application Form
* Approval Form
* Assessment Form
* Job Ad Form
* Pre-Application Form
* Requisition Form

GlobalQuestionID

The internal system code that uniquely identifies this global question

Format: Universally Unique Indeniter (UUID)

Example Value: fef94d3a-3957-8594-d78f-527cd5f60d25

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

Available Values:

* Custom Referee Question
* Custom Tertiary Question
* Group Question
* Simple Question

SectionHeading

SectionIndex

StepIndex

The step number of the given step.

StepTitle

The name of the step.