PHI.mdb: Difference between revisions

Revision as of 16:43, 2015 October 5

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

File Location: X:\CCMDB\PHI\phi.mdb

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

added indices for firstname, lastname, phin and chart, to speed up linking tables.

regular data enter into CCMDB.mdb by collector
at sending, query send_PHI is called to export all (ie not only complete) records to Regional Server\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
- 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

Located: See: <file>M:\Passwords_MainOffice_use</file>

Revision as of 12:44, 2015 August 17 (view source) Ttenbergen (talk \| contribs) m (m) ← Older edit		Revision as of 16:43, 2015 October 5 (view source) TOstryzniuk (talk \| contribs) m (→‎Password: minor) Newer edit →
Line 19:		Line 19:

	==Password==		==Password==
	Located: M:\~~Passwords_mainoffice~~		Located: See: <file>M:\Passwords_MainOffice_use</file>