Can we not use ID? I'm concerned about auto linking wiht SQL servers and the ID Column... PID could be good though!

Potentially -- Sabrina wong or Cathy Incandela should be able to provide insight on this -- she has a query that can pull if a student has had an active housing contract based on a specific date range or specific date using the Housing table instead of using the housing address