Documentation
    {{docApp.userSession.userId}}
    {{docApp.userSession.userName}}
    {{docApp.userSession.email}}
    Issuer : {{docApp.userSession.issuerInstance}}
    Expires : {{new Date(docApp.userSession.validUntil).toLocaleDateString()}}

{{docApp.title}}

{{docApp.description}}

How can we help?

{{docApp.searchError}}
{{product.name}}

Searching in {{docApp.searchFilterBySpecificBookTitle}}

{{docApp.searchResultFilteredItems.length}} results for: {{docApp.currentResultsSearchText}} in {{docApp.searchFilterBySpecificBookTitle}}
Search results have been limited. There are a total of {{docApp.searchResponse.totalResultsAvailable}} matches.

You have an odd number of " characters in your search terms - each one needs closing with a matching " character!

{{docApp.libraryHomeViewProduct.title || docApp.libraryHomeViewProduct.id}}

{{docApp.libraryHomeViewProduct.description}}

  1. {{book.title}}

{{group.title || group.id}}

{{group.description}}

  1. {{book.title}}

{{group.title}}

{{book.title}}
More...

Data Processing Record Assets

  • Article
  • 6 minutes to read

Details

Table ID: h_cmdb_assets_data_processing_record

Stores information about assets in the 'Data Processing Record' asset class

Table Attributes

Name Value
Primary Key h_pk_asset_id

Columns

Name & ID Description Column Attributes Relationships
Asset ID
h_pk_asset_id
 Unique record identifier. AutoVal: itsmAssetId keyed to h_itsm_assets.h_pk_asset_id
Type VARCHAR
Size 32
Nullable false
Primary Key true
One to One
Asset
h_cmdb_assets.h_pk_asset_id
Business function
h_business_function
 The business function
Type VARCHAR
Size 256
Nullable true
Indexed true
Business owner
h_business_owner
 The URN of the business owner
Type VARCHAR
Size 191
Nullable true
Business owner name
h_business_owner_name
 The business owner name
Type VARCHAR
Size 64
Nullable true
Indexed true
Contract ID
h_contract_id
 Contract Id for any contract in place
Type VARCHAR
Size 128
Nullable true
Indexed true
Contract location
h_contract_location
 Location of any contract in place
Type VARCHAR
Size 512
Nullable true
Indexed true
Controller email
h_controller_email
 Email address of any joint controller
Type VARCHAR
Size 64
Nullable true
Indexed true
Controller name
h_controller_name
 Name of any joint controller
Type VARCHAR
Size 128
Nullable true
Indexed true
Controller phone
h_controller_phone
 Phone number of any joint controller
Type VARCHAR
Size 32
Nullable true
Indexed true
Deletion configured
h_deletion_configured
 Whether deletion is configured
Type INTEGER
Size 11
Nullable true
Deletion type
h_deletion_type
 Automated or manual
Type INTEGER
Size 11
Nullable true
Discovery Fingerprint
h_dsc_fingerprint
 The MD5 fingerprint of the overall item
Type VARCHAR
Size 32
Nullable true
Documentation link
h_documentation_link
 Any link to existing documentation
Type VARCHAR
Size 512
Nullable true
Indexed true
Documentation status
h_documentation_status
 The documentation status
Type VARCHAR
Size 64
Nullable true
Indexed true
Ext.Custom Date 1
h_custom_ext_date1
 Extended Custom Date 1
Type DATETIME
Nullable true
Ext.Custom Date 2
h_custom_ext_date2
 Extended Custom Date 2
Type DATETIME
Nullable true
Ext.Custom Date 3
h_custom_ext_date3
 Extended Custom Date 3
Type DATETIME
Nullable true
Ext.Custom Date 4
h_custom_ext_date4
 Extended Custom Date 4
Type DATETIME
Nullable true
Ext.Custom Date 5
h_custom_ext_date5
 Extended Custom Date 5
Type DATETIME
Nullable true
Ext.Custom Date 6
h_custom_ext_date6
 Extended Custom Date 6
Type DATETIME
Nullable true
Ext.Custom Date 7
h_custom_ext_date7
 Extended Custom Date 7
Type DATETIME
Nullable true
Ext.Custom Date 8
h_custom_ext_date8
 Extended Custom Date 8
Type DATETIME
Nullable true
Ext.Custom Decimal 1
h_custom_ext_dec1
 Extended Custom Decimal 1 (0.00)
Type DECIMAL
Precision 20
Scale 2
Nullable true
Ext.Custom Decimal 2
h_custom_ext_dec2
 Extended Custom Decimal 2 (0.00)
Type DECIMAL
Precision 20
Scale 2
Nullable true
Ext.Custom Decimal 3
h_custom_ext_dec3
 Extended Custom Decimal 3 (0.00)
Type DECIMAL
Precision 20
Scale 2
Nullable true
Ext.Custom Decimal 4
h_custom_ext_dec4
 Extended Custom Decimal 4 (0.00)
Type DECIMAL
Precision 20
Scale 2
Nullable true
Ext.Custom Decimal 5
h_custom_ext_dec5
 Extended Custom Decimal 5 (0.00)
Type DECIMAL
Precision 20
Scale 2
Nullable true
Ext.Custom Decimal 6
h_custom_ext_dec6
 Extended Custom Decimal 6 (0.00)
