PIQDB_NL_CRIHO - CRIHO Changes

CRIHO Changes information is stored in SAP table PIQDB_NL_CRIHO.
It is part of development package PMIQ_NL in software component IS-HER-CM-NL. This development package consists of objects that can be grouped under "Student Lifecycle Management - Netherlands".

Fields for table PIQDB_NL_CRIHO

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	*
STUDENT	Student Number	X	PIQSTUDENT12	CHAR	24
CRIMESSAGE	CRIHO Messgae Number	X	PIQ_NL_CRIMESSAGE	CHAR	10
CRIMSGDATE	CRIHO Message Entry Date	X	PIQ_NL_CRIMSGDATE	DATS	16
SEQNR	Number of Infotype Record With Same Key	X	SEQNR	NUMC	6
EDUCATIONCODE	Education Code	X	PIQ_NL_EDUCATIONCODE	NUMC	10	T7PIQ_NL_EDUC
STUDYYEAR	Academic Year		PIQPERYR	NUMC	8	T7PIQYEAR
STUDYSESS	Academic Session		PIQPERID	NUMC	6	T7PIQPERIOD
OCWNUMBER	Identification Number for Business Partner		BP_IDNUM	CHAR	120
FORMREG	Enrollment Form Code		PIQ_NL_ENROLLFORMCODE	CHAR	2	T7PIQ_NL_ENRFOM
REGDATE	Activity Key Date for Sessional Registration		PIQREGPERDATE	DATS	16
BRINNUMBER	BRIN Number		PIQ_NL_BRINNUMBER	CHAR	8
EDUCATIONPHASE	Education Phase Code		PIQ_NL_EDUPHASECODE	CHAR	2	T7PIQ_NL_EDUPHA
FORMOFEDUCATION	Form of Education Code		PIQ_NL_FULLTPARTT	CHAR	2
FIRST_YEAR	First Year		PIQ_NL_FIRSTYR	NUMC	8	*
MONTH_FRM	Month		PIQ_NL_MONTH	NUMC	4
MONTH_TO	Month		PIQ_NL_MONTH	NUMC	4
DEFRAYCODE	CRIHO Defrayment Code		PIQ_NL_CRIDEFRAYMENT	CHAR	2
GENDER_KEY	Gender of Student		PIQ_NL_GENDER	CHAR	2
TERMINATEREASON	Reason for Termination		PIQ_NL_TERMINATION	CHAR	2	T7PIQ_NL_TMATE
TERMINATEDATE	Activity Key Date of De-registration		PIQDERDATE	DATS	16
ERDATE	Exam Result Date		PIQ_NL_ERDATE	DATS	16
ERCODE	Exam Result Code		PIQ_NL_ERCODE	CHAR	2	T7PIQ_NL_ERCD
STUDYPROGRESSCOD	Study Progress Code		PIQ_NL_PROGRESSCODE	CHAR	2
PREEDUCATION	Previous Education Code		PIQ_NL_PREEDUCATION	NUMC	10
PREEDUCATIONYEAR	Graduation Year		PIQ_NL_GRADYEAR	NUMC	8
PROCESSCODE	CRIHO Processing Codes		PIQ_NL_PROCESSCODE	NUMC	2	T7PIQ_NL_CRIPC
CRIMSGSENTDATE	CRIHO Message Sent Date		PIQ_NL_CRIMSG_SENTDATE	DATS	16
CRIIBGDATE	CRIHO Message Entry Date		PIQ_NL_CRIMSGDATE	DATS	16
SIGNALCODE1	CRIHO Signal Codes		PIQ_NL_CRISIGNALCODE	CHAR	6	T7PIQ_NL_CRISC
SIGNALCODE2	CRIHO Signal Codes		PIQ_NL_CRISIGNALCODE	CHAR	6	T7PIQ_NL_CRISC
SIGNALCODE3	CRIHO Signal Codes		PIQ_NL_CRISIGNALCODE	CHAR	6	T7PIQ_NL_CRISC
SIGNALCODE4	CRIHO Signal Codes		PIQ_NL_CRISIGNALCODE	CHAR	6	*
ADDRIND	CRIHO Address Send Indicator		PIQ_NL_ADDRIND	CHAR	2
GRADID	Graduation Identification (ID)		PIQGRADID	CHAR	64
EDUCATIONPGM	Program ID		PIQSCOBJID	NUMC	16	*
USNAM	User Name		USNAM	CHAR	24	*
CPUDT	Day On Which Accounting Document Was Entered		CPUDT	DATS	16
CPUTM	Time of Entry		CPUTM	TIMS	12
FILENAME	Filename		PIQ_NL_FILENAME	CHAR	34