SAP ABAP Table P1782 (Infotype 1782: HESA/UCAS 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	P1782	Table Relationship Diagram
Short Description	Infotype 1782: HESA/UCAS 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	.INCLUDE	☐				0	0	Key Structure for Infotype Structures PNNNN
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	PLVAR	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	T778P
4	OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	T778O
5	OBJID	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
6	INFTY	☐	INFOTYP	INFOTYP	CHAR	4	0	Infotype	T778T
7	SUBTY	☐	SUBTYP	SUBTYP	CHAR	4	0	Subtype	*
8	ISTAT	☐	ISTAT_D	ISTAT	CHAR	1	0	Planning Status	T778S
9	PRIOX	☐	PRIOX	CHAR2	CHAR	2	0	Priority
10	BEGDA	☐	BEGDATUM	DATUM	DATS	8	0	Start Date
11	ENDDA	☐	ENDDATUM	DATUM	DATS	8	0	End Date
12	VARYF	☐	VARYF	CHAR10	CHAR	10	0	Variation Field for File PLOG
13	SEQNR	☐	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
14	.INCLUDE	☐				0	0	Infotype Administration Data
15	AEDTM	☐	AEDTM	DATUM	DATS	8	0	Changed on
16	UNAME	☐	USRNAME	CHAR12	CHAR	12	0	User Name
17	REASN	☐	REASN	CHAR2	CHAR	2	0	Reason
18	HISTO	☐	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
19	ITXNR	☐	ITXNR	NUM08	NUMC	8	0	Text Module for Infotype
20	.INCLUDE	☐				0	0	UCAS/HESA Student Data (GB)
21	RESID_CAT	☐	PIQ_GB_UCAS_RESID_CAT	PIQ_GB_UCAS_RESID_CAT	CHAR	1	0	UCAS: Residential category	T7PIQ_GB_RCAT
22	DOM_COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
23	DOM_COUNTY	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
24	DOM_COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
25	INSTHE	☐	PIQ_GB_HESA_INSTHE	PIQ_GB_HESA_INSTID	NUMC	4	0	HESA: HE institution last attended	T7PIQ_GB_INST_HE
26	SCHOOL	☐	PIQ_GB_UCAS_DFE_ID	CHAR7	CHAR	7	0	UCAS: DFE number	*
27	YRLLINST	☐	PIQ_GB_HESA_YRLLINST		NUMC	4	0	Year left last institution
28	LEA	☐	PIQ_GB_UCAS_LEA	PIQ_GB_UCAS_LEA	NUMC	3	0	UCAS: LEA code	T7PIQ_GB_LEA
29	FEE_PAYER_CODE	☐	PIQ_GB_UCAS_FEE_PAYER	PIQ_GB_UCAS_FEE_PAYER	NUMC	2	0	UCAS: Fee Payer Code	T7PIQ_GB_FEES
30	SOCIO_EC_CLASS	☐	PIQ_GB_UCAS_SOCIO_EC_CLASS	PIQ_GB_UCAS_SOCIO_EC_CLASS	CHAR	1	0	UCAS: Socioeconomic Class	T7PIQ_GB_SCECCL
31	UCAS_NO	☐	PIQ_UCAS_GB_APPLICANT_ID	PIQ_GB_UCAS_APPLICANT_ID	NUMC	9	0	UCAS: UCAS Number
32	HUSID	☐	PIQ_GB_HESA_HUSID		NUMC	13	0	HESA Student Identifier
33	TREFNO	☐	PIQ_GB_UCAS_TREFNO	PIQ_GB_UCAS_TREFNO	CHAR	9	0	UCAS: Teacher Reference Number
34	DHREGREF	☐	PIQ_GB_UCAS_DHREGREF	PIQ_GB_UCAS_DHREGREF	NUMC	9	0	HESA: Regulatory Body Reference (revised)
35	QUALENT2	☐	PIQ_GB_UCAS_QUALENT2	PIQ_GB_UCAS_QUALENT2	NUMC	2	0	HESA: Highest Qualification on Entry	T7PIQ_GB_HQUAL
36	FEEELIG	☐	PIQ_GB_UCAS_FEEELIG	PIQ_GB_UCAS_FEEELIG	CHAR	1	0	UCAS: Fee Eligibility	T7PIQ_GB_FEEEL
37	SPCSTU	☐	PIQ_GB_UCAS_SPCSTU	PIQ_GB_UCAS_SPCSTU	CHAR	1	0	HESA: Special Students	T7PIQ_GB_SPSTU
38	TTACOM	☐	PIQ_GB_UCAS_TTACOM	PIQ_GB_UCAS_TTACOM	CHAR	1	0	HESA: Term Time Accommodation	T7PIQ_GB_TTCACO
39	SCHOOL_NO	☐	PIQ_GB_UCAS_SCHOOL	PIQ_GB_UCAS_SCHOOL	CHAR	7	0	UCAS: School Number	T7PIQ_GB_SCHOOL
40	SABAT	☐	PIQ_GB_HESA_SABAT	XFELD	CHAR	1	0	HESA: Flag Student as sabbatical
41	ENTRYCDE	☐	PIQ_GB_HESA_ENTRYCDE	PIQ_GB_HESA_ENTRYCDE	NUMC	1	0	HESA: New Entrant to HE
42	TTCID	☐	PIQ_GB_HESA_TTCID	PIQ_GB_HESA_TTCID	NUMC	1	0	HESA: Teacher Training Course Identifier	T7PIQ_GB_TTCID
43	NHSEMP	☐	PIQ_GB_HESA_NHSEMP	PIQ_GB_HESA_NHSEMP	CHAR	5	0	HESA: NHS Employer	T7PIQ_GB_NHSEMP
44	PGCESBJ1	☐	PIQ_GB_HESA_PGCESBJ1	PIQ_GB_HESA_SBJ	CHAR	4	0	HESA: PGCE - Subject 1 of UG Degree	T7PIQ_GB_SBJ
45	PGCESBJ2	☐	PIQ_GB_HESA_PGCESBJ2	PIQ_GB_HESA_SBJ	CHAR	4	0	HESA: PGCE - Subject 2 of UG Degree	T7PIQ_GB_SBJ
46	PGCESBJ3	☐	PIQ_GB_HESA_PGCESBJ3	PIQ_GB_HESA_SBJ	CHAR	4	0	HESA: Subject 3 of UG Degree	T7PIQ_GB_SBJ
47	PGCECLSS	☐	PIQ_GB_HESA_PGCECLSS	PIQ_GB_HESA_PGCECLSS	CHAR	2	0	HESA: PGCE - Classification of UG Degree	T7PIQ_GB_PGCECL
48	PREVINST	☐	PIQ_GB_HESA_PREVINST	CHAR8	CHAR	8	0	HESA: Previous Institution attended
49	EMPLOYER	☐	PIQ_GB_HESA_EMPLOYER	XFELD	CHAR	1	0	HESA: Major Source of Tuition Fee is Student's Employer
50	FEINSTID	☐	PIQ_GB_HESA_FEINSTID	PIQ_GB_HESA_FEINSTID	CHAR	7	0	HESA: Further Education Institution Identifier	T7PIQ_GB_FEINS
51	DHREGREF2	☐	PIQ_GB_UCAS_DHREGREF2	PIQ_GB_UCAS_DHREGREF2	CHAR	8	0	HESA: Regulatory Body Reference No. allocated to a Student
52	PARED	☐	PIQ_GB_UCAS_PARED	PIQ_GB_UCAS_PARED	CHAR	1	0	UCAS: Parental Education
53	POSTCODE	☐	PIQ_GB_UCAS_POSTCODE	PIQ_GB_UCAS_POSTCODE	CHAR	8	0	UCAS: Postcode prior to entry
54	.INCLUDE	☐				0	0

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in