SAP ABAP Table HRI1785 (UCAS: Infotype 1785)

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	HRI1785	Table Relationship Diagram
Short Description	UCAS: Infotype 1785

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	STATUS	☐	PIQ_GB_UCAS_RESULT_STATUS	PIQ_GB_UCAS_RESULT_STATUS	CHAR	1	0	UCAS: Flag for previous/final results
2	MATCH_IND	☐	PIQ_GB_UCAS_MATCH_INDC	PIQ_GB_UCAS_MATCH_INDC	CHAR	1	0	UCAS: Match indicator	T7PIQ_GB_MATCH
3	EXTORGID	☐	PIQEXTORGID	HROBJID	NUMC	8	0	External Organization ID	*
4	SUMMER_GCE_A_AS	☐	PIQ_GB_UCAS_GCE_A_AS	PIQ_GB_UCAS_NO_RESULTS	NUMC	1	0	UCAS: No. of Summer GCE A/AS-Levels
5	SUMMER_A	☐	PIQ_GB_UCAS_SUMMER_A	PIQ_GB_UCAS_NO_RESULTS	NUMC	1	0	UCAS: No. of Summer (revised do not use)
6	SUMMER_VCE_A_AS	☐	PIQ_GB_UCAS_VCE_A_AS_DB	PIQ_GB_UCAS_NO_RESULTS	NUMC	1	0	UCAS: No. of Summer VCE AS/A-Levels and Doubles
7	SUMMER_AS	☐	PIQ_GB_UCAS_SUMMER_AS	PIQ_GB_UCAS_NO_RESULTS	NUMC	1	0	UCAS: No. of Summer (revised do not use)
8	WINTER_A	☐	PIQ_GB_UCAS_WINTER_A	PIQ_GB_UCAS_NO_RESULTS	NUMC	1	0	UCAS: No. of Winter A-Levels
9	PREV_SUMMER_RES	☐	PIQ_GB_UCAS_PREV_RESULTS	PIQ_GB_UCAS_NO_RESULTS	NUMC	1	0	UCAS: No. of previous (revised do not use)
10	PREV_SUMMER_A	☐	PIQ_GB_UCAS_PREV_A	PIQ_GB_UCAS_NO_RESULTS	NUMC	1	0	UCAS: No. of previous Summer A-Levels
11	PREV_AS	☐	PIQ_GB_UCAS_PREV_AS	PIQ_GB_UCAS_NO_RESULTS	NUMC	1	0	UCAS: No. of previous AS-Levels
12	HIGHERS	☐	PIQ_GB_UCAS_HIGHERS	PIQ_GB_UCAS_NO_RESULTS	NUMC	1	0	CM UCAS: No of Highers (revised do not use)
13	CSYS	☐	PIQ_GB_UCAS_CSYS	PIQ_GB_UCAS_NO_RESULTS	NUMC	1	0	CM UCAS: No of CSYS (revised do not use)
14	BTEC_FLAG	☐	PIQ_GB_UCAS_BTEC	PIQ_GB_UCAS_BTEC	CHAR	1	0	UCAS: BTEC Flag
15	HIG_FLAG	☐	PIQ_GB_UCAS_HHIQ_FLAG	PIQ_GB_UCAS_HHIQ_FLAG	CHAR	1	0	UCAS: HSC/IBAC Flag	T7PIQ_GB_HSC
16	IRISH_FLAG	☐	PIQ_GB_UCAS_IRISH_FLAG	PIQ_GB_UCAS_IRISH_FLAG	CHAR	1	0	UCAS: Irish Leaving Certification Flag
17	OTHER_RESULTS	☐	PIQ_GB_UCAS_OTHER_RESULTS	PIQ_GB_UCAS_OTHER_RESULTS	CHAR	1	0	UCAS: Other A/AS/Highers/CSYS Flag
18	REC_ACHIEVMNT	☐	PIQ_GB_UCAS_REC_ACHIEVMNT	PIQ_GB_UCAS_REC_ACHIEVMNT	CHAR	1	0	UCAS: Record of Achievement
19	REG_NUMBER	☐	PIQ_GB_UCAS_REG_NUM	PIQ_GB_UCAS_REG_NUM	CHAR	13	0	UCAS: BTEC/SQA Scottish Cand. Number
20	QEQ	☐	PIQ_GB_UCAS_QEQ	PIQ_GB_UCAS_QEQ	CHAR	1	0	UCAS: OEQ Flag	T7PIQ_GB_QEQ
21	SQA_FLAG	☐	PIQ_GB_UCAS_SQA_FLAG	PIQ_GB_UCAS_SQA_FLAG	CHAR	1	0	UCAS: Flag SQA applicant
22	GCEASN	☐	PIQ_GB_UCAS_TR_GCEASN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of GCE AS level
23	GCEASTS	☐	PIQ_GB_UCAS_TR_GCEASTS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff Score for GCE AS Level
24	VCEASN	☐	PIQ_GB_UCAS_TR_VCEASN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of VCE AS level
25	VCEASTS	☐	PIQ_GB_UCAS_TR_VCEASTS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff Score for VCE AS Level
26	GCEAN	☐	PIQ_GB_UCAS_TR_GCEAN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of GCE A level
27	GCEATS	☐	PIQ_GB_UCAS_TR_GCEATS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff Score for GCE A Level
28	VCEAN	☐	PIQ_GB_UCAS_TR_VCEAN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of VCE A level
29	VCEATS	☐	PIQ_GB_UCAS_TR_VCEATS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff Score for VCE A Level
30	KSQN	☐	PIQ_GB_UCAS_TR_KSQN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of Key Skills
31	KSQTS	☐	PIQ_GB_UCAS_TR_KSQTS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff score for Key Skills qualification
32	UKSAN	☐	PIQ_GB_UCAS_TR_UKSAN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of 1-unit award Key Skills
33	UKSATS	☐	PIQ_GB_UCAS_TR_UKSATS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff score for 1-unit key skills award
34	SAHN	☐	PIQ_GB_UCAS_TR_SAHN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of Scottish Advanced Higher
35	SAHTS	☐	PIQ_GB_UCAS_TR_SAHTS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff score for Scottish Advanced Higher
36	SHN	☐	PIQ_GB_UCAS_TR_SHN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of Scottish Higher
37	SHTS	☐	PIQ_GB_UCAS_TR_SHTS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff score for Scottish Higher
38	SI2N	☐	PIQ_GB_UCAS_TR_SI2N	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of Scottish Intermediate
39	SI2TS	☐	PIQ_GB_UCAS_TR_SI2TS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff score for Scottish Intermediate 2
40	SSGCN	☐	PIQ_GB_UCAS_TR_SSGCN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of Scottish Standard Grade Credit
41	SSGCTS	☐	PIQ_GB_UCAS_TR_SSGCTS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff score for Scottish Standard Grade Credit
42	SCSN	☐	PIQ_GB_UCAS_TR_SCSN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of Scottish Core Skills
43	SCSTS	☐	PIQ_GB_UCAS_TR_SCSTS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff score for Scottish Core Skills
44	AEAN	☐	PIQ_GB_UCAS_TR_AEAN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of Advanced Extension Awards
45	AEANTS	☐	PIQ_GB_UCAS_TR_AEANTS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff score for Advanced Extension Awards
46	TOTALTS	☐	PIQ_GB_UCAS_TR_TOTALTS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Total Tariff Score
47	CACHEN	☐	PIQ_GB_UCAS_TR_CACHEN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of CACHE qualifications
48	CACHETS	☐	PIQ_GB_UCAS_TR_CACHETS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff Score for CACHE qualifications
49	BTECN	☐	PIQ_GB_UCAS_TR_BTECN	PIQ_GB_UCAS_TR_NUM	NUMC	1	0	CM UCAS: Number of BTEC National
50	BTECTS	☐	PIQ_GB_UCAS_TR_BTECTS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff Score for BTEC National
51	IBTS	☐	PIQ_GB_UCAS_TR_IBTS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff Score for International Baccalaureate
52	ILCTS	☐	PIQ_GB_UCAS_TR_ILCTS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff Score for Irish Leaving Certificate
53	MDPATS	☐	PIQ_GB_UCAS_TR_MDPATS	PIQ_GB_UCAS_TR_SCORE	NUMC	3	0	CM UCAS: Tariff Score for Music, Drama, Performing Arts
54	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	HRI1785	HIG_FLAG	T7PIQ_GB_HSC	HIG_FLAG	REF	1	CN
2	HRI1785	MATCH_IND	T7PIQ_GB_MATCH	MATCH_INDC	REF	1	CN
3	HRI1785	QEQ	T7PIQ_GB_QEQ	QEQ	REF	1	CN

History

Last changed by/on	SAP	20090218
SAP Release Created in