Forums
Infor Global HR (GHR)
Field Encryption
Author
Messages
Sameera
Advanced Member
Posts: 30
2/18/2014 5:26 AM
Is there a way to enable/ disable encryption for a selected field in ITM.
Also how can we read the fields like EMPLOYEEIDENTIFICATIONNUMBER from DB (looks like its encrypted)
Thanks
Sameera
Woozy
Veteran Member
Posts: 709
2/18/2014 4:03 PM
Hi Sameera - that field is encrypted, and I don't believe there is a way to disable encryption or to read it using SQL. The same is true of the EmployeeAlternateIdentificationNumber business class (DB table "EmpAltIdentNbr")
There are basically two options that I have found - either use IPA to look up the values, or use the command line "dataexport" utility to dump the data as xml and then parse the values as required (which is a pain in the rear). You would need a good understanding of xml, xslt, and xsd, as well as the appropriate toolsets to make this work.
Good Luck.
Sameera
Advanced Member
Posts: 30
2/20/2014 11:45 AM
Hi Kelly
Thanks a lot for the support.
Thanks
Sameera