Column Privacy Policy DescrColumn Privacy Policy Type
| Business Data Model Data Model |
| Description | An association between a column, a permission, a business role, and a software application. The linkage between column and permission defines the column access permissions in context of a specific business role and software application. The associated permission defines the access to the column, the type of permission can be "deny" or "grant". |
| Attributes | |
| Column Privacy Policy Descr |
|
| Column Privacy Policy Type |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Column Privacy Policy Descr
| Description | The details of the data privacy policy that mask the data for a specific software application and business role. For example, a random number generator that replaces real data with random numbers can be used. For example: Age by 1 day, 1 month, and 1 year Random email address in lowercase Random number from 1 to 1,000 Random CCN with issuer identifier Random CCN with first four digits of issuer identifier Random SSN with dashes Random SSN with valid source area number Random SSN with valid source group number |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description Long [VARCHAR(1024)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Column Privacy Policy Type
| Description | The type of privacy policy that is used to mask the data in the column for a specific software application and business role, and reflects the nature of the data contained in this column. For example: Age CCN SSN |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Column / Permission / Business Role / Software Application_Business Role_FK
| Is Identifying Relationship | true |
| Child Table | Column / Permission / Business Role / Software Application |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Business Role |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Column / Permission / Business Role / Software Application_Permission_FK
| Is Identifying Relationship | true |
| Child Table | Column / Permission / Business Role / Software Application |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Permission |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Column / Permission / Business Role / Software Application_Software Application_FK
| Is Identifying Relationship | true |
| Child Table | Column / Permission / Business Role / Software Application |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Software Application |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Column / Permission / Business Role / Software Application_Column_FK
| Is Identifying Relationship | true |
| Child Table | Column / Permission / Business Role / Software Application |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Column |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Business Data Model Data Model |