FRIDAY appointment_base → PAC appointment(全部预约)+ encounter(已到诊接诊事件),
与第一个宿主 jvs-dw 同款设计(一个预约源喂两张 canonical)。要点:
- status 编码两家一致(1/2/3/4/5/6/8/9);status=10=草稿(查 friday-saas
  origin/hotfix AppointmentDataCommons draft==1 实锤)→ filter 丢弃
- scheduledAt 用 appointment_date + appointment_start 经 derive 拼(datetime_str
  是区间且 14% 空,不用)
- 已到诊(status 4/5/6 且 in_time 非空)拆 appointment_encounter_rows → encounter,
  startedAt=in_time;externalId=预约 id,将来 EMR(med_emr_info.appointmentId)据此回挂
本地验证:809 appointment + 640 encounter,1449 txns/1449 facts,0 失败 0 drift;
patient timeline 正确重建「预约→到诊」就诊史。

Co-Authored-By: Claude Opus 4.8 <noreply@anthropic.com>