This page (revision-4) was last changed on 26-Nov-2021 10:22 by jaiken

This page was created on 26-Nov-2021 10:22 by rforbes

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
4 26-Nov-2021 10:22 1 KB jaiken to previous
3 26-Nov-2021 10:22 1 KB jaiken to previous | to last
2 26-Nov-2021 10:22 1 KB jaiken to previous | to last
1 26-Nov-2021 10:22 1 KB rforbes to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 13 changed one line
P2K_PMSEC.CHECKANDDECRYPT returns Varchar2 or
Varchar2 or Date
At line 15 removed 2 lines
P2K_PMSEC.CHECKANDDECRYPTDATE returns Date
At line 22 changed one line
{{P2K_PMSEC.CHECKANDDECRYPT(eid.government_code,eid.raw_government_code)}}
{{P2K_PMSEC.CHECKANDDECRYPT(eid.birth_date,eid.raw_birth_date)}}
At line 24 changed one line
{{P2K_PMSEC.CHECKANDDECRYPTDATE(eid.birth_date,eid.raw_birth_date)}}
This will return the birth date of the employee from the identity (EID) record, if it is encrypted or not. This function is normally used when you do not know if the data will be encrypted or not. By passing in both the clear-text and the encrypted values from the record, this function will determine if the data is encrypted and will decrypt and return it. If it is not encrypted, it will just pass through the clear-text data. This saves other code from having to figure out if encryption is being used for the column. This function has been added into provided views, Java code, and any PL/SQL code that use any of the supported columns. For example,
At line 26 removed 2 lines
This will return the government code (or birth date) of the employee from the identity (EID) record, if it is encrypted or not. This function is normally used when you do not know if the data will be encrypted or not. By passing in both the clear-text and the encrypted values from the record, this function will determine if the data is encrypted and will decrypt and return it. If it is not encrypted, it will just pass through the clear-text data. This saves other code from having to figure out if encryption is being used for the column. This function has been added into provided views, Java code, and any PL/SQL code that use any of the supported columns. For example,
At line 43 changed one line
p2k_pmsec.CheckAndDecryptDate(ect.birth_date, ect.raw_birth_date) BIRTH_DATE,
p2k_pmsec.CheckAndDecrypt(ect.birth_date, ect.raw_birth_date) BIRTH_DATE,