1. Administering Oracle Payroll Interface
  2. Report Prior Values

Report Prior Values

Use BLOCK_OLD mode in Payroll Interface for ADP Global Payroll to identify the employment and payment data changes. The application displays the updated data as on the effective date as the current value and the previous value of the attribute as prior value.

For example, an employee moves from the Consulting department to Development department changing their position from Consultant to Developer.

<gpi:JobDetails>
	<gpi:Position PriorValue="Consultant">Developer </gpi:position>
	<gpi:JobCode> JOB3 </gpi:JobCode>
	<gpi:Department PriorValue="Consulting">Development </gpi:Department>
	<gpi:ReportingEstablishment> Development </gpi:ReportingEstablishment>
	<gpi:WorkerCategory> White Collar </gpi:WorkerCategory>
	<gpi:WorkingHours> 40 </gpi:WorkingHours>
	<gpi:Frequency> W </gpi:Frequency>

This table summarizes the PriorValue attribute behavior to the type of change that the data element undergoes.

Scenario

Prior Value Attribute Present

Prior Value Attribute Populated

Element Populated

Sample Output

Initial Extracts

All Attributes

Run with Changes Only = N

Yes/No = No

Yes/No = No

Yes/No = Yes

Change: Initial Extract. All data reported.

<DEMO>
<PERSON NUMBER> 11111 </PERSON NUMBER>
<NAME> JACK </NAME>
<ADDRESS1> BELMONT </ADDRESS1>
<ADDRESS2> </ADDRESS2>
</DEMO>

First Snapshot

Run with Changes Only = BLOCK_OLD

An object or entity reported for the first time.

Includes New Hire and Payroll Transfer as a new entity.

Yes/No = Yes

Yes/No = Prior value will be NULL

Yes/No = Yes

Change: Available data is reported and the corresponding prior value shows NULL.

<DEMO>
<PERSON NUMBER Prior_value=""> 11111 </PERSON NUMBER>
<NAME Prior_value=""> JACK </NAME>
<ADDRESS1 Prior_value=""> </ADDRESS1>

<ADDRESS2> </ADDRESS2>
</DEMO>

Element changes from no value to a value.

Yes/No = Yes

Yes/No = Prior value will be NULL

Yes/No = Prior value will be NULL

Change: Address 2 changed from no value to a value and has a prior value NULL. The other attributes haven't changed and so they don't contain a prior value.

<DEMO>
<PERSON NUMBER> 11111 </PERSON NUMBER>
<NAME> JACK </NAME>
<ADDRESS1>BELMONT </ADDRESS1>

<ADDRESS2 Prior_value=""> </ADDRESS2>
</DEMO>

Element changes from value to no value.

Yes/No = Yes

Yes/No = Yes

Yes/No = Yes

Change: Address 2 changed from value to no value and has a prior old value. The other attributes haven't changed and so they don't contain a prior value.

<DEMO>
<PERSON NUMBER> 11111 </PERSON NUMBER>
<NAME> JACK </NAME>
<ADDRESS 1>BELMONT </ADDRESS1>

<ADDRESS2 Prior_value="Concourse"> </ADDRESS2>
</DEMO>

Element doesn't change

Yes/No = No

Yes/No = No

Yes/No = No

Change: No changes. All values are shown as they're without prior values. 

<DEMO>
<PERSON NUMBER> 11111 </PERSON NUMBER>
<NAME> JACK </NAME>
<ADDRESS1>BELMONT </ADDRESS1>
<ADDRESS2> </ADDRESS2>
</DEMO>

Element changes from one non-null value to another non-null value.

Yes/No = Yes

Yes/No = Yes

Yes/No = Yes

Change: Element changes from one non-null value to another non-null value. Address changes from Belmont to Jersey city. 

<DEMO>
<PERSON NUMBER> 11111 </PERSON NUMBER>
<NAME> JACK </NAME>
<ADDRESS1 Prior_value="Belmont">JERSEY CITY </ADDRESS1>

<ADDRESS2> </ADDRESS2>
</DEMO>