| SECTOR_AZ |
nvarchar(100) |
|
Default = '' |
Sector (A-Z) |
| SECTOR_IX |
nvarchar(100) |
|
Default = '' |
Sector I-X |
| REGION |
nvarchar(100) |
|
Default = '' |
|
| SURVEYYEAR |
UDT_YEAR |
|
Default = ((0)) |
|
| ZIP |
nvarchar(100) |
|
Default = '' |
|
| YEARINIT |
UDT_YEAR |
|
Default = ((0)) |
The year in which the organizations development program was initiated. |
| SUBSECTOR |
nvarchar(100) |
|
Default = '' |
Indicates the type of organization. |
| LARGESTGIFT_1 |
money |
|
Default = 0 |
The largest gift the organization received during period 1. |
| LARGESTGIFT_2 |
money |
|
Default = 0 |
The largest gift the organization received during period 2. |
| NUMGIFTS_1 |
bigint |
|
Default = ((0)) |
The number of gifts the organization received during period 1. |
| NUMGIFTS_2 |
bigint |
|
Default = ((0)) |
The number of gifts the organization received during period 2. |
| NUMBER_NEW_INDIVIDUALS_1 |
bigint |
|
Default = ((0)) |
The number of individuals that gave a gift during period 1 that had not given before. |
| AMOUNT_NEW_INDIVIDUALS_1 |
money |
|
Default = 0 |
The total amount raised from new individuals in period 1. |
| NUMBER_NEW_INDIVIDUALS_2 |
bigint |
|
Default = ((0)) |
The number of individuals that gave a gift during period 2 that had not given before. |
| AMOUNT_NEW_INDIVIDUALS_2 |
money |
|
Default = 0 |
The total amount raised from new individuals in period 2. |
| NUMBER_RECAPTURED_INDIVIDUALS_2 |
bigint |
|
Default = ((0)) |
The number of individuals that gave a gift during period 2, that did not give a gift during period 1, but had given prior to period 1. |
| AMOUNT_RECAPTURED_INDIVIDUALS_2 |
money |
|
Default = 0 |
The total amount raised from recaptured individuals in period 2. |
| AMOUNT_UPGRADED_INDIVIDUALS_1 |
money |
|
Default = 0 |
The total amount raised from upgraded individuals in period 1. |
| NUMBER_UPGRADED_INDIVIDUALS_2 |
bigint |
|
Default = ((0)) |
The number of individuals that gave during both periods, but gave more during period 2 than in period 1. |
| AMOUNT_UPGRADED_INDIVIDUALS_2 |
money |
|
Default = 0 |
The total amount raised from upgraded individuals in period 2. |
| AMOUNT_SAME_INDIVIDUALS_1 |
money |
|
Default = 0 |
The total amount raised from individuals in period 1 that gave the same amount as they did in the previous period. |
| NUMBER_SAME_INDIVIDUALS_2 |
bigint |
|
Default = ((0)) |
The number of individuals that gave the same amount during both periods. |
| AMOUNT_SAME_INDIVIDUALS_2 |
money |
|
Default = 0 |
The total amount raised during period 2 from individuals who gave the same amount as they gave in period 1. |
| AMOUNT_DOWNGRADED_INDIVIDUALS_1 |
money |
|
Default = 0 |
The total amount raised from downgraded individuals in period 1. |
| NUMBER_DOWNGRADED_INDIVIDUALS_2 |
bigint |
|
Default = ((0)) |
The number of individuals that gave during both periods, but gave less during period 2 than in period 1. |
| AMOUNT_DOWNGRADED_INDIVIDUALS_2 |
money |
|
Default = 0 |
The total amount raised from downgraded individuals during period 2. |
| NUMBER_LAPSED_NEW_INDIVIDUALS_1 |
bigint |
|
Default = ((0)) |
The number of individuals that gave for the first time in period 1, that did not give during period 2. |
| AMOUNT_LAPSED_NEW_INDIVIDUALS_1 |
money |
|
Default = 0 |
The total amount raised during period 1 from individuals who gave for the first time during period 1, that did not give during period 2. |
| NUMBER_LAPSED_OTHER_INDIVIDUALS_1 |
bigint |
|
Default = ((0)) |
The number of individuals that gave for the before and during period 1, that did not give during period 2. |
| AMOUNT_LAPSED_OTHER_INDIVIDUALS_1 |
money |
|
Default = 0 |
The total amount raised during period 1 from individuals who gave before and during period 1, that did not give during period 2. |
| NUMBER_NEW_ORGANIZATIONS_2 |
bigint |
|
Default = ((0)) |
The number of organizations that gave a gift during period 2 that had not given before. |
| AMOUNT_NEW_ORGANIZATIONS_2 |
money |
|
Default = 0 |
The total amount raised from new organizations in period 2. |
| NUMBER_RECAPTURED_ORGANIZATIONS_2 |
bigint |
|
Default = ((0)) |
The number of organizations that gave a gift during period 2, that did not give a gift during period 1, but had given prior to period 1. |
| AMOUNT_RECAPTURED_ORGANIZATIONS_2 |
money |
|
Default = 0 |
The total amount raised from recaptured organizations in period 2. |
| AMOUNT_UPGRADED_ORGANIZATIONS_1 |
money |
|
Default = 0 |
The total amount raised from upgraded organizations in period 1. |
| NUMBER_UPGRADED_ORGANIZATIONS_2 |
bigint |
|
Default = ((0)) |
The number of organizations that gave during both periods, but gave more during period 2 than in period 1. |
| AMOUNT_UPGRADED_ORGANIZATIONS_2 |
money |
|
Default = 0 |
The total amount raised from upgraded organizations in period 2. |
| AMOUNT_SAME_ORGANIZATIONS_1 |
money |
|
Default = 0 |
The total amount raised from organizations in period 1 that gave the same amount as they did in the previous period. |
| NUMBER_SAME_ORGANIZATIONS_2 |
bigint |
|
Default = ((0)) |
The number of organizations that gave the same amount during both periods. |
| AMOUNT_SAME_ORGANIZATIONS_2 |
money |
|
Default = 0 |
The total amount raised during period 2 from organizations who gave the same amount as they gave in period 1. |
| AMOUNT_DOWNGRADED_ORGANIZATIONS_1 |
money |
|
Default = 0 |
The total amount raised from downgraded organizations in period 1. |
| NUMBER_DOWNGRADED_ORGANIZATIONS_2 |
bigint |
|
Default = ((0)) |
The number of organizations that gave during both periods, but gave less during period 2 than in period 1. |
| AMOUNT_DOWNGRADED_ORGANIZATIONS_2 |
money |
|
Default = 0 |
The total amount raised from downgraded organizations during period 2. |
| NUMBER_LAPSED_NEW_ORGANIZATIONS_1 |
bigint |
|
Default = ((0)) |
The number of organizations that gave for the first time in period 1, that did not give during period 2. |
| AMOUNT_LAPSED_NEW_ORGANIZATIONS_1 |
money |
|
Default = 0 |
The total amount raised during period 1 from organizations who gave for the first time during period 1, that did not give during period 2. |
| NUMBER_LAPSED_OTHER_ORGANIZATIONS_1 |
bigint |
|
Default = ((0)) |
The number of organizations that gave for the before and during period 1, that did not give during period 2. |
| AMOUNT_LAPSED_OTHER_ORGANIZATIONS_1 |
money |
|
Default = 0 |
The total amount raised during period 1 from organizations who gave before and during period 1, that did not give during period 2. |
| TOTAL_NUM_INDIVIDUALS_1 |
bigint (Computed) |
yes |
NUMBER_NEW_INDIVIDUALS_1 + NUMBER_LAPSED_NEW_INDIVIDUALS_1 + NUMBER_LAPSED_OTHER_INDIVIDUALS_1 + NUMBER_UPGRADED_INDIVIDUALS_2 + NUMBER_SAME_INDIVIDUALS_2 + NUMBER_DOWNGRADED_INDIVIDUALS_2 |
The total number of individuals in period 1. |
| TOTAL_AMOUNT_INDIVIDUALS_1 |
money (Computed) |
yes |
AMOUNT_NEW_INDIVIDUALS_1 + AMOUNT_UPGRADED_INDIVIDUALS_1 + AMOUNT_SAME_INDIVIDUALS_1 + AMOUNT_DOWNGRADED_INDIVIDUALS_1 + AMOUNT_LAPSED_NEW_INDIVIDUALS_1 + AMOUNT_LAPSED_OTHER_INDIVIDUALS_1 |
|
| TOTAL_NUM_INDIVIDUALS_2 |
bigint (Computed) |
yes |
NUMBER_NEW_INDIVIDUALS_2 + NUMBER_RECAPTURED_INDIVIDUALS_2 + NUMBER_UPGRADED_INDIVIDUALS_2 + NUMBER_SAME_INDIVIDUALS_2 + NUMBER_DOWNGRADED_INDIVIDUALS_2 |
The total number of individuals in period 1. |
| TOTAL_AMOUNT_INDIVIDUALS_2 |
money (Computed) |
yes |
AMOUNT_NEW_INDIVIDUALS_2 + AMOUNT_RECAPTURED_INDIVIDUALS_2 + AMOUNT_UPGRADED_INDIVIDUALS_2 + AMOUNT_SAME_INDIVIDUALS_2 + AMOUNT_DOWNGRADED_INDIVIDUALS_2 |
|
| TOTAL_NUM_ORGANIZATIONS_1 |
bigint (Computed) |
yes |
NUMBER_UPGRADED_ORGANIZATIONS_2 + NUMBER_SAME_ORGANIZATIONS_2 + NUMBER_DOWNGRADED_ORGANIZATIONS_2 + NUMBER_LAPSED_NEW_ORGANIZATIONS_1 + NUMBER_LAPSED_OTHER_ORGANIZATIONS_1 |
The total number of organizations in period 1. |
| TOTAL_AMOUNT_ORGANIZATIONS_1 |
money (Computed) |
yes |
AMOUNT_UPGRADED_ORGANIZATIONS_1 + AMOUNT_SAME_ORGANIZATIONS_1 + AMOUNT_DOWNGRADED_ORGANIZATIONS_1 + AMOUNT_LAPSED_NEW_ORGANIZATIONS_1 + AMOUNT_LAPSED_OTHER_ORGANIZATIONS_1 |
|
| TOTAL_NUM_ORGANIZATIONS_2 |
bigint (Computed) |
yes |
NUMBER_NEW_ORGANIZATIONS_2 + NUMBER_RECAPTURED_ORGANIZATIONS_2 + NUMBER_UPGRADED_ORGANIZATIONS_2 + NUMBER_SAME_ORGANIZATIONS_2 + NUMBER_DOWNGRADED_ORGANIZATIONS_2 |
The total number of organizations in period 1. |
| TOTAL_AMOUNT_ORGANIZATIONS_2 |
money (Computed) |
yes |
AMOUNT_NEW_ORGANIZATIONS_2 + AMOUNT_RECAPTURED_ORGANIZATIONS_2 + AMOUNT_UPGRADED_ORGANIZATIONS_2 + AMOUNT_SAME_ORGANIZATIONS_2 + AMOUNT_DOWNGRADED_ORGANIZATIONS_2 |
|
| GAINS_NUMBER_INDIVIDUALS_2 |
bigint (Computed) |
yes |
NUMBER_NEW_INDIVIDUALS_2 + NUMBER_RECAPTURED_INDIVIDUALS_2 |
|
| GAINS_AMOUNT_INDIVIDUALS_2 |
money (Computed) |
yes |
(AMOUNT_UPGRADED_INDIVIDUALS_2 - AMOUNT_UPGRADED_INDIVIDUALS_1) + AMOUNT_NEW_INDIVIDUALS_2 + AMOUNT_RECAPTURED_INDIVIDUALS_2 |
|
| GAINS_NUMBER_ORGANIZATIONS_2 |
bigint (Computed) |
yes |
NUMBER_NEW_ORGANIZATIONS_2 + NUMBER_RECAPTURED_ORGANIZATIONS_2 |
|
| GAINS_AMOUNT_ORGANIZATIONS_2 |
money (Computed) |
yes |
(AMOUNT_UPGRADED_ORGANIZATIONS_2 - AMOUNT_UPGRADED_ORGANIZATIONS_1) + AMOUNT_NEW_ORGANIZATIONS_2 + AMOUNT_RECAPTURED_ORGANIZATIONS_2 |
|
| LOSS_NUMBER_INDIVIDUALS_2 |
bigint (Computed) |
yes |
NUMBER_LAPSED_NEW_INDIVIDUALS_1 + NUMBER_LAPSED_OTHER_INDIVIDUALS_1 |
|
| LOSS_AMOUNT_INDIVIDUALS_2 |
money (Computed) |
yes |
(AMOUNT_DOWNGRADED_INDIVIDUALS_1 - AMOUNT_DOWNGRADED_INDIVIDUALS_2) + AMOUNT_LAPSED_NEW_INDIVIDUALS_1 + AMOUNT_LAPSED_OTHER_INDIVIDUALS_1 |
|
| LOSS_NUMBER_ORGANIZATIONS_2 |
bigint (Computed) |
yes |
NUMBER_LAPSED_NEW_ORGANIZATIONS_1 + NUMBER_LAPSED_OTHER_ORGANIZATIONS_1 |
|
| LOSS_AMOUNT_ORGANIZATIONS_2 |
money (Computed) |
yes |
(AMOUNT_DOWNGRADED_ORGANIZATIONS_1 - AMOUNT_DOWNGRADED_ORGANIZATIONS_2) + AMOUNT_LAPSED_NEW_ORGANIZATIONS_1 + AMOUNT_LAPSED_OTHER_ORGANIZATIONS_1 |
|
| NUMBER_NEW_2 |
bigint (Computed) |
yes |
NUMBER_NEW_INDIVIDUALS_2 + NUMBER_NEW_ORGANIZATIONS_2 |
|
| AMOUNT_NEW_2 |
money (Computed) |
yes |
AMOUNT_NEW_INDIVIDUALS_2 + AMOUNT_NEW_ORGANIZATIONS_2 |
|
| NUMBER_RECAPTURED_2 |
bigint (Computed) |
yes |
NUMBER_RECAPTURED_INDIVIDUALS_2 + NUMBER_RECAPTURED_ORGANIZATIONS_2 |
|
| AMOUNT_RECAPTURED_2 |
money (Computed) |
yes |
AMOUNT_RECAPTURED_INDIVIDUALS_2 + AMOUNT_RECAPTURED_ORGANIZATIONS_2 |
|
| AMOUNT_UPGRADED_1 |
money (Computed) |
yes |
AMOUNT_UPGRADED_INDIVIDUALS_1 + AMOUNT_UPGRADED_ORGANIZATIONS_1 |
|
| NUMBER_UPGRADED_2 |
bigint (Computed) |
yes |
NUMBER_UPGRADED_INDIVIDUALS_2 + NUMBER_UPGRADED_ORGANIZATIONS_2 |
|
| AMOUNT_UPGRADED_2 |
money (Computed) |
yes |
AMOUNT_UPGRADED_INDIVIDUALS_2 + AMOUNT_UPGRADED_ORGANIZATIONS_2 |
|
| AMOUNT_SAME_1 |
money (Computed) |
yes |
AMOUNT_SAME_INDIVIDUALS_1 + AMOUNT_SAME_ORGANIZATIONS_1 |
|
| NUMBER_SAME_2 |
bigint (Computed) |
yes |
NUMBER_SAME_INDIVIDUALS_2 + NUMBER_SAME_ORGANIZATIONS_2 |
|
| AMOUNT_SAME_2 |
money (Computed) |
yes |
AMOUNT_SAME_INDIVIDUALS_2 + AMOUNT_SAME_ORGANIZATIONS_2 |
|
| AMOUNT_DOWNGRADED_1 |
money (Computed) |
yes |
AMOUNT_DOWNGRADED_INDIVIDUALS_1 + AMOUNT_DOWNGRADED_ORGANIZATIONS_1 |
|
| NUMBER_DOWNGRADED_2 |
bigint (Computed) |
yes |
NUMBER_DOWNGRADED_INDIVIDUALS_2 + NUMBER_DOWNGRADED_ORGANIZATIONS_2 |
|
| AMOUNT_DOWNGRADED_2 |
money (Computed) |
yes |
AMOUNT_DOWNGRADED_INDIVIDUALS_2 + AMOUNT_DOWNGRADED_ORGANIZATIONS_2 |
|
| NUMBER_LAPSED_NEW_1 |
bigint (Computed) |
yes |
NUMBER_LAPSED_NEW_INDIVIDUALS_1 + NUMBER_LAPSED_NEW_ORGANIZATIONS_1 |
|
| AMOUNT_LAPSED_NEW_1 |
money (Computed) |
yes |
AMOUNT_LAPSED_NEW_INDIVIDUALS_1 + AMOUNT_LAPSED_NEW_ORGANIZATIONS_1 |
|
| NUMBER_LAPSED_OTHER_1 |
bigint (Computed) |
yes |
NUMBER_LAPSED_OTHER_INDIVIDUALS_1 + NUMBER_LAPSED_OTHER_ORGANIZATIONS_1 |
|
| AMOUNT_LAPSED_OTHER_1 |
money (Computed) |
yes |
AMOUNT_LAPSED_OTHER_INDIVIDUALS_1 + AMOUNT_LAPSED_OTHER_ORGANIZATIONS_1 |
|