Since 12.2020, the ICP Oracle database has been decommisionned and has been migrated to AWS.
Server name: rds-ew1-icar-p-ica.cnbtg4azeov3.eu-west-1.rds.amazonaws.com
Login : iCareReader
The contact is still Saints ZHANG (Shanghai)
Personal information (Id of an employee) : ADP_PERSONAL_DATA(L_LAST_NAME,L_FIRST_NAME)
C_SOURCE means source system, we use mainly GV ( ADP Global View)
C_TYPE means type of data: Original(1) or Fixed ( 2)
ICARE BI4 application is no more used.
It is replaced by the BW HR application
In this file all the detailed SQL for each object.
In this file new tables' joins
The diagram of the universe
List of available objects in ICARE :