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
MANDTClientXMANDTCLNT6*
STUDENTStudent NumberXPIQSTUDENT12CHAR24
CRIMESSAGECRIHO Messgae NumberXPIQ_NL_CRIMESSAGECHAR10
CRIMSGDATECRIHO Message Entry DateXPIQ_NL_CRIMSGDATEDATS16
SEQNRNumber of Infotype Record With Same KeyXSEQNRNUMC6
EDUCATIONCODEEducation CodeXPIQ_NL_EDUCATIONCODENUMC10T7PIQ_NL_EDUC
STUDYYEARAcademic YearPIQPERYRNUMC8T7PIQYEAR
STUDYSESSAcademic SessionPIQPERIDNUMC6T7PIQPERIOD
OCWNUMBERIdentification Number for Business PartnerBP_IDNUMCHAR120
FORMREGEnrollment Form CodePIQ_NL_ENROLLFORMCODECHAR2T7PIQ_NL_ENRFOM
REGDATEActivity Key Date for Sessional RegistrationPIQREGPERDATEDATS16
BRINNUMBERBRIN NumberPIQ_NL_BRINNUMBERCHAR8
EDUCATIONPHASEEducation Phase CodePIQ_NL_EDUPHASECODECHAR2T7PIQ_NL_EDUPHA
FORMOFEDUCATIONForm of Education CodePIQ_NL_FULLTPARTTCHAR2
FIRST_YEARFirst YearPIQ_NL_FIRSTYRNUMC8*
MONTH_FRMMonthPIQ_NL_MONTHNUMC4
MONTH_TOMonthPIQ_NL_MONTHNUMC4
DEFRAYCODECRIHO Defrayment CodePIQ_NL_CRIDEFRAYMENTCHAR2
GENDER_KEYGender of StudentPIQ_NL_GENDERCHAR2
TERMINATEREASONReason for TerminationPIQ_NL_TERMINATIONCHAR2T7PIQ_NL_TMATE
TERMINATEDATEActivity Key Date of De-registrationPIQDERDATEDATS16
ERDATEExam Result DatePIQ_NL_ERDATEDATS16
ERCODEExam Result CodePIQ_NL_ERCODECHAR2T7PIQ_NL_ERCD
STUDYPROGRESSCODStudy Progress CodePIQ_NL_PROGRESSCODECHAR2
PREEDUCATIONPrevious Education CodePIQ_NL_PREEDUCATIONNUMC10
PREEDUCATIONYEARGraduation YearPIQ_NL_GRADYEARNUMC8
PROCESSCODECRIHO Processing CodesPIQ_NL_PROCESSCODENUMC2T7PIQ_NL_CRIPC
CRIMSGSENTDATECRIHO Message Sent DatePIQ_NL_CRIMSG_SENTDATEDATS16
CRIIBGDATECRIHO Message Entry DatePIQ_NL_CRIMSGDATEDATS16
SIGNALCODE1CRIHO Signal CodesPIQ_NL_CRISIGNALCODECHAR6T7PIQ_NL_CRISC
SIGNALCODE2CRIHO Signal CodesPIQ_NL_CRISIGNALCODECHAR6T7PIQ_NL_CRISC
SIGNALCODE3CRIHO Signal CodesPIQ_NL_CRISIGNALCODECHAR6T7PIQ_NL_CRISC
SIGNALCODE4CRIHO Signal CodesPIQ_NL_CRISIGNALCODECHAR6*
ADDRINDCRIHO Address Send IndicatorPIQ_NL_ADDRINDCHAR2
GRADIDGraduation Identification (ID)PIQGRADIDCHAR64
EDUCATIONPGMProgram IDPIQSCOBJIDNUMC16*
USNAMUser NameUSNAMCHAR24*
CPUDTDay On Which Accounting Document Was EnteredCPUDTDATS16
CPUTMTime of EntryCPUTMTIMS12
FILENAMEFilenamePIQ_NL_FILENAMECHAR34
Privacy Policy