Open topic with navigation

DATATUNEUPFOOTNOTEREASONMAP (4.0SP20)

Defines a mapping from COA DPV footnote codes to do not mail reason codes.

Primary Key
Primary Key Field Type

ID

uniqueidentifier
Foreign Key Fields
Foreign Key Field Type Null Notes Description

FOOTNOTECODE1REASONCODEID

uniqueidentifier

true

The do not mail reason that forwardable moves should be marked with.

FOOTNOTECODE2REASONCODEID

uniqueidentifier

true

The do not mail reason that moves with no forwardable addresses should be marked with.

FOOTNOTECODE3REASONCODEID

uniqueidentifier

true

The do not mail reason that PO box closings should be marked with.

FOOTNOTECODE4REASONCODEID

uniqueidentifier

true

The do not mail reason that moves to foreign addresses should be marked with.

FOOTNOTECODE5REASONCODEID

uniqueidentifier

true

The do not mail reason that moves without verifiable second addresses should be marked with.

FOOTNOTECODE6REASONCODEID

uniqueidentifier

true

The do not mail reason that moves to addresses without USPS records should be marked with.

FOOTNOTECODE7REASONCODEID

uniqueidentifier

true

The do not mail reason that temporary addresses that have lapsed should be marked with.

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.
Fields
Field Field Type Null Notes Description

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.
Indexes
Index Name Field(s) Unique Primary Clustered

IX_DATATUNEUPFOOTNOTEREASONMAP_DATEADDED

DATEADDED

False

False

True

IX_DATATUNEUPFOOTNOTEREASONMAP_DATECHANGED

DATECHANGED

False

False

False

PK_DATATUNEUPFOOTNOTEREASONMAP

ID

True

True

False
Triggers
Trigger Name Description

TR_DATATUNEUPFOOTNOTEREASONMAP_AUDIT_UPDATE

TR_DATATUNEUPFOOTNOTEREASONMAP_AUDIT_DELETE