PIQDBAD_SP_H - Admission: Study Package Header

Admission: Study Package Header information is stored in SAP table PIQDBAD_SP_H.
It is part of development package PMIQ_AD_BACK in software component IS-HER-CM. This development package consists of objects that can be grouped under "Admission Decision Back-end Core".

Fields for table PIQDBAD_SP_H

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
.INCLUDE	KEY	X		PIQAD_OBJ_KEY_C	0
MANDT	Client	X	MANDT	CLNT	6	*
.INCLUDE	OBJ_KEY	X		PIQAD_OBJ_KEY	0
OBJECT_ID	Admission Object ID	X	PIQAD_OBJECT_ID	NUMC	32
VERSION	Admission: Version	X	PIQAD_VERSION	NUMC	12
.INCLUDE	ADMIN			PIQAD_ADMIN_INFO	0
.INCLUDE				PIQAD_EDIT_INFO	0
CREATED_AT	Created At (Output in User Time Zone)		COMT_CREATED_AT_USR	DEC	8
CREATED_BY	User that Created the Transaction		CRMT_CREATED_BY	CHAR	24
CHANGED_AT	Changed At (Output in User Time Zone)		COMT_CHANGED_AT_USR	DEC	8
CHANGED_BY	Transaction Last Changed By		CRMT_CHANGED_BY	CHAR	24
.INCLUDE	PARENT			PIQAD_OBJ_PARENT	0
PARENT_TYPE	Decision: Object Category		PIQAD_OBJECT_TYPE	CHAR	6	*
PARENT_ID	Admission Object ID		PIQAD_OBJECT_ID	NUMC	32
.INCLUDE	HEADER			PIQAD_OBJ_HEADER	0
HEADER_TYPE	Decision: Object Category		PIQAD_OBJECT_TYPE	CHAR	6	*
HEADER_ID	Admission Object ID		PIQAD_OBJECT_ID	NUMC	32
STATE	Admission: Version State		PIQAD_STATE	CHAR	2
DEL	Admission: Deletion Indicator		PIQAD_DELETED	CHAR	2
OBJNR	Object number		J_OBJNR	CHAR	44	*
.INCLUDE	DATA			PIQAD_SPH_DATA	0
OBJECT_SUB_TYPE	Admission: Study Package Header Type		PIQAD_SPH_TYPE	CHAR	8
CAP_NORM	Admission: Normal Capacity		PIQAD_CAP_NORM	DEC	4
CAP_OVER	Admission: Overbooking Capacity		PIQAD_CAP_OVER	DEC	4
CAP_TOTL	Admission: Total Capacity		PIQAD_CAP_TOTL	DEC	5
ALLOC_SCHEME	Allocation Scheme ID		PIQAD_SCHEM_ID	CHAR	16	*
GROUP_ID	Study Package Group ID		PIQAD_SPGRP_ID	CHAR	16	*
COURSE_OFFER_TYPE	Studienangebotstyp		PIQAD_S0_TYPE	CHAR	8	*