EMS/Payroll Comparison

Contents

1 Overview

2 Report

3 How-to

4 Fields

Field Name

Path to data field

Table/ Field ID

Name Key

Assigned by the system and not updateable. The system assigns a new name key if an employee’s name is updated/changed: Human Resources / Profile / + Add or Edit

NAME.NALPHAKEY

Name

Human Resources / Profile / + Add or Edit

Name.Last-Name

Name.First-Name

Name.Middle-Name

Pay Code

HPMASN-ASSIGNMENTS.HPADCP-PAY-CODE

HPACON-CONTRACT.HPADCP-PAY-CODE

Work Start

HPMASN-ASSIGNMENTS.HPMASN-START-DATE

HPACON-CONTRACT.HPACON-WRK-START-DTE

Work Stop

HPMASN-ASSIGNMENTS.HPMASN-END-DATE

HPACON-CONTRACT.HPACON-WRK-STOP-DTE

Pay Start

HPMASN-ASSIGNMENTS.HPMASN-CON-START-DATE

HPACON-CONTRACT.HPACON-START-DTE

Pay Stop

HPMASN-ASSIGNMENTS.HPMASN-CON-STOP-DATE

HPACON-CONTRACT.HPACON-STOP-DTE

Pay Freq

HPMASN-ASSIGNMENTS.HPADCQ-FRQ-CODE

HPACON-CONTRACT.HPADCQ-FRQ-CODE

Override Pay Freq

HPMASN-ASSIGNMENTS.HPMASN-PAY-REC-FREQ

FTE

HPMASN-ASSIGNMENTS.HPMASN-FTE

Calc FTE

Calculated

Contract Amt

HPMASN-ASSIGNMENTS.HPMASN-CONTRACT-AMT

HPACON-CONTRACT.HPACON-AMT

Contract Diff

Calculated