
Version 4, changed by admin. 02/12/2007. Show version history
Files: tpollak/prgs/humanities
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
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')