L PCH table

L_PCH is a table in Centralized_data.mdb.

Data Structure

field	type	description
D_PCH_ID	Long integer (AutoNumber)	unique ID column, random number generated by Access when a new line is added
Person_ID	Long integer	key against table L_Person table
PCH_ID	Long integer	ID of the PCH, key against table S_PCH
PCH_admission	date/time	date of admission to that PCH

Where does this data come from?

L_PCH is populated as part of what did we call the Death/PCH data exchange...? Template:Discussion