Where to find the Enterprise Legal Seniority/ Hire Date fields to add in a OTBI report

Abhishek Bagh

Please advise

AjayKumar Maddipati

Hi Abhishek,

In OTBI most of subject areas available in below cloumns

Worker assigmnent real time subject area -in worker folder please find.

"Worker"."Enterprise Seniority Date"

"Worker"."Enterprise Hire Date"

--------------------------------------------------------------

SQL Issued-

SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT

  0 s_0,

  "Workforce Management - Worker Assignment Real Time"."Worker"."Enterprise Hire Date" s_1,

  "Workforce Management - Worker Assignment Real Time"."Worker"."Enterprise Seniority Date" s_2

FROM "Workforce Management - Worker Assignment Real Time"

ORDER BY 3 ASC NULLS LAST, 2 ASC NULLS LAST

FETCH FIRST 500001 ROWS ONLY.

Thanks,

Ajay.

Abhishek Bagh

HI @AjayKumar Maddipati -

Thanks for your response. Helpful.

I was however looking for Legal Seniority & Legal Hire Date. I have Enterprise Seniority/ Hire Date in my report already but would like to add the Legal ones too. Can you suggest on the above please?

Regards, Abhishek

Hazel De Castro

Any update on this?