T7PIQ_NL_INSTIT - Institutes and Education Details

Institutes and Education Details information is stored in SAP table T7PIQ_NL_INSTIT.
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 T7PIQ_NL_INSTIT

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	*
BRINNUMBER	BRIN Number	X	PIQ_NL_BRINNUMBER	CHAR	8
TRAIT	Trait	X	PIQ_NL_TRAIT	NUMC	2
BEGINDATE	Start Date	X	BEGDA	DATS	16
CHANGEDATE	Last Changed On	X	CHANGDATE	DATS	16
BRINSEQUENCE	BRIN Sequence Number	X	PIQ_NL_BRINSEQUENCE	NUMC	4
ENDDATE	End Date	X	ENDDA	DATS	16
INSTNAMELONG	Institute Name		PIQ_NL_INSTITUTENAME	CHAR	140
INSTNAMESHORT	Name of the Supplying Instituition		PIQ_NL_BRINSHORT	CHAR	70
DEFRAYMENTCODE	Defrayment Code		PIQ_NL_DEFRAYMENT	NUMC	2
STREET1	Street		AD_STREET	CHAR	120
HOUSENUMBER1	House Number		AD_HSNM1	CHAR	20
HOUSENUMREF1	House number supplement		AD_HSNM2	CHAR	20
LOCATIONREF1	Street 5		AD_LCTN	CHAR	80
POSTCODE1	City postal code		AD_PSTCD1	CHAR	20
CITY1	City		AD_CITY1	CHAR	80
STREET2	Street		AD_STREET	CHAR	120
HOUSENUMBER2	House Number		AD_HSNM1	CHAR	20
HOUSENUMREF2	House number supplement		AD_HSNM2	CHAR	20
LOCATIONREF2	Street 5		AD_LCTN	CHAR	80
POSTCODE2	City postal code		AD_PSTCD1	CHAR	20
CITY2	City		AD_CITY1	CHAR	80
MUNICIPALITY	City		AD_CITY1	CHAR	80
PHONE	Telephone no.: dialling code+number		AD_TLNMBR	CHAR	60
FAX	Fax number: dialling code+number		AD_FXNMBR	CHAR	60
EMAIL	E-Mail Address		AD_SMTPADR	CHAR	482
WEB	E-Mail Address		AD_SMTPADR	CHAR	482