Data dictionary › Programs, episodes, referrals & nursing

NURSING_CHECK

Single Population

File
data/NURSING_CHECK.csv
Category
patient
Primary key
LOG_NUMBER
Columns
11

01Relates to the patient

ACCOUNT is the patient's ACCOUNT

Single-patient export: the patient's rows.

02References

03Columns

#ColumnTypeSource typeNullNotes
1LOG_NUMBER PKintegerintno
2CHECK_ROUNDintegerintyes
3ACCOUNTstringvarchar(12)no
4CHECK_DISPOSITIONstringvarchar(120)yes
5CHECK_STATUSstringvarchar(120)yes
6ENTRY_USERstringvarchar(60)no
7ENTRY_DATETIMEdatetimedatetimeno
8CHANGE_USERstringvarchar(60)yes
9CHANGE_DATETIMEdatetimedatetimeyes
10PROGRAM_SHIFT_IDintegerintyes
11DATEdatetimedatetimeyes