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

PAT_ACCIDENT_ATTORNEYS

Single Population

File
data/PAT_ACCIDENT_ATTORNEYS.csv
Category
patient
Primary key
ACCOUNT, ACCIDENT_DATE, ATTORNEY_TYPE_ID
Columns
6

01Relates to the patient

ACCOUNT is the patient's ACCOUNT

Single-patient export: the patient's rows.

02References

03Columns

#ColumnTypeSource typeNullNotes
1ACCOUNT PKstringvarchar(12)no
2ACCIDENT_DATE PKdatetimesmalldatetimeno
3ATTORNEY_TYPE_ID PKintegerintno
4ATTORNEY_CODEstringvarchar(20)no
5COMMENTstringvarchar(1000)yes
6NOTESstringtextyes