S ADLOptions table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m Text replacement - "CCMDB.mdb" to "CCMDB.accdb"
m Text replacement - "[[Category: " to "[[Category:"
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
The table S_ADLOptions populates dropdown lists used to enter [[ADL General Collection Information | ADLs]] in CCMDB.accdb
{{DISPLAYTITLE:s_ADLOptions table}}The table S_ADLOptions populates dropdown lists used to enter [[ADL General Collection Information | ADLs]] in CCMDB.accdb


== Data Structure ==
== Data Structure ==
Line 18: Line 18:




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