How do I report on ‘Time In Position’ field in ODS/Advanced Reporting? The field is available in EC under the ‘Job Information’ portlet. However, I am unable to locate the field in ‘Job Information’ table in ODS.
Advanced Reporting in EC (ODS)
The value of the field ‘Time In Position’ is a calculated on the fly and is not stored in the database.
The value displayed here is a difference in Years, Months and Days (2 Years, 3 Months and 5 Days for example) between the Current date and the ’Position Entry Date’.
As the value of the field changes every day, the value is not stored in the database and is calculated on the fly when the ‘Job Information’ portlet is accessed.
As the value is not stored, it is not possible to report on this field.
The TimeIn Calculation calculates the number of years/months/days an employee has worked on a job, position, company, location, department or pay scale level. This value is transient.
It is not possible to report on this field in the exact format as it appears in (2 Years, 3 Months and 5 Days) the instance.
However, the values 2.26 Years or 27.16 Months or 827 Days (approximately) can be derived using the calculated columns feature in Advanced Reporting.
The following fields are filled when job classification, position, company, location, department or pay scale level are changed. Changes are saved to the database:
Job Entry Date
Position Entry Date
Company Entry Date
Location Entry Date
Department Entry Date
Pay Scale Level Entry Date
Therefore these are the fields that can be used for reporting purposes.
This also holds true for other fields where the values are displayed in Years, Months and Days format calculated as difference between current date and another field.
KBA , LOD-SF-ANA-ORD , Online Report Designer , LOD-SF-ANA-ODS , Advanced Reporting , How To