S CCI Picklist table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 10: | Line 10: | ||
|| '''CCI_Picklist_ID''' || number|| order on picklist | || '''CCI_Picklist_ID''' || number|| order on picklist | ||
|- | |- | ||
|| '''CCI_Picklist_TDI''' || text || | || '''CCI_Picklist_TDI''' || text || [[:Category:CCI Category]] | ||
|- | |- | ||
|| '''CCI_Picklist_code''' || number || [[L_CCI_Picklist table|L_CCI_Picklist]].CCI_1_ID | || '''CCI_Picklist_code''' || number || [[L_CCI_Picklist table|L_CCI_Picklist]].CCI_1_ID | ||
Revision as of 20:46, 2018 February 18
The S CCI Picklist table in CCMDB.mdb contains the possible picklist entries to use with CCI collection.
Data Structure
| field | type | description |
|---|---|---|
| CCI_Picklist_ID | number | order on picklist |
| CCI_Picklist_TDI | text | Category:CCI Category |
| CCI_Picklist_code | number | L_CCI_Picklist.CCI_1_ID |
| description | text | description of component code |
| active_start | Date/time | date/time the component code became active on laptops |
| active_end | Date/time | if filled, date/time the component code became inactive on laptops |
| wiki_url | Hyperlink | link to corresponding wiki article |