Data dictionary › Billing: encounters, A/R, claims, remittance

CLAIM_HISTORY_OLD

Single Population

File
data/CLAIM_HISTORY_OLD.csv
Category
patient
Primary key
INVOICE, CLAIM_EVENT_DATE
Columns
3

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_EVENT_DATE PKdatetimedatetimeno
3CLAIM_EVENTstringvarchar(15)yes