S ADLOptions table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) Created page with "The table S_ADLOptions populates dropdown lists used to enter ADLs in CCMDB.mdb ADL General Collection Information Columns/Fields: * "option" - value used in dropdown *..." |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| (6 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
The table S_ADLOptions populates dropdown lists used to enter ADLs in CCMDB. | {{DISPLAYTITLE:s_ADLOptions table}}The table S_ADLOptions populates dropdown lists used to enter [[ADL General Collection Information | ADLs]] in CCMDB.accdb | ||
[[ | == Data Structure == | ||
{| class="wikitable sortable" | |||
|- | |||
!| 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]] | |||
|} | |||
[[Category: Data structure]] | [[Category:ADL]] | ||
[[Category:Data structure]] | |||
Latest revision as of 11:59, 30 July 2025
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 |