Data dictionary › Codes & lookups

SCT_DESCRIPTIONS

Population

File
data/SCT_DESCRIPTIONS.csv
Category
reference
Primary key
DESCRIPTION_ID
Columns
7

01Relates to the patient

reference data (no patient link)

Single-patient export: not included (not referenced by patient records).

02Columns

#ColumnTypeSource typeNullNotes
1DESCRIPTION_ID PKstringvarchar(10)no
2DESCRIPTION_STATUSintegerintyes
3CONCEPT_IDstringvarchar(9)yes
4TERMstringvarchar(255)yes
5INITIAL_CAPITAL_STATUSintegerintyes
6DESCRIPTION_TYPEintegerintyes
7LANGUAGE_CODEstringvarchar(2)yes