4.6 Other Views

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.