S ADLOptions table: Difference between revisions

m no more TMSX
m m
Line 1: Line 1:
The table S_ADLOptions populates dropdown lists used to enter ADLs in CCMDB.mdb
The table S_ADLOptions populates dropdown lists used to enter [[ADL General Collection Information | ADLs]] in CCMDB.mdb


[[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|| [[MOST]] 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: ADL]]
[[Category: Data structure]]
[[Category: Data structure]]