| Primary Key | Field Type |
|---|---|
 ID |
uniqueidentifier |
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 SECTIONCODE |
tinyint | Default = 1 | ||
| DATEADDED |
datetime | Default = getdate() | ||
| DATECHANGED |
datetime | Default = getdate() | ||
| TS |
timestamp | |||
 TSLONG |
bigint (Computed) |  |
CONVERT(bigint, TS) | |
| SEQUENCE |
int | Default = 0 | ||
| SECTION |
nvarchar(29) (Computed) | |
CASE [SECTIONCODE] WHEN 1 THEN N'Prospect overview' WHEN 2 THEN N'Research summary' WHEN 3 THEN N'Additional prospect details' WHEN 4 THEN N'Spouse details' WHEN 5 THEN N'Giving summary' WHEN 6 THEN N'Model scores and ratings' WHEN 7 THEN N'Wealth point summary' WHEN 8 THEN N'Philanthropic sapacity' WHEN 9 THEN N'Constituencies' WHEN 10 THEN N'Interests' WHEN 11 THEN N'Constituent attributes' WHEN 12 THEN N'Educational history' WHEN 13 THEN N'Philanthropic gifts' WHEN 14 THEN N'Whos Who biographical summary' WHEN 15 THEN N'Whos Who biographical details' WHEN 16 THEN N'Real estate' WHEN 17 THEN N'Business ownership' WHEN 18 THEN N'Securities' WHEN 19 THEN N'Income' WHEN 20 THEN N'Affluence indicators' WHEN 21 THEN N'Nonprofit affiliations' WHEN 22 THEN N'Private foundations' WHEN 23 THEN N'Political donations' WHEN 24 THEN N'Other assets' WHEN 25 THEN N'Relationships' WHEN 26 THEN N'Extended network' WHEN 27 THEN N'Notes' WHEN 28 THEN N'Contact Information' WHEN 29 THEN N'Giving Summary Chart' WHEN 30 THEN N'Asset Distribution Chart' END |
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 PROSPECTRESEARCHTEMPLATEID |
uniqueidentifier | PROSPECTRESEARCHTEMPLATE.ID | ||
| ADDEDBYID |
uniqueidentifier | CHANGEAGENT.ID | ||
| CHANGEDBYID |
uniqueidentifier | CHANGEAGENT.ID |
| Index Name | Field(s) | Unique | Primary | Clustered |
|---|---|---|---|---|
 IX_PROSPECTRESEARCHTEMPLATESECTION_DATEADDED |
DATEADDED | |
||
 IX_PROSPECTRESEARCHTEMPLATESECTION_DATECHANGED |
DATECHANGED | |||
| PK_PROSPECTRESEARCHTEMPLATESECTION |
ID | |
|
|
| UIX_PROSPECTRESEARCHTEMPLATESECTION_PROSPECTRESEARCHTEMPLATEID_SECTIONCODE |
PROSPECTRESEARCHTEMPLATEID, SECTIONCODE | |
| Trigger Name | Description |
|---|---|
 TR_PROSPECTRESEARCHTEMPLATESECTION_AUDIT_UPDATE |
|
| TR_PROSPECTRESEARCHTEMPLATESECTION_AUDIT_DELETE |