PIQDB_DE_SXSTATD - Student and Exam Statistics Detail Table

Student and Exam Statistics Detail Table information is stored in SAP table PIQDB_DE_SXSTATD.
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_SXSTATD

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
RUNID	Run Identifier	X	PIQ_DE_RUNID	CHAR	64
ST_OBJID	Object ID of Student	X	PIQSTUDENT	NUMC	16
STUDENT	Student Number		PIQSTUDENT12	CHAR	24
.INCLUDE	CS_REF			PIQ_DE_CS_REF	0
CS_OBJID_RD1	Study Object for Registered or Deregistered Student		PIQ_DE_CS_OBJID_RD	NUMC	16	*
CS_OBJID_RD2	Study Object for Registered or Deregistered Student		PIQ_DE_CS_OBJID_RD	NUMC	16	*
CS_OBJID_G1	Study Object for Graduation		PIQ_DE_CS_OBJID_G	NUMC	16	*
CS_OBJID_G2	Study Object for Graduation		PIQ_DE_CS_OBJID_G	NUMC	16	*
.INCLUDE				PIQ_DE_SX_STATI	0
REP_REGIO	Region		PIQ_DE_REGIO	CHAR	4
REP_PERID	Statistical Reporting Period		PIQ_DE_PERID	NUMC	2
REP_YEAR	Statistical Reporting Year		PIQ_DE_PERYR	NUMC	8
HEI	Higher Education Institution		PIQ_DE_HEI	CHAR	8	*
RECNUM	Record Number		PIQ_DE_RECNUM	NUMC	12
STUDENTNO	Student Number		PIQSTUDENT12	CHAR	24
GENDER_KEY	Gender key		AD_SEX	CHAR	2	TSAD15
BIRTH_MONTH	Month		PIQ_DE_MONTH	NUMC	4
BIRTH_YEAR	Year		PIQ_DE_YEAR	NUMC	8
NATIONALITY	DUEVO: Nationality		DUSTA	CHAR	6	*
STUDY_REGIO	Region		PIQ_DE_REGIO	CHAR	4
STUDY_COUNTY	County Code		COUNC	CHAR	6	*
STUDY_COUNTRY	DUEVO: Nationality		DUSTA	CHAR	6	*
HOME_REGIO	Region		PIQ_DE_REGIO	CHAR	4
HOME_COUNTY	County Code		COUNC	CHAR	6	*
HOME_COUNTRY	DUEVO: Nationality		DUSTA	CHAR	6	*
REGISTRATION_TYPE	Registration Type		PIQ_DE_ENRCATEG	NUMC	2
SUMMER_SEM_IND	Summer Semester		PIQ_DE_SUMSEM_IND	CHAR	4
STALA_14	Available for State Statistical Agency Use		PIQ_DE_LAC2	CHAR	4
STALA_15	Available for State Statistical Agency Use		PIQ_DE_LAC2	CHAR	4
FIRST_HEI	First Higher Education Institute		PIQ_DE_HEI_FIRST	CHAR	8	*
FIRST_PERID	Statistical Reporting Period		PIQ_DE_PERID	NUMC	2
FIRST_YEAR	First Academic Year		PIQ_DE_PERYR_FIRST	NUMC	8	*
UNIVERSITY_SEM	Number of Semesters at German Universities		PIQ_DE_SESSCNT_UNIV_C	NUMC	4
LEAVEOFABSSEM	Semesters with Leaves of Absence at German Universities		PIQ_DE_SESSCNT_LOA_C	NUMC	4
INTERNSHIPSEM	Number of Internship Semesters at Higher Education Institute		PIQ_DE_SESSCNT_INTERN_C	NUMC	4
GDRSEM	Number of Study Semesters in German Democratic Republic		PIQ_DE_SESSCNT_GDR_C	NUMC	4
GDRSEM_STUDTYP	Study Type		PIQ_DE_STUDYTYP	NUMC	2
PREPSEM	Number of Semesters at a Preparatory College		PIQ_DE_SESSCNT_PRPC_C	NUMC	2
INTERRUPTSEM	Interrupted Study Semesters		PIQ_DE_SESSCNT_INTRUPT_C	NUMC	4
PREVSEM1_HEI_IND	Higher Education Institution in Previous Semester		PIQ_DE_HEI_IND	NUMC	2
PREVSEM1_PRG_IND	Program of Study in Previous Semester		PIQ_DE_STUDY_IND	NUMC	2
STALA_65U2	Available for State Statistical Agency Use		PIQ_DE_LAC2	CHAR	4
FRGN1_COUNTRY	DUEVO: Nationality		DUSTA	CHAR	6	*
FRGN1_CNT_MONTHS	Number of Months		PIQ_NRMONTHS	NUMC	4
BLANK_84	Blank		PIQ_DE_BLANK1	CHAR	2
FRGN2_COUNTRY	DUEVO: Nationality		DUSTA	CHAR	6	*
FRGN2_CNT_MONTHS	Number of Months		PIQ_NRMONTHS	NUMC	4
BLANK_87	Blank		PIQ_DE_BLANK1	CHAR	2
BLANK_88	Blank		PIQ_DE_BLANK3	CHAR	6
BLANK_89	Blank		PIQ_DE_BLANK2	CHAR	4
BLANK_90	Blank		PIQ_DE_BLANK1	CHAR	2
UEQ_YEAR	Academic Year		PIQPERYR	NUMC	8	*
UEQ_TYPE	University Entrance Qualification		PIQ_DE_UEQ	CHAR	4	*
UEQ_REGIO	Region		PIQ_DE_REGIO	CHAR	4
UEQ_COUNTY	County Code		COUNC	CHAR	6	*
UEQ_COUNTRY	DUEVO: Nationality		DUSTA	CHAR	6	*
WORK_QUAL	Work Experience with Qualification		PIQ_DE_WORK_QUAL	CHAR	2
WORK_STUDY	Work Experience with Qualification for Current Study		PIQ_DE_WORK_STUDY	CHAR	2
BLANK_114	Blank		PIQ_DE_BLANK1	CHAR	2
BLANK_115	Blank		PIQ_DE_BLANK1	CHAR	2
BLANK_116	Blank		PIQ_DE_BLANK2	CHAR	4
BLANK_117	Blank		PIQ_DE_BLANK2	CHAR	4
BLANK_118	Blank		PIQ_DE_BLANK1	CHAR	2
BLANK_119	Blank		PIQ_DE_BLANK1	CHAR	2
BIRTH_DAY	Day		PIQ_DE_DAY	NUMC	4
STUDENT_NAME	First Name of Student		PIQ_DE_ST_NAME	CHAR	8
NATIONALITY_SECOND	DUEVO: Nationality		DUSTA	CHAR	6	*
STALA_16	Available for State Statistical Agency Use		PIQ_DE_LAC2	CHAR	4
FIRST_HEI_COUNTRY	Country/Region Code		PIQ_DE_COUNTRY	CHAR	6
INTERRUPT_TYPE	Type of Study Interruption		PIQ_DE_INTERRUPT_TYPE	CHAR	4	*
STALA_27	Available for State Statistical Agency Use		PIQ_DE_LAC3	CHAR	6
STALA_120	Available for State Statistical Agency Use		PIQ_DE_LAC3	CHAR	6
STALA_121	Available for State Statistical Agency Use		PIQ_DE_LAC2	CHAR	4
STALA_124	Available for State Statistical Agency Use		PIQ_DE_LAC3	CHAR	6
STALA_125	Available for State Statistical Agency Use		PIQ_DE_LAC3	CHAR	6
.INCLUDE				CI_SX_STATD	0
CORR_RUN_TMSTP	Correction Run Timestamp		PIQ_DE_RUNTS_CORR	DEC	8
ERROR	Error Occurred		PIQPROG_PROTOCOL_ERROR	CHAR	2