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	Nursing Assessment	Scores	Braden Scale	Activity		S
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