SAP ABAP Table HRI1782 (UCAS/HESA Student Data (GB))

Hierarchy

☛ IS-PS-CA (Software Component) IS-PUBLIC SECTOR CONTRACT ACCOUNTING
   ⤷ IS-HER-CM-GB (Application Component) United Kingdom
     ⤷ PMIQ_GB (Package) Campus Management (Great Britain)

Basic Data

Table Category	INTTAB	Structure
Structure	HRI1782	Table Relationship Diagram
Short Description	UCAS/HESA Student Data (GB)

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	RESID_CAT	☐	PIQ_GB_UCAS_RESID_CAT	PIQ_GB_UCAS_RESID_CAT	CHAR	1	0	UCAS: Residential category	T7PIQ_GB_RCAT
2	DOM_COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
3	DOM_COUNTY	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
4	DOM_COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
5	INSTHE	☐	PIQ_GB_HESA_INSTHE	PIQ_GB_HESA_INSTID	NUMC	4	0	HESA: HE institution last attended	T7PIQ_GB_INST_HE
6	SCHOOL	☐	PIQ_GB_UCAS_DFE_ID	CHAR7	CHAR	7	0	UCAS: DFE number
7	YRLLINST	☐	PIQ_GB_HESA_YRLLINST		NUMC	4	0	Year left last institution
8	LEA	☐	PIQ_GB_UCAS_LEA	PIQ_GB_UCAS_LEA	NUMC	3	0	UCAS: LEA code	T7PIQ_GB_LEA
9	FEE_PAYER_CODE	☐	PIQ_GB_UCAS_FEE_PAYER	PIQ_GB_UCAS_FEE_PAYER	NUMC	2	0	UCAS: Fee Payer Code	T7PIQ_GB_FEES
10	SOCIO_EC_CLASS	☐	PIQ_GB_UCAS_SOCIO_EC_CLASS	PIQ_GB_UCAS_SOCIO_EC_CLASS	CHAR	1	0	UCAS: Socioeconomic Class	T7PIQ_GB_SCECCL
11	UCAS_NO	☐	PIQ_UCAS_GB_APPLICANT_ID	PIQ_GB_UCAS_APPLICANT_ID	NUMC	9	0	UCAS: UCAS Number
12	HUSID	☐	PIQ_GB_HESA_HUSID		NUMC	13	0	HESA Student Identifier
13	TREFNO	☐	PIQ_GB_UCAS_TREFNO	PIQ_GB_UCAS_TREFNO	CHAR	9	0	UCAS: Teacher Reference Number
14	DHREGREF	☐	PIQ_GB_UCAS_DHREGREF	PIQ_GB_UCAS_DHREGREF	NUMC	9	0	HESA: Regulatory Body Reference (revised)
15	QUALENT2	☐	PIQ_GB_UCAS_QUALENT2	PIQ_GB_UCAS_QUALENT2	NUMC	2	0	HESA: Highest Qualification on Entry	T7PIQ_GB_HQUAL
16	FEEELIG	☐	PIQ_GB_UCAS_FEEELIG	PIQ_GB_UCAS_FEEELIG	CHAR	1	0	UCAS: Fee Eligibility	T7PIQ_GB_FEEEL
17	SPCSTU	☐	PIQ_GB_UCAS_SPCSTU	PIQ_GB_UCAS_SPCSTU	CHAR	1	0	HESA: Special Students	T7PIQ_GB_SPSTU
18	TTACOM	☐	PIQ_GB_UCAS_TTACOM	PIQ_GB_UCAS_TTACOM	CHAR	1	0	HESA: Term Time Accommodation	T7PIQ_GB_TTCACO
19	SCHOOL_NO	☐	PIQ_GB_UCAS_SCHOOL	PIQ_GB_UCAS_SCHOOL	CHAR	7	0	UCAS: School Number	T7PIQ_GB_SCHOOL
20	SABAT	☐	PIQ_GB_HESA_SABAT	XFELD	CHAR	1	0	HESA: Flag Student as sabbatical
21	ENTRYCDE	☐	PIQ_GB_HESA_ENTRYCDE	PIQ_GB_HESA_ENTRYCDE	NUMC	1	0	HESA: New Entrant to HE
22	TTCID	☐	PIQ_GB_HESA_TTCID	PIQ_GB_HESA_TTCID	NUMC	1	0	HESA: Teacher Training Course Identifier	T7PIQ_GB_TTCID
23	NHSEMP	☐	PIQ_GB_HESA_NHSEMP	PIQ_GB_HESA_NHSEMP	CHAR	5	0	HESA: NHS Employer	T7PIQ_GB_NHSEMP
24	PGCESBJ1	☐	PIQ_GB_HESA_PGCESBJ1	PIQ_GB_HESA_SBJ	CHAR	4	0	HESA: PGCE - Subject 1 of UG Degree	T7PIQ_GB_SBJ
25	PGCESBJ2	☐	PIQ_GB_HESA_PGCESBJ2	PIQ_GB_HESA_SBJ	CHAR	4	0	HESA: PGCE - Subject 2 of UG Degree	T7PIQ_GB_SBJ
26	PGCESBJ3	☐	PIQ_GB_HESA_PGCESBJ3	PIQ_GB_HESA_SBJ	CHAR	4	0	HESA: Subject 3 of UG Degree	T7PIQ_GB_SBJ
27	PGCECLSS	☐	PIQ_GB_HESA_PGCECLSS	PIQ_GB_HESA_PGCECLSS	CHAR	2	0	HESA: PGCE - Classification of UG Degree	T7PIQ_GB_PGCECL
28	PREVINST	☐	PIQ_GB_HESA_PREVINST	CHAR8	CHAR	8	0	HESA: Previous Institution attended
29	EMPLOYER	☐	PIQ_GB_HESA_EMPLOYER	XFELD	CHAR	1	0	HESA: Major Source of Tuition Fee is Student's Employer
30	FEINSTID	☐	PIQ_GB_HESA_FEINSTID	PIQ_GB_HESA_FEINSTID	CHAR	7	0	HESA: Further Education Institution Identifier	T7PIQ_GB_FEINS
31	DHREGREF2	☐	PIQ_GB_UCAS_DHREGREF2	PIQ_GB_UCAS_DHREGREF2	CHAR	8	0	HESA: Regulatory Body Reference No. allocated to a Student
32	PARED	☐	PIQ_GB_UCAS_PARED	PIQ_GB_UCAS_PARED	CHAR	1	0	UCAS: Parental Education
33	POSTCODE	☐	PIQ_GB_UCAS_POSTCODE	PIQ_GB_UCAS_POSTCODE	CHAR	8	0	UCAS: Postcode prior to entry
34	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	HRI1782	DOM_COUNC	T005E	COUNC	REF	1	CN
2	HRI1782	DOM_COUNTRY	T005	LAND1	KEY	1	CN
3	HRI1782	DOM_COUNTY	T005S	BLAND	KEY	1	CN
4	HRI1782	FEEELIG	T7PIQ_GB_FEEEL	FEEEL	REF	1	CN
5	HRI1782	FEE_PAYER_CODE	T7PIQ_GB_FEES	FEE_PAYER_CODE		1	CN
6	HRI1782	FEINSTID	T7PIQ_GB_FEINS	FEINST	REF
7	HRI1782	INSTHE	T7PIQ_GB_INST_HE	INSTID	KEY	1	CN
8	HRI1782	LEA	T7PIQ_GB_LEA	LEA	KEY	1	CN
9	HRI1782	NHSEMP	T7PIQ_GB_NHSEMP	NHSEMP	REF	1	CN
10	HRI1782	PGCECLSS	T7PIQ_GB_PGCECL	PGCECLSS	REF	1	CN
11	HRI1782	PGCESBJ1	T7PIQ_GB_SBJ	SBJ	REF	1	CN
12	HRI1782	PGCESBJ2	T7PIQ_GB_SBJ	SBJ	REF	1	CN
13	HRI1782	PGCESBJ3	T7PIQ_GB_SBJ	SBJ
14	HRI1782	QUALENT2	T7PIQ_GB_HQUAL	QUALENT2	REF	1	CN
15	HRI1782	RESID_CAT	T7PIQ_GB_RCAT	RESID_CAT	KEY	1	CN
16	HRI1782	SCHOOL_NO	T7PIQ_GB_SCHOOL	SCHOOL_ID	REF	1	CN
17	HRI1782	SOCIO_EC_CLASS	T7PIQ_GB_SCECCL	SOCIO_EC_CLASS	REF	1	CN
18	HRI1782	SPCSTU	T7PIQ_GB_SPSTU	SPCSTU	REF	1	CN
19	HRI1782	TTACOM	T7PIQ_GB_TTCACO	TTACCOM	REF	1	CN
20	HRI1782	TTCID	T7PIQ_GB_TTCID	TTCID	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in