View Source

Since 12.2020 , the ICP Oracle database has been decommisionned and has been migrated to AWS.

TECHNO - BI TEAM > zzz ICARE (HR) > image2021-1-7_9-46-34.png

TECHNO - BI TEAM > zzz ICARE (HR) > image2021-1-14_9-48-46.png

The contact is still Saints ZHANG (Shanghai)

TECHNO - BI TEAM > zzz ICARE (HR) > image2021-1-21_19-10-35.png

Personal information (Id of an employee) : ADP_PERSONAL_DATA(L_LAST_NAME,L_FIRST_NAME)

C_SOURCE = source system, we use mainly GV ( ADP Global View)
C_TYPE = type of data: Original(1) or Fixed ( 2)

ICARE BI4 application is no more used .

It is replaced by the BW HR application

TECHNO - BI TEAM > zzz ICARE (HR) > image2021-1-21_19-0-23.png

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 :