vwINPATIENT_ADMISSIONS


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IP_ID int identity 4 null
CARE_ID int 4 null
L_ADMISSION_DATE smalldatetime 16 null
L_URGENCY int 4 null
L_DISCHARGE_DATE smalldatetime 16 null
L_REASON varchar 255 null
L_COMPLICATIONS int 4 null
L_COMPLICATIONS2 int 4 null
L_COMPLICATIONS3 int 4 null
L_COMPS varchar 255 null
L_PLAN varchar 255 null
L_DRUGS varchar 255 null
L_DESTINATION int 4 null
L_COMMENTS text 2147483647 null

View Definition


Possibly Referenced Tables/Views