PROSPECTRESEARCHTEMPLATESECTION
Contains Sections selected for a Prospect Research report template.
Primary Key
| Primary Key |
Field Type |
| ID |
uniqueidentifier |
Fields
| Field |
Field Type |
Null |
Notes |
Description |
| SECTIONCODE |
tinyint |
|
Default = 1 |
1=Prospect overview, 2=Research summary, 3=Additional prospect details, 4=Spouse details, 5=Giving summary, 6=Modeling and propensity ratings, 7=Wealth point summary, 8=Philanthropic sapacity, 9=Constituencies, 10=Interests, 11=Constituent attributes, 12=Educational history, 13=Philanthropic gifts, 14=Whos Who biographical summary, 15=Whos Who biographical details, 16=Real estate, 17=Business ownership, 18=Securities, 19=Income, 20=Affluence indicators, 21=Nonprofit affiliations, 22=Private foundations, 23=Political donations, 24=Other assets, 25=Relationships, 26=Extended network |
| DATEADDED |
datetime |
|
Default = getdate() |
Indicates the date this record was added. |
| DATECHANGED |
datetime |
|
Default = getdate() |
Indicates the date this record was last changed. |
| TS |
timestamp |
|
|
Timestamp. |
| TSLONG |
bigint (Computed) |
yes |
CONVERT(bigint, TS) |
Numeric representation of the timestamp. |
| SEQUENCE |
int |
|
Default = 0 |
|
| SECTION |
nvarchar(31) (Computed) |
yes |
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 (collapsed)' 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' WHEN 31 THEN N'Philanthropic gifts (expanded)' END |
|
Foreign Keys
Indexes
| Index Name |
Fields |
Unique |
Primary |
Clustered |
| IX_PROSPECTRESEARCHTEMPLATESECTION_DATEADDED |
DATEADDED |
|
|
yes |
| IX_PROSPECTRESEARCHTEMPLATESECTION_DATECHANGED |
DATECHANGED |
|
|
|
| PK_PROSPECTRESEARCHTEMPLATESECTION |
ID |
yes |
yes |
|
| UIX_PROSPECTRESEARCHTEMPLATESECTION_PROSPECTRESEARCHTEMPLATEID_SECTIONCODE |
PROSPECTRESEARCHTEMPLATEID, SECTIONCODE |
yes |
|
|
Triggers