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>
