tenant-preference.md

Tenant Preference

dataSecurityPolicysunbird.tenant_preference_v2 [PRIMARY KEY (orgid, key)]

Table used to store Tenant preference information

Column Name	Data Type	Description	Sample Data
orgid	text	organisation identifier whose preference details are stored	default
key	text	preference key id	dataSecurityPolicy/certList/selfdeclarations/userPrivateFields ....
createdby	text	Record created By	fbe926ac-a395-40e4-a65b-9b4f711d7642
createdon	timestamp	Record created On	2023-04-26 09:37:31.315000+0000
data	text	Preference details	{"level":"PLAIN_DATASET","dataEncrypted":"No","comments":"Data is not encrypted","job":{"progress-exhaust":{"level":"PUBLIC_KEY_ENCRYPTED_DATASET","dataEncrypted":"No","comments":"Password protected file."},"response-exhaust":{"level":"TEXT_KEY_ENCRYPTED_DATASET","dataEncrypted":"No","comments":"Password protected file."},"userinfo-exhaust":{"level":"PASSWORD_PROTECTED_DATASET","dataEncrypted":"Yes","comments":"Password protected file."},"program-user-exhaust":{"level":"PLAIN_DATASET","dataEncrypted":"No","comments":"Data is not encrypted"}},"securityLevels":{"PLAIN_DATASET":"Data is present in plain text/zip. Generally applicable to open datasets.","PASSWORD_PROTECTED_DATASET":"Password protected zip file. Generally applicable to non PII data sets but can contain sensitive information which may not be considered open.","TEXT_KEY_ENCRYPTED_DATASET":"Data encrypted with a user provided encryption key. Generally applicable to non PII data but can contain sensitive information which may not be considered open.","PUBLIC_KEY_ENCRYPTED_DATASET":"Data encrypted via an org provided public/private key. Generally applicable to all PII data exhaust."}}
updatedby	text	Record updated By	fbe926ac-a395-40e4-a65b-9b4f711d7642
updatedon	timestamp	Record updated On	2023-06-27 08:44:54.019000+0000