HRP1891 - DB Table for Infotype 1891

DB Table for Infotype 1891 information is stored in SAP table HRP1891.
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 HRP1891

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
.INCLUDE		X		HRIKEY	0
MANDT	Client	X	MANDT	CLNT	6	T000
PLVAR	Plan Version	X	PLVAR	CHAR	4	T778P
OTYPE	Object Type	X	OTYPE	CHAR	4	T778O
OBJID	Object ID	X	HROBJID	NUMC	16	PLOGI
SUBTY	Subtype	X	SUBTYP	CHAR	8	*
ISTAT	Planning Status	X	ISTAT_D	CHAR	2	T778S
BEGDA	Start Date	X	BEGDATUM	DATS	16
ENDDA	End Date	X	ENDDATUM	DATS	16
VARYF	Variation Field for File PLOG	X	VARYF	CHAR	20
SEQNR	Number of Infotype Record With Same Key	X	SEQNR	NUMC	6
INFTY	Infotype		INFOTYP	CHAR	8	T778T
OTJID	Concatenation of Object Type and Object ID		OTJID	CHAR	20
.INCLUDE				HRIADMIN	0
AEDTM	Changed on		AEDTM	DATS	16
UNAME	User Name		USRNAME	CHAR	24
REASN	Reason		REASN	CHAR	4
HISTO	Historical Record Flag		HISTO	CHAR	2
ITXNR	Text Module for Infotype		ITXNR	NUMC	16
.INCLUDE				HRI1891	0
SC_OBJID	Program ID		PIQSCOBJID	NUMC	16	*
ADM_AYEAR	Academic Year		PIQPERYR	NUMC	8	T7PIQYEAR
ADM_PERID	Academic Session		PIQPERID	NUMC	6	T7PIQPERIOD
BRINNUMBER	BRIN Number		PIQ_NL_BRINNUMBER	CHAR	8
BRINSEQUENCE	BRIN Sequence Number		PIQ_NL_BRINSEQUENCE	NUMC	4
LOCATION	Location		PIQ_NL_LOCATION	CHAR	48
ENROLLFORMCODE	Enrollment Form Code		PIQ_NL_ENROLLFORMCODE	CHAR	2	T7PIQ_NL_ENRFOM
ENROLLMOMENTCODE	Enrollment Moment Code		PIQ_NL_ENROLLMOMENTCODE	CHAR	24
FIRSTYEAR	First Year Check		PIQ_NL_FIRSTYEAR	CHAR	2
COMPREQSTATUS	Complementary Requirements Status		PIQ_NL_COMPREQSTATUS	CHAR	2	T7PIQ_NL_CMPREQ
ACTIVITIESSTATUS	Activity Status		PIQ_NL_ACTIVITIESSTATUS	CHAR	2	T7PIQ_NL_ACTY
LANGTEST	Language Test		PIQ_NL_LANGTEST	CHAR	2	T7PIQ_NL_LTEST
LOTTERYDRAW	Lottery Draw		PIQ_NL_LOTTERYDRAW	CHAR	2	T7PIQ_NL_LTDRW
LOTTERY	Lottery		PIQ_NL_LOTTERY	CHAR	2	T7PIQ_NL_LTRY
LOTTERYSEQUENCE	Lottery Sequence Number		PIQ_NL_LOTTERYSEQUENCE	NUMC	6
IBGSTATUS	IBG Status		PIQ_NL_IBGSTATUS	CHAR	2	T7PIQ_NL_IBGST
PLACEISSUEDATE	Placement Issue Date		PIQ_NL_PLACEISSUEDATE	DATS	16
LOTTERYRESULT	Lottery Results		PIQ_NL_LOTTERYRESULT	CHAR	2	T7PIQ_NL_LOTRES
REASONFORRESEVE	Reason for Reservation		PIQ_NL_REASON	CHAR	2	*
REASONFORREJECT	Reason for Rejection		PIQ_NL_REASONREJECT	CHAR	2	T7PIQ_NL_REJECT
REASONFORTERMIN	Reason for Termination		PIQ_NL_TERMINATION	CHAR	2	T7PIQ_NL_TMATE
INTERVIEW	Checkbox		PIQ_NL_CHECK	CHAR	2
MOTIVATION	Checkbox		PIQ_NL_CHECK	CHAR	2
EXPERIENCE	Checkbox		PIQ_NL_CHECK	CHAR	2
INTERNATIONALEXP	Checkbox		PIQ_NL_CHECK	CHAR	2
WORKEXP	Checkbox		PIQ_NL_CHECK	CHAR	2
OTHER	Checkbox		PIQ_NL_CHECK	CHAR	2
OTHERTEXT	Verifier Name		PIQ_NL_NAME	CHAR	70
DELAYEDENROLL	Indicator		PIQ_NL_INDICATE	CHAR	2
ENROLLHIGHYEAR	Checkbox		PIQ_NL_CHECK	CHAR	2
DEFRAYMENTCODE	Checkbox		PIQ_NL_CHECK	CHAR	2
DEFICIENCYSTATUS	Deficiency status		PIQ_NL_DEFICIENCYSTATUS	CHAR	2	T7PIQ_NL_DFCY
REQFORRESTIT	Request for Restitution		PIQ_NL_REASONRESTITUTE	CHAR	2
FULLTPARTT	Form of Education Code		PIQ_NL_FULLTPARTT	CHAR	2
ENRSTARTDATE	Date		PIQ_NL_DATE	DATS	16
EDUPHASECODE	Education Phase Code		PIQ_NL_EDUPHASECODE	CHAR	2	T7PIQ_NL_EDUPHA
FIRSTYEARACC	Indicator		PIQ_NL_INDICATE	CHAR	2
UNENDESDATE	Date		PIQ_NL_DATE	DATS	16
MSG34SENT	Checkbox		PIQ_NL_CHECK	CHAR	2
REQUESTGRANTED	Request Granted for Deregistration		PIQ_NL_REQUESTGRANTED	CHAR	2
ADM_GUID	Unique Key (GUID) of the Admission		PIQADM_GUID	CHAR	64
DEREG_DECDATE	Decision Date		PIQ_NL_DECDATE	DATS	16
REGNUM	Studielink Registration Sequence Number		PIQ_NL_DUO_REGIST_NUM	CHAR	40
REGNUM_OLD	Registration Number		PIQ_NL_REGNUMBER	CHAR	40
STUDYCHOICE_IND	Participation Study Choice Activities		PIQ_NL_STUDYCHOICE_IND	CHAR	2
APPL_DEADLINE	Study choice activities application deadline		PIQ_NL_STUDYCHOICE_APPL_IND	CHAR	2
FAPPL_DATE	First Application Date		PIQ_NL_FIRSTAPPL_DATE	DATS	16
REGNUM_DUO	Duo Registration Sequence Number		PIQ_NL_DUO_REGNUMBER	CHAR	40
STUDY_SWITCH	Study Switch Indicator		PIQ_NL_STUDY_SWITCH	CHAR	2
WLIST_IND	Waiting List Indicator		PIQ_NL_WLIST_INDICATOR	CHAR	2
WSTATUS	Status in the Waiting List		PIQ_NL_WLIST_STATUS	CHAR	4	T7PIQ_NL_WSTATUS
TABNR	Reference Number to Table Part		HRTABNR	CHAR	64	HRITABNR