PersInt Table (73)

• 2 minutes to read
 • 2 minutes to read

PersInt MDO list item table. PersInt list table. List of Person interests.

Fields

Name Description Type Null
PersInt_id Primary key PK
name The list item String(239)
rank Rank order UShort ●
tooltip Tooltip or other description String(254) ●
deleted 0 -> record is active 1 -> record is 'deleted' and should not be shown in lists UShort ●
registered Registered when UtcDateTime
registered_associate_id Registered by whom FK associate
updated Last updated when UtcDateTime
updated_associate_id Last updated by whom FK associate
updatedCount Number of updates made to this record UShort

PersInt table relationship diagram

Indexes

Fields Types Description
PersInt_id PK Clustered, Unique
name String(239) Unique

Relationships

Table Description
associate Employees, resources and other users - except for External persons
PersIntGroupLink User group link table for PersInt, for MDO item hiding
PersIntHeadingLink Heading link table for PersInt, for MDO headers
personinterest Note: If you add or remove rows in this table, you will need to update the interestCount field in the person table accordingly. This field should always reflect the number of interest records a person has, to enable the correct setting of the interest indicator on the tab in the person dialog. Replication note: The combination of person_id and pinterest_idx is unique. If a duplicate is made on a replicated database, the system will replace the record in the target database with the one derived from the source database during replication. Therefore, do not assume that a record in this table will retain its ID indefinitely, even if the person keeps the interest.
s_link Links in messages to measure success rate of a campaign.

Replication Flags

  • Replicate changes DOWN from central to satellites and travellers.
  • Replicate changes UP from satellites and travellers back to central.
  • Copy to satellite and travel prototypes.

Security Flags

  • No access control via user's Role.