SSR_RI_EOLVWNLD

(SQL View)
 Index Back

RIO external location view


SELECT DISTINCT olc.scc_caf_attr_val , ol.address3 %Concat ' ' %Concat ol.num1 %Concat ' ' %Concat ol.num2 %Concat ' ' %Concat ol.postal %Concat ' ' %concat ol.city AS descr200 FROM ps_org_location OL JOIN ps_scc_caf_org_loc olc ON ol.ext_org_id = olc.ext_org_id AND ol.org_location = olc.org_location AND ol.effdt = olc.effdt AND olc.scc_caf_attrib_nm = ( SELECT scc_caf_attrib_nm FROM PS_SSR_BR_PECF_NLD inst WHERE inst.effdt = ( SELECT MAX(inst_ed.effdt) FROM PS_SSR_BR_PECF_NLD inst_ed WHERE inst.institution = inst_ed.institution AND inst_ed.effdt <= %CurrentDateIn)) AND olc.scc_caf_attr_val > ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SSR_RI_OLO_COD_NLD Character(12) VARCHAR2(12) NOT NULL RIO Establishment ID
2 SSR_RI_LOC_DTL_NLD Character(254) VARCHAR2(254) NOT NULL RIO org location details