L_PHI table

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

	FieldName	FieldDataType	FieldLength	order in table
Pat ID field	Pat_ID	number	Long Integer	1
D ID field	D_ID	string	18	1
LastName field	LastName	string	40	2
FirstName field	FirstName	string	40	3
PHIN field	PHIN	number	Long Integer	4
Date of Birth	Birth	date	not entered	5
Chart number	Chart	string	8	6
Notes field (L PHI)	Notes	string	not entered	9