Files: tpollak/prgs/humanities

Non-Humanities Orgs with correct Humanities NTEE Codes (12/7/06)

In order to easily find organizations that may be coded under a humanities code in NCCS but do not belong in the humanities indicators universe, I've started entering the following phrases in the notes column.
1) May not be appropriate for humanities indicator
2) May be appropriate for humanities indicator
There are certain instances that an organization should fall into an NCCS code but does not belong in the humanities universe. For example, theology programs do belong in the A70 field but do not belong the humanities universe. This is when phrase #1 would be appropriate. For search purposes, I think it would be helpful to remain consistent with these phrases

2/12/07 Final deliverables

• What data?
  • Core files - 1989, 94, 99, '04  (use Coretrend for initial list of EINs)
  • Dig. data - (all tables, all variables (include compens.?)) - 1999 and 2003 only
• Include:

SUBSTRING(a.nteecc,1,2) in ('A7','A8')
or SUBSTRING(a.nteecc,1,3) in ('A23', 'A50','A51', 'A53', 'A54','B70','B92')
or (SUBSTRING(a.nteecc,1,3) in ('A01', 'A02', 'A03', 'A05', 'A11', 'A19', 'A26') AND (a.nteecc4d like '7%' OR a.nteecc4d like '8%'))
or (SUBSTRING(a.nteecc,1,3) in ('A11') AND (a.nteecc4d like '23%' OR a.nteecc4d like '50%' OR a.nteecc4d like '51%' OR a.nteecc like '53%' OR a.nteecc like '54%'))
or (SUBSTRING(a.nteecc,1,3) in ('B11', 'B01', 'B02', 'B03') AND (a.nteecc4d like '7%' ))
or SUBSTRING(b.nteedraft,1,2) in ('A7','A8')
or SUBSTRING(b.nteedraft,1,3) in ('A23','A50','A51','A53','A54','B70','B92')
or SUBSTRING(b.nteedraft,1,4) in ('A017', 'A018', 'A027', 'A028', 'A037', 'A038', 'A057', 'A058', 'A117', 'A118', 'A197', 'A198', 'A267')
or SUBSTRING(b.nteedraft,1,5) in ('A1123', 'A1150', 'A1151', 'A1153', 'A1154')
or SUBSTRING(b.nteedraft,1,4) in ('B117', 'B017', 'B027', 'B037')