PHI.mdb: Difference between revisions

(29 intermediate revisions by 3 users not shown)

Line 1:

Data sent via [[Copy PHI.bat]] and [[PHI copy automation]] and query send_PHI

Data sent via [[Copy PHI.bat]] and [[PHI copy automation]] and query send_PHI. Contains primarily [[L PHI table]].

* first name

* last name

* full DOB (as opposed to the month/year sent to [[~~Centralized data.mdb~~ ]]

* PHIN

* hospital chart number

~~in addition the following field is included to re-link the data:~~

* D_ID: R_Location & "-" & Pat_ID

~~This data will be stored in X~~:\CCMDB\PHI\phi.mdb

File Location: {{S:\MED\MED_CCMED|CCMDB\PHI\phi.mdb}}

== phi.mdb change log ==

=== 2016-Oct-03 ===

* I suspect it was rolled out; if it had not been there would still be a problem. Ttenbergen 16:29, 2017 January 3 (CST)

*not rolled out yet Ttenbergen 10:56, 2016 October 3 (CDT)

* fixing mistake from bulk change of STB_B5 data: see [[Centralized_data.accdb]]_Change_Log#2016-Oct-03]]

~~== phi.mdb change log ==~~

=== 2015-04-15 ===

* changed the date format for DOB to dd-mmm-yyyy, eg 12-oct-1999 Ttenbergen 14:01, 2015 April 15 (CDT)

Line 19:

Line 16:

== How PHI data travels ==

# regular data enter into [[CCMDB.~~mdb~~]] by collector

# regular data enter into [[CCMDB.accdb]] by collector

# at sending, query ''send_PHI'' is called to export '''all''' (ie not only complete) records to ~~[[Regional Server]]\~~Output\_PHI

# at sending, query ''send_PHI'' is called to export '''all''' (ie not only complete) records to {{Regionalserver|Output\_PHI}}

#* this means that previously sent data will get updated, e.g. if a name or PHIN is corrected or added

# [[PHI copy automation]]: a scheduled task uses [[Copy PHI.bat]] to move the files to ~~[[X~~:\]]CCMDB\PHI and to import it into x:\CCMDB\PHI\PHI.mdb

# [[PHI copy automation]]: a scheduled task uses [[Copy PHI.bat]] to move the files to {{S:\MED\MED_CCMED|CCMDB\PHI}} and to import it into {{S:\MED\MED_CCMED|CCMDB\PHI\PHI.mdb}}

#* [[Pull down centralized data.vbs]] will do this as well to make sure it is done before pulling

# PHI.mdb can be re-linked with [[~~centralized_data~~.~~mdb~~]] using [[~~centralized_data_front_end~~.mdb]]

# PHI.mdb can be re-linked with [[Centralized_data.accdb]] using [[Centralized_data_front_end.accdb]]

== Availability ==

PHI.mdb might not be available at its network location between the hours of 10:30 to 17:00 CST. See [[Pull down centralized data.vbs]] if it needs to be retrieved locally.

==Password==

Located: M:~~\Passwords_mainoffice~~

Located: {{M:|Passwords_MainOffice_use}}

[[Category: IT Instructions]]

[[Category:IT Instructions]]

[[Category: 2013 data upgrades]]

[[Category:2013 data upgrades]]

[[Category:Password]]

[[Category:PHI]]

@@ Line 1: / Line 1: @@
-Data sent via [[Copy PHI.bat]] and [[PHI copy automation]] and query send_PHI
+Data sent via [[Copy PHI.bat]] and [[PHI copy automation]] and query send_PHI. Contains primarily [[L PHI table]].
-* first name
-* last name
-* full DOB (as opposed to the month/year sent to [[Centralized data.mdb ]]
-* PHIN
-* hospital chart number
-in addition the following field is included to re-link the data:
-*  D_ID: R_Location & "-" & Pat_ID
-This data will be stored in X:\CCMDB\PHI\phi.mdb
+File Location: {{S:\MED\MED_CCMED|CCMDB\PHI\phi.mdb}}
+== phi.mdb change log ==
+=== 2016-Oct-03 ===
+* I suspect it was rolled out; if it had not been there would still be a problem. Ttenbergen 16:29, 2017 January 3 (CST)
+*not rolled out yet Ttenbergen 10:56, 2016 October 3 (CDT)
+* fixing mistake from bulk change of STB_B5 data: see [[Centralized_data.accdb]]_Change_Log#2016-Oct-03]]
-== phi.mdb change log ==
 === 2015-04-15 ===
 * changed the date format for DOB to dd-mmm-yyyy, eg 12-oct-1999 Ttenbergen 14:01, 2015 April 15 (CDT)
@@ Line 19: / Line 16: @@
 == How PHI data travels ==
-# regular data enter into [[CCMDB.mdb]] by collector
+# regular data enter into [[CCMDB.accdb]] by collector
-# at sending, query ''send_PHI'' is called to export '''all''' (ie not only complete) records to [[Regional Server]]\Output\_PHI
+# at sending, query ''send_PHI'' is called to export '''all''' (ie not only complete) records to {{Regionalserver|Output\_PHI}}
 #* this means that previously sent data will get updated, e.g. if a name or PHIN is corrected or added
-# [[PHI copy automation]]: a scheduled task uses [[Copy PHI.bat]] to move the files to [[X:\]]CCMDB\PHI and to import it into x:\CCMDB\PHI\PHI.mdb
+# [[PHI copy automation]]: a scheduled task uses [[Copy PHI.bat]] to move the files to {{S:\MED\MED_CCMED|CCMDB\PHI}} and to import it into {{S:\MED\MED_CCMED|CCMDB\PHI\PHI.mdb}}
 #* [[Pull down centralized data.vbs]] will do this as well to make sure it is done before pulling
-# PHI.mdb can be re-linked with [[centralized_data.mdb]] using [[centralized_data_front_end.mdb]]
+# PHI.mdb can be re-linked with [[Centralized_data.accdb]] using [[Centralized_data_front_end.accdb]]
+== Availability ==
+PHI.mdb might not be available at its network location between the hours of 10:30 to 17:00 CST.  See [[Pull down centralized data.vbs]] if it needs to be retrieved locally.
 ==Password==
-Located:   M:\Passwords_mainoffice
+Located: {{M:|Passwords_MainOffice_use}}
-[[Category: IT Instructions]]
+[[Category:IT Instructions]]
-[[Category: 2013 data upgrades]]
+[[Category:2013 data upgrades]]
 [[Category:Password]]
+[[Category:PHI]]