Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Human Resources forum / HcmWorker Department M...
Human Resources forum
Answered

HcmWorker Department Manager Id

Posted on by 50

I want to Find Department Manager Id  and Manger Name RDP Query.

  • Verified answer
    WillWU Profile Picture
    WillWU 22,344 on at
    RE: HcmWorker Department Manager Id

    Hi Wasam,

    Please try the following SQL and Table relations:

    select top 1 name from DIRPARTYTABLE
    inner join HcmWorker ON HcmWorker.PERSON = DIRPARTYTABLE.RECID
    AND HcmWorker.RECID = 
    	(select top 1 worker from HCMPOSITIONWORKERASSIGNMENT  
    	INNER JOIN HCMPOSITION ON HCMPOSITIONWORKERASSIGNMENT.POSITION =  HCMPOSITION.RECID
    	AND HCMPOSITION.POSITIONID = 'manager' 
    	where GETDATE() between HCMPOSITIONWORKERASSIGNMENT.VALIDFROM AND HCMPOSITIONWORKERASSIGNMENT.VALIDTO);

  • Wasam Gohar Profile Picture
    Wasam Gohar 50 on at
    RE: HcmWorker Department Manager Id

    Manager Name

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,835 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,526 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans