S ADLOptions table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) m Text replacement - "CCMDB.mdb" to "CCMDB.accdb" |
||
| Line 1: | Line 1: | ||
The table S_ADLOptions populates dropdown lists used to enter [[ADL General Collection Information | ADLs]] in CCMDB. | The table S_ADLOptions populates dropdown lists used to enter [[ADL General Collection Information | ADLs]] in CCMDB.accdb | ||
== Data Structure == | == Data Structure == | ||
Revision as of 11:02, 22 September 2019
The table S_ADLOptions populates dropdown lists used to enter ADLs in CCMDB.accdb
Data Structure
| field | type | description |
|---|---|---|
| option | text(16) | option shown in dropdown |
| sorter | single | used to sort options in dropdown, would default to alphabetical |
| ADL_Score | integer | ADL score, see ADL_General_Collection_Information#Scoring |
| MOST_Score | integer | ALERT Scale component score, see ADL_General_Collection_Information#Scoring |