Data dictionary › Problems, diagnoses & assessments

CLAIM_DIAGS_OLD

Single Population

File
data/CLAIM_DIAGS_OLD.csv
Category
patient
Primary key
INVOICE, CLAIM_LINE, DIAG_CODE_NUMBER, CODING_METHOD
Columns
5

01Relates to the patient

INVOICE matches ACCOUNTS_RECEIVABLE.INVOICE on a row of ACCOUNTS_RECEIVABLE that relates to the patient

Single-patient export: the patient's rows.

02Columns

#ColumnTypeSource typeNullNotes
1INVOICE PKintegerintno
2CLAIM_LINE PKintegerintno
3DIAG_CODE_NUMBER PKintegerintno
4CODING_METHOD PKstringvarchar(5)no
5DIAG_CODEstringvarchar(8)no