L PHI table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m cat |
Ttenbergen (talk | contribs) m links |
||
| Line 10: | Line 10: | ||
|| D_ID || text(18) || unique ID | || D_ID || text(18) || unique ID | ||
|- | |- | ||
|| LastName || text(40) || | || [[First Name and Last Name fields|LastName]] || text(40) || | ||
|- | |- | ||
|| FirstName || text(40) || | || [[First Name and Last Name fields|FirstName]] || text(40) || | ||
|- | |- | ||
|| PHIN || long || | || [[PHIN field|PHIN]] || long || | ||
|- | |- | ||
|| birth || Date/time || | || [[Date of Birth|birth]] || Date/time || | ||
|- | |- | ||
|| chart || text(10) || | || [[Chart number|chart]] || text(10) || | ||
|- | |- | ||
|| notes || Memo || | || notes || Memo || | ||
Revision as of 14:30, 19 September 2016
L_PHI table in PHI.mdb contains the portion of L_Log data in our centralized repository that is PHIA protected. In CCMDB.mdb this portion of the data is part of the L_Log table.
Data Structure
| field | type | description |
|---|---|---|
| D_ID | text(18) | unique ID |
| LastName | text(40) | |
| FirstName | text(40) | |
| PHIN | long | |
| birth | Date/time | |
| chart | text(10) | |
| notes | Memo |