SAP ABAP Table Q1785 (Screen Fields for Infotype 1785 (EBL School Results))

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	Q1785	Table Relationship Diagram
Short Description	Screen Fields for Infotype 1785 (EBL School Results)

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	RESULT_FINAL	☐	PIQ_GB_UCAS_RESULT_FINAL	CHAR1	CHAR	1	0	CM UCAS: Final EBL Results
2	RESULT_PREV	☐	PIQ_GB_UCAS_RESULT_PREV	CHAR1	CHAR	1	0	CM UCAS: Previous EBL Results
3	SCHOOL_SHORT	☐	PIQ_GB_UCAS_SCHOOL_SHORT	CHAR12	CHAR	12	0	CM UCAS: Marvin Code School/Institution
4	SCHOOL_LONG	☐	PIQ_GB_UCAS_SCHOOL_LONG	CHAR40	CHAR	40	0	CM UCAS: School/Institution description
5	BTEC_FLAG	☐	PIQ_GB_UCAS_BTEC_CB	CHAR1	CHAR	1	0	UCAS: BTEC
6	IRISH_FLAG	☐	PIQ_GB_UCAS_IRISH_FLAG_CB	CHAR1	CHAR	1	0	UCAS: Irish Leaving Certification Flag
7	SQA_FLAG	☐	PIQFLAG	FLAG	CHAR	1	0	General Indicator
8	OTHER_EXAM	☐	PIQ_GB_UCAS_OTHER_RESULTS_CB	CHAR1	CHAR	1	0	UCAS: Other A/AS/Highers/CSYS Flag
9	SUBJECT_EBL	☐	PIQ_GB_UCAS_SUBJ_EBL	PIQ_GB_UCAS_SUBJ_EBL	CHAR	3	0	CM UCAS: EBL Subject Code	*
10	SUBJECT_SHORT	☐	SHORT_D	TEXT12	CHAR	12	0	Object Abbreviation
11	SUBJECT_LONG	☐	PIQSUBTEXT	TEXT40	CHAR	40	0	Object Description
12	POINTS	☐	PIQ_GB_UCAS_POINTS	NUMC3	NUMC	3	0	CM UCAS: No of points
13	ACHIEVED_YES	☐	PIQ_GB_UCAS_ACHIEVED1	CHAR1	CHAR	1	0	UCAS: The record of the achievement exists
14	ACHIEVED_NO	☐	IQ_GB_UCAS_ACHIEVED2	CHAR1	CHAR	1	0	UCAS: No record of achievement exists
15	ACHIEVED_NA	☐	PIQ_GB_UCAS_ACHIEVED3	CHAR1	CHAR	1	0	***CM UCAS:
16	QUALITYT	☐	PIQ_GB_UCAS_GRADE_TYPET	TEXT50	CHAR	50	0	UCAS: Qualification
17	EXAM_BAOARDT	☐	PIQ_GB_UCAS_EX_BOARDT	TEXT50	CHAR	50	0	UCAS: Exam Board Name
18	POINTS_TOT	☐	PIQ_GB_UCAS_POINTS_TOT	PIQ_GB_UCAS_POINTS_TOT	DEC	4	0	UCAS: Total number of points
19	POINTS_A_AS	☐	PIQ_GB_UCAS_POINTS_A_AS	PIQ_GB_UCAS_POINTS_A_AS	DEC	4	0	UCAS: Number of Points Scored in GCE A/AS
20	POINTS_VCE	☐	PIQ_GB_UCAS_POINTS_VCE	PIQ_GB_UCAS_POINTS_A_AS	DEC	4	0	UCAS: Number of Points Scored in VCE A/AS/Double
21	POINTS_SH	☐	PIQ_GB_UCAS_POINTS_SH	PIQ_GB_UCAS_POINTS_SH	DEC	4	0	UCAS: Number of Points in Scottish Highers + Advanced Higher
22	.INCLUDE	☐				0	0	UCAS: HESA transmitted Tariff Scores
23	GCEASN	☐	PIQ_GB_UCAS_TR_GCEASN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of GCE AS level
24	GCEASTS	☐	PIQ_GB_UCAS_TR_GCEASTS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff Score for GCE AS Level
25	VCEASN	☐	PIQ_GB_UCAS_TR_VCEASN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of VCE AS level
26	VCEASTS	☐	PIQ_GB_UCAS_TR_VCEASTS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff Score for VCE AS Level
27	GCEAN	☐	PIQ_GB_UCAS_TR_GCEAN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of GCE A level
28	GCEATS	☐	PIQ_GB_UCAS_TR_GCEATS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff Score for GCE A Level
29	VCEAN	☐	PIQ_GB_UCAS_TR_VCEAN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of VCE A level
30	VCEATS	☐	PIQ_GB_UCAS_TR_VCEATS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff Score for VCE A Level
31	KSQN	☐	PIQ_GB_UCAS_TR_KSQN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of Key Skills
32	KSQTS	☐	PIQ_GB_UCAS_TR_KSQTS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff score for Key Skills qualification
33	UKSAN	☐	PIQ_GB_UCAS_TR_UKSAN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of 1-unit award Key Skills
34	UKSATS	☐	PIQ_GB_UCAS_TR_UKSATS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff score for 1-unit key skills award
35	SAHN	☐	PIQ_GB_UCAS_TR_SAHN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of Scottish Advanced Higher
36	SAHTS	☐	PIQ_GB_UCAS_TR_SAHTS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff score for Scottish Advanced Higher
37	SHN	☐	PIQ_GB_UCAS_TR_SHN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of Scottish Higher
38	SHTS	☐	PIQ_GB_UCAS_TR_SHTS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff score for Scottish Higher
39	SI2N	☐	PIQ_GB_UCAS_TR_SI2N	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of Scottish Intermediate
40	SI2TS	☐	PIQ_GB_UCAS_TR_SI2TS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff score for Scottish Intermediate 2
41	SSGCN	☐	PIQ_GB_UCAS_TR_SSGCN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of Scottish Standard Grade Credit
42	SSGCTS	☐	PIQ_GB_UCAS_TR_SSGCTS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff score for Scottish Standard Grade Credit
43	SCSN	☐	PIQ_GB_UCAS_TR_SCSN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of Scottish Core Skills
44	SCSTS	☐	PIQ_GB_UCAS_TR_SCSTS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff score for Scottish Core Skills
45	AEAN	☐	PIQ_GB_UCAS_TR_AEAN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of Advanced Extension Awards
46	AEANTS	☐	PIQ_GB_UCAS_TR_AEANTS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff score for Advanced Extension Awards
47	TOTALTS	☐	PIQ_GB_UCAS_TR_TOTALTS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Total Tariff Score
48	CACHEN	☐	PIQ_GB_UCAS_TR_CACHEN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of CACHE qualifications
49	CACHETS	☐	PIQ_GB_UCAS_TR_CACHETS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff Score for CACHE qualifications
50	BTECN	☐	PIQ_GB_UCAS_TR_BTECN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of BTEC National
51	BTECTS	☐	PIQ_GB_UCAS_TR_BTECTS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff Score for BTEC National
52	IBTS	☐	PIQ_GB_UCAS_TR_IBTS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff Score for International Baccalaureate
53	ILCTS	☐	PIQ_GB_UCAS_TR_ILCTS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff Score for Irish Leaving Certificate
54	MDPATS	☐	PIQ_GB_UCAS_TR_MDPATS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff Score for Music, Drama, Performing Arts

History

Last changed by/on	SAP	20130529
SAP Release Created in