Schema reference / Tables / view MDX source
cgas
Children's Global Assessment Scale (CGAS) to score a subject's most impaired level of emotional and behavioural functioning in a specified period of time.
Children's Global Assessment Scale (CGAS) to score a subject's most impaired level of emotional and behavioural functioning in a specified period of time.
Purpose. To score a child's most impaired level of emotional and behavioural functioning in the specified period of time.
Source
| Model | Leg | Role |
|---|---|---|
openEHR-EHR-OBSERVATION.cgas.v1 | openEHR | defines this table |
Columns
| Column | Type | Null | Description | Source |
|---|---|---|---|---|
id | uuid primary key | no | Primary key. | — |
form_id | uuid → form | no | The form this entry was recorded on. | — |
form_block_id | uuid | yes | The block within the form, when the entry is bound to one. | — |
score | integer | yes | Score | /data[at0001]/events[at0002]/data[at0003]/items[at0004] |
commentcomment_codecomment_systemcomment_valueset_id | coded texttext, text, text, text | yes | Comment | /data[at0001]/events[at0002]/data[at0003]/items[at0005] |
Constraints
check (score is null or score between 1 and 100)
check ((comment_code is null and comment_system is null and comment_valueset_id is null) or (comment is not null and comment_code is not null and comment_system is not null and comment_valueset_id is not null))Unique
form_block_id
References
| Columns | Target | On delete |
|---|---|---|
form_id | form | cascade |
form_id, form_block_id | form_block | cascade |
comment_valueset_id, comment_code, comment_system, comment | valueset_code | restrict |
Indexes
cgas_form_id_idxonform_id