Skip to main content
Post a question

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Hrm_ATTAssignment

Posted on 11 Nov 2015 20:26:46 by Microsoft Employee

I have created a archive company and I need this table in the database "Hrm_ATTAssignment".  Does anyone know which module installs the HRM_ tables?

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on 12 Nov 2015 at 14:33:33
    RE: Hrm_ATTAssignment

    I found this article on the internet so I just scripted the tables out of our live environment.  They are empty anyways.

    jarekf  responded on 23 Sep 2013 5:01 PM  

    I just wanted to give an update that we've successfully converted all of our employee IDs using the Employee Modifier in PSTL.  The process ran for several hours overnight to convert over 900 employee IDs.

    For anyone else performing this in the future, we found three tables that needed to be manually converted, Hrm_Timecard, Hrm_TimecardAssignements, and Dynamics.dbo.MbfRoleUser (Constituent column).  All three were related to timecards so perhaps they were added by our Business Portal application that we use for timecards.  These tables may or may not be present in your installation.  Good luck!

  • drummerboy_10 Profile Picture
    drummerboy_10 15 on 12 Nov 2015 at 14:29:58
    RE: Hrm_ATTAssignment

    Is the archive company a backup/restore of the production company where you're removing data or are you using company data archive to move the data over?

    In the archive company is HR/HR Payroll suite turned on in the registration screen?

    Looking at the below from www.dyndeveloper.com it looks like HR or HRM/Payroll suite controls the table.   Is there some kind of setup which needs to be run in the archive company?

    2015_2D00_11_2D00_12_5F00_9_2D00_24_2D00_01.png

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on 12 Nov 2015 at 13:29:36
    RE: Hrm_ATTAssignment

    They both seem to be installed when I look in control panel and Microsoft dynamics.

  • Verified answer
    drummerboy_10 Profile Picture
    drummerboy_10 15 on 11 Nov 2015 at 20:59:56
    RE: Hrm_ATTAssignment

    Hi Larry -

    I'm assuming HRM is Human Resource Management so I would think either the Human Resources or Human Resources and Payroll Suite would install this table.   Have you tried either one of these?

    2015_2D00_11_2D00_11_5F00_15_2D00_57_2D00_53.png

    --Sean

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans