CCI Data Structure: Difference between revisions
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 4: | Line 4: | ||
and can be viewed comprehensively in | and can be viewed comprehensively in | ||
* [[Query L CCI Resolver]] | * [[Query L CCI Resolver]] | ||
three fields as a single record in [[L_CCI_Component table]]: | |||
* [[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]]. | |||
[[Query L CCI Resolver]] can be used to see the actual CCI code. | |||
[[Category: CCI Data Structure|*]] | [[Category: CCI Data Structure|*]] | ||