S GCS table

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