DD Balance Sheet v2005b

Number of variables102
Number of records0

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
AArts, Culture, and Humanities
BEducation
CEnvironmental Quality, Protection, and Beautification
DAnimal-Related
EHealth
FMental Health, Crisis Intervention
GDiseases, Disorders, Medical Disciplines
HMedical Research
ICrime, Legal Related
JEmployment, Job Related
KFood, Agriculture, and Nutrition
LHousing, Shelter
MPublic Safety
NRecreation, Sports, Leisure, Athletics
OYouth Development
PHuman Services - Multipurpose and Other
QInternational, Foreign Affairs, and National Security
RCivil Rights, Social Action, Advocacy
SCommunity Improvement, Capacity Building
TPhilanthropy, Voluntarism, and Grantmaking Foundations
UScience and Technology Research Institutes, Services
VSocial Science Research Institutes, Services
WPublic, Society Benefit - Multipurpose and Other
XReligion Related, Spiritual Development
YMutual/Membership Benefit Organizations, Other
ZUnknown
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
44- Not a 501(c)(3)
FF- Foreign organization
GG- Government Entity
II- Coded out of scope by Independent Sector
NN- Coded out of scope by NCCS (e.g. foreign address on Form 990)
SS- Missing geographic information
TT- U.S. Territory or armed forces overseas
Classification
ntmaj5
Character
(20)
Major subsector
Major subsector (5)
ARArts, culture, and humanities
EDEducation
HEHealth
HUHuman services
OTOther
ntmaj10
Character
(20)
NTEE major group (10)
10 NTEE major groups
ARArts, culture, and humanities
EDEducation
ENEnvironment
HEHealth
HUHuman services
INInternational
MUMutual benefit
PUPublic and societal benefit
REReligion
UNUnknown
ntmaj12
Character
(20)
NTEE major group (12)
12 NTEE major groups: ntmaj10 plus higher education (BH) and hospitals (EH)
ARArts, culture, and humanities
BHEducation, higher
EDEducation
EHHospitals
ENEnvironment
HEHealth
HUHuman services
INInternational
MUMutual benefit
PUPublic and societal benefit
REReligion
UNUnknown
MAJGRPB
Character
(20)
Major NTEE group
Major NTEE group plus hospitals and higher education
AA-Arts, Culture & Humanities
BB-Education
BHBH-Higher educ.
CC-Environment
DD-Animal Related
EE-Health - General
EHEH-Hospitals
FF-Mental Health
GG-Health - Disease Specific (general)
HH-Health - Disease Specific (research)
II-Crime, Legal Related
JJ-Employment, Job Related
KK-Food, Agriculture, Nutrition
LL-Housing, Shelter
MM-Public Safety, Disaster Preparedness
NN-Recreation and Sports
OO-Youth Development
PP-Human Services, Multipurpose and Other
QQ-International, Foreign Affairs
RR-Civil Rights/Advocacy
SS-Community Improvement
TT-Philanthropy, Voluntarism
UU-Science and Technology
VV-Social Science
WW-Public, Society Benefit
XX-Religion Related
YY-Mutual/Membership Benefit
ZZ-Unknown, Unclassified
Part I: Revenue, Expenses, and Changes in Net Assets or Fund Balances
p1totexp
Numeric
(20)
Total Expenses
Total expenses
Part IV: Balance Sheets
p4b_cash
Numeric
(20)
Cash- beg. of year
Cash- beg. of year
p4e_cash
Numeric
(20)
Cash- end of year
Cash- end of year (Part 4, line 45_B)
p4b_save
Numeric
(20)
Savings- beg. of year
Savings- beg. of year
p4e_save
Numeric
(20)
Savings- end of year
Savings- end of year (Part 4, line 46_B)
p4g_arec
Numeric
(20)
Accounts receivable
Accounts receivable
p4d_arec
Numeric
(20)
Allowance for doubtful account
Allowance for doubtful accounts
p4b_arec
Numeric
(20)
Accounts receivable - doubtful
Accounts receivable - doubtful accts- beg. of year
p4e_arec
Numeric
(20)
Accounts receivable- end of ye
Accounts receivable- end of year (Part 4, line 47c_B)
p4b_prec
Numeric
(20)
Pledges receivable - doubtful
Pledges receivable - doubtful accts- beg. of year
p4d_prec
Numeric
(20)
Pledges receivable, allowance
Pledges receivable, allowance for doubtful accts
p4e_prec
Numeric
(20)
Pledges receivable- end of yea
Pledges receivable- end of year (Part 4, line 48c_B)
p4g_prec
Numeric
(20)
Pledges receivable, gross
Pledges receivable, gross
p4b_grec
Numeric
(20)
Grants receivable- beg. of yea
Grants receivable- beg. of year
p4e_grec
Numeric
(20)
Grants receivable- end of year
Grants receivable- end of year (Part 4, line 49_B)
p4b_irec
Numeric
(20)
Receivables from officers, dir
Receivables from officers, directors- beg. of year
p4e_irec
Numeric
(20)
Receivables due from offices,
Receivables due from offices, directors & trustees- end of year (Part 4, line 50_B)
p4b_lrec
Numeric
(20)
Other notes receivable less do
Other notes receivable less doubtful accts- beg. of year
p4d_lrec
Numeric
(20)
Allowance for doubtful account
Allowance for doubtful accounts
p4e_lrec
Numeric
(20)
Other notes & loans receivable
Other notes & loans receivable- end of year (Part 4, line 51c_B)
p4g_lrec
Numeric
(20)
Other notes & loans receivable
Other notes & loans receivable
P4B_INVT
Numeric
(20)
Inventories, beg. of yr.
Inventories for sale or use, beg. of year
P4E_INVT
Numeric
(20)
Inventories, end of yr.
Inventories for sale or use, end of year
p4b_pre
Numeric
(20)
Prepaid expenses & deferred ch
Prepaid expenses & deferred charges- beg. of year
p4e_pre
Numeric
(20)
Prepaid expenses- end of year
Prepaid expenses- end of year (Part 4, line 53_B)
p4b_sec
Numeric
(20)
Investments- securities- beg.
Investments- securities- beg. of year
p4e_sec
Numeric
(20)
Investments- securities- end o
Investments- securities- end of year (Part 4, line 54_B)
p4b_ilnd
Numeric
(20)
Investments- land, blg & eq mi
Investments- land, blg & eq minus accum. dep- beg. of year
p4d_ilnd
Numeric
(20)
Accumulated depreciation for l
Accumulated depreciation for land, blg & equip
p4e_ilnd
Numeric
(20)
Investments-land, buildings &
Investments-land, buildings & equipment minus accum. dep- end of year (Part 4, line 55c_B)
p4g_ilnd
Numeric
(20)
Investments- land, blg & equip
Investments- land, blg & equip: basis
p4b_iOth
Numeric
(20)
Investments- other- beg. of ye
Investments- other- beg. of year
p4e_iOth
Numeric
(20)
Investments-other- end of year
Investments-other- end of year (Part 4, line 56_B)
p4b_land
Numeric
(20)
Land, blg & equip - accum. dep
Land, blg & equip - accum. deprec.- beg. of year
p4d_land
Numeric
(20)
Accumulated depreciation of la
Accumulated depreciation of land, blg & equip
p4e_land
Numeric
(20)
Land, building & equip. minus
Land, building & equip. minus accum. deprec.- end of year (Part 4, line 57c_B)
p4g_land
Numeric
(20)
land, blg, equip: basis
land, blg, equip: basis
p4b_asst
Numeric
(20)
Total assets- beg. of year
Total assets- beg. of year
p4b_oAst
Numeric
(20)
Other assets- beg. of year
Other assets- beg. of year
p4e_asst
Numeric
(20)
Total assets- end of year
Total assets- end of year (Part 4, line 59_B)
p4e_oAst
Numeric
(20)
Other assets- end of year
Other assets- end of year (Part 4, line 58_B)
p4b_apay
Numeric
(20)
Accounts payable & accrued exp
Accounts payable & accrued expenses- beg. of year
p4e_apay
Numeric
(20)
Accounts payable- end of year
Accounts payable- end of year (Part 4, line 60_B)
p4b_gpay
Numeric
(20)
Grants payable- beg. of year
Grants payable- beg. of year
p4e_gpay
Numeric
(20)
Grants payable- end of year
Grants payable- end of year (Part 4, line 61_B)
p4b_defr
Numeric
(20)
Deferred revenue- beg. of year
Deferred revenue- beg. of year
p4e_defr
Numeric
(20)
Revenue designated for future
Revenue designated for future periods- end of year (Part 4, line 62_B)
p4b_lpay
Numeric
(20)
Loans from officers, directors
Loans from officers, directors,- beg. of year
p4e_lpay
Numeric
(20)
Loans from officers, directors
Loans from officers, directors & trustees- end of year (Part 4, line 63_B)
p4b_bond
Numeric
(20)
Tax-exempt bond liabilities- b
Tax-exempt bond liabilities- beg. of year
p4e_bond
Numeric
(20)
Tax-exempt bond liabilities- e
Tax-exempt bond liabilities- end of year (Part 4, line 64a_B)
p4b_mort
Numeric
(20)
Mortgages & other notes payabl
Mortgages & other notes payable- beg. of year
p4e_mort
Numeric
(20)
Mortgages & other notes payabl
Mortgages & other notes payable- end of year (Part 4, line 64b_B)
p4b_oLia
Numeric
(20)
Other liabilities- beg. of yea
Other liabilities- beg. of year
p4e_oLia
Numeric
(20)
Other liabilities- end of year
Other liabilities- end of year (Part 4, line 65_B)
p4b_liab
Numeric
(20)
Total liabilities- beg. of yea
Total liabilities- beg. of year
p4e_liab
Numeric
(20)
Total liabilities- end of year
Total liabilities- end of year (Part 4, line 66_B)
p4b_unre
Numeric
(20)
Unrestricted net assets or fun
Unrestricted net assets or fund balances- beg.of year
p4e_unre
Numeric
(20)
Unrestricted net assets or fun
Unrestricted net assets or fund balances- end of year (Part 4, line 67_B)
p4b_temp
Numeric
(20)
Temporarily restricted net ass
Temporarily restricted net asset- beg. of year
p4e_temp
Numeric
(20)
Temporarily restricted net ass
Temporarily restricted net assets- end of year (Part 4, line 68_B)
p4b_perm
Numeric
(20)
Permanently restricted net ass
Permanently restricted net assets- beg. of year
p4e_perm
Numeric
(20)
Permanently restricted net ass
Permanently restricted net assets- end of year (Part 4, line 69_B)
p4b_cap
Numeric
(20)
Capital stock, trust prncipl,
Capital stock, trust prncipl, or curnt fnds-beg. of year
p4e_cap
Numeric
(20)
Capital stock, trust prncipl,
Capital stock, trust prncipl, or curnt fnds-end of year (Part 4, line 70_B)
p4b_surp
Numeric
(20)
Paid-in or capital splus, or l
Paid-in or capital splus, or ld, blg & e fd- beg. of year
p4e_surp
Numeric
(20)
Paid-in or capital splus, or l
Paid-in or capital splus, or ld, blg & e fd- end of year (Part 4, line 71_B)
p4b_retn
Numeric
(20)
Retained earns, endowmts, accu
Retained earns, endowmts, accum. Income- beg. of year
p4e_retn
Numeric
(20)
Retained earns, endowmts, accu
Retained earns, endowmts, accum. Income- end of year (Part 4, line 72_B)
p4b_net
Numeric
(20)
Total fund balances or net wor
Total fund balances or net worth- beg. of year
p4e_net
Numeric
(20)
Total fund balances or net wor
Total fund balances or net worth- end of year (Part 4, line 73_B)
p4b_lint
Numeric
(20)
Total liabilities & net assets
Total liabilities & net assets/fund balances- beg. of year
p4e_lint
Numeric
(20)
Total liabilities & net assets
Total liabilities & net assets/fund balances- end of year (Part 4, line 74_B)
Other Classification
LEVEL1
Character
(20)
Public charity or priv. fndn?
Public charity or private foundation?
OOther Nonprofits
PCPublic Charity
PFPrivate Foundation
UUnknown
LEVEL2
Character
(20)
Reporting public charity group
Reporting public charity groups.
MMutual Benefit Public Charity
OOperating Public Charity
SSupporting Public Charity
level3
Character
(20)
Major NTEE category
Major NTEE category
ARArts, culture and humanities
EDEducation
ENEnvironment/animals
HEHealth
HSHuman Services
INInternational, foreign affairs
MOOther mutual benefit
MRPension and retirement funds
PBPublic, societal benefit
REReligion related
UNUnknown, unclassified
ZASingle organization support
ZBFundraising within NTEE major group
ZCPrivate grantmaking foundations
ZDPublic foundations
ZEGeneral fundraising
ZFOther Supporting Public Benefit
level4
Character
(20)
NTEE-CC Major Group
NTEE-CC Major Group
Unknown
AArts, Culture, and Humanities
BEducation
CEnvironmental Quality, Protection, and Beautification
DAnimal-Related
EHealth
FMental Health, Crisis Intervention
GDiseases, Disorders, Medical Disciplines
HMedical Research
ICrime, Legal Related
JEmployment, Job Related
KFood, Agriculture, and Nutrition
LHousing, Shelter
MPublic Safety
NRecreation, Sports, Leisure, Athletics
OYouth Development
PHuman Services - Multipurpose and Other
QInternational, Foreign Affairs, and National Security
RCivil Rights, Social Action, Advocacy
SCommunity Improvement, Capacity Building
TPhilanthropy, Voluntarism, and Grantmaking Foundations
UScience and Technology Research Institutes, Services
VSocial Science Research Institutes, Services
WPublic, Society Benefit - Multipurpose and Other
XReligion Related, Spiritual Development
YMutual/Membership Benefit Organizations, Other
ZUnknown
Miscellaneous
Latest
Character
(1)
Most recent return
Is record the most recent one received from organization? (y)
Internal Processing
FIN_ID
Character
(1)
Unique org. ID
Unique organization ID
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)
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