S CCI Picklist table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) Created page with "The '''{{PAGENAME}}''' in CCMDB.mdb contains some pre-set combination of CCI1, CCI2, CCI3 that make up common elements in CCI collection. See [[L CCI subform#Picklist]..." |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 1: | Line 1: | ||
The '''{{PAGENAME}}''' in [[CCMDB.mdb]] contains | The '''{{PAGENAME}}''' in [[CCMDB.mdb]] contains the possible codes to use with [[CCI collection]]. | ||
== Data Structure == | == Data Structure == | ||
| Line 8: | Line 8: | ||
!| description | !| description | ||
|- | |- | ||
|| ''' | || '''sortorder''' || number|| order on picklist | ||
|- | |- | ||
|| ''' | || '''description''' || text || description of picklist item | ||
|- | |- | ||
|| ''' | || '''CCI_1''' || number || [[L_CCI table|L_CCI]].CCI_1_ID | ||
|- | |- | ||
|| ''' | || '''CCI_2''' || number || [[L_CCI table|L_CCI]].CCI_1_ID | ||
|- | |- | ||
|| ''' | || '''CCI_3''' || number || [[L_CCI table|L_CCI]].CCI_1_ID | ||
| | |||
|} | |} | ||
Revision as of 22:58, 2017 November 25
The S CCI Picklist table in CCMDB.mdb contains the possible codes to use with CCI collection.
Data Structure
| field | type | description |
|---|---|---|
| sortorder | number | order on picklist |
| description | text | description of picklist item |
| CCI_1 | number | L_CCI.CCI_1_ID |
| CCI_2 | number | L_CCI.CCI_1_ID |
| CCI_3 | number | L_CCI.CCI_1_ID |