Department in Visit_Occurrence table

[MichealJeong (Micheal)]

I would like to ask if the ‘department field’ which person has visited could be in visit table.
As NS(NeuroSurgery), GS(General Surgery), PD(PeDiatrics), OS(OrthoSurgery), PS(Plastic Surgery)…etc, I carefully suggest them in Visit table.

[MPhilofsky (Melanie Philofsky)]

“Departments” are in the CARE_SITE table which has a FK to the VISIT_OCCURRENCE table.

[MichealJeong (Micheal)]

There is no any ‘Department’ in the CARE_SITE table.
The only IP, OP facilities are there.

[Christian_Reich]

@MichealJeong:

For more detailed information what happens inside a visit please use VISIT_DETAIL.

[MichealJeong (Micheal)]

I’ll look at them
Thank you @Christian_Reich