SSR_RI_EPV_COD_NLDSSR_RI_EEPVWNLD(SQL View) |
Index Back |
|---|---|
RIO external provider view |
| SELECT DISTINCT dpc.scc_caf_attr_val , dp.descr FROM ps_org_dept dp JOIN ps_scc_caf_org_dep dpc ON dp.ext_org_id = dpc.ext_org_id AND dp.org_department= dpc.org_department AND dp.effdt = dpc.effdt AND dpc.scc_caf_attrib_nm = ( SELECT ssr_ri_depattr_nld FROM PS_SSR_RI_EPS_NLD inst WHERE inst.effdt = ( SELECT MAX(inst_ed.effdt) FROM PS_SSR_RI_EPS_NLD inst_ed WHERE inst.institution = inst_ed.institution AND inst_ed.effdt <= %CurrentDateIn)) AND dpc.scc_caf_attr_val > ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SSR_RI_EPV_COD_NLD |
Character(12) | VARCHAR2(12) NOT NULL | Educational Provider Code |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |