SAP ABAP Table HRT1719 (Table Section for Infotype 1719)

Hierarchy

☛ IS-PS-CA (Software Component) IS-PUBLIC SECTOR CONTRACT ACCOUNTING
   ⤷ IS-HER-CM-AD (Application Component) Administration
     ⤷ PMIQ (Package) Campus Management

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	HRT1719	Table Relationship Diagram
Short Description	Table Section for Infotype 1719

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	TABNR	☑	HRTABNR	HRTABNR	CHAR	32	0	Reference Number to Table Part	HRITABNR
3	TABSEQNR	☑	HRTABSEQNR	NUM06	NUMC	6	0	Sequence Number in Table Part of Table Infotype
4	.INCLUDE	☐				0	0	Infotype 1719: Table Section for Ext. Transcripts
5	DATATYPE	☐	PIQTRDATATYPE	PIQTRDATATYPE	NUMC	2	0	Record Type
6	.INCLUDE	☐				0	0	External Academic Qualifications
7	DEGREENR	☐	PIQTRDEGREENR		NUMC	2	0	Number of Degree/Qualification
8	DEGREEID	☐	PIQTRDEGREEID	HROBJID	NUMC	8	0	Degree/Qualification	*
9	PROGRAMID	☐	PIQTRPROGRAMID		CHAR	12	0	Registered Program
10	DEGERNFLAG	☐	PIQTRDEGERNFLAG	PIQTRDEGERNFLAG	CHAR	1	0	Indicator: Degree or Qualification Earned
11	DEGDATE	☐	PIQTRDEGDATE		DATS	8	0	(Anticipated) Completion Date
12	DEGEXTGRADE	☐	PIQTRDEGEXTMARK		CHAR	10	0	External Grade Achieved in Qualification
13	DEGEXTGRADENORM	☐	PIQTRDEGEXTGRADENORM	PIQSCALE_NORM_VAL	DEC	8	2	External Grade of Achieved Qualification (Std Value)
14	DEGEXTSCALEID	☐	PIQSCALE_ID	PIQSCALE_ID	CHAR	4	0	Academic Scale Identification (ID)	T7PIQSCALE
15	DEGMANFLAG	☐	PIQTRDEGMANFLAG		CHAR	1	0	Overwrite Internal Grade of Qualification Manually
16	DEGINTGRADE	☐	PIQTRDEGINTGRADE		CHAR	10	0	Internal Grade of Achieved Qualification
17	DEGINTGRADENORM	☐	PIQTRDEGINTGRADENORM	PIQSCALE_NORM_VAL	DEC	8	2	Internal Grade of Achieved Qualification (Std Value)
18	DEGINTSCALEID	☐	PIQSCALE_ID	PIQSCALE_ID	CHAR	4	0	Academic Scale Identification (ID)	T7PIQSCALE
19	DEGHONORS	☐	PIQTRDEGHONORS	PIQTRDEGHONORS	CHAR	4	0	Academic Honors in Qualification	T7PIQTRDEGHON
20	.INCLUDE	☐				0	0	External Academic Specializations
21	SPECDEGREENR	☐	PIQTRDEGREENR		NUMC	2	0	Number of Degree/Qualification
22	SPECID	☐	PIQTRDEGSPECID	PIQSMDISZIP	CHAR	16	0	Chosen Program Specialization	T7PIQSMDISZIP
23	SPECTYPE	☐	PIQTRDEGSPECTYPE	PIQMODGRPCAT	CHAR	4	0	Specialization Type	T7PIQMODGRPCAT
24	.INCLUDE	☐				0	0	Academic Session Data of External Organization
25	SESSIONID	☐	PIQTRSESSIONID	PIQTRSESSIONID	CHAR	4	0	External Academic Session	T7PIQTREXTSES
26	SESSIONYEAR	☐	PIQTRSESSIONYEAR	PIQTRSESSIONYEAR	NUMC	4	0	Year of Registration
27	SESBEGDATE	☐	PIQTRSESBEGDATE		DATS	8	0	Start Date of Academic Session
28	SESENDDATE	☐	PIQTRSESENDDATE		DATS	8	0	End Date of Academic Session
29	SESWITHDRDATE	☐	PIQTRSESWITHDRDATE		DATS	8	0	De-registration Date
30	SESDEGREEID	☐	PIQTRDEGREEID	HROBJID	NUMC	8	0	Degree/Qualification	*
31	SESPROGRAMID	☐	PIQTRPROGRAMID		CHAR	12	0	Registered Program
32	STAGEID	☐	PIQTRSTAGEID	PIQLEVEL	NUMC	2	0	Registered Program Stage	T7PIQLEVEL
33	PROGCLASSID	☐	PIQTRPROGCLASSID	PIQPROGCLASS	CHAR	4	0	Progress Classification	T7PIQPROGCLASS
34	PROGACST	☐	PIQTRPROGACST	PIQTRPROGACST	CHAR	4	0	External Academic Standing	T7PIQTRPROGAS
35	PROGSTAT	☐	PIQPROGSTATUS	PIQPROGSTATUS	NUMC	3	0	Program Progression Status	T7PIQPROGSTATUS
36	EXTSESGPA	☐	PIQTREXTSESGPA		CHAR	10	0	External Sessional Average
37	EXTSESGPANORM	☐	PIQTREXTSESGPANORM	PIQSCALE_NORM_VAL	DEC	8	2	Original Sessional Average Standard Value)
38	EXTSESGPASCALE	☐	PIQTREXTSESGPASCALE	PIQSCALE_ID	CHAR	4	0	Grading Scale for Original Sessional Average	T7PIQSCALE
39	SESGPAMANFLAG	☐	TRPIQSESGPAMANFLAG		CHAR	1	0	Overwrite Internal Sessional Average Manually
40	INTSESGPA	☐	PIQTRINTSESGPA		CHAR	10	0	Internal Sessional Average
41	INTSESGPANORM	☐	PIQTRINTSESGPANORM	PIQSCALE_NORM_VAL	DEC	8	2	Internal Sessional Average (Standard Value)
42	INTSESGPASCALE	☐	PIQTRINTSESGPASCALE	PIQSCALE_ID	CHAR	4	0	Grading Scale for Internal Sessional Average	T7PIQSCALE
43	EXTSESATMCRED	☐	PIQTREXTSESATMCRED	PIQCP	QUAN	10	5	Attempted Credits Per Academic Session
44	EXTSESGRDCRED	☐	PIQTREXTSESGRDCRED	PIQCP	QUAN	10	5	Graded Credits Per Academic Session
45	EXTSESERNCRED	☐	PIQTREXTSESERNCRED	PIQCP	QUAN	10	5	Earned Credits Per Academic Session
46	EXTSESCREDTYPE	☐	PIQTREXTSESCREDTYPE	MEINS	UNIT	3	0	External Credit Type of Sessional Credits	T7PIQCP
47	SESCREDMANFLAG	☐	PIQTRSESCREDMANFLAG		CHAR	1	0	Overwrite Converted Sessional Credits Manually
48	INTSESATMCRED	☐	PIQTRINTSESATMCRED	PIQCP	QUAN	10	5	Attempted Credits Per Session In Internal Credit Type
49	INTSESGRDCRED	☐	PIQTRINTSESGRDCRED	PIQCP	QUAN	10	5	Graded Credits Per Session In Internal Credit Type
50	INTSESERNCRED	☐	PIQTRINTSESERNCRED	PIQCP	QUAN	10	5	Earned Credits Per Session In Internal Credit Type
51	INTSESCREDTYPE	☐	PIQTRINTSESCREDTYPE	MEINS	UNIT	3	0	Credit Type of Converted Sessional Credits	T7PIQCP
52	.INCLUDE	☐				0	0	External Subject Data
53	COURSEID	☐	PIQTRCOURSEID	HROBJID	NUMC	8	0	Registered Subject	*
54	EXTGRADE	☐	PIQTREXTGRADE		CHAR	10	0	Original Grade in External Subject
55	EXTGRADENORM	☐	PIQTREXTGRADENORM	PIQSCALE_NORM_VAL	DEC	8	2	Original Grade per Subject (Standard Value)
56	EXTGRADESCALE	☐	PIQTREXTGRADESCALE	PIQSCALE_ID	CHAR	4	0	Grading Scale for Original Grade	T7PIQSCALE
57	GRADEMANFLAG	☐	PIQTRGRADEMANFLAG		CHAR	1	0	Overwrite Converted Original Grade of External Subject
58	INTGRADE	☐	PIQTRINTGRADE		CHAR	10	0	Original Grade in External Subject on Internal Grading Scale
59	INTGRADENORM	☐	PIQTRINTGRADENORM	PIQSCALE_NORM_VAL	DEC	8	2	Converted Grade per Subject (Standard Value)
60	INTGRADESCALE	☐	PIQTRINTGRADESCALE	PIQSCALE_ID	CHAR	4	0	Internal Grading Scale for Converted Grade per Subject	T7PIQSCALE
61	COREPEATFLAG	☐	PIQTRCOREPEATFLAG		CHAR	1	0	Indicator: Repeated Subject
62	HONORSINDIC	☐	PIQTRHONORSINDIC		CHAR	1	0	Indicator: Honors Subject
63	EXTCOATMCRED	☐	PIQTREXTCOATMCRED	PIQCP	QUAN	10	5	Attempted Credits in External Subject
64	EXTCOGRDCRED	☐	PIQTREXTCOGRDCRED	PIQCP	QUAN	10	5	Graded Credits in External Subject
65	EXTCOERNCRED	☐	PIQTREXTCOERNCRED	PIQCP	QUAN	10	5	Earned Credits in External Subject
66	EXTCOCREDTYPE	☐	PIQTREXTCOCREDTYPE	MEINS	UNIT	3	0	Original Credit Type of External Subject	T7PIQCP
67	COCREDMANFLAG	☐	PIQTRCOCREDMANFLAG		CHAR	1	0	Overwrite Converted Credits Per External Subject Manually
68	INTCOATMCRED	☐	PIQTRINTCOATMCRED	PIQCP	QUAN	10	5	Attempted Credits in Ext. Subject in Internal Credit Type
69	INTCOGRDCRED	☐	PIQTRINTCOGRDCRED	PIQCP	QUAN	10	5	Graded Credits in Ext. Subject in Internal Credit Type
70	INTCOERNCRED	☐	PIQTRINTCOERNCRED	PIQCP	QUAN	10	5	Earned Credits in Ext. Subject in Internal Credit Type
71	INTCOCREDTYPE	☐	PIQTRINTCOCREDTYPE	MEINS	UNIT	3	0	Internal Credit Type	T7PIQCP
72	BASFORCOCRED	☐	PIQTRBASFORCOCRED	PIQTRBASFORCRED	CHAR	4	0	Basis for Accomplished Credits	T7PIQTRBASFORCP
73	COREFLAG	☐	PIQTRCOREFLAG		CHAR	1	0	Indicator for Core Subject
74	COWITHDRDATE	☐	PIQTRCOWITHDRDATE		DATS	8	0	Date of Withdrawal
75	COSESID	☐	PIQTRCOSESID	PIQTRSESSIONID	CHAR	4	0	Session In Which External Subject Was Taken	T7PIQTREXTSES
76	COSESYEAR	☐	PIQTRCOSESYEAR	PIQTRSESSIONYEAR	NUMC	4	0	Year In Which Subject Was Taken
77	COBEGDATE	☐	PIQTRCOBEGDATE		DATS	8	0	Start Date of Subject
78	COENDDATE	☐	PIQTRCOENDDATE		DATS	8	0	End Date of Subject
79	.INCLUDE	☐				0	0	Coded Notes
80	CODEDNOTEID	☐	PIQTRCODEDNOTEID	PIQTRCODEDNOTEID	CHAR	12	0	Coded Note	T7PIQTRCODNOTE
81	COMMENTLINE	☐	PIQTRCOMMENT	TEXT80	CHAR	80	0	Comment
82	.INCLUDE	☐				0	0	User-Defined Text
83	LINENR	☐	PIQTRLINENR		NUMC	4	0	Line Number in SAP TextEdit
84	FREETEXTLINE	☐	PIQTRFREETEXTLINE	TEXT79	CHAR	79	0	Comments

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	HRT1719	BASFORCOCRED	T7PIQTRBASFORCP	BASISFORCP	KEY	1	CN
2	HRT1719	CODEDNOTEID	T7PIQTRCODNOTE	CODEDNOTEID	KEY	1	CN
3	HRT1719	COSESID	T7PIQTREXTSES	SESSIONID	KEY	1	CN
4	HRT1719	DEGEXTSCALEID	T7PIQSCALE	SCALEID	KEY	1	CN
5	HRT1719	DEGHONORS	T7PIQTRDEGHON	DEGHONORS	KEY	1	CN
6	HRT1719	DEGINTSCALEID	T7PIQSCALE	SCALEID	KEY	1	CN
7	HRT1719	EXTCOCREDTYPE	T7PIQCP	CPUNIT	KEY	1	CN
8	HRT1719	EXTGRADESCALE	T7PIQSCALE	SCALEID	KEY	1	CN
9	HRT1719	EXTSESCREDTYPE	T7PIQCP	CPUNIT	KEY	1	CN
10	HRT1719	EXTSESGPASCALE	T7PIQSCALE	SCALEID	KEY	1	CN
11	HRT1719	INTCOCREDTYPE	T7PIQCP	CPUNIT	KEY	1	CN
12	HRT1719	INTGRADESCALE	T7PIQSCALE	SCALEID	KEY	1	CN
13	HRT1719	INTSESCREDTYPE	T7PIQCP	CPUNIT	KEY	1	CN
14	HRT1719	INTSESGPASCALE	T7PIQSCALE	SCALEID	KEY	1	CN
15	HRT1719	MANDT	T000	MANDT	KEY	1	CN
16	HRT1719	PROGACST	T7PIQTRPROGAS	PROGACST
17	HRT1719	PROGCLASSID	T7PIQPROGCLASS	PROGCLASS	KEY	1	CN
18	HRT1719	PROGSTAT	T7PIQPROGSTATUS	PROGSTATUS	KEY	1	CN
19	HRT1719	SESSIONID	T7PIQTREXTSES	SESSIONID	KEY	1	CN
20	HRT1719	SPECID	T7PIQSMDISZIP	DISZIP	KEY	1	CN
21	HRT1719	SPECTYPE	T7PIQMODGRPCAT	CATEGORY	KEY	1	CN
22	HRT1719	STAGEID	T7PIQLEVEL	ACLEVEL	KEY	1	CN
23	HRT1719	TABNR	HRITABNR	TABNR	KEY	1	CN

History

Last changed by/on	SAP	20050224
SAP Release Created in	463