XCAH02_1.1.1

Back to C18054

Field description	Field abbreviation	Field version	Field length	Field type
Common Aggregation Hierarchy, second level grouping	XCAH02	1.1.1	8	Char

Valid entries

Code	Label
CAH01-01	medicine and dentistry
CAH02-01	nursing
CAH02-02	pharmacology, toxicology and pharmacy
CAH02-03	subjects allied to medicine not otherwise specified
CAH03-01	biosciences
CAH03-02	sport and exercise sciences
CAH04-01	psychology
CAH05-01	veterinary sciences
CAH06-01	agriculture, food and related studies
CAH07-01	physics and astronomy
CAH07-02	chemistry
CAH07-03	physical, material and forensic sciences
CAH09-01	mathematical sciences
CAH10-01	engineering
CAH10-02	technology
CAH11-01	computing
CAH12-01	geographical and environmental studies
CAH13-01	architecture, building and planning
CAH14-01	humanities and liberal arts (non-specific)
CAH15-01	sociology, social policy and anthropology
CAH15-02	economics
CAH15-03	politics
CAH15-04	health and social care
CAH16-01	law
CAH17-01	business and management
CAH18-01	communications and media
CAH19-01	English studies
CAH19-02	Celtic studies
CAH19-03	languages, linguistics and classics
CAH20-01	history and archaeology
CAH20-02	philosophy and religious studies
CAH21-01	creative arts and design
CAH22-01	education and teaching
CAH23-01	combined and general studies

Dependent fields

None

Depend upon fields

XJACS01

Additional information

The Common Aggregation Hierearchy is an aggregation methodology that can be applied to both HECOS and JACS subject coding frames in order to allow for time series analysis.

The datasets tables Cyy051_SJ (for the Student record) and Cyy054_SJ (for the AP student record) are the JACS subject by full person equivalent (FPE) tables, that hold merged subject data from the appropriate Course and CourseSubject records apportioned using the HESA 'combination splitter' methodology.

XCAH02 takes the JACS subject and derives its value based on the JACS/CAH mapping

XFPE01 apportions the subjects to a nominal FPE, according to the number of subjects submitted per Course and the weighting allocated to a Course's subjects.

Technical Specification

