We would like to develop an ad-Hoc report showing the Job Posting value of a requisition, the same way we see them in the Requisition UI in column Job Postings.
This column value must display: Internal (I), External(E), Both(I/E), A (Agency) and Not Posted.
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."
SAP SuccessFactors Recruiting Management
There is no fields returning exactly the terms I,E,I/E,Not Posted,A. It can however be achieved indirectly
The field needed is: column 'Board ID' from table 'Posting'.
This field will return distinct rows for 'External' 'Internal' and 'Empty' if not posted. To get the exact same info as UI, an extra logic will need to be added after generating the report (outside of ad-hoc report).
- merge rows for requisition which have Board ID 'Internal' and 'External' into I/E
- set empty Board ID column as 'Not-Posted'
- filter to remove extra Board IDs 'Internal posting' and posting status 'deleted'
To find this column:
In your Ad-Hoc report type Single Domain Recruiting V2
The Column 'Board ID' is in table 'Posting':
posting values, ad-hoc, reporting on external postings, posting types, board ID, job posting, job requisition, internal, external , KBA , LOD-SF-RCM-REP , Reporting & Analytics, Data Imports & Exports , How To