S ADLOptions table: Difference between revisions

Latest revision as of 10:59, 30 July 2025

The table S_ADLOptions populates dropdown lists used to enter ADLs in CCMDB.accdb

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

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