DD Schedule A Employees v2005b

Number of variables	32
Number of records	607989

Field Name
Field Type

Description and Values

Basic Info

EIN
Character
(9)

Employer Identification Number
Employer identification number.

NCCSKEY
Character
(20)

Unique key: ein + return date
Unique key: ein + return date

FisYr
Character
(4)

Fiscal year
Fiscal year (ending year)

NAME
Character
(60)

Name of organization
Organization name.

STATE
Character
(2)

State
Two-letter state abbreviation.

NTEE1
Character
(2)

NTEE major group
NTEE major group (A-Z)

	Unknown
A	Arts, Culture, and Humanities
B	Education
C	Environmental Quality, Protection, and Beautification
D	Animal-Related
E	Health
F	Mental Health, Crisis Intervention
G	Diseases, Disorders, Medical Disciplines
H	Medical Research
I	Crime, Legal Related
J	Employment, Job Related
K	Food, Agriculture, and Nutrition
L	Housing, Shelter
M	Public Safety
N	Recreation, Sports, Leisure, Athletics
O	Youth Development
P	Human Services - Multipurpose and Other
Q	International, Foreign Affairs, and National Security
R	Civil Rights, Social Action, Advocacy
S	Community Improvement, Capacity Building
T	Philanthropy, Voluntarism, and Grantmaking Foundations
U	Science and Technology Research Institutes, Services
V	Social Science Research Institutes, Services
W	Public, Society Benefit - Multipurpose and Other
X	Religion Related, Spiritual Development
Y	Mutual/Membership Benefit Organizations, Other
Z	Unknown

NTEECC
Character
(4)

NTEECC primary purpose
NTEECC classification

zip5
Character
(5)

Zip code, 5 digits
First 5 digits of zip code

FIPS
Character
(5)

State + County FIPS code
2-digit State + 3-digit County FIPS code (Federal Information Processing Standard). See also U.S. Census Bureau State & County QuickFacts.

MSA_NECH
Character
(9)

Metropolitan Statistical Area
Metropolitan Statistical Area (NCCS file) (list)

PMSA
Character
(4)

Primary MSA
Primary Metropolitan Statistical Area - the component areas that comprise a CMSA (76 PMSAs as of 1995). (list)

outnccs
Character
(20)

Out of Scope flag
Out-of-scope (IN/OUT) (see OUTREAS doc. for details)

OUTREAS
Character
(20)

Reason why out of scope
Reason why out of scope

	No value
4	4- Not a 501(c)(3)
F	F- Foreign organization
G	G- Government Entity
I	I- Coded out of scope by Independent Sector
N	N- Coded out of scope by NCCS (e.g. foreign address on Form 990)
S	S- Missing geographic information
T	T- U.S. Territory or armed forces overseas

Part I: Revenue, Expenses, and Changes in Net Assets or Fund Balances

p1totexp
Numeric
(20)

Total Expenses
Total expenses

Schedule A, Part I: Compensation of Five Highest Paid Employees ...

a1expac
Numeric
(20)

Expense account & other allow.
Expense account & other allowances

a1cont
Numeric
(20)

Contribs to employee ben.plans
Contributions to employee benefit plans

a1name
Character
(20)

Name of 5 highest paid emps.
Name of 5 highest paid employees

a1numemp
Numeric
(20)

Num of employees paid > $50k
Number of employees paid over $50,000

a1ttl
Character
(20)

Title & average hr/wk
Title & average hr/wk devoted to position

a1comp
Numeric
(20)

Compensation
Compensation

Other Classification

LEVEL1
Character
(20)

Public charity or priv. fndn?
Public charity or private foundation?

O	Other Nonprofits
PC	Public Charity
PF	Private Foundation
U	Unknown

LEVEL2
Character
(20)

Reporting public charity group
Reporting public charity groups.

M	Mutual Benefit Public Charity
O	Operating Public Charity
S	Supporting Public Charity

level3
Character
(20)

Major NTEE category
Major NTEE category

AR	Arts, culture and humanities
ED	Education
EN	Environment/animals
HE	Health
HS	Human Services
IN	International, foreign affairs
MO	Other mutual benefit
MR	Pension and retirement funds
PB	Public, societal benefit
RE	Religion related
UN	Unknown, unclassified
ZA	Single organization support
ZB	Fundraising within NTEE major group
ZC	Private grantmaking foundations
ZD	Public foundations
ZE	General fundraising
ZF	Other Supporting Public Benefit

level4
Character
(20)

NTEE-CC Major Group
NTEE-CC Major Group

	Unknown
A	Arts, Culture, and Humanities
B	Education
C	Environmental Quality, Protection, and Beautification
D	Animal-Related
E	Health
F	Mental Health, Crisis Intervention
G	Diseases, Disorders, Medical Disciplines
H	Medical Research
I	Crime, Legal Related
J	Employment, Job Related
K	Food, Agriculture, and Nutrition
L	Housing, Shelter
M	Public Safety
N	Recreation, Sports, Leisure, Athletics
O	Youth Development
P	Human Services - Multipurpose and Other
Q	International, Foreign Affairs, and National Security
R	Civil Rights, Social Action, Advocacy
S	Community Improvement, Capacity Building
T	Philanthropy, Voluntarism, and Grantmaking Foundations
U	Science and Technology Research Institutes, Services
V	Social Science Research Institutes, Services
W	Public, Society Benefit - Multipurpose and Other
X	Religion Related, Spiritual Development
Y	Mutual/Membership Benefit Organizations, Other
Z	Unknown

Miscellaneous

Latest
Character
(1)

Most recent return
Is record the most recent one received from organization? (y)

LAST_MOD
Character
(20)

Date last modif. 2
Date last modified (var 2)

GRREC_SM
Character
(2)

Gross receipts < $25k flag
Gross receipts < $25k flag (Y/N)

SCHDA_ID
Character
(20)

Schedule A ID
Schedule A ID

Internal Processing

SET_
Character
(20)

Source data set
Source data set

formtype
Character
(20)

990 or ez? (9/z)
990 or ez? (9/z)

NCCSKEY2
Character
(14)

Unique key: ein + fiscal year
Unique key: ein + fiscal year

Miscellaneous

RandNum
Numeric
(14)

Random number between 0 and 1
Random number between 0 and 1 used for creating samples