Definitions of type/classifications of personal information stored in the ca_contact table (CA-MDB).
|
Field |
Data Type |
Reference |
Remarks |
|---|---|---|---|
|
creation_date |
INTEGER |
|
Specifies the date when this record was created. |
|
creation_user |
nvarchar(64) |
|
Identifies the user or process that created this record. |
|
delete_time |
INTEGER |
|
Specifies the delete time. |
|
description |
nvarchar |
|
Specifies the textual, contact type description. |
|
exclude_ registration |
INTEGER |
|
Indicates to exclude registration. |
|
hourly_cost |
Money |
|
Specifies the hourly cost. |
|
id |
INTEGER |
|
Unique (to the table), numeric contact type ID. |
|
inactive |
INTEGER |
Active_Boolean_ |
Identifies the Active flag, as follows: |
|
last_update_date |
INTEGER |
|
Specifies the date of when this record was last updated. |
|
last_update_user |
nvarchar(64) |
|
Identifies the user or process that last updated the record. |
|
name |
nvarchar |
|
Identifies the unique,contact type name. |
|
user_uuid |
UUID |
ca_contact:: uuid |
This is a unique identifier. |
|
version_number |
INTEGER |
|
Version number for transaction integrity. |
|
view_internal |
INTEGER |
|
Flag to represent whether this contact type is allowed to view internal data. |
|
Copyright © 2013 CA.
All rights reserved.
|
|