HRP1718 - DB Table for Infotype 1718

DB Table for Infotype 1718 information is stored in SAP table HRP1718.
It is part of development package PMIQ in software component IS-HER-CM-AD. This development package consists of objects that can be grouped under "Campus Management".

Fields for table HRP1718

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				HRI1718	0
ARBGB	Name of Employer or Company		PIQPE_EMPLOYER	CHAR	40
ORT01	Location of Employer or Company		PIQPE_ORT01	CHAR	50
LAND1	Country/Region Key		LAND1	CHAR	6	T005
BRANC	Industry key		BRSCH	CHAR	8	T016
TAETE	Present or Previous Job		PIQPE_ACTIVITY	NUMC	16	T513C
TAETEBSCHR	Job (Description)		PIQPE_ACTIVITYDESC	CHAR	240
ANSVX	Work Contract Concluded With Employer		PIQPE_EMPLOYTYPE	CHAR	4	T542C
INST_PARTNER	Offering Institution		PIQINST_BUPA	CHAR	20	BUT000
CONTACT_PARTNER	Internship Contact Person		PIQISH_CONTACT	CHAR	20	BUT000
ACAD_YEAR	Academic Year		PIQPERYR	NUMC	8	T7PIQYEAR
ACAD_SESSION	Academic Session		PIQPERID	NUMC	6	T7PIQPERIOD
ISHREG_ID	Internship Registration ID		PIQISHREG_ID	CHAR	64
START_DATE	Internship Begin Date		PIQISH_BEGDA	DATS	16
END_DATE	Internship End Date		PIQISH_ENDDA	DATS	16
TEXT	Internship Registration (Description)		PIQISH_TEXT	CHAR	120
STATUS	Internship Registration Status		PIQISH_STATUS	CHAR	8	T7PIQISHSTATUS
CATEGORY1	Internship Category 1		PIQISH_CAT1	CHAR	12	T7PIQISHCAT1
CATEGORY2	Internship Category 2		PIQISH_CAT2	CHAR	12	T7PIQISHCAT2
CATEGORY3	Internship Category 3		PIQISH_CAT3	CHAR	12	T7PIQISHCAT3
CATEGORY4	Internship Category 4		PIQISH_CAT4	CHAR	12	T7PIQISHCAT4
CATEGORY5	Internship Category 5		PIQISH_CAT5	CHAR	12	T7PIQISHCAT5
ATTRIBUTE1	Internship Attribute 1		PIQISH_ATTR1	CHAR	80
ATTRIBUTE2	Internship Attribute 2		PIQISH_ATTR2	CHAR	80
ATTRIBUTE3	Internship Attribute 3		PIQISH_ATTR3	CHAR	80
ATTRIBUTE4	Internship Attribute 4		PIQISH_ATTR4	CHAR	80
ATTRIBUTE5	Internship Attribute 5		PIQISH_ATTR5	CHAR	80
GUIDTYPE	Unique Identification Type (GUID)		PIQCMPR_GUIDTYPE	CHAR	8	*
GUID	Unique Key (ID)		PIQCMPR_GUIDREF	CHAR	64
SC_OBJID	Program ID		PIQSCOBJID	NUMC	16	*
ACLEVEL	Stage		PIQLEVEL	NUMC	4	*
REF_OTYPE	Object Type		OTYPE	CHAR	4	*
REF_OBJID	Object ID		HROBJID	NUMC	16	*
NOTE_GUID	GUID - Unique Note Identifier		PIQNOTE_GUID	CHAR	64
DURATION	Internship Duration		PIQISH_DURATION	NUMC	6
UNIT	Internship Duration Unit		PIQISH_UNIT	CHAR	2
FULLPART_IND	UCAS: Full-Time Indicator		PIQ_GB_UCAS_FULLPART_TIME	CHAR	2
.INCLUDE	CI_P1718			CI_P1718	0