L PHI table

From CCMDB Wiki
Jump to navigationJump to search

L_PHI table in PHI.mdb contains the portion of L_Log data in our centralized repository that is PHIA protected. In CCMDB.accdb this portion of the data is part of the L_Log table. It is linked to L_Log table by D_ID.

Data Structure

 FieldNameFieldDataTypeFieldLengthorder in table
Pat ID fieldPat_IDnumberLong Integer1
D ID fieldD_IDstring181
LastName fieldLastNamestring402
FirstName fieldFirstNamestring403
PHIN fieldPHINnumberLong Integer4
Date of BirthBirthdatenot entered5
Chart numberChartstring86
Notes field (L PHI)Notesstringnot entered9