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
