Data dictionary › Problems, diagnoses & assessments

PAT_PROGRAMS_PROBLEMS

Single Population

File
data/PAT_PROGRAMS_PROBLEMS.csv
Category
patient
Primary key
ACCOUNT, EPISODE_CARE_ID, PROBLEM_SEQUENCE_NO
Columns
6

01Relates to the patient

ACCOUNT is the patient's ACCOUNT

Single-patient export: the patient's rows.

02References

  • ACCOUNT, EPISODE_CARE_ID → PAT_PROGRAMS.ACCOUNT, EPISODE_CARE_ID
  • GROUPID, PROBLEMNUMBER → PROBLEM.GROUPID, PROBLEMNUMBER

03Columns

#ColumnTypeSource typeNullNotes
1ACCOUNT PKstringvarchar(12)no
2EPISODE_CARE_ID PKintegerintno
3PROBLEM_SEQUENCE_NO PKintegerintno
4PROBLEM_DESCRIPTIONstringvarchar(max)yes
5GROUPIDintegersmallintyes
6PROBLEMNUMBERintegersmallintyes