Is ProcCode in "procedurecode" table same as "CodeNum" in "procedurelog" table?
Posted: Tue Jun 15, 2021 4:05 pm
I am testing out writing queries.
I know the procedurecode contains all the codes while the procedurelog contains each procedure for a patient (so John with an ID of 555 can have 6 rows, each row containing a different CodeNum)
I wanted to get all patients that have a specific procedurecode. I know the procedurelog stores each and every procedure for a patient but is the "CodeNum" column contains the procedurecode that patient will do?
I know the procedurecode contains all the codes while the procedurelog contains each procedure for a patient (so John with an ID of 555 can have 6 rows, each row containing a different CodeNum)
I wanted to get all patients that have a specific procedurecode. I know the procedurelog stores each and every procedure for a patient but is the "CodeNum" column contains the procedurecode that patient will do?