S GCS table

From CCMDB Wiki
Revision as of 11:53, 30 December 2013 by Ttenbergen (talk | contribs) (Created page with "The '''s_GCS''' table contains the allowed drop-downs for the Glasgow Coma Scale fields and information to use these in Apache scoring and data management. == Editing...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

The s_GCS table contains the allowed drop-downs for the Glasgow Coma Scale fields and information to use these in Apache scoring and data management.

Editing the S_Locations Table

See Rolling out changes

Data Structure

The table has three columns:

  • full_text - what will show in the dropdown
  • gcs_type - eye motor verbal
  • points - number of Apache points associated with entry
  • reconvert - boolean, if yes then record can be used to reconvert scores to entries; this is to exclude with ventilated verbal entries that would have same score as non-ventilated