Help me read this SQL code

1

SELECT
MIN(PM.encounter_number) as 'fin'
,PD.full_name as 'name'
,PD.birth_date as 'DOB'
,MIN(PFA.start_dt_tm) as 'appt_date'
,PFA.location_name as 'location'
,PM.financial_class_display as 'fin_class'
,HCM.condition_display as 'condition'
,HCM.condition_type as 'type'
,case when HCM.condition_type = 'SATISFYED' then 1 else 0 end as 'numerator'
,c.prsnl_name as 'provider_name'

FROM SSS.PH_F_APPOINTMENT PFA

What do you think PM, PFA, PD are?

2

Welcome!

You might not be showing us the whole query but those are aliases as you see here the table ph_appointment is aliased as pfa.Same with PM is analoas for another table

1 Like
3

Thank you very much yosiasz!