PIQDB_DE_REPGRD - Graduation in the reporting semester

Graduation in the reporting semester information is stored in SAP table PIQDB_DE_REPGRD.
It is part of development package PMIQ_DE_STAT_REPORTING in software component IS-HER-CM. This development package consists of objects that can be grouped under "Statistical Reporting".

Fields for table PIQDB_DE_REPGRD

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	PIQDB_DE_SXSTATD
RUNID	Run Identifier	X	PIQ_DE_RUNID	CHAR	64	PIQDB_DE_SXSTATD
ST_OBJID	Object ID of Student	X	PIQSTUDENT	NUMC	16
PROGNR	Program Number	X	PIQ_DE_PROGNR	NUMC	2
.INCLUDE				PIQ_DE_GRD	0
GRDOFFICE	Graduation Office		PIQ_DE_GRDOFFICE	NUMC	14
SUBJECTSEM	Subject Semesters		PIQ_DE_SESSCNT_SUBJ_C	NUMC	4
SUBJECTSEMSUM	Subject Semesters		PIQ_DE_SESSCNT_SUBJ_C	NUMC	4
ACKSEM_DE	Accepted Subject Semesters from Another German University		PIQ_DE_SESSCNT_ACKDE_C	NUMC	2
ACKSEM_EMPL	Accepted Subject Semesters from Work Experience		PIQ_DE_SESSCNT_ACKEMPL_C	NUMC	2
ACKSEM_FRGN	Accepted Subject Semesters from Study Abroad		PIQ_DE_SESSCNT_ACKFRGN_C	NUMC	2
EXAMTYPE	Awarded Degree		PIQ_DE_AW_DEGREE	CHAR	6
SUBJECT1	Subject Code 1		PIQ_DE_SUBCODE1	CHAR	6	*
SUBJECT2	Subject Code 2		PIQ_DE_SUBCODE2	CHAR	6	*
SUBJECT3	Subject Code 3		PIQ_DE_SUBCODE3	CHAR	6	*
STALA_1	Available for State Statistical Agency Use		PIQ_DE_LAC3	CHAR	6
STALA_2	Available for State Statistical Agency Use		PIQ_DE_LAC4	CHAR	8
GRAD_MONTH	Month of Graduation Exam		PIQ_DE_GRAD_MONTH	NUMC	4
GRAD_YEAR	Year of Graduation Exam		PIQ_DE_GRAD_YEAR	NUMC	8
GRAD_RESULT	Graduation Exam Result		PIQ_DE_GRADRESULT	CHAR	2
GRADE	Total Grade		PIQ_DE_GRADE_TOT2	CHAR	6
GRADE_POINTS	Graduation Point		PIQ_DE_GRAD_POINT	CHAR	8
CP_TOTAL	Total Credits Earned and Acknowledged		PIQ_DE_CP_TOTAL	NUMC	6
CP_ACK_DE	Credits Acknowledged from Experiences in Germany		PIQ_DE_CP_ACK_DE	NUMC	6
CP_ACK_FR	Credits Acknowledged from Experiences outside Germany		PIQ_DE_CP_ACK_FR	NUMC	6
FR_EXP1_COUNTRY	Country/Region Code		PIQ_DE_COUNTRY	CHAR	6
FR_EXP1_DURATION	Duration of Professional Experience outside Germany		PIQ_DE_EXP_DURATION	CHAR	4	*
FR_EXP1_TYPE	Type of Professional Experience Outside Germany		PIQ_DE_EXP_TYPE	CHAR	4	*
FR_EXP1_PROGRAM_TYPE	Type of Mobility Program		PIQ_DE_MOBILITY_PROG_TYPE	CHAR	4	*
FR_EXP2_COUNTRY	Country/Region Code		PIQ_DE_COUNTRY	CHAR	6
FR_EXP2_DURATION	Duration of Professional Experience outside Germany		PIQ_DE_EXP_DURATION	CHAR	4	*
FR_EXP2_TYPE	Type of Professional Experience Outside Germany		PIQ_DE_EXP_TYPE	CHAR	4	*
FR_EXP2_PROGRAM_TYPE	Type of Mobility Program		PIQ_DE_MOBILITY_PROG_TYPE	CHAR	4	*
FR_EXP3_COUNTRY	Country/Region Code		PIQ_DE_COUNTRY	CHAR	6
FR_EXP3_DURATION	Duration of Professional Experience outside Germany		PIQ_DE_EXP_DURATION	CHAR	4	*
FR_EXP3_TYPE	Type of Professional Experience Outside Germany		PIQ_DE_EXP_TYPE	CHAR	4	*
FR_EXP3_PROGRAM_TYPE	Type of Mobility Program		PIQ_DE_MOBILITY_PROG_TYPE	CHAR	4	*
PHD_PROG_TYPE	Post Graduate Doctoral Study Type		PIQ_DE_PHD_PROG_TYPE	CHAR	4	*
STUDY_DURATION	Regular Duration of Study		PIQ_DE_STUDY_DURATION	NUMC	4
STALA_3	Available for State Statistical Agency Use		PIQ_DE_LAC2	CHAR	4
STALA_4	Available for State Statistical Agency Use		PIQ_DE_LAC2	CHAR	4
STALA_5	Available for State Statistical Agency Use		PIQ_DE_LAC2	CHAR	4
STALA_6	Available for State Statistical Agency Use		PIQ_DE_LAC1	CHAR	2
STALA_7	Available for State Statistical Agency Use		PIQ_DE_LAC1	CHAR	2
STALA_8	Available for State Statistical Agency Use		PIQ_DE_LAC1	CHAR	2
.INCLUDE				CI_SX_GRD	0
.INCLUDE				PIQ_DE_GRD_OBJ	0
CQ_OBJID	Internal Qualification Identification (ID)		PIQCQOBJID	NUMC	16	*
.INCLUDE				PIQ_DE_REG_OBJ	0
CS_OBJID	Object ID of Study Object (CS)		PIQCSOBJID	NUMC	16	*
CG_OBJID1	Module Group ID		PIQCGOBJID	NUMC	16	*
CG_OBJID2	Module Group ID		PIQCGOBJID	NUMC	16	*
CG_OBJID3	Module Group ID		PIQCGOBJID	NUMC	16	*
.INCLUDE				CI_REPREG	0
CORR_RUN_TMSTP	Correction Run Timestamp		PIQ_DE_RUNTS_CORR	DEC	8