Clarity Database and Data WareHouse Fields With Personal Data

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Which database fields can be masked or protected with the Anonymize Personally Identifable Information (PII) job for GDPR?

Environment

Release : Any

Resolution

The following schema tables and fields are subject to obfuscation. In other words, these attributes can be protected by replacing the original data with an encoded serialized number.

• CMN_AUDITS
  • value_before
  • value_after
  • raw_value_before
  • raw_value_after
• CMN_SEC_USERS
  • user_name
  • first_name
  • middle_name
  • last_name
  • email_address
  • sms_email_addresss
  • photo_file
  • full_name
  • bo_user
  • user_uid
  • favorite_photo
• NBI_PROJECT_CURRENT_FACTS
  • ae_last_name
  • ae_first_name
  • manager_last_name
  • manager_first_name
• NBI_RESOURCE_CURRENT_FACTS
  • manager_last_name
  • manager_first_name
  • resource_code
  • last_name
  • first_name
• NBI_RT_FACTS
  • resource_code
  • last_name
  • first_name
  • manager_last_name
  • manager_first_name
• NMC_CONVERSATIONS
  • resource_name
• NMC_INTEGRATIONS
  • user_name
  • proxy_user_name
• ODF_CA_RESOURCE
  • obj_bi_user_id
• PAC_MNT_PROJECTS
  • resource_code
  • approvedby_resource_code
  • awaitapprvl_resource_code
• PAC_MNT_RESOURCES
  • resource_code
  • reportsto_resource_code
• PPA_BILLING
  • resource_code
  • entry_resource_code
  • lastupdtdby_resource_code
• PPA_MATRIXVALUES
  • value1…value10
• PPA_POSTINGBATCH
  • post_resource_code
• PPA_TRANSBILL
  • resource_code
  • entry_resource_code
  • lastupdtdby_resource_code
• PPA_TRANSCONTROL
  • resource_code
  • entry_resource_code
  • lastupdtdby_resource_code
• PPA_TRANSWIPADJUST
  • resource_code
  • entry_resource_code
  • lastupdtdby_resource_code
• PPA_WIP
  • resource_code
  • entry_resource_code
  • lastupdtdby_resource_code
• PROJSTAFF
  • resource_code
• PROJREVISION
  • approvedby_resource_code
  • awaitapprvl_resource_code
  • resource_code
• SRM_CONTACTS
  • job_title
  • address1
  • address2
  • address3
  • city
  • state_province
  • country_id
  • postal_code
  • phone_home
  • phone_work
  • phone_cell
  • phone_fax
  • phone_pager
  • url
• SRM_RESOURCES
  • unique_name
  • first_name
  • middle_name
  • last_name
  • full_name
  • email
  • sms_email

Disclaimer: Broadcom is not responsible for protected data that you anonymize and later decide you want to retrieve.