Open topic with navigation

DATATUNEUP (4.0SP9)

The data tune-up settings are represented by this table.

Primary Key
Primary Key Field Type

ID

uniqueidentifier
Foreign Key Fields
Foreign Key Field Type Null Notes Description

ADDRESSTYPECODEID

uniqueidentifier

true

Set the former addresses to this address type.

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

INFOSOURCECODEID

uniqueidentifier

true

FK to INFOSOURCECODE

ADDRESSVALIDATION_INFOSOURCECODEID

uniqueidentifier

true

Set the information source for address validations
Fields
Field Field Type Null Notes Description

ADDRESSFORMATTINGCODE

tinyint

false

0

Address formatting to use.

DONOTABBREVIATE

bit

false

0

Do not abbreviate address elements according to USPS format.

CAPITALIZE

bit

false

0

Capitalize the entire address.

UPDATEADDRESSCODE

tinyint

false

0

Update address with forwardable moves or changes and validations.

SAVEFORMERADDRESS

bit

false

0

Save former addresses in the constituent address list when there is a forwardable move.

DATEADDED

datetime

false

getdate()

Indicates the date this record was added.

DATECHANGED

datetime

false

getdate()

Indicates the date this record was last changed.

TS

timestamp

false

Timestamp.

TSLONG

bigint (Computed)

true

Numeric representation of the timestamp.

FTPCONNECTIONCODE

tinyint

false

1

FTPCONNECTION

nvarchar(7) (Computed)

true

Indexes
Index Name Field(s) Unique Primary Clustered

IX_DATATUNEUP_DATEADDED

DATEADDED

False

False

True

IX_DATATUNEUP_DATECHANGED

DATECHANGED

False

False

False

PK_DATATUNEUP

ID

True

True

False
Triggers
Trigger Name Description

TR_DATATUNEUP_LIMIT

TR_DATATUNEUP_AUDIT_UPDATE

TR_DATATUNEUP_AUDIT_DELETE

Referenced by
Referenced by Field

ADDRESSVALIDATION

DATATUNEUPID

COAUPDATE

DATATUNEUPID

DATATUNEUPFOOTNOTEREASONMAP

ID