L PHI table: Difference between revisions

← Older edit

@@ 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.mdb]] this portion of the data is part of the [[L_Log table]].
+{{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 ==
-{| class="wikitable sortable"
+{{#ask: [[Category:L_PHI table]]
-|-
-!| field
-!| type
-!| description
-|-
-|| D_ID || text(18) || unique ID
-|-
-|| [[Last Name]] || text(40) ||
-|-
-|| [[First Name]] || text(40) ||
-|-
-|| [[PHIN field|PHIN]] || long ||
-|-
-|| [[Date of Birth|birth]] || Date/time ||
-|-
-|| [[Chart number|chart]] || text(10) ||
-|-
-|| notes || Memo ||
-|}
-=== SMW table description ===
-*	D_ID - unique record ID
-{{#ask: [[Category:L PHI]]
 | ?FieldName
 | ?FieldDataType
+| ?FieldLength
 | ?DataElementSortIndex = order in table
 |sort=DataElementSortIndex
@@ Line 41: / Line 17: @@
 [[Category:Data structure]]
-[[Category:L PHI table|*]]
+[[Category:L_PHI table| *]]
+[[Category:L Table]]