PIQDBAD_I - Admission: Decision Item

Admission: Decision Item information is stored in SAP table PIQDBAD_I.
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_I

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_ADI_DATA	0
OBJECT_SUB_TYPE	Admission: Decision Item Type		PIQAD_ADI_TYPE	CHAR	8	*
.INCLU-REF	REF			PIQAD_ADI_REF	0
.INCLUDE	REF_OBJREF			PIQAD_ADI_REF_HR	0
OTYPEREF	Object Type		OTYPE	CHAR	4	*
OBJIDREF	Object ID		HROBJID	NUMC	16	*
.INCLUDE				CI_ADI_REF	0
.INCLUDE				PIQAD_ADI_REF_N	0
STUDENT_OBJECTIDREF	Object ID of Student		PIQSTUDENT	NUMC	16	*
STUDY_OBJECTIDREF	Object ID of Study Object (CS)		PIQCSOBJID	NUMC	16	*
PROGRAM_OBJECTIDREF	Program ID		PIQSCOBJID	NUMC	16	*
BEGDAREF	Start Date		BEGDA	DATS	16
ENDDAREF	End Date		ENDDA	DATS	16
STUDY_PRIORITYREF	Program Priority (In Period)		PIQCSPRIOX	CHAR	4
ACAD_YEARREF	Academic Year		PIQPERYR	NUMC	8	*
ACAD_SESSIONREF	Academic Session		PIQPERID	NUMC	6	*
STAGEREF	Stage		PIQLEVEL	NUMC	4	*
REGIST_DATEREF	Activity Key Date for Sessional Registration		PIQREGPERDATE	DATS	16
PARTTIMEREF	Indicator: Part-Time Study		PIQPARTT	CHAR	2
LEAVE_REASONREF	Leave of Absence Reason		PIQLEAREASON	NUMC	8	*
COMPL_LENGTH_STUDYREF	Completed Length of Study		PIQPERCT	NUMC	6
REGIST_TYPEREF	Registration Type		PIQENRCATEG	CHAR	4	*
DEGREE_SEEKINGREF	Degree Seeking (Indicator)		PIQDEGREE_SEEK	CHAR	2
REGIST_STATUSREF	Sessional Registration Status		PIQREG_PERIODSTATUS	CHAR	2
REGIST_STATEREF	Sessional Registration Status Specification		PIQREG_PRS_STATE	CHAR	2
REGIST_CLASSREF	Registration Classification		PIQREGCLASS	CHAR	4	*
ADM_GUIDREF	Unique Key (GUID) of the Admission		PIQADM_GUID	CHAR	64
UNIVERSITYSEMREF	Number of Semesters at German Universities		PIQ_DE_SESSCNT_UNIV	DEC	3
LEAVEOFABSSEMREF	Semesters with Leaves of Absence at German Universities		PIQ_DE_SESSCNT_LOA	DEC	3
INTERNSHIPSEMREF	Number of Internship Semesters at Higher Education Institute		PIQ_DE_SESSCNT_INTERN	DEC	3
CG_OBJID1REF	Module Group ID		PIQCGOBJID	NUMC	16	*
SUBJECTSEMREF	Subject Semesters		PIQ_DE_SESSCNT_SUBJ	DEC	3
TARGET_DEGREEREF	Target Degree		PIQ_DE_TGT_DEGREE	CHAR	6
STUDYTYPEREF	Study Type		PIQ_DE_STUDYTYP	NUMC	2
FULLPARTDUALREF	Full Time/Part Time/Dual Study		PIQ_DE_FULLPART	NUMC	2
INTERRUPTSEMREF	Interrupted Semesters		PIQ_DE_SESSCNT_INTRUPT	DEC	3
PARTTYPEREF	Part-Time Study Type		PIQ_DE_PARTTYPE	CHAR	8	*
PARTREASONREF	Part-Time Study Reason		PIQ_DE_PARTREASON	NUMC	8	*
SC_SHORTREF	Program (Abbreviation)		PIQSCSHORT	CHAR	24
SC_STEXTREF	Program Description		PIQSCTXT	CHAR	80
CG_SHORTREF	Module Group (Abbreviation)		PIQCGSHORT	CHAR	24
CG_STEXTREF	Module Group (Description)		PIQCGSTEXT	CHAR	80
REQUEST_REASONREF	Part-Time Study Reason		PIQ_DE_PARTREASON	NUMC	8	*