Organization |
"Requisition Organization"."Organization Level1
Name" |
Country |
"Requisition Primary Location"."Location Level1
Name" |
Category |
"Requisition Job Field"."Job Field Level1 Name" |
Department |
"Requisition Department"."Department Name" |
Hiring Manager |
"Requisition Hiring Manager"."Hiring Manager Name" |
Process Name |
"Submission Transitions Process"."Submission Transitions Process Name (BL)" || Replace("Requisition Identification"."Req. Identifier","Requisition Identification"."Req. Identifier",'') |
Process Owner |
"Submission Transitions Process"."Submission Transitions Process Owner Full Name" || Replace("Requisition Identification"."Req. Identifier","Requisition Identification"."Req. Identifier",'') |
Process Health Is Red |
"Submission Transitions Process"."Submission Transitions Process Progression Health Is Red" || Replace("Requisition Identification"."Req. Identifier","Requisition Identification"."Req. Identifier",'') |
Process Completion |
CASE WHEN "Submission Transitions Process"."Submission Transitions Process Percent Complete" < 25
Then '0-25%'
WHEN "Submission Transitions Process"."Submission Transitions Process Percent Complete" < 50
THEN '25-50%'
WHEN "Submission Transitions Process"."Submission Transitions Process Percent Complete" < 75
Then '50-75%'
WHEN "Submission Transitions Process"."Submission Transitions Process Percent Complete" < 100
Then '75-100%'
END || Replace("Requisition Identification"."Req. Identifier","Requisition Identification"."Req. Identifier",'') |
Process Days In Progress |
"Submission Transitions Process"."Submission Transitions Process Days In Progress" + "Requisition Identification"."# Openings" - "Requisition Identification"."# Openings" |
Task Name |
"Submission Transitions Process"."Submission Transitions Task Name (BL)" || REPLACE("Requisition Identification"."Req. Identifier","Requisition Identification"."Req. Identifier",'') |
Task Assignee |
"Submission Transitions Process"."Submission Transitions Task Assignee Name" || Replace("Requisition Identification"."Req. Identifier","Requisition Identification"."Req. Identifier",'') |
Task Type |
"Submission Transitions Process"."Submission Transitions Task Type" || Replace("Requisition Identification"."Req. Identifier","Requisition Identification"."Req. Identifier",'') |
Task Is Overdue |
"Submission Transitions Process"."Submission Transitions Task Is Overdue" || Replace("Requisition Identification"."Req. Identifier","Requisition Identification"."Req. Identifier",'') |
Task Days In Progress |
TIMESTAMPDIFF(SQL_TSI_DAY, "Submission Transitions Process"."Submission Transitions Task Assignment Date", CURRENT_TIMESTAMP) + "Requisition Identification"."# Openings" - "Requisition Identification"."# Openings" |