REGISTRANTREGISTRATION (4.0SP17)

ID

uniqueidentifier

REGISTRANTID

uniqueidentifier

false

FK to REGISTRANT

EVENTPRICEID

uniqueidentifier

false

FK to EVENTPRICE

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

ORGANIZATIONEXCHANGERATEID

uniqueidentifier

true

The exchange rate used to convert to the organization amount.

QUANTITY

int

false

The number of units purchased.

AMOUNT

money

false

RECEIPTAMOUNT

money

false

DATEPURCHASED

datetime

true

NETCOMMUNITYPAGENAME

nvarchar(1000)

false

Name of the Blackbaud Internet Solutions page from which this registration originated if it came from NetCommunity.

NETCOMMUNITYPAGEID

int

false

ID of the Blackbaud Internet Solutions page from which this registration originated if it came from NetCommunity.

DATEADDED

datetime

false

Indicates the date this record was added.

DATECHANGED

datetime

false

Indicates the date this record was last changed.

TS

timestamp

false

Timestamp.

TSLONG

bigint (Computed)

true

Numeric representation of the timestamp.

ORGANIZATIONAMOUNT

money

false

The amount in the organization currency.

IX_REGISTRANTREGISTRATION_DATEADDED

False

False

True

IX_REGISTRANTREGISTRATION_DATECHANGED

False

False

False

IX_REGISTRANTREGISTRATION_EVENTPRICEID

False

False

False

IX_REGISTRANTREGISTRATION_ORGANIZATIONEXCHANGERATEID

False

False

False

IX_REGISTRANTREGISTRATION_REGISTRANTID

False

False

False

PK_REGISTRANTREGISTRATION

True

True

False

TR_REGISTRANTREGISTRATION_AUDIT_UPDATE

TR_REGISTRANTREGISTRATION_AUDIT_DELETE

TR_REGISTRANTREGISTRATION_INSERTUPDATE_CURRENCY

REGISTRANTREGISTRATIONMAP

REGISTRANTREGISTRATIONID