Who's On?

	Membership:
	Latest: Hitman
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5208

	People Online:
	Visitors: 343
	Members: 0
	Total: 343

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1372
Roger French	1315
mark.cook	1244

Best way to create a lookup table in IPA

5 Replies

1 Subscribed to this topic

52 Subscribed to this forum

Sort:

Author

Messages

Quarantine

Basic Member

Posts: 24

5/12/2020 2:20 AM

How do we create a lookup table in IPA? I am basically trying to store a cross reference between GHR and S3 employees for the 100 odd employees that have different values in GHR for a multitude of flows that we already developed over S3 HR.

Basically I plan to store the pfixrefvalue in a Javascript array and then refer that rather than making a landmark transaction call again and again. However I need to store both company and employee fields as an index in the array.

Any ideas. Is object array supported in IPA or map function is supported?

David Williams

Veteran Member

Posts: 1127

5/12/2020 9:37 AM

The PfiXRefValue is an excellent resource for crosswalk tables and the key is using the Source and Target references along with the old to new crosswalk values. Once built, there is a pre-built xref.lookup function in IPA to retrieve the value you want. There are a couple of different ways to execute this function so you should review the IPA user guides for this to determine how you want to use it.

John Henley

Posts: 3353

5/12/2020 10:34 AM

You can create XRef tables with multiple fields as source and/or target so doing what your attempting is not difficult. I would use multiple fields rather than trying to use an object or concatenation of the two fields.

John Henley

Posts: 3353

5/12/2020 10:38 AM

I am curious though about how you ended up with mismatched employees in S3 vs ghr? Are you going to/from a common hr company to/from multiple companies?

Quarantine

Basic Member

Posts: 24

5/13/2020 1:37 AM

Yes. From 2 companies in HR to one in GhR

Quarantine

Basic Member

Posts: 24

5/13/2020 8:49 AM

Thanks.