CCMDB Wiki

CCI Data Structure: Difference between revisions

← Older edit
mNo edit summary
m Text replacement - "[[Category: " to "[[Category:"
 
(8 intermediate revisions by the same user not shown)
Line 1: Line 1:
CCI data is stored in  
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  
and can be viewed comprehensively in  
* [[Query L CCI Resolver]]
* [[query L_CCI_Combined]]


three fields as a single record in [[L_CCI_Component table]]:
See [[:Category:CCI Data Structure]] for individual articles related to the [[CCI Data Structure]].
* [[CCI_1_ID]] - first component, <number between 1-3>.<2 letters>
* [[CCI_2_ID]] - 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]].
== Related Articles ==
{{Related Articles}}


[[Query L CCI Resolver]] can be used to see the actual CCI code.


[[Category: CCI Data Structure|*]]
[[Category:CCI Data Structure| *]]
[[Category:CCI]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=CCI_Data_Structure"