/support/notes/service/sap_logo.png){kind=logo}
SAP Knowledge Base Article - PublicSymptom
In adhoc and Story reports for Recruiting you would be able to see few columns name with phrase (Timestamp) to it.
For Eg: In Application Table, you will find a column Application Date (Timestamp).
Environment
SAP SuccessFactors Recruiting Management
Cause
This enhancement is released in 2105 so that time related entries in the database are stored in one particular time zone.
It also remove some discrepancy we had with the dates seen in UI and in the reports in the past because of the some application and database server in different time zones.
Resolution
As part of the enhancement, the Product had decided to add new columns to the existing tables and labelling it as Timestamp
Please find the list if column labels changed as part of this enhancement. The old columns would still be available in the reports
| Table Name | Old Column label | New column label |
| CANDIDATE | Creation Date | Created Date (Timestamp) |
| Privacy Date | Privacy Date (Timestamp) | |
| Candidate Application Comments | Created Date | Created Date (Timestamp) |
| Last Modified Date | Last Modified Date (Timestamp) | |
| Candidate Profile comments | Created Date | Created Date (Timestamp) |
| Last Modified Date | Last Modified Date (Timestamp) | |
| Candidate Profile Fields Audit | Last Modified Date | Last Modified Date (Timestamp) |
| Candidate Search Audit | Search Date | Search Date (Timestamp) |
| RCM_FIELD_AUD | Last modified Date | Last Modified Date (Timestamp) |
| Candidate Tags | Assigned Date | Assigned Date (Timestamp) |
| REFERRAL Link on Candidate | Expiration Date | Expiration Date (Timestamp) |
| Created Date | Created Date (Timestamp) | |
| Last Modified Date | Last Modified Date (Timestamp) | |
| REFERRAL Link on Application | Created Date | Created Date (Timestamp) |
| Expiration Date | Expiration Date (Timestamp) | |
| Last Modified Date | Last Modified Date (Timestamp) | |
| Referrals linked on Job Requisition | Created Date | Created Date (Timestamp) |
| Expiration Date | Expiration Date (Timestamp) | |
| Last Modified Date | Last Modified Date (Timestamp) | |
| Application | Application Date | Application Date (Timestamp) |
| Candidate Review Date | Candidate Review Date (Timestamp) | |
| Hired On | Hired On (Timestamp) | |
| Forwarded On | Forwarded On (Timestamp) | |
| Exported On | Exported On (Timestamp) | |
| Snapshot Date | Snapshot Date (Timestamp) | |
| Application Assessment Order | Created Date | Created Date (Timestamp) |
| Last Modified Date | Last Modified Date (Timestamp) | |
| APP Status Audit trail | Created Date | Created Date (Timestamp) |
| Forwarded On | Forwarded On (Timestamp) | |
| Job Requisition | Closed Date | Closed Date (Timestamp) |
| Date Created | Date Created (Timestamp) | |
| Posting | Post Start Date | Posting Start Date (Timestamp) |
| Post End Date | Posting End Date (Timestamp) | |
| Post Expiration Date | Posting Expiration Date (Timestamp) | |
| Last Modified Date | Last Modified Date (Timestamp) | |
| Job Requisition Posting Audit History | Posting Start Date | Posting Start Date (Timestamp) |
| Posting End Date | Posting End Date (Timestamp) | |
| Job Req Status Audit | Created Date | Created Date (Timestamp) |
| First Advantage | Submitted On | Submitted On (Timestamp) |
| Offer Detail | Created Date | Created Date (Timestamp) |
| Last Modified Date | Last Modified Date (Timestamp) | |
| Candidate Offer Response Date | Candidate Offer Response Date (Timestamp) | |
| Created Date | Created Date (Timestamp) | |
| Last Modified Date | Last Modified Date (Timestamp) | |
| Last Offer Detail | Created Date | Created Date (Timestamp) |
| Last Modified Date | Last Modified Date (Timestamp) |
These Columns label changes should not have any issues with the already existing integration and also do not have any behavioral changes.
It is also recommended to use the new columns going forward to see the date timestamp data in the reports.
Note: If the Adhoc reports are being used in an integration, the integrations should also be updated to read data from new fields with new labels and date & time format.
Some SFAPIs have new additional fields defined to accurately reflect the date and time. Please consume the new fields when working with SFAPIs identified below:
| Entity Name | Original Field | New Field |
| JobRequisition | jobCloseDate | jobCloseDateTime |
| dateCreated | dateTimeCreated | |
| startDate | startDateTime | |
| endDate | endDateTime | |
| JobApplication | lastModifiedForAppStatus | LastModifiedForAppStatusDateTime |
| hiredOn | hiredOnDateTime | |
| exportedOn | exportedOnDateTime | |
| applicationDate | applicationDateTime | |
| reviewDate | reviewDateTime | |
| AssessmentOrder | createdDate | createdDateTime |
| lastModifiedDate | lastModifiedDateTime | |
| JobPosting | postStartDate | postStartDateTime |
| postEndDate | postEndDateTime | |
| postExpirationDate | postExpirationDateTime |
Keywords
2105 , Adhoc report, column label change, Timestamp , KBA , LOD-SF-RCM-REP , Reporting & Analytics, Data Imports & Exports , Product Enhancement
/support/notes/service/facebook.svg)
/support/notes/service/twitter.svg)
/support/notes/service/youtube.svg)
/support/notes/service/linkedin.svg)
/support/notes/service/instagram2.svg)