S GCS table: Difference between revisions

Revision as of 15:11, 21 April 2021

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. Is broken down into subsets by s_GCS_eye query, s_GCS_motor query and s_GCS_verbal query.

field	type	description
full_text	text	what will show in the dropdown
gcs_type	text	literal eye motor verbal
points	byte	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

@@ Line 1: / Line 1: @@
-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.
+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. Is broken down into subsets by [[s_GCS_eye query]], [[s_GCS_motor query]] and [[s_GCS_verbal query]].
-== Editing the S_Locations Table ==
-See [[Rolling out changes]]
 == Data Structure ==
-The table has three columns:
+{| class="wikitable sortable"
-* full_text - what will show in the dropdown
+|-
-* gcs_type - eye motor verbal
+!| field
-* points - number of [[Apache]] points associated with entry
+!| type
-* 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
+!| description
+|-
+|| '''full_text''' || text || what will show in the dropdown
+|-
+|| '''gcs_type ''' || text || literal eye motor verbal
+|-
+|| '''points ''' || byte || 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
+|}
+== Related articles ==
+{{Related Articles}}
 [[Category: Data structure]]