EXT_ORG_IDSSR_HE_EXORG_VW(SQL View) |
Index Back |
|---|---|
HESA External Org viewHESA External Org view |
| SELECT A.EXT_ORG_ID , ( SELECT B.DESCR50 FROM %Table(EXT_ORG_TBL) B WHERE B.EXT_ORG_ID=A.EXT_ORG_ID AND B.EFFDT=( SELECT MAX(C.EFFDT) FROM %Table(EXT_ORG_TBL) C WHERE C.EXT_ORG_ID=B.EXT_ORG_ID AND C.EFFDT<=%CurrentDateIn)) AS DES FROM %Table(SSR_HE_DEG_EST) A WHERE A.SSR_HE_UKPRN<>' ' OR A.SSR_HE_UNRFN<>' ' OR A.SSR_HE_COHON<>' ' OR A.SSR_HE_NHSID<>' ' OR A.SSR_HE_HSTID<>' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EXT_ORG_ID |
Character(11) | VARCHAR2(11) NOT NULL | External Org ID |
| 2 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |