L PCH table

L_PCH is a table in Centralized_data.mdb.

Fields:

• D_PCH_ID - unique ID column
  • a random number generated by Access when a new line is added
• Person_ID - key against table L_Person table
• PCH_ID - ID of the PCH, key against table S_PCH
• PCH_admission - date of admission to that PCH

There can be multiple records in table L_PCH for each entry in L_Person table in case they change PCHs.

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