Mapping column from different schema, table

[valatharv]

I have User entity which is mapped to users table and this users table use SchemaA (using DatasourceA).

We need to map User entity to a column say Department which is in Schema B.

Please suggest best approach.

desc users
Name                           Type                                                                                                                                                                                         
----                           ----
HJID                           NUMBER(19)                                                                                                                                                                                   
EMAIL                          VARCHAR2(255 CHAR)                                                                                                                                                                           
FIRSTNAME                      VARCHAR2(255 CHAR)                                                                                                                                                                           
LASTNAME                       VARCHAR2(255 CHAR)                                                                                                                                                                           
DEPARTMENT                     VARCHAR2(255 CHAR) // THIS SHOULD BE FROM SCHEMA B