Categories
- All Categories
- Oracle Analytics Learning Hub
- 19 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 231 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.9K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 86 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Where to find employee contract dates?
Hi,
We're building KPI dashboards for HR admins and line managers and want to create overviews of new hires and ending contracts.
We're unable to find important employee dates like projected start date and contract end date. Can anyone help us locate these dates?
Thanks!
Answers
-
Could you please confirm whether you are looking for these details in FAW/FDI or OTBI? Kindly specify the application you are using, as this will help us provide better assistance.
Thank you!
0 -
Hi @Sumanth V -Oracle thanks for your response!
We're looking for these details in FAW/FDI0 -
Hello, have you found the answer? @Sumanth V -Oracle
0 -
If I remember correctly, here’s where you generally find those dates:
1. Projected Start Date:
- Usually, this is associated with the Assignment or Person data.
- In FDI templates, this date often appears under the Assignment object.
- Field names you might see:
ProjectedStartDateAssignmentStartDate(sometimes the actual start date if no projected date)
- This date indicates when the employee is expected to start or started the assignment.
2. Contract End Date
- This is often linked to the Assignment as well, especially for contract or temporary workers.
- Field names:
ContractEndDateAssignmentEndDate(if related to the contract period)
- This date specifies when the employee’s contract or assignment ends.
0 -
Hi @RVohra,
Do you mean the Assignment Information in the Worker area of the HCM - Workforce Core FDI subject area?
We can find assignment start and end dates, but the contract dates and projected start date are nowhere to be found anywhere in the Worker area.
Assignment dates are not sufficient, for example when working with Pending Workers. In those cases, we're not interested in the assignment startdates of the PW record, but we want to know the projected start date of the employee record of that same PW.
Interested to hear if there's a way to get those dates into Analytics!0 -
You might need to log a SR for Oracle support to review it with the development team. Oracle Support can suggest if it needs an idea in the Idea Lab.
0 -
Hi @Rebecca Bot
Employee contract details are not directly available in FDI.
You can find them in HcmTopModelAnalyticsGlobalAM.AssignmentAM.ContractPVOViewAll
We must create a data augmentation in order to extract this data.
0
