Previous Topic: Act_Type TableNext Topic: Active_Boolean_Table Table


Act_Type_Assoc Table

Maps a field of an object we want to do activity logging for to an Activity Type (Assignee field on a request is mapped to 'Transfer' Act_Type. All _rsrved fields are reserved for CA and NOT FOR CLIENT USE)

Field

Data Type

Reference

Remarks

act_type

STRING 30

Act_Type::code

Associated activity type

code

STRING 12

 

UNIQUE NOT_NULL S_KEY

description

STRING 80

 

Textual description of this Act Type Association

id

INTEGER

 

Unique (to the table) Numeric ID

UNIQUE NOT_NULL KEY

int1_rsrved

INTEGER

 

Flex field

int2_rsrved

INTEGER

 

Flex field

int3_rsrved

INTEGER

 

Flex field

last_mod_by

UUID

ca_contact::uuid

Specifies the UUID of the contact who last modified this record

last_mod_dt

LOCAL_TIME

 

Indicates the timestamp of when this record was last modified

log_me_f

INTEGER

 

Logging on/off flag

ob_type

STRING 30

 

Associated object type

ob_type_attr

STRING 50

 

Attribute name within associated object

persid

STRING 30

 

Persistent ID (SystemObjectName:id)

str1_rsrved

STRING 30

 

Flex fields - reserved for CA

str2_rsrved

STRING 30

 

Flex field

str3_rsrved

STRING 30

 

Flex field

sym

STRING 30 NOT_NULL