EXT_ORG_IDPrompt Table: SSR_HE_DYCODEVW
Prompt Table: SSR_HE_HSTID_VW
SSR_HE_DEG_EST(SQL Table) |
Index Back |
|---|---|
Previous Degree EstablishmentPrevious HESA Degree Establishment |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EXT_ORG_ID |
Character(11) | VARCHAR2(11) NOT NULL | External Org ID |
| 2 | SSR_HE_DEGEST | Character(4) | VARCHAR2(4) NOT NULL |
Field to store HESA Degree Establishment values
Prompt Table: SSR_HE_DYCODEVW |
| 3 | SAD_PB_SLN | Character(9) | VARCHAR2(9) NOT NULL | Sponser Licence Number |
| 4 | SSR_HE_UKPRN | Character(20) | VARCHAR2(20) NOT NULL | UKPRN |
| 5 | SSR_HE_UNRFN | Character(6) | VARCHAR2(6) NOT NULL | HESA Unique Reference Number |
| 6 | SSR_HE_COHON | Character(8) | VARCHAR2(8) NOT NULL | HESA Companies House Number |
| 7 | SSR_HE_NHSID | Character(8) | VARCHAR2(8) NOT NULL | HESA National Health Service ID |
| 8 | SSR_HE_HSTID | Character(4) | VARCHAR2(4) NOT NULL |
HESA Host ID
Prompt Table: SSR_HE_HSTID_VW |