Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(150)   Default = '' Name of the FEP process
 DATELASTRUN datetime 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) 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) CONVERT(bigint, TS) Numeric representation of the timestamp.

Foreign Key Field Type Null Notes Description
 SITEID uniqueidentifier SITE.ID Foreign key to site table
 COUNTRYID uniqueidentifier COUNTRY.LOCALID FK to COUNTRY
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_FEPPROCESS_DATEADDED DATEADDED    
 IX_FEPPROCESS_DATECHANGED DATECHANGED      
 PK_FEPPROCESS ID  
 UC_FEPPROCESS_NAME NAME    
 UIX_FEPPROCESS_SITEID SITEID    

Trigger Name Description
 TR_FEPPROCESS_AUDIT_UPDATE
 TR_FEPPROCESS_AUDIT_DELETE

Referenced by Field
 FEPSUBMITPROCESS FEPPROCESSID

Entity-Relationship diagram of this table