PIQDB_DE_DRSTATD - Doctoral Student Statistics Detail Table

Doctoral Student Statistics Detail Table information is stored in SAP table PIQDB_DE_DRSTATD.
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_DRSTATD

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
CS_OBJID_RD1	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
CORR_RUN_TMSTP	Correction Run Timestamp		PIQ_DE_RUNTS_CORR	DEC	8
.INCLUDE	STAT_DATA			PIQ_DE_DR_STAT_DB	0
REP_REGIO	Reporting Region		PIQ_DE_REP_REGIO	CHAR	4
REP_YEAR	Statistical Reporting Year		PIQ_DE_PERYR	NUMC	8
REP_HEI	Higher Education Institution		PIQ_DE_HEI	CHAR	8	*
RECNUM	Record Number		PIQ_DE_RECNUM	NUMC	12
GENDER_KEY	Gender key		AD_SEX	CHAR	2	TSAD15
BIRTH_DAY	Day		PIQ_DE_DAY	NUMC	4
BIRTH_MONTH	Month		PIQ_DE_MONTH	NUMC	4
BIRTH_YEAR	Year		PIQ_DE_YEAR	NUMC	8
STUDENT_NAME	First Name of Student		PIQ_DE_ST_NAME	CHAR	8
NATIONALITY	DUEVO: Nationality		DUSTA	CHAR	6	*
NATIONALITY_SECOND	DUEVO: Nationality		DUSTA	CHAR	6	*
PHD_PROG_TYPE	Post Graduate Doctoral Study Type		PIQ_DE_PHD_PROG_TYPE	CHAR	4	*
PHD_SUBJECT1	Subject Code 1		PIQ_DE_SUBCODE1	CHAR	6	*
PHD_REGTYPE	Doctoral Registration Category		PIQ_DE_DR_REGTYPE	CHAR	2
PHD_BEG_MONTH	Month		PIQ_DE_MONTH	NUMC	4
PHD_BEG_YEAR	Year		PIQ_DE_YEAR	NUMC	8
PHD_END_MONTH	Month		PIQ_DE_MONTH	NUMC	4
PHD_END_YEAR	Year		PIQ_DE_YEAR	NUMC	8
ACTIVE_REGIST_IND	Indicates active registration to doctoral programs		PIQ_DE_DR_REGIST_IND	CHAR	2
STRUC_PROGRAM_IND	Indicates that a program of study is structured		PIQ_DE_DR_STRUC_PROG_IND	CHAR	2
EMPLOYEE_IND	Indicates Student is as employee in the University		PIQ_DE_EMPLOYEE_IND	CHAR	2
THESIS_TYPE	Type of Doctoral Thesis		PIQ_DE_DR_THESIS_TYPE	CHAR	2
FIRST_HEI	First Higher Education Institute		PIQ_DE_HEI_FIRST	CHAR	8	*
FIRST_HEI_COUNTRY	Country/Region Code		PIQ_DE_COUNTRY	CHAR	6
FIRST_PERID	First Registration Period		PIQ_DE_PERID_FIRST	NUMC	2
FIRST_YEAR	First Academic Year		PIQ_DE_PERYR_FIRST	NUMC	8	*
QUAL_EXAM_RESULT	Result of the Qualifying Exam for Doctoral Studies		PIQ_DE_DR_QUAL_RESULT	CHAR	2
QUAL_EXAM_HEI	Higher Education Institution		PIQ_DE_HEI	CHAR	8	*
QUAL_EXAM_COUNTRY	Country/Region Code		PIQ_DE_COUNTRY	CHAR	6
QUAL_EXAM_TGT_DEGREE	Target Degree		PIQ_DE_TGT_DEGREE	CHAR	6
QUAL_EXAM_SUBJECT1	Subject Code 1		PIQ_DE_SUBCODE1	CHAR	6	*
QUAL_EXAM_MONTH	Month of Graduation Exam		PIQ_DE_GRAD_MONTH	NUMC	4
QUAL_EXAM_YEAR	Year of Graduation Exam		PIQ_DE_GRAD_YEAR	NUMC	8
QUAL_EXAM_GRADE	Total Grade		PIQ_DE_GRADE_TOTAL	CHAR	2
UEQ_YEAR	Academic Year		PIQPERYR	NUMC	8	*
UEQ_TYPE	University Entrance Qualification		PIQ_DE_UEQ	CHAR	4	*
UEQ_REGIO	Region of University Entrance Qualification		PIQ_DE_UEQ_REGION1	NUMC	4
UEQ_COUNTY	County Code		COUNC	CHAR	6	*
UEQ_COUNTRY	DUEVO: Nationality		DUSTA	CHAR	6	*
STALA_34	Available for State Statistical Agency Use		PIQ_DE_LAC3	CHAR	6
STALA_35	Available for State Statistical Agency Use		PIQ_DE_LAC3	CHAR	6
STALA_36	Available for State Statistical Agency Use		PIQ_DE_LAC3	CHAR	6
STALA_37	Available for State Statistical Agency Use		PIQ_DE_LAC3	CHAR	6
STALA_38	Available for State Statistical Agency Use		PIQ_DE_LAC3	CHAR	6
.INCLUDE				CI_DR_STATD	0