L PHI table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m links |
Ttenbergen (talk | contribs) mNo edit summary |
||
| (11 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
L_PHI table in [[PHI.mdb]] contains the portion of [[L_Log]] data in our centralized repository that is [[PHIA]] protected. In [[CCMDB. | {{DISPLAYTITLE: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 == | == Data Structure == | ||
{ | {{#ask: [[Category:L_PHI table]] | ||
| ?FieldName | |||
| ?FieldDataType | |||
| ?FieldLength | |||
| ?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: | [[Category:L_PHI table| *]] | ||
[[Category:L Table]] | |||
Latest revision as of 14:10, 17 May 2023
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 |