nurseAssessment

Purpose:

The Nursing Assessment Flowsheet provides the capability to assess and document patient items such as pain, psychosocial status, patient/family education, neurologic, cardiovascular, respiratory, oral/GI/GU, skin, and other nursing assessment data.

Links to:

  • PATIENT on patientUnitStayID

Table columns

Name Datatype Null Option Comment Is Key Stored Transformed Created
nurseAssessID int IDENTITY surrogate key for the nurse assessment PK C
patientUnitStayID int NOT NULL foreign key link to the patient table FK C
nurseAssessOffset int NOT NULL number of minutes from unit admit time that nurse assessment column C
nurseAssessEntryOffset int NOT NULL number of minutes from unit admit time that nurse assessment column was entered C
cellAttributePath varchar(255) NOT NULL the full path string of the nurse assessment entry selected in eCareManager, the sections of the assessment will be separated by a symbol e.g.: flowsheet Flowsheet Cell Labels
cellLabel varchar(255) NOT NULL label of the selected nurse assessment entry S
cellAttribute varchar(255) NOT NULL attribute for the nurse assessment entry selected in eCareManager S
cellAttributeValue varchar(7500) NULL value for the nurse assessment attribute selected for the nurse assessment entry in eCareManager S
eICU-CRD v1.0 documentation