XCAH02	XJACS01
CAH01-01	A000, A100, A200, A300, A400, A900, A990, B820.
CAH02-01	B700, B701, B702, B710, B712, B713, B714, B720, B730, B731, B740, B741, B750, B760, B761, B770, B771, B772, B773, B790.
CAH02-02	B200, B210, B220, B230.
CAH02-03	B000, B100, B110, B120, B121, B130, B131, B132, B140, B160, B170, B190, B290, B300, B310, B320, B340, B341, B342, B343, B344, B345, B346, B352, B360, B390, B400, B410, B490, B500, B510, B520, B590, B600, B610, B620, B630, B690, B800, B810, B821, B822, B850, B890, B900, B910, B920, B930, B940, B950, B960, B990, C843, C844, H166, I510.
CAH03-01	B350, C000, C100, C110, C111, C120, C130, C131, C140, C141, C142, C150, C160, C161, C162, C170, C180, C181, C182, C183, C184, C185, C186, C187, C190, C191, C200, C210, C220, C240, C250, C260, C270, C280, C290, C300, C310, C320, C330, C340, C350, C380, C390, C400, C410, C420, C430, C431, C440, C441, C450, C451, C452, C460, C470, C490, C500, C510, C520, C521, C530, C540, C550, C570, C590, C700, C710, C720, C730, C740, C741, C750, C760, C770, C790, C900, C910, C990, D322.
CAH03-02	C600, C610, C620, C630, C640, C650, C690.
CAH04-01	C800, C810, C811, C812, C813, C814, C815, C816, C820, C821, C822, C830, C831, C832, C833, C840, C841, C842, C845, C846, C847, C848, C850, C851, C852, C853, C854, C855, C856, C857, C858, C860, C861, C862, C863, C864, C870, C871, C872, C873, C880, C881, C890.
CAH05-01	C432, C522, C742, D100, D190, D200, D210, D220, D290, D310, D330, D340, D900, D990.
CAH06-01	C360, C865, D000, D300, D320, D321, D323, D324, D325, D326, D327, D328, D390, D400, D410, D411, D412, D413, D414, D415, D416, D417, D418, D420, D421, D422, D423, D424, D425, D430, D431, D432, D433, D434, D435, D440, D441, D442, D444, D446, D447, D448, D450, D460, D461, D462, D463, D470, D471, D472, D490, D500, D510, D511, D512, D513, D514, D515, D516, D517, D520, D530, D540, D541, D590, D600, D610, D611, D612, D613, D614, D620, D630, D631, D632, D633, D634, D635, D640, D641, D642, D690, D700, D710, D711, D720, D721, D730, D740, D750, D790.
CAH07-01	F300, F310, F311, F320, F321, F330, F331, F332, F340, F341, F342, F343, F350, F351, F360, F361, F370, F380, F390, F500, F510, F520, F521, F522, F530, F540, F550, F590, H140, H141, H142, H143.
CAH07-02	F100, F110, F111, F112, F120, F130, F131, F140, F141, F150, F151, F160, F161, F162, F163, F164, F165, F170, F180, F190, J421.
CAH07-03	F000, F200, F290, F400, F410, F420, F490, F600, F610, F611, F612, F620, F621, F630, F631, F640, F641, F642, F644, F645, F646, F650, F660, F661, F670, F680, F681, F682, F690, F710, F720, F730, F731, F732, F733, F734, F761, F762, F763, F765, F900, F990.
CAH09-01	G100, G110, G120, G121, G130, G140, G150, G160, G170, G190, G200, G290, G300, G310, G311, G320, G330, G340, G350, G390, G900.
CAH10-01	B830, B840, H000, H100, H110, H120, H121, H122, H123, H130, H131, H150, H160, H161, H162, H163, H164, H165, H167, H168, H169, H190, H200, H210, H220, H221, H222, H223, H230, H231, H232, H240, H241, H242, H250, H290, H300, H310, H311, H320, H321, H330, H331, H332, H333, H340, H341, H342, H350, H360, H390, H400, H410, H411, H412, H413, H420, H430, H440, H441, H450, H460, H490, H500, H510, H511, H512, H513, H514, H520, H521, H522, H523, H524, H590, H600, H610, H611, H612, H620, H630, H631, H632, H640, H641, H642, H643, H644, H650, H651, H652, H660, H661, H662, H670, H671, H672, H674, H680, H690, H700, H710, H711, H712, H713, H714, H720, H730, H790, H800, H810, H811, H812, H820, H821, H830, H831, H840, H850, H890, H900, H990, J440, J441, J442, J443, J444, J445, J750, J940, J941, J942.
CAH10-02	C230, J000, J100, J110, J120, J130, J140, J150, J160, J190, J200, J210, J220, J221, J230, J290, J300, J320, J390, J400, J410, J411, J420, J422, J430, J431, J490, J500, J510, J511, J512, J513, J520, J521, J522, J523, J524, J530, J590, J600, J610, J611, J612, J613, J614, J690, J700, J710, J720, J730, J740, J790, J900, J910, J930, J931, J950, J960, J970, J990.
CAH11-01	I100, I110, I111, I112, I113, I114, I115, I120, I130, I140, I150, I160, I161, I190, I200, I210, I220, I230, I240, I250, I260, I270, I290, I300, I310, I320, I321, I322, I323, I390, I400, I410, I420, I430, I440, I450, I460, I461, I490, I500, I520, I530, I590, I600, I610, I620, I630, I700, I710, I900, I990.
CAH12-01	D443, F643, F700, F750, F751, F752, F753, F754, F755, F756, F760, F764, F770, F780, F790, F800, F810, F811, F840, F841, F842, F843, F844, F845, F846, F890, L700, L710, L711, L712, L713, L714, L715, L716, L720, L721, L722, L723, L724, L725, L726, L727, L728, L790.
CAH13-01	K000, K100, K110, K130, K190, K200, K210, K220, K230, K240, K250, K251, K290, K300, K310, K320, K330, K340, K341, K390, K400, K410, K420, K421, K422, K430, K440, K450, K460, K490, K900, K990, N234.
CAH14-01	V000, V900, V990.
CAH15-01	L000, L300, L310, L311, L312, L320, L321, L322, L330, L340, L350, L360, L370, L371, L380, L390, L391, L400, L410, L420, L430, L431, L432, L433, L434, L435, L436, L437, L490, L600, L610, L611, L620, L690, L800, L900, L990, M270, W357.
CAH15-02	L100, L110, L111, L112, L113, L120, L130, L140, L150, L160, L170, L171, L172, L173, L174, L190.
CAH15-03	L200, L210, L211, L212, L213, L214, L215, L216, L217, L218, L220, L221, L222, L223, L224, L230, L231, L232, L240, L241, L242, L243, L244, L250, L251, L252, L253, L260, L290.
CAH15-04	L500, L510, L520, L530, L540, L541, L560, L590.
CAH16-01	M000, M100, M110, M111, M112, M113, M114, M120, M130, M140, M190, M200, M210, M211, M220, M221, M222, M223, M224, M240, M250, M260, M290, M900, M990.
CAH17-01	N000, N100, N110, N120, N190, N200, N210, N211, N212, N213, N214, N215, N220, N223, N224, N225, N230, N231, N232, N240, N250, N251, N252, N290, N300, N310, N320, N321, N322, N323, N330, N340, N341, N390, N400, N410, N411, N412, N413, N420, N421, N422, N490, N500, N510, N520, N530, N550, N560, N561, N562, N563, N590, N600, N611, N612, N613, N614, N620, N690, N700, N710, N720, N721, N722, N790, N800, N810, N820, N830, N831, N832, N850, N851, N852, N853, N860, N861, N862, N870, N871, N872, N880, N890, N900, N990, W376.
CAH18-01	P000, P100, P110, P120, P121, P130, P131, P132, P190, P200, P210, P290, P300, P301, P302, P303, P304, P305, P310, P311, P312, P313, P390, P400, P410, P411, P412, P413, P420, P430, P490, P500, P510, P590, P900, P990.
CAH19-01	Q160, Q300, Q310, Q320, Q321, Q322, Q323, Q330, Q340, Q350, Q360, Q390, W800, W810, W820, W830, W890.
CAH19-02	Q370, Q380, Q500, Q510, Q520, Q521, Q522, Q530, Q531, Q540, Q541, Q550, Q551, Q560, Q561, Q570, Q571, Q580, Q581, Q590.
CAH19-03	Q000, Q100, Q110, Q120, Q130, Q131, Q132, Q140, Q150, Q190, Q200, Q210, Q220, Q290, Q400, Q410, Q411, Q420, Q430, Q440, Q450, Q460, Q470, Q480, Q490, Q600, Q610, Q611, Q612, Q620, Q630, Q690, Q700, Q710, Q711, Q712, Q720, Q730, Q790, Q800, Q810, Q890, Q900, Q910, Q920, Q990, R000, R100, R110, R120, R130, R190, R200, R210, R220, R230, R290, R300, R310, R320, R330, R390, R400, R410, R411, R420, R430, R490, R500, R510, R511, R520, R530, R590, R600, R610, R611, R612, R613, R614, R620, R621, R622, R623, R624, R630, R631, R632, R633, R634, R690, R700, R701, R702, R703, R704, R705, R706, R707, R708, R709, R710, R711, R712, R713, R720, R721, R722, R723, R730, R731, R732, R733, R790, R800, R900, R910, R911, R912, R920, R930, R990, T000, T100, T110, T120, T130, T190, T200, T210, T220, T230, T290, T300, T310, T311, T312, T313, T314, T315, T320, T321, T322, T323, T324, T325, T330, T331, T332, T333, T334, T335, T390, T400, T410, T411, T412, T420, T421, T422, T430, T431, T432, T490, T500, T510, T511, T512, T513, T514, T515, T520, T521, T522, T523, T524, T525, T530, T531, T532, T533, T534, T535, T590, T600, T610, T611, T612, T613, T614, T615, T616, T620, T621, T623, T624, T625, T626, T630, T631, T633, T634, T635, T636, T690, T700, T710, T711, T712, T713, T714, T720, T721, T722, T723, T724, T730, T731, T732, T733, T734, T790, T800, T810, T820, T830, T890, T900, T910, T920, T930, T990.
CAH20-01	C834, D445, V100, V140, V141, V142, V143, V144, V145, V146, V147, V148, V150, V160, V161, V190, V200, V210, V211, V212, V213, V214, V220, V221, V222, V223, V224, V225, V230, V231, V232, V233, V234, V240, V241, V242, V243, V244, V250, V251, V252, V253, V254, V255, V260, V261, V262, V270, V271, V290, V300, V310, V320, V321, V322, V323, V324, V330, V340, V350, V360, V370, V380, V381, V382, V383, V384, V390, V391, V400, V410, V420, V430, V440, V450, V460, V470, V471, V472, V490, V700, V710, V720, V730, V731, V740, V750, W160, W330, W530, W630, W631, W632.
CAH20-02	C835, V500, V510, V511, V520, V530, V540, V550, V560, V590, V600, V610, V620, V621, V622, V623, V624, V625, V626, V627, V630, V640, V641, V642, V643, V644, V645, V650, V690.
CAH21-01	B351, B353, J310, J920, K120, W000, W100, W110, W120, W130, W140, W150, W190, W200, W210, W211, W212, W213, W220, W230, W231, W240, W250, W260, W270, W280, W290, W300, W310, W311, W312, W313, W314, W315, W316, W317, W320, W340, W341, W342, W343, W344, W345, W346, W350, W351, W352, W353, W354, W355, W356, W360, W370, W371, W372, W373, W374, W375, W380, W381, W382, W383, W384, W385, W386, W387, W388, W390, W400, W410, W420, W430, W440, W441, W442, W443, W450, W451, W452, W453, W460, W461, W470, W471, W472, W473, W490, W500, W510, W520, W531, W532, W540, W541, W542, W543, W544, W550, W590, W600, W610, W611, W612, W613, W614, W615, W620, W640, W690, W700, W710, W711, W712, W713, W714, W715, W720, W721, W722, W723, W730, W731, W732, W733, W734, W740, W750, W751, W752, W753, W760, W761, W762, W770, W771, W780, W781, W782, W790, W900, W990.
CAH22-01	X000, X100, X110, X120, X121, X122, X130, X131, X132, X140, X141, X142, X150, X151, X160, X161, X162, X190, X200, X290, X300, X310, X320, X330, X340, X341, X342, X350, X360, X370, X390, X900, X990.
CAH23-01	L550, X210, X220, Y000.

Revision history

Date	Version	Notes
2019-03-07	1.1.1	New derived field to determine the Common Aggregation Hierarchy, second level grouping

Contact Liaison by email or on +44 (0)1242 388 531.