SSR_HE_CONFIG(SQL Table) |
Index Back |
|---|---|
HESA ConfigurationHESA Configuration |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
| 2 | SSR_HE_INSTITUTION | Character(4) | VARCHAR2(4) NOT NULL | HESA Institution Identifier |
| 3 | SSR_HE_HUSID_SEQ | Number(6,0) | INTEGER NOT NULL | HUSID Sequence Number |
| 4 | SSR_HE_UKPRN | Character(20) | VARCHAR2(20) NOT NULL | UKPRN |
| 5 | SCC_EXTERNAL_SYS | Character(3) | VARCHAR2(3) NOT NULL |
External System
Prompt Table: SCC_EXT_SYS_TBL |
| 6 | SSR_HE_INCOM_SUB | Character(1) | VARCHAR2(1) NOT NULL |
Allow incomplete submission
Y/N Table Edit Default Value: N |
| 7 | SSR_HE_REQD_QUEST | Character(1) | VARCHAR2(1) NOT NULL |
Require mandatory questions
Y/N Table Edit Default Value: N |
| 8 | SSR_HE_FUR_EDU | Character(1) | VARCHAR2(1) NOT NULL |
Enable Further Education page
Y/N Table Edit Default Value: N |
| 9 | SSR_HE_FIN_SUP | Character(1) | VARCHAR2(1) NOT NULL |
Show Financial Support region
Y/N Table Edit |
| 10 | SSR_HE_HIDE_QTS | Character(1) | VARCHAR2(1) NOT NULL |
Hide Qualified Teacher Status
Y/N Table Edit |
| 11 | SSR_HE_HIDE_SAR | Character(1) | VARCHAR2(1) NOT NULL |
Hide Save and Return
Y/N Table Edit |
| 12 | SSR_HE_ITT_PLC | Character(1) | VARCHAR2(1) NOT NULL |
ITT Placement check box
Y/N Table Edit |
| 13 | SSR_HE_EXT_SYS | Character(3) | VARCHAR2(3) NOT NULL |
SID External System
Prompt Table: SCC_EXT_SYS_TBL |