FAFRAISEDTOTAL
Precalculated raised totals for participants and teams in FAF events
Primary Key
| Primary Key | Field Type |
|---|---|
| ID | uniqueidentifier |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| REGAMOUNT | money | Default = 0 | registration fee | |
| RECEIVEDAMOUNT | money | Default = 0 | Received credit amount | |
| UNPAIDPLEDGEAMOUNT | money | Default = 0 | Unpaid pledge amount | |
| UNPAIDRECURRINGAMOUNT | money | Default = 0 | Unpaid recurring gift amount | |
| MATCHINGGIFTCLAIMAMOUNT | money | Default = 0 | Matching gift claim amount | |
| UNCONFIRMEDOFFLINEAMOUNT | money | Default = 0 | Unconfirmed offline amount | |
| DATECHANGED | datetime | yes | Default = getdate() | The date when those amount fields are updated |
| DONORCOUNT | int | Default = 0 | Count of donors | |
| GIFTCOUNT_DONATION | int | Default = 0 | Gift count of type donation | |
| GIFTCOUNT_UNPAIDPLEDGES_ON | int | Default = 0 | Gift count of type pledge if unpaid pledge option is on | |
| GIFTCOUNT_UNPAIDPLEDGES_OFF | int | Default = 0 | Gift count of type pledge if unpaid pledge option is off | |
| GIFTCOUNT_PENDINGMATCHINGGIFTS_ON | int | Default = 0 | Gift count of type pledge if pending matching gift option is on | |
| GIFTCOUNT_PENDINGMATCHINGGIFTS_OFF | int | Default = 0 | Gift count of type pledge if pending matching gift option is off | |
| GIFTCOUNT_UNPAIDRECURRINGGIFTS_ON | int | Default = 0 | Gift count of type pledge if unpaid recurring gift option is on | |
| GIFTCOUNT_UNPAIDRECURRINGGIFTS_OFF | int | Default = 0 | Gift count of type pledge if unpaid recurring gift option is off | |
| GIFTCOUNT_UNCONFIRMEDPARTICIPANTGIFTENTRY_ON | int | Default = 0 | Gift count of type pledge if unpaid offline donation option is on | |
| GIFTCOUNT_UNCONFIRMEDPARTICIPANTGIFTENTRY_OFF | int | Default = 0 | Gift count of type pledge if unpaid offline donation option is off |
Foreign Keys
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| EVENTID | uniqueidentifier | EVENT.ID | FK to EVENT | |
| CONSTITUENTID | uniqueidentifier | yes | CONSTITUENT.LOCALID | FK to CONSTITUENT |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_FAFRAISEDTOTAL_CONSTITUENTID | CONSTITUENTID | |||
| IX_FAFRAISEDTOTAL_EVENTID_CONSTITUENTID | EVENTID, CONSTITUENTID | |||
| PK_FAFRAISEDTOTAL | ID | yes | yes | yes |