PIQDB_NL_DUOTUI - DUO Tuition Fee Details

DUO Tuition Fee Details information is stored in SAP table PIQDB_NL_DUOTUI.
It is part of development package PMIQ_NL_BRONHO in software component IS-HER-CM-NL. This development package consists of objects that can be grouped under "SLcM Netherlands - BRONHO".

Fields for table PIQDB_NL_DUOTUI

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
REG_NUM	Academic Year and Session	X	PIQ_NL_DUO_YEAR_PERID	CHAR	40
EDU_CODE	Education Code	X	PIQ_NL_EDUCATIONCODE	NUMC	10	T7PIQ_NL_EDUC
SEQNR	Sequence Number	X	PIQ_NL_SEQNR	NUMC	6
STNUM	Student Number	X	PIQSTUDENT12	CHAR	24
CITS_NUM	Citizen Service Number		PIQ_NL_DUO_CITSNUM	CHAR	18
EDU_NUM	Education Number		PIQ_NL_DUO_EDUNUM	CHAR	18
BRIN_NUM	BRIN Number		PIQ_NL_BRINNUMBER	CHAR	8
EDU_FORM	Form of Education		PIQ_NL_DUO_FORM_EDUC	CHAR	4
REG_DATE	Date Registration		PIQ_NL_DUO_REGIST_DATE	DATS	16
DATE_DETRM	Date Determination		PIQ_NL_DATE_DETERMIN	DATS	16
TUFTOT_IND	Indicate Total Tuitionfee		PIQ_NL_DUO_TOTALTUFEE_IND	CHAR	2
.INCLUDE				PIQ_NL_DUO_DECTYPE_TUIFEE	0
TUIFEE_TYPE	Tuition Fee Type		PIQ_NL_DUO_TUIFEE_TYPE	CHAR	2
IS_GRADE_HE	Indication grade higher education		PIQ_NL_DUO_IS_GRADE_HE	CHAR	2
IS_GRADE_HOE	Indication grade higher education health or education		PIQ_NL_DUO_IS_GRADE_HOE	CHAR	2
IS_GRADE_MAST	Indication grade master		PIQ_NL_DUO_IS_GRADE_MAST	CHAR	2
IS_GRADE_MAST_HOE	Indication grade master health or education		PIQ_NL_DUO_IS_GRADE_MAST_HOE	CHAR	2
IS_FUNC_LIMIT_RIGHT_USED	Indication functional limitation right to be used		PIQ_NL_DUO_IS_FUNC_LIMITATION	CHAR	2
NO_STUDY_YEAR	Number of study years higher education		PIQ_NL_DUO_NUM_STUDY_YEARS_HE	NUMC	4
NO_STUDY_YEAR_HOE	Number of study years higher education health or education		PIQ_NL_DUO_NUM_STUDY_YEARS_HOE	NUMC	4
NO_STUDY_YEAR_MAST	Number of study years master		PIQ_NL_DUO_NUM_STUDY_MAST	NUMC	4
NO_STUDY_YEAR_MAST_HOE	Number of Study Years Master Health or Education		PIQ_NL_DUO_NUM_STUDY_MAST_HOE	NUMC	4
NO_STAT_FEE_MON	Number of months lowered statuatory fees applies		PIQ_NL_DUO_NUM_STAT_FEE_MON	NUMC	4
.INCLUDE				PIQ_NL_DUO_RESIDENCE	0
IS_RES	Indication residence requirement		PIQ_NL_DUO_IS_RESIDENCE_REQ	CHAR	2
STATE_CODE	State code (German)		PIQ_NL_DUO_STATE_CODE	NUMC	4	*
.INCLUDE				PIQ_NL_DUO_NATIONALITY	0
IS_NATIONAL	Indication nationality requirement		PIQ_NL_DUO_IS_NATIONALITY_REQ	CHAR	2
.INCLUDE				PIQ_NL_DUO_FUNC_LIMIT	0
ALLOTMENT_DATE	Date allotment functional limitation		PIQ_NL_DUO_ALLOT_DATE	DATS	16
.INCLUDE				PIQ_NL_DUO_QUER_EDUPGM	0
IS_REG_HOE_Q	Indication registration health or education		PIQ_NL_DUO_IS_REG_HOE	CHAR	2
IS_REG_BOM_Q	Indication registration bachelor or master		PIQ_NL_DUO_IS_REG_BOM	CHAR	2
.INCLUDE				PIQ_NL_DUO_EDU_PROG_QUERY	0
EDU_CODE_Q	Education Code		PIQ_NL_EDUCATIONCODE	NUMC	10
EDU_NAME_SHORT_Q	Name educational program (short)		PIQ_NL_DUO_EDUNAMESHORT	CHAR	80
EDU_NAME_LONG_Q	Education Name		PIQ_NL_EDUNAMELONG	CHAR	450
EDU_LEVEL_Q	Educational level		PIQ_NL_DUO_EDU_LEVEL	CHAR	14
CODE_DEFRAYMENT_Q	Code defrayment		PIQ_NL_DUO_CODE_DEFRAYMENT	CHAR	28
DUR_DEFRAYMENT_Q	Defrayment duration		PIQ_NL_DUO_DUR_DEFRAYMENT	NUMC	4
EDU_SECTION_Q	Educational section		PIQ_NL_DUO_EDU_SECTION	CHAR	80
EDU_FORM_Q	Form of Education		PIQ_NL_DUO_FORM_EDUC	CHAR	4
TABNR	Reference Number to Table Part		HRTABNR	CHAR	64
REGNUM	Studielink Registration Sequence Number		PIQ_NL_DUO_REGIST_NUM	CHAR	40
TOTAL_LSF_MON	Total Number of Months for Lowered Statuatory Fees		PIQ_NL_DUO_TOTAL_LSF_MON	NUMC	4