INSTITUTIONSSR_RI_EDU_GOV_NLDACAD_ORGSSR_RI_EPV_BND(SQL View) |
Index Back |
|---|---|
Pop Select Bind Ed ProviderRIO Pop select Bind Ed Provider record |
| SELECT DEL.INSTITUTION ,DEL.SSR_RI_EDU_GOV_NLD ,DEL.ACAD_ORG FROM PS_SSR_RI_MEPV_NLD DEL UNION SELECT A.INSTITUTION ,A.SSR_RI_EDU_GOV_NLD ,B.ACAD_ORG FROM PS_SSR_RI_EPS_NLD A ,PS_ACAD_ORG_TBL B ,PS_SSR_RI_EPWL_NLD EPW WHERE %EffdtCheck(SSR_RI_EPS_NLD A_ED, A,%currentdatein) AND %EffdtCheck(ACAD_ORG_TBL B_ED, B, %currentdatein) AND A.INSTITUTION = B.INSTITUTION AND B.INSTITUTION = EPW.INSTITUTION AND B.ACAD_ORG = EPW.ACAD_ORG AND A.EFFDT = EPW.EFFDT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 2 | SSR_RI_EDU_GOV_NLD |
Character(20) | VARCHAR2(20) NOT NULL | Educational Board Code |
| 3 | ACAD_ORG |
Character(10) | VARCHAR2(10) NOT NULL | Academic Organization |