S ADLOptions table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
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]]

Revision as of 16:14, 6 February 2017

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

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 MOST score, see ADL_General_Collection_Information#Scoring