CCI Data Structure: Difference between revisions

Revision as of 23:05, 6 February 2018

CCI data is stored in

and can be viewed comprehensively in

@@ Line 1: / Line 1: @@
 CCI data is stored in
-* [[L CCI Component table]]
+* [[L_CCI_Component table]] which draws from
-* [[L CCI Picklist table]]
+** [[S_CCI_1 table]]
+** [[S_CCI_2 table]]
+* [[L CCI Picklist table]] which draws from
+** [[S CCI Picklist table]]
 and can be viewed comprehensively in
 * [[Query L CCI Resolver]]
-Two fields as a single record in [[L_CCI_Component table]]:
-* [[CCI_1_Code]] - first component, <number between 1-8>.<2 letters>
-* [[CCI_2_Code]] - second component, <2 numbers><optionally more letters>
-For each of those fields, a user of the data on the front end will see a description of the meaning of the chosen code. If the dropdown field is activated, the CCI Code component is seen as well. The actual data stored is a long integer unique ID that resolves to the corresponding [[s_CCI_1 table]], [[s_CCI_2 table]].
-[[Query L CCI Resolver]] can be used to see the actual CCI code.
 [[Category: CCI Data Structure|*]]