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.
Successfactors - Recruiting
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 genereting the report (outside of ad-hoc report).
- merge rows for requisition which have Board ID 'Internal' and 'Externa'l 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 , KBA , LOD-SF-RCM-REP , Reporting & Analytics, Data Imports & Exports , How To