S ADLOptions table: Difference between revisions

Revision as of 16:14, 6 February 2017

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

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

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