Type DECIMAL
Precision 20
Scale 2
Nullable true
Ext.Custom Decimal 7
h_custom_ext_dec7
 Extended Custom Decimal 7 (0.00)
Type DECIMAL
Precision 20
Scale 2
Nullable true
Ext.Custom Decimal 8
h_custom_ext_dec8
 Extended Custom Decimal 8 (0.00)
Type DECIMAL
Precision 20
Scale 2
Nullable true
Ext.Custom Integer 1
h_custom_ext_int1
 Extended Custom Integer 1
Type INTEGER
Nullable true
Ext.Custom Integer 2
h_custom_ext_int2
 Extended Custom Integer 2
Type INTEGER
Nullable true
Ext.Custom Integer 3
h_custom_ext_int3
 Extended Custom Integer 3
Type INTEGER
Nullable true
Ext.Custom Integer 4
h_custom_ext_int4
 Extended Custom Integer 4
Type INTEGER
Nullable true
Ext.Custom Integer 5
h_custom_ext_int5
 Extended Custom Integer 5
Type INTEGER
Nullable true
Ext.Custom Integer 6
h_custom_ext_int6
 Extended Custom Integer 6
Type INTEGER
Nullable true
Ext.Custom Integer 7
h_custom_ext_int7
 Extended Custom Integer 7
Type INTEGER
Nullable true
Ext.Custom Integer 8
h_custom_ext_int8
 Extended Custom Integer 8
Type INTEGER
Nullable true
Ext.Custom Text 1
h_custom_ext_text1
 Extended Custom Text 1
Type LONGTEXT
Nullable true
Ext.Custom Text 2
h_custom_ext_text2
 Extended Custom Text 2
Type LONGTEXT
Nullable true
Ext.Custom Text 3
h_custom_ext_text3
 Extended Custom Text 3
Type LONGTEXT
Nullable true
Ext.Custom Text 4
h_custom_ext_text4
 Extended Custom Text 4
Type LONGTEXT
Nullable true
Ext.Custom Varchar 1
h_custom_ext_char1
 Extended Custom Varchar 1
Type VARCHAR
Size 255
Nullable true
Ext.Custom Varchar 2
h_custom_ext_char2
 Extended Custom Varchar 2
Type VARCHAR
Size 255
Nullable true
Ext.Custom Varchar 3
h_custom_ext_char3
 Extended Custom Varchar 3
Type VARCHAR
Size 255
Nullable true
Ext.Custom Varchar 4
h_custom_ext_char4
 Extended Custom Varchar 4
Type VARCHAR
Size 255
Nullable true
Ext.Custom Varchar 5
h_custom_ext_char5
 Extended Custom Varchar 5
Type VARCHAR
Size 255
Nullable true
Ext.Custom Varchar 6
h_custom_ext_char6
 Extended Custom Varchar 6
Type VARCHAR
Size 255
Nullable true
Ext.Custom Varchar 7
h_custom_ext_char7
 Extended Custom Varchar 7
Type VARCHAR
Size 255
Nullable true
Ext.Custom Varchar 8
h_custom_ext_char8
 Extended Custom Varchar 8
Type VARCHAR
Size 255
Nullable true
Individuals categories
h_individuals_categories
 Categories of individuals
Type VARCHAR
Size 512
Nullable true
Indexed true
Lawful basis
h_lawful_basis
 Article 6 lawful basis for processing personal data
Type VARCHAR
Size 128
Nullable true
Indexed true
Personal data categories
h_personal_data_categories
 Categories of personal data
Type VARCHAR
Size 512
Nullable true
Indexed true
Policy
h_policy
 Is personal data retained and deleted in accordance with policy
Type VARCHAR
Size 512
Nullable true
Indexed true
Policy exceptions
h_policy_exceptions
 Policy exceptions
Type VARCHAR
Size 512
Nullable true
Indexed true
Processing conditions
h_processing_conditions
 Reasons for not adhering to policy (if applicable)
Type VARCHAR
Size 1024
Nullable true
Recipient categories
h_recipient_categories
 Categories of recipients
Type VARCHAR
Size 512
Nullable true
Indexed true
Retention period
h_retention_period
 The retention period
Type VARCHAR
Size 32
Nullable true
Indexed true
Retention schedule
h_retention_schedule
 Retention schedule in place
Type DATETIME
Nullable true
Safeguards
h_safeguards
 Safeguards for exceptional transfers of personal data to third countries or international organisations (if applicable)
Type VARCHAR
Size 512
Nullable true
Indexed true
Schedule link
h_schedule_link
 Link to retention and deletion schedule
Type VARCHAR
Size 512
Nullable true
Indexed true
Security
h_security
 General description of technical and organisational security measures
Type VARCHAR
Size 512
Nullable true
Indexed true
Status
h_status
 Status
Type VARCHAR
Size 64
Nullable true
Indexed true
System
h_system
 System/tool used
Type VARCHAR
Size 128
Nullable true
Indexed true
Third party access
h_third_party_access
 Any allowed third party access
Type VARCHAR
Size 128
Nullable true
Indexed true
Transferred to
h_transferred_to
 Names of third countries or international organisations that personal data are transferred to (if applicable)
Type VARCHAR
Size 256
Nullable true
Indexed true
  • Version {{docApp.book.version}}
  • Node {{docApp.node}} / {{docApp.build}}
In This Document