L PHI table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m links |
Ttenbergen (talk | contribs) m link fix and SMW |
||
| Line 10: | Line 10: | ||
|| D_ID || text(18) || unique ID | || D_ID || text(18) || unique ID | ||
|- | |- | ||
|| [[ | || [[Last Name]] || text(40) || | ||
|- | |- | ||
|| [[First Name | || [[First Name]] || text(40) || | ||
|- | |- | ||
|| [[PHIN field|PHIN]] || long || | || [[PHIN field|PHIN]] || long || | ||
| Line 23: | Line 23: | ||
|} | |} | ||
=== SMW table description === | |||
* D_ID - unique record ID | |||
{{#ask: [[Category:L PHI]] | |||
| ?FieldName | |||
| ?FieldDataType | |||
| ?DataElementSortIndex = order in table | |||
|sort=DataElementSortIndex | |||
|order=ascending | |||
|format=broadtable | |||
|default=No pages for labs that meet the semantic mediawiki criteria | |||
|headers=show | |||
|class=sortable wikitable smwtable | |||
}} | |||
[[Category:Data structure]] | [[Category:Data structure]] | ||
[[Category:L PHI table|*]] | [[Category:L PHI table|*]] | ||
Revision as of 13:39, 6 February 2017
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 |
| Last Name | text(40) | |
| First Name | text(40) | |
| PHIN | long | |
| birth | Date/time | |
| chart | text(10) | |
| notes | Memo |
SMW table description
- D_ID - unique record ID
No pages for labs that meet the semantic mediawiki criteria