Symptom
Missing Employment Detail Or Employment Infos in Adhoc report or ORD and ODS
Cannot see Employment and Personal information
Cannot report on Employment Detail Or Employment Infos in Adhoc report or ORD and ODS
Hire Date is not the same in Adhoc Report and ORD or ODS
Environment
Employe Central
Reproducing the Issue
Run an Adhoc Report and ORD or ODS report
Result: Hire Date is not the same in Adhoc Report and ORD or ODS
Cause
The data is already present in EP and EC tables, but looks like employment data was not imported for these users.
Resolution
Step 1: Download the import template for the data that will be replaced:
In Admin Center > Import Employee Data
Click ‘Download a blank CSV template’ dropdown and select the appropriate template
Here: Employment Detail
Step 2: In AdHoc Reporting, run sub domain: Person and Employment Export
In AdHoc Reporting, select Create New Report
Choose the ‘Person and Employment Export’ report definition type
In Column, Select only column “Employee Info”
Build the report based on the import template you downloaded in step 1.
Filter Test user
Save
Keep an unaltered copy of this report as backup
Step 3:Review the populated import template to ensure all data is correct
Populate the downloaded import template with the data from your Ad Hoc report. If the fields in the Ad Hoc report and import template match, copy and paste can speed up this portion of the process
Run a Full purge import for the user
In Admin Center > Import Employee Data, for example,
Select Employment Detail
Choose the file created in step 3 and select ‘Validate’ to confirm the information is correct
Once validation is completed with no errors, Import the file
Result: Once the "Employment Details" import is performed for these users, ODS or ORD will include their employee data in the report.
Keywords
ECT-45904 Hire Date Employment Detail Employment Infos Adhoc Report ORD ODS , KBA , LOD-SF-EC-EMP , Employment Information (Employment Details) , LOD-SF-EC , Employee Central , LOD-SF-EC-REP , Reporting Data (EC core only) , LOD-SF-EC-ROD , Advanced Reporting (Employee Central ODS/ORD) , Problem