Vietnam Era Veterans Readjustment Assistance Act - VEVRAA

The Vietnam Era Veterans Readjustment Assistance Act - VEVRAA report is based on the topic by the same name. It displays information about candidates and employees designated as Vietnam era veterans, including candidate or employee information and job or application information.

Fields

Fields included in the report template

Field Name	Group by	Sort Order	Totals
Candidate/Employee Name		A to Z
Job Req Id		Smallest to Largest
Is Employee
Candidate/Employee Ethnicity
Candidate/Employee Gender
Candidate/Employee Protected Veteran Status
Candidate/Employee Is Protected Veteran
Original Hire Date
Employee Start Date
Home Address Postal Code
Job Req Id
Job
Department
Application Date
Application Status
Job Family
Pay Grade
Location
Work Location Postal Code
Referral Source

Custom Fields

Is Employee

The Is Employee custom field indicates if the Vietnam Era Veteran is an employee. It uses the following expression:

CASE
    WHEN (Employee.StartDate IS NOT NULL
          AND EmploymentStatusGroup.ShortName != 'Terminated'
          AND EmployeeEmploymentStatus.EffectiveEnd IS NULL) THEN 'True'
    ELSE 'False'
END

Candidate/Employee Name

The Candidate/Employee Name custom field displays the name of the Vietnam Era Veteran. It uses the following expression:

CASE
    WHEN (Employee.StartDate IS NOT NULL)
         AND (Employee.DisplayName IS NOT NULL) THEN Employee.DisplayName
    ELSE Candidate.DisplayName
END

Candidate/Employee Ethnicity

The Candidate/Employee Ethnicity custom field displays the candidate's ethnicity. It uses the following expression:

CASE
    WHEN QuestionnaireResponseVEVRAA.Ethnicity IS NOT NULL THEN QuestionnaireResponseVEVRAA.Ethnicity
    ELSE DFEthnicity.ShortName
END

Candidate/Employee Gender

The Candidate/Employee Gender custom field displays the candidate's gender. It uses the following expression:

CASE
    WHEN QuestionnaireResponseVEVRAA.Gender IS NOT NULL THEN QuestionnaireResponseVEVRAA.Gender
    ELSE Employee.Gender
END

Application Date

The Application Date custom field displays Dayforce date. It uses the following expression:

CAST(JobPostingApplication.LastModifiedTimestamp AS DATETIME)

Filters

This template includes the following filters: