Dynamics GP - HR Tables

UPR00100 - Payroll Employee Master
UPR10301 - Transaction Entry Batch
UPR10302 - Transaction Entry Line
UPR10204 - Deduction Work (After Calculate, Before Post)
UPR10205 - Benefit Work (After Calculate, Before Post)

UPR30300 -
UPR40200 - Payroll Number Setup
UPR40300 - Payroll Department Master
UPR40301 - Payroll Position Setup
UPR40600 – Payroll TimeCode Master
UPR41700 - Payroll Supervisor Setup
UPR40800 - Benefit Setup
UPR40900 - Deduction Setup

UPR41200 - Payroll Class Setup

HR2NOT01 - HR Notes

Hrm_VacationRequest Table –DocumentStatus field

DocumentStatus = 1 means the request has been submitted and/or rejected.

DocumentStatus = 2 means the request has been approved.

DocumentStatus = 3 means the request has been aborted (likely due to it being rejected).

Who is leave assigned to (i.e. based on the Workflow Business Process where is it currently): DYNAMICS database – Hrm_WorkflowDocument Table

HR does not track the date the leave applications were created.
A trigger has to be created for that purpose.

HR does not track if a request has been rejected.
The information is stored in workflow tables here. I have attempted to use these tables, but the functionality is limited.


select* from MbfWorkItemProcess
select* from Hrm_WorkflowProcess
select* from Hrm_ActivityHostProcess
select* from dbo.MbfRunningProcess
select* from MbfProcessAlias
select* from mbfworkfloweventlog
select* from MbfWorkItem
select* from MbfWorkItemProcess
select* from MbfSystemWorkitem
select* from MbfSystemWorkItemNonStateAction
select* from MbfProviderWorkItemAction
select* from MbfClientWorkItemAction
select* from MbfProcessAlias

RV010121 - HR>Employee>Review Header
RV010221 - HR>Employee>Review Detail
TATM1030 - Employee Vacation Used / Remaining

Other HR/ Time & Attendance tables begin with TA

All BP tables begin with HRM

Hrm_Timecard – Timecard header
Hrm_TimecardDetail – Timecard daily details
Hrm_VacationRequest – Vacation request details


Employmenttype Values (UPR00100)
1 = Full Time Regular
2 = Full Time Temp
3 = Part Time Regular
4 = Part Time Temp
5 = Intern
6 = Other