FUNCTION GetDecryptedCols(table$, encryptVals$, decryptedCols$, decryptedRec$)
|
FUNCTION GetDecryptedCols(table$, encryptVals$, decryptedCols$, decryptedRec$, maskSensitive)
Returns a comma separated column list with a REC() of the decrypted values for the table and EncryptedVals$
|
| Parameter | Description |
|---|
| table$ |
[input, string] table containing EncryptedVals$ to translate |
| encryptVals$ |
[input, string] string containing concatenated encrypted values to translate |
| decryptedCols$ |
[output, string] comma separated list of PII columns contained in encryptVals$. |
| decryptedRec$ |
[output, string] REC() of PII column values contained in encryptVals$, highly sensitive columns will be returned masked. |
| maskSensitive |
{optional} [input, boolean] when true, the value returned for highly sensitve columns will be masked regardless of the users view edit security rights |
|
| Returns |
[boolean] retSUCCESS or retFAILURE |
|
FUNCTION LOCAL CheckEncryptedCols()
Performs dirty record checking for changes to and update the EncryptedVals$ column for columns established as PII data in the dictionary.
|
| Returns |
[boolean] retSUCCESS or retFAILURE |
|
FUNCTION LOCAL ClearEncryptedCols(preWrite)
|
FUNCTION LOCAL ClearEncryptedCols()
Clears from memory values set for columns established as PII data in the dictionary, required to perform dirty record and optimistic locking checking as part of a business object Write()
|
| Parameter | Description |
|---|
| preWrite |
{optional} [input, boolean] when true identifies when this clear is part of pre-write memory clear to identify when to not clear PII encryption property values |
|
| Returns |
[boolean] retSUCCESS or retFAILURE |
|
FUNCTION LOCAL DecryptRec()
Decrypts the EncryptedVals$ column then sets their values in memory for columns established as PII data in the dictionary. Values of columns identified as highly sensitive PII columns are masked without proper role security rights.
|
| Returns |
[boolean] retSUCCESS or retFAILURE |
|
FUNCTION LOCAL EncryptRec()
|
FUNCTION LOCAL EncryptRec(table$)
|
FUNCTION LOCAL EncryptRec(table$, encryptedVals$)
|
FUNCTION LOCAL EncryptRec(table$, encryptedVals$, encryptIOL$)
Encrypts the EncryptedVals$ column using values from memory for columns established as PII data in the dictionary. Changing values of columns identified as highly sensitive PII columns requires proper role security rights.
|
| Parameter | Description |
|---|
| table$ |
{optional} [input, string] table to be encrypted. |
| encryptedVals$ |
{optional} [ouput, string] variable containing encrypted valuse for the table specified. |
| encryptIOL$ |
{optional} [ouput, string] IOL of encrypted columns |
|
| Returns |
[boolean] retSUCCESS or retFAILURE |
|
FUNCTION LOCAL GetDecryptedCols(table$, encryptVals$, decryptedCols$, decryptedRec$, maskedCols$, maskedRec$)
Returns a comma separated column list with a REC() of the decrypted values for the table and EncryptedVals$
|
| Parameter | Description |
|---|
| table$ |
[input, string] table containing EncryptedVals$ to tranlate |
| encryptVals$ |
[input, string] string containing concatenated encrypted values to translate |
| decryptedCols$ |
[output, string] comma separated list of PII columns contained in encryptVals$. |
| decryptedRec$ |
[output, string] REC() of PII column values contained in encryptVals$, highly sensitive columns will be returned masked. |
| maskedCols$ |
[output, string] comma separated list of highly sensitive PII columns contained in encryptVals$. |
| maskedRec$ |
[output, string] REC() of PII highly sensitive column values contained in encryptVals$, requires proper role security rights. |
|
| Returns |
[boolean] retSUCCESS or retFAILURE |
|
FUNCTION LOCAL GetEncryptedCols(table$, encryptedCols$, maskedCols$, maskVals$)
Returns a comma separated PII column lists from the dictionary for a table
|
| Parameter | Description |
|---|
| table$ |
[input, string] table to search the dictionary for PII encryption columns |
| encryptedCols$ |
[output, string] comma separated list of all columns established as PII data in the dictionary |
| maskedCols$ |
[output, string] comma separated list of all columns established as highly sensitive PII data in the dictionary |
| maskVals$ |
[output, string] comma separated list of masks to use when displaying columns established as highly sensitive PII data in the dictionary |
|
| Returns |
[boolean] retSUCCESS or retFAILURE |
|
FUNCTION LOCAL InitEncryptInfo()
Intializes in memory a location to cache results returned by the GetEncryptedCols() method
|
| Returns |
[boolean] retSUCCESS or retFAILURE |
|
FUNCTION LOCAL MaskColumnValue$(rawVal$, mask$)
Returns a column value masked for display and printing
|
| Parameter | Description |
|---|
| rawVal$ |
input, string] raw value to mask |
| mask$ |
[input, string] mask to use |
|
| Returns |
[string] masked column value masked |
|
FUNCTION LOCAL ResetEncryptedCols()
Resets memory to current values saved prior to performing a ClearEncryptedCols() required to perform dirty record and optimistic locking checking as part of a business object Write()
|
| Returns |
[boolean] retSUCCESS or retFAILURE |
|
