| NAME |
nvarchar(150) |
|
Default = '' |
Name of the FEP process |
| DATELASTRUN |
datetime |
yes |
|
Stores the date of the last time this process was run. |
| DESCRIPTION |
nvarchar(250) |
|
Default = '' |
Description of the FEP process |
| ORGANIZATIONNAME |
nvarchar(50) |
|
Default = '' |
The name of the organization |
| POSTCODE |
nvarchar(12) |
|
Default = '' |
The zip code for the organization |
| IDNUMBER |
nvarchar(15) |
|
Default = '' |
Identification number for the organization with AFP |
| CONTACTNAME |
nvarchar(50) |
|
Default = '' |
The name of the primary person for the FEP process |
| CONTACTEMAIL |
UDT_EMAILADDRESS |
|
Default = '' |
The primary contact's email address |
| CONTACTPHONE |
nvarchar(20) |
|
Default = '' |
The primary contact's phone number |
| AFP |
bit |
|
Default = 0 |
Indicates if the organization is affiliated with the Association of Fundraising Professionals |
| CASE |
bit |
|
Default = 0 |
Indicates if the organization is affiliated with the Council for Advancement and Support of Education |
| AHP |
bit |
|
Default = 0 |
Indicates if the organization is affiliated with the Association for Healthcare Philanthropy |
| ALDE |
bit |
|
Default = 0 |
Indicates if the organization is affiliated with the Association of Lutheran Development Executives |
| NCPG |
bit |
|
Default = 0 |
Indicates if the organization is affiliated with the National Committee on Planned Giving |
| CRD |
bit |
|
Default = 0 |
Indicates if the organization is affiliated with the Council for Resource Development |
| OTHER |
bit |
|
Default = 0 |
Indicates if the organization is affiliated with another Organizational or Professional association or committee |
| OTHERAFFILIATION |
nvarchar(50) |
|
Default = '' |
One or more organizational or professional staff affiliations not listed |
| INITIALYEAR |
UDT_YEAR |
|
Default = ((0)) |
The year the organization's development program was initiated |
| SUBSECTORCODE |
tinyint |
|
Default = 0 |
Subsector or type of organization |
| SUBSECTOR |
nvarchar(53) (Computed) |
yes |
CASE [SUBSECTORCODE] WHEN 0 THEN N'Arts, Culture and Humanities' WHEN 1 THEN N'Education' WHEN 2 THEN N'Environment' WHEN 3 THEN N'Animal-Related' WHEN 4 THEN N'Health Care' WHEN 5 THEN N'Mental Health and Crisis Intervention' WHEN 6 THEN N'Voluntary Health Associations and Medical Disciplines' WHEN 7 THEN N'Medical Research' WHEN 8 THEN N'Crime and Legal-Related' WHEN 9 THEN N'Employment' WHEN 10 THEN N'Food, Agriculture and Nutrition' WHEN 11 THEN N'Housing and Shelter' WHEN 12 THEN N'Public Safety, Disaster Preparedness and Relief' WHEN 13 THEN N'Recreation and Sports' WHEN 14 THEN N'Youth Development' WHEN 15 THEN N'Human Services' WHEN 16 THEN N'International, Foreign Affairs and National Security' WHEN 17 THEN N'Civil Rights, Social Action and Advocacy' WHEN 18 THEN N'Community Improvement and Capacity Building' WHEN 19 THEN N'Philanthropy, Voluntarism and Grantmaking Foundations' WHEN 20 THEN N'Science and Technology' WHEN 21 THEN N'Social Science' WHEN 22 THEN N'Public and Societal Benefit' WHEN 23 THEN N'Religion-Related' WHEN 24 THEN N'Mutual and Membership Benefit' WHEN 25 THEN N'Unknown (Other)' END |
Provides a translation for the 'SUBSECTORCODE' field. |
| FUNDRAISINGEXPENSES |
money |
|
Default = 0 |
Amount of expenses associated with fundraising for the periods being submitted |
| FTEPROFESSIONAL |
decimal(20, 4) |
|
Default = 0 |
Number of full-time professional staff |
| FTESUPPORT |
decimal(20, 4) |
|
Default = 0 |
Number of full-time support staff |
| FTECONSULTANT |
decimal(20, 4) |
|
Default = 0 |
Number of full-time consultants |
| FTEVOLUNTEER |
decimal(20, 4) |
|
Default = 0 |
Number of full-time volunteer fundraisers |
| COMMENTS |
nvarchar(250) |
|
Default = '' |
Comments to be included with the submission |
| 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. |