SSR_RI_EPV_COD_NLDSSR_RI_MEPVWNLD(SQL View) |
Index Back |
|---|---|
Mirror Table (base edu prov) |
| SELECT DISTINCT a.SSR_RI_EPV_COD_NLD ,b.acad_org ,b.descr FROM PS_SSR_RI_MEPV_NLD a ,ps_acad_org_tbl b WHERE a.acad_org = b.acad_org AND %EffdtCheck(acad_org_tbl b1,b, %currentdatein) |
| # | 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 | ACAD_ORG | Character(10) | VARCHAR2(10) NOT NULL | Academic Organization |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |