SAP Table HRI1782
UCAS/HESA Student Data (GB)
HRI1782 (UCAS/HESA Student Data (GB)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link HRI1782 to other SAP tables.
HRI1782 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| RESID_CAT | UCAS: Residential category | PIQ_GB_UCAS_RESID_CAT | T7PIQ_GB_RCAT | CHAR | 1 | 0 | ||||||||||
| DOM_COUNTRY | Country Key | LAND1 | T005 | CHAR | 3 | 0 | ||||||||||
| DOM_COUNTY | Region (State, Province, County) | REGIO | T005S | CHAR | 3 | 0 | ||||||||||
| DOM_COUNC | County Code | COUNC | T005E | CHAR | 3 | 0 | ||||||||||
| INSTHE | HESA: HE institution last attended | PIQ_GB_HESA_INSTHE | T7PIQ_GB_INST_HE | NUMC | 4 | 0 | ||||||||||
| SCHOOL | UCAS: DFE number | PIQ_GB_UCAS_DFE_ID | CHAR | 7 | 0 | |||||||||||
| YRLLINST | Year left last institution | PIQ_GB_HESA_YRLLINST | NUMC | 4 | 0 | |||||||||||
| LEA | UCAS: LEA code | PIQ_GB_UCAS_LEA | T7PIQ_GB_LEA | NUMC | 3 | 0 | ||||||||||
| FEE_PAYER_CODE | UCAS: Fee Payer Code | PIQ_GB_UCAS_FEE_PAYER | T7PIQ_GB_FEES | NUMC | 2 | 0 | ||||||||||
| SOCIO_EC_CLASS | UCAS: Socioeconomic Class | PIQ_GB_UCAS_SOCIO_EC_CLASS | T7PIQ_GB_SCECCL | CHAR | 1 | 0 | ||||||||||
| UCAS_NO | UCAS: UCAS Number | PIQ_UCAS_GB_APPLICANT_ID | NUMC | 9 | 0 | |||||||||||
| HUSID | HESA Student Identifier | PIQ_GB_HESA_HUSID | NUMC | 13 | 0 | |||||||||||
| TREFNO | UCAS: Teacher Reference Number | PIQ_GB_UCAS_TREFNO | CHAR | 9 | 0 | |||||||||||
| DHREGREF | HESA: Regulatory Body Reference (revised) | PIQ_GB_UCAS_DHREGREF | NUMC | 9 | 0 | |||||||||||
| QUALENT2 | HESA: Highest Qualification on Entry | PIQ_GB_UCAS_QUALENT2 | T7PIQ_GB_HQUAL | NUMC | 3 | 0 | ||||||||||
| FEEELIG | UCAS: Fee Eligibility | PIQ_GB_UCAS_FEEELIG | T7PIQ_GB_FEEEL | CHAR | 1 | 0 | ||||||||||
| SPCSTU | HESA: Special Students | PIQ_GB_UCAS_SPCSTU | T7PIQ_GB_SPSTU | CHAR | 1 | 0 | ||||||||||
| TTACOM | HESA: Term Time Accommodation | PIQ_GB_UCAS_TTACOM | T7PIQ_GB_TTCACO | CHAR | 1 | 0 | ||||||||||
| SCHOOL_NO | UCAS: School Number | PIQ_GB_UCAS_SCHOOL | T7PIQ_GB_SCHOOL | CHAR | 7 | 0 | ||||||||||
| SABAT | HESA: Flag Student as sabbatical | PIQ_GB_HESA_SABAT | CHAR | 1 | 0 |
Possible values
|
||||||||||
| ENTRYCDE | HESA: New Entrant to HE | PIQ_GB_HESA_ENTRYCDE | NUMC | 1 | 0 |
Possible values
|
||||||||||
| TTCID | HESA: Teacher Training Course Identifier | PIQ_GB_HESA_TTCID | T7PIQ_GB_TTCID | NUMC | 1 | 0 | ||||||||||
| NHSEMP | HESA: NHS Employer | PIQ_GB_HESA_NHSEMP | T7PIQ_GB_NHSEMP | CHAR | 5 | 0 | ||||||||||
| PGCESBJ1 | HESA: PGCE - Subject 1 of UG Degree | PIQ_GB_HESA_PGCESBJ1 | T7PIQ_GB_SBJ | CHAR | 4 | 0 | ||||||||||
| PGCESBJ2 | HESA: PGCE - Subject 2 of UG Degree | PIQ_GB_HESA_PGCESBJ2 | T7PIQ_GB_SBJ | CHAR | 4 | 0 | ||||||||||
| PGCESBJ3 | HESA: Subject 3 of UG Degree | PIQ_GB_HESA_PGCESBJ3 | T7PIQ_GB_SBJ | CHAR | 4 | 0 | ||||||||||
| PGCECLSS | HESA: PGCE - Classification of UG Degree | PIQ_GB_HESA_PGCECLSS | T7PIQ_GB_PGCECL | CHAR | 2 | 0 | ||||||||||
| PREVINST | HESA: Previous Institution attended | PIQ_GB_HESA_PREVINST | CHAR | 8 | 0 | |||||||||||
| EMPLOYER | HESA: Major Source of Tuition Fee is Student's Employer | PIQ_GB_HESA_EMPLOYER | CHAR | 1 | 0 |
Possible values
|
||||||||||
| FEINSTID | HESA: Further Education Institution Identifier | PIQ_GB_HESA_FEINSTID | T7PIQ_GB_FEINS | CHAR | 7 | 0 | ||||||||||
| DHREGREF2 | HESA: Regulatory Body Reference No. allocated to a Student | PIQ_GB_UCAS_DHREGREF2 | CHAR | 8 | 0 | |||||||||||
| PARED | UCAS: Parental Education | PIQ_GB_UCAS_PARED | CHAR | 1 | 0 |
Possible values
|
||||||||||
| POSTCODE | UCAS: Postcode prior to entry | PIQ_GB_UCAS_POSTCODE | CHAR | 8 | 0 | |||||||||||
HRI1782 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| HRI1782 | DOM_COUNC | SYST | MANDT | T005E | County | MANDT |
| HRI1782 | DOM_COUNC | HRI1782 | DOM_COUNTRY | T005E | County | LAND1 |
| HRI1782 | DOM_COUNC | HRI1782 | DOM_COUNTY | T005E | County | REGIO |
| HRI1782 | DOM_COUNC | HRI1782 | DOM_COUNC | T005E | County | COUNC |
| HRI1782 | DOM_COUNTRY | SYST | MANDT | T005 | Countries | MANDT |
| HRI1782 | DOM_COUNTRY | HRI1782 | DOM_COUNTRY | T005 | Countries | LAND1 |
| HRI1782 | DOM_COUNTY | SYST | MANDT | T005S | Taxes: Region (Province) Key | MANDT |
| HRI1782 | DOM_COUNTY | HRI1782 | DOM_COUNTRY | T005S | Taxes: Region (Province) Key | LAND1 |
| HRI1782 | DOM_COUNTY | HRI1782 | DOM_COUNTY | T005S | Taxes: Region (Province) Key | BLAND |
| HRI1782 | FEEELIG | SYST | MANDT | T7PIQ_GB_FEEEL | UCAS: Fee eligibility | MANDT |
| HRI1782 | FEEELIG | HRI1782 | FEEELIG | T7PIQ_GB_FEEEL | UCAS: Fee eligibility | FEEEL |
| HRI1782 | FEE_PAYER_CODE | SY | MANDT | T7PIQ_GB_FEES | UCAS: Fee payer code | MANDT |
| HRI1782 | FEE_PAYER_CODE | HRI1782 | FEE_PAYER_CODE | T7PIQ_GB_FEES | UCAS: Fee payer code | FEE_PAYER_CODE |
| HRI1782 | FEINSTID | SYST | MANDT | T7PIQ_GB_FEINS | HESA: Further Education Institutions | MANDT |
| HRI1782 | FEINSTID | HRI1782 | FEINSTID | T7PIQ_GB_FEINS | HESA: Further Education Institutions | FEINST |
| HRI1782 | INSTHE | SYST | MANDT | T7PIQ_GB_INST_HE | HESA: Institution Codes | MANDT |
| HRI1782 | INSTHE | HRI1782 | INSTHE | T7PIQ_GB_INST_HE | HESA: Institution Codes | INSTID |
| HRI1782 | LEA | SYST | MANDT | T7PIQ_GB_LEA | UCAS: LEA code | MANDT |
| HRI1782 | LEA | HRI1782 | LEA | T7PIQ_GB_LEA | UCAS: LEA code | LEA |
| HRI1782 | NHSEMP | HRI1782 | NHSEMP | T7PIQ_GB_NHSEMP | HESA: NHS Employer | NHSEMP |
| HRI1782 | NHSEMP | SYST | MANDT | T7PIQ_GB_NHSEMP | HESA: NHS Employer | MANDT |
| HRI1782 | PGCECLSS | SYST | MANDT | T7PIQ_GB_PGCECL | HESA: PGCE - Classification of UG Degree | MANDT |
| HRI1782 | PGCECLSS | HRI1782 | PGCECLSS | T7PIQ_GB_PGCECL | HESA: PGCE - Classification of UG Degree | PGCECLSS |
| HRI1782 | PGCESBJ1 | SYST | MANDT | T7PIQ_GB_SBJ | HESA: JACS Subject Codes | MANDT |
| HRI1782 | PGCESBJ1 | HRI1782 | PGCESBJ1 | T7PIQ_GB_SBJ | HESA: JACS Subject Codes | SBJ |
| HRI1782 | PGCESBJ2 | SYST | MANDT | T7PIQ_GB_SBJ | HESA: JACS Subject Codes | MANDT |
| HRI1782 | PGCESBJ2 | HRI1782 | PGCESBJ2 | T7PIQ_GB_SBJ | HESA: JACS Subject Codes | SBJ |
| HRI1782 | PGCESBJ3 | HRI1782 | PGCESBJ3 | T7PIQ_GB_SBJ | HESA: JACS Subject Codes | SBJ |
| HRI1782 | PGCESBJ3 | SYST | MANDT | T7PIQ_GB_SBJ | HESA: JACS Subject Codes | MANDT |
| HRI1782 | QUALENT2 | HRI1782 | QUALENT2 | T7PIQ_GB_HQUAL | UCAS: Highest Qualification on Entry | QUALENT2 |
| HRI1782 | QUALENT2 | SYST | MANDT | T7PIQ_GB_HQUAL | UCAS: Highest Qualification on Entry | MANDT |
| HRI1782 | RESID_CAT | SYST | MANDT | T7PIQ_GB_RCAT | UCAS: Residential category (Revised do not use) | MANDT |
| HRI1782 | RESID_CAT | HRI1782 | RESID_CAT | T7PIQ_GB_RCAT | UCAS: Residential category (Revised do not use) | RESID_CAT |
| HRI1782 | SCHOOL_NO | SYST | MANDT | T7PIQ_GB_SCHOOL | UCAS: Schools | MANDT |
| HRI1782 | SCHOOL_NO | HRI1782 | SCHOOL_NO | T7PIQ_GB_SCHOOL | UCAS: Schools | SCHOOL_ID |
| HRI1782 | SOCIO_EC_CLASS | SYST | MANDT | T7PIQ_GB_SCECCL | UCAS: Socioeconomic Class | MANDT |
| HRI1782 | SOCIO_EC_CLASS | HRI1782 | SOCIO_EC_CLASS | T7PIQ_GB_SCECCL | UCAS: Socioeconomic Class | SOCIO_EC_CLASS |
| HRI1782 | SPCSTU | HRI1782 | SPCSTU | T7PIQ_GB_SPSTU | HESA: Special Students | SPCSTU |
| HRI1782 | SPCSTU | SYST | MANDT | T7PIQ_GB_SPSTU | HESA: Special Students | MANDT |
| HRI1782 | TTACOM | SYST | MANDT | T7PIQ_GB_TTCACO | HESA: Term Time Accomodation | MANDT |
| HRI1782 | TTACOM | HRI1782 | TTACOM | T7PIQ_GB_TTCACO | HESA: Term Time Accomodation | TTACCOM |
| HRI1782 | TTCID | SYST | MANDT | T7PIQ_GB_TTCID | HESA: Teacher Training Course Identifier | MANDT |
| HRI1782 | TTCID | HRI1782 | TTCID | T7PIQ_GB_TTCID | HESA: Teacher Training Course Identifier | TTCID |
