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

RCM_CASES

Single Population

File
data/RCM_CASES.csv
Category
reference
Primary key
TRACKING_NUMBER
Columns
6

01Relates to the patient

reference data (no patient link)

Single-patient export: included in full (reference data).

02References

  • ACS_USER_ID → USERS.USER_ID
  • CUSTOMER_USER_ID → USERS.USER_ID

03Columns

#ColumnTypeSource typeNullNotes
1TRACKING_NUMBER PKintegerintno
2ACS_USER_IDstringvarchar(20)no
3CUSTOMER_USER_IDstringvarchar(20)no
4ENTRY_DATEdatetimedatetimeno
5CLOSE_DATEdatetimedatetimeyes
6COMMENT_TEXTstringvarchar(max)yes