S ADLOptions table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m no more TMSX
m Text replacement - "[[Category: " to "[[Category:"
 
(5 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.mdb
{{DISPLAYTITLE:s_ADLOptions table}}The table S_ADLOptions populates dropdown lists used to enter [[ADL General Collection Information | ADLs]] in CCMDB.accdb


[[ADL General Collection Information]]
== 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]]
|}


Columns/Fields:
* "option" - value used in dropdown
* "sorter" - column to sort dropdown
* "ADL_Score" - ADL score used by [[CFE]] (actually not sure where that one is used now, muight be part of the calculator in CFE that Julie uses)
* "MOST_Score" - ADL score used by [[MOST]]


[[Category: Data structure]]
[[Category:ADL]]
[[Category:Data structure]]

Latest revision as of 10: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