Entity Column Security Regimen

DescriptionThe restriction, rule or standard that applies to a data element or attribute.

For example:
PHI
HIPAA
SOX
Competitive sensitivity

Attributes
Column Security Regimen End DateColumn Security Regimen End Date
Column Security Regimen Start DateColumn Security Regimen Start Date
Default Security IndDefault Security Ind
Security Regimen CodeSecurity Regimen Code

Relationship
Column Security Regimen_Column_FKColumn Security Regimen_Column_FK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Column Security Regimen End Date
DescriptionThe date upon which the application of a security regimen to the column ends.
Data TypeStandards - Data Domains.ddm/Data Domains/Date Time [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Column Security Regimen Start Date
DescriptionThe date upon which the application of a security regimen to the column starts.
Data TypeStandards - Data Domains.ddm/Data Domains/Date Time [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Default Security Ind
DescriptionIndicates whether or not the security regimen is the default reason for protection.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Security Regimen Code
DescriptionIndicates the reason for protection.

For example:
PHI
HIPAA
SOX
Competitive sensitivity
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Column Security Regimen_Column_FK
Is Identifying Relationshiptrue
Child TableColumn Security Regimen
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableColumn
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE