S ADLOptions table: Difference between revisions

← Older edit

@@ 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]]